blob: 88ca8910cd25fff73c0e6cf011525a08c084cf95 (
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
|
#
# Test the persistent stats auto recalc on lots of tables
#
--source include/no_valgrind_without_big.inc
-- source include/have_innodb.inc
let $check_stats = SELECT table_name, n_rows FROM mysql.innodb_table_stats WHERE table_name LIKE 'ar_%' ORDER BY table_name;
-- disable_query_log
let $i = 1200;
while ($i > 1000) {
eval CREATE TABLE ar_$i (a INT, PRIMARY KEY (a)) ENGINE=INNODB;
dec $i;
}
-- enable_query_log
# the CREATEs above should have inserted zeroed stats
-- eval $check_stats
-- disable_query_log
let $i = 1200;
while ($i > 1000) {
eval INSERT INTO ar_$i VALUES (1), (2);
dec $i;
}
-- enable_query_log
-- disable_query_log
let $i = 1200;
while ($i > 1000) {
eval INSERT INTO ar_$i VALUES (3), (4);
dec $i;
}
-- enable_query_log
# would be too long to wait for stats to become up to date here
-- disable_query_log
let $i = 1200;
while ($i > 1000) {
eval DROP TABLE ar_$i;
dec $i;
}
-- enable_query_log
|