MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Ady Wicaksono Date:January 2 2008 6:10am
Subject:Re: Performance problem - MySQL at 99.9% CPU
View as plain text  
Hi, please monitor what happened with mysql

show processlist
show innodb status

and also ps aux

because maybe some application makes your mysql busy

On Jan 2, 2008 7:31 AM, 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?
>
> 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
>
>


-- 
Regards,

Ady Wicaksono
Email:
ady.wicaksono at gmail.com
http://adywicaksono.wordpress.com/

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