Huge database, agonizing speed
 

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.

I wouldn't use InnoDB on the post tables.

If its taking you 20 hrs to delete 70 threads, i think you have other issues, lack of hardware to support your DB correctly or issues in the DB itself (bad indexes etc)

Im assuming the link in your sig is actually your site, couldnt tell what your exact stats were.

We dont use the postindex table, we switched to mysql search.

Yes, the site is from my signature. I`m still on 3.7.4 since I have a custom mod which I don`t have time to port to 3.8.2.
@snakes1100 : I doubt it`s hardware, as I have 0 usage when the site works normally, and when I do a thread delete, loads jump to 7-10.
I did alot of mysql optimizations and tweaking to match my server configuration, and get the most out of it.

Stats :
Threads: 1,033,025, Posts: 6,438,233

Some of your posts have dates in future: 02-09-2015
e.g. http://www.varioustopics.com/uk/1035...real-deal.html

.

I know, something with the importer. That`s not my pressing issue at the moment :)

Well, I converted my post, thread and word tables to inno, but found out I have to create new tables, set it to inno, copy the data over, and only then switch to those tables, else it won`t take inno right.