The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Apache + Nginxcp + Mariadb Config

Discussion in 'Workarounds and Optimization' started by mili, Oct 1, 2015.

  1. mili

    mili Registered

    Joined:
    Jul 4, 2015
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    UK
    cPanel Access Level:
    Reseller Owner
    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
    Code:
    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
    Code:
    [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
    Code:
    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
     
  2. lx24

    lx24 Member

    Joined:
    Oct 2, 2014
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page