hi , i have a contabo vps which have DDOS attacks protection and cloudflare with the main domain, VPS specs:
CPU Model: Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz
CPU Details: 4 Core (2200 MHz)
Ram : 8GB
Distro Name: CentOS Linux release 7.6.1810 (Core)
Kernel Version: 3.10.0-957.21.3.el7.x86_64
i run CWP Pro.
i have installed 3 wordpress sites , there is one with about 35000 posts.
Now, the CPU usage is 100% and all my websites are down because of mysqld service
there are some screenshots of the CWP processes and mysql queries.
https://imgur.com/Q8yK9A7https://imgur.com/uzFLNm3https://imgur.com/577yZ5Vplease help me , how can i optimize mysql for better performance?