52 lines
2.2 KiB
Plaintext
52 lines
2.2 KiB
Plaintext
DROP TABLE IF EXISTS t1;
|
|
create table t1(
|
|
id bigint not null primary key,
|
|
i1 bigint, #unique
|
|
i2 bigint, #repeating
|
|
c1 varchar(20), #unique
|
|
c2 varchar(20), #repeating
|
|
index t1_1(id, i1),
|
|
index t1_2(i1, i2),
|
|
index t1_3(i2, i1),
|
|
index t1_4(c1, c2),
|
|
index t1_5(c2, c1)
|
|
) engine=xengine;
|
|
optimize table t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 optimize status OK
|
|
show index in t1;
|
|
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression
|
|
t1 0 PRIMARY 1 id A 100 NULL NULL SE_SPECIFIC YES NULL
|
|
t1 1 t1_1 1 id A 50 NULL NULL SE_SPECIFIC YES NULL
|
|
t1 1 t1_1 2 i1 A 100 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_2 1 i1 A 25 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_2 2 i2 A 50 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_3 1 i2 A 25 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_3 2 i1 A 50 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_4 1 c1 A 25 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_4 2 c2 A 50 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_5 1 c2 A 25 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_5 2 c1 A 50 NULL NULL YES SE_SPECIFIC YES NULL
|
|
SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE();
|
|
TABLE_NAME TABLE_ROWS
|
|
t1 100
|
|
restarting...
|
|
# restart
|
|
show index in t1;
|
|
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Visible Expression
|
|
t1 0 PRIMARY 1 id A 100 NULL NULL SE_SPECIFIC YES NULL
|
|
t1 1 t1_1 1 id A 50 NULL NULL SE_SPECIFIC YES NULL
|
|
t1 1 t1_1 2 i1 A 100 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_2 1 i1 A 25 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_2 2 i2 A 50 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_3 1 i2 A 25 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_3 2 i1 A 50 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_4 1 c1 A 25 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_4 2 c2 A 50 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_5 1 c2 A 25 NULL NULL YES SE_SPECIFIC YES NULL
|
|
t1 1 t1_5 2 c1 A 50 NULL NULL YES SE_SPECIFIC YES NULL
|
|
SELECT table_name, table_rows FROM information_schema.tables WHERE table_schema = DATABASE();
|
|
TABLE_NAME TABLE_ROWS
|
|
t1 100
|
|
drop table t1;
|