Re: Ancient, unsolved high-CPU problem

[Rene Fournier]

Uptime: 1054977  Threads: 10  Questions: 15576766  Slow queries: 229   
Opens: 489  Flush tables: 1  Open tables: 483  Queries per second avg:  
14.765

----

I know what the slow queries are--some that take 20-30 seconds to  
compute, and they are normal. The number of open tables seems high,  
no? The database that gets 95% of the load has ~35 tables in total.

As for cron jobs, I have a number of command-line PHP scripts that  
perform regular queries. They've been running for about 10 days now.  
The current high CPU state started a couple days ago.




On 22-Sep-08, at 8:30 PM, Martin Gainty wrote:

> curious if you have any cron jobs starting to execute?
>
> what does mysqladmin status show ?
>
> Martin
> ______________________________________________
> Disclaimer and confidentiality note
> Everything in this e-mail and any attachments relates to the  
> official business of Sender. This transmission is of a confidential  
> nature and Sender does not endorse distribution to any party other  
> than intended recipient. Sender does not necessarily endorse content  
> contained within this transmission.
>
>
> > From: m5@stripped
> > To: mysql@stripped
> > Subject: Ancient, unsolved high-CPU problem
> > Date: Mon, 22 Sep 2008 19:41:25 +0200
> >
> > For the longest time, I've had a strange problem with MySQL.
> > Basically, after a certain amount of time--sometimes a few days,
> > sometimes a couple weeks--its CPU usage will go from a steady 20-30%
> > to 80-90%. Actual load and number of queries is the same, nothing  
> else
> > changes.
> >
> > If I shutdown MySQL and restart it (not the server), CPU% goes  
> back to
> > normal. What could this be?
> >
> > (Xserve G5 2GHz, 8GB, 3x250GB RAID5, Mac OS X 10.4.11, MySQL  
> 5.0.51a)
> >
> > ...Rene
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=1
> >
>
> Get more out of the Web. Learn 10 hidden secrets of Windows Live.  
> Learn Now