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
> wrote:
> > Make sure the tables that the information_schema are not locked.
> >
> > This is because MyISAM tables, that are constantly being inserted into
> > (Each
Hi,
On Tue, Apr 28, 2009 at 1:04 PM, Rolando Edwards
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_
: RolandoLogicWorx
redwa...@logicworks.net
-Original Message-
From: Nico Sabbi [mailto:nicola.sa...@poste.it]
Sent: Tuesday, April 28, 2009 10:05 AM
To: MySql
Subject: Extremely slow access to information_schema
Hi,
in Mysql 5.0 accessing information_schema.tables means almost
certainly
Hi,
in Mysql 5.0 accessing information_schema.tables means almost
certainly dropping down the DBMS.
With my configuration
412 databases
357417 grants
every query to information_schema.tables takes minutes, while the
equivalent show tables from... (that I can't absolutely use)
is immediate.
Is
