mysql-bin.000008_/usr/local/mysql/bin/mysqlbinlog -vv /var/lib/bin/mysql-bin.000008 --base64-output=...

戚升
2023-12-01

/usr/local/mysql/bin/mysqlbinlog -vv /var/lib/bin/mysql-bin.000008--base64-output=DECODE-ROWS --start-pos=307

问题:这个究竟是什么意思

[root@ma mysql]# /usr/local/mysql/bin/mysqlbinlog -vv /var/lib/bin/mysql-bin.000008 --base64-output=DECODE-ROWS --start-pos=307

Warning: Using unique option prefix start-pos instead of start-position is deprecated and will be removed in a future release. Please use the full name instead.

/*!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 307

#140820 7:56:56 server id 1 end_log_pos 338 CRC32 0x3ebc4dbb Xid = 42

COMMIT/*!*/;

# at 338

#140820 7:58:29 server id 1 end_log_pos 361 CRC32 0x2db75773 Stop

DELIMITER ;

# End of log file

ROLLBACK /* added by mysqlbinlog */;

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

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

[root@ma mysql]# /usr/local/mysql/bin/mysqlbinlog -vv /var/lib/bin/mysql-bin.000008 --start-pos=307

Warning: Using unique option prefix start-pos instead of start-position is deprecated and will be removed in a future release. Please use the full name instead.

/*!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

#140820 7:56:31 server id 1 end_log_pos 120 CRC32 0x4e0c426a Start: binlog v 4, server v 5.6.15-log created 140820 7:56:31

BINLOG '

L+TzUw8BAAAAdAAAAHgAAAAAAAQANS42LjE1LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA

AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXAAEGggAAAAICAgCAAAACgoKGRkAAWpC

DE4=

'/*!*/;

# at 307

#140820 7:56:56 server id 1 end_log_pos 338 CRC32 0x3ebc4dbb Xid = 42

COMMIT/*!*/;

# at 338

#140820 7:58:29 server id 1 end_log_pos 361 CRC32 0x2db75773 Stop

DELIMITER ;

# End of log file

ROLLBACK /* added by mysqlbinlog */;

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

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

测试如下,貌似不加中个参数没有办法指定了start-pos的位置

 类似资料: