--- 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 on a single thread
> >and is not capable of utilizing both the
> processors.
> >(please correct me if i am wrong).
>
> MySQL uses both processors on a G5 if more than one
> query is running.
> If there is only a single query running it is
> limited to one processor.
> So I don't think running multiple instances makes
> sense.
ok.
>
> >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:
I was in a view that if the key index size is more
than the available memory there is no point in
increasing the key buffer size since anyway it will
use the disk read. If I am wrong, could you suggest me
a value for this?
Thanks again
Kareen
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
