Get the most out of your Centmin Mod LEMP stack
Become a Member

Beta Branch CentOS 7.x CPU consumption jumped Significantly after moving to 130.00beta01 from 124.00stable

Discussion in 'Beta release code' started by Dannymh, May 17, 2024.

  1. Dannymh

    Dannymh New Member

    19
    3
    3
    Oct 23, 2014
    Ratings:
    +3
    Local Time:
    12:47 AM
    1.7.x
    5.5
    • CentOS Version: CentOS 7 64bit
    • Centmin Mod Version Installed: 130.00beta01
    • Nginx Version Installed:1.25.4
    • PHP Version Installed: 7.4.33 (also tried 8.1 and 8.2.19
    • MariaDB MySQL Version Installed: 10.3.39
    • When was last time updated Centmin Mod code base ? : Yesterday
    • Persistent Config:
      Code (Text):
      MARIADB_INSTALLTENTHREE='y'
      
      
      MARCH_TARGETNATIVE='n'
      
      
      LETSENCRYPT_DETECT='y'
      
      
      NGINXBACKUP='n'
      
      

    Because I run xenforo, they suggest using PHP 8.2 this meant that I had to move to the 130.00beta branch of centminmod. Prior to this my system was running fine with relatively low CPU usage. Once I moved over to the beta branch almost immediately my CPU usage went to over 100% on both cores and has stayed there.

    The only change was moving to the beta branch

    Here are some of the stats from the VPS back end (linode)

    April Averages
    Screenshot 2024-05-17 at 10.42.42 AM.png

    Last 30 Days with Sudden Cliff Yesterday
    Screenshot 2024-05-17 at 10.41.46 AM.png

    Last 30 Days
    Screenshot 2024-05-17 at 10.41.59 AM.png

    I tried rolling different versions of the PHP to see if that was the cause, however its the same issue.

    It looks like its mariadb that is somehow causing this from using htop, so imagine it has to do with the version change


    Screenshot 2024-05-17 at 10.51.37 AM.png

    Any thoughts on what may be the issue here or how to go about bring this back under control?
     
  2. Dannymh

    Dannymh New Member

    19
    3
    3
    Oct 23, 2014
    Ratings:
    +3
    Local Time:
    12:47 AM
    1.7.x
    5.5
    Ok so ran an upgrade of mariadb to 10.4 this seems to have had a positive effect on CPU consumption by mariadb. I am going to watch for a while and then maybe just up us all the way to 10.x because this could just be a version issue
     
  3. Dannymh

    Dannymh New Member

    19
    3
    3
    Oct 23, 2014
    Ratings:
    +3
    Local Time:
    12:47 AM
    1.7.x
    5.5
    Ok spoke too soon it looks like we are still bouncing high CPU usage. Next move is I may move back to a backup or see if I can rollback to 124.00Stable
     
  4. Dannymh

    Dannymh New Member

    19
    3
    3
    Oct 23, 2014
    Ratings:
    +3
    Local Time:
    12:47 AM
    1.7.x
    5.5
    Rolled back to a server backup from yesterday which has 124.00stable on it. Restored the database from today and load is sitting at about a 7% average rather than near on 200%
     
  5. eva2000

    eva2000 Administrator Staff Member

    52,657
    12,071
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +18,597
    Local Time:
    8:47 AM
    Nginx 1.25.x
    MariaDB 10.x
    Centmin Mod 130.00beta01 switch doesn't touch MariaDB version, so would be unrelated most likely. Moving from 124.00stable to 130.00beta01 is about the centmin.sh menu code so if you haven't ran the menu for options 4 or 5 for Nginx and php-fpm upgrades etc, then nothing has changed. But you said you ran menu option 5 for PHP 8.2 upgrade.

    See https://community.centminmod.com/threads/how-to-troubleshoot-high-cpu-load-issues.22483/ for tools to investigate high CPU load.

    For MariaDB you can see what queries are running on command line that maybe cpu intensive

    Code (Text):
    mysqladmin proc


    I would not post the list publicly without masking database names or any sensitive into