Re: Optimize Table and Flush Table contention on different databases

[Aftab Khan]

I understand restarting mysql is not the solution. what is value of max_connections? as table_cache is related to max_connections.
For example, for 200 concurrent running connections, you should have a table cache size of at least 200 × N, where N is the maximum number of tables per join in any of the queries which you execute.

Note: You also have to take into account that the MyISAM storage engine needs two file descriptors for each unique open table and you may need to increase open_files_limit.

Use this command to check the status of open_files, opened_tables.
mysql> show global status like 'open%'