MySql Database Rapidly Increasing! Help Please

G

GentleMan

Registered
Nov 7, 2018
3
0
1
Pakistan
cPanel Access Level
Website Owner
Hi Friends, I am having the SQL high usage issues into my website . Some time it goes to more then 1000% and average of sql is round about 200% to 400%. I have a dedicated server with the config below:

40 core CPU
256 GB Ram
500mb dedicated bandwidth

Due to High SQL rapidly increasing, my site goes down (Crashes) in every 5 minutes. Please help me to Solve this problem. As i contact with my hosting company but they told me everything is perfect from our end, so i don't know What do i do now.
 

Attachments

F

ffeingol

Well-Known Member
PartnerNOC
Nov 9, 2001
409
93
328
cPanel Access Level
DataCenter Provider
Have you gone into phpmyadmin and looked at what is running or run mysqladmin processlist from Linux shell? If MySQL is using a lot of CPU it's more than likely a bad query and you have to debug it from within MySQL.
 
  • Like
Reactions: cPanelLauren
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
H MySQL Databases Offline in cPanel? (kind of cryptic error message) Databases 3
M SOLVED mysql appears to be down after moving database Databases 6
Bashed Change MySQL Database to InnoDB? Databases 1
A Remove Sys Database after upgrade to from MySQL 5.7 to MariaDB 10.3? Databases 6
F SOLVED MySQL database Error cause of cpanel_cp Databases 3
Similar threads
MySQL Databases Offline in cPanel? (kind of cryptic error message)
SOLVED mysql appears to be down after moving database
Change MySQL Database to InnoDB?
Remove Sys Database after upgrade to from MySQL 5.7 to MariaDB 10.3?
SOLVED MySQL database Error cause of cpanel_cp
Top Bottom