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. <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED]
>
>
--
Regards,
Ady Wicaksono
Email:
ady.wicaksono at gmail.com
http://adywicaksono.wordpress.com/
