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

Source: Internet
Author: User
Tags base64 crc32 deprecated

/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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.