I have a huge database, over 10 GB, and when I try to delete threads, it takes about 20 hours to delete 70 threads ... I`m doing some cleanup due to adsense being nasty about no-porn-on-threads rule, and I`m doing some mass deletions.
I was thinking of converting the post and postindex tables to innodb, to benefit on the row level locking feature ... still I`d like to know if anyone has had these issues and what solutions you used.
06-07-2009, 09:57 PM
Huge database, agonizing speed
Threaded Mode