540 lines
20 KiB
Plaintext
540 lines
20 KiB
Plaintext
#
|
|
# These test make sure that tables are visible after rebooting
|
|
#
|
|
|
|
--source include/have_innodb_max_16k.inc
|
|
|
|
SET default_storage_engine=InnoDB;
|
|
LET $MYSQLD_DATADIR = `select @@datadir`;
|
|
LET $INNODB_PAGE_SIZE = `select @@innodb_page_size`;
|
|
|
|
--disable_query_log
|
|
# This error is expected in the error log for this test.
|
|
call mtr.add_suppression("\\[ERROR\\] Error number 17 means 'File exists'");
|
|
call mtr.add_suppression("\\[ERROR\\] Operating system error number (17|80) in a file operation.");
|
|
call mtr.add_suppression("\\[ERROR\\] The link file: .* already exists.");
|
|
call mtr.add_suppression("\\[ERROR\\] Cannot open datafile for read-only:");
|
|
call mtr.add_suppression("\\[ERROR\\] Operating system error number 2 in a file operation.");
|
|
call mtr.add_suppression("\\[ERROR\\] The error means the system cannot find the path specified.");
|
|
call mtr.add_suppression("\\[ERROR\\] If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.");
|
|
call mtr.add_suppression("\\[Warning\\] Tablespace .*, name 'innodb_file_per_table.*', file '.*alt_dir/move_test/.*\.ibd' has been moved to '.*alt_dir_moved/move_test/.*\.ibd'");
|
|
--enable_query_log
|
|
|
|
--echo #
|
|
--echo # A series of tests to make sure tables are opened after restart.
|
|
--echo # Bug#13357607 Compressed file-per-table tablespaces fail to open
|
|
--echo #
|
|
# This bug was introduced without a regression test failing since
|
|
# there were no tests showing that tablespaces could be created and
|
|
# then read after reboot.
|
|
#
|
|
|
|
--disable_query_log
|
|
|
|
LET $SCHEMA_NAME = move_test;
|
|
LET $MYSQL_DATA_DIR = `select @@datadir`;
|
|
LET $ALT_DIR = $MYSQL_TMP_DIR/alt_dir;
|
|
LET $ALT_DATA_DIR = DATA DIRECTORY='$ALT_DIR';
|
|
LET $ALT_DIR_MOVED = $MYSQL_TMP_DIR/alt_dir_moved;
|
|
|
|
LET $innodb_file_per_table_orig=`select @@innodb_file_per_table`;
|
|
|
|
LET $restart_parameters = restart:--innodb-directories=$ALT_DIR;
|
|
|
|
--enable_query_log
|
|
|
|
eval CREATE DATABASE $SCHEMA_NAME;
|
|
eval USE $SCHEMA_NAME;
|
|
|
|
set global innodb_file_per_table=on;
|
|
|
|
--echo #
|
|
--echo # Create and insert records into a REDUNDANT row formatted table.
|
|
--echo #
|
|
CREATE TABLE t1_restart(c1 DOUBLE AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
|
|
ROW_FORMAT=REDUNDANT ENGINE=InnoDB;
|
|
INSERT INTO t1_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
|
|
INSERT INTO t1_restart (SELECT 0, c2, c3, c4, c5 FROM t1_restart);
|
|
INSERT INTO t1_restart (SELECT 0, c2, c3, c4, c5 FROM t1_restart);
|
|
INSERT INTO t1_restart (SELECT 0, c2, c3, c4, c5 FROM t1_restart);
|
|
INSERT INTO t1_restart (SELECT 0, c2, c3, c4, c5 FROM t1_restart);
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t1_restart;
|
|
SELECT count(*) FROM t1_restart;
|
|
|
|
--echo #
|
|
--echo # Create and insert records into a COMPACT row formatted table.
|
|
--echo #
|
|
CREATE TABLE t2_restart(c1 DOUBLE AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
|
|
ROW_FORMAT=COMPACT ENGINE=InnoDB;
|
|
INSERT INTO t2_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
|
|
INSERT INTO t2_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
|
|
INSERT INTO t2_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
|
|
INSERT INTO t2_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
|
|
INSERT INTO t2_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t2_restart;
|
|
SELECT count(*) FROM t2_restart;
|
|
|
|
--echo #
|
|
--echo # Create and insert records into a COMPRESSED row formatted table.
|
|
--echo #
|
|
CREATE TABLE t3_restart(c1 DOUBLE AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
|
|
ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 ENGINE=InnoDB;
|
|
INSERT INTO t3_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
|
|
INSERT INTO t3_restart (SELECT 0, c2, c3, c4, c5 FROM t3_restart);
|
|
INSERT INTO t3_restart (SELECT 0, c2, c3, c4, c5 FROM t3_restart);
|
|
INSERT INTO t3_restart (SELECT 0, c2, c3, c4, c5 FROM t3_restart);
|
|
INSERT INTO t3_restart (SELECT 0, c2, c3, c4, c5 FROM t3_restart);
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t3_restart;
|
|
SELECT count(*) FROM t3_restart;
|
|
|
|
--echo #
|
|
--echo # Create and insert records into a DYNAMIC row formatted table.
|
|
--echo #
|
|
CREATE TABLE t4_restart(c1 DOUBLE AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
|
|
ROW_FORMAT=DYNAMIC ENGINE=InnoDB;
|
|
INSERT INTO t4_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
|
|
INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
|
|
INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
|
|
INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
|
|
INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t4_restart;
|
|
SELECT count(*) FROM t4_restart;
|
|
|
|
--echo #
|
|
--echo # Create and insert records into a table that uses a remote DATA DIRECTORY.
|
|
--echo #
|
|
--echo #
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
eval CREATE TABLE t5_restart(c1 DOUBLE AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
|
|
ROW_FORMAT=DYNAMIC ENGINE=InnoDB $ALT_DATA_DIR;
|
|
INSERT INTO t5_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
|
|
INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
|
|
INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
|
|
INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
|
|
INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t5_restart;
|
|
SELECT count(*) FROM t5_restart;
|
|
|
|
--echo #
|
|
--echo # Create and insert records into a partitioned table that uses-echo # a remote DATA DIRECTORY for each partition.
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
eval CREATE TABLE t6_restart(
|
|
c1 INT AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
|
|
ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2 ENGINE=InnoDB
|
|
PARTITION BY HASH(c1) (
|
|
PARTITION p0 $ALT_DATA_DIR,
|
|
PARTITION p1 $ALT_DATA_DIR,
|
|
PARTITION p2 $ALT_DATA_DIR);
|
|
INSERT INTO t6_restart VALUES (0, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
|
|
INSERT INTO t6_restart (SELECT 0, c2, c3, c4, c5 FROM t6_restart);
|
|
INSERT INTO t6_restart (SELECT 0, c2, c3, c4, c5 FROM t6_restart);
|
|
INSERT INTO t6_restart (SELECT 0, c2, c3, c4, c5 FROM t6_restart);
|
|
INSERT INTO t6_restart (SELECT 0, c2, c3, c4, c5 FROM t6_restart);
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t6_restart;
|
|
SELECT count(*) FROM t6_restart;
|
|
|
|
--echo #
|
|
--echo # Create and insert records into a subpartitioned table that uses
|
|
--echo # a remote DATA DIRECTORY for each subpartition.
|
|
--echo #
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
eval CREATE TABLE t7_restart(
|
|
c1 INT AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
|
|
ROW_FORMAT=DYNAMIC ENGINE=InnoDB
|
|
PARTITION BY RANGE(c1) SUBPARTITION BY HASH(c1) (
|
|
PARTITION p0 VALUES LESS THAN (10) (
|
|
SUBPARTITION s0 $ALT_DATA_DIR,
|
|
SUBPARTITION s1 $ALT_DATA_DIR),
|
|
PARTITION p1 VALUES LESS THAN MAXVALUE (
|
|
SUBPARTITION s2 $ALT_DATA_DIR,
|
|
SUBPARTITION s3 $ALT_DATA_DIR));
|
|
INSERT INTO t7_restart VALUES (0, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
|
|
INSERT INTO t7_restart (SELECT 0, c2, c3, c4, c5 FROM t7_restart);
|
|
INSERT INTO t7_restart (SELECT 0, c2, c3, c4, c5 FROM t7_restart);
|
|
INSERT INTO t7_restart (SELECT 0, c2, c3, c4, c5 FROM t7_restart);
|
|
INSERT INTO t7_restart (SELECT 0, c2, c3, c4, c5 FROM t7_restart);
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t7_restart;
|
|
SELECT count(*) FROM t7_restart;
|
|
|
|
--echo #
|
|
--echo # Create and insert records into a table that uses a general tablespace.
|
|
--echo #
|
|
CREATE TABLESPACE s1_restart ADD DATAFILE 's1_restart.ibd';
|
|
CREATE TABLE t8_restart(c1 DOUBLE AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
|
|
ROW_FORMAT=COMPACT ENGINE=InnoDB TABLESPACE=s1_restart;
|
|
INSERT INTO t8_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
|
|
INSERT INTO t8_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
|
|
INSERT INTO t8_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
|
|
INSERT INTO t8_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
|
|
INSERT INTO t8_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t8_restart;
|
|
SELECT count(*) FROM t8_restart;
|
|
CREATE TABLE t9_restart(c1 DOUBLE AUTO_INCREMENT KEY, c2 CHAR(10), c3 VARCHAR(100), c4 DATE, c5 TEXT)
|
|
ROW_FORMAT=DYNAMIC ENGINE=InnoDB TABLESPACE=s1_restart;
|
|
INSERT INTO t9_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
|
|
INSERT INTO t9_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
|
|
INSERT INTO t9_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
|
|
INSERT INTO t9_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
|
|
INSERT INTO t9_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t9_restart;
|
|
SELECT count(*) FROM t9_restart;
|
|
|
|
--echo #
|
|
--echo # Show these tables in information_schema.
|
|
--echo #
|
|
--source suite/innodb/include/show_i_s_tables.inc
|
|
--source suite/innodb/include/show_i_s_tablespaces.inc
|
|
|
|
--echo #
|
|
--echo # Shutdown the server and list the tablespace OS files
|
|
--echo #
|
|
--source include/shutdown_mysqld.inc
|
|
|
|
--echo ---- MYSQL_DATA_DIR/$SCHEMA_NAME
|
|
--replace_result #P# #p# #SP# #sp#
|
|
--list_files $MYSQL_DATA_DIR$SCHEMA_NAME
|
|
--echo ---- ALT_DIR
|
|
--list_files $ALT_DIR
|
|
--echo ---- ALT_DIR/$SCHEMA_NAME
|
|
--replace_result #P# #p# #SP# #sp#
|
|
--list_files $ALT_DIR/$SCHEMA_NAME
|
|
|
|
--echo #
|
|
--echo # Start the server and show that tables are still visible and accessible.
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
--source include/start_mysqld.inc
|
|
|
|
SHOW VARIABLES LIKE 'innodb_file_per_table';
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t1_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t2_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t3_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t4_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t5_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t6_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t7_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t8_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t9_restart;
|
|
|
|
INSERT INTO t1_restart (SELECT 0, c2, c3, c4, c5 FROM t1_restart);
|
|
INSERT INTO t2_restart (SELECT 0, c2, c3, c4, c5 FROM t2_restart);
|
|
INSERT INTO t3_restart (SELECT 0, c2, c3, c4, c5 FROM t3_restart);
|
|
INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
|
|
INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
|
|
INSERT INTO t6_restart (SELECT 0, c2, c3, c4, c5 FROM t6_restart);
|
|
INSERT INTO t7_restart (SELECT 0, c2, c3, c4, c5 FROM t7_restart);
|
|
INSERT INTO t8_restart (SELECT 0, c2, c3, c4, c5 FROM t8_restart);
|
|
INSERT INTO t9_restart (SELECT 0, c2, c3, c4, c5 FROM t9_restart);
|
|
|
|
SELECT count(*) FROM t1_restart;
|
|
SELECT count(*) FROM t2_restart;
|
|
SELECT count(*) FROM t3_restart;
|
|
SELECT count(*) FROM t4_restart;
|
|
SELECT count(*) FROM t5_restart;
|
|
SELECT count(*) FROM t6_restart;
|
|
SELECT count(*) FROM t7_restart;
|
|
SELECT count(*) FROM t8_restart;
|
|
SELECT count(*) FROM t9_restart;
|
|
|
|
--echo #
|
|
--echo # Show these tables in information_schema.
|
|
--echo #
|
|
--source suite/innodb/include/show_i_s_tables.inc
|
|
--source suite/innodb/include/show_i_s_tablespaces.inc
|
|
|
|
DROP TABLE t1_restart;
|
|
DROP TABLE t2_restart;
|
|
DROP TABLE t3_restart;
|
|
# Table t5_restart will be expanded.
|
|
# Tables t6_restart and t7_restart will be truncated.
|
|
DROP TABLE t8_restart;
|
|
DROP TABLE t9_restart;
|
|
DROP TABLESPACE s1_restart;
|
|
|
|
--echo #
|
|
--echo # Truncate the remote tablespaces.
|
|
--echo #
|
|
TRUNCATE TABLE t5_restart;
|
|
ALTER TABLE t6_restart TRUNCATE PARTITION p2;
|
|
ALTER TABLE t7_restart TRUNCATE PARTITION p1;
|
|
|
|
--source suite/innodb/include/show_i_s_tablespaces.inc
|
|
|
|
INSERT INTO t5_restart VALUES (1000000000, 'MySQL', 'InnoDB', '2011-11-11', 'Read this after reboot');
|
|
INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
|
|
INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
|
|
INSERT INTO t5_restart (SELECT 0, c2, c3, c4, c5 FROM t5_restart);
|
|
|
|
SELECT count(*) FROM t5_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t5_restart;
|
|
|
|
SELECT count(*) FROM t6_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t6_restart;
|
|
|
|
SELECT count(*) FROM t7_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t7_restart;
|
|
|
|
--echo #
|
|
--echo # Shutdown the server and make a backup of a tablespace
|
|
--echo #
|
|
--source include/shutdown_mysqld.inc
|
|
|
|
--copy_file $ALT_DIR/$SCHEMA_NAME/t5_restart.ibd $ALT_DIR/$SCHEMA_NAME/t5_restart.ibd.bak
|
|
|
|
--echo ---- MYSQL_DATA_DIR/$SCHEMA_NAME
|
|
--replace_result #P# #p# #SP# #sp#
|
|
--list_files $MYSQL_DATA_DIR/$SCHEMA_NAME
|
|
--echo ---- ALT_DIR/$SCHEMA_NAME
|
|
--replace_result #P# #p# #SP# #sp#
|
|
--list_files $ALT_DIR/$SCHEMA_NAME
|
|
|
|
--echo #
|
|
--echo # Start the server and show the tablespaces.
|
|
--echo #
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
--source include/start_mysqld.inc
|
|
|
|
SHOW VARIABLES LIKE 'innodb_file_per_table';
|
|
|
|
--source suite/innodb/include/show_i_s_tablespaces.inc
|
|
|
|
SELECT count(*) FROM t5_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t5_restart;
|
|
|
|
SELECT count(*) FROM t6_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t6_restart;
|
|
|
|
SELECT count(*) FROM t7_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t7_restart;
|
|
|
|
--echo #
|
|
--echo # Try to rename a tablespace to a file that already exists
|
|
--echo #
|
|
|
|
--remove_file $ALT_DIR/$SCHEMA_NAME/t5_restart.ibd.bak
|
|
|
|
--echo ---- MYSQL_DATA_DIR/$SCHEMA_NAME
|
|
--replace_result #P# #p# #SP# #sp#
|
|
--list_files $MYSQL_DATA_DIR/$SCHEMA_NAME
|
|
--echo ---- ALT_DIR/$SCHEMA_NAME
|
|
--replace_result #P# #p# #SP# #sp#
|
|
--list_files $ALT_DIR/$SCHEMA_NAME
|
|
|
|
--echo #
|
|
--echo # Rename file table and tablespace
|
|
--echo #
|
|
|
|
RENAME TABLE t5_restart TO t55_restart;
|
|
RENAME TABLE t6_restart TO t66_restart;
|
|
RENAME TABLE t7_restart TO t77_restart;
|
|
|
|
--source suite/innodb/include/show_i_s_tablespaces.inc
|
|
|
|
INSERT INTO t55_restart (SELECT 0, c2, c3, c4, c5 FROM t55_restart);
|
|
SELECT count(*) FROM t55_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t55_restart;
|
|
|
|
INSERT INTO t66_restart (SELECT 0, c2, c3, c4, c5 FROM t66_restart);
|
|
SELECT count(*) FROM t66_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t66_restart;
|
|
|
|
INSERT INTO t77_restart (SELECT 0, c2, c3, c4, c5 FROM t77_restart);
|
|
SELECT count(*) FROM t77_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t77_restart;
|
|
|
|
--echo ---- MYSQL_DATA_DIR/$SCHEMA_NAME
|
|
--replace_result #P# #p# #SP# #sp#
|
|
--list_files $MYSQL_DATA_DIR/$SCHEMA_NAME
|
|
--echo ---- ALT_DIR/$SCHEMA_NAME
|
|
--replace_result #P# #p# #SP# #sp#
|
|
--list_files $ALT_DIR/$SCHEMA_NAME
|
|
|
|
--echo #
|
|
--echo # Restart the server
|
|
--echo #
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
--source include/restart_mysqld.inc
|
|
SHOW VARIABLES LIKE 'innodb_file_per_table';
|
|
|
|
--source suite/innodb/include/show_i_s_tablespaces.inc
|
|
|
|
INSERT INTO t55_restart (SELECT 0, c2, c3, c4, c5 FROM t55_restart);
|
|
SELECT count(*) FROM t55_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t55_restart;
|
|
|
|
INSERT INTO t66_restart (SELECT 0, c2, c3, c4, c5 FROM t66_restart);
|
|
SELECT count(*) FROM t66_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t66_restart;
|
|
|
|
INSERT INTO t77_restart (SELECT 0, c2, c3, c4, c5 FROM t77_restart);
|
|
SELECT count(*) FROM t77_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t77_restart;
|
|
|
|
--echo #
|
|
--echo # Shutdown the server
|
|
--echo #
|
|
--source include/shutdown_mysqld.inc
|
|
|
|
--echo ---- MYSQL_DATA_DIR/$SCHEMA_NAME
|
|
--replace_result #P# #p# #SP# #sp#
|
|
--list_files $MYSQL_DATA_DIR/$SCHEMA_NAME
|
|
--echo ---- ALT_DIR/$SCHEMA_NAME
|
|
--replace_result #P# #p# #SP# #sp#
|
|
--list_files $ALT_DIR/$SCHEMA_NAME
|
|
|
|
--echo #
|
|
--echo # Start the server and check tablespaces.
|
|
--echo #
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
--source include/start_mysqld.inc
|
|
|
|
--source suite/innodb/include/show_i_s_tablespaces.inc
|
|
|
|
INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
|
|
SELECT count(*) FROM t4_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t4_restart;
|
|
|
|
INSERT INTO t55_restart (SELECT 0, c2, c3, c4, c5 FROM t55_restart);
|
|
SELECT count(*) FROM t55_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t55_restart;
|
|
|
|
INSERT INTO t66_restart (SELECT 0, c2, c3, c4, c5 FROM t66_restart);
|
|
SELECT count(*) FROM t66_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t66_restart;
|
|
|
|
INSERT INTO t77_restart (SELECT 0, c2, c3, c4, c5 FROM t77_restart);
|
|
SELECT count(*) FROM t77_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t77_restart;
|
|
|
|
|
|
--echo #
|
|
--echo # Shutdown the server
|
|
--echo #
|
|
--source include/shutdown_mysqld.inc
|
|
|
|
--echo #
|
|
--echo # Start the server and check tablespaces.
|
|
--echo #
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
--source include/start_mysqld.inc
|
|
|
|
--source suite/innodb/include/show_i_s_tablespaces.inc
|
|
|
|
INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
|
|
SELECT count(*) FROM t4_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t4_restart;
|
|
|
|
INSERT INTO t55_restart (SELECT 0, c2, c3, c4, c5 FROM t55_restart);
|
|
SELECT count(*) FROM t55_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t55_restart;
|
|
|
|
INSERT INTO t66_restart (SELECT 0, c2, c3, c4, c5 FROM t66_restart);
|
|
SELECT count(*) FROM t66_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t66_restart;
|
|
|
|
INSERT INTO t77_restart (SELECT 0, c2, c3, c4, c5 FROM t77_restart);
|
|
SELECT count(*) FROM t77_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t77_restart;
|
|
|
|
--echo #
|
|
--echo # Shutdown the server
|
|
--echo # Move all the files form ALT_DIR to ALT_DIR_MOVED
|
|
--echo #
|
|
--source include/shutdown_mysqld.inc
|
|
|
|
--echo # Moving files
|
|
--mkdir $ALT_DIR_MOVED
|
|
--mkdir $ALT_DIR_MOVED/$SCHEMA_NAME
|
|
--copy_files_wildcard $ALT_DIR/$SCHEMA_NAME $ALT_DIR_MOVED/$SCHEMA_NAME *
|
|
--remove_files_wildcard $ALT_DIR/$SCHEMA_NAME *
|
|
--rmdir $ALT_DIR/$SCHEMA_NAME
|
|
--replace_result #P# #p# #SP# #sp#
|
|
--list_files $ALT_DIR_MOVED/$SCHEMA_NAME
|
|
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
LET $restart_parameters = restart:--innodb-directories="$ALT_DIR_MOVED";
|
|
|
|
--echo #
|
|
--echo # Start the server and check tablespaces.
|
|
--echo #
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
--source include/start_mysqld.inc
|
|
|
|
INSERT INTO t4_restart (SELECT 0, c2, c3, c4, c5 FROM t4_restart);
|
|
SELECT count(*) FROM t4_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t4_restart;
|
|
|
|
INSERT INTO t55_restart (SELECT 0, c2, c3, c4, c5 FROM t55_restart);
|
|
SELECT count(*) FROM t55_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t55_restart;
|
|
|
|
INSERT INTO t66_restart (SELECT 0, c2, c3, c4, c5 FROM t66_restart);
|
|
SELECT count(*) FROM t66_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t66_restart;
|
|
|
|
INSERT INTO t77_restart (SELECT 0, c2, c3, c4, c5 FROM t77_restart);
|
|
SELECT count(*) FROM t77_restart;
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
SHOW CREATE TABLE t77_restart;
|
|
|
|
--echo #
|
|
--echo # Show these tables in information_schema with the updated path
|
|
--echo #
|
|
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
|
|
--source suite/innodb/include/show_i_s_tables.inc
|
|
--source suite/innodb/include/show_i_s_tablespaces.inc
|
|
|
|
--echo #
|
|
--echo # Cleanup
|
|
--echo #
|
|
|
|
eval DROP DATABASE $SCHEMA_NAME;
|
|
|
|
--disable_query_log
|
|
|
|
--rmdir $ALT_DIR_MOVED/$SCHEMA_NAME
|
|
--rmdir $ALT_DIR_MOVED
|
|
|
|
eval set global innodb_file_per_table=$innodb_file_per_table_orig;
|
|
--enable_query_log
|