mysql 5.6开启binlog_MySQL 5.6.12切换binlog二进制日志路径

[root@mysql5612 binlog_new]# /usr/local/mysql/bin/mysqlbinlog --base64-output=DECODE-ROWS -v mysql-bin.000002

/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;

/*!40019 SET @@session.max_insert_delayed_threads=0*/;

/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;

DELIMITER /*!*/;

# at 4

#151210 21:10:05 server id 72 end_log_pos 120 CRC32 0xa723f142 Start: binlog v 4, server v 5.6.12-log created 151210 21:10:05 at startup

# Warning: this binlog is either in use or was not closed properly.

ROLLBACK/*!*/;

# at 120

#151210 21:10:07 server id 72 end_log_pos 206 CRC32 0x447f5733 Query thread_id=1 exec_time=0 error_code=0

SET TIMESTAMP=1449753007/*!*/;

SET @@session.pseudo_thread_id=1/*!*/;

SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/;

SET @@session.sql_mode=1075838976/*!*/;

SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;

/*!\C utf8mb4 *//*!*/;

SET @@session.character_set_client=45,@@session.collation_connection=45,@@session.collation_server=45/*!*/;

SET @@session.time_zone='SYSTEM'/*!*/;

SET @@session.lc_time_names=0/*!*/;

SET @@session.collation_database=DEFAULT/*!*/;

BEGIN

/*!*/;

# at 206

#151210 21:10:07 server id 72 end_log_pos 274 CRC32 0xde0b7250 Table_map: `access_log`.`access_log` mapped to number 70

# at 274

#151210 21:10:07 server id 72 end_log_pos 368 CRC32 0xa03a9659 Write_rows: table id 70 flags: STMT_END_F

### INSERT INTO `access_log`.`access_log`

### SET

### @1=10534

### @2=1

### @3=1449753007

### @4='park_user@192.168.121.243'

### @5='park_user@192.168.%'

# at 368

#151210 21:10:07 server id 72 end_log_pos 399 CRC32 0x3ccf3c72 Xid = 3

COMMIT/*!*/;

# at 399

#151210 21:10:58 server id 72 end_log_pos 471 CRC32 0xef9ce950 Query thread_id=2 exec_time=0 error_code=0

SET TIMESTAMP=1449753058/*!*/;

BEGIN

/*!*/;

# at 471

#151210 21:10:58 server id 72 end_log_pos 593 CRC32 0x92e79f36 Query thread_id=2 exec_time=0 error_code=0

use `test`/*!*/;

SET TIMESTAMP=1449753058/*!*/;

CREATETABLE`z3` (

`a` int(1)NOTNULLDEFAULT'0'

)

/*!*/;

# at 593

#151210 21:10:58 server id 72 end_log_pos 638 CRC32 0x65f13b58 Table_map: `test`.`z3` mapped to number 107

# at 638

#151210 21:10:58 server id 72 end_log_pos 678 CRC32 0xaa7fb7e1 Write_rows: table id 107 flags: STMT_END_F

### INSERT INTO `test`.`z3`

### SET

### @1=3

# at 678

#151210 21:10:58 server id 72 end_log_pos 709 CRC32 0x218a319c Xid = 60

COMMIT/*!*/;

# at 709

#151210 21:11:04 server id 72 end_log_pos 781 CRC32 0x9662b95e Query thread_id=2 exec_time=0 error_code=0

SET TIMESTAMP=1449753064/*!*/;

BEGIN

/*!*/;

# at 781

#151210 21:11:04 server id 72 end_log_pos 826 CRC32 0x46f32822 Table_map: `test`.`z3` mapped to number 107

# at 826

#151210 21:11:04 server id 72 end_log_pos 866 CRC32 0xafb27f1e Write_rows: table id 107 flags: STMT_END_F

### INSERT INTO `test`.`z3`

### SET

### @1=4

# at 866

#151210 21:11:04 server id 72 end_log_pos 897 CRC32 0x351c7718 Xid = 63

COMMIT/*!*/;

# at 897

#151210 21:11:10 server id 72 end_log_pos 969 CRC32 0x76931e05 Query thread_id=2 exec_time=0 error_code=0

SET TIMESTAMP=1449753070/*!*/;

BEGIN

/*!*/;

# at 969

#151210 21:11:10 server id 72 end_log_pos 1014 CRC32 0xe7e8947b Table_map: `test`.`z3` mapped to number 107

# at 1014

#151210 21:11:10 server id 72 end_log_pos 1054 CRC32 0xbdafa096 Write_rows: table id 107 flags: STMT_END_F

### INSERT INTO `test`.`z3`

### SET

### @1=5

# at 1054

#151210 21:11:10 server id 72 end_log_pos 1085 CRC32 0x831695c0 Xid = 64

COMMIT/*!*/;

DELIMITER ;

# End of log file

ROLLBACK /* added by mysqlbinlog */;

/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/;

[root@mysql5612 binlog_new]#

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值