Hi, I'm using GNU/Linux Slackware 8.0 and not using any my.cnf (so the configs are all at default).. Is it possible that mysql is doing some background tasks while the system is in idle state ?
thanks ---------- Original Message ---------------------------------- From: Jeremy Zawodny <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 4 Jun 2003 20:10:40 -0700 >On Thu, Jun 05, 2003 at 10:05:00AM +0700, nino wrote: >> 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. > >What operating system do you use? And which verison of MySQL? > >Can we see your my.cnf file? > >Have you enabled the slow query log to see what's slowing you down? > >Jeremy >-- >Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! ><[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > >MySQL 4.0.13: up 1 days, processed 66,202,387 queries (415/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]
