[MySQL Binlog]mysql How to completely parse the mixed log format binlog_mysql

Source: Internet
Author: User
Tags base64 mixed

MySQL binlog3 type format, row,mixed,statement. Parsing work

Mysqlbinlog--base64-output=decode-rows-v mysql-bin.000144 |more

--base64-output=decode-rows: Shows the SQL changes brought by the row mode.

-V: Shows the SQL statement brought by the statement mode

Copy Code code as follows:

[mysql@002tmp]$ mysqlbinlog--base64-output=decode-rows-v mysql-bin.000144 |more
/*!40019 SET @ @session. max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE =@ @COMPLETION_TYPE, completion_type=0*/;
DELIMITER/*!*/;
# at 4
#140216 23:59:26 Server ID 3 end_log_pos start:binlog v 4, Server v 5.5.25a-log created 140216 23:59:26
# at 107
#140216 23:59:26 Server ID 1 end_log_pos 171 Query thread_id=8557964 exec_time=0 error_code=0
SET timestamp=1392595166/*!*/;
SET @ @session. pseudo_thread_id=8557964/*!*/;
SET @ @session. Foreign_key_checks=1, @ @session. sql_auto_is_null=0, @ @session. Unique_checks=1, @ @session. autocommit= 1/*!*/;
SET @ @session. sql_mode=6291456/*!*/;
SET @ @session. auto_increment_increment=2, @ @session. auto_increment_offset=1/*!*/;
/*!\c UTF8MB4 *//*!*/;
SET @ @session. character_set_client=45,@ @session. collation_connection=45,@ @session. collation_server=33/*!*/;
SET @ @session. lc_time_names=0/*!*/;
SET @ @session. collation_database=default/*!*/;
BEGIN
/*!*/;
# at 171
# at 260
#140216 23:59:26 Server ID 1 end_log_pos table_map: ' Billing '. ' Billing_account ' mapped to number 216
#140216 23:59:26 Server ID 1 end_log_pos 418 write_rows:table ID 216 flags:stmt_end_f
### INSERT into Billing.billing_account
### SET
### @1=80491
### @2=1000013580491
### @3=1000056980491
### @4=1
### @5=1
### @6= ' integration-tests '
### @7=2014-02-16 23:59:26
### @8= ' integration-tests '
### @9=2014-02-16 23:59:26
### @10= ' integration-tests '
### @11=null
### @12= ' 0 '
### @13=1000105380491
### @14= ' 0 '
### @15= ' 159.153.208.254 '
### @16=1
### @17=null
# at 418
# at 516
#140216 23:59:26 Server ID 1 end_log_pos 516 table_map: ' billing '. ' Credit_card_account ' mapped to number 222
#140216 23:59:26 Server ID 1 end_log_pos 812 write_rows:table ID 222 flags:stmt_end_f
### INSERT into Billing.credit_card_account
### SET

Related Article

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.