Kart v wrote:
>>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%
>utilizatio
Kart v wrote:
>>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%
>utilizatio
> 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
You need to first determine what the bottleneck is. If it's disk I/O
that's slowing you down, then adding another instance of MySQL may
actually hurt you. If that table is physically large, it's probably
your disk subsystem holding you back. I don't know what you disk setup
is like. For about $
Kart v wrote:
>>>Also it would be helpful if you could give me some hints on what
>>>system variables to set and what table types to use. After doing the
>>>basic setup, I will play with the queries to optimize them.
>>
>>Your key buffer looks very small, assuming you are using MyISAM
>>tables:
>>
--- 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
Kart v 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 on a single thread
>and is not capable of utili
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
