Optimize apache 2.4 Debian 9

Discussion in 'Server Operation' started by Oitsuki, Jul 21, 2018.

  1. Oitsuki

    Oitsuki Member

    Do you have a tutoto install mod_cache or what is your recommandation (with tuto) to optimize apache 2.4 on debian 9 ispconfig 3.1.2 ?Tk
     
  2. ztk.me

    ztk.me ISPConfig Developer ISPConfig Developer

    depends on your current situation, why do you think mod_cache could help you?
    Actually it's your job to know what is going on and to know how this affects the requests you push out.
     
  3. Oitsuki

    Oitsuki Member

    I am not specialist on server, I have a forum (Invision Board) can make big database or request.
     
  4. ztk.me

    ztk.me ISPConfig Developer ISPConfig Developer

    if you followed the default ispconfig installation howto, you could apply
    https://www.howtoforge.com/communit...be-enigma-munin-phpmyadmin-aliases-fix.77489/
    https://www.howtoforge.com/community/threads/debian-9-install-mariadb-10-3.79531/
    https://www.howtoforge.com/community/threads/debian-stretch-pureftp-newer-mariadb-fixes.79514/

    those should give you some decent performance boost, especially the newer mariadb server, if you are tempted to tune your database system for some reason, it does much on its own.

    Code:
    #optimizer_search_depth=7  # if you have querys with tons of subselects, its better to stop optimizing
    innodb_buffer_pool_size=...
    thread_handling="pool-of-threads"
    thread_pool_size=4
    back_log=700
    
    are probably the most interesting pats, set innodb_buffer_pool_size big enough it can hold your data and some more what u expect to be needed. 4GB for example


    also add noatime to your system mount options
    /etc/fstab:
    Code:
    /dev/md/3 /var ext4 defaults,noatime,usrjquota=quota.user,grpjquota=quota.group,jqfmt=vfsv0 0 0
    
    if you have hardware-raid backed up with a battery, check that the cache of the hw-raid is enabled ( some HP units need manual interaction ^^ ) and you could do
    Code:
    /dev/sda1 /var ext4 defaults,noatime,usrjquota=quota.user,grpjquota=quota.group,jqfmt=vfsv0,nobarrier 0 0
    

    it's also good to use a as small as possible parition for mysql data dir at some levels
     

Share This Page