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