Senator crash problem with mysql

[wormsunited]

By the way... Since the InnoDB Storage Engine looks operational at the time mysql is restated, you should take the time to cleanup the InnoDB infrastructure.

• mysqldump the entire database instance
  
• reconfigure innodb from scratch
  
• Start over with a fresh ibdata1 file
  
• Empty Undo Space
  
• Empty Rollback Segments
  
• Empty Data Dictionary
  
• Empty List of Tablespace IDs
  
• Store Each InnoDB table in its own tablespace
  
• Configure Buffer Pool to be 4 times the Log File Size
  
• Perform Better Flushing of the Buffer Pool
  
• reload mysql data
  

Source => http://dba.stackexchange.com/questions/1...corruption