Nino, are you using InnoDB tables? InnoDB does background purge and insert buffer merge. What does SHOW INNODB STATUS say during that spike?
Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ ----- Original Message ----- From: "" nino"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, June 06, 2003 10:41 AM 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]