Optimize a large MySQL Table

[thota kaarthiik]

Hi,

We have a large table approximate 27 GB, and when trying to optimize this table on production, it is taking more time, We had to kill the optimize before it completes, as we could not afford downtime of more than 2 hours. DB should be 24X7 Up. And we take Hotbackups using Percona tools.

MySQL Version is 5.1.25 32 bit, but OS is SUSE 64 Bit.

The table is having a BLOB data. The database size is 57 GB.

Before running optimize on production, we restored the copy of production DB on our test machine on a VM with 4 GB ram (Production is dedicated server, Hardware of test and production is different), Optimization with auto repair completed in just 45 minutes. But when on production server, it is taking beyond 2 hours.

Is optimization highly depends on CPU speed ? Our test server is a new server with quadcore processor.

Request experts here to provide some inputs on what to check!

Thanks,
Kaarthiik