On Fri, Feb 27, 2009 at 4:19 AM, <dbrb2002-...@yahoo.com> wrote: > 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..
Have you checked to see if your disk is saturated with requests? Try this: vmstat 5 5 iostat -dx 5 5 Assuming you're on a Unix-like OS. -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org