Re: time for OPTMIZE TABLE and ANALYZE TABLE for Really Big Tables

[Adrian Chapela Cordeiro]

I don't know any third software to refresh index, analyze, optimize a really big table.

I have one table of about 100 GB size and the time depends of size of file. If you want optimize a table I recommend you configure a slave serve to takeover while the opeation is doing.

You can do the next:

you need a master and a slave server.

You can do the change in the slave server (modifying the key, analyze or optimize). Then when the slaver server finishs you must wait the slave server catchs up the master server. When they are synchronized you have to change the roles, slave server to master server and master server to slave server. Now you can do the operation in master server and then wait until it catchs up the new master and then you should change the roles again.

Could it be valid for you ?? I do long operations like that.