From: dbrb2002-sql
Date: February 27 2009 9:19am
Subject: MySQL Closing/Opening tables
List-Archive: http://lists.mysql.com/mysql/216502
Message-Id: <646950.83904.qm@web31814.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-728681590-1235726358=:83904"

--0-728681590-1235726358=:83904
Content-Type: text/plain; charset=us-ascii

Hi

Recently I noticed the server takes lot of time on and off when opening and closing tables. And I tried to increase the table_cache more the the total tables (file_limit is properly set); and the problem still continues and lowering it also continues.. and tried to set in middle.. same

Any thoughts on fixing this ? I am going crazy..

Sometimes the threads spin 10-60secs in just opening and closing tables state..

Thanks for reply
Rick
--0-728681590-1235726358=:83904--