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 <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
> To: mysql@lists.mysql.com
> 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/[EMAIL PROTECTED]
>
Get more out of the Web. Learn 10 hidden secrets of Windows Live.
Learn Now