33 lines
916 B
Plaintext
33 lines
916 B
Plaintext
--source include/force_myisam_default.inc
|
|
--source include/have_myisam.inc
|
|
--source include/master-slave.inc
|
|
--echo [Connection Master]
|
|
--connection master
|
|
|
|
--echo # Creation of invisible indexes on MyISAM tables
|
|
|
|
CREATE TABLE t1 (i INT, KEY(i) INVISIBLE) ENGINE=MYISAM;
|
|
INSERT INTO t1 VALUES (2),(3),(5),(7),(11);
|
|
ANALYZE TABLE t1;
|
|
--source include/sync_slave_sql_with_master.inc
|
|
--echo [Connection Slave]
|
|
SHOW INDEXES FROM t1;
|
|
EXPLAIN SELECT i FROM t1;
|
|
--echo [Connection Master]
|
|
--connection master
|
|
--echo # Make index visible
|
|
ALTER TABLE t1 ALTER INDEX i INVISIBLE, ALTER INDEX i VISIBLE, ALTER INDEX i VISIBLE;
|
|
ANALYZE TABLE t1;
|
|
--source include/sync_slave_sql_with_master.inc
|
|
--echo [Connection Slave]
|
|
SHOW INDEXES FROM t1;
|
|
EXPLAIN SELECT i FROM t1;
|
|
--echo [Connection Master]
|
|
--connection master
|
|
--echo # Clean up
|
|
|
|
DROP TABLE t1;
|
|
|
|
--source include/sync_slave_sql_with_master.inc
|
|
--source include/rpl_end.inc
|