SHOW TABLE STATUS

This statement shows various statistics about tables in TiDB. If the statistics appear out of date, it is recommended to run ANALYZE TABLE.

Synopsis

ShowTableStatusStmt

SHOW TABLE STATUS - 图1

ShowLikeOrWhere

SHOW TABLE STATUS - 图2

  1. ShowTableStatusStmt ::=
  2.     "SHOW" "TABLE" "STATUS" ("FROM" Identifier | "IN" Identifier )? ShowLikeOrWhere?
  4. ShowLikeOrWhere ::=
  5.     "LIKE" SimpleExpr
  6. |   "WHERE" Expression

Examples

  1. mysql> CREATE TABLE t1 (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, c1 INT NOT NULL);
  2. Query OK, 0 rows affected (0.11 sec)
  4. mysql> INSERT INTO t1 (c1) VALUES (1),(2),(3),(4),(5);
  5. Query OK, 5 rows affected (0.02 sec)
  6. Records: 5  Duplicates: 0  Warnings: 0
  8. mysql> SHOW TABLE STATUS LIKE 't1'\G
  9. *************************** 1. row ***************************
  10.            Name: t1
  11.          Engine: InnoDB
  12.         Version: 10
  13.      Row_format: Compact
  14.            Rows: 0
  15.  Avg_row_length: 0
  16.     Data_length: 0
  17. Max_data_length: 0
  18.    Index_length: 0
  19.       Data_free: 0
  20.  Auto_increment: 30001
  21.     Create_time: 2019-04-19 08:32:06
  22.     Update_time: NULL
  23.      Check_time: NULL
  24.       Collation: utf8mb4_bin
  25.        Checksum:
  26.  Create_options:
  27.         Comment:
  28. 1 row in set (0.00 sec)
  30. mysql> ANALYZE TABLE t1;
  31. Query OK, 0 rows affected (0.12 sec)
  33. mysql> SHOW TABLE STATUS LIKE 't1'\G
  34. *************************** 1. row ***************************
  35.            Name: t1
  36.          Engine: InnoDB
  37.         Version: 10
  38.      Row_format: Compact
  39.            Rows: 5
  40.  Avg_row_length: 16
  41.     Data_length: 80
  42. Max_data_length: 0
  43.    Index_length: 0
  44.       Data_free: 0
  45.  Auto_increment: 30001
  46.     Create_time: 2019-04-19 08:32:06
  47.     Update_time: NULL
  48.      Check_time: NULL
  49.       Collation: utf8mb4_bin
  50.        Checksum:
  51.  Create_options:
  52.         Comment:
  53. 1 row in set (0.00 sec)

MySQL compatibility

The SHOW TABLE STATUS statement in TiDB is fully compatible with MySQL. If you find any compatibility differences, report a bug.

See also