## 0. no-pool (base) fuzhengwei1@ZBMac-GV47H1GXD ~ % ab -c 20 -n 600 http://127.0.0.1:8091/api/mysql/insert This is ApacheBench, Version 2.3 <$Revision: 1901567 $> Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ Licensed to The Apache Software Foundation, http://www.apache.org/ Benchmarking 127.0.0.1 (be patient) Completed 100 requests Completed 200 requests Completed 300 requests Completed 400 requests Completed 500 requests Completed 600 requests Finished 600 requests Server Software: Server Hostname: 127.0.0.1 Server Port: 8091 Document Path: /api/mysql/insert Document Length: 23 bytes Concurrency Level: 20 Time taken for tests: 9.267 seconds Complete requests: 600 Failed requests: 0 Total transferred: 93600 bytes HTML transferred: 13800 bytes Requests per second: 64.74 [#/sec] (mean) Time per request: 308.911 [ms] (mean) Time per request: 15.446 [ms] (mean, across all concurrent requests) Transfer rate: 9.86 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.3 0 2 Processing: 65 276 182.2 217 1022 Waiting: 65 269 177.1 212 1000 Total: 65 276 182.3 218 1023 Percentage of the requests served within a certain time (ms) 50% 218 66% 283 75% 353 80% 389 90% 534 95% 745 98% 808 99% 821 100% 1023 (longest request) ## 1. C3P0 ab -c 20 -n 600 http://127.0.0.1:8091/api/mysql/insert This is ApacheBench, Version 2.3 <$Revision: 1901567 $> Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ Licensed to The Apache Software Foundation, http://www.apache.org/ Benchmarking 127.0.0.1 (be patient) Completed 100 requests Completed 200 requests Completed 300 requests Completed 400 requests Completed 500 requests Completed 600 requests Finished 600 requests Server Software: Server Hostname: 127.0.0.1 Server Port: 8091 Document Path: /api/mysql/insert Document Length: 23 bytes Concurrency Level: 20 Time taken for tests: 3.729 seconds Complete requests: 600 Failed requests: 0 Total transferred: 93600 bytes HTML transferred: 13800 bytes Requests per second: 160.88 [#/sec] (mean) Time per request: 124.314 [ms] (mean) Time per request: 6.216 [ms] (mean, across all concurrent requests) Transfer rate: 24.51 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.3 0 2 Processing: 15 99 82.8 74 787 Waiting: 13 93 80.3 70 763 Total: 15 100 82.9 74 787 Percentage of the requests served within a certain time (ms) 50% 74 66% 112 75% 135 80% 147 90% 219 95% 256 98% 361 99% 378 100% 787 (longest request) ## 2. DBCP (base) fuzhengwei1@ZBMac-GV47H1GXD ~ % ab -c 20 -n 600 http://127.0.0.1:8091/api/mysql/insert This is ApacheBench, Version 2.3 <$Revision: 1901567 $> Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ Licensed to The Apache Software Foundation, http://www.apache.org/ Benchmarking 127.0.0.1 (be patient) Completed 100 requests Completed 200 requests Completed 300 requests Completed 400 requests Completed 500 requests Completed 600 requests Finished 600 requests Server Software: Server Hostname: 127.0.0.1 Server Port: 8091 Document Path: /api/mysql/insert Document Length: 23 bytes Concurrency Level: 20 Time taken for tests: 4.174 seconds Complete requests: 600 Failed requests: 0 Total transferred: 93600 bytes HTML transferred: 13800 bytes Requests per second: 143.74 [#/sec] (mean) Time per request: 139.140 [ms] (mean) Time per request: 6.957 [ms] (mean, across all concurrent requests) Transfer rate: 21.90 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.3 0 3 Processing: 15 107 92.8 83 997 Waiting: 15 101 89.3 77 987 Total: 15 107 93.0 83 997 Percentage of the requests served within a certain time (ms) 50% 83 66% 103 75% 121 80% 131 90% 204 95% 253 98% 474 99% 482 100% 997 (longest request) ## druid fuzhengwei1@ZBMac-GV47H1GXD ~ % ab -c 20 -n 600 http://127.0.0.1:8091/api/mysql/insert This is ApacheBench, Version 2.3 <$Revision: 1901567 $> Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ Licensed to The Apache Software Foundation, http://www.apache.org/ Benchmarking 127.0.0.1 (be patient) Completed 100 requests Completed 200 requests Completed 300 requests Completed 400 requests Completed 500 requests Completed 600 requests Finished 600 requests Server Software: Server Hostname: 127.0.0.1 Server Port: 8091 Document Path: /api/mysql/insert Document Length: 23 bytes Concurrency Level: 20 Time taken for tests: 4.885 seconds Complete requests: 600 Failed requests: 0 Total transferred: 93600 bytes HTML transferred: 13800 bytes Requests per second: 122.83 [#/sec] (mean) Time per request: 162.827 [ms] (mean) Time per request: 8.141 [ms] (mean, across all concurrent requests) Transfer rate: 18.71 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.3 0 2 Processing: 39 144 85.3 121 568 Waiting: 38 138 80.0 115 550 Total: 40 145 85.2 122 568 Percentage of the requests served within a certain time (ms) 50% 122 66% 168 75% 193 80% 205 90% 247 95% 353 98% 395 99% 427 100% 568 (longest request) ## hikari (base) fuzhengwei1@ZBMac-GV47H1GXD ~ % ab -c 20 -n 600 http://127.0.0.1:8091/api/mysql/insert This is ApacheBench, Version 2.3 <$Revision: 1901567 $> Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ Licensed to The Apache Software Foundation, http://www.apache.org/ Benchmarking 127.0.0.1 (be patient) Completed 100 requests Completed 200 requests Completed 300 requests Completed 400 requests Completed 500 requests Completed 600 requests Finished 600 requests Server Software: Server Hostname: 127.0.0.1 Server Port: 8091 Document Path: /api/mysql/insert Document Length: 23 bytes Concurrency Level: 20 Time taken for tests: 3.793 seconds Complete requests: 600 Failed requests: 0 Total transferred: 93600 bytes HTML transferred: 13800 bytes Requests per second: 158.20 [#/sec] (mean) Time per request: 126.420 [ms] (mean) Time per request: 6.321 [ms] (mean, across all concurrent requests) Transfer rate: 24.10 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.6 0 8 Processing: 13 98 64.2 86 915 Waiting: 12 93 62.6 80 883 Total: 14 98 64.1 86 916 Percentage of the requests served within a certain time (ms) 50% 86 66% 111 75% 136 80% 147 90% 180 95% 199 98% 217 99% 271 100% 916 (longest request) ## 测试；插入、无索引更新、有索引更新 ### 1. 插入 (base) fuzhengwei1@ZBMac-GV47H1GXD ~ % ab -c 20 -n 600 http://127.0.0.1:8091/api/mysql/insert This is ApacheBench, Version 2.3 <$Revision: 1901567 $> Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/ Licensed to The Apache Software Foundation, http://www.apache.org/ Benchmarking 127.0.0.1 (be patient) Completed 100 requests Completed 200 requests Completed 300 requests Completed 400 requests Completed 500 requests Completed 600 requests Finished 600 requests Server Software: Server Hostname: 127.0.0.1 Server Port: 8091 Document Path: /api/mysql/insert Document Length: 23 bytes Concurrency Level: 20 Time taken for tests: 4.009 seconds Complete requests: 600 Failed requests: 0 Total transferred: 93600 bytes HTML transferred: 13800 bytes Requests per second: 149.67 [#/sec] (mean) Time per request: 133.628 [ms] (mean) Time per request: 6.681 [ms] (mean, across all concurrent requests) Transfer rate: 22.80 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.4 0 4 Processing: 19 104 74.0 82 912 Waiting: 12 99 69.2 80 895 Total: 20 105 74.0 82 912 Percentage of the requests served within a certain time (ms) 50% 82 66% 116 75% 136 80% 159 90% 202 95% 243 98% 290 99% 291 100% 912 (longest request) (base) fuzhengwei1@ZBMac-GV47H1GXD ~ % ### 2. 无索引更新 ### 3. 有索引更新 Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.9 0 8 Processing: 23 164 96.0 139 664 Waiting: 23 161 94.4 137 664 Total: 23 164 96.5 139 669 Percentage of the requests served within a certain time (ms) 50% 139 66% 175 75% 196 80% 211 90% 308 95% 374 98% 448 99% 459 100% 669 (longest request) Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.7 0 6 Processing: 5 163 119.8 125 934 Waiting: 5 154 111.9 119 807 Total: 5 163 119.8 126 937 Percentage of the requests served within a certain time (ms) 50% 126 66% 162 75% 225 80% 248 90% 367 95% 428 98% 471 99% 502 100% 937 (longest request) 服务器软件： 服务器主机名：127.0.0.1 服务器端口：8091 文档路径：/api/mysql/selectByOrderId 文档长度：23字节 并发级别：100 测试所用时间：3.395秒 完成请求：2000 失败请求：0 总传输量：312000字节 HTML传输量：46000字节 每秒请求数：589.09 [#/sec]（平均值） 每个请求的时间：169.752 [ms]（平均值） 每个请求的时间：1.698 [ms]（平均值，所有并发请求） 传输速率：89.74 [Kbytes/sec]（接收） 连接时间（毫秒） 最小值 平均值[+/-标准差] 中位数 最大值 连接：0 0 0.9 0 8 处理：23 164 96.0 139 664 等待：23 161 94.4 137 664 总计：23 164 96.5 139 669 在特定时间内完成请求的百分比（毫秒） 50% 139 66% 175 75% 196 80% 211 90% 308 95% 374 98% 448 99% 459 100% 669（最长请求） 解释： - 服务器软件：指的是在服务器上运行的软件，用于提供服务和处理请求。 - 服务器主机名：指的是服务器的主机名或IP地址。 - 服务器端口：指的是服务器监听的端口号。 - 文档路径：指的是请求的文档路径。 - 文档长度：指的是请求的文档的长度，以字节为单位。 - 并发级别：指的是同时处理的请求数量。 - 完成请求：指的是成功完成的请求数量。 - 失败请求：指的是失败的请求数量。 - 总传输量：指的是总共传输的数据量，以字节为单位。 - HTML传输量：指的是传输的HTML数据量，以字节为单位。 - 每秒请求数：指的是每秒处理的请求数量，也称为QPS（Queries Per Second）。 - 每个请求的时间：指的是每个请求的平均处理时间，以毫秒为单位。 - 传输速率：指的是接收数据的速率，以千字节/秒为单位。 - 连接时间：指的是建立连接所花费的时间。 - 处理时间：指的是处理请求所花费的时间。 - 等待时间：指的是在处理请求期间等待的时间。 - 百分比的请求时间：指的是在特定时间内完成请求的百分比。例如，50%的请求在139毫秒内完成，99%的请求在459毫秒内完成。 ===连接数 25 个 Server Software: Server Hostname: 127.0.0.1 Server Port: 8091 Document Path: /api/mysql/selectByOrderId Document Length: 23 bytes Concurrency Level: 100 Time taken for tests: 2.889 seconds Complete requests: 2000 Failed requests: 0 Total transferred: 312000 bytes HTML transferred: 46000 bytes Requests per second: 692.24 [#/sec] (mean) Time per request: 144.458 [ms] (mean) Time per request: 1.445 [ms] (mean, across all concurrent requests) Transfer rate: 105.46 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.7 0 4 Processing: 4 138 89.9 111 495 Waiting: 3 130 88.1 99 495 Total: 4 139 90.1 111 498 Percentage of the requests served within a certain time (ms) 50% 111 66% 159 75% 206 80% 225 90% 274 95% 309 98% 342 99% 378 100% 498 (longest request) ===== 连接数 5 Server Hostname: 127.0.0.1 Server Port: 8091 Document Path: /api/mysql/selectByOrderId Document Length: 23 bytes Concurrency Level: 100 Time taken for tests: 3.086 seconds Complete requests: 2000 Failed requests: 0 Total transferred: 312000 bytes HTML transferred: 46000 bytes Requests per second: 648.10 [#/sec] (mean) Time per request: 154.296 [ms] (mean) Time per request: 1.543 [ms] (mean, across all concurrent requests) Transfer rate: 98.73 [Kbytes/sec] received Connection Times (ms) min mean[+/-sd] median max Connect: 0 0 0.9 0 10 Processing: 5 149 101.4 121 555 Waiting: 4 139 89.9 116 469 Total: 5 149 101.5 122 555 Percentage of the requests served within a certain time (ms) 50% 122 66% 168 75% 201 80% 220 90% 267 95% 398 98% 436 99% 454 100% 555 (longest request)