MySQL Flooded with Queries When Posting
I have recently started to have a problem on my site that I really can’t figure out, and I’m hoping someone here can help me to troubleshoot it.
Often, but not always, when someone posts on my site (not just in bbPress, but on the blog as well) I get a flood of a particular kind of query, which causes huge load spikes. Here is an example of one of the queries:
SELECT DISTINCT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name FROM as_bp_activity a LEFT JOIN as_users u ON a.user_id = u.ID WHERE a.is_spam = 0 AND a.component IN ( ‘bbpress’ ) AND a.hide_sitewide = 0 AND a.type != ‘activity_comment’ ORDER BY a.date_recorded DESC LIMIT 0, 5
I have already posted this in the BuddyPress forum, but they said it was related to bbPress, so I should ask here.
- You must be logged in to reply to this topic.