mysqlbinlog中解释事件--hexdump(二)
5 20 74 65 78 74 2c 0a 65 78 70 6c |ample.text..expl|
# 0000012e 61 6e 61 74 69 6f 6e 20 74 65 78 74 2c 0a 61 64 |anation.text..ad|
# 0000013e 64 69 74 69 6f 6e 61 6c 20 74 65 78 74 29 20 65 |ditional.text..e|
# 0000014e 6e 67 69 6e 65 3d 69 6e 6e 6f 64 62 20 64 65 66 |ngine.innodb.def|
# 0000015e 61 75 6c 74 20 63 68 61 72 73 65 74 3d 75 74 66 |ault.charset.utf|
# 0000016e 38 |8|
# Query thread_id=1 exec_time=0 error_code=0
use test/*!*/;
SET TIMESTAMP=1364888751/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1/*!*/;
SET @@session.sql_mode=0/*!*/;
/*!\C utf8 *//*!*/;
SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/;
create table items(
id int not null auto_increment primary key,
short_description varchar(255),
description text,
example text,
explanation text,
additional text) engine=innodb default charset=utf8
/*!*/;
# at 367
#130402 16:57:39 server id 11 end_log_pos 435
# Position Timestamp Type Master ID Size Master Pos Flags
# 0000016f 83 9d 5a 51 02 0b 00 00 00 44 00 00 00 b3 01 00 00 08 00
# 00000182 01 00 00 00 00 00 00 00 04 00 00 1a 00 00 00 00 |................|
# 00000192 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std|
# 000001a2 04 21 00 21 00 21 00 74 65 73 74 00 42 45 47 49 |.......test.BEGI|
# 000001b2 4e |N|
# Query thread_id=1 exec_time=0 error_code=0
SET TIMESTAMP=1364893059/*!*/;
BEGIN
/*!*/;
# at 435
#130402 16:57:39 server id 11 end_log_pos 528
# Position Timestamp Type Master ID Size Master Pos Flags
# 000001b3 83 9d 5a 51 02 0b 00 00 00 5d 00 00 00 10 02 00 00 00 00
# 000001c6 01 00 00 00 00 00 00 00 04 00 00 1a 00 00 00 00 |................|
# 000001d6 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std|
# 000001e6 04 21 00 21 00 21 00 74 65 73 74 00 64 65 6c 65 |.......test.dele|
# 000001f6 74 65 20 66 72 6f 6d 20 20 74 31 2c 74 32 20 75 |te.from..t1.t2.u|
# 00000206 73 69 6e 67 20 74 31 2c 74 32 |sing.t1.t2|
# Query thread_id=1 exec_time=0 error_code=0
SET TIMESTAMP=1364893059/*!*/;
delete from t1,t2 using t1,t2
/*!*/;
# at 528
#130402 16:57:39 server id 11 end_log_pos 597
# Position Timestamp Type Master ID Size Master Pos Flags
# 00000210 83 9d 5a 51 02 0b 00 00 00 45 00 00 00 55 02 00 00 08 00
# 00000223 01 00 00 00 00 00 00 00 04 00 00 1a 00 00 00 00 |................|
# 00000233 00 00 01 00 00 00 00 00 00 00 00 06 03 73 74 64 |.............std|
# 00000243 04 21 00 21 00 21 00 74 65 73 74 00 43 4f 4d 4d |.......test.COMM|
# 00000253 49 54 |IT|
# Query thread_id=1 exec_time=0 error_code=0
SET TIMESTAMP=1364893059/*!*/;
COMMIT
/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
[root@Slave02 data]#
可以看到一些信息和事件的特定的信息被分成两行，而他们被合并在正常的输出中显示出来；