On Fri, Feb 27, 2009 at 4:19 AM, <dbrb2002-sql@stripped> wrote:
> 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