Learn about Centmin Mod LEMP Stack today
Register Now

CentOS 8.x AlmaLinux Rocky Linux Centmin Mod CentOS 8 Compatibility Worklog

Discussion in 'CentOS, Redhat & Oracle Linux News' started by eva2000, Sep 24, 2019.

Thread Status:
Not open for further replies.
  1. eva2000

    eva2000 Administrator Staff Member

    48,863
    11,174
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,407
    Local Time:
    3:28 PM
    Nginx 1.21.x
    MariaDB 10.x
    CentOS Linux 8.0 has been released following from Redhat Enterprise Linux 8.0 release. Below is public work log of what I will need to do to update Centmin Mod to support CentOS 8. CentOS Linux 8.0 uses DNF package manager instead of YUM, but YUM commands are supported as an alias to the actual DNF commands it seems. This development work also applies to making Centmin Mod compatible for AlmaLinux 8 and Rocky Linux 8. Currently, VPSDime has graciously provided some test Premium VPS servers so I can test EL8+ compatibility :D For EL9 based Alma Linux 9 and Rocky Linux 9 compatibility worklog, check out the thread at https://community.centminmod.com/th...-9-rocky-linux-9-compatibility-worklog.22842/.

    Shortcut URLs to reference this thread are below too

    Code (Text):
    cat /etc/redhat-release; uname -r
    CentOS Linux release 8.0.1905 (Core)
    4.18.0-80.el8.x86_64
    


    Redhat/CentOS 8 Release Notes, Manual & Info


    CentOS 8 Community Forum



    Monitor CentOS 8 community forum for issues users report at CentOS - CentOS 8

    To Do List AlmaLinux 8.x



    AlmaLinux 8.x is 1:1 same as CentOS 8 AFAIK so this to do list is in conjunction with below CentOS 8 to do list.
    • Alma Linux 8 has much higher minimum and recommended memory requirements than CentOS 7. Alma Linux 8 minimum is 2GB memory and recommended is at least 4GB memory.
    • With AlmaLinux Elevate announced for CentOS 7 to 8 (EL8) OS migration tooling, this means more testing and work would be needed to ensure Centmin Mod works if folks opt to go this route.
    • Seems both CentOS 8 and AlmaLinux 8.3 are missing libmetalink-devel YUM package which existed in CentOS 7. It's required to build newer wget 1.21.1 with metalink support.
      Code (Text):
      yum -q list libmetalink-devel
      Error: No matching Packages to list
      
      So built it with source libmetalink on test server for now. Will investigate further.
      Code (Text):
      wget -V
      GNU Wget 1.21.1 built on linux-gnu.
      
      -cares +digest -gpgme +https +ipv6 +iri +large-file +metalink +nls 
      +ntlm +opie +psl +ssl/openssl 
      
      Wgetrc: 
          /usr/local/etc/wgetrc (system)
      Locale: 
          /usr/local/share/locale 
      Compile: 
          gcc -DHAVE_CONFIG_H -DSYSTEM_WGETRC="/usr/local/etc/wgetrc" 
          -DLOCALEDIR="/usr/local/share/locale" -I. -I../lib -I../lib 
          -I/usr/local/include -I /usr/include -DHAVE_LIBSSL -DNDEBUG -O2 -g 
          -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS 
          -fexceptions -fstack-protector-strong -fasynchronous-unwind-tables 
          -fstack-clash-protection -fcf-protection -grecord-gcc-switches -m64 
          -mtune=generic 
      Link: 
          gcc -I/usr/local/include -I /usr/include -DHAVE_LIBSSL -DNDEBUG -O2 
          -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS 
          -fexceptions -fstack-protector-strong -fasynchronous-unwind-tables 
          -fstack-clash-protection -fcf-protection -grecord-gcc-switches -m64 
          -mtune=generic -L/usr/local/lib -lmetalink -lpcre2-8 -luuid -lidn2 
          -L /usr/lib64 -lssl -lcrypto -lz -lpsl ftp-opie.o openssl.o 
          http-ntlm.o ../lib/libgnu.a 
      
      Copyright (C) 2015 Free Software Foundation, Inc.
      License GPLv3+: GNU GPL version 3 or later
      <http://www.gnu.org/licenses/gpl.html>.
      This is free software: you are free to change and redistribute it.
      There is NO WARRANTY, to the extent permitted by law.
      
      Originally written by Hrvoje Niksic <hniksic@xemacs.org>.
      Please send bug reports and questions to <bug-wget@gnu.org>.
      

    To Do List CentOS 8



    CentOS 8 differs quite a bit in some areas from CentOS 7 as outlined here. As such Centmin Mod 123.09beta01+ and newer need updates to account for this:
    • CentOS 8 lifecycle has been cut short from May 2029 to Dec 2021 next year moving focus to CentOS 8 Stream and CentOS 8.3 has already started changing the Repository names so scripted/automated installations would break initially on CentOS 8.3. Centmin Mod would have to account for both CentOS <=8.2 and 8.3 repo name changes in all automated routines. Converting from CentOS 8 to CentOS 8 Stream for continued development shouldn't be that hard at OS level at least. Status = TDB
    • Update Centmin Mod to detect and differentiate for CentOS 8 versions. Status = done (commit done).
    • CentOS 8 has much higher minimum and recommended memory requirements than CentOS 7/6. CentOS 8 minimum is 2GB memory and recommended is at least 4GB memory. Centmin Mod's memory check routines will need to be updated to check for CentOS 8 and report to user at initial install time whether their server's memory installed satisfies these memory requirments. Status = done (commit done). Looks like that 2GB minimum might just being overly cautious maybe according to System requirements reference Red Hat Enterprise Linux 8
    • Centmin Mod uses 3rd party YUM repositories like EPEL, REMI and MariaDB for some YUM packages. Centmin Mod needs to ensure same equivalent YUM packages are available in CentOS 8 YUM/DNF repositories. REMI EL8 repo is available so need to test it. EPEL 8 also added an additional epel-playground repository.
      Status = work in progress
    • CentOS 8's EPEL 8 repo seems to have moved some of expected EPEL YUM packages into epel-testing and epel-playground repository so not where they're expected. Centmin Mod will need to adjust routines to run --enablerepo=epel-testing,epel-playground to find and install such YUM packages. Example where some of the packages are:
      Code (Text):
      yum -q list ccache screen re2 uw-imap* pwgen zstd fail2ban figlet haveged jpegoptim lynis --enablerepo=epel-testing,epel-playground --showduplicates | tr -s ' ' | column -t
      Installed              Packages                                     
      figlet.x86_64          2.2.5-18.20151018gita565ae1.el8               @epel
      jpegoptim.x86_64       1.4.6-4.el8                                   @epel
      screen.x86_64          4.6.2-10.el8                                  @epel
      Available              Packages                                     
      ccache.x86_64          3.7.4-1.el8                                   epel-testing
      ccache.x86_64          3.7.4-1.epel8.playground                      epel-playground
      fail2ban.noarch        0.10.4-5.el8                                  epel
      fail2ban.noarch        0.10.4-5.epel8.playground                     epel-playground
      figlet.x86_64          2.2.5-18.20151018gita565ae1.el8               @epel
      figlet.x86_64          2.2.5-18.20151018gita565ae1.el8               epel
      figlet.x86_64          2.2.5-18.20151018gita565ae1.epel8.playground epel-playground                                                     
      haveged.x86_64         1.9.6-1.el8                                   epel
      haveged.x86_64         1.9.6-1.epel8.playground                      epel-playground
      jpegoptim.x86_64       1.4.6-4.el8                                   @epel
      jpegoptim.x86_64       1.4.6-4.el8                                   epel
      jpegoptim.x86_64       1.4.6-4.epel8.playground                      epel-playground
      lynis.noarch           2.7.5-4.el8                                   epel-testing
      lynis.noarch           2.7.5-4.epel8.playground                      epel-playground
      pwgen.x86_64           2.08-3.el8                                    epel-testing
      re2.x86_64             20190801-1.el8                                epel
      re2.x86_64             1:20160401-11.epel8.playground                epel-playground
      screen.x86_64          4.6.2-10.el8                                  @epel
      screen.x86_64          4.6.2-10.el8                                  epel
      screen.x86_64          4.6.2-10.epel8.playground                     epel-playground
      uw-imap.x86_64         2007f-24.el8                                  epel-testing
      uw-imap.x86_64         2007f-24.epel8.playground                     epel-playground
      uw-imap-devel.x86_64   2007f-24.el8                                  epel-testing
      uw-imap-devel.x86_64   2007f-24.epel8.playground                     epel-playground
      uw-imap-static.x86_64  2007f-24.el8                                  epel-testing
      uw-imap-static.x86_64  2007f-24.epel8.playground                     epel-playground
      uw-imap-utils.x86_64   2007f-24.el8                                  epel-testing
      uw-imap-utils.x86_64   2007f-24.epel8.playground                     epel-playground
      zstd.x86_64            1.4.2-1.el8                                   epel-testing
      zstd.x86_64            1.4.2-1.epel8.playground                      epel-playground
      
      Status = work in progress
    • CentOS 8 seems to have moved -devel related YUM packages to a separate PowerTools repository which is disabled by default unlike in CentOS 6/7 where -devel YUM packages were within main repos. So for CentOS 8, either need to enable PowerTools repository by default or pass extra YUM flag --enablerepo=PowerTools to enable it in Centmin Mod routines. Status = work in progress
    • CentOS 8 no longer has a yum-utils YUM package, it has been changed to dnf-utils. Also pkgconfig YUM package has been renamed to pkgconf-pkg-config in CentOS 8. MySQL-python package now in CentOS 8 is provided by python2-PyMySQL and python3-PyMySQL packages. Centmin Mod will need to adjust this when CentOS 8 is detected. Status = work in progress
    • CentOS 8 yum-cron is now dnf-automatic with different config files. Status = work in progress
    • CentOS 8 mariadb-libs is now in mariadb-connector-c. Status = work in progress
    • CentOS 8 or EPEL 8 doesn't have pwgen YUM package used to generate secure passwords. Seems they moved pwgen into a separate epel-testing repository. Centmin Mod routines will need to find an alternative. Status = work in progress
    • CentOS 8 or EPEL 8 doesn't have jemalloc YUM package. However, REMI EL8 YUM repo does. Centmin Mod routines will need to be updated for this. Status = work in progress
    • CentOS 8 no longer provides ntp YUM package and instead recommends Chrony YUM package. So Centmin Mod install routine needs to update to detect CentOS 8 and install Chrony and for CentOS 6/7 install ntp. Status = done (commit done)
    • EPEL yum repo for CentOS 8 and CentOS 8 itself do not have an opendkim YUM package which Centmin Mod uses for addons/opendkim.sh for DKIM setup for server's main hostname. So need to look at alternatives or wait for EPEL EL8 YUM repo to add an opendkim YUM package or build my own custom CentOS 8 RPM versions of OpenDKIM. Status = work in progress
    • CentOS 8 sysstat YUM package no longer uses /etc/cron.d/sysstat to control the interval at which in collects system statistics which defaults to every 10 minutes but instead uses a systemd timer at /usr/lib/systemd/system/sysstat-collect.timer. Centmin Mod's modification of reducing interval from every 10 minutes to every 5 minutes needs updating when CentOS 8 is detected. Status = done (commit done)
    • CentOS 8 doesn't seem to have ImageMagick YUM pages in it's main repo. But EPEL EL8 and REMI EL8 YUm repos do. Centmin Mod used REMI's EL6/EL7 YUM repos for CentOS 6/7 install of ImageMagick. But REMI named those packages as ImageMagick6. However, with CentOS 8, both EPEL and REMI versions are named ImageMagick again. REMI EL8 also has ImageMagick7 packages as well. So will need to update routines to ignore EPEL EL8 version and use REMI EL8 versions. Examples of packages in epel-testing, remi, remi-safe repos:
      Code (Text):
      yum -q list ImageMagick* --enablerepo=epel-testing,epel-playground,remi --showduplicates | tr -s ' ' | column -t
      Available                      Packages               
      ImageMagick.x86_64             6.9.10.64-1.el8         epel-testing
      ImageMagick.x86_64             1:6.9.10.65-1.el8.remi  remi
      ImageMagick.x86_64             1:6.9.10.66-1.el8.remi  remi
      ImageMagick-c++.x86_64         6.9.10.64-1.el8         epel-testing
      ImageMagick-c++.x86_64         1:6.9.10.65-1.el8.remi  remi
      ImageMagick-c++.x86_64         1:6.9.10.66-1.el8.remi  remi
      ImageMagick-c++-devel.x86_64   6.9.10.64-1.el8         epel-testing
      ImageMagick-c++-devel.x86_64   1:6.9.10.65-1.el8.remi  remi
      ImageMagick-c++-devel.x86_64   1:6.9.10.66-1.el8.remi  remi
      ImageMagick-devel.x86_64       6.9.10.64-1.el8         epel-testing
      ImageMagick-devel.x86_64       1:6.9.10.65-1.el8.remi  remi
      ImageMagick-devel.x86_64       1:6.9.10.66-1.el8.remi  remi
      ImageMagick-djvu.x86_64        1:6.9.10.65-1.el8.remi  remi
      ImageMagick-djvu.x86_64        1:6.9.10.66-1.el8.remi  remi
      ImageMagick-doc.x86_64         6.9.10.64-1.el8         epel-testing
      ImageMagick-doc.x86_64         1:6.9.10.65-1.el8.remi  remi
      ImageMagick-doc.x86_64         1:6.9.10.66-1.el8.remi  remi
      ImageMagick-heic.x86_64        1:6.9.10.65-1.el8.remi  remi
      ImageMagick-heic.x86_64        1:6.9.10.66-1.el8.remi  remi
      ImageMagick-libs.x86_64        6.9.10.64-1.el8         epel-testing
      ImageMagick-libs.x86_64        1:6.9.10.65-1.el8.remi  remi
      ImageMagick-libs.x86_64        1:6.9.10.66-1.el8.remi  remi
      ImageMagick-perl.x86_64        6.9.10.64-1.el8         epel-testing
      ImageMagick-perl.x86_64        1:6.9.10.65-1.el8.remi  remi
      ImageMagick-perl.x86_64        1:6.9.10.66-1.el8.remi  remi
      ImageMagick7.x86_64            7.0.8.65-1.el8.remi     remi
      ImageMagick7.x86_64            7.0.8.66-1.el8.remi     remi
      ImageMagick7-c++.x86_64        7.0.8.65-1.el8.remi     remi-safe
      ImageMagick7-c++.x86_64        7.0.8.65-1.el8.remi     remi
      ImageMagick7-c++.x86_64        7.0.8.66-1.el8.remi     remi-safe
      ImageMagick7-c++.x86_64        7.0.8.66-1.el8.remi     remi
      ImageMagick7-c++-devel.x86_64  7.0.8.65-1.el8.remi     remi
      ImageMagick7-c++-devel.x86_64  7.0.8.66-1.el8.remi     remi
      ImageMagick7-devel.x86_64      7.0.8.65-1.el8.remi     remi
      ImageMagick7-devel.x86_64      7.0.8.66-1.el8.remi     remi
      ImageMagick7-djvu.x86_64       7.0.8.65-1.el8.remi     remi-safe
      ImageMagick7-djvu.x86_64       7.0.8.65-1.el8.remi     remi
      ImageMagick7-djvu.x86_64       7.0.8.66-1.el8.remi     remi-safe
      ImageMagick7-djvu.x86_64       7.0.8.66-1.el8.remi     remi
      ImageMagick7-doc.x86_64        7.0.8.65-1.el8.remi     remi
      ImageMagick7-doc.x86_64        7.0.8.66-1.el8.remi     remi
      ImageMagick7-heic.x86_64       7.0.8.65-1.el8.remi     remi-safe
      ImageMagick7-heic.x86_64       7.0.8.65-1.el8.remi     remi
      ImageMagick7-heic.x86_64       7.0.8.66-1.el8.remi     remi-safe
      ImageMagick7-heic.x86_64       7.0.8.66-1.el8.remi     remi
      ImageMagick7-libs.x86_64       7.0.8.65-1.el8.remi     remi-safe
      ImageMagick7-libs.x86_64       7.0.8.65-1.el8.remi     remi
      ImageMagick7-libs.x86_64       7.0.8.66-1.el8.remi     remi-safe
      ImageMagick7-libs.x86_64       7.0.8.66-1.el8.remi     remi
      ImageMagick7-perl.x86_64       7.0.8.65-1.el8.remi     remi
      ImageMagick7-perl.x86_64       7.0.8.66-1.el8.remi     remi
      
      Status = work in progress
    • Centmin Mod uses CSF Firewall instead of Firewalld - both Firewalld and CSF are essentially wrappers to communicate with CentOS 6/7's iptables firewall. However, CentOS 8 switched from iptables to nftables. You can read differences between iptables vs nftables here. CSF Firewall only supports iptables right now so no nftables support. Centmin Mod would need to wait on CSF Firewall to add nftables support and/or offer an option for CentOS 8 installs to not use CSF Firewall and instead use Firewalld which would interface with nftables. Also centmin.sh menu option 16 would need updating for SSHD port change routine which also automatically updates CSF Firewall's whitelisted SSHD port. With CentOS would also need to ensure such routine works with Firewalld/nftables. However, it seems one can disable firewalld/nftables and go back to using iptables as well via guide outlined. So that is an option for Centmin Mod and CSF Firewall usage too. Right now Centmin Mod will switch back to CSF Firewall with iptables. Also there might be some network performance slowness with CentOS 8 and CSF configurations which need to be investigated. Status = done (commit done)
    • CentOS 8 defaults to python 3.6 (via python36 YUM package) with option to install python 2.7 (via python2 YUM package) and each require using python3/python2 or pip3/pip2 commands. There's no longer a path to non-version defined python/pip. Centmin Mod needs to update python 2.7/3.6 routines as CentOS 7 has python 2.7 default with CentOS 7.7+ supporting python 3.6 natively via python3 packages. Status = work in progress
    • CentOS 8's grep command has some changes in the way it operates. Centmin Mod needs to ensure such changes don't change the results grep returns for Centmin Mod's routines. Status = work in progress
    • CentOS 8 with updated 4.18 Linux Kernel now supports Google BBR TCP congestion control algorithm. Centmin Mod routines need to update to detect CentOS 8 and automatically setup and enable Google BBR TCP congestion control algorithm via optional persistent config file variable type setup. Status = work in progress
    • CentOS 8 doesn't have yum-plugin-versionlock YUM plugin anymore to do YUM version locks on YUM packages you do not want updated when running yum commands. CentOS 8 seems to have a DNF package named python3-dnf-plugin-versionlock. Centmin Mod uses YUM version locks to control what YUM packages get updated and when due to using 3rd party YUM repos like EPEL, REMI for CentOS 6/7. Centmin Mod will need to update all YUM version lock routines to install python3-dnf-plugin-versionlock instead of yum-plugin-versionlock YUM plugin when CentOS 8 is detected. Status = work in progress
    • CentOS 8 comes with MariaDB 10.3 default. However, it's a few versions behind official MariaDB YUM repos which Centmin Mod usually uses. CentOS 8 has MariaDB 10.3.11 right now while MariaDB official YUM has 10.3.18. Need to update Centmin Mod routines to use official MariaDB YUM repo version instead of CentOS 8's version. Official MariaDB YUM repo version with newer 10.3.18. If AppStream repo is disabled, MariaDB-server package does show but below bug outlined seems to hide MariaDB-server package if AppStream is enabled despite CentOS 8 native MariaDB module being disabled.
      Code (Text):
      yum -q list MariaDB-* --disablerepo=AppStream| tr -s ' ' | column -t                 
      Installed                                         Packages       
      mariadb-connector-c.x86_64                        3.0.7-1.el8    @AppStream
      mariadb-connector-c-config.noarch                 3.0.7-1.el8    @AppStream
      Available                                         Packages       
      MariaDB-backup.x86_64                             10.3.18-1.el8  mariadb
      MariaDB-backup-debuginfo.x86_64                   10.3.18-1.el8  mariadb
      MariaDB-client.x86_64                             10.3.18-1.el8  mariadb
      MariaDB-client-debuginfo.x86_64                   10.3.18-1.el8  mariadb
      MariaDB-common.x86_64                             10.3.18-1.el8  mariadb
      MariaDB-common-debuginfo.x86_64                   10.3.18-1.el8  mariadb
      MariaDB-connect-engine.x86_64                     10.3.18-1.el8  mariadb
      MariaDB-connect-engine-debuginfo.x86_64           10.3.18-1.el8  mariadb
      MariaDB-cracklib-password-check.x86_64            10.3.18-1.el8  mariadb
      MariaDB-cracklib-password-check-debuginfo.x86_64  10.3.18-1.el8  mariadb
      MariaDB-devel.x86_64                              10.3.18-1.el8  mariadb
      MariaDB-devel-debuginfo.x86_64                    10.3.18-1.el8  mariadb
      MariaDB-gssapi-server.x86_64                      10.3.18-1.el8  mariadb
      MariaDB-gssapi-server-debuginfo.x86_64            10.3.18-1.el8  mariadb
      MariaDB-server.x86_64                             10.3.18-1.el8  mariadb
      MariaDB-server-debuginfo.x86_64                   10.3.18-1.el8  mariadb
      MariaDB-shared.x86_64                             10.3.18-1.el8  mariadb
      MariaDB-shared-debuginfo.x86_64                   10.3.18-1.el8  mariadb
      MariaDB-test.x86_64                               10.3.18-1.el8  mariadb
      MariaDB-test-debuginfo.x86_64                     10.3.18-1.el8  mariadb
      MariaDB-tokudb-engine.x86_64                      10.3.18-1.el8  mariadb
      MariaDB-tokudb-engine-debuginfo.x86_64            10.3.18-1.el8  mariadb
      
      compared to CentOS 8 default MariaDB older version.
      Code (Text):
      yum -q list mariadb-* --disablerepo=mariadb| tr -s ' ' | column -t       
      Installed                          Packages                               
      mariadb-connector-c.x86_64         3.0.7-1.el8                             @AppStream
      mariadb-connector-c-config.noarch  3.0.7-1.el8                             @AppStream
      Available                          Packages                               
      mariadb-backup.x86_64              3:10.3.11-2.module_el8.0.0+35+6f2527ed  AppStream
      mariadb-common.x86_64              3:10.3.11-2.module_el8.0.0+35+6f2527ed  AppStream
      mariadb-connector-c-devel.x86_64   3.0.7-1.el8                             AppStream
      mariadb-connector-odbc.x86_64      3.0.7-1.el8                             AppStream
      mariadb-devel.x86_64               3:10.3.11-2.module_el8.0.0+35+6f2527ed  AppStream
      mariadb-embedded.x86_64            3:10.3.11-2.module_el8.0.0+35+6f2527ed  AppStream
      mariadb-embedded-devel.x86_64      3:10.3.11-2.module_el8.0.0+35+6f2527ed  AppStream
      mariadb-errmsg.x86_64              3:10.3.11-2.module_el8.0.0+35+6f2527ed  AppStream
      mariadb-gssapi-server.x86_64       3:10.3.11-2.module_el8.0.0+35+6f2527ed  AppStream
      mariadb-java-client.noarch         2.2.5-2.el8                             AppStream
      mariadb-oqgraph-engine.x86_64      3:10.3.11-2.module_el8.0.0+35+6f2527ed  AppStream
      mariadb-server.x86_64              3:10.3.11-2.module_el8.0.0+35+6f2527ed  AppStream
      mariadb-server-galera.x86_64       3:10.3.11-2.module_el8.0.0+35+6f2527ed  AppStream
      mariadb-server-utils.x86_64        3:10.3.11-2.module_el8.0.0+35+6f2527ed  AppStream
      mariadb-test.x86_64                3:10.3.11-2.module_el8.0.0+35+6f2527ed  AppStream
      
      Not sure if it's a bug but if you install official MariaDB YUM repo for CentOS 8, doing yum list for the packages returns a mix of packages most from official MariaDB YUM repo, but mariadb-common and mariadb-server seem to come from native CentOS 8 AppStream repository still ?
      Code (Text):
      yum -q list mariadb-client mariadb-server mariadb-common mariadb-shared --showduplicates | tr -s ' ' | column -t
      Available              Packages                               
      MariaDB-client.x86_64  10.3.16-1.el8                           mariadb
      MariaDB-client.x86_64  10.3.17-1.el8                           mariadb
      MariaDB-client.x86_64  10.3.18-1.el8                           mariadb
      MariaDB-common.x86_64  10.3.16-1.el8                           mariadb
      MariaDB-common.x86_64  10.3.17-1.el8                           mariadb
      MariaDB-common.x86_64  10.3.18-1.el8                           mariadb
      MariaDB-shared.x86_64  10.3.16-1.el8                           mariadb
      MariaDB-shared.x86_64  10.3.17-1.el8                           mariadb
      MariaDB-shared.x86_64  10.3.18-1.el8                           mariadb
      mariadb-common.x86_64  3:10.3.11-2.module_el8.0.0+35+6f2527ed  AppStream
      mariadb-server.x86_64  3:10.3.11-2.module_el8.0.0+35+6f2527ed  AppStream
      
      Looks like only way in CentOS 8, is to disable CentOS 8 native mariadb module and then we can now use official MariaDB YUM repo
      Code (Text):
      yum -q list mariadb-client mariadb-server mariadb-common mariadb-shared --showduplicates | tr -s ' ' | column -t
      Available              Packages       
      MariaDB-client.x86_64  10.3.16-1.el8  mariadb
      MariaDB-client.x86_64  10.3.17-1.el8  mariadb
      MariaDB-client.x86_64  10.3.18-1.el8  mariadb
      MariaDB-common.x86_64  10.3.16-1.el8  mariadb
      MariaDB-common.x86_64  10.3.17-1.el8  mariadb
      MariaDB-common.x86_64  10.3.18-1.el8  mariadb
      MariaDB-shared.x86_64  10.3.16-1.el8  mariadb
      MariaDB-shared.x86_64  10.3.17-1.el8  mariadb
      MariaDB-shared.x86_64  10.3.18-1.el8  mariadb
      
      However, seems MariaDB-server package missing from MariaDB.org YUM repo - logged bug in MariaDB Jira bug tracker and also now logged upstream in Redhat bug tracker. Status = work in progress
    • ELrepo's Mainline Linux Kernel YUM repository seems ready for CentOS with Linux 5.3.1 Kernel available - good news for AMD EPYC/Ryzen users for better performance. Centmin Mod testing for ELrepo Mainline Linux Kernel will needed to be done as it's a possible feature option for Centmin Mod's DigitalOcean 1-click Marketplace support planned. Status = work in progress
      Code (Text):
      yum -q list kernel-ml kernel-ml-devel kernel-ml-tools --enablerepo=elrepo-kernel  | tr -s ' ' | column -t
      Available               Packages           
      kernel-ml.x86_64        5.3.1-1.el8.elrepo  elrepo-kernel
      kernel-ml-devel.x86_64  5.3.1-1.el8.elrepo  elrepo-kernel
      kernel-ml-tools.x86_64  5.3.1-1.el8.elrepo  elrepo-kernel
      

    • CentOS 8 has a new CentOS Stream. Investigate how Centmin Mod will fit in with this. Status = work in progress
    • CentOS 8.2 release brought new changes to auditd which will impact Centmin Mod 123.09beta01 and newer's tools/auditd.sh script. It means I'll need to rework tools/auditd.sh to detect CentOS 7 and <=8.1 vs 8.2 appropriately. Status = work in progress
    I'll update this thread with more work needed to do as I start testing CentOS 8 and Centmin Mod compatibility.

    Supporting Centmin Mod



    If you find Centmin Mod userful, please consider supporting Centmin Mod via a donation or upgrading to Centmin Mod Premium Membership.

     
    Last edited: May 30, 2022
  2. eva2000

    eva2000 Administrator Staff Member

    48,863
    11,174
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,407
    Local Time:
    3:28 PM
    Nginx 1.21.x
    MariaDB 10.x
    Possible solution for CSF Firewall and that is to switch back from firewalld/nftables in CentOS 8 to CentOS 8 using iptables. Similar process as CentOS 7 just need to stop/disable nftables too it seems How to disable firewalld and nftables and use iptables instead? - Red Hat Customer Portal

    Edit: updated 123.09beta01 to switch back to CSF Firewall with iptables for CentOS 8 Beta Branch - CentOS 8 prep for CSF Firewall in 123.09beta01

    Edit: CSF Firewall 13.07 version was released with more RHEL/CentOS 8 compatibility fixes along with switching firewalld/nftables to csf firewall/iptables now allows CSF Firewall to install on CentOS 8

    CSF service
    Code (Text):
    systemctl status csf
    ● csf.service - ConfigServer Firewall & Security - csf
       Loaded: loaded (/usr/lib/systemd/system/csf.service; enabled; vendor preset: disabled)
       Active: active (exited) since Sat 2019-10-05 08:36:29 AEST; 4min 27s ago
      Process: 6193 ExecStop=/usr/sbin/csf --stop (code=exited, status=0/SUCCESS)
      Process: 6176 ExecStop=/usr/sbin/csf --initdown (code=exited, status=0/SUCCESS)
      Process: 6225 ExecStart=/usr/sbin/csf --initup (code=exited, status=0/SUCCESS)
     Main PID: 6225 (code=exited, status=0/SUCCESS)
    Oct 05 08:36:28 centos8.local systemd[1]: Starting ConfigServer Firewall & Security - csf...
    Oct 05 08:36:29 centos8.local csf[6225]: (restoring iptables) (restoring ip6tables)
    Oct 05 08:36:29 centos8.local systemd[1]: Started ConfigServer Firewall & Security - csf.
    

    CSF lfd service
    Code (Text):
    systemctl status lfd
    ● lfd.service - ConfigServer Firewall & Security - lfd
       Loaded: loaded (/usr/lib/systemd/system/lfd.service; enabled; vendor preset: disabled)
       Active: active (running) since Sat 2019-10-05 08:36:29 AEST; 4min 21s ago
      Process: 6256 ExecStart=/usr/sbin/lfd (code=exited, status=0/SUCCESS)
     Main PID: 6269 (lfd - sleeping)
        Tasks: 1 (limit: 11521)
       Memory: 30.3M
       CGroup: /system.slice/lfd.service
               └─6269 lfd - sleeping                                                                                                                                                           
    Oct 05 08:36:29 centos8.local systemd[1]: Starting ConfigServer Firewall & Security - lfd...
    Oct 05 08:36:29 centos8.local systemd[1]: Started ConfigServer Firewall & Security - lfd.
    
     
  3. eva2000

    eva2000 Administrator Staff Member

    48,863
    11,174
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,407
    Local Time:
    3:28 PM
    Nginx 1.21.x
    MariaDB 10.x

    EPEL 8 OpenDKIM YUM Packages



    EPEL 8 YUM repo is still missing YUM packages for OpenDKIM and related dependencies for opendbx and opendbx-devel which Centmin Mod uses for addons/opendkim.sh for DKIM setup for server's main hostname. However, managed to finally build custom OpenDKIM RPMs for CentOS 8 by installing EPEL 7 for CentOS 7's version of opendbx and opendbx-devel first. Still prefer EPEL 8 YUM repo to have OpenDKIM and opendbx/opendbx-devel packages eventually though. But if not, I'll have to use my custom OpenDKIM CentOS 8 RPM packages.

    Code (Text):
    tree -Ah
    .
    +-- [  78K]  libopendkim-2.11.0-0.1.el8.x86_64.rpm
    +-- [ 142K]  libopendkim-debuginfo-2.11.0-0.1.el8.x86_64.rpm
    +-- [  89K]  libopendkim-devel-2.11.0-0.1.el8.x86_64.rpm
    +-- [ 234K]  opendkim-2.11.0-0.1.el8.x86_64.rpm
    +-- [ 294K]  opendkim-debuginfo-2.11.0-0.1.el8.x86_64.rpm
    +-- [ 218K]  opendkim-debugsource-2.11.0-0.1.el8.x86_64.rpm
    
    0 directories, 6 files

    Code (Text):
    yum info opendkim-2.11.0-0.1.el8.x86_64
    Last metadata expiration check: 0:22:14 ago on Tue 10 Dec 2019 12:49:01 AM AEST.
    Installed Packages
    Name         : opendkim
    Version      : 2.11.0
    Release      : 0.1.el8
    Arch         : x86_64
    Size         : 634 k
    Source       : opendkim-2.11.0-0.1.el8.src.rpm
    Repo         : @System
    From repo    : @commandline
    Summary      : A DomainKeys Identified Mail (DKIM) milter to sign and/or verify mail
    URL          : http://opendkim.org/
    License      : BSD and Sendmail
    Description  : OpenDKIM allows signing and/or verification of email through an open source
                 : library that implements the DKIM service, plus a milter-based filter
                 : application that can plug in to any milter-aware MTA, including sendmail,
                 : Postfix, or any other MTA that supports the milter protocol
    

    Code (Text):
    yum info libopendkim-2.11.0-0.1.el8.x86_64
    Last metadata expiration check: 0:22:42 ago on Tue 10 Dec 2019 12:49:01 AM AEST.
    Installed Packages
    Name         : libopendkim
    Version      : 2.11.0
    Release      : 0.1.el8
    Arch         : x86_64
    Size         : 147 k
    Source       : opendkim-2.11.0-0.1.el8.src.rpm
    Repo         : @System
    From repo    : @commandline
    Summary      : An open source DKIM library
    URL          : http://opendkim.org/
    License      : BSD and Sendmail
    Description  : This package contains the library files required for running services built
                 : using libopendkim.

    Code (Text):
    yum info libopendkim-devel-2.11.0-0.1.el8.x86_64
    Last metadata expiration check: 0:23:37 ago on Tue 10 Dec 2019 12:49:01 AM AEST.
    Installed Packages
    Name         : libopendkim-devel
    Version      : 2.11.0
    Release      : 0.1.el8
    Arch         : x86_64
    Size         : 395 k
    Source       : opendkim-2.11.0-0.1.el8.src.rpm
    Repo         : @System
    From repo    : @commandline
    Summary      : Development files for libopendkim
    URL          : http://opendkim.org/
    License      : BSD and Sendmail
    Description  : This package contains the static libraries, headers, and other support files
                 : required for developing applications against libopendkim.

    Code (Text):
    rpm -ql opendkim-2.11.0-0.1.el8.x86_64 | egrep 'bin|.conf'
    /etc/opendkim.conf
    /etc/sysconfig/opendkim
    /etc/tmpfiles.d/opendkim.conf
    /usr/sbin/opendkim
    /usr/sbin/opendkim-default-keygen
    /usr/sbin/opendkim-genkey
    /usr/sbin/opendkim-genzone
    /usr/sbin/opendkim-reportstats
    /usr/sbin/opendkim-testkey
    /usr/sbin/opendkim-testmsg
    /usr/share/doc/opendkim/opendkim.conf.sample
    /usr/share/doc/opendkim/opendkim.conf.simple
    /usr/share/doc/opendkim/opendkim.conf.simple-verify
    /usr/share/man/man5/opendkim.conf.5.gz
    

    Code (Text):
    rpm -ql libopendkim-devel-2.11.0-0.1.el8.x86_64 | egrep '.so|.h$'
    /usr/include/opendkim/dkim.h
    /usr/lib64/libopendkim.so
     
  4. eva2000

    eva2000 Administrator Staff Member

    48,863
    11,174
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,407
    Local Time:
    3:28 PM
    Nginx 1.21.x
    MariaDB 10.x

    MariaDB.org Official YUM Install Bug For MariaDB-server YUM Package



    Seems for MariaDB official YUM repo bug in CentOS 8 mentioned in 1st post, MariaDB folks updated [MDEV-20673] MariaDB-server package not listing on CentOS 8 - Jira with a workaround temp fix mentioned here. MariaDB folks consider it's a bug in CentOS 8's dnf (YUM4) package manager.

    Using module_hotfixes=true as a workaround
    So the MariaDB CentOS 8 repo file becomes
    Code (Text):
    # MariaDB 10.3 CentOS repository list - created 2020-01-22 22:57 UTC
    # http://downloads.mariadb.org/mariadb/repositories/
    [mariadb]
    name = MariaDB
    baseurl = http://yum.mariadb.org/10.3/centos8-amd64
    module_hotfixes=1
    gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
    gpgcheck=1
    

    Added changes to my private dev 123.09beta01-centos8 branch which is solely just for MariaDB CentOS 8 development. Eventually work will be merged into 123.09beta01 public branch.

    private-cmm-centos-8-230120-01.png
     
    Last edited: Jan 23, 2020
  5. eva2000

    eva2000 Administrator Staff Member

    48,863
    11,174
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,407
    Local Time:
    3:28 PM
    Nginx 1.21.x
    MariaDB 10.x

    May 7, 2020 Update For CentOS 8 Compatibility



    Just an update on CentOS 8 development and compatibility status for Centmin Mod 123.09beta01 and newer versions. It is still basically delayed due to above listed factors. Particularly, for missing 3rd party YUM/repository packages needing to catch up for missing CentOS 8 package and dependencies. It could go either way now with Corona virus forcing everyone to stay home - they may have more free time to get packages done or not.

    It's not just what Centmin Mod requires but software/web apps that end users may require which I would not have foreseen. I don't want folks to start installing on CentOS 8 only to find out their specific web apps won't work due to packages they need that aren't available in CentOS 8 and CentOS 8 3rd party YUM repositories and I didn't know of.

    You can track some of the package requests and package bugs due to CentOS/Redhat 8 differences in EPEL 8 bug tracker here.
     
  6. eva2000

    eva2000 Administrator Staff Member

    48,863
    11,174
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,407
    Local Time:
    3:28 PM
    Nginx 1.21.x
    MariaDB 10.x
    CentOS 8.2 was just released and it brought more changes relevant to Centmin Mod development.

    auditd changes means I'll have to look at my tools/auditd.sh Centmin Mod Auditd Support Added In Latest 123.09beta01
     
  7. eva2000

    eva2000 Administrator Staff Member

    48,863
    11,174
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,407
    Local Time:
    3:28 PM
    Nginx 1.21.x
    MariaDB 10.x
  8. eva2000

    eva2000 Administrator Staff Member

    48,863
    11,174
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,407
    Local Time:
    3:28 PM
    Nginx 1.21.x
    MariaDB 10.x
    CentOS 8 lifecycle has been cut short from May 2029 to Dec 2021 next year moving focus to CentOS 8 Stream and CentOS 8.3 has already started changing the Repository names so scripted/automated installations would break initially on CentOS 8.3. Centmin Mod would have to account for both CentOS <=8.2 and 8.3 repo name changes in all automated routines. Converting from CentOS 8 to CentOS 8 Stream for continued development shouldn't be that hard at OS level at least.
     
    Last edited: Dec 9, 2020
  9. eva2000

    eva2000 Administrator Staff Member

    48,863
    11,174
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,407
    Local Time:
    3:28 PM
    Nginx 1.21.x
    MariaDB 10.x

    CentOS 8 Development Continues With AlmaLinux 8.3



    AlmaLinux 8.3 is a new forked version of Redhat Enterprise Linux 8 to replace it as CentOS 8 is end of life at end of this year 2021 - another 8 months to go. Centmin Mod 123.09beta01 and higher will continue CentOS 8 and thus AlmaLinux 8.3 compatibility development in a separate branch on Github, 123.09beta01-el8.3. This branch is not for production use as it's still being developed and tested.

    However, you can follow updates to Centmin Mod 123.09beta01-el8.3 branch via:
     
    Last edited: Apr 5, 2021
  10. eva2000

    eva2000 Administrator Staff Member

    48,863
    11,174
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,407
    Local Time:
    3:28 PM
    Nginx 1.21.x
    MariaDB 10.x
    Seems both CentOS 8 and AlmaLinux 8.3 are missing libmetalink-devel YUM package which existed in CentOS 7. It's required to build newer wget 1.21.1 with metalink support.
    Code (Text):
    yum -q list libmetalink-devel
    Error: No matching Packages to list
    
    So built it with source libmetalink on test server for now. Will investigate further.

    Still not perfect as missing gpgme support which I'll add next. Seems default wget is built with gnuTLS while I built mine with OpenSSL crypto library. CentOS 7 built wget with OpenSSL so this changed in CentOS 8 to using gnuTLS by default - maybe due to TLSv1.3 support in gnuTLS though OpenSSL 1.1.1 in CentOS 8/AlmaLinux 8 is also TLSv1.3 capable.
    Code (Text):
    wget -V
    GNU Wget 1.21.1 built on linux-gnu.
    
    -cares +digest -gpgme +https +ipv6 +iri +large-file +metalink +nls
    +ntlm +opie +psl +ssl/openssl
    
    Wgetrc:
        /usr/local/etc/wgetrc (system)
    Locale:
        /usr/local/share/locale
    Compile:
        gcc -DHAVE_CONFIG_H -DSYSTEM_WGETRC="/usr/local/etc/wgetrc"
        -DLOCALEDIR="/usr/local/share/locale" -I. -I../lib -I../lib
        -I/usr/local/include -I /usr/include -DHAVE_LIBSSL -DNDEBUG -O2 -g
        -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS
        -fexceptions -fstack-protector-strong -fasynchronous-unwind-tables
        -fstack-clash-protection -fcf-protection -grecord-gcc-switches -m64
        -mtune=generic
    Link:
        gcc -I/usr/local/include -I /usr/include -DHAVE_LIBSSL -DNDEBUG -O2
        -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS
        -fexceptions -fstack-protector-strong -fasynchronous-unwind-tables
        -fstack-clash-protection -fcf-protection -grecord-gcc-switches -m64
        -mtune=generic -L/usr/local/lib -lmetalink -lpcre2-8 -luuid -lidn2
        -L /usr/lib64 -lssl -lcrypto -lz -lpsl ftp-opie.o openssl.o
        http-ntlm.o ../lib/libgnu.a
    
    Copyright (C) 2015 Free Software Foundation, Inc.
    License GPLv3+: GNU GPL version 3 or later
    <http://www.gnu.org/licenses/gpl.html>.
    This is free software: you are free to change and redistribute it.
    There is NO WARRANTY, to the extent permitted by law.
    
    Originally written by Hrvoje Niksic <hniksic@xemacs.org>.
    Please send bug reports and questions to <bug-wget@gnu.org>.
    

    CentOS 8 and AlmaLinux 8.3's default wget version is 1.19.5 with backported security and some bug fixes
    Code (Text):
    /usr/bin/wget -V
    GNU Wget 1.19.5 built on linux-gnu.
    
    -cares +digest +gpgme +https +ipv6 +iri +large-file +metalink +nls
    +ntlm +opie +psl +ssl/gnutls
    
    Wgetrc:
        /etc/wgetrc (system)
    Locale:
        /usr/share/locale
    Compile:
        gcc -DHAVE_CONFIG_H -DSYSTEM_WGETRC="/etc/wgetrc"
        -DLOCALEDIR="/usr/share/locale" -I. -I../lib -I../lib
        -I/usr/include/p11-kit-1 -DHAVE_LIBGNUTLS -DNDEBUG -O2 -g -pipe
        -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2
        -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong
        -grecord-gcc-switches
        -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1
        -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=generic
        -fasynchronous-unwind-tables -fstack-clash-protection
        -fcf-protection
    Link:
        gcc -I/usr/include/p11-kit-1 -DHAVE_LIBGNUTLS -DNDEBUG -O2 -g -pipe
        -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2
        -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong
        -grecord-gcc-switches
        -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1
        -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=generic
        -fasynchronous-unwind-tables -fstack-clash-protection
        -fcf-protection -Wl,-z,relro -Wl,-z,now
        -specs=/usr/lib/rpm/redhat/redhat-hardened-ld -luuid -lidn2
        -L/usr/lib64 -lgpgme -lmetalink -lnettle -lgnutls -lz -lpsl
        ftp-opie.o gnutls.o http-ntlm.o ../lib/libgnu.a
    
    Copyright (C) 2015 Free Software Foundation, Inc.
    License GPLv3+: GNU GPL version 3 or later
    <http://www.gnu.org/licenses/gpl.html>.
    This is free software: you are free to change and redistribute it.
    There is NO WARRANTY, to the extent permitted by law.
    
    Originally written by Hrvoje Niksic <hniksic@xemacs.org>.
    Please send bug reports and questions to <bug-wget@gnu.org>.
    

    edit: Updated wget 1.21.1 build with gpgme support :)
    Code (Text):
    wget -V
    GNU Wget 1.21.1 built on linux-gnu.
    
    -cares +digest +gpgme +https +ipv6 +iri +large-file +metalink +nls
    +ntlm +opie +psl +ssl/openssl
    
    Wgetrc:
        /usr/local/etc/wgetrc (system)
    Locale:
        /usr/local/share/locale
    Compile:
        gcc -DHAVE_CONFIG_H -DSYSTEM_WGETRC="/usr/local/etc/wgetrc"
        -DLOCALEDIR="/usr/local/share/locale" -I. -I../lib -I../lib
        -I/usr/local/include -I /usr/include -DHAVE_LIBSSL -DNDEBUG -O2 -g
        -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS
        -fexceptions -fstack-protector-strong -fasynchronous-unwind-tables
        -fstack-clash-protection -fcf-protection -grecord-gcc-switches -m64
        -mtune=generic
    Link:
        gcc -I/usr/local/include -I /usr/include -DHAVE_LIBSSL -DNDEBUG -O2
        -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS
        -fexceptions -fstack-protector-strong -fasynchronous-unwind-tables
        -fstack-clash-protection -fcf-protection -grecord-gcc-switches -m64
        -mtune=generic -L/usr/local/lib -lmetalink -lpcre2-8 -luuid -lidn2
        -L /usr/lib64 -lssl -lcrypto -lz -lpsl -L/usr/lib64 -lgpgme
        ftp-opie.o openssl.o http-ntlm.o ../lib/libgnu.a
    
    Copyright (C) 2015 Free Software Foundation, Inc.
    License GPLv3+: GNU GPL version 3 or later
    <http://www.gnu.org/licenses/gpl.html>.
    This is free software: you are free to change and redistribute it.
    There is NO WARRANTY, to the extent permitted by law.
    
    Originally written by Hrvoje Niksic <hniksic@xemacs.org>.
    Please send bug reports and questions to <bug-wget@gnu.org>.
    

    also tried building wget 1.21.1 with gnuTLS same as default wget 1.19.5 instead of OpenSSL. Will make it an option to choose between gnuTLS and OpenSSL in AlmaLinux and CentOS 8
    Code (Text):
    wget -V
    GNU Wget 1.21.1 built on linux-gnu.
    
    -cares +digest +gpgme +https +ipv6 +iri +large-file +metalink +nls 
    +ntlm +opie +psl +ssl/gnutls 
    
    Wgetrc: 
        /usr/local/etc/wgetrc (system)
    Locale: 
        /usr/local/share/locale 
    Compile: 
        gcc -DHAVE_CONFIG_H -DSYSTEM_WGETRC="/usr/local/etc/wgetrc" 
        -DLOCALEDIR="/usr/local/share/locale" -I. -I../lib -I../lib 
        -I/usr/local/include -I/usr/include/p11-kit-1 -DHAVE_LIBGNUTLS 
        -DNDEBUG -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 
        -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong 
        -fasynchronous-unwind-tables -fstack-clash-protection 
        -fcf-protection -grecord-gcc-switches -m64 -mtune=generic 
    Link: 
        gcc -I/usr/local/include -I/usr/include/p11-kit-1 -DHAVE_LIBGNUTLS 
        -DNDEBUG -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 
        -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong 
        -fasynchronous-unwind-tables -fstack-clash-protection 
        -fcf-protection -grecord-gcc-switches -m64 -mtune=generic 
        -L/usr/local/lib -lmetalink -lpcre2-8 -luuid -lidn2 -lnettle 
        -lgnutls -lz -lpsl -L/usr/lib64 -lgpgme ftp-opie.o gnutls.o 
        http-ntlm.o ../lib/libgnu.a 
    
    Copyright (C) 2015 Free Software Foundation, Inc.
    License GPLv3+: GNU GPL version 3 or later
    <http://www.gnu.org/licenses/gpl.html>.
    This is free software: you are free to change and redistribute it.
    There is NO WARRANTY, to the extent permitted by law.
    
    Originally written by Hrvoje Niksic <hniksic@xemacs.org>.
    Please send bug reports and questions to <bug-wget@gnu.org>.
    


    Why do I even bother with being able to build wget newer versions when Redhat, CentOS and AlmaLinux backport security fixes and some bug fixes to older versions like wget 1.19.5? It's because
    1. Not all bug and security fixes get backported, only the most severe
    2. In the past there was one case where wget security bug existed in CentOS 6 and CentOS 7. But Redhat upstream would only fix CentOS 7 version and marked CentOS 6 security bug as 'will not fix'. It was then when I added to Centmin Mod support for building newer wget versions to cover such cases.
    3. The Centmin Mod wget version doesn't override default wget as it's installed side by side at /usr/local/bin/wget while default is at /usr/bin/wget and a command alias sets custom wget path as priority. Wget is the window or doorway into a system via downloads etc so it's important that security and bug fixes are available. This way, get best of both worlds when upstream wget updates don't come quick enough or don't come at all.
     
    Last edited: Apr 5, 2021
  11. eva2000

    eva2000 Administrator Staff Member

    48,863
    11,174
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,407
    Local Time:
    3:28 PM
    Nginx 1.21.x
    MariaDB 10.x
    Update November 11, 2021

    As quite a few folks have asked about the status of Centmin Mod's support for CentOS 8, AlmaLinux 8 and Rocky Linux 8, I thought I'd update this thread. Right now, I haven't had the time to make further progress of the work as I would like. Between paid work taking up my time and my mum's medical surgery https://community.centminmod.com/threads/away-time-due-to-family-medical-circumstances.21865/, my current free time is limited. My mum's surgery has also pushed back a lot of my paid work and work in general too.

    To elaborate a bit more, making Centmin Mod compatible would be just half the work. The other half is providing timely support for any issues folks come across related to CentOS 8, AlmaLinux 8 and Rocky Linux 8 compatibility. I just wouldn't have that extra free time right now to provide such support.

    So for stability sake, Centmin Mod on CentOS 7 is still the best path right now. CentOS 7 is supported until June 30, 2024.
     
  12. eva2000

    eva2000 Administrator Staff Member

    48,863
    11,174
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,407
    Local Time:
    3:28 PM
    Nginx 1.21.x
    MariaDB 10.x
    Still alot of work and testing for AlmaLinux and Rocky Linux 8 compatibility for Centmin Mod 123.09beta01. But making progress - preview on AlmaLinux 8.5 :cool:

    Code (Text):
    cat /etc/almalinux-release
    AlmaLinux release 8.5 (Arctic Sphynx)
    
    cat /etc/redhat-release
    AlmaLinux release 8.5 (Arctic Sphynx)
    
    cat /etc/centminmod-release
    123.09beta01.b804
    
    uname -r
    4.18.0-348.20.1.el8_5.x86_64
    


    Centmin Mod Nginx with systemd service file built with GCC 10.3.1 and OpenSSL 1.1.1n
    Code (Text):
    systemctl status nginx
    ● nginx.service - Centmin Mod NGINX Server
       Loaded: loaded (/usr/lib/systemd/system/nginx.service; disabled; vendor preset: disabled)
      Drop-In: /etc/systemd/system/nginx.service.d
               └─openfileslimit.conf
       Active: active (running) since Tue 2022-03-22 16:45:32 UTC; 18min ago
      Process: 27431 ExecStop=/bin/sh -c /bin/kill -s TERM $(/bin/cat /usr/local/nginx/logs/nginx.pid) (code=exited, status=0/SUCCESS)
      Process: 27440 ExecStart=/usr/local/sbin/nginx -c /usr/local/nginx/conf/nginx.conf (code=exited, status=0/SUCCESS)
      Process: 27437 ExecStartPre=/usr/local/sbin/nginx -t (code=exited, status=0/SUCCESS)
     Main PID: 27441 (nginx)
        Tasks: 3 (limit: 50552)
       Memory: 142.7M
       CGroup: /system.slice/nginx.service
               ├─27441 nginx: master process /usr/local/sbin/nginx -c /usr/local/nginx/conf/nginx.conf
               ├─27442 nginx: worker process
               └─27443 nginx: worker process
    
    Mar 22 16:45:32 almalinux-4cpu-8gb-us-nyc1 systemd[1]: Starting Centmin Mod NGINX Server...
    Mar 22 16:45:32 almalinux-4cpu-8gb-us-nyc1 nginx[27437]: nginx: the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
    Mar 22 16:45:32 almalinux-4cpu-8gb-us-nyc1 nginx[27437]: nginx: configuration file /usr/local/nginx/conf/nginx.conf test is successful
    Mar 22 16:45:32 almalinux-4cpu-8gb-us-nyc1 systemd[1]: Started Centmin Mod NGINX Server.
    

    Nginx master process limits
    Code (Text):
    prlimit -p 27441
    RESOURCE   DESCRIPTION                             SOFT      HARD UNITS
    AS         address space limit                unlimited unlimited bytes
    CORE       max core file size                         0 unlimited bytes
    CPU        CPU time                           unlimited unlimited seconds
    DATA       max data size                      unlimited unlimited bytes
    FSIZE      max file size                      unlimited unlimited bytes
    LOCKS      max number of file locks held      unlimited unlimited locks
    MEMLOCK    max locked-in-memory address space     65536     65536 bytes
    MSGQUEUE   max bytes in POSIX mqueues            819200    819200 bytes
    NICE       max nice prio allowed to raise             0         0
    NOFILE     max number of open files             1048576   1048576 files
    NPROC      max number of processes                31595     31595 processes
    RSS        max resident set size              unlimited unlimited bytes
    RTPRIO     max real-time priority                     0         0
    RTTIME     timeout for real-time tasks        unlimited unlimited microsecs
    SIGPENDING max number of pending signals          31595     31595 signals
    STACK      max stack size                       8388608 unlimited bytes
    

    Centmin Mod PHP 7.4.28
    Code (Text):
    php -v
    PHP 7.4.28 (cli) (built: Mar 22 2022 14:07:37) ( NTS )
    Copyright (c) The PHP Group
    Zend Engine v3.4.0, Copyright (c) Zend Technologies
        with Zend OPcache v7.4.28, Copyright (c), by Zend Technologies
    

    Code (Text):
    php-config
    Usage: /usr/local/bin/php-config [OPTION]
    Options:
      --prefix            [/usr/local]
      --includes          [-I/usr/local/include/php -I/usr/local/include/php/main -I/usr/local/include/php/TSRM -I/usr/local/include/php/Zend -I/usr/local/include/php/ext -I/usr/local/include/php/ext/date/lib]
      --ldflags           [ -L/usr/local/lib64]
      --libs              [-lcrypt  -lc-client  -ltidy -largon2 -lresolv -lcrypt -lncurses -laspell -lpspell -lrt -lldap -llber -lstdc++ -lcrypt -lpam -lgmp -lbz2 -lrt -lm -ldl  -lxml2 -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lssl -lcrypto -lsqlite3 -lz -lcurl -lxml2 -lenchant -lgmodule-2.0 -lglib-2.0 -lssl -lcrypto -lz -lpng16 -lz -lwebp -ljpeg -lXpm -lX11 -lfreetype -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lssl -lcrypto -licuio -licui18n -licuuc -licudata -lonig -lsqlite3 -ledit -lxml2 -lnetsnmp -lm -lssl -lssl -lcrypto -lxml2 -lsodium -lcrypt -largon2 -lxml2 -lxml2 -lxml2 -lxml2 -lxslt -lm -lxml2 -lexslt -lxslt -lm -lgcrypt -ldl -lgpg-error -lxml2 -lzip -lz -lssl -lcrypto -lcrypt ]
      --extension-dir     [/usr/local/lib/php/extensions/no-debug-non-zts-20190902]
      --include-dir       [/usr/local/include/php]
      --man-dir           [/usr/local/php/man]
      --php-binary        [/usr/local/bin/php]
      --php-sapis         [ cli embed fpm phpdbg cgi]
      --ini-path          [/usr/local/lib]
      --ini-dir           [/etc/centminmod/php.d]
      --configure-options [--enable-fpm --enable-opcache --enable-intl --enable-pcntl --with-mcrypt --with-snmp --enable-embed=shared --with-mhash --with-zlib --with-gettext --enable-exif --with-zip --with-libzip --with-bz2 --enable-soap --enable-sockets --enable-sysvmsg --enable-sysvsem --enable-sysvshm --with-mysql-sock=/var/lib/mysql/mysql.sock --with-curl --enable-gd --with-xmlrpc --enable-bcmath --enable-calendar --enable-ftp --enable-gd-native-ttf --with-freetype --with-jpeg --with-png-dir=/usr --with-xpm --with-webp --with-t1lib=/usr --enable-shmop --with-pear --enable-mbstring --with-openssl --with-mysql=mysqlnd --with-libdir=lib64 --with-mysqli=mysqlnd --enable-pdo --with-pdo-sqlite --with-pdo-mysql=mysqlnd --enable-inline-optimization --with-imap --with-imap-ssl --with-kerberos --with-readline --with-libedit --with-gmp --with-pspell --with-tidy --with-enchant --with-fpm-user=nginx --with-fpm-group=nginx --disable-fileinfo --with-ldap --with-ldap-sasl --enable-huge-code-pages --with-password-argon2 --with-sodium=/usr/local --with-config-file-scan-dir=/etc/centminmod/php.d --with-xsl PKG_CONFIG_PATH=/opt/rh/gcc-toolset-10/root/usr/lib64/pkgconfig:/opt/rh/gcc-toolset-10/root/usr/lib64/pkgconfig ICU_CFLAGS=-I/usr/include ICU_LIBS=-L/usr/lib64 -licuio -licui18n -licuuc -licudata LIBSODIUM_CFLAGS=-I/usr/local/include LIBSODIUM_LIBS=-L/usr/local/lib64 -lsodium LIBZIP_CFLAGS=-I/usr/local/include LIBZIP_LIBS=-L/usr/local/lib64 -lzip]
      --version           [7.4.28]
      --vernum            [70428]
    

    MariaDB official 10.3.34 YUM Repo not AlmaLinux 8's included MariaDB version
    Code (Text):
    mysqladmin ver
    mysqladmin  Ver 9.1 Distrib 10.3.34-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.3.34-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 20 min 37 sec
    

    cminfo sar-cpu stats
    Code (Text):
    cminfo sar-cpu
    
    ------------------------------------------------------------------
     CPU Utilisation % Last 7 days (4 CPU Threads):
    ------------------------------------------------------------------
    %CPU  min:  %user:  0.02   %nice:  0.00  %system:  0.02   %iowait:  0.00  %steal:  0.00  %idle:  6.28
    %CPU  avg:  %user:  17.25  %nice:  0.37  %system:  9.55   %iowait:  0.22  %steal:  0.01  %idle:  72.60
    %CPU  max:  %user:  84.36  %nice:  5.47  %system:  40.60  %iowait:  7.16  %steal:  0.17  %idle:  99.96
    %CPU  50%:  %user:  14.10  %nice:  0.00  %system:  4.94   %iowait:  0.06  %steal:  0.00  %idle:  74.62
    %CPU  75%:  %user:  21.91  %nice:  0.04  %system:  13.97  %iowait:  0.20  %steal:  0.02  %idle:  99.62
    %CPU  90%:  %user:  52.66  %nice:  0.84  %system:  28.01  %iowait:  0.44  %steal:  0.04  %idle:  99.94
    %CPU  95%:  %user:  59.95  %nice:  2.70  %system:  35.49  %iowait:  0.62  %steal:  0.04  %idle:  99.95
    %CPU  99%:  %user:  70.09  %nice:  4.73  %system:  39.94  %iowait:  2.19  %steal:  0.12  %idle:  99.96
    
    ------------------------------------------------------------------
     CPU Utilisation % Daily Last 7 days (4 CPU Threads):
    ------------------------------------------------------------------
    Mar 22 2022 %CPU
    %CPU  min:  %user:  0.02   %nice:  0.00  %system:  0.02   %iowait:  0.00  %steal:  0.00  %idle:  6.28
    %CPU  avg:  %user:  17.25  %nice:  0.37  %system:  9.55   %iowait:  0.22  %steal:  0.01  %idle:  72.60
    %CPU  max:  %user:  84.36  %nice:  5.47  %system:  40.60  %iowait:  7.16  %steal:  0.17  %idle:  99.96
    %CPU  95%:  %user:  59.95  %nice:  2.70  %system:  35.49  %iowait:  0.62  %steal:  0.04  %idle:  99.95
    

    cminfo sar-mem stats
    Code (Text):
    cminfo sar-mem
    
    ------------------------------------------------------------------
     Memory Usage Daily Last 7 days (4 CPU Threads):
    ------------------------------------------------------------------
    
    Mar 22 2022 Memory
    Memory      min:                                                                                 
    kbmemfree:  2273096.0  kbmemused:  6263364.0  %memused:  624428.0   kbbuffers:  7.7        kbcached:  0.0
    kbcommit:   136856.0   %commit:    334936.0   kbactive:  4.1        kbinact:    51872.0    kbdirty:   331512.0
    Memory      avg:                                                                                 
    kbmemfree:  4761488.0  kbmemused:  6967234.5  %memused:  3363459.5  kbbuffers:  41.4       kbcached:  1574.4
    kbcommit:   2362516.0  %commit:    1442494.7  kbactive:  15.8       kbinact:    767881.5   kbdirty:   1894010.1
    Memory      max:                                                                                 
    kbmemfree:  7500552.0  kbmemused:  7465376.0  %memused:  5851884.0  kbbuffers:  72.0       kbcached:  2104.0
    kbcommit:   5163812.0  %commit:    1830136.0  kbactive:  20.0       kbinact:    1403060.0  kbdirty:   4081576.0
    Memory      95%:                                                                                 
    kbmemfree:  6353549.0  kbmemused:  7453595.0  %memused:  5830410.0  kbbuffers:  71.8       kbcached:  2104.0
    kbcommit:   4933380.0  %commit:    1791992.0  kbactive:  19.5       kbinact:    1362442.0  kbdirty:   3945898.0
    

    cminfo top stats
    Code (Text):
    cminfo top
    
    ------------------------------------------------------------------
     Centmin Mod Top Info:
    ------------------------------------------------------------------
     Server Location Info
    
      city: New York City
      region: New York
      country: US
      org: AS25697 UpCloud USA Inc
      timezone: America/New_York
      ASN: AS25697 UpCloud USA Inc
    
     Processors physical = 4, cores = 4, virtual = 4, hyperthreading = no
    
          4  2894.562
          4  AMD EPYC 7542 32-Core Processor
          4  512 KB
    
     System Uptime:         up 1:37, 1 user,
     MySQL Server Started   2022-03-22 15:29:25
     MySQL Uptime:          1 hour 37 min 45 sec
     MySQL Uptime (secs):   5865
     Server Type:           kvm
     CentOS Version:        8.5
     Centmin Mod:           123.09beta01.b804
     Nginx PageSpeed:       OFF
     Nginx Version:         1.21.6 (220322-162310--kvm-9b3cdca)
     PHP-FPM Version:       7.4.28
     MariaDB Version:       10.3.34
     CSF Firewall:          v14.16
     Memcached Server:      1.6.5
     NSD Version:            -
     Siege Version:         4.0.4
     Maldet Version:        not installed
     ClamAV Version:        not installed
     ElasticSearch:         not installed
    
    ------------------------------------------------------------------
    free -mtl
                  total        used        free      shared  buff/cache   available
    Mem:           7933        1501        4679           8        1752        6160
    Low:           7933        3254        4679
    High:             0           0           0
    Swap:          1023           0        1023
    Total:         8957        1501        5703
    
    ------------------------------------------------------------------
    top 10 processes using swap (VmSwap)
    
    
    ------------------------------------------------------------------
    top 10 processes' virtual memory size (VmSize/VSZ)
    RSS vs VSZ https://stackoverflow.com/a/21049737/272648
    RSS https://en.wikipedia.org/wiki/Resident_set_size
    
          1242 mysqld                                   2198964 kB
           685 polkitd                                  1763504 kB
           801 tuned                                     781236 kB
           790 NetworkManager                            600288 kB
         41291 php-fpm                                   567896 kB
          1595 memcached                                 455448 kB
           757 sssd_nss                                  436972 kB
           714 sssd_be                                   435408 kB
           686 sssd                                      426856 kB
          3886 lfd - sleeping                            309268 kB
    
    ------------------------------------------------------------------
    smem process memory info (sorted by RSS)
    PSS https://en.wikipedia.org/wiki/Proportional_set_size
    USS https://en.wikipedia.org/wiki/Unique_set_size
    
      PID User     Command                         Swap      USS      PSS      RSS
     1242 mysql    /usr/sbin/mysqld                   0   166844   167723   173612
    27442 nginx    nginx: worker process              0    55472    64776    85956
    27443 nginx    nginx: worker process              0    54940    64248    85432
      757 root     /usr/libexec/sssd/sssd_nss         0    28568    30666    41116
    27441 root     nginx: master process /usr/        0    10412    18979    36980
     3886 root     lfd - sleeping                     0    30192    30406    33440
      801 root     /usr/libexec/platform-pytho        0    18936    21870    32392
      685 polkitd  /usr/lib/polkit-1/polkitd -        0    15956    17820    25632
    41291 root     php-fpm: master process (/u        0    13956    14771    19996
      790 root     /usr/sbin/NetworkManager --        0     7156     9412    19920
      714 root     /usr/libexec/sssd/sssd_be -        0     3348     5245    15536
      686 root     /usr/sbin/sssd -i --logger=        0     2912     4672    14736
    28074 root     /usr/libexec/platform-pytho        0     7876     9577    14412
        1 root     /usr/lib/systemd/systemd --        0     1880     3778    11036
     1648 root     sshd: root [priv]                  0     1340     2895    10440
      585 root     /usr/lib/systemd/systemd-jo        0     2616     3918    10132
      667 root     /usr/lib/systemd/systemd-ud        0     3252     3930     9776
     1652 root     /usr/lib/systemd/systemd --        0     1280     2706     9408
     1575 root     /usr/sbin/rsyslogd -n              0     3892     4989     9276
      767 root     /usr/lib/systemd/systemd-lo        0     1160     1837     7676
      349 root     @usr/sbin/haveged -w 1024 -        0     7608     7608     7612
      798 root     /usr/sbin/sshd -D -oCiphers        0      944     1620     7540
     1660 root     sshd: root@pts/0                   0      548     1767     6516
      734 rngd     /usr/sbin/rngd -f --fill-wa        0     1108     1733     6288
      695 dbus     /usr/bin/dbus-daemon --syst        0     1160     1729     5868
      687 root     /usr/sbin/irqbalance --fore        0      780     1317     5600
     1595 memcached /usr/local/bin/memcached -d        0     3652     3711     5280
      705 chrony   /usr/sbin/chronyd                  0     1212     1631     5236
     3462 root     /usr/sbin/pure-ftpd /etc/pu        0     1792     2085     4884
     1662 root     -bash                              0     1236     1710     4544
     1654 root     (sd-pam)                           0     1624     2282     4228
    27641 root     /bin/bash /usr/bin/cminfo t        0      260     1080     3908
      807 root     /usr/sbin/crond -n                 0      952     1122     3736
    27674 root     /bin/bash /usr/bin/cminfo t        0      416     1078     2940
      642 root     /sbin/auditd                       0      888      983     2768
     1576 root     /sbin/agetty -o -p -- \u --        0      312      408     2120
    27675 root     tee /root/centminlogs/cminf        0      140      238     1780
    -------------------------------------------------------------------------------
       37 8                                           0   456620   516320   747752
    
    ------------------------------------------------------------------
    df -hT
    Filesystem     Type      Size  Used Avail Use% Mounted on
    devtmpfs       devtmpfs  3.9G     0  3.9G   0% /dev
    tmpfs          tmpfs     3.9G     0  3.9G   0% /dev/shm
    tmpfs          tmpfs     3.9G  8.5M  3.9G   1% /run
    tmpfs          tmpfs     3.9G     0  3.9G   0% /sys/fs/cgroup
    /dev/vda2      xfs       160G  7.8G  153G   5% /
    tmpfs          tmpfs     3.9G     0  3.9G   0% /tmp
    tmpfs          tmpfs     794M     0  794M   0% /run/user/0
    
    ------------------------------------------------------------------
    php-fpm stats
    
    ------------------------------------------------------------------
    Total PHP-FPM Master Processes: 1
    PHP-FPM Pool Names:
    ------------------------------------------------------------------
    41291 php-fpm: master /usr/local/etc/php-fpm.conf
    ------------------------------------------------------------------
    awk: cmd. line:1: (FILENAME=- FNR=1) fatal: division by zero attempted
    uss = user set size
    pss = process set size
    rss = resident set size
    
    pool:                 www
    process manager:      ondemand
    start time:           22/Mar/2022:16:08:26 +0000
    start since:          3526
    accepted conn:        1
    listen queue:         0
    max listen queue:     0
    listen queue len:     65535
    idle processes:       0
    active processes:     1
    total processes:      1
    max active processes: 1
    max children reached: 0
    slow requests:        0
    
    ------------------------------------------------------------------
    Filter sar -q for times cpu load avg (1min) hit/exceeded cpu threads max
    
    12:34:48     LINUX RESTART      (4 CPU)
    12:53:34 PM         0       167      4.54      3.03      1.63         0
    12:53:46 PM         1       167      4.07      2.98      1.63         0
    02:08:03 PM         0       184      4.76      2.55      1.21         0
    
    ------------------------------------------------------------------
    Filter sar -q for times cpu load avg (5min) hit/exceeded cpu threads max
    
    12:44:19 PM  LINUX RESTART      (4 CPU)
    12:45:05 PM  LINUX RESTART      (4 CPU)
    01:00:45 PM  LINUX RESTART      (4 CPU)
    01:00:54 PM  LINUX RESTART      (4 CPU)
    01:02:57 PM  LINUX RESTART      (4 CPU)
    01:41:08 PM  LINUX RESTART      (4 CPU)
    01:41:09 PM  LINUX RESTART      (4 CPU)
    01:50:45 PM  LINUX RESTART      (4 CPU)
    01:50:47 PM  LINUX RESTART      (4 CPU)
    01:51:07 PM  LINUX RESTART      (4 CPU)
    01:55:28 PM  LINUX RESTART      (4 CPU)
    01:55:30 PM  LINUX RESTART      (4 CPU)
    01:57:57 PM  LINUX RESTART      (4 CPU)
    01:57:59 PM  LINUX RESTART      (4 CPU)
    02:03:41 PM  LINUX RESTART      (4 CPU)
    02:03:43 PM  LINUX RESTART      (4 CPU)
    02:10:05 PM  LINUX RESTART      (4 CPU)
    02:13:24 PM  LINUX RESTART      (4 CPU)
    02:22:41 PM  LINUX RESTART      (4 CPU)
    02:22:58 PM  LINUX RESTART      (4 CPU)
    02:35:23 PM  LINUX RESTART      (4 CPU)
    02:38:57 PM  LINUX RESTART      (4 CPU)
    03:29:24 PM  LINUX RESTART      (4 CPU)
    04:01:14 PM  LINUX RESTART      (4 CPU)
    04:01:30 PM  LINUX RESTART      (4 CPU)
    04:05:38 PM  LINUX RESTART      (4 CPU)
    04:05:40 PM  LINUX RESTART      (4 CPU)
    04:15:12 PM  LINUX RESTART      (4 CPU)
    04:15:14 PM  LINUX RESTART      (4 CPU)
    04:19:32 PM  LINUX RESTART      (4 CPU)
    04:19:34 PM  LINUX RESTART      (4 CPU)
    04:22:26 PM  LINUX RESTART      (4 CPU)
    04:22:32 PM  LINUX RESTART      (4 CPU)
    
    ------------------------------------------------------------------
    sar -q | sed -e "s|$(hostname)|hostname|g"
    Linux 4.18.0-305.19.1.el8_4.x86_64 (hostname)   03/22/2022      _x86_64_        (4 CPU)
    
    12:34:48     LINUX RESTART      (4 CPU)
    
    12:35:10 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    12:37:17 PM         2       147      0.86      0.35      0.12         0
    12:37:20 PM         1       148      1.03      0.39      0.14         0
    12:37:24 PM         1       155      1.19      0.44      0.15         0
    12:37:26 PM         2       157      1.19      0.44      0.15         0
    12:37:31 PM         2       158      1.33      0.48      0.17         0
    12:37:54 PM         1       158      2.94      0.94      0.33         0
    12:37:55 PM         2       159      2.94      0.94      0.33         0
    12:38:22 PM         1       157      2.77      1.06      0.39         0
    12:38:29 PM         1       158      3.01      1.17      0.43         0
    12:38:30 PM         1       157      3.01      1.17      0.43         0
    12:38:36 PM         1       151      2.93      1.18      0.44         0
    12:40:01 PM         1       152      0.71      0.89      0.40         0
    Average:            1       155      1.99      0.79      0.29         0
    
    12:44:19 PM  LINUX RESTART      (4 CPU)
    
    12:44:20 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    12:44:21 PM         0       138      0.16      0.40      0.30         0
    12:44:22 PM         0       138      0.16      0.40      0.30         0
    12:44:23 PM         0       138      0.16      0.40      0.30         0
    12:45:00 PM         1       147      0.41      0.43      0.31         0
    Average:            0       140      0.22      0.41      0.30         0
    
    12:45:05 PM  LINUX RESTART      (4 CPU)
    
    12:45:10 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    12:45:11 PM         0       143      0.42      0.43      0.32         0
    12:46:52 PM         0       150      2.89      1.45      0.70         0
    12:48:12 PM         0       148      2.91      1.94      0.95         0
    12:49:42 PM         1       181      1.20      1.61      0.92         0
    12:49:43 PM         0       177      1.20      1.61      0.92         0
    12:49:44 PM         0       177      1.18      1.60      0.92         0
    12:50:12 PM         9       201      2.02      1.76      1.00         0
    12:51:22 PM         0       167      1.57      1.72      1.04         0
    12:53:34 PM         0       167      4.54      3.03      1.63         0
    12:53:46 PM         1       167      4.07      2.98      1.63         0
    12:54:36 PM         2       177      2.61      2.74      1.62         0
    12:54:38 PM         1       179      2.61      2.74      1.62         0
    12:55:11 PM         5       177      1.90      2.54      1.60         0
    12:55:24 PM         2       182      1.70      2.47      1.59         0
    12:55:26 PM         0       178      1.70      2.47      1.59         0
    12:55:27 PM         0       178      1.70      2.47      1.59         0
    12:55:44 PM         0       177      1.43      2.35      1.57         0
    12:55:45 PM         0       177      1.43      2.35      1.57         0
    12:55:47 PM         0       177      1.43      2.35      1.57         0
    12:55:50 PM         0       177      1.40      2.33      1.56         0
    12:56:28 PM         4       185      1.20      2.19      1.55         0
    12:56:35 PM         1       178      1.78      2.29      1.58         0
    01:00:01 PM         2       180      0.21      1.19      1.27         0
    Average:            1       174      1.87      2.11      1.32         0
    
    01:00:45 PM  LINUX RESTART      (4 CPU)
    
    01:00:54 PM  LINUX RESTART      (4 CPU)
    
    01:01:18 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    01:02:42 PM         0       183      3.87      2.24      1.64         0
    01:02:45 PM         0       183      3.56      2.20      1.63         0
    Average:            0       183      3.71      2.22      1.64         0
    
    01:02:57 PM  LINUX RESTART      (4 CPU)
    
    01:05:12 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    01:10:01 PM         0       171      0.00      0.50      1.01         0
    01:15:00 PM         0       172      0.00      0.18      0.72         0
    01:20:01 PM         0       171      0.00      0.06      0.51         0
    01:25:01 PM         0       175      0.00      0.01      0.35         0
    01:30:01 PM         0       171      0.00      0.00      0.25         0
    01:35:00 PM         0       173      0.00      0.00      0.16         0
    01:40:01 PM         0       174      0.08      0.02      0.11         0
    Average:            0       172      0.01      0.11      0.44         0
    
    01:41:08 PM  LINUX RESTART      (4 CPU)
    
    01:41:09 PM  LINUX RESTART      (4 CPU)
    
    01:41:29 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    01:43:05 PM         1       179      3.23      1.43      0.62         0
    01:43:08 PM         1       179      3.23      1.43      0.62         0
    01:45:01 PM         0       178      0.47      0.97      0.54         0
    01:50:01 PM         0       173      0.00      0.34      0.38         0
    Average:            0       177      1.73      1.04      0.54         0
    
    01:50:45 PM  LINUX RESTART      (4 CPU)
    
    01:50:47 PM  LINUX RESTART      (4 CPU)
    
    01:50:51 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    01:50:58 PM         0       182      0.32      0.37      0.38         0
    01:51:02 PM         0       182      0.69      0.44      0.41         0
    Average:            0       182      0.51      0.41      0.40         0
    
    01:51:07 PM  LINUX RESTART      (4 CPU)
    
    01:55:28 PM  LINUX RESTART      (4 CPU)
    
    01:55:30 PM  LINUX RESTART      (4 CPU)
    
    01:56:17 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    01:56:19 PM         0       180      0.24      0.39      0.41         0
    Average:            0       180      0.24      0.39      0.41         0
    
    01:57:57 PM  LINUX RESTART      (4 CPU)
    
    01:57:59 PM  LINUX RESTART      (4 CPU)
    
    01:58:15 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    01:58:16 PM         1       190      0.18      0.30      0.37         0
    02:00:01 PM         0       209      0.03      0.21      0.33         0
    Average:            0       200      0.10      0.26      0.35         0
    
    02:03:41 PM  LINUX RESTART      (4 CPU)
    
    02:03:43 PM  LINUX RESTART      (4 CPU)
    
    02:03:59 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    02:04:01 PM         1       177      0.45      0.20      0.28         0
    02:05:12 PM         1       187      2.18      0.85      0.51         0
    02:05:44 PM         0       184      1.77      0.88      0.53         0
    02:08:03 PM         0       184      4.76      2.55      1.21         0
    02:08:16 PM         0       184      3.78      2.44      1.20         0
    02:08:18 PM         0       184      3.78      2.44      1.20         0
    02:08:21 PM         0       184      3.64      2.43      1.20         0
    02:08:22 PM         0       184      3.64      2.43      1.20         0
    02:08:25 PM         1       184      3.43      2.41      1.20         0
    02:08:33 PM         0       184      3.23      2.38      1.20         0
    02:08:34 PM         1       184      3.23      2.38      1.20         0
    02:08:52 PM         0       184      2.52      2.28      1.19         0
    02:10:00 PM         2       178      0.86      1.81      1.10         0
    Average:            0       183      2.87      1.96      1.02         0
    
    02:10:05 PM  LINUX RESTART      (4 CPU)
    
    02:13:24 PM  LINUX RESTART      (4 CPU)
    
    02:15:01 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    02:20:01 PM         0       173      0.00      0.24      0.56         0
    Average:            0       173      0.00      0.24      0.56         0
    
    02:22:41 PM  LINUX RESTART      (4 CPU)
    
    02:22:58 PM  LINUX RESTART      (4 CPU)
    
    02:25:01 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    02:30:01 PM         1       168      0.04      0.05      0.29         0
    02:35:12 PM         0       168      0.00      0.02      0.20         0
    Average:            0       168      0.02      0.04      0.24         0
    
    02:35:23 PM  LINUX RESTART      (4 CPU)
    
    02:38:57 PM  LINUX RESTART      (4 CPU)
    
    02:40:01 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    02:45:09 PM         1       169      0.00      0.00      0.08         0
    02:50:01 PM         0       173      0.01      0.01      0.07         0
    02:55:01 PM         0       170      0.00      0.00      0.04         0
    03:00:01 PM         0       171      0.00      0.00      0.01         0
    03:05:12 PM         0       170      0.01      0.00      0.00         0
    03:10:01 PM         0       197      0.68      0.63      0.28         0
    03:15:12 PM         0       171      0.00      0.21      0.19         0
    03:20:01 PM         0       169      0.00      0.07      0.13         0
    03:25:12 PM         0       171      0.00      0.02      0.08         0
    Average:            0       173      0.08      0.10      0.10         0
    
    03:29:24 PM  LINUX RESTART      (4 CPU)
    
    03:30:26 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    03:35:01 PM         0       168      0.00      0.01      0.00         0
    03:40:18 PM         0       166      0.00      0.00      0.00         0
    03:45:18 PM         0       169      0.00      0.00      0.00         0
    03:50:21 PM         2       172      0.02      0.01      0.00         0
    03:55:18 PM         0       167      0.01      0.03      0.00         0
    04:00:01 PM         2       168      0.00      0.00      0.00         0
    Average:            1       168      0.01      0.01      0.00         0
    
    04:01:14 PM  LINUX RESTART      (4 CPU)
    
    04:01:30 PM  LINUX RESTART      (4 CPU)
    
    04:02:25 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    04:03:23 PM         0       173      2.28      0.86      0.31         0
    04:03:26 PM         0       173      2.28      0.86      0.31         0
    04:05:11 PM         1       170      0.41      0.61      0.28         0
    Average:            0       172      1.66      0.78      0.30         0
    
    04:05:38 PM  LINUX RESTART      (4 CPU)
    
    04:05:40 PM  LINUX RESTART      (4 CPU)
    
    04:06:03 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    04:06:52 PM         0       169      1.41      0.86      0.40         0
    04:06:55 PM         0       169      1.41      0.86      0.40         0
    04:10:18 PM         0       167      0.04      0.43      0.31         0
    04:15:08 PM         5       169      0.00      0.15      0.22         0
    Average:            1       168      0.71      0.57      0.33         0
    
    04:15:12 PM  LINUX RESTART      (4 CPU)
    
    04:15:14 PM  LINUX RESTART      (4 CPU)
    
    04:15:31 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    04:16:18 PM         1       172      1.20      0.50      0.33         0
    04:16:21 PM         0       172      1.20      0.50      0.33         0
    Average:            0       172      1.20      0.50      0.33         0
    
    04:19:32 PM  LINUX RESTART      (4 CPU)
    
    04:19:34 PM  LINUX RESTART      (4 CPU)
    
    04:19:53 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    04:20:30 PM         4       182      1.46      0.64      0.40         0
    04:20:41 PM         0       173      1.39      0.65      0.40         0
    04:20:45 PM         0       173      1.28      0.64      0.40         0
    Average:            1       176      1.38      0.64      0.40         0
    
    04:22:26 PM  LINUX RESTART      (4 CPU)
    
    04:22:32 PM  LINUX RESTART      (4 CPU)
    
    04:23:18 PM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
    04:24:20 PM         0       174      2.62      1.35      0.70         0
    04:24:23 PM         0       174      2.41      1.33      0.69         0
    04:25:11 PM         1       173      1.13      1.14      0.66         0
    04:30:24 PM         6       166      0.00      0.39      0.45         0
    04:35:18 PM         0       167      0.00      0.13      0.32         0
    04:40:10 PM         0       168      0.00      0.05      0.23         0
    04:45:18 PM         0       168      0.00      0.01      0.15         0
    04:50:24 PM         0       170      0.00      0.00      0.10         0
    04:55:01 PM         1       170      0.00      0.00      0.07         0
    05:00:18 PM         0       166      0.00      0.00      0.04         0
    05:05:02 PM         1       168      0.00      0.00      0.02         0
    Average:            1       169      0.56      0.40      0.31         0
    
    ------------------------------------------------------------------
    sar -r | sed -e "s|$(hostname)|hostname|g"
    Linux 4.18.0-305.19.1.el8_4.x86_64 (hostname)   03/22/2022      _x86_64_        (4 CPU)
    
    12:34:48     LINUX RESTART      (4 CPU)
    
    12:35:10 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    12:37:17 PM   6045476   7465376   2079504     25.59      2104   1589480    334936      4.12    269828   1464944    647992
    12:37:20 PM   6044764   7464344   2080216     25.60      2104   1589508    347452      4.28    290768   1446984    647880
    12:37:24 PM   6032028   7451572   2092952     25.76      2104   1589772    365324      4.50    299432   1438960      2832
    12:37:26 PM   6031796   7453372   2093184     25.76      2104   1591732    351572      4.33    301772   1439576      4768
    12:37:31 PM   6014720   7453484   2110260     25.97      2104   1608484    364456      4.49    351168   1407416     18320
    12:37:54 PM   5984556   7454264   2140424     26.34      2104   1639132    362072      4.46    368676   1420588     38452
    12:37:55 PM   5968056   7453632   2156924     26.55      2104   1654924    371420      4.57    374540   1430504     46920
    12:38:22 PM   5911192   7432328   2213788     27.25      2104   1688424    373444      4.60    402028   1456128     50832
    12:38:29 PM   5894856   7431304   2230124     27.45      2104   1703252    393320      4.84    417664   1456160     16324
    12:38:30 PM   5888916   7430988   2236064     27.52      2104   1709000    394212      4.85    421796   1457516     19680
    12:38:36 PM   5858800   7460032   2266180     27.89      2104   1767920    343412      4.23    430656   1479052     54524
    12:40:01 PM   5829228   7430684   2295752     28.26      2104   1768068    371988      4.58    431332   1508316         0
    Average:      5958699   7448448   2166281     26.66      2104   1658308    364467      4.49    363305   1450512    129044
    
    12:44:19 PM  LINUX RESTART      (4 CPU)
    
    12:44:20 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    12:44:21 PM   4751132   7425300   3373848     41.52      2104   2839520    432464      4.71    434292   2578904     24396
    12:44:22 PM   4751264   7425468   3373716     41.52      2104   2839556    428112      4.67    434356   2578976     24400
    12:44:23 PM   4750984   7425212   3373996     41.53      2104   2839568    428112      4.67    434392   2579012     24412
    12:45:00 PM   4667156   7353268   3457824     42.56      2104   2851216    592156      6.46    437908   2655316     80212
    Average:      4730134   7407312   3394846     41.78      2104   2842465    470211      5.13    435237   2598052     38355
    
    12:45:05 PM  LINUX RESTART      (4 CPU)
    
    12:45:10 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    12:45:11 PM   4682776   7420972   3442204     42.37      2104   2902860    454492      4.95    444856   2635092    104196
    12:46:52 PM   2276120   7313936   5848860     71.99      2104   5163812    465184      5.07   1403060   3940084    327324
    12:48:12 PM   3376604   7311420   4748376     58.44      2104   4063996    474512      5.17    825920   3417500     14444
    12:49:42 PM   2871632   7177304   5253348     64.66      2104   4429656   1644856     17.93    839436   3892768     65116
    12:49:43 PM   2883396   7185964   5241584     64.51      2104   4426372   1635556     17.83    846164   3875824     61816
    12:49:44 PM   2883656   7186212   5241324     64.51      2104   4426376   1630384     17.77    846180   3875836     61820
    12:50:12 PM   2772968   7165252   5352012     65.87      2104   4510388   1659852     18.09    869544   3947836     87712
    12:51:22 PM   2762948   7176600   5362032     65.99      2104   4528624   1650796     18.00    904108   3922280      1772
    12:53:34 PM   2608096   7156784   5516884     67.90      2104   4653832   1648744     17.97   1005344   3961880     75572
    12:53:46 PM   2534092   7155784   5590888     68.81      2104   4725808   1638964     17.87   1030392   4008456    102768
    12:54:36 PM   2413488   7129680   5711492     70.30      2104   4820504   1778824     19.39   1071512   4081576     25564
    12:54:38 PM   2437496   7153184   5687484     70.00      2104   4819480   1748244     19.06   1077812   4050592     23868
    12:55:11 PM   2321480   7130536   5803500     71.43      2104   4911116   1760892     19.20   1353668   3888380     38052
    12:55:24 PM   2314496   7124828   5810484     71.51      2104   4912324   1830136     19.95   1355300   3890504       664
    12:55:26 PM   2317148   7128128   5807832     71.48      2104   4912888   1792072     19.54   1355772   3887568      1240
    12:55:27 PM   2316312   7128088   5808668     71.49      2104   4913556   1791752     19.53   1356852   3887396      1908
    12:55:44 PM   2295176   7126736   5829804     71.75      2104   4931952   1754728     19.13   1360972   3902196     21660
    12:55:45 PM   2294368   7127880   5830612     71.76      2104   4933856   1767924     19.27   1362932   3902036     23236
    12:55:47 PM   2292816   7127472   5832164     71.78      2104   4934856   1761040     19.20   1364316   3901400     24240
    12:55:50 PM   2289200   7126372   5835780     71.83      2104   4936976   1758436     19.17   1365124   3902900     26352
    12:56:28 PM   2273096   7128984   5851884     72.02      2104   4953956   1790904     19.52   1378108   3899244     23712
    12:56:35 PM   7500552   7446356    624428      7.69         0    136856   1720584     18.76     83596    331512        12
    01:00:01 PM   7288784   7370832    836196     10.29         0    292504   1744272     19.01    129344    489344      1312
    Average:      3043770   7195622   5081210     62.54      1921   4271415   1561006     17.02   1027405   3543139     48450
    
    01:00:45 PM  LINUX RESTART      (4 CPU)
    
    01:00:54 PM  LINUX RESTART      (4 CPU)
    
    01:01:18 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    01:02:42 PM   6325664   7285816   1799316     22.15      1044   1144372   1777228     19.37    629788    847216     29072
    01:02:45 PM   6302468   7285152   1822512     22.43      1044   1166732   1774992     19.35    630616    869104     24440
    Average:      6314066   7285484   1810914     22.29      1044   1155552   1776110     19.36    630202    858160     26756
    
    01:02:57 PM  LINUX RESTART      (4 CPU)
    
    01:05:12 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    01:10:01 PM   6321220   7309316   1803760     22.20      1044   1172172   1716740     18.71    658872    823412         0
    01:15:00 PM   6321404   7309572   1803576     22.20      1044   1172248   1705700     18.59    659408    823276        12
    01:20:01 PM   6321712   7309980   1803268     22.19      1044   1172344   1708544     18.62    659416    823232         4
    01:25:01 PM   6321536   7309816   1803444     22.20      1044   1172356   1715216     18.70    660852    821792        12
    01:30:01 PM   6321504   7309764   1803476     22.20      1044   1172380   1716740     18.71    660860    821904        12
    01:35:00 PM   6315504   7309292   1809476     22.27      1044   1177920   1715484     18.70    660716    827508        16
    01:40:01 PM   6313724   7307320   1811256     22.29      1044   1177728   1718272     18.73    660760    829656         4
    Average:      6319515   7309294   1805465     22.22      1044   1173878   1713814     18.68    660126    824397         9
    
    01:41:08 PM  LINUX RESTART      (4 CPU)
    
    01:41:09 PM  LINUX RESTART      (4 CPU)
    
    01:41:29 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    01:43:05 PM   6174896   7265168   1950084     24.00      1044   1270876   1780824     19.41    709044    905608     14596
    01:43:08 PM   6182916   7264940   1942064     23.90      1044   1262464   1773988     19.34    710288    895940      9628
    01:45:01 PM   6211444   7294152   1913536     23.55      1044   1263140   1711948     18.66    712188    866708         0
    01:50:01 PM   6211244   7293996   1913736     23.55      1044   1263168   1719352     18.74    726844    852104         0
    Average:      6195125   7279564   1929855     23.75      1044   1264912   1746528     19.04    714591    880090      6056
    
    01:50:45 PM  LINUX RESTART      (4 CPU)
    
    01:50:47 PM  LINUX RESTART      (4 CPU)
    
    01:50:51 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    01:50:58 PM   6138268   7260372   1986712     24.45      1044   1302168   1786524     19.47    750036    899680      6288
    01:51:02 PM   6129220   7260184   1995760     24.56      1044   1310968   1783752     19.44    757272    901080     13520
    Average:      6133744   7260278   1991236     24.51      1044   1306568   1785138     19.46    753654    900380      9904
    
    01:51:07 PM  LINUX RESTART      (4 CPU)
    
    01:55:28 PM  LINUX RESTART      (4 CPU)
    
    01:55:30 PM  LINUX RESTART      (4 CPU)
    
    01:56:17 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    01:56:19 PM   5778784   7205460   2346196     28.88      1044   1589740   1780520     19.41    814452   1124576    184136
    Average:      5778784   7205460   2346196     28.88      1044   1589740   1780520     19.41    814452   1124576    184136
    
    01:57:57 PM  LINUX RESTART      (4 CPU)
    
    01:57:59 PM  LINUX RESTART      (4 CPU)
    
    01:58:15 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    01:58:16 PM   5774536   7204644   2350444     28.93      1044   1592652   1780784     19.41    826852   1114956    174208
    02:00:01 PM   5797580   7228164   2327400     28.64      1044   1593148   1714576     18.69    827916   1081200         4
    Average:      5786058   7216404   2338922     28.79      1044   1592900   1747680     19.05    827384   1098078     87106
    
    02:03:41 PM  LINUX RESTART      (4 CPU)
    
    02:03:43 PM  LINUX RESTART      (4 CPU)
    
    02:03:59 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    02:04:01 PM   5771552   7202472   2353428     28.97      1044   1593564   1778884     19.39    828320   1118404    174216
    02:05:12 PM   4724200   6265816   3400780     41.86      1044   1705728   1801728     19.64    861348   1211836     11052
    02:05:44 PM   4733952   6279464   3391028     41.74      1044   1709472   1774608     19.34    866116   1196800      1384
    02:08:03 PM   4598564   6269636   3526416     43.40      1044   1829632   1783680     19.44    963644   1219776     72020
    02:08:16 PM   4510708   6269380   3614272     44.48      1044   1917308   1780916     19.41    980604   1289964     93588
    02:08:18 PM   4504712   6268660   3620268     44.56      1044   1922296   1781516     19.42    980616   1295236     93032
    02:08:21 PM   4497296   6264064   3627684     44.65      1044   1924452   1786452     19.47    981324   1296852     91668
    02:08:22 PM   4497720   6264896   3627260     44.64      1044   1924588   1781160     19.42    982548   1296184     91872
    02:08:25 PM   4497908   6265040   3627072     44.64      1044   1924760   1780916     19.41    982600   1295640     93480
    02:08:33 PM   4503656   6264728   3621324     44.57      1044   1918684   1780484     19.41    978916   1293716     70948
    02:08:34 PM   4501332   6264548   3623648     44.60      1044   1920800   1782836     19.43    980316   1294112     73096
    02:08:52 PM   4785236   6271648   3339744     41.10      1044   1642992   1748600     19.06    876452   1118352     29008
    02:10:00 PM   4805264   6281632   3319716     40.86      1044   1642668   1745976     19.03    876560   1140504       680
    Average:      4687085   6340922   3437895     42.31      1044   1813611   1777520     19.38    933797   1235952     68926
    
    02:10:05 PM  LINUX RESTART      (4 CPU)
    
    02:13:24 PM  LINUX RESTART      (4 CPU)
    
    02:15:01 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    02:20:01 PM   4871760   6349156   3253220     40.04      1044   1643744   1674248     18.25    877228   1074768        12
    Average:      4871760   6349156   3253220     40.04      1044   1643744   1674248     18.25    877228   1074768        12
    
    02:22:41 PM  LINUX RESTART      (4 CPU)
    
    02:22:58 PM  LINUX RESTART      (4 CPU)
    
    02:25:01 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    02:30:01 PM   4871436   6349480   3253544     40.04      1044   1644412   1676004     18.27    878452   1074000         8
    02:35:12 PM   4871744   6349828   3253236     40.04      1044   1644452   1675424     18.26    878288   1074164         0
    Average:      4871590   6349654   3253390     40.04      1044   1644432   1675714     18.27    878370   1074082         4
    
    02:35:23 PM  LINUX RESTART      (4 CPU)
    
    02:38:57 PM  LINUX RESTART      (4 CPU)
    
    02:40:01 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    02:45:09 PM   4666224   6263696   3458756     42.57      1044   1763892   1785804     19.47    878636   1277948      2676
    02:50:01 PM   4550288   6263896   3574692     44.00      1044   1879988   1784544     19.45    878768   1393900      5688
    02:55:01 PM   4507640   6263364   3617340     44.52      1044   1922152   1785804     19.47    878768   1436004       956
    03:00:01 PM   4466036   6263404   3658944     45.03      1044   1963804   1795188     19.57    878768   1477668      3596
    03:05:12 PM   4424620   6263708   3700360     45.54      1044   2005500   1800736     19.63    878772   1519400      1964
    03:10:01 PM   3616612   6294268   4508368     55.49      2104   2820708   1704400     18.58   1047664   2081992         8
    03:15:12 PM   3617640   6295528   4507340     55.48      2104   2820732   1691120     18.43   1047904   2081776        24
    03:20:01 PM   3617184   6295080   4507796     55.48      2104   2820748   1699156     18.52   1047948   2081776         4
    03:25:12 PM   3617496   6295396   4507484     55.48      2104   2820756   1699152     18.52   1047972   2081564         4
    Average:      4120416   6277593   4004564     49.29      1515   2313142   1749545     19.07    953911   1714670      1658
    
    03:29:24 PM  LINUX RESTART      (4 CPU)
    
    03:30:26 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    03:35:01 PM   6394584   6457900   1729696     21.29      2104    274048   1624088     17.71     51872    591716        28
    03:40:18 PM   6387544   6450900   1736736     21.38      2104    274072   1627940     17.75     52736    596460        12
    03:45:18 PM   6362844   6426424   1761436     21.68      2104    274104   1627936     17.75     53260    618860        16
    03:50:21 PM   6016964   6345116   2107316     25.94      2104    537640   1756464     19.15     74312    935992      1560
    03:55:18 PM   6106192   6526032   2018088     24.84      2104    611472   1585680     17.29    269460    595620         4
    04:00:01 PM   6104960   6524956   2019320     24.86      2104    611624   1590720     17.34    269716    596104         8
    Average:      6228848   6455221   1895432     23.33      2104    430493   1635471     17.83    128559    655792       271
    
    04:01:14 PM  LINUX RESTART      (4 CPU)
    
    04:01:30 PM  LINUX RESTART      (4 CPU)
    
    04:02:25 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    04:03:23 PM   5065316   6438036   3058964     37.65      2104   1550488   1659844     18.10    676584   1161472     20260
    04:03:26 PM   5062388   6437476   3061892     37.69      2104   1552652   1654132     18.03    679596   1160664     22804
    04:05:11 PM   5084528   6467296   3039752     37.42      2104   1560256   1615888     17.62    702528   1116464         8
    Average:      5070744   6447603   3053536     37.59      2104   1554465   1643288     17.91    686236   1146200     14357
    
    04:05:38 PM  LINUX RESTART      (4 CPU)
    
    04:05:40 PM  LINUX RESTART      (4 CPU)
    
    04:06:03 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    04:06:52 PM   5042588   6436012   3081692     37.93      2104   1570184   1662700     18.13    727908   1129948     38652
    04:06:55 PM   5044340   6435480   3079940     37.91      2104   1567808   1654120     18.03    729576   1126064     22104
    04:10:18 PM   5072316   6470928   3051964     37.57      2104   1575304   1590932     17.34    740144   1088732         0
    04:15:08 PM   5038724   6437348   3085556     37.98      2104   1575316   1623968     17.70    740284   1119484       240
    Average:      5049492   6444942   3074788     37.85      2104   1572153   1632930     17.80    734478   1116057     15249
    
    04:15:12 PM  LINUX RESTART      (4 CPU)
    
    04:15:14 PM  LINUX RESTART      (4 CPU)
    
    04:15:31 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    04:16:18 PM   5030532   6431828   3093748     38.08      2104   1578016   1666180     18.16    747228   1118408     13596
    04:16:21 PM   5038840   6431528   3085440     37.98      2104   1569420   1654756     18.04    744268   1112740      9632
    Average:      5034686   6431678   3089594     38.03      2104   1573718   1660468     18.10    745748   1115574     11614
    
    04:19:32 PM  LINUX RESTART      (4 CPU)
    
    04:19:34 PM  LINUX RESTART      (4 CPU)
    
    04:19:53 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    04:20:30 PM   4960364   6349760   3163916     38.94      2104   1588680   1767896     19.27    760980   1175588    404412
    04:20:41 PM   5028204   6431200   3096076     38.11      2104   1579524   1657712     18.07    760072   1107040     15936
    04:20:45 PM   5037360   6431912   3086920     38.00      2104   1570932   1653420     18.03    757196   1101384      9640
    Average:      5008643   6404291   3115637     38.35      2104   1579712   1693009     18.46    759416   1128004    143329
    
    04:22:26 PM  LINUX RESTART      (4 CPU)
    
    04:22:32 PM  LINUX RESTART      (4 CPU)
    
    04:23:18 PM kbmemfree   kbavail kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
    04:24:20 PM   4902816   6425584   3221464     39.65      2104   1697380   1655508     18.05    825968   1158888     20128
    04:24:23 PM   4910968   6425568   3213312     39.55      2104   1689084   1654912     18.04    825936   1150768     11100
    04:25:11 PM   4942320   6458400   3181960     39.17      2104   1690384   1594500     17.38    827732   1117624         8
    04:30:24 PM   4930356   6446628   3193924     39.31      2104   1690584   1675620     18.27    831116   1126168         8
    04:35:18 PM   4943512   6459796   3180768     39.15      2104   1690608   1592144     17.36    831124   1113948         4
    04:40:10 PM   4816496   6332804   3307784     40.71      2104   1690844   1623988     17.70    831228   1238788         4
    04:45:18 PM   4796596   6312960   3327684     40.96      2104   1690900   1622968     17.69    831268   1258592         4
    04:50:24 PM   4816384   6332764   3307896     40.72      2104   1690916   1628920     17.76    831328   1238528         4
    04:55:01 PM   4816144   6332544   3308136     40.72      2104   1690932   1623988     17.70    831368   1238684         0
    05:00:18 PM   4796060   6312524   3328220     40.97      2104   1690996   1629060     17.76    831400   1258892         8
    05:05:02 PM   4793876   6310348   3330404     40.99      2104   1691012   1630080     17.77    831464   1258916        16
    Average:      4860503   6377265   3263777     40.17      2104   1691240   1630153     17.77    829994   1196345      2844
    
    ------------------------------------------------------------------
    sar -u | sed -e "s|$(hostname)|hostname|g"
    Linux 4.18.0-305.19.1.el8_4.x86_64 (hostname)   03/22/2022      _x86_64_        (4 CPU)
    
    12:34:48     LINUX RESTART      (4 CPU)
    
    12:35:10 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    12:37:17 PM     all     16.37      0.10      2.70      1.31      0.01     79.50
    12:37:20 PM     all     17.97      5.47     29.69      0.45      0.00     46.43
    12:37:24 PM     all     18.50      3.46     33.88      7.16      0.00     36.99
    12:37:26 PM     all     16.62      4.60     29.03      0.40      0.00     49.35
    12:37:31 PM     all     11.03      2.76     40.60      0.11      0.11     45.39
    12:37:54 PM     all     84.36      0.27      9.02      0.03      0.03      6.28
    12:37:55 PM     all     13.96      2.52     39.82      0.00      0.00     43.71
    12:38:22 PM     all     12.17      1.92     37.01      0.05      0.04     48.82
    12:38:29 PM     all     61.05      0.56     20.35      0.11      0.04     17.90
    12:38:30 PM     all     14.17      1.18     36.02      0.20      0.00     48.43
    12:38:36 PM     all     14.54      0.97     29.97      0.21      0.00     54.31
    12:40:01 PM     all      0.08      0.00      0.04      0.04      0.00     99.84
    Average:        all     17.52      0.47      8.33      0.71      0.01     72.95
    
    12:44:19 PM  LINUX RESTART      (4 CPU)
    
    12:44:20 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    12:44:21 PM     all     22.87      0.00      1.95      0.00      0.00     75.18
    12:44:22 PM     all     22.81      0.00      2.01      0.25      0.00     74.94
    12:44:23 PM     all     23.00      0.00      1.75      0.00      0.00     75.25
    12:45:00 PM     all     11.14      0.42      2.60      0.11      0.01     85.71
    Average:        all     12.04      0.39      2.55      0.11      0.01     84.90
    
    12:45:05 PM  LINUX RESTART      (4 CPU)
    
    12:45:10 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    12:45:11 PM     all     67.57      0.00      8.42      0.00      0.00     24.01
    12:46:52 PM     all     39.74      0.48     11.42      0.62      0.02     47.72
    12:48:12 PM     all     53.92      0.00      9.19      0.29      0.03     36.57
    12:49:42 PM     all     16.13      0.62      4.07      0.57      0.01     78.60
    12:49:43 PM     all     21.58      0.70      7.19      0.70      0.00     69.84
    12:49:44 PM     all     21.59      0.00      3.60      0.00      0.00     74.81
    12:50:12 PM     all     30.99      0.00     19.29      0.14      0.02     49.56
    12:51:22 PM     all     25.22      0.00     13.95      0.08      0.03     60.72
    12:53:34 PM     all     63.19      0.00     24.74      0.02      0.02     12.03
    12:53:46 PM     all      7.67      0.00     19.49      0.06      0.06     72.72
    12:54:36 PM     all     19.21      0.12      9.46      0.16      0.02     71.03
    12:54:38 PM     all     14.45      4.15     37.05      0.43      0.00     43.92
    12:55:11 PM     all     21.11      0.02      5.71      0.26      0.02     72.89
    12:55:24 PM     all     17.03      0.00     12.43      0.14      0.04     70.37
    12:55:26 PM     all     16.50      0.00     14.80      0.17      0.00     68.54
    12:55:27 PM     all     53.85      0.00     19.23      0.00      0.00     26.92
    12:55:44 PM     all     15.40      0.38      8.43      0.21      0.00     75.57
    12:55:45 PM     all     44.24      0.00     20.16      0.00      0.00     35.60
    12:55:47 PM     all      2.66      0.00      3.94      0.20      0.00     93.20
    12:55:50 PM     all     13.00      0.00     14.05      0.09      0.00     72.86
    12:56:28 PM     all     12.14      0.31      6.05      0.16      0.03     81.31
    12:56:35 PM     all     31.08      0.04     10.81      0.32      0.00     57.74
    01:00:01 PM     all      1.31      0.00      0.35      0.03      0.00     98.30
    Average:        all     27.12      0.15      9.86      0.21      0.02     62.64
    
    01:00:45 PM  LINUX RESTART      (4 CPU)
    
    01:00:54 PM  LINUX RESTART      (4 CPU)
    
    01:01:18 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    01:02:42 PM     all     57.27      0.00     13.06      0.33      0.03     29.31
    01:02:45 PM     all      0.71      0.00      1.25      0.08      0.00     97.96
    Average:        all     55.19      0.00     12.63      0.32      0.03     31.84
    
    01:02:57 PM  LINUX RESTART      (4 CPU)
    
    01:05:12 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    01:10:01 PM     all      0.02      0.00      0.02      0.00      0.00     99.96
    01:15:00 PM     all      0.03      0.00      0.04      0.00      0.00     99.93
    01:20:01 PM     all      0.04      0.00      0.04      0.00      0.00     99.93
    01:25:01 PM     all      0.02      0.00      0.03      0.00      0.00     99.95
    01:30:01 PM     all      0.02      0.00      0.02      0.00      0.00     99.95
    01:35:00 PM     all      0.02      0.00      0.03      0.00      0.00     99.95
    01:40:01 PM     all      0.14      0.00      0.03      0.00      0.00     99.83
    Average:        all      0.04      0.00      0.03      0.00      0.00     99.93
    
    01:41:08 PM  LINUX RESTART      (4 CPU)
    
    01:41:09 PM  LINUX RESTART      (4 CPU)
    
    01:41:29 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    01:43:05 PM     all     55.89      0.00     11.88      0.25      0.03     31.95
    01:43:08 PM     all      0.85      0.00      1.24      0.00      0.00     97.91
    01:45:01 PM     all      0.09      0.02      0.15      0.01      0.00     99.73
    01:50:01 PM     all      0.18      0.00      0.05      0.00      0.00     99.76
    Average:        all     10.58      0.00      2.29      0.05      0.01     87.06
    
    01:50:45 PM  LINUX RESTART      (4 CPU)
    
    01:50:47 PM  LINUX RESTART      (4 CPU)
    
    01:50:51 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    01:50:58 PM     all     17.59      0.00      8.68      0.19      0.00     73.53
    01:51:02 PM     all     44.35      0.00     10.53      0.08      0.00     45.05
    Average:        all     25.49      0.00      9.23      0.16      0.00     65.13
    
    01:51:07 PM  LINUX RESTART      (4 CPU)
    
    01:55:28 PM  LINUX RESTART      (4 CPU)
    
    01:55:30 PM  LINUX RESTART      (4 CPU)
    
    01:56:17 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    01:56:19 PM     all     21.43      0.00      3.88      0.00      0.00     74.69
    Average:        all     21.43      0.00      3.88      0.00      0.00     74.69
    
    01:57:57 PM  LINUX RESTART      (4 CPU)
    
    01:57:59 PM  LINUX RESTART      (4 CPU)
    
    01:58:15 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    01:58:16 PM     all     22.09      0.00      2.91      0.00      0.00     75.00
    02:00:01 PM     all      1.09      0.12      0.81      0.12      0.00     97.86
    Average:        all      1.35      0.12      0.84      0.11      0.00     97.58
    
    02:03:41 PM  LINUX RESTART      (4 CPU)
    
    02:03:43 PM  LINUX RESTART      (4 CPU)
    
    02:03:59 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    02:04:01 PM     all     22.02      0.00      3.29      0.62      0.00     74.07
    02:05:12 PM     all     29.99      0.00     20.34      0.17      0.02     49.47
    02:05:44 PM     all     19.40      0.00      6.56      0.09      0.02     73.93
    02:08:03 PM     all     60.84      0.00     26.98      0.03      0.04     12.12
    02:08:16 PM     all      7.83      0.00     19.04      0.26      0.04     72.83
    02:08:18 PM     all      3.20      0.00      4.17      0.58      0.10     91.95
    02:08:21 PM     all     12.95      0.00     13.98      0.00      0.00     73.07
    02:08:22 PM     all     14.85      0.00     11.39      0.00      0.00     73.76
    02:08:25 PM     all     21.33      0.00      4.06      0.07      0.00     74.55
    02:08:33 PM     all     17.92      0.00      8.59      0.10      0.03     73.35
    02:08:34 PM     all     51.47      0.00     22.97      0.00      0.17     25.39
    02:08:52 PM     all     14.03      0.00     11.59      0.10      0.03     74.25
    02:10:00 PM     all      0.60      0.00      0.95      0.06      0.00     98.39
    Average:        all     33.16      0.00     16.89      0.09      0.03     49.84
    
    02:10:05 PM  LINUX RESTART      (4 CPU)
    
    02:13:24 PM  LINUX RESTART      (4 CPU)
    
    02:15:01 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    02:20:01 PM     all      0.02      0.00      0.03      0.00      0.00     99.94
    Average:        all      0.02      0.00      0.03      0.00      0.00     99.94
    
    02:22:41 PM  LINUX RESTART      (4 CPU)
    
    02:22:58 PM  LINUX RESTART      (4 CPU)
    
    02:25:01 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    02:30:01 PM     all      0.29      0.00      0.08      0.00      0.00     99.63
    02:35:12 PM     all      0.36      0.00      0.10      0.00      0.00     99.54
    Average:        all      0.32      0.00      0.09      0.00      0.00     99.59
    
    02:35:23 PM  LINUX RESTART      (4 CPU)
    
    02:38:57 PM  LINUX RESTART      (4 CPU)
    
    02:40:01 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    02:45:09 PM     all      0.31      0.00      0.16      0.01      0.00     99.52
    02:50:01 PM     all      0.24      0.00      0.16      0.01      0.00     99.58
    02:55:01 PM     all      0.11      0.00      0.09      0.00      0.00     99.80
    03:00:01 PM     all      0.11      0.00      0.08      0.00      0.00     99.81
    03:05:12 PM     all      0.11      0.00      0.08      0.00      0.00     99.81
    03:10:01 PM     all     13.46      0.56     11.16      0.70      0.03     74.09
    03:15:12 PM     all      0.02      0.00      0.03      0.00      0.00     99.95
    03:20:01 PM     all      0.02      0.00      0.03      0.00      0.00     99.96
    03:25:12 PM     all      0.02      0.00      0.02      0.00      0.00     99.96
    Average:        all      1.53      0.06      1.26      0.08      0.00     97.07
    
    03:29:24 PM  LINUX RESTART      (4 CPU)
    
    03:30:26 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    03:35:01 PM     all      0.03      0.00      0.05      0.01      0.00     99.92
    03:40:18 PM     all      0.02      0.00      0.03      0.00      0.00     99.95
    03:45:18 PM     all      0.02      0.00      0.04      0.00      0.00     99.94
    03:50:21 PM     all      0.19      0.00      0.08      0.08      0.00     99.65
    03:55:18 PM     all      0.60      0.06      0.29      0.03      0.00     99.01
    04:00:01 PM     all      0.03      0.00      0.04      0.00      0.00     99.93
    Average:        all      0.15      0.01      0.09      0.02      0.00     99.73
    
    04:01:14 PM  LINUX RESTART      (4 CPU)
    
    04:01:30 PM  LINUX RESTART      (4 CPU)
    
    04:02:25 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    04:03:23 PM     all     47.83      0.00     10.43      0.70      0.02     41.01
    04:03:26 PM     all      0.94      0.00      0.94      0.00      0.00     98.11
    04:05:11 PM     all      0.08      0.00      0.11      0.02      0.00     99.79
    Average:        all     16.74      0.00      3.72      0.26      0.01     79.27
    
    04:05:38 PM  LINUX RESTART      (4 CPU)
    
    04:05:40 PM  LINUX RESTART      (4 CPU)
    
    04:06:03 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    04:06:52 PM     all     41.30      0.00      9.08      0.52      0.03     49.07
    04:06:55 PM     all      0.78      0.00      1.25      0.39      0.00     97.58
    04:10:18 PM     all      0.07      0.00      0.11      0.01      0.00     99.81
    04:15:08 PM     all      0.06      0.00      0.09      0.00      0.00     99.86
    Average:        all      3.74      0.00      0.90      0.05      0.00     95.31
    
    04:15:12 PM  LINUX RESTART      (4 CPU)
    
    04:15:14 PM  LINUX RESTART      (4 CPU)
    
    04:15:31 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    04:16:18 PM     all     34.99      0.00      8.43      0.56      0.02     56.01
    04:16:21 PM     all      0.71      0.00      1.18      0.00      0.00     98.12
    Average:        all     32.82      0.00      7.97      0.52      0.01     58.67
    
    04:19:32 PM  LINUX RESTART      (4 CPU)
    
    04:19:34 PM  LINUX RESTART      (4 CPU)
    
    04:19:53 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    04:20:30 PM     all     38.29      0.00     11.15      0.08      0.01     50.47
    04:20:41 PM     all     24.19      0.00      1.05      1.86      0.02     72.88
    04:20:45 PM     all      0.78      0.00      1.17      0.23      0.00     97.81
    Average:        all     32.78      0.00      8.27      0.48      0.01     58.45
    
    04:22:26 PM  LINUX RESTART      (4 CPU)
    
    04:22:32 PM  LINUX RESTART      (4 CPU)
    
    04:23:18 PM     CPU     %user     %nice   %system   %iowait    %steal     %idle
    04:24:20 PM     all     43.56      0.00     10.80      0.44      0.02     45.18
    04:24:23 PM     all      0.62      0.00      1.17      0.16      0.00     98.05
    04:25:11 PM     all      0.17      0.00      0.34      0.03      0.00     99.46
    04:30:24 PM     all      0.02      0.00      0.04      0.00      0.00     99.94
    04:35:18 PM     all      0.03      0.00      0.04      0.00      0.00     99.93
    04:40:10 PM     all      0.03      0.00      0.05      0.00      0.00     99.92
    04:45:18 PM     all      0.03      0.00      0.04      0.00      0.00     99.93
    04:50:24 PM     all      0.03      0.00      0.04      0.00      0.00     99.93
    04:55:01 PM     all      0.02      0.00      0.03      0.00      0.00     99.95
    05:00:18 PM     all      0.02      0.00      0.03      0.00      0.00     99.95
    05:05:02 PM     all      0.02      0.00      0.03      0.00      0.00     99.95
    Average:        all      1.09      0.00      0.31      0.01      0.00     98.59
    
    ------------------------------------------------------------------
    top -bHn1 -w200
    top - 17:07:12 up  1:37,  1 user,  load average: 0.00, 0.00, 0.00
    Threads: 173 total,   1 running, 172 sleeping,   0 stopped,   0 zombie
    %Cpu(s):  1.6 us,  0.0 sy,  0.0 ni, 98.4 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st
    MiB Mem :   7933.9 total,   4677.1 free,   1503.2 used,   1753.6 buff/cache
    MiB Swap:   1024.0 total,   1024.0 free,      0.0 used.   6158.5 avail Mem
    
      PID USER      PR  NI    VIRT    RES    SHR S  %CPU  %MEM     TIME+ COMMAND
        1 root      20   0  172536  11036   8360 S   0.0   0.1   0:03.15 systemd
        2 root      20   0       0      0      0 S   0.0   0.0   0:00.00 kthreadd
        3 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 rcu_gp
        4 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 rcu_par_gp
        6 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 kworker/0:0H-events_highpri
        9 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 mm_percpu_wq
       10 root      20   0       0      0      0 S   0.0   0.0   0:00.55 ksoftirqd/0
       11 root      20   0       0      0      0 I   0.0   0.0   0:00.58 rcu_sched
       12 root      rt   0       0      0      0 S   0.0   0.0   0:00.01 migration/0
       13 root      rt   0       0      0      0 S   0.0   0.0   0:00.01 watchdog/0
       14 root      20   0       0      0      0 S   0.0   0.0   0:00.00 cpuhp/0
       15 root      20   0       0      0      0 S   0.0   0.0   0:00.00 cpuhp/1
       16 root      rt   0       0      0      0 S   0.0   0.0   0:00.01 watchdog/1
       17 root      rt   0       0      0      0 S   0.0   0.0   0:00.01 migration/1
       18 root      20   0       0      0      0 S   0.0   0.0   0:00.58 ksoftirqd/1
       20 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 kworker/1:0H-events_highpri
       21 root      20   0       0      0      0 S   0.0   0.0   0:00.00 cpuhp/2
       22 root      rt   0       0      0      0 S   0.0   0.0   0:00.01 watchdog/2
       23 root      rt   0       0      0      0 S   0.0   0.0   0:00.01 migration/2
       24 root      20   0       0      0      0 S   0.0   0.0   0:00.56 ksoftirqd/2
       26 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 kworker/2:0H-events_highpri
       27 root      20   0       0      0      0 S   0.0   0.0   0:00.00 cpuhp/3
       28 root      rt   0       0      0      0 S   0.0   0.0   0:00.01 watchdog/3
       29 root      rt   0       0      0      0 S   0.0   0.0   0:00.01 migration/3
       30 root      20   0       0      0      0 S   0.0   0.0   0:00.55 ksoftirqd/3
       32 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 kworker/3:0H-events_highpri
       37 root      20   0       0      0      0 S   0.0   0.0   0:00.00 kdevtmpfs
       38 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 netns
       39 root      20   0       0      0      0 S   0.0   0.0   0:00.00 rcu_tasks_trace
       40 root      20   0       0      0      0 S   0.0   0.0   0:00.00 rcu_tasks_rude_
       41 root      20   0       0      0      0 S   0.0   0.0   0:00.02 kauditd
       43 root      20   0       0      0      0 S   0.0   0.0   0:00.00 khungtaskd
       44 root      20   0       0      0      0 S   0.0   0.0   0:00.00 oom_reaper
       45 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 writeback
       46 root      20   0       0      0      0 S   0.0   0.0   0:00.00 kcompactd0
       47 root      25   5       0      0      0 S   0.0   0.0   0:00.00 ksmd
       48 root      39  19       0      0      0 S   0.0   0.0   0:00.08 khugepaged
       49 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 crypto
       50 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 kintegrityd
       51 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 kblockd
       52 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 blkcg_punt_bio
       53 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 tpm_dev_wq
       54 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 md
       55 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 edac-poller
       56 root      rt   0       0      0      0 S   0.0   0.0   0:00.00 watchdogd
       58 root       0 -20       0      0      0 I   0.0   0.0   0:00.08 kworker/0:1H-kblockd
       98 root      20   0       0      0      0 S   0.0   0.0   0:00.00 kswapd0
      200 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 kthrotld
      201 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 acpi_thermal_pm
      202 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 kmpath_rdacd
      203 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 kaluad
      204 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 ipv6_addrconf
      205 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 kstrp
      318 root       0 -20       0      0      0 I   0.0   0.0   0:00.08 kworker/2:1H-kblockd
      321 root       0 -20       0      0      0 I   0.0   0.0   0:00.05 kworker/1:1H-xfs-log/vda2
      341 root       0 -20       0      0      0 I   0.0   0.0   0:00.04 kworker/3:1H-kblockd
      349 root      20   0   12372   7604   1732 S   0.0   0.1   0:00.42 haveged
      465 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 ata_sff
      468 root      20   0       0      0      0 S   0.0   0.0   0:00.00 scsi_eh_0
      469 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 scsi_tmf_0
      471 root      20   0       0      0      0 S   0.0   0.0   0:00.00 scsi_eh_1
      475 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 scsi_tmf_1
      491 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 xfsalloc
      492 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 xfs_mru_cache
      493 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 xfs-buf/vda2
      494 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 xfs-conv/vda2
      495 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 xfs-cil/vda2
      496 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 xfs-reclaim/vda
      497 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 xfs-eofblocks/v
      498 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 xfs-log/vda2
      499 root      20   0       0      0      0 S   0.0   0.0   0:02.11 xfsaild/vda2
      585 root      20   0   89464  10120   9184 S   0.0   0.1   0:00.22 systemd-journal
      642 root      16  -4   77012   1940   1328 S   0.0   0.0   0:00.10 auditd
      643 root      16  -4   77012   1940   1328 S   0.0   0.0   0:00.00 auditd
      667 root      20   0  115424   9776   7648 S   0.0   0.1   0:00.20 systemd-udevd
      685 polkitd   20   0 1763504  25312  16992 S   0.0   0.3   0:00.03 polkitd
      717 polkitd   20   0 1763504  25312  16992 S   0.0   0.3   0:00.00 gmain
      718 polkitd   20   0 1763504  25312  16992 S   0.0   0.3   0:00.03 gdbus
      720 polkitd   20   0 1763504  25312  16992 S   0.0   0.3   0:00.00 JS Helper
      721 polkitd   20   0 1763504  25312  16992 S   0.0   0.3   0:00.00 JS Helper
      722 polkitd   20   0 1763504  25312  16992 S   0.0   0.3   0:00.00 JS Helper
      723 polkitd   20   0 1763504  25312  16992 S   0.0   0.3   0:00.00 JS Helper
      732 polkitd   20   0 1763504  25312  16992 S   0.0   0.3   0:00.00 polkitd
      686 root      20   0  426856  14732  12592 S   0.0   0.2   0:00.04 sssd
      687 root      20   0  122916   5516   4884 S   0.0   0.1   0:00.18 irqbalance
      694 root      20   0  122916   5516   4884 S   0.0   0.1   0:00.00 gmain
      695 dbus      20   0   76652   5572   5004 S   0.0   0.1   0:00.46 dbus-daemon
      705 chrony    20   0  149116   4680   3956 S   0.0   0.1   0:00.04 chronyd
      714 root      20   0  435408  15536  12792 S   0.0   0.2   0:00.11 sssd_be
      734 rngd      20   0  154828   5980   5164 S   0.0   0.1   0:00.10 rngd
      756 rngd      20   0  154828   5980   5164 S   0.0   0.1   0:07.24 rngd
      747 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 ttm_swap
      757 root      20   0  436972  41112  39304 S   0.0   0.5   0:00.26 sssd_nss
      767 root      20   0   92632   7656   6740 S   0.0   0.1   0:00.11 systemd-logind
      773 root      20   0       0      0      0 S   0.0   0.0   0:00.00 hwmon0
      790 root      20   0  600288  19640  16480 S   0.0   0.2   0:00.08 NetworkManager
      795 root      20   0  600288  19640  16480 S   0.0   0.2   0:00.09 gmain
      796 root      20   0  600288  19640  16480 S   0.0   0.2   0:00.00 gdbus
      798 root      20   0   92352   7540   6612 S   0.0   0.1   0:00.01 sshd
      801 root      20   0  781236  32224  15756 S   0.0   0.4   0:00.20 tuned
     1268 root      20   0  781236  32224  15756 S   0.0   0.4   0:00.73 tuned
     1279 root      20   0  781236  32224  15756 S   0.0   0.4   0:00.00 tuned
     1302 root      20   0  781236  32224  15756 S   0.0   0.4   0:00.00 tuned
      807 root      20   0  246744   3704   2848 S   0.0   0.0   0:00.00 crond
     1242 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.06 mysqld
     1303 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.00 mysqld
     1308 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.00 mysqld
     1313 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.33 mysqld
     1314 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.46 mysqld
     1315 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.38 mysqld
     1316 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.36 mysqld
     1317 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.40 mysqld
     1318 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.43 mysqld
     1319 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.18 mysqld
     1331 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.22 mysqld
     1332 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.38 mysqld
     1333 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.04 mysqld
     1334 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.01 mysqld
     1335 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.04 mysqld
     1336 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.23 mysqld
     1337 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.00 mysqld
     1338 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.00 mysqld
     1339 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.00 mysqld
     1340 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.18 mysqld
     1341 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.00 mysqld
     1342 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.00 mysqld
     1343 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.00 mysqld
     1344 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.00 mysqld
    27780 mysql     20   0 2198964 171804  21248 S   0.0   2.1   0:00.00 mysqld
     1547 root       0 -20       0      0      0 I   0.0   0.0   0:00.00 dio/vda2
     1575 root      20   0  218556   8048   5224 S   0.0   0.1   0:00.00 rsyslogd
     1578 root      20   0  218556   8048   5224 S   0.0   0.1   0:00.47 in:imjournal
     1579 root      20   0  218556   8048   5224 S   0.0   0.1   0:00.03 rs:main Q:Reg
     1576 root      20   0  226348   1632   1520 S   0.0   0.0   0:00.01 agetty
     1595 memcach+  20   0  455448   4420   1680 S   0.0   0.1   0:00.27 memcached
     1596 memcach+  20   0  455448   4420   1680 S   0.0   0.1   0:00.19 memcached
     1597 memcach+  20   0  455448   4420   1680 S   0.0   0.1   0:00.00 memcached
     1598 memcach+  20   0  455448   4420   1680 S   0.0   0.1   0:00.00 memcached
     1599 memcach+  20   0  455448   4420   1680 S   0.0   0.1   0:00.00 memcached
     1600 memcach+  20   0  455448   4420   1680 S   0.0   0.1   0:00.00 memcached
     1607 memcach+  20   0  455448   4420   1680 S   0.0   0.1   0:00.00 memcached
     1608 memcach+  20   0  455448   4420   1680 S   0.0   0.1   0:00.00 memcached
     1614 memcach+  20   0  455448   4420   1680 S   0.0   0.1   0:00.34 memcached
     1615 memcach+  20   0  455448   4420   1680 S   0.0   0.1   0:00.00 memcached
     1648 root      20   0  153456  10372   9108 S   0.0   0.1   0:00.01 sshd
     1652 root      20   0   89360   9228   8004 S   0.0   0.1   0:00.02 systemd
     1654 root      20   0  227524   2572     12 S   0.0   0.0   0:00.00 (sd-pam)
     1660 root      20   0  153796   6472   4992 S   0.0   0.1   0:01.57 sshd
     1662 root      20   0  236296   4544   3724 S   0.0   0.1   0:00.13 bash
     3462 root      20   0  293180   4332   3280 S   0.0   0.1   0:00.00 pure-ftpd
     3464 root      20   0       0      0      0 I   0.0   0.0   0:00.58 kworker/1:1-events
     3886 root      20   0  309268  33440   5312 S   0.0   0.4   0:00.38 lfd - sleeping
    26197 root      20   0       0      0      0 I   0.0   0.0   0:00.23 kworker/u256:1-events_unbound
    27377 root      20   0       0      0      0 I   0.0   0.0   0:00.03 kworker/0:0-events
    27395 root      20   0       0      0      0 I   0.0   0.0   0:00.01 kworker/3:1-events
    27397 root      20   0       0      0      0 I   0.0   0.0   0:00.00 kworker/2:3-xfs-conv/vda2
    27403 root      20   0       0      0      0 I   0.0   0.0   0:00.00 kworker/u256:0-events_unbound
    27441 root      20   0  159884  36916   2212 S   0.0   0.5   0:00.00 nginx
    27442 nginx     10 -10  251404  84916   5684 S   0.0   1.0   0:00.27 nginx
    27443 nginx     10 -10  251404  84916   5684 S   0.0   1.0   0:00.58 nginx
    27488 root      20   0       0      0      0 I   0.0   0.0   0:00.00 kworker/1:2-cgroup_destroy
    27496 root      20   0       0      0      0 I   0.0   0.0   0:00.00 kworker/2:0-events
    27536 root      20   0       0      0      0 I   0.0   0.0   0:00.00 kworker/0:3-cgroup_pidlist_destroy
    27561 root      20   0       0      0      0 I   0.0   0.0   0:00.00 kworker/3:0-events
    27583 root      20   0       0      0      0 I   0.0   0.0   0:00.00 kworker/0:2-cgroup_destroy
    27614 root      20   0       0      0      0 I   0.0   0.0   0:00.00 kworker/2:1-xfs-conv/vda2
    27641 root      20   0  223312   3908   2920 S   0.0   0.0   0:00.00 cminfo
    27674 root      20   0  223444   2952   1788 S   0.0   0.0   0:00.01 cminfo
    27675 root      20   0  217080    800    728 S   0.0   0.0   0:00.00 tee
    27751 root      20   0       0      0      0 I   0.0   0.0   0:00.00 kworker/3:2-events
    28116 nginx     20   0  584192  20932  10940 S   0.0   0.3   0:00.00 php-fpm
    28148 root      20   0  275196   4556   3972 R   0.0   0.1   0:00.00 top
    41291 root      20   0  567896  19028   9124 S   0.0   0.2   0:00.15 php-fpm
    
    ------------------------------------------------------------------
    iotop -bton1 -P
    17:07:12 Total DISK READ :       0.00 B/s | Total DISK WRITE :       0.00 B/s
    17:07:12 Actual DISK READ:       0.00 B/s | Actual DISK WRITE:       0.00 B/s
        TIME  PID  PRIO  USER     DISK READ  DISK WRITE  SWAPIN      IO    COMMAND
    
    ------------------------------------------------------------------
    MySQL InnoDB Status
    
    ---
    MySQL InnoDB Monitor Statistics Gathering for 10 seconds
    
    *************************** 1. row ***************************
      Type: InnoDB
      Name:
    Status:
    =====================================
    2022-03-22 17:07:22 0x7efc30157700 INNODB MONITOR OUTPUT
    =====================================
    Per second averages calculated from the last 2 seconds
    -----------------
    BACKGROUND THREAD
    -----------------
    srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 5876 srv_idle
    srv_master_thread log flush and writes: 5876
    ----------
    SEMAPHORES
    ----------
    OS WAIT ARRAY INFO: reservation count 3
    OS WAIT ARRAY INFO: signal count 3
    RW-shared spins 1, rounds 30, OS waits 1
    RW-excl spins 0, rounds 0, OS waits 0
    RW-sx spins 0, rounds 0, OS waits 0
    Spin rounds per wait: 30.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
    ------------
    TRANSACTIONS
    ------------
    Trx id counter 21
    Purge done for trx's n:o < 19 undo n:o < 0 state: running but idle
    History list length 9
    LIST OF TRANSACTIONS FOR EACH SESSION:
    ---TRANSACTION 421096580903016, not started
    0 lock struct(s), heap size 1128, 0 row lock(s)
    --------
    FILE I/O
    --------
    I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
    I/O thread 1 state: waiting for completed aio requests (log thread)
    I/O thread 2 state: waiting for completed aio requests (read thread)
    I/O thread 3 state: waiting for completed aio requests (read thread)
    I/O thread 4 state: waiting for completed aio requests (write thread)
    I/O thread 5 state: waiting for completed aio requests (write thread)
    Pending normal aio reads: [0, 0] , aio writes: [0, 0] ,
     ibuf aio reads:, log i/o's:, sync i/o's:
    Pending flushes (fsync) log: 0; buffer pool: 0
    192 OS file reads, 133 OS file writes, 2 OS fsyncs
    0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
    -------------------------------------
    INSERT BUFFER AND ADAPTIVE HASH INDEX
    -------------------------------------
    Ibuf: size 1, free list len 0, seg size 2, 0 merges
    merged operations:
     insert 0, delete mark 0, delete 0
    discarded operations:
     insert 0, delete mark 0, delete 0
    Hash table size 138401, node heap has 0 buffer(s)
    Hash table size 138401, node heap has 0 buffer(s)
    Hash table size 138401, node heap has 0 buffer(s)
    Hash table size 138401, node heap has 0 buffer(s)
    Hash table size 138401, node heap has 0 buffer(s)
    Hash table size 138401, node heap has 0 buffer(s)
    Hash table size 138401, node heap has 0 buffer(s)
    Hash table size 138401, node heap has 0 buffer(s)
    0.00 hash searches/s, 0.00 non-hash searches/s
    ---
    LOG
    ---
    Log sequence number 1625648
    Log flushed up to   1625648
    Pages flushed up to 1625648
    Last checkpoint at  1625639
    0 pending log flushes, 0 pending chkp writes
    8 log i/o's done, 0.00 log i/o's/second
    ----------------------
    BUFFER POOL AND MEMORY
    ----------------------
    Total large memory allocated 564920320
    Dictionary memory allocated 32032
    Buffer pool size   32768
    Free buffers       32461
    Database pages     307
    Old database pages 0
    Modified db pages  0
    Percent of dirty pages(LRU & free pages): 0.000
    Max dirty pages percent: 75.000
    Pending reads 0
    Pending writes: LRU 0, flush list 0, single page 0
    Pages made young 0, not young 0
    0.00 youngs/s, 0.00 non-youngs/s
    Pages read 176, created 131, written 131
    0.00 reads/s, 0.00 creates/s, 0.00 writes/s
    No buffer pool page gets since the last printout
    Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
    LRU len: 307, unzip_LRU len: 0
    I/O sum[0]:cur[0], unzip sum[0]:cur[0]
    --------------
    ROW OPERATIONS
    --------------
    0 queries inside InnoDB, 0 queries in queue
    0 read views open inside InnoDB
    Process ID=1242, Main thread ID=139621177116416, state: sleeping
    Number of rows inserted 0, updated 0, deleted 0, read 0
    0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
    Number of system rows inserted 0, updated 0, deleted 0, read 0
    0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
    ----------------------------
    END OF INNODB MONITOR OUTPUT
    ============================
    
    
    
    ------------------------------------------------------------------
    mysqladmin var
    | Variable_name | Value |
    | alter_algorithm | DEFAULT |
    | aria_block_size | 8192 |
    | aria_checkpoint_interval | 30 |
    | aria_checkpoint_log_activity | 1048576 |
    | aria_encrypt_tables | OFF |
    | aria_force_start_after_recovery_failures | 0 |
    | aria_group_commit | none |
    | aria_group_commit_interval | 0 |
    | aria_log_file_size | 67108864 |
    | aria_log_purge_type | immediate |
    | aria_max_sort_file_size | 9223372036853727232 |
    | aria_page_checksum | ON |
    | aria_pagecache_age_threshold | 300 |
    | aria_pagecache_buffer_size | 67108864 |
    | aria_pagecache_division_limit | 100 |
    | aria_pagecache_file_hash_size | 512 |
    | aria_recover_options | BACKUP,QUICK |
    | aria_repair_threads | 1 |
    | aria_sort_buffer_size | 67108864 |
    | aria_stats_method | nulls_unequal |
    | aria_sync_log_dir | NEWFILE |
    | aria_used_for_temp_tables | ON |
    | auto_increment_increment | 1 |
    | auto_increment_offset | 1 |
    | autocommit | ON |
    | automatic_sp_privileges | ON |
    | back_log | 350 |
    | basedir | /usr/ |
    | big_tables | OFF |
    | bind_address | |
    | binlog_annotate_row_events | ON |
    | binlog_cache_size | 32768 |
    | binlog_checksum | CRC32 |
    | binlog_commit_wait_count | 0 |
    | binlog_commit_wait_usec | 100000 |
    | binlog_direct_non_transactional_updates | OFF |
    | binlog_file_cache_size | 16384 |
    | binlog_format | MIXED |
    | binlog_optimize_thread_scheduling | ON |
    | binlog_row_image | FULL |
    | binlog_stmt_cache_size | 32768 |
    | bulk_insert_buffer_size | 8388608 |
    | character_set_client | utf8 |
    | character_set_connection | utf8 |
    | character_set_database | utf8 |
    | character_set_filesystem | binary |
    | character_set_results | utf8 |
    | character_set_server | utf8 |
    | character_set_system | utf8 |
    | character_sets_dir | /usr/share/mysql/charsets/ |
    | check_constraint_checks | ON |
    | collation_connection | utf8_general_ci |
    | collation_database | utf8_general_ci |
    | collation_server | utf8_general_ci |
    | column_compression_threshold | 100 |
    | column_compression_zlib_level | 6 |
    | column_compression_zlib_strategy | DEFAULT_STRATEGY |
    | column_compression_zlib_wrap | OFF |
    | completion_type | NO_CHAIN |
    | concurrent_insert | ALWAYS |
    | connect_timeout | 10 |
    | core_file | OFF |
    | datadir | /var/lib/mysql/ |
    | deadlock_search_depth_long | 15 |
    | deadlock_search_depth_short | 4 |
    | deadlock_timeout_long | 50000000 |
    | deadlock_timeout_short | 10000 |
    | debug_no_thread_alarm | OFF |
    | default_regex_flags | |
    | default_storage_engine | InnoDB |
    | default_tmp_storage_engine | |
    | default_week_format | 0 |
    | delay_key_write | ON |
    | delayed_insert_limit | 100 |
    | delayed_insert_timeout | 300 |
    | delayed_queue_size | 1000 |
    | div_precision_increment | 4 |
    | encrypt_binlog | OFF |
    | encrypt_tmp_disk_tables | OFF |
    | encrypt_tmp_files | OFF |
    | enforce_storage_engine | |
    | eq_range_index_dive_limit | 0 |
    | event_scheduler | OFF |
    | expensive_subquery_limit | 100 |
    | expire_logs_days | 0 |
    | explicit_defaults_for_timestamp | OFF |
    | extra_max_connections | 1 |
    | extra_port | 0 |
    | flush | OFF |
    | flush_time | 0 |
    | foreign_key_checks | ON |
    | ft_max_word_len | 84 |
    | ft_min_word_len | 4 |
    | ft_query_expansion_limit | 20 |
    | general_log | OFF |
    | group_concat_max_len | 1048576 |
    | gtid_binlog_pos | |
    | gtid_binlog_state | |
    | gtid_current_pos | |
    | gtid_domain_id | 0 |
    | gtid_ignore_duplicates | OFF |
    | gtid_pos_auto_engines | |
    | gtid_slave_pos | |
    | gtid_strict_mode | OFF |
    | have_compress | YES |
    | have_crypt | YES |
    | have_dynamic_loading | YES |
    | have_geometry | YES |
    | have_openssl | YES |
    | have_profiling | YES |
    | have_query_cache | YES |
    | have_rtree_keys | YES |
    | have_ssl | DISABLED |
    | have_symlink | YES |
    | histogram_size | 0 |
    | histogram_type | SINGLE_PREC_HB |
    | host_cache_size | 478 |
    | idle_readonly_transaction_timeout | 0 |
    | idle_transaction_timeout | 0 |
    | idle_write_transaction_timeout | 0 |
    | ignore_builtin_innodb | OFF |
    | ignore_db_dirs | cmsetiofiotest,lost+found |
    | in_predicate_conversion_threshold | 1000 |
    | init_connect | |
    | init_file | |
    | init_slave | |
    | innodb_adaptive_flushing | ON |
    | innodb_adaptive_flushing_lwm | 10.000000 |
    | innodb_adaptive_hash_index | ON |
    | innodb_adaptive_hash_index_parts | 8 |
    | innodb_adaptive_max_sleep_delay | 150000 |
    | innodb_autoextend_increment | 64 |
    | innodb_autoinc_lock_mode | 1 |
    | innodb_background_scrub_data_check_interval | 3600 |
    | innodb_background_scrub_data_compressed | OFF |
    | innodb_background_scrub_data_interval | 604800 |
    | innodb_background_scrub_data_uncompressed | OFF |
    | innodb_buf_dump_status_frequency | 0 |
    | innodb_buffer_pool_chunk_size | 134217728 |
    | innodb_buffer_pool_dump_at_shutdown | ON |
    | innodb_buffer_pool_dump_now | OFF |
    | innodb_buffer_pool_dump_pct | 25 |
    | innodb_buffer_pool_filename | ib_buffer_pool |
    | innodb_buffer_pool_instances | 1 |
    | innodb_buffer_pool_load_abort | OFF |
    | innodb_buffer_pool_load_at_startup | ON |
    | innodb_buffer_pool_load_now | OFF |
    | innodb_buffer_pool_size | 536870912 |
    | innodb_change_buffer_max_size | 25 |
    | innodb_change_buffering | all |
    | innodb_checksum_algorithm | crc32 |
    | innodb_checksums | ON |
    | innodb_cmp_per_index_enabled | OFF |
    | innodb_commit_concurrency | 0 |
    | innodb_compression_algorithm | zlib |
    | innodb_compression_default | OFF |
    | innodb_compression_failure_threshold_pct | 5 |
    | innodb_compression_level | 6 |
    | innodb_compression_pad_pct_max | 50 |
    | innodb_concurrency_tickets | 5000 |
    | innodb_data_file_path | ibdata1:10M:autoextend |
    | innodb_data_home_dir | |
    | innodb_deadlock_detect | ON |
    | innodb_default_encryption_key_id | 1 |
    | innodb_default_row_format | dynamic |
    | innodb_defragment | ON |
    | innodb_defragment_fill_factor | 0.900000 |
    | innodb_defragment_fill_factor_n_recs | 20 |
    | innodb_defragment_frequency | 40 |
    | innodb_defragment_n_pages | 7 |
    | innodb_defragment_stats_accuracy | 0 |
    | innodb_disable_sort_file_cache | OFF |
    | innodb_disallow_writes | OFF |
    | innodb_doublewrite | ON |
    | innodb_encrypt_log | OFF |
    | innodb_encrypt_tables | OFF |
    | innodb_encrypt_temporary_tables | OFF |
    | innodb_encryption_rotate_key_age | 1 |
    | innodb_encryption_rotation_iops | 100 |
    | innodb_encryption_threads | 0 |
    | innodb_fast_shutdown | 1 |
    | innodb_fatal_semaphore_wait_threshold | 600 |
    | innodb_file_format | |
    | innodb_file_per_table | ON |
    | innodb_fill_factor | 100 |
    | innodb_flush_log_at_timeout | 1 |
    | innodb_flush_log_at_trx_commit | 2 |
    | innodb_flush_method | O_DIRECT |
    | innodb_flush_neighbors | 0 |
    | innodb_flush_sync | ON |
    | innodb_flushing_avg_loops | 30 |
    | innodb_force_load_corrupted | OFF |
    | innodb_force_primary_key | OFF |
    | innodb_force_recovery | 0 |
    | innodb_ft_aux_table | |
    | innodb_ft_cache_size | 8000000 |
    | innodb_ft_enable_diag_print | OFF |
    | innodb_ft_enable_stopword | ON |
    | innodb_ft_max_token_size | 84 |
    | innodb_ft_min_token_size | 3 |
    | innodb_ft_num_word_optimize | 2000 |
    | innodb_ft_result_cache_limit | 2000000000 |
    | innodb_ft_server_stopword_table | |
    | innodb_ft_sort_pll_degree | 2 |
    | innodb_ft_total_cache_size | 640000000 |
    | innodb_ft_user_stopword_table | |
    | innodb_idle_flush_pct | 100 |
    | innodb_immediate_scrub_data_uncompressed | OFF |
    | innodb_instant_alter_column_allowed | add_last |
    | innodb_io_capacity | 1400 |
    | innodb_io_capacity_max | 2333 |
    | innodb_large_prefix | |
    | innodb_lock_schedule_algorithm | fcfs |
    | innodb_lock_wait_timeout | 50 |
    | innodb_locks_unsafe_for_binlog | OFF |
    | innodb_log_buffer_size | 8388608 |
    | innodb_log_checksums | ON |
    | innodb_log_compressed_pages | ON |
    | innodb_log_file_size | 268435456 |
    | innodb_log_files_in_group | 2 |
    | innodb_log_group_home_dir | ./ |
    | innodb_log_optimize_ddl | OFF |
    | innodb_log_write_ahead_size | 8192 |
    | innodb_lru_scan_depth | 1024 |
    | innodb_max_dirty_pages_pct | 75.000000 |
    | innodb_max_dirty_pages_pct_lwm | 0.000000 |
    | innodb_max_purge_lag | 0 |
    | innodb_max_purge_lag_delay | 0 |
    | innodb_max_purge_lag_wait | 4294967295 |
    | innodb_max_undo_log_size | 10485760 |
    | innodb_monitor_disable | |
    | innodb_monitor_enable | |
    | innodb_monitor_reset | |
    | innodb_monitor_reset_all | |
    | innodb_old_blocks_pct | 37 |
    | innodb_old_blocks_time | 1000 |
    | innodb_online_alter_log_max_size | 134217728 |
    | innodb_open_files | 4000 |
    | innodb_optimize_fulltext_only | OFF |
    | innodb_page_cleaners | 1 |
    | innodb_page_size | 16384 |
    | innodb_prefix_index_cluster_optimization | OFF |
    | innodb_print_all_deadlocks | OFF |
    | innodb_purge_batch_size | 300 |
    | innodb_purge_rseg_truncate_frequency | 128 |
    | innodb_purge_threads | 2 |
    | innodb_random_read_ahead | OFF |
    | innodb_read_ahead_threshold | 56 |
    | innodb_read_io_threads | 2 |
    | innodb_read_only | OFF |
    | innodb_replication_delay | 0 |
    | innodb_rollback_on_timeout | OFF |
    | innodb_rollback_segments | 128 |
    | innodb_scrub_log | OFF |
    | innodb_scrub_log_speed | 256 |
    | innodb_sort_buffer_size | 2097152 |
    | innodb_spin_wait_delay | 4 |
    | innodb_stats_auto_recalc | ON |
    | innodb_stats_include_delete_marked | OFF |
    | innodb_stats_method | nulls_equal |
    | innodb_stats_modified_counter | 0 |
    | innodb_stats_on_metadata | OFF |
    | innodb_stats_persistent | ON |
    | innodb_stats_persistent_sample_pages | 20 |
    | innodb_stats_sample_pages | 8 |
    | innodb_stats_traditional | ON |
    | innodb_stats_transient_sample_pages | 8 |
    | innodb_status_output | OFF |
    | innodb_status_output_locks | OFF |
    | innodb_strict_mode | ON |
    | innodb_sync_array_size | 1 |
    | innodb_sync_spin_loops | 30 |
    | innodb_table_locks | ON |
    | innodb_temp_data_file_path | ibtmp1:12M:autoextend |
    | innodb_thread_concurrency | 12 |
    | innodb_thread_sleep_delay | 5000 |
    | innodb_tmpdir | |
    | innodb_undo_directory | ./ |
    | innodb_undo_log_truncate | OFF |
    | innodb_undo_logs | 128 |
    | innodb_undo_tablespaces | 0 |
    | innodb_use_atomic_writes | ON |
    | innodb_use_native_aio | ON |
    | innodb_version | 10.3.34 |
    | innodb_write_io_threads | 2 |
    | interactive_timeout | 28800 |
    | join_buffer_size | 262144 |
    | join_buffer_space_limit | 2097152 |
    | join_cache_level | 2 |
    | keep_files_on_create | OFF |
    | key_buffer_size | 268435456 |
    | key_cache_age_threshold | 300 |
    | key_cache_block_size | 1024 |
    | key_cache_division_limit | 100 |
    | key_cache_file_hash_size | 512 |
    | key_cache_segments | 1 |
    | large_files_support | ON |
    | large_page_size | 0 |
    | large_pages | OFF |
    | lc_messages | en_US |
    | lc_messages_dir | |
    | lc_time_names | en_US |
    | license | GPL |
    | local_infile | OFF |
    | lock_wait_timeout | 86400 |
    | locked_in_memory | OFF |
    | log_bin | OFF |
    | log_bin_basename | |
    | log_bin_compress | OFF |
    | log_bin_compress_min_len | 256 |
    | log_bin_index | |
    | log_bin_trust_function_creators | OFF |
    | log_disabled_statements | sp |
    | log_error | |
    | log_output | FILE |
    | log_queries_not_using_indexes | OFF |
    | log_slave_updates | OFF |
    | log_slow_admin_statements | ON |
    | log_slow_disabled_statements | sp |
    | log_slow_filter | admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk |
    | log_slow_rate_limit | 1 |
    | log_slow_slave_statements | ON |
    | log_slow_verbosity | |
    | log_tc_size | 24576 |
    | log_warnings | 1 |
    | long_query_time | 1.000000 |
    | low_priority_updates | OFF |
    | lower_case_file_system | OFF |
    | lower_case_table_names | 0 |
    | master_verify_checksum | OFF |
    | max_allowed_packet | 67108864 |
    | max_binlog_cache_size | 18446744073709547520 |
    | max_binlog_size | 1073741824 |
    | max_binlog_stmt_cache_size | 18446744073709547520 |
    | max_connect_errors | 100000 |
    | max_connections | 350 |
    | max_delayed_threads | 20 |
    | max_digest_length | 1024 |
    | max_error_count | 64 |
    | max_heap_table_size | 268435456 |
    | max_insert_delayed_threads | 20 |
    | max_join_size | 18446744073709551615 |
    | max_length_for_sort_data | 1024 |
    | max_long_data_size | 67108864 |
    | max_prepared_stmt_count | 16382 |
    | max_recursive_iterations | 4294967295 |
    | max_relay_log_size | 1073741824 |
    | max_seeks_for_key | 4294967295 |
    | max_session_mem_used | 9223372036854775807 |
    | max_sort_length | 1024 |
    | max_sp_recursion_depth | 0 |
    | max_statement_time | 0.000000 |
    | max_tmp_tables | 32 |
    | max_user_connections | 0 |
    | max_write_lock_count | 4294967295 |
    | metadata_locks_cache_size | 1024 |
    | metadata_locks_hash_instances | 8 |
    | min_examined_row_limit | 0 |
    | mrr_buffer_size | 262144 |
    | multi_range_count | 256 |
    | myisam_block_size | 1024 |
    | myisam_data_pointer_size | 6 |
    | myisam_max_sort_file_size | 2147483648 |
    | myisam_mmap_size | 18446744073709551615 |
    | myisam_recover_options | BACKUP,QUICK |
    | myisam_repair_threads | 1 |
    | myisam_sort_buffer_size | 268435456 |
    | myisam_stats_method | NULLS_UNEQUAL |
    | myisam_use_mmap | OFF |
    | mysql56_temporal_format | ON |
    | net_buffer_length | 16384 |
    | net_read_timeout | 30 |
    | net_retry_count | 10 |
    | net_write_timeout | 60 |
    | old | OFF |
    | old_alter_table | DEFAULT |
    | old_mode | |
    | old_passwords | OFF |
    | open_files_limit | 65921 |
    | optimizer_prune_level | 1 |
    | optimizer_search_depth | 62 |
    | optimizer_selectivity_sampling_limit | 100 |
    | optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on |
    | optimizer_use_condition_selectivity | 1 |
    | performance_schema | OFF |
    | performance_schema_max_cond_classes | 80 |
    | performance_schema_max_digest_length | 1024 |
    | performance_schema_max_file_classes | 50 |
    | performance_schema_max_file_handles | 32768 |
    | performance_schema_max_mutex_classes | 200 |
    | performance_schema_max_rwlock_classes | 40 |
    | performance_schema_max_socket_classes | 10 |
    | performance_schema_max_stage_classes | 160 |
    | performance_schema_max_statement_classes | 200 |
    | performance_schema_max_thread_classes | 50 |
    | performance_schema_setup_actors_size | 100 |
    | performance_schema_setup_objects_size | 100 |
    | plugin_dir | /usr/lib64/mysql/plugin/ |
    | plugin_maturity | gamma |
    | port | 3306 |
    | preload_buffer_size | 32768 |
    | profiling | OFF |
    | profiling_history_size | 15 |
    | progress_report_time | 5 |
    | protocol_version | 10 |
    | proxy_protocol_networks | |
    | query_alloc_block_size | 65536 |
    | query_cache_limit | 1048576 |
    | query_cache_min_res_unit | 2048 |
    | query_cache_size | 83886080 |
    | query_cache_strip_comments | OFF |
    | query_cache_type | ON |
    | query_cache_wlock_invalidate | OFF |
    | query_prealloc_size | 262144 |
    | query_response_time_flush | OFF |
    | query_response_time_range_base | 10 |
    | query_response_time_stats | OFF |
    | range_alloc_block_size | 4096 |
    | read_binlog_speed_limit | 0 |
    | read_buffer_size | 262144 |
    | read_only | OFF |
    | read_rnd_buffer_size | 524288 |
    | relay_log | |
    | relay_log_basename | |
    | relay_log_index | |
    | relay_log_purge | ON |
    | relay_log_recovery | OFF |
    | relay_log_space_limit | 0 |
    | replicate_annotate_row_events | ON |
    | replicate_do_db | |
    | replicate_do_table | |
    | replicate_events_marked_for_skip | REPLICATE |
    | replicate_ignore_db | |
    | replicate_ignore_table | |
    | replicate_wild_do_table | |
    | replicate_wild_ignore_table | |
    | report_host | |
    | report_password | |
    | report_port | 3306 |
    | report_user | |
    | rowid_merge_buff_size | 8388608 |
    | rpl_semi_sync_master_enabled | OFF |
    | rpl_semi_sync_master_timeout | 10000 |
    | rpl_semi_sync_master_trace_level | 32 |
    | rpl_semi_sync_master_wait_no_slave | ON |
    | rpl_semi_sync_master_wait_point | AFTER_COMMIT |
    | rpl_semi_sync_slave_delay_master | OFF |
    | rpl_semi_sync_slave_enabled | OFF |
    | rpl_semi_sync_slave_kill_conn_timeout | 5 |
    | rpl_semi_sync_slave_trace_level | 32 |
    | secure_auth | ON |
    | secure_file_priv | |
    | secure_timestamp | NO |
    | server_id | 1 |
    | session_track_schema | ON |
    | session_track_state_change | OFF |
    | session_track_system_variables | autocommit,character_set_client,character_set_connection,character_set_results,time_zone |
    | session_track_transaction_info | OFF |
    | skip_external_locking | ON |
    | skip_name_resolve | OFF |
    | skip_networking | OFF |
    | skip_show_database | OFF |
    | slave_compressed_protocol | OFF |
    | slave_ddl_exec_mode | IDEMPOTENT |
    | slave_domain_parallel_threads | 0 |
    | slave_exec_mode | STRICT |
    | slave_load_tmpdir | /home/mysqltmp |
    | slave_max_allowed_packet | 1073741824 |
    | slave_net_timeout | 60 |
    | slave_parallel_max_queued | 131072 |
    | slave_parallel_mode | conservative |
    | slave_parallel_threads | 0 |
    | slave_parallel_workers | 0 |
    | slave_run_triggers_for_rbr | NO |
    | slave_skip_errors | OFF |
    | slave_sql_verify_checksum | ON |
    | slave_transaction_retries | 10 |
    | slave_transaction_retry_errors | 1213,1205 |
    | slave_transaction_retry_interval | 0 |
    | slave_type_conversions | |
    | slow_launch_time | 2 |
    | slow_query_log | OFF |
    | slow_query_log_file | /var/lib/mysql/slowq.log |
    | socket | /var/lib/mysql/mysql.sock |
    | sort_buffer_size | 262144 |
    | sql_auto_is_null | OFF |
    | sql_big_selects | ON |
    | sql_buffer_result | OFF |
    | sql_log_bin | ON |
    | sql_log_off | OFF |
    | sql_mode | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
    | sql_notes | ON |
    | sql_quote_show_create | ON |
    | sql_safe_updates | OFF |
    | sql_select_limit | 18446744073709551615 |
    | sql_slave_skip_counter | 0 |
    | sql_warnings | OFF |
    | ssl_ca | |
    | ssl_capath | |
    | ssl_cert | |
    | ssl_cipher | |
    | ssl_crl | |
    | ssl_crlpath | |
    | ssl_key | |
    | standard_compliant_cte | ON |
    | storage_engine | InnoDB |
    | stored_program_cache | 256 |
    | strict_password_validation | ON |
    | sync_binlog | 0 |
    | sync_frm | ON |
    | sync_master_info | 10000 |
    | sync_relay_log | 10000 |
    | sync_relay_log_info | 10000 |
    | system_time_zone | UTC |
    | system_versioning_alter_history | ERROR |
    | system_versioning_asof | DEFAULT |
    | table_definition_cache | 8192 |
    | table_open_cache | 4096 |
    | table_open_cache_instances | 8 |
    | tcp_keepalive_interval | 0 |
    | tcp_keepalive_probes | 0 |
    | tcp_keepalive_time | 0 |
    | thread_cache_size | 256 |
    | thread_concurrency | 10 |
    | thread_pool_idle_timeout | 60 |
    | thread_pool_max_threads | 65536 |
    | thread_pool_oversubscribe | 3 |
    | thread_pool_prio_kickup_timer | 1000 |
    | thread_pool_priority | auto |
    | thread_pool_size | 4 |
    | thread_pool_stall_limit | 500 |
    | thread_stack | 299008 |
    | time_format | %H:%i:%s |
    | time_zone | SYSTEM |
    | timed_mutexes | OFF |
    | tmp_disk_table_size | 18446744073709551615 |
    | tmp_memory_table_size | 268435456 |
    | tmp_table_size | 268435456 |
    | tmpdir | /home/mysqltmp |
    | transaction_alloc_block_size | 8192 |
    | transaction_prealloc_size | 4096 |
    | tx_read_only | OFF |
    | unique_checks | ON |
    | updatable_views_with_limit | YES |
    | use_stat_tables | NEVER |
    | userstat | OFF |
    | version_comment | MariaDB Server |
    | version_compile_machine | x86_64 |
    | version_compile_os | Linux |
    | version_malloc_library | system |
    | version_source_revision | a36fc80aeb3f835fad02f443d65dc608b74b92d1 |
    | version_ssl_library | OpenSSL 1.1.1k FIPS 25 Mar 2021 |
    | wait_timeout | 1800 |
    | wsrep_osu_method | TOI |
    | wsrep_auto_increment_control | ON |
    | wsrep_causal_reads | OFF |
    | wsrep_certification_rules | strict |
    | wsrep_certify_nonpk | ON |
    | wsrep_cluster_address | |
    | wsrep_cluster_name | my_wsrep_cluster |
    | wsrep_convert_lock_to_trx | OFF |
    | wsrep_data_home_dir | /var/lib/mysql/ |
    | wsrep_dbug_option | |
    | wsrep_debug | OFF |
    | wsrep_desync | OFF |
    | wsrep_dirty_reads | OFF |
    | wsrep_drupal_282555_workaround | OFF |
    | wsrep_forced_binlog_format | NONE |
    | wsrep_gtid_domain_id | 0 |
    | wsrep_gtid_mode | OFF |
    | wsrep_load_data_splitting | ON |
    | wsrep_log_conflicts | OFF |
    | wsrep_max_ws_rows | 0 |
    | wsrep_max_ws_size | 2147483647 |
    | wsrep_mysql_replication_bundle | 0 |
    | wsrep_node_address | |
    | wsrep_node_incoming_address | AUTO |
    | wsrep_notify_cmd | |
    | wsrep_on | OFF |
    | wsrep_patch_version | wsrep_25.24 |
    | wsrep_provider | none |
    | wsrep_provider_options | |
    | wsrep_recover | OFF |
    | wsrep_reject_queries | NONE |
    | wsrep_replicate_myisam | OFF |
    | wsrep_restart_slave | OFF |
    | wsrep_retry_autocommit | 1 |
    | wsrep_slave_fk_checks | ON |
    | wsrep_slave_uk_checks | OFF |
    | wsrep_slave_threads | 1 |
    | wsrep_sst_auth | |
    | wsrep_sst_donor | |
    | wsrep_sst_donor_rejects_queries | OFF |
    | wsrep_sst_method | rsync |
    | wsrep_sst_receive_address | AUTO |
    | wsrep_sync_wait | 0 |
    
    mysqladmin ext
    | Variable_name | Value |
    | Aborted_clients | 0 |
    | Aborted_connects | 0 |
    | Access_denied_errors | 0 |
    | Acl_column_grants | 0 |
    | Acl_database_grants | 2 |
    | Acl_function_grants | 0 |
    | Acl_procedure_grants | 0 |
    | Acl_package_spec_grants | 0 |
    | Acl_package_body_grants | 0 |
    | Acl_proxy_users | 2 |
    | Acl_role_grants | 0 |
    | Acl_roles | 0 |
    | Acl_table_grants | 0 |
    | Acl_users | 4 |
    | Aria_pagecache_blocks_not_flushed | 0 |
    | Aria_pagecache_blocks_unused | 7852 |
    | Aria_pagecache_blocks_used | 0 |
    | Aria_pagecache_read_requests | 0 |
    | Aria_pagecache_reads | 0 |
    | Aria_pagecache_write_requests | 0 |
    | Aria_pagecache_writes | 0 |
    | Aria_transaction_log_syncs | 0 |
    | Binlog_commits | 0 |
    | Binlog_group_commits | 0 |
    | Binlog_group_commit_trigger_count | 0 |
    | Binlog_group_commit_trigger_lock_wait | 0 |
    | Binlog_group_commit_trigger_timeout | 0 |
    | Binlog_snapshot_file | |
    | Binlog_snapshot_position | 0 |
    | Binlog_bytes_written | 0 |
    | Binlog_cache_disk_use | 0 |
    | Binlog_cache_use | 0 |
    | Binlog_stmt_cache_disk_use | 0 |
    | Binlog_stmt_cache_use | 0 |
    | Busy_time | 0.000000 |
    | Bytes_received | 9471 |
    | Bytes_sent | 163504 |
    | Column_compressions | 0 |
    | Column_decompressions | 0 |
    | Com_admin_commands | 7 |
    | Com_alter_db | 0 |
    | Com_alter_db_upgrade | 0 |
    | Com_alter_event | 0 |
    | Com_alter_function | 0 |
    | Com_alter_procedure | 0 |
    | Com_alter_server | 0 |
    | Com_alter_sequence | 0 |
    | Com_alter_table | 0 |
    | Com_alter_tablespace | 0 |
    | Com_alter_user | 0 |
    | Com_analyze | 0 |
    | Com_assign_to_keycache | 0 |
    | Com_begin | 0 |
    | Com_binlog | 0 |
    | Com_call_procedure | 0 |
    | Com_change_db | 0 |
    | Com_change_master | 0 |
    | Com_check | 0 |
    | Com_checksum | 0 |
    | Com_commit | 0 |
    | Com_compound_sql | 0 |
    | Com_create_db | 0 |
    | Com_create_event | 0 |
    | Com_create_function | 0 |
    | Com_create_index | 0 |
    | Com_create_package | 0 |
    | Com_create_package_body | 0 |
    | Com_create_procedure | 0 |
    | Com_create_role | 0 |
    | Com_create_sequence | 0 |
    | Com_create_server | 0 |
    | Com_create_table | 0 |
    | Com_create_temporary_table | 0 |
    | Com_create_trigger | 0 |
    | Com_create_udf | 0 |
    | Com_create_user | 0 |
    | Com_create_view | 0 |
    | Com_dealloc_sql | 0 |
    | Com_delete | 0 |
    | Com_delete_multi | 0 |
    | Com_do | 0 |
    | Com_drop_db | 0 |
    | Com_drop_event | 0 |
    | Com_drop_function | 0 |
    | Com_drop_index | 0 |
    | Com_drop_procedure | 0 |
    | Com_drop_package | 0 |
    | Com_drop_package_body | 0 |
    | Com_drop_role | 0 |
    | Com_drop_server | 0 |
    | Com_drop_sequence | 0 |
    | Com_drop_table | 0 |
    | Com_drop_temporary_table | 0 |
    | Com_drop_trigger | 0 |
    | Com_drop_user | 0 |
    | Com_drop_view | 0 |
    | Com_empty_query | 0 |
    | Com_execute_immediate | 0 |
    | Com_execute_sql | 0 |
    | Com_flush | 0 |
    | Com_get_diagnostics | 0 |
    | Com_grant | 0 |
    | Com_grant_role | 0 |
    | Com_ha_close | 0 |
    | Com_ha_open | 0 |
    | Com_ha_read | 0 |
    | Com_help | 0 |
    | Com_insert | 0 |
    | Com_insert_select | 0 |
    | Com_install_plugin | 0 |
    | Com_kill | 0 |
    | Com_load | 0 |
    | Com_lock_tables | 0 |
    | Com_multi | 0 |
    | Com_optimize | 0 |
    | Com_preload_keys | 0 |
    | Com_prepare_sql | 0 |
    | Com_purge | 0 |
    | Com_purge_before_date | 0 |
    | Com_release_savepoint | 0 |
    | Com_rename_table | 0 |
    | Com_rename_user | 0 |
    | Com_repair | 0 |
    | Com_replace | 0 |
    | Com_replace_select | 0 |
    | Com_reset | 0 |
    | Com_resignal | 0 |
    | Com_revoke | 0 |
    | Com_revoke_all | 0 |
    | Com_revoke_role | 0 |
    | Com_rollback | 0 |
    | Com_rollback_to_savepoint | 0 |
    | Com_savepoint | 0 |
    | Com_select | 11 |
    | Com_set_option | 8 |
    | Com_show_authors | 0 |
    | Com_show_binlog_events | 0 |
    | Com_show_binlogs | 0 |
    | Com_show_charsets | 0 |
    | Com_show_collations | 0 |
    | Com_show_contributors | 0 |
    | Com_show_create_db | 0 |
    | Com_show_create_event | 0 |
    | Com_show_create_func | 0 |
    | Com_show_create_package | 0 |
    | Com_show_create_package_body | 0 |
    | Com_show_create_proc | 0 |
    | Com_show_create_table | 0 |
    | Com_show_create_trigger | 0 |
    | Com_show_create_user | 0 |
    | Com_show_databases | 3 |
    | Com_show_engine_logs | 0 |
    | Com_show_engine_mutex | 0 |
    | Com_show_engine_status | 4 |
    | Com_show_errors | 0 |
    | Com_show_events | 0 |
    | Com_show_explain | 0 |
    | Com_show_fields | 0 |
    | Com_show_function_status | 0 |
    | Com_show_generic | 0 |
    | Com_show_grants | 0 |
    | Com_show_keys | 0 |
    | Com_show_master_status | 0 |
    | Com_show_open_tables | 0 |
    | Com_show_package_status | 0 |
    | Com_show_package_body_status | 0 |
    | Com_show_plugins | 0 |
    | Com_show_privileges | 0 |
    | Com_show_procedure_status | 0 |
    | Com_show_processlist | 0 |
    | Com_show_profile | 0 |
    | Com_show_profiles | 0 |
    | Com_show_relaylog_events | 0 |
    | Com_show_slave_hosts | 0 |
    | Com_show_slave_status | 0 |
    | Com_show_status | 10 |
    | Com_show_storage_engines | 0 |
    | Com_show_table_status | 0 |
    | Com_show_tables | 0 |
    | Com_show_triggers | 0 |
    | Com_show_variables | 4 |
    | Com_show_warnings | 0 |
    | Com_shutdown | 0 |
    | Com_signal | 0 |
    | Com_start_all_slaves | 0 |
    | Com_start_slave | 0 |
    | Com_stmt_close | 0 |
    | Com_stmt_execute | 0 |
    | Com_stmt_fetch | 0 |
    | Com_stmt_prepare | 0 |
    | Com_stmt_reprepare | 0 |
    | Com_stmt_reset | 0 |
    | Com_stmt_send_long_data | 0 |
    | Com_stop_all_slaves | 0 |
    | Com_stop_slave | 0 |
    | Com_truncate | 0 |
    | Com_uninstall_plugin | 0 |
    | Com_unlock_tables | 0 |
    | Com_update | 0 |
    | Com_update_multi | 0 |
    | Com_xa_commit | 0 |
    | Com_xa_end | 0 |
    | Com_xa_prepare | 0 |
    | Com_xa_recover | 0 |
    | Com_xa_rollback | 0 |
    | Com_xa_start | 0 |
    | Compression | OFF |
    | Connection_errors_accept | 0 |
    | Connection_errors_internal | 0 |
    | Connection_errors_max_connections | 0 |
    | Connection_errors_peer_address | 0 |
    | Connection_errors_select | 0 |
    | Connection_errors_tcpwrap | 0 |
    | Connections | 40 |
    | Cpu_time | 0.000000 |
    | Created_tmp_disk_tables | 0 |
    | Created_tmp_files | 5 |
    | Created_tmp_tables | 24 |
    | Delayed_errors | 0 |
    | Delayed_insert_threads | 0 |
    | Delayed_writes | 0 |
    | Delete_scan | 0 |
    | Empty_queries | 1 |
    | Executed_events | 0 |
    | Executed_triggers | 0 |
    | Feature_check_constraint | 0 |
    | Feature_custom_aggregate_functions | 0 |
    | Feature_delay_key_write | 0 |
    | Feature_dynamic_columns | 0 |
    | Feature_fulltext | 0 |
    | Feature_gis | 0 |
    | Feature_invisible_columns | 0 |
    | Feature_json | 0 |
    | Feature_locale | 0 |
    | Feature_subquery | 0 |
    | Feature_system_versioning | 0 |
    | Feature_timezone | 0 |
    | Feature_trigger | 0 |
    | Feature_window_functions | 0 |
    | Feature_xml | 0 |
    | Flush_commands | 1 |
    | Handler_commit | 1 |
    | Handler_delete | 0 |
    | Handler_discover | 0 |
    | Handler_external_lock | 0 |
    | Handler_icp_attempts | 0 |
    | Handler_icp_match | 0 |
    | Handler_mrr_init | 0 |
    | Handler_mrr_key_refills | 0 |
    | Handler_mrr_rowid_refills | 0 |
    | Handler_prepare | 0 |
    | Handler_read_first | 3 |
    | Handler_read_key | 0 |
    | Handler_read_last | 0 |
    | Handler_read_next | 0 |
    | Handler_read_prev | 0 |
    | Handler_read_retry | 0 |
    | Handler_read_rnd | 0 |
    | Handler_read_rnd_deleted | 0 |
    | Handler_read_rnd_next | 4729 |
    | Handler_rollback | 0 |
    | Handler_savepoint | 0 |
    | Handler_savepoint_rollback | 0 |
    | Handler_tmp_delete | 0 |
    | Handler_tmp_update | 0 |
    | Handler_tmp_write | 4686 |
    | Handler_update | 0 |
    | Handler_write | 0 |
    | Innodb_buffer_pool_dump_status | |
    | Innodb_buffer_pool_load_status | Buffer pool(s) load completed at 220322 15:29:25 |
    | Innodb_buffer_pool_resize_status | |
    | Innodb_buffer_pool_load_incomplete | OFF |
    | Innodb_buffer_pool_pages_data | 307 |
    | Innodb_buffer_pool_bytes_data | 5029888 |
    | Innodb_buffer_pool_pages_dirty | 0 |
    | Innodb_buffer_pool_bytes_dirty | 0 |
    | Innodb_buffer_pool_pages_flushed | 131 |
    | Innodb_buffer_pool_pages_free | 32461 |
    | Innodb_buffer_pool_pages_misc | 0 |
    | Innodb_buffer_pool_pages_total | 32768 |
    | Innodb_buffer_pool_read_ahead_rnd | 0 |
    | Innodb_buffer_pool_read_ahead | 0 |
    | Innodb_buffer_pool_read_ahead_evicted | 0 |
    | Innodb_buffer_pool_read_requests | 1635 |
    | Innodb_buffer_pool_reads | 177 |
    | Innodb_buffer_pool_wait_free | 0 |
    | Innodb_buffer_pool_write_requests | 843 |
    | Innodb_data_fsyncs | 2 |
    | Innodb_data_pending_fsyncs | 0 |
    | Innodb_data_pending_reads | 0 |
    | Innodb_data_pending_writes | 0 |
    | Innodb_data_read | 2968064 |
    | Innodb_data_reads | 192 |
    | Innodb_data_writes | 133 |
    | Innodb_data_written | 2147328 |
    | Innodb_dblwr_pages_written | 0 |
    | Innodb_dblwr_writes | 0 |
    | Innodb_log_waits | 0 |
    | Innodb_log_write_requests | 0 |
    | Innodb_log_writes | 1 |
    | Innodb_os_log_fsyncs | 2 |
    | Innodb_os_log_pending_fsyncs | 0 |
    | Innodb_os_log_pending_writes | 0 |
    | Innodb_os_log_written | 512 |
    | Innodb_page_size | 16384 |
    | Innodb_pages_created | 131 |
    | Innodb_pages_read | 176 |
    | Innodb_pages0_read | 5 |
    | Innodb_pages_written | 131 |
    | Innodb_row_lock_current_waits | 0 |
    | Innodb_row_lock_time | 0 |
    | Innodb_row_lock_time_avg | 0 |
    | Innodb_row_lock_time_max | 0 |
    | Innodb_row_lock_waits | 0 |
    | Innodb_rows_deleted | 0 |
    | Innodb_rows_inserted | 0 |
    | Innodb_rows_read | 0 |
    | Innodb_rows_updated | 0 |
    | Innodb_system_rows_deleted | 0 |
    | Innodb_system_rows_inserted | 0 |
    | Innodb_system_rows_read | 0 |
    | Innodb_system_rows_updated | 0 |
    | Innodb_num_open_files | 8 |
    | Innodb_truncated_status_writes | 0 |
    | Innodb_available_undo_logs | 128 |
    | Innodb_undo_truncations | 0 |
    | Innodb_page_compression_saved | 0 |
    | Innodb_num_index_pages_written | 0 |
    | Innodb_num_non_index_pages_written | 0 |
    | Innodb_num_pages_page_compressed | 0 |
    | Innodb_num_page_compressed_trim_op | 0 |
    | Innodb_num_pages_page_decompressed | 0 |
    | Innodb_num_pages_page_compression_error | 0 |
    | Innodb_num_pages_encrypted | 0 |
    | Innodb_num_pages_decrypted | 0 |
    | Innodb_have_lz4 | OFF |
    | Innodb_have_lzo | OFF |
    | Innodb_have_lzma | ON |
    | Innodb_have_bzip2 | OFF |
    | Innodb_have_snappy | OFF |
    | Innodb_have_punch_hole | ON |
    | Innodb_defragment_compression_failures | 0 |
    | Innodb_defragment_failures | 0 |
    | Innodb_defragment_count | 0 |
    | Innodb_instant_alter_column | 0 |
    | Innodb_onlineddl_rowlog_rows | 0 |
    | Innodb_onlineddl_rowlog_pct_used | 0 |
    | Innodb_onlineddl_pct_progress | 0 |
    | Innodb_secondary_index_triggered_cluster_reads | 0 |
    | Innodb_secondary_index_triggered_cluster_reads_avoided | 0 |
    | Innodb_encryption_rotation_pages_read_from_cache | 0 |
    | Innodb_encryption_rotation_pages_read_from_disk | 0 |
    | Innodb_encryption_rotation_pages_modified | 0 |
    | Innodb_encryption_rotation_pages_flushed | 0 |
    | Innodb_encryption_rotation_estimated_iops | 0 |
    | Innodb_encryption_key_rotation_list_length | 0 |
    | Innodb_encryption_n_merge_blocks_encrypted | 0 |
    | Innodb_encryption_n_merge_blocks_decrypted | 0 |
    | Innodb_encryption_n_rowlog_blocks_encrypted | 0 |
    | Innodb_encryption_n_rowlog_blocks_decrypted | 0 |
    | Innodb_encryption_n_temp_blocks_encrypted | 0 |
    | Innodb_encryption_n_temp_blocks_decrypted | 0 |
    | Innodb_scrub_background_page_reorganizations | 0 |
    | Innodb_scrub_background_page_splits | 0 |
    | Innodb_scrub_background_page_split_failures_underflow | 0 |
    | Innodb_scrub_background_page_split_failures_out_of_filespace | 0 |
    | Innodb_scrub_background_page_split_failures_missing_index | 0 |
    | Innodb_scrub_background_page_split_failures_unknown | 0 |
    | Innodb_scrub_log | 0 |
    | Innodb_encryption_num_key_requests | 0 |
    | Key_blocks_not_flushed | 0 |
    | Key_blocks_unused | 214334 |
    | Key_blocks_used | 0 |
    | Key_blocks_warm | 0 |
    | Key_read_requests | 0 |
    | Key_reads | 0 |
    | Key_write_requests | 0 |
    | Key_writes | 0 |
    | Last_query_cost | 0.000000 |
    | Master_gtid_wait_count | 0 |
    | Master_gtid_wait_time | 0 |
    | Master_gtid_wait_timeouts | 0 |
    | Max_statement_time_exceeded | 0 |
    | Max_used_connections | 1 |
    | Memory_used | 425816152 |
    | Memory_used_initial | 424591832 |
    | Not_flushed_delayed_rows | 0 |
    | Open_files | 59 |
    | Open_streams | 0 |
    | Open_table_definitions | 31 |
    | Open_tables | 31 |
    | Opened_files | 121 |
    | Opened_plugin_libraries | 3 |
    | Opened_table_definitions | 31 |
    | Opened_tables | 38 |
    | Opened_views | 0 |
    | Performance_schema_accounts_lost | 0 |
    | Performance_schema_cond_classes_lost | 0 |
    | Performance_schema_cond_instances_lost | 0 |
    | Performance_schema_digest_lost | 0 |
    | Performance_schema_file_classes_lost | 0 |
    | Performance_schema_file_handles_lost | 0 |
    | Performance_schema_file_instances_lost | 0 |
    | Performance_schema_hosts_lost | 0 |
    | Performance_schema_locker_lost | 0 |
    | Performance_schema_mutex_classes_lost | 0 |
    | Performance_schema_mutex_instances_lost | 0 |
    | Performance_schema_rwlock_classes_lost | 0 |
    | Performance_schema_rwlock_instances_lost | 0 |
    | Performance_schema_session_connect_attrs_lost | 0 |
    | Performance_schema_socket_classes_lost | 0 |
    | Performance_schema_socket_instances_lost | 0 |
    | Performance_schema_stage_classes_lost | 0 |
    | Performance_schema_statement_classes_lost | 0 |
    | Performance_schema_table_handles_lost | 0 |
    | Performance_schema_table_instances_lost | 0 |
    | Performance_schema_thread_classes_lost | 0 |
    | Performance_schema_thread_instances_lost | 0 |
    | Performance_schema_users_lost | 0 |
    | Prepared_stmt_count | 0 |
    | Qcache_free_blocks | 1 |
    | Qcache_free_memory | 83868256 |
    | Qcache_hits | 0 |
    | Qcache_inserts | 0 |
    | Qcache_lowmem_prunes | 0 |
    | Qcache_not_cached | 11 |
    | Qcache_queries_in_cache | 0 |
    | Qcache_total_blocks | 1 |
    | Queries | 70 |
    | Questions | 70 |
    | Rows_read | 12 |
    | Rows_sent | 4602 |
    | Rows_tmp_read | 4684 |
    | Rpl_semi_sync_master_clients | 0 |
    | Rpl_semi_sync_master_get_ack | 0 |
    | Rpl_semi_sync_master_net_avg_wait_time | 0 |
    | Rpl_semi_sync_master_net_wait_time | 0 |
    | Rpl_semi_sync_master_net_waits | 0 |
    | Rpl_semi_sync_master_no_times | 0 |
    | Rpl_semi_sync_master_no_tx | 0 |
    | Rpl_semi_sync_master_request_ack | 0 |
    | Rpl_semi_sync_master_status | OFF |
    | Rpl_semi_sync_master_timefunc_failures | 0 |
    | Rpl_semi_sync_master_tx_avg_wait_time | 0 |
    | Rpl_semi_sync_master_tx_wait_time | 0 |
    | Rpl_semi_sync_master_tx_waits | 0 |
    | Rpl_semi_sync_master_wait_pos_backtraverse | 0 |
    | Rpl_semi_sync_master_wait_sessions | 0 |
    | Rpl_semi_sync_master_yes_tx | 0 |
    | Rpl_semi_sync_slave_send_ack | 0 |
    | Rpl_semi_sync_slave_status | OFF |
    | Rpl_status | AUTH_MASTER |
    | Rpl_transactions_multi_engine | 0 |
    | Select_full_join | 0 |
    | Select_full_range_join | 0 |
    | Select_range | 0 |
    | Select_range_check | 0 |
    | Select_scan | 24 |
    | Slave_connections | 0 |
    | Slave_heartbeat_period | 0.000 |
    | Slave_open_temp_tables | 0 |
    | Slave_received_heartbeats | 0 |
    | Slave_retried_transactions | 0 |
    | Slave_running | OFF |
    | Slave_skipped_errors | 0 |
    | Slaves_connected | 0 |
    | Slaves_running | 0 |
    | Slow_launch_threads | 0 |
    | Slow_queries | 0 |
    | Sort_merge_passes | 0 |
    | Sort_priority_queue_sorts | 0 |
    | Sort_range | 0 |
    | Sort_rows | 0 |
    | Sort_scan | 0 |
    | Ssl_accept_renegotiates | 0 |
    | Ssl_accepts | 0 |
    | Ssl_callback_cache_hits | 0 |
    | Ssl_cipher | |
    | Ssl_cipher_list | |
    | Ssl_client_connects | 0 |
    | Ssl_connect_renegotiates | 0 |
    | Ssl_ctx_verify_depth | 0 |
    | Ssl_ctx_verify_mode | 0 |
    | Ssl_default_timeout | 0 |
    | Ssl_finished_accepts | 0 |
    | Ssl_finished_connects | 0 |
    | Ssl_server_not_after | |
    | Ssl_server_not_before | |
    | Ssl_session_cache_hits | 0 |
    | Ssl_session_cache_misses | 0 |
    | Ssl_session_cache_mode | NONE |
    | Ssl_session_cache_overflows | 0 |
    | Ssl_session_cache_size | 0 |
    | Ssl_session_cache_timeouts | 0 |
    | Ssl_sessions_reused | 0 |
    | Ssl_used_session_cache_entries | 0 |
    | Ssl_verify_depth | 0 |
    | Ssl_verify_mode | 0 |
    | Ssl_version | |
    | Subquery_cache_hit | 0 |
    | Subquery_cache_miss | 0 |
    | Syncs | 4 |
    | Table_locks_immediate | 18 |
    | Table_locks_waited | 0 |
    | Table_open_cache_active_instances | 1 |
    | Table_open_cache_hits | 43 |
    | Table_open_cache_misses | 38 |
    | Table_open_cache_overflows | 0 |
    | Tc_log_max_pages_used | 0 |
    | Tc_log_page_size | 4096 |
    | Tc_log_page_waits | 0 |
    | Threadpool_idle_threads | 0 |
    | Threadpool_threads | 0 |
    | Threads_cached | 0 |
    | Threads_connected | 1 |
    | Threads_created | 2 |
    | Threads_running | 4 |
    | Transactions_gtid_foreign_engine | 0 |
    | Transactions_multi_engine | 0 |
    | Update_scan | 0 |
    | Uptime | 5877 |
    | Uptime_since_flush_status | 5877 |
    | wsrep_applier_thread_count | 0 |
    | wsrep_cluster_conf_id | 18446744073709551615 |
    | wsrep_cluster_size | 0 |
    | wsrep_cluster_state_uuid | |
    | wsrep_cluster_status | Disconnected |
    | wsrep_connected | OFF |
    | wsrep_local_bf_aborts | 0 |
    | wsrep_local_index | 18446744073709551615 |
    | wsrep_provider_name | |
    | wsrep_provider_vendor | |
    | wsrep_provider_version | |
    | wsrep_ready | OFF |
    | wsrep_rollbacker_thread_count | 0 |
    | wsrep_thread_count | 0 |
    
    ------------------------------------------------------------------
    mysqlreport
    MariaDB 10.3.34-MariaDB     uptime 0 1:37:57    Tue Mar 22 17:07:22 2022
    
    __ Key _________________________________________________________________
    Buffer used         0 of  256.00M   %Used:   0.00
      Current      46.69M              %Usage:  18.24
    Write hit       0.00%
    Read hit        0.00%
    
    __ Questions ___________________________________________________________
    Total              80       0.0/s
      COM_QUIT         40       0.0/s  %Total:  50.00
      Com_             39       0.0/s           48.75
      DMS              17       0.0/s           21.25
      -Unknown         16       0.0/s           20.00
    Slow 1 s            0         0/s            0.00  %DMS:   0.00 Log:
    DMS                17       0.0/s           21.25
      SELECT           17       0.0/s           21.25        100.00
      INSERT            0         0/s            0.00          0.00
      REPLACE           0         0/s            0.00          0.00
      UPDATE            0         0/s            0.00          0.00
      DELETE            0         0/s            0.00          0.00
    Com_               39       0.0/s           48.75
      show_status      11       0.0/s           13.75
      set_option        8       0.0/s           10.00
      admin_comma       8       0.0/s           10.00
    
    __ Rows ________________________________________________________________
    Rows            5.30k       0.9/s
      Using idx         3       0.0/s  %Index:   0.06
    Rows/question   66.30
    
    __ SELECT and Sort _____________________________________________________
    Scan               32       0.0/s %SELECT: 188.24
    Range               0         0/s            0.00
    Full join           0         0/s            0.00
    Range check         0         0/s            0.00
    Full rng join       0         0/s            0.00
    Sort scan           0         0/s
    Sort range          0         0/s
    Sort mrg pass       0         0/s
    
    __ Query Cache _________________________________________________________
    Memory usage   17.41k of   80.00M  %Usage:   0.02
    Block Fragmnt 100.00%
    Hits                0         0/s
    Inserts             1       0.0/s
    Insrt:Prune       1:1         0/s
    Hit:Insert     0.00:1
    
    __ Table Locks _________________________________________________________
    Waited              0         0/s  %Total:   0.00
    Immediate          18       0.0/s
    
    __ Tables ______________________________________________________________
    Open               31 of   4096    %Cache:   0.76
    Opened             38       0.0/s
    
    __ Connections _________________________________________________________
    Max used            1 of    350      %Max:   0.29
    Total              42       0.0/s
    
    __ Created Temp ________________________________________________________
    Disk table          0         0/s   %Disk:   0.00
    Table              32       0.0/s    Size: 256.0M
    File                5       0.0/s
    
    __ Threads _____________________________________________________________
    Running             4 of      1
    Created             2       0.0/s
    Slow                0         0/s
    Cached              0 of    256      %Hit:  95.24
    
    __ Aborted _____________________________________________________________
    Clients             0         0/s
    Connects            0         0/s
    
    __ Bytes _______________________________________________________________
    Sent          180.18k      30.7/s
    Received       10.59k       1.8/s
    
    __ InnoDB Buffer Pool __________________________________________________
    Usage           4.80M of  512.00M  %Usage:   0.94
    Read hit       89.17%
    Pages
      Free         32.46k              %Total:  99.06
      Data            307                        0.94  %Drty:   0.00
      Misc              0                        0.00
      Latched           0                        0.00
    Reads           1.64k       0.3/s
      From disk       177       0.0/s   %Disk:  10.83
      Ahead Rnd         0         0/s
    Writes            843       0.1/s
    Flushes           131       0.0/s
    Wait Free           0         0/s   %Wait:   0.00
    
    __ InnoDB Lock _________________________________________________________
    Waits               0         0/s
    Current             0
    Time acquiring
      Total             0 ms
      Average           0 ms
      Max               0 ms
    
    __ InnoDB Data, Pages, Rows ____________________________________________
    Data
      Reads           192       0.0/s
      Writes          133       0.0/s
      fsync             2       0.0/s
      Pending
        Reads           0
        Writes          0
        fsync           0
    
    Pages
      Created         131       0.0/s
      Read            176       0.0/s
      Written         131       0.0/s
    
    Rows
      Deleted           0         0/s
      Inserted          0         0/s
      Read              0         0/s
      Updated           0         0/s
    
    __ Aria Pagecache ______________________________________________________
    Buffer used         0 of   64.00M   %Used:   0.00
      Current       2.66M              %Usage:   4.15
    Write hit       0.00%
    Read hit        0.00%
    
    ------------------------------------------------------------------
    pidstat -durh 1 10 | sed -e "s|$(hostname)|hostname|g"
    ...
    Linux 4.18.0-348.20.1.el8_5.x86_64 (hostname)   03/22/2022      _x86_64_        (4 CPU)
    
    # Time        UID       PID    %usr %system  %guest   %wait    %CPU   CPU  minflt/s  majflt/s     VSZ     RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s iodelay  Command
    05:07:23 PM     0     28214    0.00    0.00    0.00    0.00    0.00     2    919.80      0.00  222728    5176   0.06      0.00      0.00      0.00       0  pidstat
    05:07:23 PM     0     41291    0.00    0.00    0.00    0.00    0.00     2      5.94      0.00  567896   19028   0.23      0.00      0.00      0.00       0  php-fpm
    
    # Time        UID       PID    %usr %system  %guest   %wait    %CPU   CPU  minflt/s  majflt/s     VSZ     RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s iodelay  Command
    05:07:24 PM     0     28214    0.00    0.00    0.00    0.00    0.00     2    106.00      0.00  222728    5704   0.07      0.00      0.00      0.00       0  pidstat
    
    # Time        UID       PID    %usr %system  %guest   %wait    %CPU   CPU  minflt/s  majflt/s     VSZ     RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s iodelay  Command
    05:07:25 PM     0         1    0.00    0.00    0.00    0.00    0.00     0      1.00      0.00  172536   11036   0.14      0.00      0.00      0.00       0  systemd
    05:07:25 PM     0       349    1.00    0.00    0.00    0.00    1.00     2      0.00      0.00   12372    7604   0.09      0.00      0.00      0.00       0  haveged
    05:07:25 PM     0       642    0.00    0.00    0.00    0.00    0.00     2      0.00      0.00   77012    1940   0.02      0.00      8.00      0.00       0  auditd
    05:07:25 PM     0      3886    1.00    0.00    0.00    0.00    1.00     1    854.00      0.00  309268   33448   0.41      0.00      0.00      0.00       0  lfd - sleeping
    05:07:25 PM     0     27496    1.00    0.00    0.00    0.00    1.00     2      0.00      0.00       0       0   0.00      0.00      0.00      0.00       0  kworker/2:0-mm_percpu_wq
    05:07:25 PM     0     28214    0.00    1.00    0.00    0.00    1.00     2      0.00      0.00  222728    5704   0.07      0.00      0.00      0.00       0  pidstat
    
    # Time        UID       PID    %usr %system  %guest   %wait    %CPU   CPU  minflt/s  majflt/s     VSZ     RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s iodelay  Command
    
    # Time        UID       PID    %usr %system  %guest   %wait    %CPU   CPU  minflt/s  majflt/s     VSZ     RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s iodelay  Command
    05:07:27 PM     0     28214    0.00    1.00    0.00    0.00    1.00     2      0.00      0.00  222728    5704   0.07      0.00      0.00      0.00       0  pidstat
    
    # Time        UID       PID    %usr %system  %guest   %wait    %CPU   CPU  minflt/s  majflt/s     VSZ     RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s iodelay  Command
    
    # Time        UID       PID    %usr %system  %guest   %wait    %CPU   CPU  minflt/s  majflt/s     VSZ     RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s iodelay  Command
    05:07:29 PM     0     28214    1.00    0.00    0.00    0.00    1.00     2      0.00      0.00  222728    5704   0.07      0.00      0.00      0.00       0  pidstat
    
    # Time        UID       PID    %usr %system  %guest   %wait    %CPU   CPU  minflt/s  majflt/s     VSZ     RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s iodelay  Command
    05:07:30 PM   992      1242    0.00    1.00    0.00    0.00    1.00     1      0.00      0.00 2264500  171804   2.11      0.00      0.00      0.00       0  mysqld
    05:07:30 PM     0     28214    0.00    1.00    0.00    0.00    1.00     2      0.00      0.00  222728    5704   0.07      0.00      0.00      0.00       0  pidstat
    
    # Time        UID       PID    %usr %system  %guest   %wait    %CPU   CPU  minflt/s  majflt/s     VSZ     RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s iodelay  Command
    
    # Time        UID       PID    %usr %system  %guest   %wait    %CPU   CPU  minflt/s  majflt/s     VSZ     RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s iodelay  Command
    05:07:32 PM     0       499    0.00    1.00    0.00    0.00    1.00     0      0.00      0.00       0       0   0.00      0.00      0.00      0.00       0  xfsaild/vda2
    
    ------------------------------------------------------------------
     CPU Utilisation % Last 7 days (4 CPU Threads):
    ------------------------------------------------------------------
    %CPU  min:  %user:  0.02   %nice:  0.00  %system:  0.02   %iowait:  0.00  %steal:  0.00  %idle:  6.28
    %CPU  avg:  %user:  15.49  %nice:  0.29  %system:  7.92   %iowait:  0.22  %steal:  0.01  %idle:  76.08
    %CPU  max:  %user:  84.36  %nice:  5.47  %system:  40.60  %iowait:  7.16  %steal:  0.17  %idle:  99.96
    %CPU  50%:  %user:  12.14  %nice:  0.00  %system:  2.91   %iowait:  0.03  %steal:  0.00  %idle:  75.57
    %CPU  75%:  %user:  21.81  %nice:  0.00  %system:  11.41  %iowait:  0.20  %steal:  0.02  %idle:  99.81
    %CPU  90%:  %user:  44.35  %nice:  0.56  %system:  22.97  %iowait:  0.52  %steal:  0.03  %idle:  99.94
    %CPU  95%:  %user:  56.58  %nice:  2.22  %system:  31.92  %iowait:  0.66  %steal:  0.04  %idle:  99.95
    %CPU  99%:  %user:  67.13  %nice:  4.56  %system:  39.54  %iowait:  1.81  %steal:  0.11  %idle:  99.96
    
    ------------------------------------------------------------------
     CPU Utilisation % Daily Last 7 days (4 CPU Threads):
    ------------------------------------------------------------------
    Mar 22 2022 %CPU
    %CPU  min:  %user:  0.02   %nice:  0.00  %system:  0.02   %iowait:  0.00  %steal:  0.00  %idle:  6.28
    %CPU  avg:  %user:  15.49  %nice:  0.29  %system:  7.92   %iowait:  0.22  %steal:  0.01  %idle:  76.08
    %CPU  max:  %user:  84.36  %nice:  5.47  %system:  40.60  %iowait:  7.16  %steal:  0.17  %idle:  99.96
    %CPU  95%:  %user:  56.58  %nice:  2.22  %system:  31.92  %iowait:  0.66  %steal:  0.04  %idle:  99.95
    
    ------------------------------------------------------------------
     Memory Usage Daily Last 7 days (4 CPU Threads):
    ------------------------------------------------------------------
    
    Mar 22 2022 Memory
    Memory      min:                                                                                 
    kbmemfree:  2273096.0  kbmemused:  6263364.0  %memused:  624428.0   kbbuffers:  7.7        kbcached:  0.0
    kbcommit:   136856.0   %commit:    334936.0   kbactive:  4.1        kbinact:    51872.0    kbdirty:   331512.0
    Memory      avg:                                                                                 
    kbmemfree:  4825857.2  kbmemused:  6843080.0  %memused:  3298940.0  kbbuffers:  40.6       kbcached:  1693.7
    kbcommit:   2178754.0  %commit:    1486704.4  kbactive:  16.3       kbinact:    761020.6   kbdirty:   1718507.9
    Memory      max:                                                                                 
    kbmemfree:  7500552.0  kbmemused:  7465376.0  %memused:  5851884.0  kbbuffers:  72.0       kbcached:  2104.0
    kbcommit:   5163812.0  %commit:    1830136.0  kbactive:  20.0       kbinact:    1403060.0  kbdirty:   4081576.0
    Memory      95%:                                                                                 
    kbmemfree:  6323688.0  kbmemused:  7453428.0  %memused:  5820144.0  kbbuffers:  71.6       kbcached:  2104.0
    kbcommit:   4922754.0  %commit:    1791328.0  kbactive:  19.5       kbinact:    1358912.0  kbdirty:   3931182.0
    ------------------------------------------------------------------
    Stats saved at: /root/centminlogs/cminfo-top-220322-170710.log
    ------------------------------------------------------------------
    
    


    Additional testing and fixes required to get optional Nginx modules and features enabled

    Tests to switch from Nginx PCRE 8.45 to PCRE2 10.39 with Nginx modules enabled for njs, brotli and geoip2 lite and video related modules.

    Set in persistent config file /etc/centminmod/custom_config.inc
    Code (Text):
    NGINX_PCRE_TWO='y'
    NGINX_VIDEO='y'
    NGINX_NJS='y'
    NGXDYNAMIC_NJS='y'
    NGXDYNAMIC_BROTLI='y'
    NGINX_LIBBROTLI='y'
    NGINX_GEOIPTWOLITE='y'
    NGXDYNAMIC_GEOIPTWOLITE='y'
    

    where NGINX_VIDEO enables modules for
    Code (Text):
      NGINX_SLICE='y'
      NGINX_RTMP='y'
      NGINX_FLV='y'
      NGINX_MP4='y'
    

    Resulting Nginx server configuration on AlmaLinux 8.5 system
     
    Last edited: Mar 23, 2022
  13. eva2000

    eva2000 Administrator Staff Member

    48,863
    11,174
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,407
    Local Time:
    3:28 PM
    Nginx 1.21.x
    MariaDB 10.x
    Next up preview for Rocky Linux 8.5 tests :)

    Code (Text):
    uname -r
    4.18.0-348.20.1.el8_5.x86_64
    
    cat /etc/os-release 
    NAME="Rocky Linux"
    VERSION="8.5 (Green Obsidian)"
    ID="rocky"
    ID_LIKE="rhel centos fedora"
    VERSION_ID="8.5"
    PLATFORM_ID="platform:el8"
    PRETTY_NAME="Rocky Linux 8.5 (Green Obsidian)"
    ANSI_COLOR="0;32"
    CPE_NAME="cpe:/o:rocky:rocky:8:GA"
    HOME_URL="https://rockylinux.org/"
    BUG_REPORT_URL="https://bugs.rockylinux.org/"
    ROCKY_SUPPORT_PRODUCT="Rocky Linux"
    ROCKY_SUPPORT_PRODUCT_VERSION="8"
    
    cat /etc/redhat-release 
    Rocky Linux release 8.5 (Green Obsidian)
    
    cat /etc/rocky-release
    Rocky Linux release 8.5 (Green Obsidian)
    
    cat /etc/centminmod-release 
    123.09beta01-el8.5.b804
    

    Nginx with GCC 10.3.1 with OpenSSL 1.1.1n
    Code (Text):
    php -v
    PHP 7.4.28 (cli) (built: Mar 24 2022 09:12:34) ( NTS )
    Copyright (c) The PHP Group
    Zend Engine v3.4.0, Copyright (c) Zend Technologies
        with Zend OPcache v7.4.28, Copyright (c), by Zend Technologies
    

    Code (Text):
    mysqladmin ver
    mysqladmin  Ver 9.1 Distrib 10.3.34-MariaDB, for Linux on x86_64
    Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
    
    Server version          10.3.34-MariaDB
    Protocol version        10
    Connection              Localhost via UNIX socket
    UNIX socket             /var/lib/mysql/mysql.sock
    Uptime:                 25 min 58 sec
    
    Threads: 4  Questions: 1  Slow queries: 0  Opens: 18  Flush tables: 1  Open tables: 11  Queries per second avg: 0.000
    
    

    Tests to switch from Nginx PCRE 8.45 to PCRE2 10.39 with Nginx modules enabled for njs, brotli and geoip2 lite and video related modules.

    Set in persistent config file /etc/centminmod/custom_config.inc
    Code (Text):
    NGINX_PCRE_TWO='y'
    NGINX_VIDEO='y'
    NGINX_NJS='y'
    NGXDYNAMIC_NJS='y'
    NGXDYNAMIC_BROTLI='y'
    NGINX_LIBBROTLI='y'
    NGINX_GEOIPTWOLITE='y'
    NGXDYNAMIC_GEOIPTWOLITE='y'


    where NGINX_VIDEO enables modules for
    Code (Text):
      NGINX_SLICE='y'
      NGINX_RTMP='y'
      NGINX_FLV='y'
      NGINX_MP4='y'
    

    Resulting Nginx server configuration on Rocky Linux 8.5 system
     
  14. eva2000

    eva2000 Administrator Staff Member

    48,863
    11,174
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +17,407
    Local Time:
    3:28 PM
    Nginx 1.21.x
    MariaDB 10.x
Thread Status:
Not open for further replies.