SHOW TABLE STATUS
Show tables status information in a SingleStoreDB database.
Syntax
SHOW TABLE STATUS [{FROM | IN} db_name]
Remarks
db_name
is the name of a SingleStoreDB database.Shows how much memory this table is using for row data.
Memory for off-row data (such as
VARCHAR
s) is not reported.This command can be run on any SingleStoreDB node (see Node Requirements for SingleStoreDB Commands).
Output
Column | Description |
---|---|
| Default is null, used as a placeholder for MySQL compatibility |
| SingleStoreDB engine image name |
| Engine version |
| Shows whether the table is a sparse compressed rowstore table |
| Number of rows in the table |
| Average memory used per row in the table and is calculated as Data_length / Rows |
| Total memory used for a table |
| Maximum data length. Default is null, used as a placeholder for MySQL compatibility. |
| Index length. Default is null, used as a placeholder for MySQL compatibility. |
| Data free. Default is null, used as a placeholder for MySQL compatibility. |
| Default is null, used as a placeholder for MySQL compatibility. |
| Table creation date and time |
| Update time |
| Default is null, used as a placeholder for MySQLcompatibility |
| Takes the default value as per the character set and collation engine variables. By default it is |
| Default is null, used as a placeholder for MySQL compatibility. |
| Default is null, used as a placeholder for MySQL compatibility. |
| Comments |
| Buffer manager memory in use (in bytes) |
| 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)