You have to give it to the russians. They dont mind taking a few Risks.
Bookmark to:
Archive for May, 2010
Nuke the oil slick
Tuesday, May 11th, 2010adjusting innodb_log_file_size in mysql to get around
Tuesday, May 11th, 2010I was getting “ERROR 1033 (HY000): Incorrect information in file: ‘./realworx_production/analyzers.frm’” whenever I tried to adjust my mysql innodb parameters and run a query.
To adjust this you have do delete or move the ib_logfile0 and ib_logfile1 file in your datadir. Then start the database.
So step-by-step
1. stop mysql
2. modify my.cnf, specifically the changes you want to make to innodb_log_file_size
3. move or delete ib_logfile1 and ib_logfile0
4. start database.
Bookmark to: