show table status return empty set

Posted on 2007-10-17
Last Modified: 2012-06-21
Below, the show table status returns an empty set when I think it shouldn't
Can anyone explain?

mysql> use mydb
Database changed
mysql> show tables;
| Tables_in_mydb |
| loans_table         |
1 row in set (0.03 sec)

mysql> show table status;
Empty set (0.06 sec)

mysql> show table status from mydb;
Empty set (0.00 sec)
Question by:allelopath
    LVL 17

    Accepted Solution

    Very strange... Try issuing:
    CHECK TABLE loans_table;

    If it reports any errors, then call:
    OPTIMIZE TABLE loans_table;

    If CHECK TABLE does not return any erros, could you post here the results of the following queries:
    EXPLAIN loans_table;
    SELECT * FROM loans_table LIMIT 1;
    LVL 1

    Author Comment

    I was seeing other funny things, so I ended up just deleted everything and starting over (No big deal, still very much in the experimental phase). but thanks for your response.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
    I have been using r1soft Continuous Data Protection ( for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now