<div>
Having never seen this issu directly, I would start looking more directly at te issue. &nbsp;What is causing it to hang. &nbsp;anything in event viewer any updates or major additions to the db &nbsp;My former boss wouldl ove to see me say this but setting up a random restart is a bandaid and doesnt really fix your real problem which could grow.
</div>


Having never seen this issu directly, I would start looking more directly at te issue.  What is causing it to hang.  anything in event viewer any updates or major additions to the db  My former boss wouldl ove to see me say this but setting up a random restart is a bandaid and doesnt really fix your real problem which could grow.

<div>
It must have been the 12GB log file. Once set up to purge nightly, MySQL stopped hanging.
</div>


It must have been the 12GB log file. Once set up to purge nightly, MySQL stopped hanging.

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
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.
</div>
</div>


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.

MySQL Questions / Hanging Problem

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.