Debian Codegraph @

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

raw
1 set use_stat_tables='preferably';
2 CREATE TABLE t1(
3 class INT,
4 id INT,
5 title VARCHAR(100)
6 ) ENGINE=InnoDB;
7 insert into t1 select seq, seq, concat('a', seq) from seq_1_to_500;
8 SELECT COUNT(*) FROM t1;
9 COUNT(*)
10 500
11 set @@max_heap_table_size=16384;
12 ANALYZE TABLE t1;
13 Table Op Msg_type Msg_text
14 test.t1 analyze status Engine-independent statistics collected
15 test.t1 analyze status OK
16 DROP TABLE t1;