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
> How long does an "ls" command in the database directory take?
less than 1 sec.
----- Original Message -----
From: "Paul DuBois" <paul@stripped>
To: "Jozsa Boti" <jboti@stripped>
Sent: Monday, November 24, 2003 5:36 PM
Subject: Re: SHOW TABLE STATUS without LIKE
> 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
> >> >statements?
> >> There isn't another way.
> >> >There's the SHOW TABLE STATUS command, but if there are many tables
> >> >database this command is very slow, even if a specific table name is
> >> >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?
> 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