List:General Discussion« Previous MessageNext Message »
From:Gunnar R. Date:January 3 2008 9:44pm
Subject:RE: Performance problem - MySQL at 99.9% CPU
View as plain text  
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:gr@stripped]
> Sent: Tue, 01 January 2008 23:31
> To: mysql@stripped
> 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/mysql?unsub=1
>
>
>
> 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/mysql?unsub=1
>
>


Thread
Performance problem - MySQL at 99.9% CPUGunnar R.2 Jan
  • Re: Performance problem - MySQL at 99.9% CPUBaron Schwartz2 Jan
  • Re: Performance problem - MySQL at 99.9% CPUAdy Wicaksono2 Jan
    • Re: Performance problem - MySQL at 99.9% CPUGunnar R.3 Jan
  • Re: Performance problem - MySQL at 99.9% CPUPer Jessen2 Jan
    • RE: Performance problem - MySQL at 99.9% CPUEric Frazier2 Jan
  • RE: Performance problem - MySQL at 99.9% CPUAndrew Braithwaite2 Jan
    • RE: Performance problem - MySQL at 99.9% CPUGunnar R.3 Jan
      • Re: Performance problem - MySQL at 99.9% CPUErik Giberti4 Jan
        • Re: Performance problem - MySQL at 99.9% CPUGunnar R.8 Jan
        • Re: Performance problem - MySQL at 99.9% CPUGunnar R.8 Jan
          • Re: Performance problem - MySQL at 99.9% CPUKevin Hunter8 Jan
          • Re: Performance problem - MySQL at 99.9% CPUErik Giberti9 Jan
Re: Performance problem - MySQL at 99.9% CPUKevin Hunter9 Jan