mysql-test/suite/innodb/r/innodb_stats_external_pages.result
raw| 1 | CREATE TABLE bug18384390 ( |
| 2 | id INT AUTO_INCREMENT PRIMARY KEY, |
| 3 | txt VARCHAR(10000) |
| 4 | ) ENGINE=INNODB STATS_PERSISTENT=1 STATS_AUTO_RECALC=0; |
| 5 | INSERT INTO bug18384390 (txt) SELECT REPEAT('0', 10000) FROM seq_1_to_1024; |
| 6 | set use_stat_tables=never; |
| 7 | ANALYZE TABLE bug18384390; |
| 8 | Table Op Msg_type Msg_text |
| 9 | test.bug18384390 analyze status OK |
| 10 | DROP TABLE bug18384390; |