Solved

Why does my MySQL instance crash for no good reason?

Posted on 2014-02-13
1
287 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 78

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

Get Actionable Data from Your Monitoring Solution

Your communication platform is only as good as the relevance of the information you send. Ensure your alerts get to the right people every time with actionable responses. Create escalation rules that ensure everyone follows the process and nothing is left to chance.

Question has a verified solution.

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

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://…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

717 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