Debian Codegraph @

mysql-test/suite/innodb/r/analyze_table.result

raw
1 CREATE PROCEDURE populate_t1()
2 BEGIN
3 DECLARE i int DEFAULT 1;
4 START TRANSACTION;
5 WHILE (i <= 1000000) DO
6 INSERT INTO t1 VALUES (i, i, CONCAT('a', i));
7 SET i = i + 1;
8 END WHILE;
9 COMMIT;
10 END|
11 CREATE TABLE t1(
12 class INT,
13 id INT,
14 title VARCHAR(100)
15 ) ENGINE=InnoDB;
16 SELECT COUNT(*) FROM t1;
17 COUNT(*)
18 1000000
19 SET GLOBAL innodb_stats_persistent_sample_pages=2000;
20 ANALYZE TABLE t1;
21 Table Op Msg_type Msg_text
22 test.t1 analyze status OK
23 DROP TABLE t1;
24 DROP PROCEDURE populate_t1;
25 SET GLOBAL innodb_stats_persistent_sample_pages=default;