show table status return empty set

Posted on 2007-10-17
Medium Priority
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

Aleksandar Bradarić earned 2000 total points
ID: 20094025
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;

Author Comment

ID: 20094456
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month13 days, 15 hours left to enroll

809 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