SHOW TABLE STATUS

Syntax

SHOW TABLE STATUS [{FROM | IN} db_name]

Remarks

db_name is 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 (see 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 MySQLcompatibility
`Collation`	Takes the default value as per the character set and collation engine variables. By default it is `utf8_general_ci`.
`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
1 row in set (0.00 sec)

On this page

Syntax

Remarks

Example

Was this article helpful?

On this page

Was this article helpful?