Il giorno mar, 28/04/2009 alle 17.11 -0400, Baron Schwartz ha scritto: > Hi, > > On Tue, Apr 28, 2009 at 1:04 PM, Rolando Edwards > <redwa...@logicworks.net> wrote: > > Make sure the tables that the information_schema are not locked. > > > > This is because MyISAM tables, that are constantly being inserted into > > (Each insert, update, delete on a MyISAM table does a table lock), must > > update the TABLE_ROWS column in information_schema.tables to have the > > latest count. > > That's not how INFORMATION_SCHEMA works. Those aren't real tables. > > Behind the scenes it is just doing SHOW TABLE STATUS on each table and > populating a temporary structure with the results. > > Nico, it is my opinion that I_S is not suitable for heavy production > use :-) I have seen several cases of severe performance problems > caused by it. > > Baron
after what I'm seeing I can't avoid to agree completely. I also read of extremely serious DOS problems caused by this crazy (and severely castrated) implementation of the I_S. How did it end up in mainline? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
