MySQL Forums
Forum List  »  InnoDB

Slow SHOW TABLE STATUS
Posted by: Josep Maria
Date: March 15, 2005 03:11AM

Hello, I have a Innodb database with 207 tables. Some of these tables are big (45M)

When I execute the command SHOW TABLE STATUS it's very slow, 45 secons to respond, anybody know why ?

Some client programs, after connect, if the user select a table in the list of tables, the command SHOW TABLE STATUS execute and it's very slow too.

What is the reason ? Exists a solution ?

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Slow SHOW TABLE STATUS
3976
March 15, 2005 03:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.