In the last episode (Feb 27), dbrb2002-...@yahoo.com 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 dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org