SHOW TABLE STATUS

The SHOW TABLE STATUS command shows status information on tables in a SingleStore database.

Syntax

SHOW TABLE STATUS [{FROM | IN} db_name]

Remarks

  • {FROM | IN} db_name specifies the name of a SingleStore 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 (refer to Node Requirements for SingleStore Commands).

Output

Column

Description

Check_time

Default is null, used as a placeholder for MySQL compatibility.

Engine

SingleStore engine image name.

Version

Engine version.

Row_format

Shows whether the table is a sparse compressed rowstore table.

Rows

Number of rows in the table.

Avg_row_length

Average memory used per row in the table and is calculated as Data_length / Rows.

Data_length

Total memory used for a table.

Max_data_length

Maximum data length. Default is null, used as a placeholder for MySQL compatibility.

Index_length

Index length. Default is null, used as a placeholder for MySQL compatibility.

Data_free

Data free. Default is null, used as a placeholder for MySQL compatibility.

Auto_increment

Default is null, used as a placeholder for MySQL compatibility.

Create_time

Table creation date and time.

Update_time

Update time.

Check_time

Default is null, used as a placeholder for MySQL compatibility.

Collation

Takes the default value as per the character set and collation engine variables. Refer to Character Encoding for related information.

Checksum

Default is null, used as a placeholder for MySQL compatibility.

Create_options

Default is null, used as a placeholder for MySQL compatibility.

Comment

Comments.

BuffMgr Memory Use

Buffer manager memory in use (in bytes).

Average GC Duration (ms)

Average duration of garbage collection (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

Last modified:

Was this article helpful?