c,
> 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, Gunna
c,
> 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, Gunna
USER 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:
64 872 pts/0R+ 22:34 0:00 ps aux
[EMAIL PROTECTED] ~]#
-
I don't really know what to look for when it comes to the show-commands in
MySQL, 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 proce
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
