Debian Codegraph @

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

raw
1 #
2 # BUG#22385442 - INNODB: DIFFICULT TO FIND FREE BLOCKS IN THE BUFFER POOL
3 #
4
5 --source include/big_test.inc
6 # Disable in valgrind because of timeout, cf. Bug#22755816
7 --source include/not_valgrind.inc
8
9 DELIMITER |;
10 CREATE PROCEDURE populate_t1()
11 BEGIN
12 DECLARE i int DEFAULT 1;
13
14 START TRANSACTION;
15 WHILE (i <= 1000000) DO
16 INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
17 SET i = i + 1;
18 END WHILE;
19 COMMIT;
20 END|
21 DELIMITER ;|
22
23 CREATE TABLE t1(
24 class INT,
25 id INT,
26 title VARCHAR(100)
27 ) ENGINE=InnoDB;
28
29 -- disable_query_log
30 CALL populate_t1();
31 -- enable_query_log
32
33 SELECT COUNT(*) FROM t1;
34
35 SET GLOBAL innodb_stats_persistent_sample_pages=2000;
36
37 ANALYZE TABLE t1;
38
39 DROP TABLE t1;
40
41 DROP PROCEDURE populate_t1;
42
43 SET GLOBAL innodb_stats_persistent_sample_pages=default;