MySQL Forums
Forum List  »  MyISAM

Re: Optimize Table and Flush Table contention on different databases
Posted by: Aftab Khan
Date: December 10, 2009 03:19AM

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%'

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Optimize Table and Flush Table contention on different databases
2651
December 10, 2009 03:19AM


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.