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
