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" <[EMAIL PROTECTED]> To: "Jozsa Boti" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
