MySql数据库优化笔记(一)

来源：互联网发布：淘宝货源编辑：程序博客网时间：2024/06/10 07:26

关键词：MySQL 数据库优化访问慢 Discuz! Apache ab web压力测试

新配置了一个discuz论坛，数据库也是新安装，对my.ini没有进行过任何设置。

用ab测试。

ab -c 100 -n 1000 http://localhost/forum.php

测试结果如下：

Document Path: /forum.phpDocument Length: 2118 bytes

Concurrency Level: 100Time taken for tests: 238.752 secondsComplete requests: 1000Failed requests: 96 (Connect: 0, Receive: 0, Length: 96, Exceptions: 0)Write errors: 0Total transferred: 2188195 bytesHTML transferred: 1985211 bytesRequests 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 maxConnect: 0 2 4.8 0 31Processing: 31 12721 42814.3 62 218394Waiting: 31 12721 42814.4 62 218394Total: 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.phpDocument Length:        23624 bytesConcurrency Level:      100Time taken for tests:   35.353 secondsComplete requests:      1000Failed requests:        0Write errors:           0Total transferred:      24247000 bytesHTML transferred:       23624000 bytesRequests 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] receivedConnection Times (ms)              min  mean[+/-sd] median   maxConnect:        0    2   5.0      0      31Processing:   296 3477 650.6   3479    5647Waiting:      296 3470 649.9   3479    5632Total:        296 3479 650.7   3479    5647Percentage 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)

可以发现速度明显上升。

未完待续。