MySQL 5 CPU very high Usage

Hello experts,

i am on a DDS windows 2003 enterprise server (IIS6) , SP2, with my PHP e-commerce apps running on MySQL 5 & PHP 4.3.11
Alle of the sudden, MySQL uses 100% of my CPU and the server stopped responding, so I had to disable MySQL service until i find the cause.
Any idea what i should looking for?
Database tables are optimized and queries running now hold to a minimum
sh2grAsked:
Who is Participating?
 
nizsmoDeveloperCommented:
There are a lot of possible solutions for your problem:
http://www.google.co.nz/search?hl=en&q=mysql+100%25+cpu&btnG=Google+Search&meta=
0
 
DeathbobCommented:
Try running "SHOW FULL PROCESSLIST" while it is at 100% and posting what it returns. May be some rouge connections that arn't closing.
0
 
sh2grAuthor Commented:
Well, as i had no time to investigate further, i downgraded to the previous mysql version and all work fine now.
I will consider your recommendation for the next time the same issue will ahppen (hope not)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.