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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
