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]
