My Sql database load too high

samarniazi

Registered
Mar 30, 2023
1
0
1
Pakistan
cPanel Access Level
Website Owner
Hello, my sql database process shows 1 query running again and again thousands of time and never gets completed or timeout. Pls help. I have to restart my sqp in order to visit wp admin in my website. It just says sending data and crates another one same as thisScreenshot_20230331-073457_Chrome.jpg
 
Last edited by a moderator:

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
16,505
2,605
363
cPanel Access Level
Root Administrator
Hey there! Does checking the MySQL processes on the server directly with the "mysqladmin proc status" command give you any more detail about those processes? That will show what is happening with the service in real-time, including the status of the queries and how long they have been running.

If the issue is always wit the same query, it is most likely an issue with the coding of the query and not a problem with MySQL itself.