Solved

Why does my MySQL instance crash for no good reason?

Posted on 2014-02-13
1
280 Views
Last Modified: 2014-02-19
I've got a lot of ETL reading and writing to my DB all day, every day.  It runs quickly but about 1x per day, MySQL just crashes.  I just restart it when I notice, but then my ETL is backlogged.  I've added a scheduled 'net start mysql' that repeats every 5 minutes on Task Scheduler, but that's a bandaid, not a fix.  

If I check the *.err file at C:\Program Files\MySQL\MySQL Server 5.5\data, I don't see much of use in there.  It'll say "InnoDB: Database was not shut down normally!" but that's it.  

My guess is that these crashes happen because of highly concurrent reads/writes and also some nasty Select queries that are called by a script on Windows scheduler every now and then.

How can I go about getting a better clue of what causes the mysql service to just stop?  Are there any settings in the options file can look at / adjust to help avoid crashes?
0
Comment
Question by:ducky801
1 Comment
 
LVL 77

Accepted Solution

by:
arnold earned 500 total points
ID: 39859434
To determine the cause you need to monitor its memory use.
Look at the error log.
Look at the system event log to make sure windows isn't shutting it down because it is trying to get too many resources or it transgresses application boundaries.
If you do not already have phpmyadmin installed on your web server through which you can access the mysql stats and get a report that may help in resolving your issue.

I doubt the inserts/writes are the cause.  Do you have reports queries ran on/against the mysql and that is when those crashes are commonly seen?
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

829 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