mysqld-nt 100% CPU Utilization?

Robinson, Eric · *nix forums beginner Joined: 20 Apr 2006 Posts: 19

Our MySQL-based medical application has been running fine for 3 years.
Last week, mysqld-nt started jumping up to 100% CPU and staying there
until someone restarts the service. mysqlcheck found no errors in the
database. I dumped it to disk and read it back in to create a fresh copy
of the database, but it is still happening. Any ideas?

--
Eric Robinson

Disclaimer - July 19, 2006
This email and any files transmitted with it are confidential and intended solely for mysql@lists.mysql.com. If you are not the named addressee you should not disseminate, distribute, copy or alter this email. Any views or opinions presented in this email are solely those of the author and might not represent those of Physician Select Management (PSM) or Physician's Managed Care (PMC). Warning: Although the message sender has taken reasonable precautions to ensure no viruses are present in this email, neither PSM nor PMC can accept responsibility for any loss or damage arising from the use of this email or attachments.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Chris · *nix forums Guru Wannabe Joined: 29 Jan 2006 Posts: 137

Robinson, Eric wrote:

Douglas Sims · *nix forums beginner Joined: 20 Mar 2006 Posts: 13

Can you do a "show processlist" from the MySQL client? This might
help you to figure out if it is a specific query that's gumming up
the works.

Douglas Sims
Doug@Apley.com

On Jul 19, 2006, at 6:35 PM, Robinson, Eric wrote:

Google