MySql数据库优化笔记(一)

最新推荐文章于 2021-07-19 11:09:34 发布

TendaRouter

最新推荐文章于 2021-07-19 11:09:34 发布

阅读量717

点赞数

CC 4.0 BY-SA版权

分类专栏：其他种种文章标签：数据库优化 mysql processing 测试 path

本文链接：https://blog.youkuaiyun.com/tendarouter/article/details/6836796

其他种种专栏收录该内容

2 篇文章

订阅专栏

针对新配置的Discuz论坛，通过调整my.ini设置，优化了数据库访问效率，显著提升了ab测试下的请求处理速度。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

关键词：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)

可以发现速度明显上升。

未完待续。