Why does my MySQL instance crash for no good reason?

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?
LVL 5
ducky801Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
arnoldConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.