List:General Discussion« Previous MessageNext Message »
From:Gunnar R. Date:January 1 2008 11:31pm
Subject:Performance problem - MySQL at 99.9% CPU
View as plain text  
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


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