Slow SHOW TABLE STATUS
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.
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.