/usr/local/mysql/bin/mysqlbinlog-vv/var/lib/bin/mysql-bin.000008 --base64-output=decode-rows - -start-pos=307
Question: What exactly does this mean?
[Email protected] 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 would be removed in a future rele Ase. Please use the full name instead.
/*!50530 SET @ @SESSION. pseudo_slave_mode=1*/;
/*!40019 SET @ @session. max_insert_delayed_threads=0*/;
/*!50003 SET @[email protected] @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 [email protected]_completion_type*/;
/*!50530 SET @ @SESSION. pseudo_slave_mode=0*/;
[Email protected] 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 would be removed in a future rele Ase. Please use the full name instead.
/*!50530 SET @ @SESSION. pseudo_slave_mode=1*/;
/*!40019 SET @ @session. max_insert_delayed_threads=0*/;
/*!50003 SET @[email protected] @COMPLETION_TYPE, completion_type=0*/;
DELIMITER/*!*/;
# at 4
#140820 7:56:31 Server ID 1 end_log_pos 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 [email protected]_completion_type*/;
/*!50530 SET @ @SESSION. pseudo_slave_mode=0*/;
The test is as follows, it seems that there is no way to specify the location of the Start-pos