If things were that easy, there probably wouldn't be a DBA job title.
Tuning a database requires knowledge of the data, how it is accessed
and what variables will affect those access patterns. There are some
basic formulas for speeding up a typical database with typical access
patterns.
If you
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
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
