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?
lnriveraAsked:
Who is Participating?
 
Muhammad WasifConnect With a Mentor Commented:
What information do you need in SHOW TABLE STATUS output? I believe you can get the same information from INFORMATION_SCHEMA.
0
 
Muhammad WasifCommented:
Normally for a single table you do
SHOW TABLE STATUS LIKE 'table'

Open in new window

Did you try this?
0
 
lnriveraAuthor Commented:
Yes, but the table is a innodb and take a lot of time to resolve it
0
 
Muhammad WasifCommented:
This slowness seems to be due to transactions or READ LOCKs as mentioned here.

Which MySQL version do you have?
0
 
lnriveraAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.