List:General Discussion« Previous MessageNext Message »
From:Jeffrey Santos Date:September 23 2008 12:20pm
Subject:Re: Ancient, unsolved high-CPU problem
View as plain text  
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
>>
>
>

Thread
Ancient, unsolved high-CPU problemRene Fournier22 Sep
Re: Ancient, unsolved high-CPU problemRene Fournier22 Sep
  • Re: Ancient, unsolved high-CPU problemJeffrey Santos23 Sep
    • Re: Ancient, unsolved high-CPU problemRene Fournier23 Sep
      • Re: Ancient, unsolved high-CPU problemDoug Bridgens23 Sep
        • Re: Ancient, unsolved high-CPU problemRene Fournier23 Sep
          • Re: Ancient, unsolved high-CPU problemDoug Bridgens23 Sep
        • Re: Ancient, unsolved high-CPU problem -- vmstat, top and psRene Fournier23 Sep
          • Re: Ancient, unsolved high-CPU problem -- vmstat, top and psKen Menzel23 Sep
            • Re: Ancient, unsolved high-CPU problem -- vmstat, top and psRene Fournier24 Sep
              • RE: Ancient, unsolved high-CPU problem -- vmstat, top and psMartin Gainty24 Sep
                • Re: Ancient, unsolved high-CPU problem -- vmstat, top and psRene Fournier30 Sep
              • Re: Ancient, unsolved high-CPU problem -- vmstat, top and psKen Menzel24 Sep
                • Re: Ancient, unsolved high-CPU problem -- vmstat, top and psRene Fournier30 Sep
                  • Re: Ancient, unsolved high-CPU problem -- vmstat, top and psKen Menzel30 Sep