MYSQL server getting slower

[charliecres]

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.

 

[ServerHealers]

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.

How To Use The MySQLTuner Script?

Disclaimer: Please bear in mind that, it is extremely important for you to fully understand each change you make to a MySQL database server. If you don't understand portions of the script's outpu...

support.cpanel.net