Solved

mySQL stops working, kills website completely

Posted on 2011-03-09
6
240 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
[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
  • 3
  • 3
6 Comments
 
LVL 51

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 51

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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

Accepted Solution

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

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

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 …
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

615 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