← Back to branch summary

~mdcallag/+junk/5.1-map

« back to all changes in this revision

Viewing changes to mysql-test/r/rpl_row_log_innodb.result

  • Committer: msvensson at pilot
  • Date: 2007-04-24 09:11:45 UTC
  • mfrom: (2469.1.106)
  • Revision ID: sp1r-msvensson@pilot.blaudden-20070424091145-10463
Merge pilot.blaudden:/home/msvensson/mysql/my51-m-mysql_upgrade
into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/rpl_row_log_innodb.result
28
28
master-bin.000001       #       Table_map       1       #       table_id: # (test.t1)
29
29
master-bin.000001       #       Write_rows      1       #       table_id: # flags: STMT_END_F
30
30
master-bin.000001       #       Xid     1       #       COMMIT /* XID */
31
 
show binlog events from 102 limit 1;
 
31
show binlog events from 106 limit 1;
32
32
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
33
33
master-bin.000001       #       Query   1       #       use `test`; create table t1(n int not null auto_increment primary key)ENGINE=InnoDB
34
 
show binlog events from 102 limit 2;
 
34
show binlog events from 106 limit 2;
35
35
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
36
36
master-bin.000001       #       Query   1       #       use `test`; create table t1(n int not null auto_increment primary key)ENGINE=InnoDB
37
37
master-bin.000001       #       Table_map       1       #       table_id: # (test.t1)
38
 
show binlog events from 102 limit 2,1;
 
38
show binlog events from 106 limit 2,1;
39
39
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
40
40
master-bin.000001       #       Write_rows      1       #       table_id: # flags: STMT_END_F
41
41
flush logs;
49
49
stop slave;
50
50
create table t2 (n int)ENGINE=InnoDB;
51
51
insert into t2 values (1);
52
 
show binlog events;
 
52
show binlog events from <binlog_start>;
53
53
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
54
 
master-bin.000001       #       Format_desc     1       #       Server ver: VERSION, Binlog ver: 4
55
 
master-bin.000001       #       Query   1       #       use `test`; create table t1(n int not null auto_increment primary key)ENGINE=InnoDB
56
 
master-bin.000001       #       Table_map       1       #       table_id: # (test.t1)
57
 
master-bin.000001       #       Write_rows      1       #       table_id: # flags: STMT_END_F
58
 
master-bin.000001       #       Xid     1       #       COMMIT /* XID */
59
 
master-bin.000001       #       Query   1       #       use `test`; drop table t1
60
 
master-bin.000001       #       Query   1       #       use `test`; create table t1 (word char(20) not null)ENGINE=InnoDB
61
 
master-bin.000001       #       Table_map       1       #       table_id: # (test.t1)
62
 
master-bin.000001       #       Write_rows      1       #       table_id: # flags: STMT_END_F
63
 
master-bin.000001       #       Xid     1       #       COMMIT /* XID */
64
 
master-bin.000001       #       Rotate  1       #       master-bin.000002;pos=4
 
54
master-bin.000001       #       Query   #       #       use `test`; create table t1(n int not null auto_increment primary key)ENGINE=InnoDB
 
55
master-bin.000001       #       Table_map       #       #       table_id: # (test.t1)
 
56
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
 
57
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
58
master-bin.000001       #       Query   #       #       use `test`; drop table t1
 
59
master-bin.000001       #       Query   #       #       use `test`; create table t1 (word char(20) not null)ENGINE=InnoDB
 
60
master-bin.000001       #       Table_map       #       #       table_id: # (test.t1)
 
61
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
 
62
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
63
master-bin.000001       #       Rotate  #       #       master-bin.000002;pos=4
65
64
show binlog events in 'master-bin.000002';
66
65
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
67
66
master-bin.000002       #       Format_desc     1       #       Server ver: VERSION, Binlog ver: 4
72
71
master-bin.000002       #       Xid     1       #       COMMIT /* XID */
73
72
show binary logs;
74
73
Log_name        File_size
75
 
master-bin.000001       1310
76
 
master-bin.000002       400
 
74
master-bin.000001       1314
 
75
master-bin.000002       404
77
76
start slave;
78
77
show binary logs;
79
78
Log_name        File_size
80
 
slave-bin.000001        1408
81
 
slave-bin.000002        301
 
79
slave-bin.000001        1412
 
80
slave-bin.000002        305
82
81
show binlog events in 'slave-bin.000001' from 4;
83
82
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
84
83
slave-bin.000001        #       Format_desc     2       #       Server ver: VERSION, Binlog ver: 4
101
100
slave-bin.000002        #       Write_rows      1       #       table_id: # flags: STMT_END_F
102
101
slave-bin.000002        #       Xid     1       #       COMMIT /* XID */
103
102
show slave status;
104
 
Slave_IO_State  Master_Host     Master_User     Master_Port     Connect_Retry   Master_Log_File Read_Master_Log_Pos     Relay_Log_File  Relay_Log_Pos   Relay_Master_Log_File   Slave_IO_Running        Slave_SQL_Running       Replicate_Do_DB Replicate_Ignore_DB     Replicate_Do_Table      Replicate_Ignore_Table  Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table     Last_Errno      Last_Error      Skip_Counter    Exec_Master_Log_Pos     Relay_Log_Space Until_Condition Until_Log_File  Until_Log_Pos   Master_SSL_Allowed      Master_SSL_CA_File      Master_SSL_CA_Path      Master_SSL_Cert Master_SSL_Cipher       Master_SSL_Key  Seconds_Behind_Master
105
 
#       127.0.0.1       root    MASTER_PORT     1       master-bin.000002       400     #       #       master-bin.000002       Yes     Yes                             #                       0               0       400     #       None            0       No                                              #
 
103
Slave_IO_State  Master_Host     Master_User     Master_Port     Connect_Retry   Master_Log_File Read_Master_Log_Pos     Relay_Log_File  Relay_Log_Pos   Relay_Master_Log_File   Slave_IO_Running        Slave_SQL_Running       Replicate_Do_DB Replicate_Ignore_DB     Replicate_Do_Table      Replicate_Ignore_Table  Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table     Last_Errno      Last_Error      Skip_Counter    Exec_Master_Log_Pos     Relay_Log_Space Until_Condition Until_Log_File  Until_Log_Pos   Master_SSL_Allowed      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
 
104
#       127.0.0.1       root    MASTER_PORT     1       master-bin.000002       404     #       #       master-bin.000002       Yes     Yes                             #                       0               0       404     #       None            0       No                                              #       No
106
105
show binlog events in 'slave-bin.000005' from 4;
107
106
ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log
108
107
DROP TABLE t1;
113
112
reset master;
114
113
set insert_id=5;
115
114
insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id());
116
 
show binlog events;
 
115
show binlog events from <binlog_start>;
117
116
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
118
 
master-bin.000001       #       Format_desc     1       #       Server ver: VERSION, Binlog ver: 4
119
 
master-bin.000001       #       Table_map       1       #       table_id: # (test.t1)
120
 
master-bin.000001       #       Write_rows      1       #       table_id: # flags: STMT_END_F
 
117
master-bin.000001       #       Table_map       #       #       table_id: # (test.t1)
 
118
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
121
119
select * from t1;
122
120
a       b
123
121
1       1