我的小站访问超级慢,请问这是被黑了吗?

nvhaizi
  • 43

系统centos7.4, 2核4G 2M阿里云建的Wordpress,平时每天2000PV 1000IP,最近网站访问超级慢,请大神们看看我这是怎么了,谢谢!

/usr/local/php/var/log/php-fpm.log

[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

php-fpm.conf配置,php.ini 里面memory_limit = 1024M

[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;#慢请求的记录日志,配合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

php-fpm.log日志

[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)"

nginx.conf配置

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;

  #Gzip 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)";

  #If 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;

######################## default ############################
  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;
    #error_page 404 /404.html;
    #error_page 502 /502.html;
    location /nginx_status {
      stub_status on;
      access_log off;
      allow 127.0.0.1;
      deny all;
    }
    location ~ [^/]\.php(/|$) {
      #fastcgi_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;
    }
  }
########################## vhost #############################
  include vhost/*.conf;
  include waf.conf;
}

nginx. vhost配置

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;
  #error_page 404 /404.html;
  #error_page 502 /502.html;
  
  location ~ [^/]\.php(/|$) {
    #fastcgi_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;
  }
}

/usr/local/nginx/logs/error.log nginx错误日志

2018/09/23 14:44:56 [notice] 22412#0: signal process started
2018/09/23 15:11:22 [notice] 4323#0: using inherited sockets from "6;13;"
2018/09/23 15:11:25 [notice] 4360#0: signal process started
2018/09/23 15:13:29 [notice] 4449#0: signal process started
2018/09/24 02:27:12 [notice] 10095#0: signal process started
2018/09/24 02:44:43 [notice] 10510#0: signal process started
2018/09/24 02:49:28 [notice] 10606#0: signal process started
2018/09/24 02:53:59 [notice] 10694#0: signal process started

my.cnf配置

[client]
port = 3306
socket = /tmp/mysql.sock
default-character-set = utf8mb4

[mysql]
prompt="MySQL [\d]> "
no-auto-rehash
#event_scheduler = ON
#不添加这句话的话,以后mysql服务一旦重启,事件计划就会失效。
[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
#skip-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

#lower_case_table_names = 1

skip-external-locking
########

########
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

/data/mysql/mysql-error.log 日志

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)

请问大神,这几个东西到底该怎么配置?

回复
阅读 4.4k
2 个回答

兄dei,脑壳痛!

景云之应
  • 3
新手上路,请多包涵

被恶意扫描了,看看PHP慢日志

撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
宣传栏