Slow delete of multiple threads

[elonturing]

Hello,

Doing some cleanup and noticed when deleting multiple threads it seems to take a long time.

This was the sql process while deleting 5 threads

As for search index

Total number of indexed words: 302530
Total number of word to post relations indexed: 21268512

Any way to improve delete times?

[JoshyPHP]

Do you have any control over MySQL settings? You can increase key_buffer_size if you're on MyISAM or innodb_buffer_pool_size for InnoDB.

In some rare cases, OPTIMIZE TABLE can improve the performance of future updates and deletions. And make sure that table has an index on post_id. (which it does by default)

[elonturing]

I just deleted the search index and added google to the forum.

A 50 thread delete that would lock the database for a couple minutes, now takes three seconds.