mirror of
https://github.com/MariaDB/server.git
synced 2025-12-25 05:35:44 +01:00
126 lines
3.6 KiB
Text
126 lines
3.6 KiB
Text
CREATE TABLE t1(col1 INT PRIMARY KEY, col2 char(64), FULLTEXT KEY fts_index(col2))ENGINE=InnoDB;
|
|
INSERT INTO t1 VALUES(10, 'clone row 1');
|
|
INSERT INTO t1 VALUES(20, 'clone row 2');
|
|
INSERT INTO t1 VALUES(30, 'clone row 3');
|
|
SELECT * from t1 ORDER BY col1;
|
|
col1 col2
|
|
10 clone row 1
|
|
20 clone row 2
|
|
30 clone row 3
|
|
SELECT count(*) FROM mysql.general_log;
|
|
count(*)
|
|
0
|
|
SELECT count(*) FROM mysql.slow_log;
|
|
count(*)
|
|
0
|
|
CREATE TABLE t_myisam(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=MyISAM;
|
|
INSERT INTO t_myisam VALUES(10, 'myisam not cloned row 1');
|
|
SELECT * from t_myisam ORDER BY col1;
|
|
col1 col2
|
|
10 myisam not cloned row 1
|
|
CREATE TABLE t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL) ENGINE=CSV;
|
|
INSERT INTO t_csv VALUES(10, 'csv not cloned row 1');
|
|
SELECT * from t_csv ORDER BY col1;
|
|
col1 col2
|
|
10 csv not cloned row 1
|
|
CREATE SCHEMA non_innodb;
|
|
CREATE TABLE non_innodb.t_myisam(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=MyISAM;
|
|
INSERT INTO non_innodb.t_myisam VALUES(10, 'myisam not cloned row 1');
|
|
INSERT INTO non_innodb.t_myisam VALUES(20, 'myisam not cloned row 2');
|
|
INSERT INTO non_innodb.t_myisam VALUES(30, 'myisam not cloned row 3');
|
|
SELECT * from non_innodb.t_myisam ORDER BY col1;
|
|
col1 col2
|
|
10 myisam not cloned row 1
|
|
20 myisam not cloned row 2
|
|
30 myisam not cloned row 3
|
|
CREATE TABLE non_innodb.t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL) ENGINE=CSV;
|
|
INSERT INTO non_innodb.t_csv VALUES(10, 'csv not cloned row 1');
|
|
INSERT INTO non_innodb.t_csv VALUES(20, 'csv not cloned row 2');
|
|
INSERT INTO non_innodb.t_csv VALUES(30, 'csv not cloned row 3');
|
|
SELECT * from non_innodb.t_csv ORDER BY col1;
|
|
col1 col2
|
|
10 csv not cloned row 1
|
|
20 csv not cloned row 2
|
|
30 csv not cloned row 3
|
|
INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
|
|
SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS
|
|
WHERE PLUGIN_NAME LIKE '%clone%';
|
|
PLUGIN_NAME PLUGIN_STATUS
|
|
clone ACTIVE
|
|
CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
|
|
connection default;
|
|
# Restart server on cloned data directory
|
|
# restart: with restart_parameters
|
|
SELECT * from t1 ORDER BY col1;
|
|
col1 col2
|
|
10 clone row 1
|
|
20 clone row 2
|
|
30 clone row 3
|
|
INSERT INTO t1 VALUES(40, 'clone row 4');
|
|
SELECT * from t1 ORDER BY col1;
|
|
col1 col2
|
|
10 clone row 1
|
|
20 clone row 2
|
|
30 clone row 3
|
|
40 clone row 4
|
|
SELECT * from t_myisam ORDER BY col1;
|
|
col1 col2
|
|
10 myisam not cloned row 1
|
|
INSERT INTO t_myisam VALUES(40, 'myisam not cloned row 4');
|
|
SELECT * from t_myisam ORDER BY col1;
|
|
col1 col2
|
|
10 myisam not cloned row 1
|
|
40 myisam not cloned row 4
|
|
INSERT INTO t_csv VALUES(40, 'csv not cloned row 4');
|
|
SELECT * from t_csv ORDER BY col1;
|
|
col1 col2
|
|
10 csv not cloned row 1
|
|
40 csv not cloned row 4
|
|
INSERT INTO non_innodb.t_myisam VALUES(40, 'myisam not cloned row 4');
|
|
SELECT * from non_innodb.t_myisam ORDER BY col1;
|
|
col1 col2
|
|
10 myisam not cloned row 1
|
|
20 myisam not cloned row 2
|
|
30 myisam not cloned row 3
|
|
40 myisam not cloned row 4
|
|
INSERT INTO non_innodb.t_csv VALUES(40, 'csv not cloned row 4');
|
|
SELECT * from non_innodb.t_csv ORDER BY col1;
|
|
col1 col2
|
|
10 csv not cloned row 1
|
|
20 csv not cloned row 2
|
|
30 csv not cloned row 3
|
|
40 csv not cloned row 4
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t1
|
|
t_csv
|
|
t_myisam
|
|
SELECT count(*) FROM mysql.general_log;
|
|
count(*)
|
|
0
|
|
SELECT count(*) FROM mysql.slow_log;
|
|
count(*)
|
|
0
|
|
SET GLOBAL general_log = ON;
|
|
SET GLOBAL slow_query_log = ON;
|
|
# restart
|
|
SHOW TABLES;
|
|
Tables_in_test
|
|
t1
|
|
t_csv
|
|
t_myisam
|
|
SELECT * from t1 ORDER BY col1;
|
|
col1 col2
|
|
10 clone row 1
|
|
20 clone row 2
|
|
30 clone row 3
|
|
SELECT * from t_myisam ORDER BY col1;
|
|
col1 col2
|
|
10 myisam not cloned row 1
|
|
DROP TABLE t1;
|
|
DROP TABLE t_myisam;
|
|
DROP TABLE t_csv;
|
|
DROP TABLE non_innodb.t_myisam;
|
|
DROP TABLE non_innodb.t_csv;
|
|
DROP SCHEMA non_innodb;
|
|
UNINSTALL PLUGIN clone;
|