mirror of
https://github.com/MariaDB/server.git
synced 2026-02-02 08:49:06 +01:00
121 lines
3.9 KiB
Text
121 lines
3.9 KiB
Text
# Test clone with concurrent DML
|
|
--source include/have_innodb.inc
|
|
|
|
--let $CLONE_DATADIR = $MYSQL_TMP_DIR/data_new
|
|
--let $CLONE_DATADIR1 = $MYSQL_TMP_DIR/data_new1
|
|
--source include/count_sessions.inc
|
|
|
|
## Install plugin
|
|
--replace_result $MARIADB_CLONE_SO CLONE_PLUGIN
|
|
--eval INSTALL PLUGIN clone SONAME '$MARIADB_CLONE_SO'
|
|
SHOW VARIABLES LIKE "clone_buffer_size";
|
|
SET GLOBAL clone_buffer_size = 2097152;
|
|
SHOW VARIABLES LIKE "clone_buffer_size";
|
|
## Create test schema
|
|
--source ../include/create_schema.inc
|
|
## Execute Clone while concurrent DMLs are in progress
|
|
--let num_rows = 100
|
|
# Insert rows
|
|
--eval call execute_dml(0, 0, $num_rows, $num_rows, 10, 0)
|
|
# Check base rows
|
|
SHOW CREATE TABLE t1;
|
|
SELECT count(*) from t1;
|
|
SELECT col1, col2, col3 FROM t1 ORDER BY col1 LIMIT 10;
|
|
SELECT col1, col2, col3 FROM t1 ORDER BY col1 DESC LIMIT 10;
|
|
SHOW CREATE TABLE t2;
|
|
SELECT count(*) from t2;
|
|
SELECT col1, col2, col3 FROM t2 ORDER BY col1 LIMIT 10;
|
|
SELECT col1, col2, col3 FROM t2 ORDER BY col1 DESC LIMIT 10;
|
|
--echo # In connection con1 - Running Insert Random [100 - 200 Key range]
|
|
connect (con1,localhost,root,,);
|
|
--send call execute_dml(0, 100, 100, 100, 20, 1)
|
|
--echo # In connection con2 - Running Update Random [0 - 25 Key Range]
|
|
connect (con2,localhost,root,,);
|
|
--send call execute_dml(1, 0, 25, 100, 20, 1)
|
|
--echo # In connection con3 - Running Delete Random [26 - 50 Key Range]
|
|
connect (con3,localhost,root,,);
|
|
--send call execute_dml(2, 26, 25, 100, 20, 1)
|
|
--echo # In connection con4 - Running Update Random uncommited [51 - 75 Key Range]
|
|
connect (con4,localhost,root,,);
|
|
begin;
|
|
--send call execute_dml(1, 51, 25, 100, 200, 1)
|
|
--echo # In connection default - Cloning database
|
|
--connection default
|
|
--replace_result $CLONE_DATADIR CLONE_DATADIR
|
|
--eval CLONE LOCAL DATA DIRECTORY = '$CLONE_DATADIR'
|
|
--echo # In connection default - Finished Cloning
|
|
--echo # In connection con1 - Waiting
|
|
connection con1;
|
|
--reap
|
|
--echo # In connection con2 - Waiting
|
|
connection con2;
|
|
--reap
|
|
--echo # In connection con3 - Waiting
|
|
connection con3;
|
|
--reap
|
|
--echo # In connection con4 - Waiting
|
|
connection con4;
|
|
--reap
|
|
commit;
|
|
--echo # In connection default
|
|
connection default;
|
|
disconnect con1;
|
|
disconnect con2;
|
|
disconnect con3;
|
|
disconnect con4;
|
|
|
|
--source include/wait_until_count_sessions.inc
|
|
--echo # Restart cloned database
|
|
--let restart_noprint=1
|
|
--let restart_parameters=--datadir=$CLONE_DATADIR
|
|
--source include/restart_mysqld.inc
|
|
|
|
# Execute procedure to delete all rows and insert
|
|
call execute_dml(3, 0, 1, 1, 1, 0);
|
|
--eval call execute_dml(0, 0, $num_rows, $num_rows, 10, 0)
|
|
|
|
# Check table in cloned database
|
|
SHOW CREATE TABLE t1;
|
|
SELECT count(*) from t1;
|
|
SELECT col1, col2, col3 FROM t1 ORDER BY col1 LIMIT 10;
|
|
SELECT col1, col2, col3 FROM t1 ORDER BY col1 DESC LIMIT 10;
|
|
|
|
SHOW CREATE TABLE t2;
|
|
SELECT count(*) from t2;
|
|
SELECT col1, col2, col3 FROM t2 ORDER BY col1 LIMIT 10;
|
|
SELECT col1, col2, col3 FROM t2 ORDER BY col1 DESC LIMIT 10;
|
|
|
|
# Test clone after recovering from cloned databse
|
|
--let $CLONE_DATADIR = $CLONE_DATADIR1
|
|
--replace_result $CLONE_DATADIR CLONE_DATADIR
|
|
--eval CLONE LOCAL DATA DIRECTORY = '$CLONE_DATADIR'
|
|
--let $CLONE_DATADIR = $MYSQL_TMP_DIR/data_new
|
|
|
|
--echo # Restart cloned database
|
|
--let restart_parameters=--datadir=$CLONE_DATADIR1
|
|
--source include/restart_mysqld.inc
|
|
|
|
# Execute procedure to delete all rows and insert
|
|
call execute_dml(3, 0, 1, 1, 1, 0);
|
|
call execute_dml(0, 0, 100, 100, 10, 0);
|
|
|
|
# Check table in cloned database
|
|
SHOW CREATE TABLE t1;
|
|
SELECT count(*) from t1;
|
|
SELECT col1, col2, col3 FROM t1 ORDER BY col1 LIMIT 10;
|
|
SELECT col1, col2, col3 FROM t1 ORDER BY col1 DESC LIMIT 10;
|
|
|
|
SHOW CREATE TABLE t2;
|
|
SELECT count(*) from t2;
|
|
SELECT col1, col2, col3 FROM t2 ORDER BY col1 LIMIT 10;
|
|
SELECT col1, col2, col3 FROM t2 ORDER BY col1 DESC LIMIT 10;
|
|
|
|
#Cleanup
|
|
--let restart_parameters=
|
|
--source include/restart_mysqld.inc
|
|
--connection default
|
|
--source ../include/drop_schema.inc
|
|
--rmdir $CLONE_DATADIR
|
|
--rmdir $CLONE_DATADIR1
|
|
|
|
UNINSTALL PLUGIN clone;
|