From: Wm Mussatto Date: February 27 2009 4:35pm Subject: Re: MySQL Closing/Opening tables List-Archive: http://lists.mysql.com/mysql/216511 Message-Id: <1172.68.164.150.104.1235752503.squirrel@secure2.csz.com> MIME-Version: 1.0 Content-Type: text/plain;charset=UTF-8 Content-Transfer-Encoding: 8bit On Fri, February 27, 2009 05:50, Baron Schwartz wrote: > On Fri, Feb 27, 2009 at 4:19 AM, 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 Slight variant if you use logical volumes. iostat -x 10 /dev/sda /dev/sdb /dev/sdc /dev/sdd /dev/sde Where the /dev/...'s are the actual base disks. W/O the -d you get cpu loads as well. I use top -i (then z for color) if I need to know what processes are running. The is on Debian GNU Linux. Look at the await column: "The average time (in milliseconds) for I/O requests issued to the device to be served. This includes the time spent by the requests in queue and the time spent servicing them. " > 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=mussatto@stripped > > >