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 >> > >
