Solved

mySQL stops working, kills website completely

Posted on 2011-03-09
6
238 Views
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.
0
Comment
Question by:NELIXINC
  • 3
  • 3
6 Comments
 
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?
0
 

Author Comment

by:NELIXINC
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...
0
 
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?
0
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.

 

Accepted Solution

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

Expert Comment

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

Author Closing Comment

by:NELIXINC
ID: 35145506
found the solution ourselves
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
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…

830 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