system centos7.4, 2 core 4G 2m Wordpress, built by Aliyun usually 2000PV 1000IP every day, recently the website access is super slow, please see what"s wrong with me, thank you!
< H2 > / usr/local/php/var/log/php-fpm.log < / H2 >[24-Sep-2018 01:27:26] WARNING: [pool www] child 7418 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:28:03] WARNING: [pool www] child 7684 exited on signal 9 (SIGKILL) after 9374.848977 seconds from start
[24-Sep-2018 01:28:03] WARNING: [pool www] child 9196 said into stderr: ""
[24-Sep-2018 01:28:03] WARNING: [pool www] child 9196 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:28:06] WARNING: [pool www] child 7688 exited on signal 9 (SIGKILL) after 9320.454959 seconds from start
[24-Sep-2018 01:29:02] WARNING: [pool www] child 7426 exited on signal 9 (SIGKILL) after 11629.155767 seconds from start
[24-Sep-2018 01:31:34] WARNING: [pool www] child 8076 exited on signal 9 (SIGKILL) after 8590.593105 seconds from start
[24-Sep-2018 01:31:34] WARNING: [pool www] child 7412 said into stderr: ""
[24-Sep-2018 01:31:34] WARNING: [pool www] child 7412 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:31:34] WARNING: [pool www] child 8077 said into stderr: ""
[24-Sep-2018 01:31:34] WARNING: [pool www] child 8077 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:31:53] WARNING: [pool www] child 7411 exited on signal 9 (SIGKILL) after 11801.851618 seconds from start
[24-Sep-2018 01:31:53] WARNING: [pool www] child 9165 said into stderr: ""
[24-Sep-2018 01:31:53] WARNING: [pool www] child 9165 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:31:57] WARNING: [pool www] child 9279 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/azenv.php (No such file or directory)"
[24-Sep-2018 01:32:37] WARNING: [pool www] child 7682 said into stderr: ""
[24-Sep-2018 01:32:37] WARNING: [pool www] child 7682 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:32:37] WARNING: [pool www] child 7415 said into stderr: ""
[24-Sep-2018 01:32:37] WARNING: [pool www] child 7415 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:32:37] WARNING: [pool www] child 9196 exited on signal 9 (SIGKILL) after 329.772613 seconds from start
[24-Sep-2018 01:33:04] WARNING: [pool www] child 7681 exited on signal 9 (SIGKILL) after 9677.042849 seconds from start
[24-Sep-2018 01:34:25] WARNING: [pool www] child 9279 exited on signal 9 (SIGKILL) after 378.986079 seconds from start
[24-Sep-2018 01:34:25] WARNING: [pool www] child 9365 said into stderr: ""
[24-Sep-2018 01:34:25] WARNING: [pool www] child 9365 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:34:28] WARNING: [pool www] child 8077 exited on signal 9 (SIGKILL) after 8764.079016 seconds from start
[24-Sep-2018 01:34:45] WARNING: [pool www] child 9278 exited on signal 9 (SIGKILL) after 401.991401 seconds from start
[24-Sep-2018 01:34:45] WARNING: [pool www] child 7686 said into stderr: ""
[24-Sep-2018 01:34:45] WARNING: [pool www] child 7686 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:38:52] WARNING: [pool www] child 9373 exited on signal 9 (SIGKILL) after 246.995347 seconds from start
[24-Sep-2018 01:38:59] WARNING: [pool www] child 7679 exited on signal 9 (SIGKILL) after 10032.606558 seconds from start
[24-Sep-2018 01:38:59] WARNING: [pool www] child 7417 said into stderr: ""
[24-Sep-2018 01:38:59] WARNING: [pool www] child 7417 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:39:33] WARNING: [pool www] child 9165 exited on signal 9 (SIGKILL) after 954.227649 seconds from start
[24-Sep-2018 01:46:29] WARNING: [pool www] child 9447 exited on signal 9 (SIGKILL) after 457.116479 seconds from start
[24-Sep-2018 01:46:29] WARNING: [pool www] child 9450 said into stderr: ""
[24-Sep-2018 01:46:29] WARNING: [pool www] child 9450 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:07] WARNING: [pool www] child 7412 said into stderr: ""
[24-Sep-2018 01:55:07] WARNING: [pool www] child 7412 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:30] WARNING: [pool www] child 9365 said into stderr: ""
[24-Sep-2018 01:55:30] WARNING: [pool www] child 9365 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:30] WARNING: [pool www] child 9365 said into stderr: ""
[24-Sep-2018 01:55:30] WARNING: [pool www] child 9365 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:30] WARNING: [pool www] child 7682 said into stderr: ""
[24-Sep-2018 01:55:30] WARNING: [pool www] child 7682 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:30] WARNING: [pool www] child 7682 said into stderr: ""
[24-Sep-2018 01:55:30] WARNING: [pool www] child 7682 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:30] WARNING: [pool www] child 7423 exited on signal 9 (SIGKILL) after 13217.445640 seconds from start
[24-Sep-2018 01:55:30] WARNING: [pool www] child 9282 said into stderr: ""
[24-Sep-2018 01:55:30] WARNING: [pool www] child 9282 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:30] WARNING: [pool www] child 7416 said into stderr: ""
[24-Sep-2018 01:55:30] WARNING: [pool www] child 7416 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:48] WARNING: [pool www] child 7412 exited on signal 9 (SIGKILL) after 13237.117228 seconds from start
[24-Sep-2018 01:58:15] WARNING: [pool www] child 9370 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/azenv.php (No such file or directory)"
[24-Sep-2018 02:20:01] WARNING: [pool www] child 9282 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/plus/90sec.php (No such file or directory)"
[24-Sep-2018 02:20:04] WARNING: [pool www] child 9746 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/data/cache/asd.php (No such file or directory)"
[24-Sep-2018 02:20:08] WARNING: [pool www] child 7682 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/plus/result.php (No such file or directory)"
[24-Sep-2018 02:20:12] WARNING: [pool www] child 9365 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/plus/read.php (No such file or directory)"
[24-Sep-2018 02:20:15] WARNING: [pool www] child 7416 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/data/cache/flye.php (No such file or directory)"
[24-Sep-2018 02:20:19] WARNING: [pool www] child 9540 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/fuck.php (No such file or directory)"
[24-Sep-2018 02:20:30] WARNING: [pool www] child 9367 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/test.php (No such file or directory)"
[24-Sep-2018 02:20:49] WARNING: [pool www] child 9450 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/plus/moon.php (No such file or directory)"
[24-Sep-2018 02:20:52] WARNING: [pool www] child 9490 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/data/cache/coco.php (No such file or directory)"
[24-Sep-2018 02:38:12] WARNING: [pool www] child 10143 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/azenv.php (No such file or directory)"
[24-Sep-2018 03:00:52] WARNING: [pool www] child 10733 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/user.php (No such file or directory)"
[24-Sep-2018 03:01:17] WARNING: [pool www] child 10740 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/myships.php (No such file or directory)"
[24-Sep-2018 03:13:06] WARNING: [pool www] child 10735 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/e/install/index.php (No such file or directory)"
[24-Sep-2018 03:19:29] WARNING: [pool www] child 10735 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/data/cache/asd.php (No such file or directory)"
[24-Sep-2018 03:19:33] WARNING: [pool www] child 10739 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/plus/result.php (No such file or directory)"
[24-Sep-2018 03:19:36] WARNING: [pool www] child 10748 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/plus/read.php (No such file or directory)"
[24-Sep-2018 03:19:41] WARNING: [pool www] child 10744 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/data/cache/flye.php (No such file or directory)"
[24-Sep-2018 03:19:45] WARNING: [pool www] child 10746 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/fuck.php (No such file or directory)"
[24-Sep-2018 03:33:09] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 8 children, there are 0 idle, and 31 total children
[24-Sep-2018 03:33:10] WARNING: [pool www] seems busy (you may need to increase pm.start_servers, or pm.min/max_spare_servers), spawning 16 children, there are 0 idle, and 39 total children
[24-Sep-2018 03:33:11] WARNING: [pool www] server reached pm.max_children setting (40), consider raising it
< hr >
< H2 > php-fpm.conf configuration, memory_limit = 1024m in php.ini < / H2 >
[global]
pid = run/php-fpm.pid
error_log = log/php-fpm.log
log_level = warning
emergency_restart_threshold = 30
emergency_restart_interval = 60s
process_control_timeout = 5s
daemonize = yes
;;;;;;;;;;;;;;;;;;;;
; Pool Definitions ;
;;;;;;;;;;;;;;;;;;;;
[www]
listen = /dev/shm/php-cgi.sock
;listen.backlog = -1
listen.allowed_clients = 127.0.0.1
listen.owner = www
listen.group = www
listen.mode = 0666
user = www
group = www
pm = dynamic
pm.max_children = 40
pm.start_servers = 20
pm.min_spare_servers = 10
pm.max_spare_servers = 30
pm.max_requests = 900
pm.process_idle_timeout = 10s
request_terminate_timeout = 600
request_slowlog_timeout = 0
pm.status_path = /php-fpm_status
;slowlog = log/slow.log;-sharp,request_slowlog_timeout
rlimit_files = 51200
rlimit_core = 0
catch_workers_output = yes
;env[HOSTNAME] = iZuf67015k8i8q0njeahs4Z
env[PATH] = /usr/local/bin:/usr/bin:/bin
env[TMP] = /tmp
env[TMPDIR] = /tmp
env[TEMP] = /tmp
< hr >
< H2 > php-fpm.log log < / H2 >
[24-Sep-2018 01:32:37] WARNING: [pool www] child 7682 said into stderr: ""
[24-Sep-2018 01:32:37] WARNING: [pool www] child 7682 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:32:37] WARNING: [pool www] child 7415 said into stderr: ""
[24-Sep-2018 01:32:37] WARNING: [pool www] child 7415 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:32:37] WARNING: [pool www] child 9196 exited on signal 9 (SIGKILL) after 329.772613 seconds from start
[24-Sep-2018 01:33:04] WARNING: [pool www] child 7681 exited on signal 9 (SIGKILL) after 9677.042849 seconds from start
[24-Sep-2018 01:34:25] WARNING: [pool www] child 9279 exited on signal 9 (SIGKILL) after 378.986079 seconds from start
[24-Sep-2018 01:34:25] WARNING: [pool www] child 9365 said into stderr: ""
[24-Sep-2018 01:34:25] WARNING: [pool www] child 9365 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:34:28] WARNING: [pool www] child 8077 exited on signal 9 (SIGKILL) after 8764.079016 seconds from start
[24-Sep-2018 01:34:45] WARNING: [pool www] child 9278 exited on signal 9 (SIGKILL) after 401.991401 seconds from start
[24-Sep-2018 01:34:45] WARNING: [pool www] child 7686 said into stderr: ""
[24-Sep-2018 01:34:45] WARNING: [pool www] child 7686 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:38:52] WARNING: [pool www] child 9373 exited on signal 9 (SIGKILL) after 246.995347 seconds from start
[24-Sep-2018 01:38:59] WARNING: [pool www] child 7679 exited on signal 9 (SIGKILL) after 10032.606558 seconds from start
[24-Sep-2018 01:38:59] WARNING: [pool www] child 7417 said into stderr: ""
[24-Sep-2018 01:38:59] WARNING: [pool www] child 7417 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:39:33] WARNING: [pool www] child 9165 exited on signal 9 (SIGKILL) after 954.227649 seconds from start
[24-Sep-2018 01:46:29] WARNING: [pool www] child 9447 exited on signal 9 (SIGKILL) after 457.116479 seconds from start
[24-Sep-2018 01:46:29] WARNING: [pool www] child 9450 said into stderr: ""
[24-Sep-2018 01:46:29] WARNING: [pool www] child 9450 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:07] WARNING: [pool www] child 7412 said into stderr: ""
[24-Sep-2018 01:55:07] WARNING: [pool www] child 7412 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:30] WARNING: [pool www] child 9365 said into stderr: ""
[24-Sep-2018 01:55:30] WARNING: [pool www] child 9365 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:30] WARNING: [pool www] child 9365 said into stderr: ""
[24-Sep-2018 01:55:30] WARNING: [pool www] child 9365 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:30] WARNING: [pool www] child 7682 said into stderr: ""
[24-Sep-2018 01:55:30] WARNING: [pool www] child 7682 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:30] WARNING: [pool www] child 7682 said into stderr: ""
[24-Sep-2018 01:55:30] WARNING: [pool www] child 7682 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:30] WARNING: [pool www] child 7423 exited on signal 9 (SIGKILL) after 13217.445640 seconds from start
[24-Sep-2018 01:55:30] WARNING: [pool www] child 9282 said into stderr: ""
[24-Sep-2018 01:55:30] WARNING: [pool www] child 9282 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:30] WARNING: [pool www] child 7416 said into stderr: ""
[24-Sep-2018 01:55:30] WARNING: [pool www] child 7416 said into stderr: "mmap() failed: [12] Cannot allocate memory"
[24-Sep-2018 01:55:48] WARNING: [pool www] child 7412 exited on signal 9 (SIGKILL) after 13237.117228 seconds from start
[24-Sep-2018 01:58:15] WARNING: [pool www] child 9370 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/azenv.php (No such file or directory)"
[24-Sep-2018 02:20:01] WARNING: [pool www] child 9282 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/plus/90sec.php (No such file or directory)"
[24-Sep-2018 02:20:04] WARNING: [pool www] child 9746 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/data/cache/asd.php (No such file or directory)"
[24-Sep-2018 02:20:08] WARNING: [pool www] child 7682 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/plus/result.php (No such file or directory)"
[24-Sep-2018 02:20:12] WARNING: [pool www] child 9365 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/plus/read.php (No such file or directory)"
[24-Sep-2018 02:20:15] WARNING: [pool www] child 7416 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/data/cache/flye.php (No such file or directory)"
[24-Sep-2018 02:20:19] WARNING: [pool www] child 9540 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/fuck.php (No such file or directory)"
[24-Sep-2018 02:20:30] WARNING: [pool www] child 9367 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/test.php (No such file or directory)"
[24-Sep-2018 02:20:49] WARNING: [pool www] child 9450 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/plus/moon.php (No such file or directory)"
[24-Sep-2018 02:20:52] WARNING: [pool www] child 9490 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/data/cache/coco.php (No such file or directory)"
[24-Sep-2018 02:38:12] WARNING: [pool www] child 10143 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/azenv.php (No such file or directory)"
[24-Sep-2018 03:00:52] WARNING: [pool www] child 10733 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/user.php (No such file or directory)"
[24-Sep-2018 03:01:17] WARNING: [pool www] child 10740 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/myships.php (No such file or directory)"
[24-Sep-2018 03:13:06] WARNING: [pool www] child 10735 said into stderr: "ERROR: Unable to open primary script: /data/wwwroot/www.yuming.com/e/install/index.php (No such file or directory)"
< hr >
< H2 > nginx.conf configuration < / H2 >
user www www;
worker_processes auto;
error_log /data/wwwlogs/error_nginx.log crit;
pid /var/run/nginx.pid;
worker_rlimit_nofile 51200;
events {
use epoll;
worker_connections 51200;
multi_accept on;
}
http {
include mime.types;
default_type application/octet-stream;
server_names_hash_bucket_size 128;
client_header_buffer_size 32k;
large_client_header_buffers 4 32k;
client_max_body_size 1024m;
client_body_buffer_size 10m;
sendfile on;
tcp_nopush on;
keepalive_timeout 120;
server_tokens off;
tcp_nodelay on;
fastcgi_connect_timeout 300;
fastcgi_send_timeout 300;
fastcgi_read_timeout 300;
fastcgi_buffer_size 64k;
fastcgi_buffers 4 64k;
fastcgi_busy_buffers_size 128k;
fastcgi_temp_file_write_size 128k;
fastcgi_intercept_errors on;
-sharpGzip Compression
gzip on;
gzip_buffers 16 8k;
gzip_comp_level 6;
gzip_http_version 1.1;
gzip_min_length 256;
gzip_proxied any;
gzip_vary on;
gzip_types
text/xml application/xml application/atom+xml application/rss+xml application/xhtml+xml image/svg+xml
text/javascript application/javascript application/x-javascript
text/x-json application/json application/x-web-app-manifest+json
text/css text/plain text/x-component
font/opentype application/x-font-ttf application/vnd.ms-fontobject
image/x-icon;
gzip_disable "MSIE [1-6]\.(?!.*SV1)";
-sharpIf you have a lot of static files to serve through Nginx then caching of the files" metadata (not the actual files" contents) can save some latency.
open_file_cache max=1000 inactive=20s;
open_file_cache_valid 30s;
open_file_cache_min_uses 2;
open_file_cache_errors on;
-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp default -sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp
server {
listen 80;
server_name www.yuming.com yuming.com;
access_log /data/wwwlogs/access_nginx.log combined;
root /data/wwwroot/www.yuming.com;
index index.html index.htm index.php;
-sharperror_page 404 /404.html;
-sharperror_page 502 /502.html;
location /nginx_status {
stub_status on;
access_log off;
allow 127.0.0.1;
deny all;
}
location ~ [^/]\.php(/|$) {
-sharpfastcgi_pass remote_php_ip:9000;
fastcgi_pass unix:/dev/shm/php-cgi.sock;
fastcgi_index index.php;
include fastcgi.conf;
}
location ~ .*\.(gif|jpg|jpeg|png|bmp|swf|flv|mp4|ico)$ {
expires 30d;
access_log off;
}
location ~ .*\.(js|css)?$ {
expires 7d;
access_log off;
}
location ~ /\.ht {
deny all;
}
}
-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp vhost -sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp
include vhost/*.conf;
include waf.conf;
}
< hr >
< H2 > nginx. Vhost configuration < / H2 >
server {
listen 443;
ssl on;
server_name www.yuming.com yuming.com;
access_log /data/wwwlogs/www.yuming.com_nginx.log combined;
index index.html index.htm index.php;
root /data/wwwroot/www.yuming.com;
ssl_certificate cert/www.yuming.com.crt;
ssl_certificate_key cert/www.yuming.com.key;
ssl_session_timeout 5m;
ssl_ciphers ECDHE-RSA-AES128-GCM-SHA256:ECDHE:ECDH:AES:HIGH:!NULL:!aNULL:!MD5:!ADH:!RC4;
ssl_protocols TLSv1 TLSv1.1 TLSv1.2;
ssl_prefer_server_ciphers on;
include /usr/local/nginx/conf/rewrite/wordpress.conf;
-sharperror_page 404 /404.html;
-sharperror_page 502 /502.html;
location ~ [^/]\.php(/|$) {
-sharpfastcgi_pass remote_php_ip:9000;
fastcgi_pass unix:/dev/shm/php-cgi.sock;
fastcgi_index index.php;
include fastcgi.conf;
}
location ~ .*\.(gif|jpg|jpeg|png|bmp|swf|flv|mp4|ico)$ {
expires 30d;
access_log off;
}
location ~ .*\.(js|css)?$ {
expires 7d;
access_log off;
}
location ~ /\.ht {
deny all;
}
}
< hr >
< H2 > / usr/local/nginx/logs/error.log nginx error log < / H2 >
2018/09/23 14:44:56 [notice] 22412-sharp0: signal process started
2018/09/23 15:11:22 [notice] 4323-sharp0: using inherited sockets from "6;13;"
2018/09/23 15:11:25 [notice] 4360-sharp0: signal process started
2018/09/23 15:13:29 [notice] 4449-sharp0: signal process started
2018/09/24 02:27:12 [notice] 10095-sharp0: signal process started
2018/09/24 02:44:43 [notice] 10510-sharp0: signal process started
2018/09/24 02:49:28 [notice] 10606-sharp0: signal process started
2018/09/24 02:53:59 [notice] 10694-sharp0: signal process started
< hr >
< H2 > my.cnf configuration < / H2 >
[client]
port = 3306
socket = /tmp/mysql.sock
default-character-set = utf8mb4
[mysql]
prompt="MySQL [\d]> "
no-auto-rehash
-sharpevent_scheduler = ON
-sharpmysql
[mysqld]
port = 3306
socket = /tmp/mysql.sock
basedir = /usr/local/mysql
datadir = /data/mysql
pid-file = /data/mysql/mysql.pid
user = mysql
bind-address = 0.0.0.0
server-id = 1
init-connect = "SET NAMES utf8mb4"
character-set-server = utf8mb4
skip-name-resolve
-sharpskip-networking
back_log = 300
max_connections = 1263
max_connect_errors = 6000
open_files_limit = 65535
table_open_cache = 1024
max_allowed_packet = 500M
binlog_cache_size = 1M
max_heap_table_size = 8M
tmp_table_size = 128M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
sort_buffer_size = 8M
join_buffer_size = 8M
key_buffer_size = 256M
thread_cache_size = 64
query_cache_type = 1
query_cache_size = 64M
query_cache_limit = 2M
ft_min_word_len = 4
log_bin = mysql-bin
binlog_format = mixed
expire_logs_days = 7
log_error = /data/mysql/mysql-error.log
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /data/mysql/mysql-slow.log
performance_schema = 0
explicit_defaults_for_timestamp
-sharplower_case_table_names = 1
skip-external-locking
-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp
-sharp-sharp-sharp-sharp-sharp-sharp-sharp-sharp
default_storage_engine = InnoDB
innodb_file_per_table = 1
innodb_open_files = 500
innodb_buffer_pool_size = 64M
innodb_write_io_threads = 4
innodb_read_io_threads = 4
innodb_thread_concurrency = 0
innodb_purge_threads = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 2M
innodb_log_file_size = 32M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
bulk_insert_buffer_size = 8M
myisam_sort_buffer_size = 64M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
interactive_timeout = 28800
wait_timeout = 28800
[mysqldump]
quick
max_allowed_packet = 500M
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 8M
read_buffer = 4M
write_buffer = 4M
< hr >
< H2 > / data/mysql/mysql-error.log log < / H2 >
2018-09-24 01:50:23 9632 [Note] InnoDB: Memory barrier is not used
2018-09-24 01:50:23 9632 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-09-24 01:50:23 9632 [Note] InnoDB: Using Linux native AIO
2018-09-24 01:50:23 9632 [Note] InnoDB: Using CPU crc32 instructions
2018-09-24 01:50:23 9632 [Note] InnoDB: Initializing buffer pool, size = 64.0M
2018-09-24 01:50:23 9632 [Note] InnoDB: Completed initialization of buffer pool
2018-09-24 01:50:23 9632 [Note] InnoDB: Highest supported file format is Barracuda.
2018-09-24 01:50:23 9632 [Note] InnoDB: The log sequence numbers 5137705201 and 5137705201 in ibdata files do not match the log sequence number 7615408470 in the ib_logfiles!
2018-09-24 01:50:23 9632 [Note] InnoDB: Database was not shutdown normally!
2018-09-24 01:50:23 9632 [Note] InnoDB: Starting crash recovery.
2018-09-24 01:50:23 9632 [Note] InnoDB: Reading tablespace information from the .ibd files...
2018-09-24 01:50:23 9632 [Note] InnoDB: Restoring possible half-written data pages
2018-09-24 01:50:23 9632 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 3999053, file name mysql-bin.000055
2018-09-24 01:50:24 9632 [Note] InnoDB: 128 rollback segment(s) are active.
2018-09-24 01:50:24 9632 [Note] InnoDB: Waiting for purge to start
2018-09-24 01:50:24 9632 [Note] InnoDB: 5.6.41 started; log sequence number 7615408470
2018-09-24 01:50:24 9632 [Note] Recovering after a crash using mysql-bin
2018-09-24 01:50:24 9632 [Note] Starting crash recovery...
2018-09-24 01:50:24 9632 [Note] Crash recovery finished.
2018-09-24 01:50:24 9632 [Note] Server hostname (bind-address): "0.0.0.0"; port: 3306
2018-09-24 01:50:24 9632 [Note] - "0.0.0.0" resolves to "0.0.0.0";
2018-09-24 01:50:24 9632 [Note] Server socket created on IP: "0.0.0.0".
2018-09-24 01:50:24 9632 [Note] Event Scheduler: Loaded 0 events
2018-09-24 01:50:24 9632 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: "5.6.41-log" socket: "/tmp/mysql.sock" port: 3306 MySQL Community Server (GPL)
2018-09-24 01:55:07 9716 [Note] Plugin "FEDERATED" is disabled.
2018-09-24 01:55:07 9716 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-09-24 01:55:07 9716 [Note] InnoDB: The InnoDB memory heap is disabled
2018-09-24 01:55:07 9716 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-09-24 01:55:07 9716 [Note] InnoDB: Memory barrier is not used
2018-09-24 01:55:07 9716 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-09-24 01:55:07 9716 [Note] InnoDB: Using Linux native AIO
2018-09-24 01:55:07 9716 [Note] InnoDB: Using CPU crc32 instructions
2018-09-24 01:55:07 9716 [Note] InnoDB: Initializing buffer pool, size = 64.0M
2018-09-24 01:55:07 9716 [Note] InnoDB: Completed initialization of buffer pool
2018-09-24 01:55:07 9716 [Note] InnoDB: Highest supported file format is Barracuda.
2018-09-24 01:55:07 9716 [Note] InnoDB: Log scan progressed past the checkpoint lsn 7620461203
2018-09-24 01:55:07 9716 [Note] InnoDB: Database was not shutdown normally!
2018-09-24 01:55:07 9716 [Note] InnoDB: Starting crash recovery.
2018-09-24 01:55:07 9716 [Note] InnoDB: Reading tablespace information from the .ibd files...
2018-09-24 01:55:07 9716 [Note] InnoDB: Restoring possible half-written data pages
2018-09-24 01:55:07 9716 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 7620462678
2018-09-24 01:55:08 9716 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 4743450, file name mysql-bin.000056
2018-09-24 01:55:08 9716 [Note] InnoDB: 128 rollback segment(s) are active.
2018-09-24 01:55:08 9716 [Note] InnoDB: Waiting for purge to start
2018-09-24 01:55:08 9716 [Note] InnoDB: 5.6.41 started; log sequence number 7620462678
2018-09-24 01:55:08 9716 [Note] Recovering after a crash using mysql-bin
2018-09-24 01:55:08 9716 [Note] Starting crash recovery...
2018-09-24 01:55:08 9716 [Note] Crash recovery finished.
2018-09-24 01:55:08 9716 [Note] Server hostname (bind-address): "0.0.0.0"; port: 3306
2018-09-24 01:55:08 9716 [Note] - "0.0.0.0" resolves to "0.0.0.0";
2018-09-24 01:55:08 9716 [Note] Server socket created on IP: "0.0.0.0".
2018-09-24 01:55:09 9716 [Note] Event Scheduler: Loaded 0 events
2018-09-24 01:55:09 9716 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: "5.6.41-log" socket: "/tmp/mysql.sock" port: 3306 MySQL Community Server (GPL)
< hr >
I would like to ask God, how on earth should these things be configured?