Centmin Mod CentOS 8 Compatibility Worklog

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 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

• https://community.centminmod.com/centos8/
• https://community.centminmod.com/almalinux/
• https://community.centminmod.com/rockylinux/

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

• Official CentOS 8 Documentation
• Manuals/ReleaseNotes/CentOS8.1905 - CentOS Wiki
• 8.0 release notes Red Hat Enterprise Linux 8 | Red Hat Customer Portal
• YUM Package replacement list for CentOS 8/ RedHat 8

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.

---

 

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.

 

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

 

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.

 

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.

 

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

 

There might be some network performance slowness with CentOS 8 and CSF configurations which need to be investigated as well.

 

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.

 

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:

• Github commits https://github.com/centminmod/centminmod/commits/123.09beta01-el8.3
• Github branch comparison between 123.09beta01 vs 123.09beta01-el8.3

 

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.

 

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.

 

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

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

 

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

 

Getting closer https://community.centminmod.com/threads/alma-linux-8-5-centmin-mod-test-installation-details.22575/

 

The last few days AlmaLinux 8 and AlmaLinux 9 compatibility testing for Centmin Mod 130.00beta01 branch has been ramping up. Some notes on some decisions I've made

1. EL8 will default to GCC 11.2 for compilation routines instead of the current Centmin Mod 130.00beta01 default for GCC 10.2 and EL8 system default GCC 8.5
2. EL8 will default to PHP 8.0.x installation (PHP-FPM) and stick with MariaDB 10.3 Official YUM repo
3. EL9 is already default to GCC 11.2 for compilation routines
   
4. EL9 will default to PHP 8.1.x installation (PHP-FPM) and use MariaDB 10.6 LTS Official YUM repo and also default the MariaDB MySQL 10.6 character set and collation to utf8mb4 via enabling variable SET_DEFAULT_MYSQLCHARSET='utf8mb4'

Example for Centmin Mod Nginx built using GCC 11.2 with OpenSSL 1.1.1 on Rocky Linux 8, AlmaLinux 8 and AlmaLinux 9

Rocky Linux 8

Code (Text):

nginx -V
nginx version: nginx/1.23.1 (310822-163951-rockylinux8-kvm-2341d4a)
built by gcc 11.2.1 20220127 (Red Hat 11.2.1-9) (GCC) 
built with OpenSSL 1.1.1q  5 Jul 2022

AlmaLinux 8

Code (Text):

nginx -V
nginx version: nginx/1.23.1 (310822-162241-almalinux8-kvm-2341d4a)
built by gcc 11.2.1 20220127 (Red Hat 11.2.1-9) (GCC) 
built with OpenSSL 1.1.1q  5 Jul 2022

AlmaLinux 9

Code (Text):

nginx -V
nginx version: nginx/1.23.1 (310822-024725-almalinux9-kvm-a198187)
built by gcc 11.2.1 20220127 (Red Hat 11.2.1-9) (GCC) 
built with OpenSSL 1.1.1q  5 Jul 2022

 

Centmin Mod Terraformed

I've discovered the wonders and power of using Terraform for provisioning and automation. This makes automating EL8/EL9 testing a lot easier.

1. I can even spin up a premade Centmin Mod custom OS image ready to use in <2 minutes I am using Upcloud's Terraform provider and example at https://github.com/centminmod/upcloud-terraform. If you also want to try Upcloud Terraform for yourself, you can sign up for Upcloud via my referral link, and you'll get US$25 free credit to play with yourself, and after you make your first US$10 deposit payment, I'll get a US$50 referral bonus which I'll use towards my testing
2. I can also use Terraform to spin up custom Centmin Mod installations with scripts to build my EL7/EL8/EL9 custom YUM RPM packages + automate the setup of my own Centmin Mod YUM repo mirrors. The ways I can use Terraform are pretty endless

For now, I'm using Terraform at Upcloud. But later on, will build Terraform scripts for Linode, DigitalOcean, Hetzner and Vultr. As all these providers have their own Terraform provider support.

This compatibility testing for EL8 and EL9 OS is costing $$$$ so if you can spare some $$$ to support this, it would be much appreciated

FYI, the past 3+ days, I've done a total of 150+ Centmin Mod installations to both get Centmin Mod installs ready for Terraform compatibility + also for EL8 and EL9 OS compatibility testing and OS provisioning

 

Updated EL8 compatibility for Centmin Mod due to switching EL8 MariaDB 10.3 to EL8 native Appstream module provided version.

1. Centmin Mod EL8 installs will default to GCC 11.2 for compilation routines instead of the current Centmin Mod 130.00beta01 default for GCC 10.2 and EL8 system default GCC 8.5
2. Centmin Mod EL8 installs will default to PHP 8.0.x installation (PHP-FPM)
3. Centmin Mod EL8 installs as of September 27, 2022, onwards (in private beta testing), will switch from the official MariaDB YUM repo provided MariaDB 10.3 which has support ending May 2023 to the native EL8 Appstream module provided MariaDB 10.3 version which has extended support until May 2029

Note that native EL8 Appstream MariaDB 10.3's YUM package names are different from the official MariaDB YUM repo's YUM package names.

EL8 Appstream MariaDB 10.3's YUM package name

Code (Text):

rpm -qa mariadb*
mariadb-server-utils-10.3.35-1.module_el8.6.0+3265+230ed96b.x86_64
mariadb-connector-c-3.1.11-2.el8_3.x86_64
mariadb-errmsg-10.3.35-1.module_el8.6.0+3265+230ed96b.x86_64
mariadb-server-10.3.35-1.module_el8.6.0+3265+230ed96b.x86_64
mariadb-backup-10.3.35-1.module_el8.6.0+3265+230ed96b.x86_64
mariadb-10.3.35-1.module_el8.6.0+3265+230ed96b.x86_64
mariadb-gssapi-server-10.3.35-1.module_el8.6.0+3265+230ed96b.x86_64
mariadb-connector-c-config-3.1.11-2.el8_3.noarch
mariadb-common-10.3.35-1.module_el8.6.0+3265+230ed96b.x86_64

official MariaDB YUM repo's YUM package names

Code (Text):

rpm -qa MariaDB*
MariaDB-devel-10.3.36-1.el8.x86_64
MariaDB-shared-10.3.36-1.el8.x86_64
MariaDB-server-10.3.36-1.el8.x86_64
MariaDB-client-10.3.36-1.el8.x86_64
MariaDB-common-10.3.36-1.el8.x86_64

 

Been working on Centmin Mod's Github automated workflow testing

 

Sharing some of the behind the scenes work I've been doing on Centmin Mod's EL8/EL9 compatibility testing using Github Workflow automated actions. The testing now allows me to do 100s of automated tests installing Centmin Mod 130.00beta01's private EL8/EL9 compatible installer on AlmaLinux 8/9, RockyLinux 8/9 and Oracle Linux 8/9 and has already helped me find and fix quite a few EL8/EL9 related bugs for Centmin Mod

I posted some automated testing screenshots for one test which installs Centmin Mod on AlmaLinux 8, RockyLinux 8 and Oracle Linux 8 concurrently on 3 servers and runs through a whole suite of tests for various Centmin Mod features - including centmin.sh menu option 4 and 5 routines for compiling Nginx with OpenSSL 1.1.1, OpenSSL 3.0, BoringSSQL, QuicTLS and also compiling PHP 8.0, 8.1, 8.2 and 8.3

Some of the automated testing done for AlmaLinux 8 part shown below. For the rest check out https://community.centminmod.com/media/albums/centmin-mod-el8-el9-automated-tests.21/. These extensive automated tests will help me speed up EL8/EL9 compatibility testing and development for Centmin Mod - allowing to properly test 3 different OSes for AlmaLinux, RockyLinux and OracleLinux



Example for automated testing on Nginx built with OpenSSL 3.0 - soon to be the default for Centmin Mod 130.00beta01 as OpenSSL 1.1.1 is EOL

 

FYI, public AlmaLinux 8 and Rocky Linux 8 beta testing is now open to all https://community.centminmod.com/th...almalinux-8-rocky-linux-8-beta-testing.24227/

I expect lots of testing and feedback