Found weird query running multiple times per minute
Trying to find the source of sudden weird lag on my large Buddypress website. I noticed this query running very frequently:
# Time: 220408 21:41:46 # User@Host: [removed] @ localhost  # Thread_id: 337208 Schema: [removed] QC_hit: No # Query_time: 1.645619 Lock_time: 0.000068 Rows_sent: 0 Rows_examined: 0 # Rows_affected: 0 Bytes_sent: 77 SET timestamp=1649454106; SELECT DISTINCT a.id FROM wp_bp_activity a WHERE ( ( ( a.component = 'groups' AND a.item_id IN ( 0 ) ) AND a.hide_sitewide = 0 ) ) AND a.is_spam = 0 AND a.type NOT IN ('activity_comment', 'last_activity') ORDER BY a.date_recorded DESC, a.id DESC LIMIT 0, 16;
It always results in nothing. So, where is it coming from and how can I stop it?
Any idea what function is triggering this, I’d be able to even edit the core file just to have it check “if certain params are true, don’t even run this query”
I think it’s killing my site’s performance
- You must be logged in to reply to this topic.