[buddypress-trac] [BuddyPress Trac] #8532: High CPU due to Slow Queries

[buddypress-trac]

#8532: High CPU due to Slow Queries
-------------------------+-----------------------------
 Reporter:  bkkhanny     |      Owner:  (none)
     Type:  enhancement  |     Status:  new
 Priority:  high         |  Milestone:  Awaiting Review
Component:  Core         |    Version:  8.0.0
 Severity:  normal       |   Keywords:
-------------------------+-----------------------------
 MySQL CPU is reaching high and I can find alot of these in slow query
 logs:


 {{{
 # Time: 210718 16:50:58
 # User at Host: wpdb30458u2277[wpdb30458u2277] @ localhost []
 # Thread_id: 748  Schema: wp1039019370db_30458  QC_hit: No
 # Query_time: 8.219083  Lock_time: 0.000148  Rows_sent: 0  Rows_examined:
 895356
 # Rows_affected: 0  Bytes_sent: 88
 SET timestamp=1626627058;
 SELECT DISTINCT a.id  FROM wp_bp_activity a  WHERE
 (
         (
                 a.content LIKE '%@sissykelly1985<%'
                 AND
                 a.hide_sitewide = 0
                 AND
                 (
                         a.user_id NOT IN (
 7521,4819,7523,7520,6554,621,4807,5492,7546,7544,7574,7143,4421,7588,7597,4467,7609,5195,7614,7623,7629,7644,4525,7647,4902,3663,7590,7657,7603,7$
                 )

         )

 )

 }}}

-- 
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/8532>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac