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 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. >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: >key buffer size 8388600 I'd look at http://dev.mysql.com/doc/mysql/en/Server_system_variables.html as a first cut. You'll get a lot of benefit out of these and optimizing queries. Good luck, Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
