Author Topic: Time out 300% cpu sql  (Read 797 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Time out 300% cpu sql
« on: November 19, 2023, 04:16:57 PM »




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
« Last Edit: November 19, 2023, 04:32:57 PM by evehq »

Offline
*****
Re: Time out 300% cpu sql
« Reply #1 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/