Link to home
Start Free TrialLog in
Avatar of Luis N
Luis NFlag for Spain

asked on

How to increase speed "SHOW TABLE STATUS FROM table" in a innodb table

When I launch SHOW TABLE STATUS FROM tablename, in a innodb table, the results take more than 1 minute.

How can I increase the speed of this sentence?
Avatar of Muhammad Wasif
Muhammad Wasif
Flag of Pakistan image

Normally for a single table you do
SHOW TABLE STATUS LIKE 'table'

Open in new window

Did you try this?
Avatar of Luis N

ASKER

Yes, but the table is a innodb and take a lot of time to resolve it
This slowness seems to be due to transactions or READ LOCKs as mentioned here.

Which MySQL version do you have?
Avatar of Luis N

ASKER

We have 5.5, and the "show table status" are running in a server without any another connections (Only for test), the question is that the table is a big innod table with thousands of records
ASKER CERTIFIED SOLUTION
Avatar of Muhammad Wasif
Muhammad Wasif
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial