binlog内容格式

binlog文件内容格式

/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#191126 10:45:32 server id 2233306  end_log_pos 123     Start: binlog v 4, server v 5.7.26-log 
created 191126 10:45:32
BINLOG '
zJHcXQ/aEyIAdwAAAHsAAAAAAAQANS43LjI2LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAXwAEGggAAAAICAgCAAAACgoKKioAEjQA
AB6gf+o=
'/*!*/;
# at 123
#191126 10:45:32 server id 2233306  end_log_pos 150     Previous-GTIDs
# [empty]
# at 150
#191126 10:45:34 server id 2233306  end_log_pos 211     Anonymous_GTID  last_committed=0      sequence_number=1        rbr_only=yes
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/;
SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/;
# at 211
#191126 10:45:34 server id 2233306  end_log_pos 285     Query   thread_id=9879411       exec_ti
me=0    error_code=0
SET TIMESTAMP=1574736334/*!*/;
SET @@session.pseudo_thread_id=9879411/*!*/;
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@
session.autocommit=1/*!*/;
SET @@session.sql_mode=1411383296/*!*/;
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
/*!\C utf8mb4 *//*!*/;
SET @@session.character_set_client=45,@@session.collation_connection=45,@@session.collation_ser
ver=45/*!*/;
SET @@session.lc_time_names=0/*!*/;
SET @@session.collation_database=DEFAULT/*!*/;
BEGIN
/*!*/;
# at 285
#191126 10:45:34 server id 2233306  end_log_pos 459     Table_map: `secooPisDB`.`t_collect_products` mapped to number 11768
# at 459
#191126 10:45:34 server id 2233306  end_log_pos 1811    Update_rows: table id 11768 flags: STMT_END_F

BINLOG '
zpHcXRPaEyIArgAAAMsBAAAAAPgtAAAAAAEACnNlY29vUGlzREIAEnRfY29sbGVjdF9wcm9kdWN0
cwAwCAgIDwICDw8PDw8PDw/29vYPDw8PCA8PDw8PAQ8PDwgSAQ8SDxIIAgIICAgICA/2O1gCLAEs
ASwB3AUsAVgCLAFYAg4CDgIOAiwBLAEsASwBLAEsATQILAEsAdwFcBeYOgAsAQAsAQAsAQoCQCbM
fzDA
zpHcXR/aEyIASAUAABMHAAAAAPgtAAAAAAEAAgAw////////////////QCIIEACAOTNwBwAAAAAA
AAAAAAAAAHZEAAAAAAAADABsdW5nb2xpdmlnbm8EAAAABQAzMDM2MRgANzQwOTYwMDIyMTkyMDAz
X0VVIDM4IMK9BQAzMDM2MREAQkxBQ0sgQU5LTEUgQk9PVFMBAE6AAAAAAhIAgAAAAADZHoAAAAAA
AAAFAFRPRCdTBQBTaG9lcwsAQW5rbGUgYm9vdHMAAAAAAAAAAAUAQmxhY2sIAEVVIDM4IMK9DAAx
MDAlIExlYXRoZXIFAFdvbWVuBQBJdGFseQAAAXsicGljMSI6Imh0dHBzOi8vbHVuZ29saXZpZ25v
c3RvcmFnZS5ibG9iLmNvcmUud2luZG93cy5uZXQvcHJvZHVjdC8zMDM2MS9tYXJrZXRwbGFjZS9m
YTg4ZDhhZS1iNDY1LTRhZWQtOTkzNS02NGM4MzA3MjBjZjUuanBnIiwicGljbmFtZSI6Imh0dHBz
Oi8vbHVuZ29saXZpZ25vc3RvcmFnZS5ibG9iLmNvcmUud2luZG93cy5uZXQvcHJvZHVjdC8zMDM2
MS9tYXJrZXRwbGFjZS8wMTZkODg0ZC03MGViLTQ0NzQtYjA0OS0xMWY4NGRhNWU0OTMuanBnIn1F
AExlYXRoZXIgYW5rbGUgYm9vdHMNCkxvZ28gb24gaGVlbA0KRWxhc3RpY2F0ZWQgc2lkZSBiYW5k
DQpSdWJiZXIgc29sZQEAAAAAAAAAmaS0qqMACABBUElfQ0FMTJmkDtXICABBUElfQ0FMTJmktKqj
ZQQAAAAAAAAAAAAA/////////////////////////////////////////////////////xAARmFs
bC9XaW50ZXIgMjAxOUAiCBAAgDkzcAcAAAAAAAAAAAAAAAB2RAAAAAAAAAwAbHVuZ29saXZpZ25v
BAAAAAUAMzAzNjEYADc0MDk2MDAyMjE5MjAwM19FVSAzOCDCvQUAMzAzNjERAEJMQUNLIEFOS0xF
IEJPT1RTAQBOgAAAAAISAIAAAAAA2R6AAAAAAAAABQBUT0QnUwUAU2hvZXMLAEFua2xlIGJvb3Rz
AAAAAAAAAAAFAEJsYWNrCABFVSAzOCDCvQwAMTAwJSBMZWF0aGVyBQBXb21lbgUASXRhbHkAAAF7
InBpYzEiOiJodHRwczovL2x1bmdvbGl2aWdub3N0b3JhZ2UuYmxvYi5jb3JlLndpbmRvd3MubmV0
L3Byb2R1Y3QvMzAzNjEvbWFya2V0cGxhY2UvZmE4OGQ4YWUtYjQ2NS00YWVkLTk5MzUtNjRjODMw
NzIwY2Y1LmpwZyIsInBpY25hbWUiOiJodHRwczovL2x1bmdvbGl2aWdub3N0b3JhZ2UuYmxvYi5j
b3JlLndpbmRvd3MubmV0L3Byb2R1Y3QvMzAzNjEvbWFya2V0cGxhY2UvMDE2ZDg4NGQtNzBlYi00
NDc0LWIwNDktMTFmODRkYTVlNDkzLmpwZyJ9RQBMZWF0aGVyIGFua2xlIGJvb3RzDQpMb2dvIG9u
IGhlZWwNCkVsYXN0aWNhdGVkIHNpZGUgYmFuZA0KUnViYmVyIHNvbGUBAAAAAAAAAJmktKtiAAgA
QVBJX0NBTEyZpA7VyAgAQVBJX0NBTEyZpLSrYmYEAAAAAAAAAAAAAP//////////////////////
//////////////////////////////8QAEZhbGwvV2ludGVyIDIwMTk=
'/*!*/;
# at 1811
#191126 10:45:34 server id 2233306  end_log_pos 1838    Xid = 985990179
COMMIT/*!*/;