調整nginx與msyql效能

(一)調整nginx效能

Step1)找出CPU核心數，筆者核心數為4

# grep ^processor /proc/cpuinfo | wc -l

修改/etc/nginx/nginx.conf

worker_processes 4;

worker_cpu_affinity 0001 0010 0100 1000;

Step2)設定最大開啟檔案數為65536

worker_rlimit_nofile 65535;

Step3)因為筆者使用Linux所以設定為epoll，連線數為65535。

events {

use epoll;

worker_connections 65535;

multi_accept on;

}

Step4)設定最大檔案開啟數為65535，編輯/etc/security/limits.conf，需要重新登入才會啟用

* soft nofile 65535

* hard nofile 65535

查詢目前大檔案開啟數

#ulimit -n

使用指令修改

#ulimit -n 65536

Step5)測試nginx設定檔是否正確

#nginx -t

Step6)重新啟動nginx

#service nginx restart

(二)使用指令ab進行網站壓力測試

Step1)使用指令ab進行效能測試，結果如下。

ab -n 200000 -c 5000 http://localhost/

This is ApacheBench, Version 2.3 <$Revision: 1843412 $>

Licensed to The Apache Software Foundation, http://www.apache.org/

Benchmarking localhost (be patient)

Completed 20000 requests

Completed 40000 requests

Completed 60000 requests

Completed 80000 requests

Completed 100000 requests

Completed 120000 requests

Completed 140000 requests

Completed 160000 requests

Completed 180000 requests

Completed 200000 requests

Finished 200000 requests

Server Software: nginx/1.18.0

Server Hostname: localhost

Server Port: 80

Document Path: /

Document Length: 26 bytes

Concurrency Level: 5000

Time taken for tests: 9.160 seconds

Complete requests: 200000

Failed requests: 199114

(Connect: 0, Receive: 0, Length: 199114, Exceptions: 0)

Non-2xx responses: 200000

Total transferred: 68257354 bytes

HTML transferred: 33075960 bytes

Requests per second: 21834.29 [#/sec] (mean)

Time per request: 228.998 [ms] (mean)

Time per request: 0.046 [ms] (mean, across all concurrent requests)

Transfer rate: 7277.10 [Kbytes/sec] received

Connection Times (ms)

min mean[+/-sd] median max

Connect: 0 106 276.8 42 3065

Processing: 5 91 92.3 72 1477

Waiting: 2 76 91.3 55 1466

Total: 12 197 291.7 120 4257

Percentage of the requests served within a certain time (ms)

50% 120

66% 136

75% 147

80% 156

90% 319

95% 1109

98% 1157

99% 1174

100% 4257 (longest request)

(三)設定mysql連線數由151增加到1000

Step1)編輯設定檔/etc/mysql/mysql.conf.d/mysqld.cnf

max_connections=1000

Step2)重新啟動mysql服務

#service mysql restart

Step3)確定連線數

#mysql -u root -p

mysql>show variables like '%max_connections%';