pingcap / pingcap/tidb

tidb TP query latency jitter in AP/TP-mixed workload

Open
#41,575 0 comments 0 reactions 1 assignee Claimed by @tiancaiamao View on GitHub
sig/sql-infra type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

Prepare data:

TPCH dataset, for example, you can [prepare the data](https://docs.pingcap.com/tidb/dev/tiup-bench) by

```
tiup bench tpch --sf=10 prepare
```

The TP query:

```
select a.C_NAME,b.O_TOTALPRICE from customer a,orders b where a.C_CUSTKEY=b.O_CUSTKEY and a.C_PHONE=? --随机取select c_phone from customer limit 100000值

mysql> explain analyze select a.C_NAME,b.O_TOTALPRICE from customer a,orders b where a.C_CUSTKEY=b.O_CUSTKEY and a.C_PHONE='10-100-106-1617';
+------------------------------------+---------+---------+-----------+---------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+
| id | estRows | actRows | task | access object | execution info | operator info | memory | disk |
+------------------------------------+---------+---------+-----------+---------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+
| IndexHashJoin_15 | 15.10 | 26 | root | | time:6.47ms, loops:2, inner:{total:4.11ms, concurrency:3, task:1, construct:18.4µs, fetch:4.04ms, build:14.3µs, join:23.4µs} | inner join, inner:IndexLookUp_12, outer key:tpch1.customer.c_custkey, inner key:tpch1.orders.o_custkey, equal cond:eq(tpch1.customer.c_custkey, tpch1.orders.o_custkey) | 89.6 KB | N/A |
| ├─IndexLookUp_50(Build) | 1.02 | 1 | root | | time:2.22ms, loops:3, index_task: {total_time: 1.1ms, fetch_handle: 1.1ms, build: 730ns, wait: 475ns}, table_task: {total_time: 911.1µs, num: 1, concurrency: 3} | | 2.13 KB | N/A |
| │ ├─IndexRangeScan_48(Build) | 1.02 | 1 | cop[tikv] | table:a, index:customer_idx1(C_PHONE) | time:1.1ms, loops:3, cop_task: {num: 1, max: 1.02ms, proc_keys: 1, rpc_num: 1, rpc_time: 960.7µs, copr_cache_hit_ratio: 0.00, distsql_concurrency: 5}, tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 1, total_process_keys_size: 55, total_keys: 2, get_snapshot_time: 180µs, rocksdb: {key_skipped_count: 1, block: {cache_hit_count: 8}}} | range:["10-100-106-1617","10-100-106-1617"], keep order:false | N/A | N/A |
| │ └─TableRowIDScan_49(Probe) | 1.02 | 1 | cop[tikv] | table:a | time:838.4µs, loops:2, cop_task: {num: 1, max: 776.4µs, proc_keys: 1, rpc_num: 1, rpc_time: 759.5µs, copr_cache_hit_ratio: 0.00, distsql_concurrency: 5}, tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 1, total_process_keys_size: 229, total_keys: 1, get_snapshot_time: 103.8µs, rocksdb: {block: {cache_hit_count: 8}}} | keep order:false | N/A | N/A |
| └─IndexLookUp_12(Probe) | 15.10 | 26 | root | | time:4.01ms, loops:2, index_task: {total_time: 898.5µs, fetch_handle: 896.6µs, build: 807ns, wait: 1.03µs}, table_task: {total_time: 3.03ms, num: 1, concurrency: 3} | | 10.2 KB | N/A |
| ├─IndexRangeScan_10(Build) | 15.10 | 26 | cop[tikv] | table:b, index:orders_idx1(O_CUSTKEY) | time:893.3µs, loops:3, cop_task: {num: 1, max: 826.3µs, proc_keys: 26, rpc_num: 1, rpc_time: 810.5µs, copr_cache_hit_ratio: 0.00, distsql_concurrency: 5}, tikv_task:{time:0s, loops:1}, scan_detail: {total_process_keys: 26, total_process_keys_size: 1196, total_keys: 27, get_snapshot_time: 140.5µs, rocksdb: {key_skipped_count: 26, block: {cache_hit_count: 8}}} | range: decided by [eq(tpch1.orders.o_custkey, tpch1.customer.c_custkey)], keep order:false | N/A | N/A |
| └─TableRowIDScan_11(Probe) | 15.10 | 26 | cop[tikv] | table:b | time:2.84ms, loops:2, cop_task: {num: 18, max: 1.59ms, min: 642.9µs, avg: 926.9µs, p95: 1.59ms, max_proc_keys: 3, p95_proc_keys: 3, rpc_num: 18, rpc_time: 16.3ms, copr_cache_hit_ratio: 0.00, distsql_concurrency: 5}, tikv_task:{proc max:1ms, min:0s, avg: 166.7µs, p80:0s, p95:1ms, iters:18, tasks:18}, scan_detail: {total_process_keys: 26, total_process_keys_size: 3908, total_keys: 26, get_snapshot_time: 2.67ms, rocksdb: {block: {cache_hit_count: 154}}} | keep order:false | N/A | N/A |
+------------------------------------+---------+---------+-----------+---------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+
7 rows in set (0.00 sec)
```

The AP query:

```
select max(total),min(total) from (select O_CUSTKEY,O_ORDERDATE,sum(O_TOTALPRICE) total from orders group by O_CUSTKEY,O_ORDERDATE) a;

mysql> explain analyze select max(total),min(total) from (select O_CUSTKEY,O_ORDERDATE,sum(O_TOTALPRICE) total from orders group by O_CUSTKEY,O_ORDERDATE) a;
+------------------------------+-------------+----------+-----------+---------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------+----------+---------+
| id | estRows | actRows | task | access object | execution info | operator info | memory | disk |
+------------------------------+-------------+----------+-----------+---------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------+----------+---------+
| StreamAgg_8 | 1.00 | 1 | root | | time:1m49.8s, loops:2 | funcs:max(Column#10)->Column#11, funcs:min(Column#10)->Column#12 | 40.4 KB | N/A |
| └─HashAgg_20 | 1009664.00 | 14967533 | root | | time:1m49.3s, loops:14618 | group by:tpch1.orders.o_custkey, tpch1.orders.o_orderdate, funcs:sum(Column#14)->Column#10 | 945.9 MB | 2.12 GB |
| └─TableReader_21 | 1009664.00 | 14999907 | root | | time:503.2ms, loops:518, cop_task: {num: 517, max: 3.56s, min: 905.2µs, avg: 54.2ms, p95: 85.2ms, max_proc_keys: 50176, p95_proc_keys: 50176, tot_proc: 25.6s, tot_wait: 1.08s, rpc_num: 517, rpc_time: 28s, copr_cache_hit_ratio: 0.00, distsql_concurrency: 5} | data:HashAgg_17 | 11.6 MB | N/A |
| └─HashAgg_17 | 1009664.00 | 14999907 | cop[tikv] | | tikv_task:{proc max:3.56s, min:0s, avg: 48.6ms, p80:36ms, p95:64ms, iters:14656, tasks:517}, scan_detail: {total_process_keys: 15000000, total_process_keys_size: 2277738682, total_keys: 15000517, get_snapshot_time: 31ms, rocksdb: {key_skipped_count: 15000000, block: {cache_hit_count: 42045}}} | group by:tpch1.orders.o_custkey, tpch1.orders.o_orderdate, funcs:sum(tpch1.orders.o_totalprice)->Column#14 | N/A | N/A |
| └─TableFullScan_12 | 15000000.00 | 15000000 | cop[tikv] | table:orders | tikv_task:{proc max:3.55s, min:0s, avg: 41.2ms, p80:23ms, p95:54ms, iters:14656, tasks:517} | keep order:false | N/A | N/A |
+------------------------------+-------------+----------+-----------+---------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------+----------+---------+
5 rows in set (1 min 49.89 sec)
```

Test program:

[main.go.txt](https://github.com/pingcap/tidb/files/10779473/main.go.txt)

See the latency jitter:

```
[tidb@host0 goproj1]$ ./main -host=192.168.31.201 -dbname="tpch1" -password="root" -delay=30s
time:2023-01-21-22:44:47,conns:10,act_connns:10,qps:5,avg_response_ms:10.45,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:44:48,conns:10,act_connns:10,qps:1996,avg_response_ms:5.02,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:44:49,conns:10,act_connns:10,qps:1923,avg_response_ms:5.20,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:44:50,conns:10,act_connns:10,qps:1985,avg_response_ms:5.04,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:44:51,conns:10,act_connns:10,qps:1931,avg_response_ms:5.17,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:44:52,conns:10,act_connns:10,qps:1957,avg_response_ms:5.11,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:44:53,conns:10,act_connns:10,qps:1917,avg_response_ms:5.22,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:44:54,conns:10,act_connns:10,qps:1942,avg_response_ms:5.15,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:44:55,conns:10,act_connns:10,qps:1929,avg_response_ms:5.18,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:44:56,conns:10,act_connns:10,qps:1953,avg_response_ms:5.11,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:44:57,conns:10,act_connns:10,qps:1864,avg_response_ms:5.38,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:44:58,conns:10,act_connns:10,qps:2013,avg_response_ms:4.96,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:44:59,conns:10,act_connns:10,qps:1886,avg_response_ms:5.30,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:00,conns:10,act_connns:10,qps:1979,avg_response_ms:5.04,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:01,conns:10,act_connns:10,qps:1879,avg_response_ms:5.33,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:02,conns:10,act_connns:10,qps:1964,avg_response_ms:5.09,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:03,conns:10,act_connns:10,qps:1919,avg_response_ms:5.21,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:04,conns:10,act_connns:10,qps:2005,avg_response_ms:4.99,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:05,conns:10,act_connns:10,qps:1908,avg_response_ms:5.24,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:06,conns:10,act_connns:10,qps:2022,avg_response_ms:4.95,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:07,conns:10,act_connns:10,qps:1941,avg_response_ms:5.15,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:08,conns:10,act_connns:10,qps:1981,avg_response_ms:5.05,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:09,conns:10,act_connns:10,qps:1870,avg_response_ms:5.34,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:10,conns:10,act_connns:10,qps:1992,avg_response_ms:5.02,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:12,conns:10,act_connns:10,qps:1982,avg_response_ms:5.05,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:13,conns:10,act_connns:10,qps:1884,avg_response_ms:5.30,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:14,conns:10,act_connns:10,qps:1965,avg_response_ms:5.09,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:15,conns:10,act_connns:10,qps:1923,avg_response_ms:5.19,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:16,conns:10,act_connns:10,qps:2016,avg_response_ms:4.98,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:17,conns:10,act_connns:10,qps:1873,avg_response_ms:5.33,expensive_qps:0,expensive_avg_response_ms:0.00
begin execute expensive sql,parallel:2
time:2023-01-21-22:45:18,conns:12,act_connns:12,qps:1837,avg_response_ms:5.42,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:19,conns:12,act_connns:12,qps:938,avg_response_ms:10.61,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:20,conns:12,act_connns:12,qps:911,avg_response_ms:11.04,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:21,conns:12,act_connns:12,qps:1157,avg_response_ms:8.65,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:22,conns:12,act_connns:12,qps:1145,avg_response_ms:8.73,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:23,conns:12,act_connns:12,qps:990,avg_response_ms:10.05,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:24,conns:12,act_connns:12,qps:964,avg_response_ms:10.42,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:25,conns:12,act_connns:12,qps:360,avg_response_ms:27.30,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:26,conns:12,act_connns:12,qps:164,avg_response_ms:61.57,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:27,conns:12,act_connns:12,qps:250,avg_response_ms:35.88,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:28,conns:12,act_connns:12,qps:738,avg_response_ms:15.03,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:29,conns:12,act_connns:12,qps:803,avg_response_ms:12.49,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:30,conns:12,act_connns:12,qps:760,avg_response_ms:13.17,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:31,conns:12,act_connns:12,qps:822,avg_response_ms:12.17,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:32,conns:12,act_connns:12,qps:799,avg_response_ms:12.49,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:33,conns:12,act_connns:12,qps:798,avg_response_ms:12.53,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:34,conns:12,act_connns:12,qps:773,avg_response_ms:12.97,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:35,conns:12,act_connns:12,qps:814,avg_response_ms:12.28,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:36,conns:12,act_connns:12,qps:744,avg_response_ms:13.43,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:37,conns:12,act_connns:12,qps:786,avg_response_ms:12.69,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:38,conns:12,act_connns:12,qps:651,avg_response_ms:15.39,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:39,conns:12,act_connns:12,qps:472,avg_response_ms:21.16,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:40,conns:12,act_connns:12,qps:469,avg_response_ms:21.34,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:41,conns:12,act_connns:12,qps:492,avg_response_ms:20.40,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:42,conns:12,act_connns:12,qps:470,avg_response_ms:21.21,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:43,conns:12,act_connns:12,qps:464,avg_response_ms:21.55,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:44,conns:12,act_connns:12,qps:496,avg_response_ms:20.22,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:45,conns:12,act_connns:12,qps:512,avg_response_ms:19.42,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:46,conns:12,act_connns:12,qps:650,avg_response_ms:15.49,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:47,conns:12,act_connns:12,qps:1232,avg_response_ms:8.13,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:48,conns:12,act_connns:12,qps:1492,avg_response_ms:6.71,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:49,conns:12,act_connns:12,qps:1523,avg_response_ms:6.56,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:50,conns:12,act_connns:12,qps:1494,avg_response_ms:6.70,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:51,conns:12,act_connns:12,qps:868,avg_response_ms:11.42,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:52,conns:12,act_connns:12,qps:759,avg_response_ms:13.31,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:53,conns:12,act_connns:12,qps:1388,avg_response_ms:7.20,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:54,conns:12,act_connns:12,qps:1324,avg_response_ms:7.55,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:55,conns:12,act_connns:12,qps:1128,avg_response_ms:8.85,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:56,conns:12,act_connns:12,qps:1246,avg_response_ms:8.06,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:57,conns:12,act_connns:12,qps:913,avg_response_ms:10.91,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:58,conns:12,act_connns:12,qps:851,avg_response_ms:11.81,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:45:59,conns:12,act_connns:12,qps:1207,avg_response_ms:8.27,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:00,conns:12,act_connns:12,qps:1202,avg_response_ms:8.31,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:01,conns:12,act_connns:12,qps:1200,avg_response_ms:8.36,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:02,conns:12,act_connns:12,qps:1013,avg_response_ms:9.56,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:03,conns:12,act_connns:12,qps:154,avg_response_ms:63.94,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:04,conns:12,act_connns:12,qps:159,avg_response_ms:61.31,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:05,conns:12,act_connns:12,qps:866,avg_response_ms:12.39,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:06,conns:12,act_connns:12,qps:916,avg_response_ms:10.91,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:07,conns:12,act_connns:12,qps:1214,avg_response_ms:8.19,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:08,conns:12,act_connns:12,qps:392,avg_response_ms:25.09,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:09,conns:12,act_connns:12,qps:162,avg_response_ms:61.25,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:10,conns:12,act_connns:12,qps:494,avg_response_ms:20.84,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:11,conns:12,act_connns:12,qps:578,avg_response_ms:17.30,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:12,conns:12,act_connns:12,qps:756,avg_response_ms:13.30,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:13,conns:12,act_connns:12,qps:1496,avg_response_ms:6.69,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:14,conns:12,act_connns:12,qps:1529,avg_response_ms:6.53,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:15,conns:12,act_connns:12,qps:1562,avg_response_ms:6.42,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:16,conns:12,act_connns:12,qps:1483,avg_response_ms:6.73,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:17,conns:12,act_connns:12,qps:1477,avg_response_ms:6.77,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:18,conns:12,act_connns:12,qps:1363,avg_response_ms:7.35,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:19,conns:12,act_connns:12,qps:1396,avg_response_ms:7.16,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:20,conns:12,act_connns:12,qps:1328,avg_response_ms:7.53,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:21,conns:12,act_connns:12,qps:1276,avg_response_ms:7.83,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:22,conns:12,act_connns:12,qps:1241,avg_response_ms:8.07,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:23,conns:12,act_connns:12,qps:1082,avg_response_ms:9.21,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:24,conns:12,act_connns:12,qps:1335,avg_response_ms:7.47,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:25,conns:12,act_connns:12,qps:1288,avg_response_ms:7.82,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:26,conns:12,act_connns:12,qps:1336,avg_response_ms:7.46,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:27,conns:12,act_connns:12,qps:1199,avg_response_ms:8.33,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:28,conns:12,act_connns:12,qps:602,avg_response_ms:16.57,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:29,conns:12,act_connns:12,qps:403,avg_response_ms:24.82,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:30,conns:12,act_connns:12,qps:527,avg_response_ms:18.99,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:31,conns:12,act_connns:12,qps:539,avg_response_ms:18.50,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:32,conns:12,act_connns:12,qps:420,avg_response_ms:23.75,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:33,conns:12,act_connns:12,qps:447,avg_response_ms:22.60,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:34,conns:12,act_connns:12,qps:456,avg_response_ms:21.80,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:35,conns:12,act_connns:12,qps:264,avg_response_ms:38.02,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:36,conns:12,act_connns:12,qps:515,avg_response_ms:19.49,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:37,conns:12,act_connns:12,qps:538,avg_response_ms:18.54,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:38,conns:12,act_connns:12,qps:259,avg_response_ms:38.49,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:39,conns:12,act_connns:12,qps:605,avg_response_ms:16.63,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:40,conns:12,act_connns:12,qps:917,avg_response_ms:10.90,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:41,conns:12,act_connns:12,qps:989,avg_response_ms:10.16,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:42,conns:12,act_connns:12,qps:1399,avg_response_ms:7.16,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:43,conns:12,act_connns:12,qps:1326,avg_response_ms:7.52,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:44,conns:12,act_connns:12,qps:1416,avg_response_ms:7.07,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:45,conns:12,act_connns:12,qps:1014,avg_response_ms:9.78,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:46,conns:12,act_connns:12,qps:434,avg_response_ms:22.92,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:47,conns:12,act_connns:12,qps:229,avg_response_ms:44.12,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:48,conns:12,act_connns:12,qps:238,avg_response_ms:41.65,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:49,conns:12,act_connns:12,qps:394,avg_response_ms:25.59,expensive_qps:0,expensive_avg_response_ms:0.00
time:2023-01-21-22:46:50,conns:12,act_connns:12,qps:489,avg_response_ms:20.33,expensive_qps:0,expensive_avg_response_ms:0.00
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.