High CPU Spikes from high traffic website

[ad_1]

https://preview.redd.it/v3jpdod1eurd1.png?width=1133&format=png&auto=webp&s=1b8305efea53b989047138c792bdfc63021ac6b2

So i have this website, it gets 1500-2000 visits every 30min, around 100 every 30min during night time (00-08am).
Since 2 months ago i got this huge spikes, i tried everything to try to understand. the process having that much cpu is "mysql", the php-fpm gets a lot of instances too. the space between spikes is random. i tried to disable every plugin with no result. i have the website behind cloudflare, running on plesk/almaos. I used to have this much traffic and no spikes, i also change server and imported this website using the import tool from plesk and the spikes continue to happen. any ideas?

[ad_2]

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer