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