mySQL stops working, kills website completely

Posted on 2011-03-09
Last Modified: 2012-06-27
I have a fairly traffic heavy site that works for a while without issue then completely stops working due to what we believe is a mysql crash/issue... Does anyone have any suggestions/ideas to help us figure this out... Are there any tools or anything that I can use to troubleshoot this issue?  The only thing that is working to get it back up and running is restarting the mysql service and restarting iis then it will work for some time before it crashes again.
Question by:NELIXINC
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
  • 3
  • 3
LVL 50

Expert Comment

by:Steve Bink
ID: 35092913
>>> due to what we believe is a mysql crash/issue

What evidence do you have that lends towards that conclusion?  Have you examined any of the MySQL logs?  Have you attempted to troubleshoot the MySQL server during an outage?  Have you created any trace code to find out when/where outages occur in your application?

Author Comment

ID: 35095476
Well in all honesty I can't say for sure that is the situation... But basically it seems like after some time IIS is refusing to open connections to mysql... When I log into the server I'm able access mySQL command line... We've checked all the obvious things like unclosed connections etc but nothing really stands out... We are just looking for some avenues to go down to figure this out... Does anyone have any suggestions to help figure out where this is going wrong..  Restarting IIS and mysql service do free it up again and allow it to work for some time.  I'll throw in some trace code to see what I can see when it stops working...
LVL 50

Expert Comment

by:Steve Bink
ID: 35105776
Next time, try just restarting IIS.  If that alone brings services back up, then it looks like an IIS issue.  What version of IIS are you using?  Is this application written in .NET?
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.


Accepted Solution

NELIXINC earned 0 total points
ID: 35109314
Turns out to be some index issues on the mysql database
LVL 50

Expert Comment

by:Steve Bink
ID: 35114251
Could you elaborate a little more on the resolution you found?

Author Closing Comment

ID: 35145506
found the solution ourselves

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
In an interesting question ( here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

738 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