Join the community today
Become a Member

Beta Branch update MariaDB install/upgrade routines to exclude from OOM in 130.00beta01

Discussion in 'Centmin Mod Github Commits' started by eva2000, Oct 18, 2023.

  1. eva2000

    eva2000 Administrator Staff Member

    59,274
    12,508
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,140
    Local Time:
    7:40 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    update MariaDB install/upgrade routines to exclude from OOM in 130.00beta01

    - update MariaDB initial install or major version upgrade routines to exclude MariaDB MySQL process from Out Of Memory killer process to ensure in low memory situations, MariaDB process isn't a candidate for premature process termination. Such premature termination due to OOM events could potentially cause MySQL data corruption
    - for existing 130.00beta01 users after running cmupdate, running centmin.sh menu will trigger a new mariadb_oomfix function that checks if MariaDB MySQL service has the appropriate /etc/systemd/system/mariadb.service.d/oomscoreadjust.conf config file created to set MariaDB service with OOMScoreAdjust=-1000 to effectively remove it as a candidate for termination. You can verify it it has been set along with other Centmin Mod custom set settings, using SSH command below:

    systemctl show mariadb --no-pager | egrep 'LimitNOFILE|NotifyAccess|OOM'


    example output on CentOS 7

    systemctl show mariadb --no-pager | egrep 'LimitNOFILE|NotifyAccess|OOM'
    NotifyAccess=all
    LimitNOFILE=524288
    OOMScoreAdjust=-1000

    Continue reading...

    130.00beta01 branch

    Support Centmin Mod


    If you find Centmin Mod useful, please help support Centmin Mod