2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
CREATE TABLE t1 (data LONGBLOB) ENGINE=MYISAM;
8
CREATE TABLE t2 (data LONGBLOB) ENGINE=MYISAM;
9
INSERT INTO t1 (data) VALUES (repeat('a',1024*1024));
10
INSERT INTO t1 SELECT * FROM t1;
11
INSERT INTO t1 SELECT * FROM t1;
12
INSERT INTO t1 SELECT * FROM t1;
13
INSERT INTO t1 SELECT * FROM t1;
14
INSERT INTO t1 SELECT * FROM t1;
15
INSERT INTO t1 SELECT * FROM t1;
16
INSERT INTO t1 SELECT * FROM t1;
17
INSERT INTO t1 SELECT * FROM t1;
18
INSERT INTO t2 SELECT * FROM t1;
20
SELECT COUNT(*) FROM t2;
27
Master_Port MASTER_PORT
29
Master_Log_File master-bin.000001
33
Relay_Master_Log_File master-bin.000001
39
Replicate_Ignore_Table
40
Replicate_Wild_Do_Table
41
Replicate_Wild_Ignore_Table
56
Seconds_Behind_Master #