that's particularly problematic,
perhaps optimizing the indexes etc on the table might help with the
performance.
Also, make sure your HD's aren't full... that will kill performance
very quickly if the needed disk space isn't there.
Erik
On Jan 3, 2008, at 3:44 PM, Gunnar R. wrote:
Hello
that's particularly problematic,
perhaps optimizing the indexes etc on the table might help with the
performance.
Also, make sure your HD's aren't full... that will kill performance
very quickly if the needed disk space isn't there.
Erik
On Jan 3, 2008, at 3:44 PM, Gunnar R. wrote:
Hello
, except that it seems I can now be sure that it's the phpBB board
that's causing the problems. Not a lot of other processes, and they're
sleeping.
Anyone wanna explain what else to look for?
Cheers,
Gunnar R.
On ons, januar 2, 2008, 07:10, Ady Wicaksono wrote:
Hi, please monitor what happened
PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND
2410 mysql 15 0 470m 310m 4464 S 99.9 30.8 4200:25 mysqld
How come the CPUs can have idle time even though mysqld is running at
99.9%, AND there's a processor queue (4.36)?
Cheers,
Gunnar R.
On ons, januar 2, 2008, 13:07, Andrew
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