Hello, Thanks. I read the document, but unfortunately it didn't tell me anything new..
One of the things I am a bit confused about is: top - 22:08:12 up 6 days, 7:23, 1 user, load average: 4.36, 3.30, 2.84 Tasks: 134 total, 1 running, 133 sleeping, 0 stopped, 0 zombie Cpu0 : 61.3% us, 29.1% sy, 0.0% ni, 7.9% id, 0.7% wa, 0.3% hi, 0.7% si Cpu1 : 57.0% us, 37.1% sy, 0.0% ni, 6.0% id, 0.0% wa, 0.0% hi, 0.0% si Mem: 1034280k total, 942780k used, 91500k free, 34252k buffers Swap: 2031608k total, 104k used, 2031504k free, 278788k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 2410 mysql 15 0 470m 310m 4464 S 99.9 30.8 4200:25 mysqld How come the CPUs can have idle time even though mysqld is running at 99.9%, AND there's a processor queue (4.36)? Cheers, Gunnar R. On ons, januar 2, 2008, 13:07, Andrew Braithwaite wrote: > Hi, > > If you can follow this document: > > http://www.ufsdump.org/papers/uuasc-june-2006.pdf > > You should be able to figure out what's happening. > > Cheers, > > Andrew > > -----Original Message----- > From: Gunnar R. [mailto:[EMAIL PROTECTED] > Sent: Tue, 01 January 2008 23:31 > To: mysql@lists.mysql.com > Subject: Performance problem - MySQL at 99.9% CPU > > Hello, > > I am running a community site mainly based on phpBB. It has about 9.300 > registered users, 650.000 posts and about 200.000 visitors/month (12 > mill > "hits"). The SQL database is about 700MB. > > It's all running on a couple of years old Dell box with two P4 Xeon > 1.7Ghz > CPUs, 1GB of RAMBUS memory and SCSI disks, with Linux and Apache. > > The last year the server has been having huge performance problems, and > MySQL (5.0.45) seems to be the problem. It's almost constantly running > at > 99.9% CPU ("measured" using 'top'). > > I know the hardware isn't too hot, but either way I am a bit confused by > the > fact that I can't seem to get MySQL to run smoothly. Is this just too > big a > database for this kind of box, or could this be a configuration issue? > > I am thinking about buying a new dual core box (with IDE disks?), but I > have > to make sure this really is a hardware issue before I spend thousands of > bucks. > > Any help will be hugely appreciated! > > Cheers, > > Gunnar > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > LOVEFiLM International Limited is a company registered in England and > Wales. Registered Number: 04392195. Registered Office: No.9, 6 Portal Way, > London W3 6RU, United Kingdom. > > This e-mail is confidential to the ordinary user of the e-mail address to > which it was addressed. If you have received it in error, please delete it > from your system and notify the sender immediately. > > This message has been scanned for viruses by BlackSpider MailControl - > www.blackspider.com > > -- > 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]