MySQL Forums
Forum List  »  Optimizer & Parser

optimization with table_cache
Posted by: rei
Date: September 05, 2006 09:17PM

I am having a database with more than 100 tables (around 300tables)
It seems we need to make some tuning to the table_cache value for database with a large numbers of tables.
I tried some load test and found that my "open_tables" value reaches "table_cache" values in a short time and "opened_tables" values is increasing after that.
Thus, i guess a "table_cache" tuning is inevitable.

The following statment is a quote from :
table_cache is a useful one. Each time MySQL accesses a table, it places it in the cache.
If your system accesses many tables, it is faster to have these in the cache.
A good way to see whether your system needs to increase this is to examine the value of open_tables at peak times
(one of the extended status values, above).
If you find it stays at the same value as your table_cache value, and then the number of opened_tables starts increasing,
you should increase the table_cache if you have enough memory.

I would like to seek advice on how much value should i set to the table_cache.
Any points that i need to be extra careful in order not to set it too high?
I guess by increasing this value, i need to re-check my "max_connections" value too ?

Any advice or recomended documentations are truly appreciated.


Options: ReplyQuote

Written By
optimization with table_cache
September 05, 2006 09:17PM
December 18, 2006 10:40PM
December 20, 2006 02:37AM
December 20, 2006 02:45AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.