CentOS

Dear all, I have a8 core CPU server with memory of 32GB. Then to mysql results into heavy load, sometimes even 50 with idealtime=0. Please find the output of mysqltuner. >> MySQLTuner 1.7.8 - Major Hayden <major@mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> R...

innodb_force_recovery = 1

It is the exact line which is there in /etc/my.cnf.

Thanks for your help. It was the faulty disk which is located in our DC. Anyway will align hardware team for the replacement

Dear all, In my server , CPU is continuously under heavy load due to mysql. Also ideal time is 0. Please find the output of mysqltuner.pl script. Any help to reduce load is appreciated. -bash-4.1# ./mysqltuner.pl >> MySQLTuner 1.7.7 - Major Hayden <major@mhtx.net> >> Bug reports, feature requests, a...

MYSQL Log:- ;InnoDB: End of page dump 180228 10:28:06 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432 InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0 InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0 InnoDB: Page number (if stored to page already) 0,...

Hi Devourer,
Database is not starting even after using innodb_recovery to level 5. Any other solutions?

No, Lots of space is left in the disk.
df -lh

Filesystem Size Used Avail Use% Mounted on
/dev/hda1 66G 5.6G 57G 9% /
/dev/hda2 16G 4.2G 11G 29% /var
tmpfs 2.0G 0 2.0G 0% /dev/shm

Dear all, I am unable to start MYSQL service in my CENTOS 5.11 server . Please find the attached logs for your reference. Your help will be appreciated. vi /var/log/mysqld.log 180223 16:46:02 mysqld started InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence numbe...