Portal Home > Knowledgebase > Articles Database > innodb problem


innodb problem




Posted by Xcode, 12-30-2012, 02:22 PM
really a weird problem i like to use low memory usage so i skip "skip-innodb" and after restarting mysqld i get below error if i enable innodb means my site doesn't run even for 1 hour properly i have tried all those /tmp things service mysql stop rm -f ib_logfile* service mysql start nothing worked! waiting for suggestions my.cnf file

Posted by dareORdie, 12-30-2012, 02:46 PM
You receive this error message if InnoDB table is corrupted or damaged. An InnoDB table is stored as three files: .FRM (database table definition), .MYI (Index file) and .MYD (table data). This certain error occurs if .FRM table is damaged or corrupted.

Posted by Xcode, 12-30-2012, 02:49 PM
no table is corrupted or damaged bro if i comment innodb means everything is fine as before but site take heavy memory usage !

Posted by dareORdie, 12-30-2012, 02:59 PM
Please paste the mysql error log here.

Posted by Xcode, 12-30-2012, 03:09 PM
sorry but it's empty! hope without error log we can fix



Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read
How to fight spam? (Views: 321)
2010 with WE3CARES.COM (Views: 319)