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
create table t1(n int not null auto_increment primary key)ENGINE=MyISAM;
12
insert into t1 values (NULL);
14
create table t1 (word char(20) not null)ENGINE=MyISAM;
15
load data infile 'LOAD_FILE' into table t1 ignore 1 lines;
16
select count(*) from t1;
20
Log_name Pos Event_type Server_id End_log_pos Info
21
master-bin.000001 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4
22
master-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
23
master-bin.000001 # Intvar 1 # INSERT_ID=1
24
master-bin.000001 # Query 1 # use `test`; insert into t1 values (NULL)
25
master-bin.000001 # Query 1 # use `test`; drop table t1
26
master-bin.000001 # Query 1 # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
27
master-bin.000001 # Begin_load_query 1 # ;file_id=1;block_len=581
28
master-bin.000001 # Execute_load_query 1 # use `test`; LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES (`word`) ;file_id=1
29
show binlog events from 106 limit 1;
30
Log_name Pos Event_type Server_id End_log_pos Info
31
master-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
32
show binlog events from 106 limit 2;
33
Log_name Pos Event_type Server_id End_log_pos Info
34
master-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
35
master-bin.000001 # Intvar 1 # INSERT_ID=1
36
show binlog events from 106 limit 2,1;
37
Log_name Pos Event_type Server_id End_log_pos Info
38
master-bin.000001 # Query 1 # use `test`; insert into t1 values (NULL)
40
create table t3 (a int)ENGINE=MyISAM;
41
select * from t1 order by 1 asc;
112
select * from t1 order by 1 asc;
184
include/stop_slave.inc
185
include/start_slave.inc
186
create table t2 (n int)ENGINE=MyISAM;
187
insert into t2 values (1);
188
show binlog events from <binlog_start>;
189
Log_name Pos Event_type Server_id End_log_pos Info
190
master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
191
master-bin.000001 # Intvar # # INSERT_ID=1
192
master-bin.000001 # Query # # use `test`; insert into t1 values (NULL)
193
master-bin.000001 # Query # # use `test`; drop table t1
194
master-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
195
master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
196
master-bin.000001 # Execute_load_query # # use `test`; LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES (`word`) ;file_id=#
197
master-bin.000001 # Rotate # # master-bin.000002;pos=4
198
show binlog events in 'master-bin.000002';
199
Log_name Pos Event_type Server_id End_log_pos Info
200
master-bin.000002 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4
201
master-bin.000002 # Query 1 # use `test`; create table t3 (a int)ENGINE=MyISAM
202
master-bin.000002 # Query 1 # use `test`; create table t2 (n int)ENGINE=MyISAM
203
master-bin.000002 # Query 1 # use `test`; insert into t2 values (1)
212
show binlog events in 'slave-bin.000001' from 4;
213
Log_name Pos Event_type Server_id End_log_pos Info
214
slave-bin.000001 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4
215
slave-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
216
slave-bin.000001 # Intvar 1 # INSERT_ID=1
217
slave-bin.000001 # Query 1 # use `test`; insert into t1 values (NULL)
218
slave-bin.000001 # Query 1 # use `test`; drop table t1
219
slave-bin.000001 # Query 1 # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
220
slave-bin.000001 # Begin_load_query 1 # ;file_id=1;block_len=581
221
slave-bin.000001 # Execute_load_query 1 # use `test`; LOAD DATA INFILE '../../tmp/SQL_LOAD-2-1-1.data' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES (`word`) ;file_id=1
222
slave-bin.000001 # Query 1 # use `test`; create table t3 (a int)ENGINE=MyISAM
223
slave-bin.000001 # Rotate 2 # slave-bin.000002;pos=4
224
show binlog events in 'slave-bin.000002' from 4;
225
Log_name Pos Event_type Server_id End_log_pos Info
226
slave-bin.000002 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4
227
slave-bin.000002 # Query 1 # use `test`; create table t2 (n int)ENGINE=MyISAM
228
slave-bin.000002 # Query 1 # use `test`; insert into t2 values (1)
231
Master_Host 127.0.0.1
233
Master_Port MASTER_PORT
235
Master_Log_File master-bin.000002
236
Read_Master_Log_Pos 392
239
Relay_Master_Log_File master-bin.000002
241
Slave_SQL_Running Yes
245
Replicate_Ignore_Table #
246
Replicate_Wild_Do_Table
247
Replicate_Wild_Ignore_Table
251
Exec_Master_Log_Pos 392
256
Master_SSL_Allowed No
262
Seconds_Behind_Master #
263
Master_SSL_Verify_Server_Cert No
268
show binlog events in 'slave-bin.000005' from 4;
269
ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log
274
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
277
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
279
create table t1(a int auto_increment primary key, b int);
280
insert into t1 values (NULL, 1);
282
insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id());
283
show binlog events from <binlog_start>;
284
Log_name Pos Event_type Server_id End_log_pos Info
285
master-bin.000001 # Query # # use `test`; create table t1(a int auto_increment primary key, b int)
286
master-bin.000001 # Intvar # # INSERT_ID=1
287
master-bin.000001 # Query # # use `test`; insert into t1 values (NULL, 1)
288
master-bin.000001 # Intvar # # LAST_INSERT_ID=1
289
master-bin.000001 # Intvar # # INSERT_ID=5
290
master-bin.000001 # Query # # use `test`; insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id())