Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Nico Sabbi (nicola.sabbiposte.it)
Date: Tue Apr 28 2009 - 16:17:53 CDT
Il giorno mar, 28/04/2009 alle 17.11 -0400, Baron Schwartz ha scritto:
> On Tue, Apr 28, 2009 at 1:04 PM, Rolando Edwards
> <redwardslogicworks.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.
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
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql