Results 1 to 5 of 5
Thread: MySQL error
-
01-15-2015, 04:03 PM #1Disabled
- Join Date
- Jan 2011
- Posts
- 674
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?
-
01-15-2015, 06:55 PM #2Web Hosting Master
- 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%';
-
01-15-2015, 06:57 PM #3Disabled
- Join Date
- Jan 2011
- Posts
- 674
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)
-
01-17-2015, 07:15 AM #4Disabled
- Join Date
- Jan 2011
- Posts
- 674
Anyone any ideas?
-
01-18-2015, 10:47 AM #5Web Hosting Master
- Join Date
- Oct 2007
- Posts
- 2,349
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
-
MySQL Error : Got error -1 from storage engine Error Number : 1030
By Linkdatacenter in forum Programming DiscussionReplies: 2Last Post: 05-25-2008, 04:16 AM -
Installed MySQL in /usr/local/mysql but error in /var/lib/mysql
By guest3 in forum Hosting Security and TechnologyReplies: 1Last Post: 01-21-2007, 06:38 PM -
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.
By atul in forum Hosting Security and TechnologyReplies: 5Last Post: 05-11-2004, 12:24 AM -
[URGENT] Please help with this error mySQL error:Can't open file: 'invision_posts.MYI
By John D in forum Programming DiscussionReplies: 14Last Post: 11-20-2003, 12:57 PM -
ticketsmith mysql error --> Got an error reading communication packets
By Domenico in forum Hosting Security and TechnologyReplies: 3Last Post: 11-06-2002, 08:45 AM