关键词:MySQL 数据库 优化 访问慢 Discuz! Apache ab web压力测试
新配置了一个discuz论坛,数据库也是新安装,对my.ini没有进行过任何设置。
用ab测试。
ab -c 100 -n 1000 http://localhost/forum.php
测试结果如下:
Document Path: /forum.php
Document Length: 2118 bytes
Concurrency Level: 100
Time taken for tests: 238.752 seconds
Complete requests: 1000
Failed requests: 96
(Connect: 0, Receive: 0, Length: 96, Exceptions: 0)
Write errors: 0
Total transferred: 2188195 bytes
HTML transferred: 1985211 bytes
Requests per second: 4.19 [#/sec] (mean)
Time per request: 23875.242 [ms] (mean)
Time per request: 238.752 [ms] (mean, across all concurrent requests)
Transfer rate: 8.95 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 2 4.8 0 31
Processing: 31 12721 42814.3 62 218394
Waiting: 31 12721 42814.4 62 218394
Total: 31 12723 42814.4 62 218394
Percentage of the requests served within a certain time (ms)
50% 62
66% 78
75% 78
80% 94
90% 15881
95% 128251
98% 195681
99% 218207
100% 218394 (longest request)
开始进行优化:
1、将my.ini中设置
skip-name-resolve
注:论坛访问量几乎可以忽略。
测试结果如下:
Document Path: /forum.php
Document Length: 23624 bytes
Concurrency Level: 100
Time taken for tests: 35.353 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Total transferred: 24247000 bytes
HTML transferred: 23624000 bytes
Requests per second: 28.29 [#/sec] (mean)
Time per request: 3535.251 [ms] (mean)
Time per request: 35.353 [ms] (mean, across all concurrent requests)
Transfer rate: 669.79 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 2 5.0 0 31
Processing: 296 3477 650.6 3479 5647
Waiting: 296 3470 649.9 3479 5632
Total: 296 3479 650.7 3479 5647
Percentage of the requests served within a certain time (ms)
50% 3479
66% 3592
75% 3666
80% 3713
90% 3914
95% 4867
98% 5132
99% 5429
100% 5647 (longest request)
可以发现 速度明显上升。
未完待续。