MySQL Forums :: Optimizer & Parser :: optimization with table_cache

Advanced Search

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

Subject Views Written By Posted
optimization with table_cache 49335 rei 09/05/2006 09:17PM
Re: optimization with table_cache 20131 sneakyimp 12/18/2006 10:40PM
Re: optimization with table_cache 19934 Björn Steinbrink 12/20/2006 02:37AM
Re: optimization with table_cache 19544 Björn Steinbrink 12/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.