1
SET DEFAULT_STORAGE_ENGINE='tokudb';
3
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1 (a int, b int, c int, z int, y int, x int, r int, s int, t int, primary key (a,b), key (z), key(x), key(t));
5
id select_type table type possible_keys key key_len ref rows Extra
6
1 SIMPLE t1 index NULL foo 10 NULL 10 Using index
18
id select_type table type possible_keys key key_len ref rows Extra
19
1 SIMPLE t1 ALL NULL NULL NULL NULL 10
21
1 9 18 10 100 1000 2 3 4
22
2 8 16 20 200 2000 4 6 8
23
3 7 14 30 300 3000 6 9 12
24
4 6 12 40 400 4000 8 12 16
25
5 5 10 50 500 5000 10 15 20
26
6 4 8 60 600 6000 12 18 24
27
7 3 6 70 700 7000 14 21 28
28
8 2 4 80 800 8000 16 24 32
29
9 1 2 90 900 9000 18 27 36
30
10 0 0 100 1000 10000 20 30 40
31
id select_type table type possible_keys key key_len ref rows Extra
32
1 SIMPLE t1 index NULL bar 10 NULL 10 Using index
44
id select_type table type possible_keys key key_len ref rows Extra
45
1 SIMPLE t1 ALL NULL NULL NULL NULL 10
47
1 9 18 10 100 1000 2 3 4
48
2 8 16 20 200 2000 4 6 8
49
3 7 14 30 300 3000 6 9 12
50
4 6 12 40 400 4000 8 12 16
51
5 5 10 50 500 5000 10 15 20
52
6 4 8 60 600 6000 12 18 24
53
7 3 6 70 700 7000 14 21 28
54
8 2 4 80 800 8000 16 24 32
55
9 1 2 90 900 9000 18 27 36
56
10 0 0 100 1000 10000 20 30 40