为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:v3.0.9
- 【问题描述】:dm-同步 过程慢,大量insert 慢日志,loading完成后,sync 速度也慢,同步延迟太大
{‘tidb_log_dir’: ‘{{ deploy_dir }}/log’, ‘dummy’: None, ‘tidb_port’: 4000, ‘tidb_status_port’: 10080, ‘tidb_cert_dir’: '{{ deploy_dir }}/co
系统信息
+-----------------------+---------------------------+
| Host | Release |
+-----------------------+---------------------------+
| tidb-pd-001-116-173 | 3.10.0-693.2.2.el7.x86_64 |
| tidb-pd-002-116-184 | 3.10.0-693.2.2.el7.x86_64 |
| tidb-tikv-001-116-190 | 3.10.0-693.2.2.el7.x86_64 |
| tidb-tikv-002-116-191 | 3.10.0-693.2.2.el7.x86_64 |
| tidb-tikv-003-116-192 | 3.10.0-693.2.2.el7.x86_64 |
+-----------------------+---------------------------+
TiDB 集群信息
+--------------------+--------------+------+----+------+
| TiDB_version | Clu_replicas | TiDB | PD | TiKV |
+--------------------+--------------+------+----+------+
| 5.7.25-TiDB-v3.0.9 | 3 | 2 | 1 | 3 |
+--------------------+--------------+------+----+------+
集群节点信息
+------------+-------------+
| Node_IP | Server_info |
+------------+-------------+
| instance_4 | tidb |
| instance_1 | tikv |
| instance_0 | tikv |
| instance_3 | tikv |
| instance_2 | pd+tidb |
+------------+-------------+
容量 & region 数量
+---------------------+-----------------+--------------+
| Storage_capacity_GB | Storage_uesd_GB | Region_count |
+---------------------+-----------------+--------------+
| 2700.00 | 864.98 | 28173 |
+---------------------+-----------------+--------------+
QPS
+---------+----------------+-----------------+
| Clu_QPS | Duration_99_MS | Duration_999_MS |
+---------+----------------+-----------------+
| 4170.78 | 51.11 | 125.84 |
+---------+----------------+-----------------+
热点 region 信息
+---------+----------+-----------+
| Store | Hot_read | Hot_write |
+---------+----------+-----------+
| store-1 | 0 | 74 |
| store-5 | 1 | 74 |
| store-4 | 0 | 74 |
+---------+----------+-----------+
磁盘延迟信息
+--------+------------+-------------+--------------+
| Device | Instance | Read_lat_MS | Write_lat_MS |
+--------+------------+-------------+--------------+
| vda | instance_2 | 8.50 | 15.90 |
| vda | instance_4 | nan | 1.67 |
| vda | instance_1 | nan | 1.00 |
| vda | instance_0 | nan | 1.50 |
| vda | instance_3 | nan | 0.83 |
| vdb | instance_2 | nan | 1.03 |
| vdb | instance_4 | nan | 1.00 |
| vdb | instance_1 | 1.14 | 0.24 |
| vdb | instance_0 | 1.62 | 0.07 |
| vdb | instance_3 | 1.08 | 0.23 |
| vdc | instance_1 | nan | nan |
| vdc | instance_0 | nan | nan |
| vdc | instance_3 | nan | nan |
+--------+------------+-------------+--------------+