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/[EMAIL PROTECTED]

Reply via email to