I have a MySQL 5.0.45 production server that until very recently was fine. About a week, maybe two, ago, the server has started hanging every day to few days. This is installed on a Windows 2003 Server and when I try to restart the MySQL service, it will not do anything. The only solution is to reboot the entire server.
I am curious if anyone thinks an automated shutdown/reboot of the MySQL service would help this and if so, how would I accomplish that? Otherwise, open to suggestions.