Outdated Version
You are viewing an older version of this section. View current production version.
SHOW TABLE STATUS
Show tables status information in a MemSQL database.
Syntax
SHOW TABLE STATUS [{FROM | IN} db_name]
Remarks
db_name
is the name of a MemSQL 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 MemSQL node (see Node Requirements for MemSQL 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
memsql> 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)