Problem with MySql Server -- hanging on query -- status LOCKED and not being released
Posted on 2007-03-29
I am having problems with a MySql Database installed on a dedicated server. I'm running an older version, 4.1.7, as it is used for a messenger who requires this version. My problem is that once in a while, not all the time, my database will hang. When this occurs, I see a bunch of users in the user connections window, and all these users show a query, and a status LOCKED. I'm having a hard time to troubbleshoot this because whenever this happens, I lose access to my server as it hangs, so I have to reboot, hence loose the process list causing the problem. I've looked at my logs and found nothing of interest. Any idea what might be happening here?