Hi,
I have noticed also that SHOW TABLE STATUS became slower in 5 times at least
(from 1 sec to 5-6 secs).
Since I've switched to version 3.23.53 to version 4.0.14.
But I have changed type of all my tables (~30 tables) from MyISAM to InnoDB
as well.
> How long does an "ls" command in the database directory take?
less than 1 sec.
Thanks,
Mikhail.
----- Original Message -----
From: "Paul DuBois" <paul@stripped>
To: "Jozsa Boti" <jboti@stripped>
Cc: <mysql@stripped>
Sent: Monday, November 24, 2003 5:36 PM
Subject: Re: SHOW TABLE STATUS without LIKE
> >Hi!
>
> Please reply to the list, not to me personally, so that others can
> follow this discussion. Thanks.
>
> >
> >
> >
> >> At 13:21 +0200 11/21/03, Jozsa Boti wrote:
> >> >Hi!
> >> >
> >> >How an i get the last Check-time of a specific table without using
LIKE
> >> >statements?
> >>
> >> There isn't another way.
> >>
> >> >There's the SHOW TABLE STATUS command, but if there are many tables
in a
> >> >database this command is very slow, even if a specific table name is
> >after
> >> >the LIKE statment.
> >>
> >> Slow? How many tables are we talking about?
> >>
> >
> >I'm talking about nearly 20 000 tables in a database.
> >In this case a SHOW TABLE STATUS commande takes about 20-30 seconds.
>
> Hm, that is pretty slow. How long does an "ls" command in the database
> directory take?
>
> >
> >Thanks,
> >Boti
>
>
> --
> Paul DuBois, Senior Technical Writer
> Madison, Wisconsin, USA
> MySQL AB, www.mysql.com
>
> Are you MySQL certified? http://www.mysql.com/certification/
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
