On Thu, Feb 10, 2011 at 2:15 PM, Santiago Soares <santiagosoa...@gmail.com>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