batch removed thousands of members, now mysql locking site

dethfire

Well-known member
Immediately after batch removing 14k members (process completed), mysql is now ranging from 200-300% of CPU and completely locking the site even after restarting mysql. Any ideas?
 

dethfire

Well-known member
Now it appears the batch tool was just queuing the queries up and jobs.php is still running queries. This is misleading.
 

Xon

Well-known member
Try making sure you have indexes added as listed here;

XF added some indexes, but not all of them.
 
  • Like
Reactions: rdn
Top