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; |