blob: 82ceda1914d33e7dc8e52c8b18954c6a002a9bb3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
let $max_table = 2;
--disable_query_log
let $table = 1;
while ($table <= $max_table) {
let $max = 9;
let $i = 2;
while ($i <= $max) {
let $insert = INSERT INTO t$table VALUES ($i, $i, $i);
eval $insert;
inc $i;
}
inc $table;
}
--enable_query_log
let $table = 1;
while ($table <= $max_table) {
let $i = 1;
let $j = 9;
while ($i <= $max) {
let $insert = INSERT INTO t$table VALUES ($i, $i, $i) ON DUPLICATE KEY UPDATE id2 = $j;
eval $insert;
let $select = SELECT * FROM t$table WHERE id1 = $i;
eval $select;
let $select = SELECT * FROM t$table FORCE INDEX (id3) WHERE id3 = $i;
eval $select;
inc $j;
let $insert = INSERT INTO t$table VALUES ($i, $i, $i) ON DUPLICATE KEY UPDATE id2 = $j;
eval $insert;
let $select = SELECT * FROM t$table WHERE id1 = $i;
eval $select;
let $select = SELECT * FROM t$table FORCE INDEX (id3) WHERE id3 = $i;
eval $select;
inc $j;
let $insert = INSERT INTO t$table VALUES ($i, $i, $i) ON DUPLICATE KEY UPDATE id2 = $j;
eval $insert;
let $select = SELECT * FROM t$table WHERE id1 = $i;
eval $select;
let $select = SELECT * FROM t$table FORCE INDEX (id3) WHERE id3 = $i;
eval $select;
inc $j;
inc $i;
inc $i;
inc $i;
inc $i;
}
let $select = SELECT * FROM t$table;
eval $select;
let $select = SELECT * FROM t$table FORCE INDEX (id3);
eval $select;
inc $table;
}
|