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
VARCHAR
s) 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 |
| Engine |
| Engine version |
| Row format |
| Rows |
| Average row length |
| Data length |
| Maximum data length |
| Index length |
| Data free |
| Auto increment |
| Create time |
| Update time |
| Check time |
| Collation |
| Checksum |
| Create options |
| Comment |
| Buffer manager memory use (in bytes) |
| 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)