List:General Discussion« Previous MessageNext Message »
From:Gavin Towey Date:August 12 2010 6:36pm
Subject:RE: opened_table status
View as plain text  
You don't need to flush tables, just increase the table_cache.

-----Original Message-----
From: jitendra ranjan [mailto:jitendra_ranjan@stripped]
Sent: Thursday, August 12, 2010 10:55 AM
To: mysql@stripped
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
Thread
opened_table statusjitendra ranjan12 Aug
  • RE: opened_table statusGavin Towey12 Aug
    • RE: opened_table statusjitendra ranjan12 Aug