Re: SHOW TABLE STATUS without LIKE

[Paul DuBois]

At 8:10 +0200 11/25/03, Jozsa Boti wrote:
 > >Hi!
 Please reply to the list, not to me personally, so that others can
 follow this discussion.  Thanks.


Sorry,
No apology required.  It's just that others may have something to
contribute.
I was able to duplicate your results and raised the question with
the developers.  An inefficiency was identified with memory allocation
for this particular situation. I have filed a bug report. You can track
its status here:
http://bugs.mysql.com/bug.php?id=1952





 >
 >
 >
 >>  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?
About 1-2 seconds.

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]