sanhpv aaP_demo1 Not everything is normal Time: 2024-11-24T18:26:39.350987Z User@Host: sql_jx_guru[sql_jx_guru] @ localhost [] Id: 1192940 Query_time: 4.359717 Lock_time: 0.000166 Rows_sent: 20 Rows_examined: 1708268 SET timestamp=171472799; SELECT wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND wp_posts.ID NOT IN (230761) AND ( wp_term_relationships.term_taxonomy_id IN (217,270,503,504,5972,6251) ) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY RAND() LIMIT 0, 20; this is slow log mysql of me
aaP_demo1 sanhpv How about your site's access logs? check client's IP to see if they're making huge requests.
sanhpv aaP_demo1 There is no unusual traffic, only google bot traffic is a lot, my website has 188k articles
aaPanel_Kern Hello, do you use waf? Or CloudFlare checks whether access is normal? You can use phpmyadmin to check which mysql processes occupy the CPU sanhpv
sanhpv It's funny that I have full cpu due to Google bot, now what should I do to block Google bot so I can't do SEO?
aaPanel_Kern Hello, I suggest you check what is the cause? Can it be viewed using Website statistics v2? Which IP is accessed from? If it is not a normal access, you can prohibit it from accessing it. sanhpv
sanhpv aaPanel_Kern I found the cause in this article, can you go to this article and help me? https://www.aapanel.com/forum/d/22555-how-do-i-need-to-set-up-mysql-to-withstand-the-load-of-bot-requests
aaPanel_Kern Hello, is it possible to set it to 2G-4G? You need to restart mysql after setting sanhpv
