RE: opened_table status

2010-08-12 Thread jitendra ranjan
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"

RE: opened_table status

2010-08-12 Thread Gavin Towey
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'