When I try to change the status of more than 5 or 6 posts, I often run into a "deadlock" error:
1213 Deadlock found when trying to get lock; try restarting transaction SQL=UPDATE `XXXX_finder_terms` AS t INNER JOIN `XXXX_finder_tokens_aggregate` AS ta ON ta.term_id = t.term_id SET t.`links` = t.links + 1
What's causing this? I'd like to "publish" or "delete" multiple articles, not just 2-3 at a time.