List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:February 27 2009 1:50pm
Subject:Re: MySQL Closing/Opening tables
View as plain text  
On Fri, Feb 27, 2009 at 4:19 AM,  <dbrb2002-sql@stripped> 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
Thread
MySQL Closing/Opening tablesdbrb2002-sql27 Feb
  • Re: MySQL Closing/Opening tablesBaron Schwartz27 Feb
    • Re: MySQL Closing/Opening tablesWm Mussatto27 Feb
    • Re: MySQL Closing/Opening tablesdbrb2002-sql27 Feb
      • Re: MySQL Closing/Opening tablesWm Mussatto27 Feb
      • Re: MySQL Closing/Opening tablesBaron Schwartz28 Feb
  • Re: MySQL Closing/Opening tablesDan Nelson27 Feb
    • Re: MySQL Closing/Opening tablesdbrb2002-sql27 Feb
      • Re: MySQL Closing/Opening tablesEric Bergen28 Feb
      • Re: MySQL Closing/Opening tablesDan Nelson28 Feb