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 :
http://www.databasejournal.com/features/mysql/article.php/10897_1402311_3
---------------------------------------------------
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.
Thanks