Outdated Version

You are viewing an older version of this section. View current production version.

SHOW TABLE STATUS

Show tables status information in a SingleStore DB database.

Syntax

SHOW TABLE STATUS [{FROM | IN} db_name]

Remarks

  • db_name is the name of a SingleStore DB database.
  • Shows how much memory this table is using for row data.
  • Memory for off-row data (such as VARCHARs) is not reported.
  • This command can be run on any SingleStore node (see Node Requirements for SingleStore DB Commands).

Output

Column Description
Check_time Check time
Engine Engine
Version Engine version
Row_format Row format
Rows Rows
Avg_row_length Average row length
Data_length Data length
Max_data_length Maximum data length
Index_length Index length
Data_free Data free
Auto_increment Auto increment
Create_time Create time
Update_time Update time
Check_time Check time
Collation Collation
Checksum Checksum
Create_options Create options
Comment Comment
BuffMgr Memory Use Buffer manager memory use (in bytes)
Average GC Duration (ms) Average GC duration (in milliseconds)

Example

show table status \G
*************************** 1. row ***************************
                    Name: x
                  Engine: MemSQL
                 Version: 10
              Row_format: Uncompressed
                    Rows: 130
          Avg_row_length: NULL
             Data_length: NULL
         Max_data_length: NULL
            Index_length: NULL
               Data_free: NULL
          Auto_increment: NULL
             Create_time: 2014-03-05 16:10:36
             Update_time: NULL
              Check_time: NULL
               Collation: utf8_general_ci
                Checksum: NULL
          Create_options: Not Available
                 Comment: Not Available
      BuffMgr Memory Use: 141472
Average GC Duration (ms): 0
1 row in set (0.00 sec)