High CPU due to Slow Queries

[bkkhanny]

MySQL CPU is reaching high and I can find alot of these in slow query logs:

# Time: 210718 16:50:58
# User@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$
                )

        )

)

[imath]

Thanks for your report. It's duplicating with an existing ticket. Please feel free to share your recommandations on it see #8413