Debian Codegraph @

mysql-test/suite/innodb/t/innodb_stats_auto_recalc_lots.test

raw
1 #
2 # Test the persistent stats auto recalc on lots of tables
3 #
4
5 --source include/no_valgrind_without_big.inc
6 -- source include/have_innodb.inc
7
8 let $check_stats = SELECT table_name, n_rows FROM mysql.innodb_table_stats WHERE table_name LIKE 'ar_%' ORDER BY table_name;
9
10 -- disable_query_log
11 let $i = 1200;
12 while ($i > 1000) {
13 eval CREATE TABLE ar_$i (a INT, PRIMARY KEY (a)) ENGINE=INNODB;
14 dec $i;
15 }
16 -- enable_query_log
17
18 # the CREATEs above should have inserted zeroed stats
19 -- eval $check_stats
20
21 -- disable_query_log
22 let $i = 1200;
23 while ($i > 1000) {
24 eval INSERT INTO ar_$i VALUES (1), (2);
25 dec $i;
26 }
27 -- enable_query_log
28
29 -- disable_query_log
30 let $i = 1200;
31 while ($i > 1000) {
32 eval INSERT INTO ar_$i VALUES (3), (4);
33 dec $i;
34 }
35 -- enable_query_log
36
37 # would be too long to wait for stats to become up to date here
38
39 -- disable_query_log
40 let $i = 1200;
41 while ($i > 1000) {
42 eval DROP TABLE ar_$i;
43 dec $i;
44 }
45 -- enable_query_log