How to Fix MySQL High CPU Usage?
-
I check in mysql and there are so many queries run every second :
“SELECT p.ID FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE p.post_date < ‘2022-01-21 00:18:33’ AND p.post_type = ‘product’ AND tt.taxonomy = ‘product_cat’ AND tt.term_id IN (233,282,360,383) AND p.post_status = ‘publish’ ORDER BY p.post_date DESC LIMIT 1”I don’t know where is the query from ?
Cound you tell me how to check and find out to fix this problem ?
My server’s cpu is so high.Thank you so much & Best regards,
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
- The topic ‘How to Fix MySQL High CPU Usage?’ is closed to new replies.