Hello.
Table cache formula is present at: http://dev.mysql.com/doc/mysql/en/table-cache.html Usually key_buffer should be as big as possible, to be able to store a lot of index blocks. If you're using group by queries increasing a tmp_table_size might be helpful. Stephen More <[EMAIL PROTECTED]> wrote: > Is there a good place/book to lookup formulas for tunning mysql ? > > What size should the table_cache be ? I have 2,770 tables.... > > What size should the key_buffer be ? I am only using 38 MB out of 265 > MB, yet my Index Length reported by mysql-administrator is 2.72 G > > Total number of records are 61 Million Rows. > Most queries will be select on primary key, or group by primary key. > > Any help is appreciated. > -Steve More > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]