Re: Optimize a large MySQL Table

[thota kaarthiik]

Thanks for your response Rick.

Table is of Innodb. Sometimes deletion takes place on this table. It is heavy. It contains emails in form of blob. So lots of inserts happen.

We were using Mysqlcheck with --auto-repair and --optimize options with it.

What is the best way to handle maintenance? Recently DB performance got low. We had to kill the optimize in middle as we did not had option... all the hours are of waste.

MySQL is on 32 bit. OS is on 64 bit. Planning to move the DB to 64 bit. Version 5.1.24

But the thing that was not understood is, the optimizations is lot quicker on test servers. But on production it is dead slow. And recntly we found that production mahcine is much higher of configuration than our test servers. They are of dual quad core processors.