Unanswered: optimize tables and 48 + hours to complete
I am using Mysql enterprise 5.0, there is huge amount of data in each table of last six months. whch is useless (as we have backup of this) so we want to delete old records.
as i deleted the records and want to get the space used by tables (162 GB single table). it takes 48+ hours to get the job done. where as the same task when i used it on another server, time was 8 Hours.
after checking the primary database server i analyzed that another server is trying to insert data into this server.
The primary database server have 2 CPU (Quad core PPC) and 16 GB memory where as test database server have single CPU (Quad Xeon) and 8GB memory.
how do i make this fast to complete or any suggestion.