SingleStore Managed Service

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