As our file descriptor does not allow to increase the table_cache is there any other way to decrease the occurence of opened_table ?
--- On Fri, 13/8/10, Gavin Towey <gto...@ffn.com> wrote: From: Gavin Towey <gto...@ffn.com> Subject: RE: opened_table status To: "jitendra ranjan" <jitendra_ran...@yahoo.com>, "mysql@lists.mysql.com" <mysql@lists.mysql.com> Date: Friday, 13 August, 2010, 12:06 AM You don't need to flush tables, just increase the table_cache. -----Original Message----- From: jitendra ranjan [mailto:jitendra_ran...@yahoo.com] Sent: Thursday, August 12, 2010 10:55 AM To: mysql@lists.mysql.com Subject: opened_table status Hi, I have opened_table status is too high but i don't want increase the value of table_cache and also dont want to flush table because it will reset the query cache. Now my question is how can i decrease the opened_table status ? Thanks in advance Jeetendra Ranjan MySQL DBA This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you are notified that reviewing, disseminating, disclosing, copying or distributing this e-mail is strictly prohibited. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any loss or damage caused by viruses or errors or omissions in the contents of this message, which arise as a result of e-mail transmission. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089, USA, FriendFinder.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=jitendra_ran...@yahoo.com