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 M
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
