SET @@GLOBAL.innodb_stats_sample_pages=30000;
SET @@GLOBAL.innodb_stats_on_metadata=OFF;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1(id INT NOT NULL PRIMARY KEY, data TEXT) ENGINE=InnoDB;
INSERT INTO t1 VALUES(1, '');
INSERT INTO t1 VALUES(2, '');
DELETE FROM t1 WHERE id = 2;
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
test.t1 analyze status OK
SHOW INDEXES IN t1;
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
t1 0 PRIMARY 1 id A 2 NULL NULL BTREE
DROP TABLE t1;
CREATE TABLE t1(id INT NOT NULL PRIMARY KEY, data TEXT) ENGINE=InnoDB;
INSERT INTO t1 VALUES(1, '');
INSERT INTO t1 VALUES(2, '');
DELETE FROM t1 WHERE id = 2;
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
test.t1 analyze status OK
SHOW INDEXES IN t1;
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
t1 0 PRIMARY 1 id A 2 NULL NULL BTREE
DROP TABLE t1;
SET @@GLOBAL.innodb_stats_sample_pages=default;
SET @@GLOBAL.innodb_stats_on_metadata=default;
MySQL 5.5 output:
SET @@GLOBAL. innodb_ stats_sample_ pages=30000; innodb_ stats_on_ metadata= OFF; innodb_ stats_sample_ pages=default; innodb_ stats_on_ metadata= default;
SET @@GLOBAL.
DROP TABLE IF EXISTS t1;
CREATE TABLE t1(id INT NOT NULL PRIMARY KEY, data TEXT) ENGINE=InnoDB;
INSERT INTO t1 VALUES(1, '');
INSERT INTO t1 VALUES(2, '');
DELETE FROM t1 WHERE id = 2;
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
test.t1 analyze status OK
SHOW INDEXES IN t1;
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
t1 0 PRIMARY 1 id A 2 NULL NULL BTREE
DROP TABLE t1;
CREATE TABLE t1(id INT NOT NULL PRIMARY KEY, data TEXT) ENGINE=InnoDB;
INSERT INTO t1 VALUES(1, '');
INSERT INTO t1 VALUES(2, '');
DELETE FROM t1 WHERE id = 2;
ANALYZE TABLE t1;
Table Op Msg_type Msg_text
test.t1 analyze status OK
SHOW INDEXES IN t1;
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
t1 0 PRIMARY 1 id A 2 NULL NULL BTREE
DROP TABLE t1;
SET @@GLOBAL.
SET @@GLOBAL.