hu60.cn数据库配置已优化，表已从MyISAM存储引擎转为InnoDB存储引擎，期待性能可以提升 - 超级灌水

帖子的点击量是我用ab命令刷的。

[2020-07-08 22:30] hu60.cn数据库配置已优化，表已从MyISAM存储引擎转为InnoDB存储引擎，期待性能可以有所提升。

@000：@老虎会游泳，感觉对虎林来说换存储引擎应该变化不大 (联合)索引弄好点就差不多了

@老虎会游泳：@000，不一定。并发访问帖子的问题在于每次访问都要给帖子的访问量+1，MyISAM就会一直锁定表。InnoDB的并发写入性能应该会好很多，可以只锁定行，而不是整个表。这样，只有被CC的那个帖子打不开而已，不会影响我们查看其他帖子。

ab的压测结果明显改善了，以前ab -n10000 -c1000 https://hu60.cn/q.php/bbs.topic.94721.html10分钟根本完不成，而且只要我一执行，谁也打不开网站。现在我执行过程中其他帖子可以打开了，而且这个命令5秒就执行完了。

其中Failed requests: 9385都是防CC模块的功劳，刷新不规范，虎友两行泪

# ab -n10000 -c1000 https://hu60.cn/q.php/bbs.topic.94721.html
This is ApacheBench, Version 2.3 <$Revision: 1874286 $>
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking hu60.cn (be patient)
Completed 1000 requests
Completed 2000 requests
Completed 3000 requests
Completed 4000 requests
Completed 5000 requests
Completed 6000 requests
Completed 7000 requests
Completed 8000 requests
Completed 9000 requests
Completed 10000 requests
Finished 10000 requests

Server Software:        Tengine
Server Hostname:        hu60.cn
Server Port:            443
SSL/TLS Protocol:       TLSv1.2,ECDHE-RSA-AES128-GCM-SHA256,2048,128
Server Temp Key:        X25519 253 bits
TLS Server Name:        hu60.cn

Document Path:          /q.php/bbs.topic.94721.html
Document Length:        33825 bytes

Concurrency Level:      1000
Time taken for tests:   19.664 seconds
Complete requests:      10000
Failed requests:        9385
   (Connect: 0, Receive: 0, Length: 9385, Exceptions: 0)
Non-2xx responses:      9385
Total transferred:      28680915 bytes
HTML transferred:       26639845 bytes
Requests per second:    508.54 [#/sec] (mean)
Time per request:       1966.411 [ms] (mean)
Time per request:       1.966 [ms] (mean, across all concurrent requests)
Transfer rate:          1424.36 [Kbytes/sec] received

Connection Times (ms)
              min  mean[+/-sd] median   max
Connect:        1  150 401.0      4    1423
Processing:    41 1779 885.5   1456    5275
Waiting:       20 1779 885.5   1456    5275
Total:        119 1929 862.7   1519    5280

Percentage of the requests served within a certain time (ms)
  50%   1519
  66%   1646
  75%   2431
  80%   2855
  90%   3523
  95%   3608
  98%   3686
  99%   3716
 100%   5280 (longest request)

[2020-07-08 21:45] 正在折腾hu60.cn的数据库，hu60.cn正在反向代理到hu60.net，打开速度会明显变慢

[2020-07-08 21:30] 数据库裂开预警：我在编译新版本的mysql，很快就要替换了。届时hu60.cn和m.hu60.cn又可能会发生各种状况，请做好心理准备

[2020-07-08 15:00] hu60.cn和m.hu60.cn挂了百度云加速，现在应该可以访问了。

[2020-07-07] 今天惊讶的发现apache2的a2modphp只能开256个工作进程，太少了，大并发数时卡的不要不要的。
准备换成nginx+php-fpm试试。