My server autorun optimize table everyday and today, it run and failed for 6 hours until I found out. Percona Server become cannot start. It keep saying page is corrupt so, I set innodb_force_recovery=1 and it can run again. I do recover by using below method
It helped me recover some of database out but 20% is unrecoverable and it’s table user which is the most important.
My question is “Did optimize table should not be run everyday to make the database run faster?” and “Do optimize table can make the database corrupt?” My server is Joyentcloud which is run on OpenSolaris with Percona Server 5.5. I suspect if it’s hardware problem from hosting itself or it’s some mysql bug. Do you have any suggestion?