Restarting Mysql Service Every 1 Hour?

I want to restart mysql service every 1 hour
How can i do it with ssh cronjob

 

You do NOT want to restart MySQL every 60 minutes because if it stops while the database is being written to you will end up with a corrupted db.

Why do you want it to restart so much?

 

my mysql is giving high load when i restart , it turns to normal .
so i need how to do it with ssh

I wrote 0 * 1 1 1 /etc/rc.d/init.d/mysqld restart to cronjob
I hope it work i will test

 

Probably because he has high load, and hasn't tuned it correctly. Might be able to help with something like this.

 

I think it's

0 * * * * /etc/init.d/mysql restart

Code (markup):

Jay

 

I think you need to find the source of the problem rather than to restart MySQL to get the load down. I think you need to find what's causing it in the first place.

 

Might be he needs to turn off persistent connections.