List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:February 28 2009 2:55am
Subject:Re: MySQL Closing/Opening tables
View as plain text  
In the last episode (Feb 27), dbrb2002-sql@stripped said:
> Thanks Dan.. thats a valuable point.. and this actually happening with
> MyISAM tables only..
> 
> But the question is; when I set the table_cache to higher than total
> tables..  then it should stop closing the table in first place..so that
> only un-opened tables will be opened and kept in cache..  it will avoid
> closing and re-opening..  but looks like it is not the case..

Even though the State column says "closing tables", it's just flushing dirty
key blocks.  I bet if you ran "show status like 'Opened_tables'" you
wouldn't see that number increment at all.

-- 
	Dan Nelson
	dnelson@stripped
Thread
MySQL Closing/Opening tablesdbrb2002-sql27 Feb
  • Re: MySQL Closing/Opening tablesBaron Schwartz27 Feb
    • Re: MySQL Closing/Opening tablesWm Mussatto27 Feb
    • Re: MySQL Closing/Opening tablesdbrb2002-sql27 Feb
      • Re: MySQL Closing/Opening tablesWm Mussatto27 Feb
      • Re: MySQL Closing/Opening tablesBaron Schwartz28 Feb
  • Re: MySQL Closing/Opening tablesDan Nelson27 Feb
    • Re: MySQL Closing/Opening tablesdbrb2002-sql27 Feb
      • Re: MySQL Closing/Opening tablesEric Bergen28 Feb
      • Re: MySQL Closing/Opening tablesDan Nelson28 Feb