Solved

MySQL Questions / Hanging Problem

Posted on 2011-03-22
3
414 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:street9009
  • 2
3 Comments
 
LVL 10

Expert Comment

by:Hutch_77
ID: 35195517
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.
0
 

Accepted Solution

by:
street9009 earned 0 total points
ID: 35195520
I did check the error log (in the MySQL directory) and the event log and haven't seen anything that jumped out at me. I will take a look again the next time it hangs.

I did find a 12GB regular log file that I'm backing up and getting ready to flush so that may have something to do with it. Not sure though.
0
 

Author Closing Comment

by:street9009
ID: 35711467
It must have been the 12GB log file. Once set up to purge nightly, MySQL stopped hanging.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Problem with Simple PHP/mySQL Query 3 74
RDBMS and No sql database 4 63
SubQuery link 4 35
Uploading a CSV Data Import via PHP & MySql 3 29
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question