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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to