Apache + Nginxcp + Mariadb Config

mili

• October 01, 2015 03:02

Hi can you check our server config and say it's tune or not we have 32 Core cpu and 32 thread 128GB of memory NgnixCP
user nobody; # no need for more workers in the proxy mode worker_processes 32; error_log /var/log/nginx/error.log warn; worker_rlimit_nofile 20480; events { worker_connections 5120; # increase for busier servers use epoll; # you should use epoll here for Linux kernels 2.6.x } http { server_name_in_redirect off; server_names_hash_max_size 10240; server_names_hash_bucket_size 1024; include mime.types; default_type application/octet-stream; server_tokens off; # remove/commentout disable_symlinks if_not_owner;if you get Permission denied error # disable_symlinks if_not_owner; sendfile on; tcp_nopush on; tcp_nodelay on; keepalive_timeout 5; gzip on; gzip_vary on; gzip_disable "MSIE [1-6]\."; gzip_proxied any; gzip_http_version 1.0; gzip_min_length 1000; gzip_comp_level 6; gzip_buffers 16 8k; # You can remove image/png image/x-icon image/gif image/jpeg if you have slow CPU gzip_types text/plain text/xml text/css application/x-javascript application/xml application/javascript application/xml+rss text/javascript application/atom+xml; ignore_invalid_headers on; client_header_timeout 3m; client_body_timeout 3m; send_timeout 3m; reset_timedout_connection on; connection_pool_size 256; client_header_buffer_size 256k; large_client_header_buffers 4 256k; client_max_body_size 200M; client_body_buffer_size 128k; request_pool_size 32k; output_buffers 4 32k; postpone_output 1460; proxy_temp_path /tmp/nginx_proxy/; proxy_cache_path /var/cache/nginx levels=1:2 keys_zone=microcache:15m inactive=24h max_size=500m; client_body_in_file_only on; log_format bytes_log "$msec $bytes_sent ."; log_format custom_microcache '$remote_addr - $remote_user [$time_local] ' '"$request" $status $body_bytes_sent ' '"$http_referer" "$http_user_agent" nocache:$no_cache'; include "/etc/nginx/vhosts/*"; }
Mysql
[mysqld] # GENERAL # local-infile=0 default-storage-engine = MyISAM # MyISAM # key-buffer-size = 44G myisam-recover = FORCE,BACKUP # SAFETY # max-allowed-packet = 16M max-connect-errors = 1000000 skip-name-resolve #sql-mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ONLY_FULL_GR$ sysdate-is-now = 1 # BINARY LOGGING # log-bin = /var/lib/mysql/mysql-bin expire-logs-days = 14 sync-binlog = 1 # CACHES AND LIMITS # tmp-table-size = 512M max-heap-table-size = 512M query-cache-size = 2G query_cache_limit = 512M join_buffer_size = 2G max-connections = 500 thread-cache-size = 50 open-files-limit = 65535 table-definition-cache = 4096 table-open-cache = 10240 # INNODB # innodb-flush-method = O_DIRECT innodb-log-files-in-group = 2 innodb-log-file-size = 32M innodb-flush-log-at-trx-commit = 1 innodb-file-per-table = 1 innodb-buffer-pool-size = 4G innodb_buffer_pool_instances = 4 # LOGGING # log-error = /var/lib/mysql/mysql-error.log log-queries-not-using-indexes = 1 slow-query-log = 1 slow-query-log-file = /var/lib/mysql/mysql-slow.log max_allowed_packet=268435456 open_files_limit=38000 innodb_buffer_pool_size=134217728
Apache
Start Servers 30 Minimum Spare Servers 30 Maximum Spare Servers 60 Server Limit 10240 Max Request Workers 150 Max Connections Per Child 10000 Keep-Alive On defaultOff Keep-Alive Timeout 5 Max Keep-Alive Requests 100 Timeout 300

• 

  lx24

  • October 03, 2015 11:40

  Most of the things appears to be tuned. Are you facing any issue? Do you want to check benchmark score of your environment? If you so then you can check with unix bench or any other tool

  0
• 

  cPanelMichael

  • October 05, 2015 20:28

  Hello :) You may find this thread helpful if you are attempting to tune your MySQL configuration:

  0

Please sign in to leave a comment.