Skip to content

Instantly share code, notes, and snippets.

@mdcallag
Created December 1, 2016 03:31
Show Gist options
  • Save mdcallag/bd47d712802a281b44a5b939ff697cff to your computer and use it in GitHub Desktop.
Save mdcallag/bd47d712802a281b44a5b939ff697cff to your computer and use it in GitHub Desktop.
# mysql -uroot -ppw test -e 'show indexes from sbtest1\G'
*************************** 1. row ***************************
Table: sbtest1
Non_unique: 0
Key_name: PRIMARY
Seq_in_index: 1
Column_name: id
Collation: A
Cardinality: 0
Sub_part: NULL
Packed: NULL
Null:
Index_type: BTREE
Comment:
Index_comment:
*************************** 2. row ***************************
Table: sbtest1
Non_unique: 1
Key_name: k_1
Seq_in_index: 1
Column_name: k
Collation: A
Cardinality: 0
Sub_part: NULL
Packed: NULL
Null:
Index_type: BTREE
Comment:
Index_comment:
# mysql -uroot -ppw test -e 'show table status\G'
*************************** 1. row ***************************
Name: sbtest1
Engine: TokuDB
Version: 10
Row_format: tokudb_uncompressed
Rows: 0
Avg_row_length: 0
Data_length: 15200000000
Max_data_length: 9223372036854775807
Index_length: 719999514
Data_free: 7711105022
Auto_increment: 80000001
Create_time: 2016-11-30 17:36:53
Update_time: 2016-11-30 19:26:34
Check_time: NULL
Collation: latin1_swedish_ci
Checksum: NULL
Create_options: max_rows=1000000 row_format=TOKUDB_UNCOMPRESSED
Comment:
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment