charliecres

Active Member
Mar 5, 2020
28
2
3
Dhaka
cPanel Access Level
Root Administrator
MYSQL server getting slower and most of the site showing down.

i need to restart mysql server once to solve this issue in every 12-15 hours.


i need a permanent solution.

is there any way to restart mysql server automatically in every 12 hours? or any cron job setup?



i have included screenshot of my.cnf .

is there anything wrong? help me to resolve this issue.
 

Attachments

Last edited by a moderator:

ServerHealers

Well-Known Member
Sep 21, 2015
59
28
68
India
cPanel Access Level
Root Administrator
I'd suggest checking the active usage of the MySQL at the time of slowness to see what exactly causing it. You could check it using the below command:

# mysqladmin proc status

I also don't suggest restarting MySQL service every 12 hours, that might make things more complex, rather, I'd run a MySQL optimizer script to see if there are any parameters that we could alter to make MySQL more optimized to perform well.

 
  • Like
Reactions: cPRex