Hi all,
System details:
PowerMac G5 1.6 GHz dual processor
3 G RAM
Mac OS X (10.3.4)
Application : MYSQL (mysql Ver 12.20 Distrib 4.0.13,
for apple-darwin6.6 (powerpc)) + APPACHE
I have couple of database on a single installation of
MySQL. One of these databases is static (only selects)
and i
--- Ware Adams <[EMAIL PROTECTED]> wrote:
>
> >sort buffer size 2097144
> >join buffer size 131072
> >max heap table size 16777216
> >max join size 4294967295
> >max sort length 1024
> >myisam max sort file size 2147483647
> >myisam sort buffer size 8388608
> >
> >Upto my understanding mysql runs
> If your not using the cpu fully, you definitely need
> to optimize
> mysqld's settings and/or optimize your queries.
> Even if the cpu is
> running full out, optimizing queries to examine
> fewer rows can help.
Yes Ware, the CPU is not fully utilized. It shows just
10 -15% utilization. Could y
