| 1 |
stop slave; |
| 2 |
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; |
| 3 |
reset master; |
| 4 |
reset slave; |
| 5 |
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; |
| 6 |
start slave; |
| 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; |
| 19 |
KILL QUERY 2; |
| 20 |
SELECT COUNT(*) FROM t2; |
| 21 |
COUNT(*) |
| 22 |
0 |
| 23 |
SHOW SLAVE STATUS; |
| 24 |
Slave_IO_State # |
| 25 |
Master_Host 127.0.0.1 |
| 26 |
Master_User root |
| 27 |
Master_Port MASTER_PORT |
| 28 |
Connect_Retry 1 |
| 29 |
Master_Log_File master-bin.000001 |
| 30 |
Read_Master_Log_Pos # |
| 31 |
Relay_Log_File # |
| 32 |
Relay_Log_Pos # |
| 33 |
Relay_Master_Log_File master-bin.000001 |
| 34 |
Slave_IO_Running Yes |
| 35 |
Slave_SQL_Running No |
| 36 |
Replicate_Do_DB |
| 37 |
Replicate_Ignore_DB |
| 38 |
Replicate_Do_Table |
| 39 |
Replicate_Ignore_Table |
| 40 |
Replicate_Wild_Do_Table |
| 41 |
Replicate_Wild_Ignore_Table |
| 42 |
Last_Errno 1317 |
| 43 |
Last_Error # |
| 44 |
Skip_Counter 0 |
| 45 |
Exec_Master_Log_Pos # |
| 46 |
Relay_Log_Space # |
| 47 |
Until_Condition None |
| 48 |
Until_Log_File |
| 49 |
Until_Log_Pos 0 |
| 50 |
Master_SSL_Allowed No |
| 51 |
Master_SSL_CA_File |
| 52 |
Master_SSL_CA_Path |
| 53 |
Master_SSL_Cert |
| 54 |
Master_SSL_Cipher |
| 55 |
Master_SSL_Key |
| 56 |
Seconds_Behind_Master # |