Results 1 to 5 of 5

Thread: MySQL error

  1. #1

    MySQL error

    My shared cPanel server is getting the following error in the /var/lib/mysql/server.err file:

    150103 8:15:59 InnoDB: ERROR: the age of the last checkpoint is 9438869,
    InnoDB: which exceeds the log group capacity 9433498.
    InnoDB: If you are using big BLOB or TEXT rows, you must set the
    InnoDB: combined size of log files at least 10 times bigger than the
    InnoDB: largest such row.

    Any ideas what is causing this?

  2. #2
    Join Date
    Dec 2005
    Posts
    3,110
    You need to probably need to increase the size of innodb_log_file_size

    To check your current InnoDB log stats you can run the below from the mysql CLI:

    Code:
    SHOW GLOBAL VARIABLES LIKE 'innodb_log%';

  3. #3
    Quote Originally Posted by PCS-Chris View Post
    You need to probably need to increase the size of innodb_log_file_size

    To check your current InnoDB log stats you can run the below from the mysql CLI:

    Code:
    SHOW GLOBAL VARIABLES LIKE 'innodb_log%';
    This is the output:

    Code:
    mysql> SHOW GLOBAL VARIABLES LIKE 'innodb_log%';
    +---------------------------+---------+
    | Variable_name             | Value   |
    +---------------------------+---------+
    | innodb_log_buffer_size    | 8388608 |
    | innodb_log_file_size      | 5242880 |
    | innodb_log_files_in_group | 2       |
    | innodb_log_group_home_dir | ./      |
    +---------------------------+---------+
    4 rows in set (0.00 sec)

  4. #4
    Anyone any ideas?

  5. #5
    Hi,

    You have to increase the log file size from the default, like the one below. Add it in the my.cnf and restart MySQL.

    innodb_log_file_size = 128M (analyze and check the size first)

    Important: Make sure everything is backed up properly and dont forget to backup "ib_logfile*" too.
    www.24x7servermanagement.com
    Server Management, Server Security, Server Monitoring.
    India's Leading Managed Service Provider !! Skype: techs24x7

Similar Threads

  1. MySQL Error : Got error -1 from storage engine Error Number : 1030
    By Linkdatacenter in forum Programming Discussion
    Replies: 2
    Last Post: 05-25-2008, 04:16 AM
  2. Installed MySQL in /usr/local/mysql but error in /var/lib/mysql
    By guest3 in forum Hosting Security and Technology
    Replies: 1
    Last Post: 01-21-2007, 06:38 PM
  3. Replies: 5
    Last Post: 05-11-2004, 12:24 AM
  4. Replies: 14
    Last Post: 11-20-2003, 12:57 PM
  5. ticketsmith mysql error --> Got an error reading communication packets
    By Domenico in forum Hosting Security and Technology
    Replies: 3
    Last Post: 11-06-2002, 08:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •