Re: Ancient, unsolved high-CPU problem

[Rene Fournier]

10% of queries are web-based (Apache/PHP).
30% of queries are from command-line PHP scripts that get executed  
(average 1/second -- they end with mysql_close() btw).
60% of queries are from command-line PHP scripts that run continuously  
(in a loop, with sleep()), acting on incoming socket data.

...Rene

On 23-Sep-08, at 2:20 PM, Jeffrey Santos wrote:

> Rene,
>
> How are you querying the database during normal use?  What kind of  
> applications are you using?
>
> ~Jeffrey Santos
>
> On Mon, Sep 22, 2008 at 2:46 PM, Rene Fournier <m5@stripped>  
> wrote:
> 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
>
>