Hello, thanks for your answers. All of my tables are MyISAM. I found out that the application runs a lot of 'show tables' commands. These commands take a lot of time to run, due to the high number of tables (~160k). Is there anything I can do to make 'show tables' run faster?
Santiago Soares Fone: (41) 8488-0537 On Thu, Feb 10, 2011 at 12:58 PM, Johan De Meersman <vegiv...@tuxera.be>wrote: > 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 >
