In the last episode (Feb 27), [email protected] 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
[email protected]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
