rpl_stm_reset_slave.result 3.47 KB
Newer Older
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1
stop slave;
guilhem@mysql.com's avatar
guilhem@mysql.com committed
2 3 4 5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
6
start slave;
7 8 9 10 11 12 13
SHOW SLAVE STATUS;
Slave_IO_State	#
Master_Host	127.0.0.1
Master_User	root
Master_Port	MASTER_PORT
Connect_Retry	1
Master_Log_File	master-bin.000001
hezx@mail.hezx.com's avatar
hezx@mail.hezx.com committed
14
Read_Master_Log_Pos	#
15 16 17 18 19 20 21 22 23 24 25 26 27 28
Relay_Log_File	#
Relay_Log_Pos	#
Relay_Master_Log_File	master-bin.000001
Slave_IO_Running	Yes
Slave_SQL_Running	Yes
Replicate_Do_DB	
Replicate_Ignore_DB	
Replicate_Do_Table	
Replicate_Ignore_Table	#
Replicate_Wild_Do_Table	
Replicate_Wild_Ignore_Table	
Last_Errno	0
Last_Error	
Skip_Counter	0
hezx@mail.hezx.com's avatar
hezx@mail.hezx.com committed
29
Exec_Master_Log_Pos	#
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
Relay_Log_Space	#
Until_Condition	None
Until_Log_File	
Until_Log_Pos	0
Master_SSL_Allowed	No
Master_SSL_CA_File	
Master_SSL_CA_Path	
Master_SSL_Cert	
Master_SSL_Cipher	
Master_SSL_Key	
Seconds_Behind_Master	#
Master_SSL_Verify_Server_Cert	No
Last_IO_Errno	#
Last_IO_Error	#
Last_SQL_Errno	0
Last_SQL_Error	
guilhem@mysql.com's avatar
guilhem@mysql.com committed
46 47
stop slave;
change master to master_user='test';
48 49 50 51 52 53 54
SHOW SLAVE STATUS;
Slave_IO_State	#
Master_Host	127.0.0.1
Master_User	test
Master_Port	MASTER_PORT
Connect_Retry	1
Master_Log_File	master-bin.000001
hezx@mail.hezx.com's avatar
hezx@mail.hezx.com committed
55
Read_Master_Log_Pos	#
56 57 58 59 60 61 62 63 64 65 66 67 68 69
Relay_Log_File	#
Relay_Log_Pos	#
Relay_Master_Log_File	master-bin.000001
Slave_IO_Running	No
Slave_SQL_Running	No
Replicate_Do_DB	
Replicate_Ignore_DB	
Replicate_Do_Table	
Replicate_Ignore_Table	#
Replicate_Wild_Do_Table	
Replicate_Wild_Ignore_Table	
Last_Errno	0
Last_Error	
Skip_Counter	0
hezx@mail.hezx.com's avatar
hezx@mail.hezx.com committed
70
Exec_Master_Log_Pos	#
71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86
Relay_Log_Space	#
Until_Condition	None
Until_Log_File	
Until_Log_Pos	0
Master_SSL_Allowed	No
Master_SSL_CA_File	
Master_SSL_CA_Path	
Master_SSL_Cert	
Master_SSL_Cipher	
Master_SSL_Key	
Seconds_Behind_Master	#
Master_SSL_Verify_Server_Cert	No
Last_IO_Errno	#
Last_IO_Error	#
Last_SQL_Errno	0
Last_SQL_Error	
guilhem@mysql.com's avatar
guilhem@mysql.com committed
87
reset slave;
88 89 90 91 92 93 94
SHOW SLAVE STATUS;
Slave_IO_State	#
Master_Host	127.0.0.1
Master_User	root
Master_Port	MASTER_PORT
Connect_Retry	1
Master_Log_File	
hezx@mail.hezx.com's avatar
hezx@mail.hezx.com committed
95
Read_Master_Log_Pos	#
96 97 98 99 100 101 102 103 104 105 106 107 108 109
Relay_Log_File	#
Relay_Log_Pos	#
Relay_Master_Log_File	
Slave_IO_Running	No
Slave_SQL_Running	No
Replicate_Do_DB	
Replicate_Ignore_DB	
Replicate_Do_Table	
Replicate_Ignore_Table	#
Replicate_Wild_Do_Table	
Replicate_Wild_Ignore_Table	
Last_Errno	0
Last_Error	
Skip_Counter	0
hezx@mail.hezx.com's avatar
hezx@mail.hezx.com committed
110
Exec_Master_Log_Pos	#
111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126
Relay_Log_Space	#
Until_Condition	None
Until_Log_File	
Until_Log_Pos	0
Master_SSL_Allowed	No
Master_SSL_CA_File	
Master_SSL_CA_Path	
Master_SSL_Cert	
Master_SSL_Cipher	
Master_SSL_Key	
Seconds_Behind_Master	#
Master_SSL_Verify_Server_Cert	No
Last_IO_Errno	#
Last_IO_Error	#
Last_SQL_Errno	0
Last_SQL_Error	
guilhem@mysql.com's avatar
guilhem@mysql.com committed
127
start slave;
128 129 130 131 132 133 134
SHOW SLAVE STATUS;
Slave_IO_State	#
Master_Host	127.0.0.1
Master_User	root
Master_Port	MASTER_PORT
Connect_Retry	1
Master_Log_File	master-bin.000001
hezx@mail.hezx.com's avatar
hezx@mail.hezx.com committed
135
Read_Master_Log_Pos	#
136 137 138 139 140 141 142 143 144 145 146 147 148 149
Relay_Log_File	#
Relay_Log_Pos	#
Relay_Master_Log_File	master-bin.000001
Slave_IO_Running	Yes
Slave_SQL_Running	Yes
Replicate_Do_DB	
Replicate_Ignore_DB	
Replicate_Do_Table	
Replicate_Ignore_Table	#
Replicate_Wild_Do_Table	
Replicate_Wild_Ignore_Table	
Last_Errno	0
Last_Error	
Skip_Counter	0
hezx@mail.hezx.com's avatar
hezx@mail.hezx.com committed
150
Exec_Master_Log_Pos	#
151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166
Relay_Log_Space	#
Until_Condition	None
Until_Log_File	
Until_Log_Pos	0
Master_SSL_Allowed	No
Master_SSL_CA_File	
Master_SSL_CA_Path	
Master_SSL_Cert	
Master_SSL_Cipher	
Master_SSL_Key	
Seconds_Behind_Master	#
Master_SSL_Verify_Server_Cert	No
Last_IO_Errno	#
Last_IO_Error	#
Last_SQL_Errno	0
Last_SQL_Error	
167 168 169 170 171 172 173 174 175 176
stop slave;
reset slave;
start slave;
create temporary table t1 (a int);
stop slave;
reset slave;
start slave;
show status like 'slave_open_temp_tables';
Variable_name	Value
Slave_open_temp_tables	1