You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

SHOW TABLE STATUS

Show tables status information in a MemSQL database.

Syntax

SHOW TABLE STATUS [{FROM | IN} db_name]

Remarks

  • db_name is the name of a MemSQL 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 MemSQL node (see Node Requirements for MemSQL 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

memsql> 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)