为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:2.1
- 【问题描述】:insert数据慢
系统信息
+-------------------------+----------------------------+
| Host | Release |
+-------------------------+----------------------------+
| iZbp1e5ffofgmrvniuozyzZ | 3.10.0-957.21.3.el7.x86_64 |
| iZbp1e5ffofgmrvniuozyyZ | 3.10.0-957.21.3.el7.x86_64 |
| iZbp19jkykx0eigvjvnfebZ | 3.10.0-957.21.3.el7.x86_64 |
| iZbp19jkykx0eigvjvnfeaZ | 3.10.0-957.21.3.el7.x86_64 |
| iZbp19jkykx0eigvjvnfe9Z | 3.10.0-957.21.3.el7.x86_64 |
| iZbp1i0nrydzztekp823a3Z | 3.10.0-957.21.3.el7.x86_64 |
| iZbp1i0nrydzztekp823a4Z | 3.10.0-957.21.3.el7.x86_64 |
| iZbp1i0nrydzztekp823a5Z | 3.10.0-957.21.3.el7.x86_64 |
| iZbp1ee5ye356ifjoltsc1Z | 3.10.0-957.21.3.el7.x86_64 |
+-------------------------+----------------------------+
TiDB 集群信息
+---------------------+--------------+------+----+------+
| TiDB_version | Clu_replicas | TiDB | PD | TiKV |
+---------------------+--------------+------+----+------+
| 5.7.25-TiDB-v2.1.14 | 3 | 2 | 3 | 3 |
+---------------------+--------------+------+----+------+
集群节点信息
+------------+-------------+
| Node_IP | Server_info |
+------------+-------------+
| instance_0 | pd |
| instance_1 | pd |
| instance_2 | tidb |
| instance_3 | tidb |
| instance_4 | tikv |
| instance_5 | tikv |
| instance_6 | tikv |
| instance_7 | pd |
+------------+-------------+
容量 & region 数量
+---------------------+-----------------+--------------+
| Storage_capacity_GB | Storage_uesd_GB | Region_count |
+---------------------+-----------------+--------------+
| 1476.07 | 935.45 | 74229 |
+---------------------+-----------------+--------------+
QPS
+---------+----------------+-----------------+
| Clu_QPS | Duration_99_MS | Duration_999_MS |
+---------+----------------+-----------------+
| 1135.91 | 115.24 | 224.97 |
+---------+----------------+-----------------+
热点 region 信息
+---------------+----------+-----------+
| Store | Hot_read | Hot_write |
+---------------+----------+-----------+
| store-store_5 | 0 | 1 |
| store-store_4 | 1 | 2 |
| store-store_1 | 0 | 1 |
+---------------+----------+-----------+
磁盘延迟信息
+--------+----------+-------------+--------------+
| Device | Instance | Read_lat_MS | Write_lat_MS |
+--------+----------+-------------+--------------+
表结构
数据量大概在37亿左右