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 wrote:
From: Gavin Towey
Subject: RE: opened_table status
To: "jitendra ranjan" , "mysql@lists.mysql.com"
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
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
