Avatar of NELIXINC
NELIXINC
 asked on

mySQL stops working, kills website completely

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.
Visual Basic.NETMySQL Server

Avatar of undefined
Last Comment
NELIXINC

8/22/2022 - Mon
Steve Bink

>>> 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?
NELIXINC

ASKER
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...
Steve Bink

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?
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
NELIXINC

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Steve Bink

Could you elaborate a little more on the resolution you found?
NELIXINC

ASKER
found the solution ourselves