List:General Discussion« Previous MessageNext Message »
From:Mikhail Entaltsev Date:November 24 2003 4:54pm
Subject:Re: SHOW TABLE STATUS without LIKE
View as plain text  
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
>

Thread
SHOW TABLE STATUS without LIKEJozsa Boti21 Nov
  • How to join tables using pack_isammathan21 Nov
  • Re: SHOW TABLE STATUS without LIKEPaul DuBois21 Nov
  • Re: SHOW TABLE STATUS without LIKEMikhail Entaltsev24 Nov
  • Re: SHOW TABLE STATUS without LIKEJozsa Boti25 Nov
    • Re: SHOW TABLE STATUS without LIKEEd Leafe25 Nov
    • Re: SHOW TABLE STATUS without LIKEPaul DuBois25 Nov
Re: SHOW TABLE STATUS without LIKEPaul DuBois24 Nov