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