Discover Centmin Mod today
Register Now

Sysadmin PHP handlers and optmization?

Discussion in 'System Administration' started by elargento, Mar 25, 2017.

  1. elargento

    elargento Member

    352
    17
    18
    Jan 4, 2016
    Ratings:
    +44
    Local Time:
    2:34 AM
    10
    Hello there :)

    Is there any guide you recommend to learn more about PHP handlers and tune my.cnf and mariadb? I've found many tutorials but each sysadmin has its own opinion and I'd like to know which would be the most appropriate tutorial to follow.


    Thanks
     
  2. eva2000

    eva2000 Administrator Staff Member

    54,891
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,811
    Local Time:
    3:34 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Reading and practice and monitoring is key.

    MySQL Official Docs is a great resource
    I assume php handlers terminology you are referring Cpanel ? Then cpanel docs PHP Handlers - EasyApache - cPanel Documentation and Apache docs https://httpd.apache.org/docs/2.4/ and then lots of trial and error practice.

    For PHP-FPM PHP: FastCGI Process Manager (FPM) - Manual and then lots of trial and error practice.

    All tutorials and guides are just a starting point, there's no golden rule set to follow as it depends on your web app's usage. So it's about learning the rules and best practices and then learning enough to know which of these can be adhered to or not for your own usage requirements.

    Learning = 60% reading + 40% practice :)

    To give you an idea, I can spend between 4-6+ hours a day just learning via reading :)
     
  3. elargento

    elargento Member

    352
    17
    18
    Jan 4, 2016
    Ratings:
    +44
    Local Time:
    2:34 AM
    10
    Yes Eva, I was referring to this but the main question is, how do you check if the changes you made make a real improvement or not? Is there any way to simulate traffic? I think it is almost impossible to check if the optimizations you made have a benefit if you don't have traffic on the server
     
  4. eva2000

    eva2000 Administrator Staff Member

    54,891
    12,240
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,811
    Local Time:
    3:34 PM
    Nginx 1.27.x
    MariaDB 10.x/11.4+
    Monitoring of statistics internally and externally (load testing) is key and all above documentation outlines such as well :)

    Example of very old benchmarks I did during my vBulletin tech days on my personal vB related blog
    monitoring is key

    For basic monitoring i use my very old mysqlmymonlite.sh script which gives me a quick overview of a new server's hardware and software configuration and usage stats in less than <12 seconds. Script supports non-cpanel CentOS, cpanel CentOS and Debian/Ubuntu somewhat but hasn't been tested much on Debian/Ubuntu side. Works fine for Centmin Mod CentOS. For cpanel mysqlmymonlite.sh server stats gathering tool for cPanel Server

    Also discussed at https://community.centminmod.com/threads/mysqlmymonlite-sh-addon.65/