I'm no Linux expert (barely even a novice) but, from my Windows experience I think that most applications will from time to time do this sort of thing. What is important is how long it does it for!
If its a brief surge, its just trying to use the resources to complete the task quickly. If it takes a while, then there's a problem somewhere. I'm currently having a similar problem with 40 minute surges on Filemaker which is giving me a real headache as its going to be a few months before my MySQL replacement is ready. Just my 2c (2p actually) George in Oxford > -----Original Message----- > From: nino [mailto:[EMAIL PROTECTED] > Sent: 06 June 2003 8:48 am > To: [EMAIL PROTECTED] > Subject: Re: mysqld CPU usage is almost 100% !!! > > > Neither am I, I'm not ODBC literate :) > Is there any answer relating my problem (mysqld CPU consume) with > the way mysqld doing its background tasks ?? Or, is it normal > that mysqld sometimes consuming my CPU at some 99.9% ?? > > ---------- Original Message ---------------------------------- > From: Jeremy Zawodny <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Wed, 4 Jun 2003 23:14:23 -0700 > > >On Thu, Jun 05, 2003 at 11:33:23AM +0800, Ahmad Rezal Ibrahim @ > PNSB wrote: > >> > >> check either your using ODBC - trace is on ? > > > >How would that impact the server? > > > >I'm not terrible ODBC-literate, so I don't know. > > > >Jeremy > > > >> -----Original Message----- > >> From: nino [mailto:[EMAIL PROTECTED] > >> Sent: Thursday, June 05, 2003 11:05 AM > >> To: milis mysql > >> Subject: mysqld CPU usage is almost 100% !!! > >> > >> > >> Hi folks, > >> > >> I'm experiencing some phenomenon that mysqld is consuming CPU at almost > >> 100%. At this time, I only assemble a few database with record > size is about > >> 37000 rows. Is mysqld likely gonna crash or something ?? > >> > >> I also noticed that, if some other mysqld thread is active, > the mysqld which > >> consume almost 100% CPU is decreasing its CPU usage a little bit, and > >> sometimes the CPU usage is normal. > >> > >> Is it because my record size grows ? Anyway, it's only 37000 rows > >> > >> please help me, thanks in advance > >> > >> --nino > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: > >> http://lists.mysql.com/[EMAIL PROTECTED] > > > >-- > >Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > ><[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > > >MySQL 4.0.13: up 1 days, processed 67,889,776 queries (398/sec. avg) > > > >-- > >MySQL General Mailing List > >For list archives: http://lists.mysql.com/mysql > >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]