mysql dump binlog master状态
来源:互联网 发布:安卓 ping软件 编辑:程序博客网 时间:2024/06/07 22:36
遇到个dump binlog延迟增加的问题,发现master上的dump线程状态多数时间是
Finished reading one binlog; switching to next binlog
查问题要看系统IO,可能是dump程序太多,导致IO繁忙;
dba反馈load 8,iowait和ioutil并不高;但是业务在跑定时任务,导致tps很高,tps高会导致dump 变慢?这个之前没有遇到过
mysql> show processlist;+----------+---------+----------------------+------+-------------+---------+-------------------------------------------------------+------------------+-----------+---------------+-----------+| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined | Rows_read |+----------+---------+----------------------+------+-------------+---------+-------------------------------------------------------+------------------+-----------+---------------+-----------+| 18618377 | jw_sync | 172.20.136.45:58226 | NULL | Binlog Dump | 1724575 | Finished reading one binlog; switching to next binlog | NULL | 0 | 0 | 198 || 18618389 | jw_sync | 172.20.150.87:58321 | NULL | Binlog Dump | 1724572 | Finished reading one binlog; switching to next binlog | NULL | 0 | 0 | 198 || 18618665 | jw_sync | 172.20.148.70:37864 | NULL | Binlog Dump | 1724438 | Finished reading one binlog; switching to next binlog | NULL | 0 | 0 | 198 || 21133727 | jw_sync | 172.20.133.18:56499 | NULL | Binlog Dump | 578883 | Finished reading one binlog; switching to next binlog | NULL | 0 | 0 | 198 || 22466211 | jw_sync | 172.23.227.174:60700 | NULL | Query | 0 | NULL | show processlist | 0 | 0 | 2 |+----------+---------+----------------------+------+-------------+---------+-------------------------------------------------------+------------------+-----------+---------------+
Binlog Dump 状态一共4个
1 Sending binlog event to slave
已经读出来,正在发送
2 Finished reading one binlog; switching to next binlog
The thread has finished reading a binary log file and is opening the next one to send to the slave.
3 Master has sent all binlog to slave; waiting for binlog to be updated
等着新的binlog产生
4 Waiting to finalize termination
线程停止时候一个短暂状态
- mysql dump binlog master状态
- Mysql主从同步中Binlog Dump线程僵尸问题
- mysql dump备份恢复,binlog基于时间点的恢复
- MySQL半同步复制--master dump线程1
- MySQL半同步复制--master dump线程2
- MySQL binlog
- mysql binlog
- MySQL binlog
- mysql binlog
- MySQL BinLog
- MySQL binlog
- mysql-binlog
- mysql binlog
- Mysql binlog
- mysql binlog
- MySql binlog
- mysql binlog
- MySQL binlog
- java.lang.Instrumentation作用,虚拟机监控
- JQuery Mobile实现动态下拉框代码
- rman 同机复制数据库
- python的 Digango框架的安装
- FFplay 整体流程图
- mysql dump binlog master状态
- rman 异机复制数据库
- 开关电源基本知识
- Android repo 切换分支
- tomcat 虚拟路径配置的几种方法
- 最短路
- NSString 与UTF8 的字符转换
- XML解析详细介绍
- NSDateFormatter使用总结