1
by brian
clean slate |
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 t2 (id int not null primary key auto_increment); |
|
8 |
select @@session.read_buffer_size - @@session.max_allowed_packet > 0 ; |
|
9 |
@@session.read_buffer_size - @@session.max_allowed_packet > 0 |
|
10 |
1
|
|
11 |
load data infile 'MYSQLTEST_VARDIR/tmp/bug30435_5k.txt' into table t2; |
|
12 |
select count(*) from t2 /* 5 000 */; |
|
13 |
count(*) |
|
14 |
5000
|
|
15 |
show binlog events in 'master-bin.000002' from <binlog_start>; |
|
16 |
Log_name Pos Event_type Server_id End_log_pos Info |
|
17 |
master-bin.000002 # Query # # use `test`; create table t2 (id int not null primary key auto_increment) |
|
18 |
master-bin.000002 # Begin_load_query # # ;file_id=#;block_len=# |
|
19 |
master-bin.000002 # Append_block # # ;file_id=#;block_len=# |
|
20 |
master-bin.000002 # Append_block # # ;file_id=#;block_len=# |
|
21 |
master-bin.000002 # Execute_load_query # # use `test`; load data infile 'MYSQLTEST_VARDIR/tmp/bug30435_5k.txt' into table t2 ;file_id=# |
|
22 |
select count(*) from t2 /* 5 000 */; |
|
23 |
count(*) |
|
24 |
5000
|
|
25 |
drop table t1, t2; |
|
26 |
end of the tests |