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;
11
Master_Port MASTER_PORT
13
Master_Log_File master-bin.000001
17
Relay_Master_Log_File master-bin.000001
23
Replicate_Ignore_Table #
24
Replicate_Wild_Do_Table
25
Replicate_Wild_Ignore_Table
40
Seconds_Behind_Master #
41
Master_SSL_Verify_Server_Cert No
47
change master to master_user='test';
52
Master_Port MASTER_PORT
54
Master_Log_File master-bin.000001
58
Relay_Master_Log_File master-bin.000001
64
Replicate_Ignore_Table #
65
Replicate_Wild_Do_Table
66
Replicate_Wild_Ignore_Table
81
Seconds_Behind_Master #
82
Master_SSL_Verify_Server_Cert No
92
Master_Port MASTER_PORT
104
Replicate_Ignore_Table #
105
Replicate_Wild_Do_Table
106
Replicate_Wild_Ignore_Table
110
Exec_Master_Log_Pos #
115
Master_SSL_Allowed No
121
Seconds_Behind_Master #
122
Master_SSL_Verify_Server_Cert No
127
change master to master_user='root';
131
Master_Host 127.0.0.1
133
Master_Port MASTER_PORT
135
Master_Log_File master-bin.000001
136
Read_Master_Log_Pos #
139
Relay_Master_Log_File master-bin.000001
141
Slave_SQL_Running Yes
145
Replicate_Ignore_Table #
146
Replicate_Wild_Do_Table
147
Replicate_Wild_Ignore_Table
151
Exec_Master_Log_Pos #
156
Master_SSL_Allowed No
162
Seconds_Behind_Master #
163
Master_SSL_Verify_Server_Cert No
171
create temporary table t1 (a int);
175
show status like 'slave_open_temp_tables';
177
Slave_open_temp_tables 0