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: >>key buffer size 8388600
>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? That's true, and swapping will make performance horrible. But your original email said: >PowerMac G5 1.6 GHz dual processor >3 G RAM >Mac OS X (10.3.4) So you have 3 GB RAM and your using only about 8 MB for key_buffer_size. What else is running on the box? If it's only MySQL try cranking up key_buffer_size. If it's only MySQL on the machine, I might start at 1.5 GB. Watch top while your queries are running. You want mydqld at or close to 100% cpu (only one query running) or 200% (2 or more queries running). 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. Good luck, Ware -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
