使用 MySQL 线程池对压力测试的影响，下面使用两个文件，分别测试一下。

代码：

test1.js 使用了 MySQL 线程池：

export async function test1(ctx) {
 let pool = dbUtil.getPool();
 let connection = await pool.getConnection();
 let [rows] = await connection.query('select * from tb_user limit 10');
 connection.release();
}

test2.js 未使用 MySQL 线程池：

export async function test2(ctx) {
 var rows = await dbUtil.query('select * from tb_user limit 10');
 ctx.body = rows;
}

压测命令：

ab -c 200 -n 9999 http://127.0.0.1:8001/test1

执行结果：

test1.js 的结果：

Server Software:     
Server Hostname:    127.0.0.1
Server Port:      8001

Document Path:     /test1
Document Length:    3140 bytes

Concurrency Level:   200
Time taken for tests:  37.411 seconds
Complete requests:   9999
Failed requests:    0
Total transferred:   32836716 bytes
HTML transferred:    31396860 bytes
Requests per second:  267.28 [#/sec] (mean)
Time per request:    748.287 [ms] (mean)
Time per request:    3.741 [ms] (mean, across all concurrent requests)
Transfer rate:     857.17 [Kbytes/sec] received

Connection Times (ms)
       min mean[+/-sd] median  max
Connect:    0  1  7.2   0   123
Processing:  19 743 93.1  744  1011
Waiting:    4 686 90.3  685   953
Total:     19 744 93.7  745  1084

Percentage of the requests served within a certain time (ms)
 50%  745
 66%  778
 75%  800
 80%  816
 90%  861
 95%  908
 98%  947
 99%  977
 100%  1084 (longest request)

test2.js 的结果：

Server Software:     
Server Hostname:    127.0.0.1
Server Port:      8001

Document Path:     /test2
Document Length:    3140 bytes

Concurrency Level:   200
Time taken for tests:  11.595 seconds
Complete requests:   9999
Failed requests:    0
Total transferred:   32836716 bytes
HTML transferred:    31396860 bytes
Requests per second:  862.39 [#/sec] (mean)
Time per request:    231.914 [ms] (mean)
Time per request:    1.160 [ms] (mean, across all concurrent requests)
Transfer rate:     2765.71 [Kbytes/sec] received

Connection Times (ms)
       min mean[+/-sd] median  max
Connect:    0  0  1.0   0   24
Processing:  14 228 69.6  202   461
Waiting:    3 227 69.4  201   461
Total:     14 229 69.6  202   461

Percentage of the requests served within a certain time (ms)
 50%  202
 66%  217
 75%  240
 80%  258
 90%  354
 95%  393
 98%  440
 99%  454
 100%  461 (longest request)

修改时间 2024-03-05