How to thoroughly parse the Mixed log format
This article will explain in detail how to thoroughly analyze the Mixed log format, the content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.
Mysql binlog3 format, row,mixed,statement. Analytical work
Mysqlbinlog-- base64-output=DECODE-ROWS-v mysql-bin.000144 | more
-- base64-output=DECODE-ROWS: shows the sql changes brought about by the row mode.
-v: displays the sql statements brought by statement mode
[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 107 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.pseudoplastics thread readership idling 8557964pencils /
SET @ @ session.foreign_key_checks=1, @ @ session.sql_auto_is_null=0, @ @ session.unique_checks=1, @ @ session.
SET @ @ session.sqlcards modewords 6291456pxt /
SET @ @ session.auto_increment_increment=2, @ @ session.
/ *!\ C utf8mb4 * /! * /
SET @ @ session. Session. Session setting client.45 session. Collationalization connection45 session. Session. Collationalization server33 apperance.
SET @ @ session. Session. LCC timetables namespace.
SET @ @ session.collationalization databases
BEGIN
/ *! * /
# at 171
# at 260
# 140216 23:59:26 server id 1 end_log_pos 260 Table_map: `billing`.`billing _ account` mapped to number
# 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
# @ 1mm 80491
# @ 2 million 1000013580491
# @ 3 million 1000056980491
# @ 4room1
# @ 531
# @ 6 collect Integration Mutual Tests'
# @ 7 February, 2014-02-16 23:59:26
# @ 8 collect Integration Mutual Tests'
# @ 9 September 2014-02-16 23:59:26
# @ 10 percent Integration Mutual Tests'
# @ 11=NULL
# @ 12 years 0'
# @ 130105380491
# @ 14 years 0'
# @ 159.153.208.254'
# @ 168.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
# 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
On how to thoroughly parse the Mixed log format to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.
