Control Web Panel

WebPanel => CentOS 7 Problems => Topic started by: evehq on November 19, 2023, 04:16:57 PM

Title: Time out 300% cpu sql
Post by: evehq on November 19, 2023, 04:16:57 PM

(https://i.imgur.com/FmtVG6n.png)

(https://i.imgur.com/fwzK0iS.png)

Please can someone help me fix this? I don't have thousands of visits, my server is strong but it only increases the visits a little and it is impossible to work. Please, I'm not an expert but I understand... I don't understand why the queries generate so much cpu usage... please help

Title: Re: Time out 300% cpu sql
Post by: overseer on November 20, 2023, 09:04:25 PM

What is the web application you are using that connects to the DB? A PHP script?
You probably need to do some MySQL tuning:
https://www.linode.com/docs/guides/how-to-optimize-mysql-performance-using-mysqltuner/ (https://www.linode.com/docs/guides/how-to-optimize-mysql-performance-using-mysqltuner/)