MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:January 2 2008 12:15am
Subject:Re: Performance problem - MySQL at 99.9% CPU
View as plain text  
Hi,

On Jan 1, 2008 6:31 PM, Gunnar R. <gr@stripped> wrote:
> 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?

It might an application problem, not MySQL.  You could have some
config problems too, but it's hard to give advice on that.  Just as a
very basic first step, are you using a default configuration for
MySQL, or have you customized it?  Have you watched the processlist to
see what's going on?  Is the query cache enabled?
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