当前位置：Gxlcms > 数据库问题 > Mysql的binlog日志与mysqlbinlog命令

Mysql的binlog日志与mysqlbinlog命令

时间：2021-07-01 10:21:17 帮助过：3人阅读

MySQL 的二进制日志 binlog 可以说是 MySQL 最重要的日志，它记录了所有的 DDL 和 DML 语句（除了数据查询语句select、show等），以事件形式记录，还包含语句所执行的消耗的时间，MySQL的二进制日志是事务安全型的。binlog 的主要目的是复制和恢复。

Binlog日志的两个最重要的使用场景
MySQL主从复制：MySQL Replication在Master端开启binlog，Master把它的二进制日志传递给slaves来达到master-slave数据一致的目的
数据恢复：通过使用 mysqlbinlog工具来使恢复数据


总体的关于binlog的参数如下

  1. sync_binlog <span style="color: #808080;">=</span> <span style="color: #800000; font-weight: bold;">1</span>
  2. <span style="color: #ff00ff;">log</span><span style="color: #808080;">-</span>bin <span style="color: #808080;">=</span> mysql<span style="color: #808080;">-</span><span style="color: #000000;">bin
  3. binlog_format </span><span style="color: #808080;">=</span><span style="color: #000000;"> row
  4. expire_logs_days </span><span style="color: #808080;">=</span> <span style="color: #800000; font-weight: bold;">10</span><span style="color: #000000;">
  5. binlog_cache_size </span><span style="color: #808080;">=</span><span style="color: #000000;">4M
  6. max_binlog_cache_size </span><span style="color: #808080;">=</span><span style="color: #000000;">8M
  7. max_binlog_size </span><span style="color: #808080;">=</span>1024M

相关参数讲解

log-bin
决定了msyql 的binlog的名字，?成的binlog名字为mysql-bin.000001


binlog_format
规定binlog的格式， binlog有三种格式statement， row以及mixed，默认使?默认使?statement（5.7.7之前），建议使?row格式（5.7.7之后默认）


expire_logs_days
过期时间


binlog_do_db
此参数表示只记录指定数据库的?进制?志


binlog_ignore_db
此参数表示不记录指定的数据库的?进制?志


sync_binlog
在提交n次事务后，进?binlog的落盘， 0为不进?强?的刷新操作，?是由?件系统控制刷新?志?件
如果是在线交易和帐有关的数据建议设置成1, 如果是其它数据可以保持为０即可。


max_binlog_size
binlog?件的最?值，默认和最?是1GB，并不能严格限定?进制?件的??


max_binlog_cache_size 表示的是binlog 能够使?的最?cache 内存??
当我们执?多语句事务的时候 所有session的使?的内存超过max_binlog_cache_size的值时
就会报错： “Multi-statement transaction required more than ‘max_binlog_cache_size‘ bytes ofstorage”

mysqlbinlog格式

statment格式
特点：记录每?条数据的SQL，将执?的每?条SQL记录在binlog中，减少?志量，节省IO,提?性能。
缺点：某些SQL中的函数?法使?，?如SYSDATE()，在同步过程中会出现?法同步的问题。
mixed格式
特点：?般的语句使?SQL语句来记录，遇到特殊的语句使?row格式来记录，保证数据的?致性和复制的准确性。
row格式
特点： binlog中仅仅记录哪?条记录被修改，不记录dml的sql语句，会详细记录每?行的更改细节，不会出现?法复制的问题。
缺点：因为要记录每?条修改记录的?志，所以?量占?磁盘IO和?量使?硬盘空间。

注：将二进制日志格式设置为ROW时，有些更改仍然使用基于语句的格式，包括所有DDL语句，例如CREATE TABLE， ALTER TABLE，或 DROP TABLE。

开启binlog

由于log_bin是个只读系统变量，不能动态的修改，只能再my.cnf里[mysqld]模块添加log-bin 配置，表示启用binlog，如果没有给定值，写成 log-bin=，则默认名称为主机名。（注：名称若带有小数点，则只取第一个小数点前的部分作为名称）

  1. <span style="color: #ff0000;">[</span><span style="color: #ff0000;">mysqld</span><span style="color: #ff0000;">]</span>
  2. <span style="color: #ff00ff;">log</span><span style="color: #808080;">-</span>bin<span style="color: #808080;">=</span>mysql<span style="color: #808080;">-</span>bin

此方法需要重启数据库方能生效，如果想临时关掉binlog而又不想重启数据库，可以使用sql_log_bin，sql_log_bin 是一个动态变量，修改该变量时，可以只对当前会话生效（Session），也可以是全局的（Global），当全局修改这个变量时，只会对新的会话生效（这意味当对当前会话也不会生效），因此一般全局修改了这个变量后，都要把原来的所有连接 kill 掉，全局只在MariaDB 5.5之前和MySQL 5.6.22之前生效，后面的版本都已经不支持全局，因为太危险了。
用处：
当还原数据库的时候，如果不关闭二进制日志，那么你还原的过程仍然会记录在二进制日志里面，不仅浪费资源，那么增加了磁盘的容量，还没有必要（特别是利用二进制还原数据库的时候）所以一般还原的时候会选择关闭二进制日志，可以通过修改配置文件，重启关闭二进制日志。
也可以动态命令关闭sql_log_bin,然后导入数据库。

  1. <span style="color: #0000ff;">set</span> sql_log_bin<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">0</span><span style="color: #000000;">；# 设为0后，在当前会话上执行的语句都不记录binlog
  2. </span><span style="color: #0000ff;">set</span> sql_log_bin<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1</span>; # 取消限制

常用的binlog命令

  1. <span style="color: #000000;"># 是否启用binlog日志
  2. show variables </span><span style="color: #808080;">like</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">log_bin</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">;
  3. # 查看详细的日志配置信息
  4. show global variables </span><span style="color: #808080;">like</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">%log%</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">;
  5. # 查看binlog的目录
  6. show global variables </span><span style="color: #808080;">like</span> "<span style="color: #808080;">%</span>log_bin<span style="color: #808080;">%</span><span style="color: #000000;">";
  7. # 查看当前服务器使用的biglog文件及大小
  8. show </span><span style="color: #0000ff;">binary</span><span style="color: #000000;"> logs;
  9. # 查看最新一个binlog日志文件名称和Position
  10. show master status;
  11. # 清除所有的binlog?件，并且重置为?个
  12. reset master</span>

清理binlog日志

自动清理：
通过binlog参数（expire_logs_days ）来实现mysql?动删除binlog

  1. show <span style="color: #0000ff;">binary</span><span style="color: #000000;"> logs;
  2. show variables </span><span style="color: #808080;">like</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">expire_logs_days</span><span style="color: #ff0000;">‘</span><span style="color: #000000;">;
  3. </span><span style="color: #0000ff;">set</span> global expire_logs_days<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">3</span>; # 过期删除，单位是天

手动清理：

1、使?reset master 重置binlog?件（#reset master后，会造成slave?法找到master的严重后果）

2、直接rm本地删除binlog

  1. <span style="color: #000000;"># 查看正在使用的binlog
  2. show master status;</span>

直接使?rm 命令删除不是当前使?的binlog(切记不要删除正在使?的binlog)

 

mysqlbinlog命令

  1. root<span style="color: #008000;">@localhost</span> localhost <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">23</span>:<span style="color: #800000; font-weight: bold;">43</span> (none)<span style="color: #808080;">></span>show global variables <span style="color: #808080;">like</span> "<span style="color: #808080;">%</span>log_bin<span style="color: #808080;">%</span><span style="color: #000000;">";
  2. </span><span style="color: #808080;">+</span><span style="color: #008080;">--</span><span style="color: #008080;">-------------------------------+-----------------------------+</span>
  3. <span style="color: #808080;">|</span> Variable_name <span style="color: #808080;">|</span> Value <span style="color: #808080;">|</span>
  4. <span style="color: #808080;">+</span><span style="color: #008080;">--</span><span style="color: #008080;">-------------------------------+-----------------------------+</span>
  5. <span style="color: #808080;">|</span> log_bin <span style="color: #808080;">|</span> <span style="color: #0000ff;">ON</span> <span style="color: #808080;">|</span>
  6. <span style="color: #808080;">|</span> log_bin_basename <span style="color: #808080;">|</span> <span style="color: #808080;">/</span>data<span style="color: #808080;">/</span>mysql<span style="color: #808080;">/</span>mysql<span style="color: #808080;">-</span>bin <span style="color: #808080;">|</span>
  7. <span style="color: #808080;">|</span> log_bin_index <span style="color: #808080;">|</span> <span style="color: #808080;">/</span>data<span style="color: #808080;">/</span>mysql<span style="color: #808080;">/</span>mysql<span style="color: #808080;">-</span>bin.<span style="color: #0000ff;">index</span> <span style="color: #808080;">|</span>
  8. <span style="color: #808080;">|</span> log_bin_trust_function_creators <span style="color: #808080;">|</span> <span style="color: #0000ff;">ON</span> <span style="color: #808080;">|</span>
  9. <span style="color: #808080;">|</span> log_bin_use_v1_row_events <span style="color: #808080;">|</span> <span style="color: #0000ff;">OFF</span> <span style="color: #808080;">|</span>
  10. <span style="color: #808080;">+</span><span style="color: #008080;">--</span><span style="color: #008080;">-------------------------------+-----------------------------+</span>
  11. <span style="color: #800000; font-weight: bold;">5</span> rows <span style="color: #808080;">in</span> <span style="color: #0000ff;">set</span> (<span style="color: #800000; font-weight: bold;">0.00</span><span style="color: #000000;"> sec)
  12. root</span><span style="color: #008000;">@localhost</span> localhost <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">29</span>:<span style="color: #800000; font-weight: bold;">21</span> test1<span style="color: #808080;">></span>show global variables <span style="color: #808080;">like</span><span style="color: #000000;"> "binlog_format";
  13. </span><span style="color: #808080;">+</span><span style="color: #008080;">--</span><span style="color: #008080;">-------------+-------+</span>
  14. <span style="color: #808080;">|</span> Variable_name <span style="color: #808080;">|</span> Value <span style="color: #808080;">|</span>
  15. <span style="color: #808080;">+</span><span style="color: #008080;">--</span><span style="color: #008080;">-------------+-------+</span>
  16. <span style="color: #808080;">|</span> binlog_format <span style="color: #808080;">|</span> ROW <span style="color: #808080;">|</span>
  17. <span style="color: #808080;">+</span><span style="color: #008080;">--</span><span style="color: #008080;">-------------+-------+</span>
  18. <span style="color: #800000; font-weight: bold;">1</span> row <span style="color: #808080;">in</span> <span style="color: #0000ff;">set</span> (<span style="color: #800000; font-weight: bold;">0.01</span><span style="color: #000000;"> sec)
  19. root</span><span style="color: #008000;">@localhost</span> localhost <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">25</span>:<span style="color: #800000; font-weight: bold;">06</span> abc<span style="color: #808080;">></span><span style="color: #0000ff;">create</span> <span style="color: #0000ff;">database</span><span style="color: #000000;"> test1;
  20. Query OK, </span><span style="color: #800000; font-weight: bold;">1</span> row affected (<span style="color: #800000; font-weight: bold;">0.00</span><span style="color: #000000;"> sec)
  21. root</span><span style="color: #008000;">@localhost</span> localhost <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">25</span>:<span style="color: #800000; font-weight: bold;">28</span> abc<span style="color: #808080;">></span><span style="color: #0000ff;">use</span><span style="color: #000000;"> test1;
  22. </span><span style="color: #0000ff;">Database</span><span style="color: #000000;"> changed
  23. root</span><span style="color: #008000;">@localhost</span> localhost <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">25</span>:<span style="color: #800000; font-weight: bold;">34</span> test1<span style="color: #808080;">></span><span style="color: #0000ff;">CREATE</span> <span style="color: #0000ff;">TABLE</span><span style="color: #000000;"> `abc` (
  24. </span><span style="color: #808080;">-></span> `id` <span style="color: #0000ff;">int</span>(<span style="color: #800000; font-weight: bold;">11</span>) <span style="color: #808080;">NOT</span> <span style="color: #0000ff;">NULL</span><span style="color: #000000;"> AUTO_INCREMENT,
  25. </span><span style="color: #808080;">-></span> `c1` <span style="color: #0000ff;">int</span>(<span style="color: #800000; font-weight: bold;">11</span>) <span style="color: #0000ff;">DEFAULT</span> <span style="color: #0000ff;">NULL</span><span style="color: #000000;">,
  26. </span><span style="color: #808080;">-></span> <span style="color: #0000ff;">PRIMARY</span> <span style="color: #0000ff;">KEY</span><span style="color: #000000;"> (`id`),
  27. </span><span style="color: #808080;">-></span> <span style="color: #0000ff;">KEY</span><span style="color: #000000;"> `shouji` (`c1`) USING BTREE
  28. </span><span style="color: #808080;">-></span> ) ENGINE<span style="color: #808080;">=</span>InnoDB AUTO_INCREMENT<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1</span> <span style="color: #0000ff;">DEFAULT</span> CHARSET<span style="color: #808080;">=</span><span style="color: #000000;">utf8;
  29. Query OK, </span><span style="color: #800000; font-weight: bold;">0</span> rows affected (<span style="color: #800000; font-weight: bold;">0.01</span><span style="color: #000000;"> sec)
  30. </span><span style="color: #ff0000;">
  31. root@localhost localhost 15:26:12 test1>insert into abc(c1) values (1);
  32. Query OK, 1 row affected (0.13 sec)
  33. root@localhost localhost 15:26:23 test1>insert into abc(c1) values (2),(3);
  34. Query OK, 2 rows affected (0.02 sec)
  35. Records: 2 Duplicates: 0 Warnings: 0
  36. root@localhost localhost 15:26:43 test1>delete from abc where id=2;
  37. Query OK, 1 row affected (0.00 sec)
  38. root@localhost localhost 15:26:58 test1>select * from abc;
  39. +----+------+
  40. | id | c1 |
  41. +----+------+
  42. | 1 | 1 |
  43. | 3 | 3 |
  44. +----+------+
  45. 2 rows in set (0.00 sec)<br><br></span>

root@localhost localhost 15:47:38 test1>show master status;
+------------------+----------+--------------+------------------+------------------------------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+------------------------------------------+
| mysql-bin.000001 | 1361 | | | 0f943fa6-3117-11ea-a98d-005056b351ef:1-5 |
+------------------+----------+--------------+------------------+------------------------------------------+
1 row in set (0.00 sec)

root@localhost localhost 15:48:27 test1>show binlog events in ‘mysql-bin.000001‘\G;
*************************** 1. row ***************************
Log_name: mysql-bin.000001
Pos: 4
Event_type: Format_desc
Server_id: 1007231
End_log_pos: 123
Info: Server ver: 5.7.19-log, Binlog ver: 4
*************************** 2. row ***************************
Log_name: mysql-bin.000001
Pos: 123
Event_type: Previous_gtids
Server_id: 1007231
End_log_pos: 150
Info:
*************************** 3. row ***************************
Log_name: mysql-bin.000001
Pos: 150
Event_type: Gtid
Server_id: 1007231
End_log_pos: 211
Info: SET @@SESSION.GTID_NEXT= ‘0f943fa6-3117-11ea-a98d-005056b351ef:1‘
*************************** 4. row ***************************
Log_name: mysql-bin.000001
Pos: 211
Event_type: Query
Server_id: 1007231
End_log_pos: 304
Info: create database test1
*************************** 5. row ***************************
Log_name: mysql-bin.000001
Pos: 304
Event_type: Gtid
Server_id: 1007231
End_log_pos: 365
Info: SET @@SESSION.GTID_NEXT= ‘0f943fa6-3117-11ea-a98d-005056b351ef:2‘
*************************** 6. row ***************************
Log_name: mysql-bin.000001
Pos: 365
Event_type: Query
Server_id: 1007231
End_log_pos: 629
Info: use `test1`; CREATE TABLE `abc` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`c1` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `shouji` (`c1`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
*************************** 7. row ***************************
Log_name: mysql-bin.000001
Pos: 629
Event_type: Gtid
Server_id: 1007231
End_log_pos: 690
Info: SET @@SESSION.GTID_NEXT= ‘0f943fa6-3117-11ea-a98d-005056b351ef:3‘
*************************** 8. row ***************************
Log_name: mysql-bin.000001
Pos: 690
Event_type: Query
Server_id: 1007231
End_log_pos: 759
Info: BEGIN
*************************** 9. row ***************************
Log_name: mysql-bin.000001
Pos: 759
Event_type: Table_map
Server_id: 1007231
End_log_pos: 803
Info: table_id: 220 (test1.abc)
*************************** 10. row ***************************
Log_name: mysql-bin.000001
Pos: 803
Event_type: Write_rows
Server_id: 1007231
End_log_pos: 843
Info: table_id: 220 flags: STMT_END_F
*************************** 11. row ***************************
Log_name: mysql-bin.000001
Pos: 843
Event_type: Xid
Server_id: 1007231
End_log_pos: 870
Info: COMMIT /* xid=52 */
*************************** 12. row ***************************
Log_name: mysql-bin.000001
Pos: 870
Event_type: Gtid
Server_id: 1007231
End_log_pos: 931
Info: SET @@SESSION.GTID_NEXT= ‘0f943fa6-3117-11ea-a98d-005056b351ef:4‘
*************************** 13. row ***************************
Log_name: mysql-bin.000001
Pos: 931
Event_type: Query
Server_id: 1007231
End_log_pos: 1000
Info: BEGIN
*************************** 14. row ***************************
Log_name: mysql-bin.000001
Pos: 1000
Event_type: Table_map
Server_id: 1007231
End_log_pos: 1044
Info: table_id: 220 (test1.abc)
*************************** 15. row ***************************
Log_name: mysql-bin.000001
Pos: 1044
Event_type: Write_rows
Server_id: 1007231
End_log_pos: 1093
Info: table_id: 220 flags: STMT_END_F
*************************** 16. row ***************************
Log_name: mysql-bin.000001
Pos: 1093
Event_type: Xid
Server_id: 1007231
End_log_pos: 1120
Info: COMMIT /* xid=53 */
*************************** 17. row ***************************
Log_name: mysql-bin.000001
Pos: 1120
Event_type: Gtid
Server_id: 1007231
End_log_pos: 1181
Info: SET @@SESSION.GTID_NEXT= ‘0f943fa6-3117-11ea-a98d-005056b351ef:5‘
*************************** 18. row ***************************
Log_name: mysql-bin.000001
Pos: 1181
Event_type: Query
Server_id: 1007231
End_log_pos: 1250
Info: BEGIN
*************************** 19. row ***************************
Log_name: mysql-bin.000001
Pos: 1250
Event_type: Table_map
Server_id: 1007231
End_log_pos: 1294
Info: table_id: 220 (test1.abc)
*************************** 20. row ***************************
Log_name: mysql-bin.000001
Pos: 1294
Event_type: Delete_rows
Server_id: 1007231
End_log_pos: 1334
Info: table_id: 220 flags: STMT_END_F
*************************** 21. row ***************************
Log_name: mysql-bin.000001
Pos: 1334
Event_type: Xid
Server_id: 1007231
End_log_pos: 1361
Info: COMMIT /* xid=54 */
21 rows in set (0.00 sec)

  1. <span style="color: #ff0000;"> </span>

下面是mysqlbinlog命令的参数，摘自官方文档

选项名称描述引用弃用
--base64-output
 使用base-64编码打印二进制日志条目    
--bind-address 使用指定的网络接口连接到MySQL Server    
--binlog-row-event-max-size 二进制日志最大事件大小    
--character-sets-dir 字符集的安装目录    
--connection-server-id 用于测试和调试。有关适用的默认值和其他详细信息，请参见文本 5.7.5  
--database
 仅列出该数据库的条目    
--debug 编写调试日志    
--debug-check 程序退出时打印调试信息    
--debug-info 程序退出时打印调试信息，内存和CPU统计信息    
--default-auth 身份验证插件使用    
--defaults-extra-file 除了通常的选项文件，还读取命名的选项文件    
--defaults-file 只读命名的选项文件    
--defaults-group-suffix 选项组后缀值    
--disable-log-bin 禁用二进制日志记录    
--exclude-gtids 不要显示提供的GTID集中的任何组    
--force-if-open 读取二进制日志文件，即使打开或未正确关闭    
--force-read 如果mysqlbinlog读取了无法识别的二进制日志事件，则会输出警告    
--get-server-public-key 从服务器请求RSA公钥 5.7.23  
--help 显示帮助信息并退出    
--hexdump 显示登录注释的十六进制转储    
--host MySQL服务器所在的主机    
--idempotent 仅在处理来自此会话的二进制日志更新时，导致服务器使用幂等模式 5.7.0  
--include-gtids 仅显示提供的GTID集中的组    
--local-load 在指定目录中为LOAD DATA准备本地临时文件    
--login-path 从.mylogin.cnf中读取登录路径选项    
--no-defaults 不读取选项文件    
--offset 跳过日志中的前N个条目    
open_files_limit 指定要保留的打开文件描述符的数量    
--password 连接服务器时使用的密码    
--plugin-dir 安装插件的目录    
--port 用于连接的TCP / IP端口号    
--print-defaults 打印默认选项    
--protocol 使用的连接协议    
--raw 将事件以原始（二进制）格式写入输出文件    
--read-from-remote-master 从MySQL主服务器读取二进制日志，而不是读取本地日志文件    
--read-from-remote-server 从MySQL服务器而不是本地日志文件中读取二进制日志    
--result-file 直接输出到命名文件    
--rewrite-db 从基于行的格式编写的日志中播放时，为数据库创建重写规则。可多次使用 5.7.1  
--secure-auth 不要以旧（4.1之前）格式向服务器发送密码 5.7.4 5.7.5
--server-id 仅提取由具有给定服务器ID的服务器创建的那些事件    
--server-id-bits 告诉mysqlbinlog当mysqld编写的server-id-bits设置为小于最大值时，如何解释二进制日志中的服务器ID；仅受MySQL Cluster版本的mysqlbinlog支持    
--server-public-key-path 包含RSA公钥的文件的路径名 5.7.23  
--set-charset 在输出中添加SET NAMES charset_name语句    
--shared-memory-base-name 用于共享内存连接的共享内存的名称    
--short-form 仅显示日志中包含的语句    
--skip-gtids 不要打印任何GTID。从包含GTID的二进制日志写入转储文件时使用此功能    
--socket Unix套接字文件或Windows命名管道使用    
--ssl 启用连接加密 5.7.3  
--ssl-ca 包含受信任的SSL证书颁发机构列表的文件 5.7.3  
--ssl-capath 包含受信任的SSL证书颁发机构证书文件的目录 5.7.3  
--ssl-cert 包含X.509证书的文件 5.7.3  
--ssl-cipher 连接加密的允许密码 5.7.3  
--ssl-crl 包含证书吊销列表的文件    
--ssl-crlpath 包含证书吊销列表文件的目录    
--ssl-key 包含X.509密钥的文件 5.7.3  
--ssl-mode 与服务器连接的所需安全状态 5.7.11  
--ssl-verify-server-cert 根据服务器证书的公用名身份验证主机名 5.7.3  
--start-datetime 从第一个事件中读取时间戳等于或晚于datetime参数的二进制日志    
--start-position 从位置等于或大于参数的第一个事件读取二进制日志    
--stop-datetime 在时间戳等于或大于datetime参数的第一个事件时停止读取二进制日志    
--stop-never 读取最后一个二进制日志文件后保持与服务器的连接    
--stop-never-slave-server-id 连接到服务器时要报告的从服务器ID    
--stop-position 在第一个事件中停止读取二进制日志，且位置等于或大于参数    
--tls-version 允许的TLS协议进行加密连接 5.7.10  
--to-last-log 不要在从MySQL服务器请求的二进制日志的结尾处停止，而要继续打印到最后一个二进制日志的结尾    
--user 连接服务器时要使用的MySQL用户名    
--verbose 将行事件重建为SQL语句    
--verify-binlog-checksum 验证二进制日志中的校验和    

 

  1. <span style="color: #ff0000;">[</span><span style="color: #ff0000;">root@localhost mysql</span><span style="color: #ff0000;">]</span># mysqlbinlog mysql<span style="color: #808080;">-</span>bin.<span style="color: #800000; font-weight: bold;">000001</span> <span style="color: #808080;">>/</span>data<span style="color: #808080;">/</span>tmp<span style="color: #808080;">/</span><span style="color: #000000;">mysqlbinlog.sql
  2. </span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">root@localhost mysql</span><span style="color: #ff0000;">]</span># cat <span style="color: #808080;">/</span>data<span style="color: #808080;">/</span>tmp<span style="color: #808080;">/</span><span style="color: #000000;">mysqlbinlog.sql
  3. </span><span style="color: #008080;">/*</span><span style="color: #008080;">!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  4. </span><span style="color: #008080;">/*</span><span style="color: #008080;">!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  5. DELIMITER </span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  6. # at </span><span style="color: #800000; font-weight: bold;">4</span><span style="color: #000000;">
  7. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">45</span>:<span style="color: #800000; font-weight: bold;">15</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">123</span>     Start: binlog v <span style="color: #800000; font-weight: bold;">4</span>, server v <span style="color: #800000; font-weight: bold;">5.7</span>.<span style="color: #800000; font-weight: bold;">19</span><span style="color: #808080;">-</span><span style="color: #ff00ff;">log</span> created <span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">45</span>:<span style="color: #800000; font-weight: bold;">15</span><span style="color: #000000;"> at startup
  8. # Warning: this binlog </span><span style="color: #0000ff;">is</span> either <span style="color: #808080;">in</span> <span style="color: #0000ff;">use</span> <span style="color: #808080;">or</span> was <span style="color: #808080;">not</span><span style="color: #000000;"> closed properly.
  9. </span><span style="color: #0000ff;">ROLLBACK</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  10. BINLOG </span><span style="color: #ff0000;">‘</span><span style="color: #ff0000;">
  11. CzcUXg9/Xg8AdwAAAHsAAAABAAQANS43LjE5LWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
  12. AAAAAAAAAAAAAAAAAAALNxReEzgNAAgAEgAEBAQEEgAAXwAEGggAAAAICAgCAAAACgoKKioAEjQA
  13. AEJXKj0=
  14. </span><span style="color: #ff0000;">‘</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  15. # at </span><span style="color: #800000; font-weight: bold;">123</span><span style="color: #000000;">
  16. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">45</span>:<span style="color: #800000; font-weight: bold;">15</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">150</span>     Previous<span style="color: #808080;">-</span><span style="color: #000000;">GTIDs
  17. # </span><span style="color: #ff0000;">[</span><span style="color: #ff0000;">empty</span><span style="color: #ff0000;">]</span><span style="color: #000000;">
  18. # at </span><span style="color: #800000; font-weight: bold;">150</span><span style="color: #000000;">
  19. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">45</span>:<span style="color: #800000; font-weight: bold;">53</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">211</span>     GTID    last_committed<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">0</span>    sequence_number<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1</span>    rbr_only<span style="color: #808080;">=</span><span style="color: #000000;">no
  20. </span><span style="color: #0000ff;">SET</span> <span style="color: #008000; font-weight: bold;">@@SESSION</span>.GTID_NEXT<span style="color: #808080;">=</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">0f943fa6-3117-11ea-a98d-005056b351ef:1</span><span style="color: #ff0000;">‘</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  21. # at </span><span style="color: #800000; font-weight: bold;">211</span><span style="color: #000000;">
  22. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">45</span>:<span style="color: #800000; font-weight: bold;">53</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">304</span>     Query    thread_id<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">3</span>    exec_time<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">0</span>    error_code<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">0</span>
  23. <span style="color: #0000ff;">SET</span> <span style="color: #0000ff;">TIMESTAMP</span><span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1578383153</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  24. </span><span style="color: #0000ff;">SET</span> <span style="color: #008000; font-weight: bold;">@@session</span>.pseudo_thread_id<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">3</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  25. </span><span style="color: #0000ff;">SET</span> <span style="color: #008000; font-weight: bold;">@@session</span>.foreign_key_checks<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1</span>, <span style="color: #008000; font-weight: bold;">@@session</span>.sql_auto_is_null<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">0</span>, <span style="color: #008000; font-weight: bold;">@@session</span>.unique_checks<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1</span>, <span style="color: #008000; font-weight: bold;">@@session</span>.autocommit<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  26. </span><span style="color: #0000ff;">SET</span> <span style="color: #008000; font-weight: bold;">@@session</span>.sql_mode<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1344274432</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  27. </span><span style="color: #0000ff;">SET</span> <span style="color: #008000; font-weight: bold;">@@session</span>.auto_increment_increment<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1</span>, <span style="color: #008000; font-weight: bold;">@@session</span>.auto_increment_offset<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  28. </span><span style="color: #008080;">/*</span><span style="color: #008080;">!\C utf8mb4 </span><span style="color: #008080;">*//*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  29. </span><span style="color: #0000ff;">SET</span> <span style="color: #008000; font-weight: bold;">@@session</span>.character_set_client<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">224</span>,<span style="color: #008000; font-weight: bold;">@@session</span>.collation_connection<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">224</span>,<span style="color: #008000; font-weight: bold;">@@session</span>.collation_server<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">224</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  30. </span><span style="color: #0000ff;">SET</span> <span style="color: #008000; font-weight: bold;">@@session</span>.lc_time_names<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">0</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  31. </span><span style="color: #0000ff;">SET</span> <span style="color: #008000; font-weight: bold;">@@session</span>.collation_database<span style="color: #808080;">=</span><span style="color: #0000ff;">DEFAULT</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  32. </span><span style="color: #0000ff;">create</span> <span style="color: #0000ff;">database</span><span style="color: #000000;"> test1
  33. </span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  34. # at </span><span style="color: #800000; font-weight: bold;">304</span><span style="color: #000000;">
  35. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">46</span>:<span style="color: #800000; font-weight: bold;">38</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">365</span>     GTID    last_committed<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1</span>    sequence_number<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">2</span>    rbr_only<span style="color: #808080;">=</span><span style="color: #000000;">no
  36. </span><span style="color: #0000ff;">SET</span> <span style="color: #008000; font-weight: bold;">@@SESSION</span>.GTID_NEXT<span style="color: #808080;">=</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">0f943fa6-3117-11ea-a98d-005056b351ef:2</span><span style="color: #ff0000;">‘</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  37. # at </span><span style="color: #800000; font-weight: bold;">365</span><span style="color: #000000;">
  38. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">46</span>:<span style="color: #800000; font-weight: bold;">38</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">629</span>     Query    thread_id<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">3</span>    exec_time<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">0</span>    error_code<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">0</span>
  39. <span style="color: #0000ff;">use</span> `test1`<span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  40. </span><span style="color: #0000ff;">SET</span> <span style="color: #0000ff;">TIMESTAMP</span><span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1578383198</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  41. </span><span style="color: #0000ff;">CREATE</span> <span style="color: #0000ff;">TABLE</span><span style="color: #000000;"> `abc` (
  42. `id` </span><span style="color: #0000ff;">int</span>(<span style="color: #800000; font-weight: bold;">11</span>) <span style="color: #808080;">NOT</span> <span style="color: #0000ff;">NULL</span><span style="color: #000000;"> AUTO_INCREMENT,
  43. `c1` </span><span style="color: #0000ff;">int</span>(<span style="color: #800000; font-weight: bold;">11</span>) <span style="color: #0000ff;">DEFAULT</span> <span style="color: #0000ff;">NULL</span><span style="color: #000000;">,
  44. </span><span style="color: #0000ff;">PRIMARY</span> <span style="color: #0000ff;">KEY</span><span style="color: #000000;"> (`id`),
  45. </span><span style="color: #0000ff;">KEY</span><span style="color: #000000;"> `shouji` (`c1`) USING BTREE
  46.  ) ENGINE</span><span style="color: #808080;">=</span>InnoDB AUTO_INCREMENT<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1</span> <span style="color: #0000ff;">DEFAULT</span> CHARSET<span style="color: #808080;">=</span><span style="color: #000000;">utf8
  47. </span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  48. # at </span><span style="color: #800000; font-weight: bold;">629</span><span style="color: #000000;">
  49. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">47</span>:<span style="color: #800000; font-weight: bold;">15</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">690</span>     GTID    last_committed<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">2</span>    sequence_number<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">3</span>    rbr_only<span style="color: #808080;">=</span><span style="color: #000000;">yes
  50. </span><span style="color: #008080;">/*</span><span style="color: #008080;">!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED</span><span style="color: #008080;">*//*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  51. </span><span style="color: #0000ff;">SET</span> <span style="color: #008000; font-weight: bold;">@@SESSION</span>.GTID_NEXT<span style="color: #808080;">=</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">0f943fa6-3117-11ea-a98d-005056b351ef:3</span><span style="color: #ff0000;">‘</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  52. # at </span><span style="color: #800000; font-weight: bold;">690</span><span style="color: #000000;">
  53. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">47</span>:<span style="color: #800000; font-weight: bold;">15</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">759</span>     Query    thread_id<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">3</span>    exec_time<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">0</span>    error_code<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">0</span>
  54. <span style="color: #0000ff;">SET</span> <span style="color: #0000ff;">TIMESTAMP</span><span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1578383235</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  55. </span><span style="color: #0000ff;">BEGIN</span>
  56. <span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  57. # at </span><span style="color: #800000; font-weight: bold;">759</span><span style="color: #000000;">
  58. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">47</span>:<span style="color: #800000; font-weight: bold;">15</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">803</span>     Table_map: `test1`.`abc` mapped <span style="color: #0000ff;">to</span> <span style="color: #0000ff;">number</span> <span style="color: #800000; font-weight: bold;">220</span><span style="color: #000000;">
  59. # at </span><span style="color: #800000; font-weight: bold;">803</span><span style="color: #000000;">
  60. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">47</span>:<span style="color: #800000; font-weight: bold;">15</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">843</span>     Write_rows: <span style="color: #0000ff;">table</span> id <span style="color: #800000; font-weight: bold;">220</span><span style="color: #000000;"> flags: STMT_END_F
  61. BINLOG </span><span style="color: #ff0000;">‘</span><span style="color: #ff0000;">
  62. gzcUXhN/Xg8ALAAAACMDAAAAANwAAAAAAAEABXRlc3QxAANhYmMAAgMDAAI=
  63. gzcUXh5/Xg8AKAAAAEsDAAAAANwAAAAAAAEAAgAC//wBAAAAAQAAAA==
  64. </span><span style="color: #ff0000;">‘</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  65. # at </span><span style="color: #800000; font-weight: bold;">843</span><span style="color: #000000;">
  66. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">47</span>:<span style="color: #800000; font-weight: bold;">15</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">870</span>     Xid <span style="color: #808080;">=</span> <span style="color: #800000; font-weight: bold;">52</span>
  67. <span style="color: #0000ff;">COMMIT</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  68. # at </span><span style="color: #800000; font-weight: bold;">870</span><span style="color: #000000;">
  69. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">47</span>:<span style="color: #800000; font-weight: bold;">23</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">931</span>     GTID    last_committed<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">3</span>    sequence_number<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">4</span>    rbr_only<span style="color: #808080;">=</span><span style="color: #000000;">yes
  70. </span><span style="color: #008080;">/*</span><span style="color: #008080;">!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED</span><span style="color: #008080;">*//*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  71. </span><span style="color: #0000ff;">SET</span> <span style="color: #008000; font-weight: bold;">@@SESSION</span>.GTID_NEXT<span style="color: #808080;">=</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">0f943fa6-3117-11ea-a98d-005056b351ef:4</span><span style="color: #ff0000;">‘</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  72. # at </span><span style="color: #800000; font-weight: bold;">931</span><span style="color: #000000;">
  73. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">47</span>:<span style="color: #800000; font-weight: bold;">23</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">1000</span>     Query    thread_id<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">3</span>    exec_time<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">0</span>    error_code<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">0</span>
  74. <span style="color: #0000ff;">SET</span> <span style="color: #0000ff;">TIMESTAMP</span><span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1578383243</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  75. </span><span style="color: #0000ff;">BEGIN</span>
  76. <span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  77. # at </span><span style="color: #800000; font-weight: bold;">1000</span><span style="color: #000000;">
  78. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">47</span>:<span style="color: #800000; font-weight: bold;">23</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">1044</span>     Table_map: `test1`.`abc` mapped <span style="color: #0000ff;">to</span> <span style="color: #0000ff;">number</span> <span style="color: #800000; font-weight: bold;">220</span><span style="color: #000000;">
  79. # at </span><span style="color: #800000; font-weight: bold;">1044</span><span style="color: #000000;">
  80. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">47</span>:<span style="color: #800000; font-weight: bold;">23</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">1093</span>     Write_rows: <span style="color: #0000ff;">table</span> id <span style="color: #800000; font-weight: bold;">220</span><span style="color: #000000;"> flags: STMT_END_F
  81. BINLOG </span><span style="color: #ff0000;">‘</span><span style="color: #ff0000;">
  82. izcUXhN/Xg8ALAAAABQEAAAAANwAAAAAAAEABXRlc3QxAANhYmMAAgMDAAI=
  83. izcUXh5/Xg8AMQAAAEUEAAAAANwAAAAAAAEAAgAC//wCAAAAAgAAAPwDAAAAAwAAAA==
  84. </span><span style="color: #ff0000;">‘</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  85. # at </span><span style="color: #800000; font-weight: bold;">1093</span><span style="color: #000000;">
  86. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">47</span>:<span style="color: #800000; font-weight: bold;">23</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">1120</span>     Xid <span style="color: #808080;">=</span> <span style="color: #800000; font-weight: bold;">53</span>
  87. <span style="color: #0000ff;">COMMIT</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  88. # at </span><span style="color: #800000; font-weight: bold;">1120</span><span style="color: #000000;">
  89. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">47</span>:<span style="color: #800000; font-weight: bold;">30</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">1181</span>     GTID    last_committed<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">4</span>    sequence_number<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">5</span>    rbr_only<span style="color: #808080;">=</span><span style="color: #000000;">yes
  90. </span><span style="color: #008080;">/*</span><span style="color: #008080;">!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED</span><span style="color: #008080;">*//*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  91. </span><span style="color: #0000ff;">SET</span> <span style="color: #008000; font-weight: bold;">@@SESSION</span>.GTID_NEXT<span style="color: #808080;">=</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">0f943fa6-3117-11ea-a98d-005056b351ef:5</span><span style="color: #ff0000;">‘</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  92. # at </span><span style="color: #800000; font-weight: bold;">1181</span><span style="color: #000000;">
  93. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">47</span>:<span style="color: #800000; font-weight: bold;">30</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">1250</span>     Query    thread_id<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">3</span>    exec_time<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">0</span>    error_code<span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">0</span>
  94. <span style="color: #0000ff;">SET</span> <span style="color: #0000ff;">TIMESTAMP</span><span style="color: #808080;">=</span><span style="color: #800000; font-weight: bold;">1578383250</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  95. </span><span style="color: #0000ff;">BEGIN</span>
  96. <span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  97. # at </span><span style="color: #800000; font-weight: bold;">1250</span><span style="color: #000000;">
  98. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">47</span>:<span style="color: #800000; font-weight: bold;">30</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">1294</span>     Table_map: `test1`.`abc` mapped <span style="color: #0000ff;">to</span> <span style="color: #0000ff;">number</span> <span style="color: #800000; font-weight: bold;">220</span><span style="color: #000000;">
  99. # at </span><span style="color: #800000; font-weight: bold;">1294</span><span style="color: #000000;">
  100. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">47</span>:<span style="color: #800000; font-weight: bold;">30</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">1334</span>     Delete_rows: <span style="color: #0000ff;">table</span> id <span style="color: #800000; font-weight: bold;">220</span><span style="color: #000000;"> flags: STMT_END_F
  101. BINLOG </span><span style="color: #ff0000;">‘</span><span style="color: #ff0000;">
  102. kjcUXhN/Xg8ALAAAAA4FAAAAANwAAAAAAAEABXRlc3QxAANhYmMAAgMDAAI=
  103. kjcUXiB/Xg8AKAAAADYFAAAAANwAAAAAAAEAAgAC//wCAAAAAgAAAA==
  104. </span><span style="color: #ff0000;">‘</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  105. # at </span><span style="color: #800000; font-weight: bold;">1334</span><span style="color: #000000;">
  106. #</span><span style="color: #800000; font-weight: bold;">200107</span> <span style="color: #800000; font-weight: bold;">15</span>:<span style="color: #800000; font-weight: bold;">47</span>:<span style="color: #800000; font-weight: bold;">30</span> server id <span style="color: #800000; font-weight: bold;">1007231</span>  end_log_pos <span style="color: #800000; font-weight: bold;">1361</span>     Xid <span style="color: #808080;">=</span> <span style="color: #800000; font-weight: bold;">54</span>
  107. <span style="color: #0000ff;">COMMIT</span><span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  108. </span><span style="color: #0000ff;">SET</span> <span style="color: #008000; font-weight: bold;">@@SESSION</span>.GTID_NEXT<span style="color: #808080;">=</span> <span style="color: #ff0000;">‘</span><span style="color: #ff0000;">AUTOMATIC</span><span style="color: #ff0000;">‘</span> <span style="color: #008080;">/*</span><span style="color: #008080;"> added by mysqlbinlog </span><span style="color: #008080;">*/</span> <span style="color: #008080;">/*</span><span style="color: #008080;">!</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  109. DELIMITER ;
  110. # </span><span style="color: #0000ff;">End</span> <span style="color: #0000ff;">of</span> <span style="color: #ff00ff;">log</span> <span style="color: #0000ff;">file</span>
  111. <span style="color: #008080;">/*</span><span style="color: #008080;">!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE</span><span style="color: #008080;">*/</span><span style="color: #000000;">;
  112. </span><span style="color: #00                    </div>
  113.                   
  114.  
  115.                     <div class=" "="">
  116.                         <ul class="m-news-opt fix">
  117.                             <li class="opt-item">
  118.                                 <a href="/sql_question-390600.html" target="_blank"><p>< 上一篇</p><p class="ellipsis">SpringBoot 2.X集成 jdbc自动配置原理探究</p></a>
  119.                             </li>
  120.                             <li class="opt-item ta-r">
  121.                                  <a href="/sql_question-390602.html" target="_blank"><p>下一篇 ></p><p class="ellipsis">ubuntu 安装mysql 重置密码并远程连接</p></a>
  122.                             </li>
  123.                         </ul>
  124.                     </span>

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！