From: Johan De Meersman Date: February 10 2011 2:58pm Subject: Re: High disk usage List-Archive: http://lists.mysql.com/mysql/224361 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0015174c100003d253049beecf33 --0015174c100003d253049beecf33 Content-Type: text/plain; charset=ISO-8859-1 On Thu, Feb 10, 2011 at 2:15 PM, Santiago Soares wrote: > With a show global status I see a strange behavior: > | Open_files | 286 | > | Opened_files | 1050743 | > > At this time the database has just started (about 10 minutes). > That's quite a lot for ten minutes, yes. Increasing the open table cache, query cache and/or index cache might help, depending on data size, table types (I'd assume mostly InnoDB based off your pool size), et cetera. Basically it's a matter of finding out why you open and close so many files, as that's likely to be one of the causes of the I/O waits. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --0015174c100003d253049beecf33--