/ Register

Welcome to Centmin Mod Community
Become a Member

Wordpress Wordpress Slow Save Times - Struggling To Find Fault

Discussion in 'Blogs & CMS usage' started by JamesJamz, May 5, 2020.

Previous Thread Next Thread
Loading...
  1. May 5, 2020 #1
    JamesJamz

    JamesJamz New Member

    21
    2
    3
    May 4, 2020
    UK
    Ratings:
    +3
    Local Time:
    1:15 AM
    10.4
    Hi All,

    I've been looking all over the place to figure out the issue and its driving me mad now, everything is lightning fast, apart from when saving a WooCommerce product, which has a lot of text attached, 10 images and full product attributes.

    Now I was hitting a max child limit, and I increased that just to get the product(s) saved, but for some reason, its taking like 60-200 seconds to save, and I cannot for the life of me figure out what limits its hitting or why its taking so long to save.

    Server is a VPS with 8GB RAM. Running Centmin Mod (Nginx/MariaDB/PHP7.3) set up the whole website with the Wordpress configurator within Centmin Mod.

    I'm pretty much running the default build, but modified PHP-FPM thinking it was this, but its still the same.

    Code:
    pm = ondemand
; Default was 30 - JS
pm.max_children = 50
; Default Value: min_spare_servers + (max_spare_servers - min_spare_servers) / 2
; Default Start Servers was 8
pm.start_servers = 15
; Defailt Min Spare was 4
pm.min_spare_servers = 10
; Default Max Spare was 12
pm.max_spare_servers = 20
; Default was 5000
pm.max_requests = 200
    Also added the following into the NGINX conf for the domain
    Code:
     fastcgi_buffers 8 16k; # increase the buffer size for PHP-FTP
  fastcgi_buffer_size 32k; # increase the buffer size for PHP-FTP
  fastcgi_connect_timeout 60;
  fastcgi_send_timeout 300;
  fastcgi_read_timeout 300;
    But this has made no difference at all.

    I'm not sure what else to check. Any help is much appreciated.
     
  2. May 5, 2020 #2
    Saahib

    Saahib Member

    38
    2
    8
    Oct 8, 2017
    Ratings:
    +6
    Local Time:
    5:45 AM
    1.13
    10.2
    What about checking mysql status while save, try mytop.
     
  3. May 5, 2020 #3
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    10:15 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    How is cpu load during this time ? If running Centmin Mod 123.09beta01 or higher, you will have access to a cminfo top command which can also provide a summary of statistics - some of which are explained in info and linked articles below.

    FYI, CPU load optimal is 1.0 per cpu thread so 8 cpu thread normal = 8x1 = 8.0. 16 cpu server normal is 16x1 = 16.0

    so cpu load of 8 for
    • 2 cpu server = 8/2 = 4.0 load average
    • 4 cpu server = 8/4 = 2.0 load average
    • 8 cpu server = 8/8 = 1.0 load average
    When you type top command, hit number 1 to break down per cpu stats

    Centmin Mod is provided as is, so troubleshooting load issues is left to end user to do. However, there's many linux tools and scripts that can help you figure out what was causing the load issues and when.

    If you're providing info on this forum, more info might be helpful
    1. What version of Centmin Mod ? .08 stable or .09 beta ? If .09 beta when was it installed and when was last time you updated ?
    2. What's your VPS/Server hardware specifications ? cpu type ? memory available ? disk space ?
    3. Who's your web host ? Different hosts have different limits for server resource usage and some are more restrictive that others so it could just be their resource usage policy you tripped which may or may not be restrictive. If restrictive, then real solution would be finding a better web host. If not restrictive, then it's finding out what caused high cpu load.
    4. If running Centmin Mod 123.09beta01 or higher, you will have access to a cminfo top command which can also provide a summary of statistics - some of which are explained in info and linked articles below.
    Tools and commands you will want to read up on and learn for basic system admin tasks and troubleshooting.
    Notes:
    For example some commands which are also available automatically when you run cminfo top command
    Code (Text):
    top -bn1

    Code (Text):
    ps aufxw

    Code (Text):
    sar -q

    Code (Text):
    sar -r

    Code (Text):
    sar -q -f /var/log/sa/sa$(date +%d -d yesterday)

    Code (Text):
    sar -r -f /var/log/sa/sa$(date +%d -d yesterday)

    If you want to look at per process usage stats use pidstat run pidstat every 1 sec for 5 runs and sed is just to replace your main hostname with word hostname so mask your domain for posting on public places
    Code (Text):
    pidstat -durh 1 5 | sed -e "s|$(hostname)|hostname|g"

    for posting code you might want to use CODE tags for code How to use forum BBCODE code tags :)
     
  4. May 7, 2020 #4
    JamesJamz

    JamesJamz New Member

    21
    2
    3
    May 4, 2020
    UK
    Ratings:
    +3
    Local Time:
    1:15 AM
    10.4
    It looks like the database does start to go over 120% CPU when saving these large products, but mysqltuner isn't really showing anything to optimise out the ordinary from what I can see. I've been checking it over for the past few days, and cannot see anything out of the blue. I've tried the cminfo top (posted below).

    It may well be MySQL but I think I've been staring at it for that long, the issue may be staring me in my face, but just cannot see it.


    Code:
    ------------------------------------------------------------------

------------------------------------------------------------------
 Centmin Mod Top Info:
------------------------------------------------------------------
 Server Location Info

  city: Moffat
  region: Scotland
  country: GB
  timezone: Europe/London
  ASN: AS48254 20i Limited

 Processors physical = 6, cores = 6, virtual = 6, hyperthreading = no

      6  2399.996
      6  Intel Core Processor (Broadwell)
      6  4096 KB

 System Up Since:     2020-04-27 21:56:53
 System Uptime:     up 1 week, 1 day, 20 hours, 37 minutes
 MySQL Server Started     2020-04-27 21:56:32
 MySQL Uptime:         8 days 20 hours 37 min 53 sec
 MySQL Uptime (secs):     765473
 Server Type:         kvm
 CentOS Version:     7.8
 Centmin Mod:         123.09beta01.b500
 Nginx PageSpeed:     OFF
 Nginx Version:     1.17.10 (270420-193209-centos7-kvm-b5de03e)
 PHP-FPM Version:     7.3.17
 MariaDB Version:     10.3.22
 CSF Firewall:         v14.02
 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:           7820        2589        2051         357        3179        4582
Low:           7820        5769        2051
High:             0           0           0
Swap:           614         101         513
Total:         8435        2691        2564

------------------------------------------------------------------
top 10 processes using swap (VmSwap)

      1666 mysqld                                     51548 kB
       873 tuned                                       9604 kB
       576 polkitd                                     4060 kB
       646 NetworkManager                              1336 kB
       572 haveged                                     1044 kB
       872 sshd                                         924 kB
      1697 qmgr                                         828 kB
       607 rngd                                         804 kB
       943 memcached                                    736 kB
       428 systemd-udevd                                652 kB

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

      1666 mysqld                                   5147704 kB
     19868 php-fpm                                   836208 kB
     20461 php-fpm                                   833904 kB
     22237 php-fpm                                   832740 kB
     22358 php-fpm                                   824556 kB
     23669 php-fpm                                   744120 kB
     60544 php-fpm                                   714404 kB
       576 polkitd                                   612400 kB
       873 tuned                                     574356 kB
     65097 glances                                   570072 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
 1666 mysql    /usr/sbin/mysqld               51548  1146292  1146373  1147612
60489 nginx    nginx: worker process              0    44016    54145    84228
60490 nginx    nginx: worker process              0    44020    54128    84188
60488 nginx    nginx: worker process              0    43940    54063    84140
19868 nginx    php-fpm: pool www                  0    36520    39451    50828
20461 nginx    php-fpm: pool www                  0    35340    38263    49608
22237 nginx    php-fpm: pool www                  0    32948    34793    44932
65097 root     /usr/bin/python2 /usr/bin/g        0    37792    39072    41996
23669 nginx    php-fpm: pool www                  0    30360    31594    39416
22358 nginx    php-fpm: pool www                  0    26376    28219    38356
60487 root     nginx: master process /usr/        0      512     9748    37656
  395 root     /usr/lib/systemd/systemd-jo      180     3336    14451    34464
34747 root     lfd - sleepin                      0    23316    23345    24108
  880 root     /usr/sbin/rsyslogd -n          25540     2352     9440    21576
60544 root     php-fpm: master process (/u        0     2256     3364    10172
24225 root     python /usr/bin/smem -rt -s        0     6972     7632     9192
60318 root     sshd: root@pts/0                   0     2456     3284     6088
  576 polkitd  /usr/lib/polkit-1/polkitd -     4060     2900     3179     4512
 6543 postfix  pickup -l -t unix -u               0     1900     2319     4200
  873 root     /usr/bin/python2 -Es /usr/s     9604     1760     1988     3452
    1 root     /usr/lib/systemd/systemd --      160     2420     2464     3340
60324 root     -bash                              0     1532     1821     3096
24279 postfix  tlsmgr -l -t unix -u               0     1564     1615     2732
  572 root     /usr/sbin/haveged -w 4067 -     1044     2140     2157     2676
  646 root     /usr/sbin/NetworkManager --     1336      796     1082     2588
 1499 root     pure-ftpd (SERVER)                 0     1432     1468     2256
23727 root     /bin/bash /usr/bin/cminfo t        0      236      625     1832
  578 dbus     /usr/bin/dbus-daemon --syst      268      608      710     1676
 1697 postfix  qmgr -l -t unix -u               828      396      433     1496
  872 root     /usr/sbin/sshd -D                924      100      192     1424
  609 root     /usr/lib/systemd/systemd-lo      140      564      587     1392
23767 root     /bin/bash /usr/bin/cminfo t        0      372      666     1388
 1661 root     /usr/libexec/postfix/master      644      536      558     1384
  583 chrony   /usr/sbin/chronyd                232      384      411     1268
  616 root     /usr/sbin/crond -n               264      456      473     1192
  943 memcached /usr/local/bin/memcached -d      736      528      539      984
  607 root     /sbin/rngd -f                    804       60       87      912
  428 root     /usr/lib/systemd/systemd-ud      652       48       68      844
  612 root     /usr/bin/qemu-ga --method=v      352        4       45      836
  603 root     /usr/sbin/irqbalance --fore      160      128      151      800
  904 root     /sbin/agetty --noclear tty1        0      128      142      704
  548 root     /sbin/auditd                     324      184      199      692
  907 root     /sbin/agetty --keep-baud 11        0      128      141      688
23768 root     tee /root/centminlogs/cminf        0      124      155      680
  647 root     /usr/sbin/acpid                  132        4       12      304
-------------------------------------------------------------------------------
   45 8                                       99932  1540236  1615652  1857908

------------------------------------------------------------------
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  385M  3.5G  10% /run
tmpfs          tmpfs     3.9G     0  3.9G   0% /sys/fs/cgroup
/dev/vda4      xfs       149G   13G  137G   9% /
/dev/loop0     ext4      5.8G   25M  5.5G   1% /tmp
/dev/vda2      xfs      1014M  235M  780M  24% /boot
tmpfs          tmpfs     783M     0  783M   0% /run/user/0

------------------------------------------------------------------
php-fpm stats
PHP-FPM pm = ondemand in /usr/local/etc/php-fpm.conf
PHP-FPM memory usage only viewable when pm = static

Ready to handle connections
pool:                 www
process manager:      ondemand
start time:           06/May/2020:18:34:28 +0000
start since:          1
accepted conn:        2
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

no times found that >= 6.00

------------------------------------------------------------------
Filter sar -q for times cpu load avg (5min) hit/exceeded cpu threads max

no times found that >= 6.00

------------------------------------------------------------------
sar -q | sed -e "s|$(hostname)|hostname|g"
Linux 3.10.0-1127.el7.x86_64 (hostname)     05/06/2020     _x86_64_    (6 CPU)

12:00:01 AM   runq-sz  plist-sz   ldavg-1   ldavg-5  ldavg-15   blocked
12:05:01 AM         3       225      0.11      0.11      0.08         0
12:10:01 AM         1       233      0.90      0.62      0.31         0
12:15:01 AM         0       216      0.27      0.55      0.38         0
12:20:01 AM         0       217      0.10      0.35      0.35         0
12:25:01 AM         0       217      0.04      0.17      0.28         0
12:30:01 AM         0       215      0.03      0.12      0.22         0
12:35:01 AM         0       216      0.35      0.18      0.22         0
12:40:01 AM         0       217      0.06      0.13      0.20         0
12:45:01 AM         0       218      0.16      0.15      0.19         0
12:50:01 AM         0       217      0.12      0.14      0.18         0
12:55:01 AM         0       218      0.06      0.12      0.15         0
01:00:01 AM         1       220      0.09      0.11      0.13         0
01:05:01 AM         0       217      0.17      0.14      0.14         0
01:10:01 AM         0       216      0.23      0.20      0.16         0
01:15:01 AM         1       220      0.27      0.16      0.15         0
01:20:01 AM         1       225      0.87      0.72      0.41         0
01:25:01 AM         2       221      0.23      0.43      0.37         0
01:30:01 AM         0       220      0.13      0.27      0.32         0
01:35:01 AM         0       217      0.15      0.21      0.28         0
01:40:01 AM         4       218      0.24      0.19      0.25         0
01:45:01 AM         0       216      0.45      0.26      0.25         0
01:50:01 AM         0       217      0.11      0.20      0.22         0
01:55:01 AM         1       217      0.30      0.15      0.19         0
02:00:01 AM         0       216      0.03      0.11      0.16         0
02:05:02 AM         0       218      0.16      0.10      0.14         0
02:10:01 AM         0       218      0.09      0.08      0.12         0
02:15:01 AM         0       217      0.07      0.12      0.13         0
02:20:01 AM         0       217      0.04      0.10      0.13         0
02:25:01 AM         0       216      0.02      0.08      0.12         0
02:30:01 AM         0       218      0.11      0.09      0.12         0
02:35:01 AM         2       218      0.11      0.12      0.13         0
02:40:01 AM         0       216      0.11      0.11      0.13         0
02:45:01 AM         0       217      0.07      0.12      0.13         0
02:50:01 AM         0       217      0.14      0.11      0.13         0
02:55:01 AM         0       217      0.11      0.14      0.14         0
03:00:01 AM         0       212      0.10      0.11      0.13         0
03:05:01 AM         0       216      0.03      0.07      0.12         0
03:10:01 AM         0       212      0.12      0.11      0.13         0
03:15:01 AM         1       217      0.00      0.04      0.10         0
03:20:01 AM         0       213      0.33      0.13      0.12         0
03:25:01 AM         0       213      0.07      0.08      0.10         0
03:30:01 AM         0       213      0.06      0.13      0.13         0
03:35:01 AM         0       213      0.03      0.09      0.13         0
03:40:01 AM         0       214      0.04      0.11      0.13         0
03:45:01 AM         0       213      0.13      0.12      0.13         0
03:50:01 AM         0       213      0.16      0.13      0.14         0
03:55:01 AM         0       216      0.16      0.20      0.18         0
04:00:02 AM         0       216      0.11      0.14      0.15         1
04:05:01 AM         0       214      0.18      0.16      0.14         0
04:10:01 AM         0       213      0.06      0.11      0.13         0
04:15:01 AM         0       213      0.03      0.14      0.14         0
04:20:01 AM         0       213      0.15      0.10      0.13         0
04:25:01 AM         0       214      0.11      0.14      0.14         0
04:30:01 AM         0       214      0.47      0.20      0.16         0
04:35:01 AM         0       214      0.24      0.30      0.22         0
04:40:01 AM         0       214      0.07      0.19      0.20         0
04:45:01 AM         0       213      0.02      0.10      0.16         0
04:50:01 AM         0       213      0.12      0.10      0.14         0
04:55:01 AM         0       215      0.12      0.19      0.18         0
05:00:01 AM         0       214      0.20      0.21      0.19         0
05:05:01 AM         0       215      0.19      0.16      0.17         0
05:10:01 AM         0       213      0.22      0.20      0.17         0
05:15:01 AM         0       214      0.14      0.19      0.17         0
05:20:01 AM         0       215      0.06      0.21      0.20         0
05:25:01 AM         1       215      0.46      0.38      0.27         0
05:30:01 AM         1       216      0.36      0.39      0.31         0
05:35:01 AM         0       216      0.37      0.41      0.34         0
05:40:01 AM         0       215      0.59      0.49      0.40         0
05:45:01 AM         1       214      0.39      0.53      0.45         0
05:50:02 AM         1       215      0.38      0.36      0.39         0
05:55:01 AM         0       215      0.02      0.18      0.31         0
06:00:01 AM         3       216      0.85      0.55      0.43         0
06:05:01 AM         0       213      0.43      0.70      0.55         0
06:10:01 AM         0       216      1.34      0.98      0.70         0
06:15:01 AM         2       217      1.20      1.02      0.78         0
06:20:01 AM         1       216      0.74      0.88      0.79         0
06:25:01 AM         1       217      0.90      0.71      0.73         0
06:30:01 AM         2       215      0.17      0.56      0.68         0
06:35:01 AM         1       214      0.08      0.30      0.54         0
06:40:01 AM         0       215      0.27      0.52      0.59         0
06:45:01 AM         0       214      0.04      0.26      0.46         0
06:50:01 AM         7       215      0.23      0.19      0.37         0
06:55:01 AM         1       213      0.08      0.21      0.34         0
07:00:01 AM         0       214      0.25      0.20      0.30         0
07:05:01 AM         0       214      0.20      0.22      0.28         0
07:10:01 AM         0       213      0.18      0.20      0.26         0
07:15:01 AM         0       215      0.08      0.16      0.22         0
07:20:01 AM         0       212      0.05      0.15      0.21         0
07:25:01 AM         1       214      0.35      0.25      0.24         0
07:30:01 AM         0       212      0.03      0.12      0.19         0
07:35:01 AM         1       213      0.10      0.11      0.16         0
07:40:01 AM         0       212      0.12      0.17      0.17         0
07:45:01 AM         0       213      0.43      0.22      0.18         0
07:50:02 AM         0       213      0.13      0.21      0.19         0
07:55:01 AM         0       210      0.33      0.38      0.27         0
08:00:01 AM         1       218      0.36      0.46      0.34         0
08:05:01 AM         2       216      0.39      0.47      0.39         0
08:10:01 AM         0       213      0.14      0.28      0.33         0
08:15:01 AM         0       210      0.06      0.19      0.29         0
08:20:01 AM         0       210      0.43      0.28      0.29         0
08:25:01 AM         0       210      0.27      0.19      0.24         0
08:30:01 AM         0       210      0.07      0.11      0.20         0
08:35:01 AM         0       211      0.26      0.15      0.19         0
08:40:01 AM         0       212      0.23      0.18      0.18         0
08:45:01 AM         0       211      0.25      0.16      0.16         0
08:50:01 AM         0       210      0.11      0.11      0.14         0
08:55:01 AM         2       211      0.34      0.19      0.16         0
09:00:01 AM         3       213      0.92      0.40      0.23         0
09:05:01 AM         1       215      1.61      1.09      0.57         0
09:10:02 AM         0       210      0.17      0.61      0.52         0
09:15:01 AM         3       212      0.74      0.68      0.57         0
09:20:01 AM         0       212      0.65      0.71      0.62         0
09:25:01 AM         0       210      0.40      0.62      0.61         0
09:30:01 AM         0       212      1.02      0.69      0.63         0
09:35:01 AM         0       212      1.04      0.89      0.73         0
09:40:01 AM         3       212      1.24      1.03      0.82         0
09:45:01 AM         2       212      0.95      0.93      0.84         0
09:50:01 AM         0       212      0.55      0.81      0.83         0
09:55:01 AM         4       216      1.83      0.89      0.81         0
10:00:01 AM         2       211      0.33      0.67      0.77         0
10:05:01 AM         0       211      0.09      0.36      0.60         0
10:10:01 AM         0       210      0.18      0.26      0.50         0
10:15:01 AM         0       210      0.24      0.22      0.40         0
10:20:01 AM         0       211      0.17      0.18      0.34         0
10:25:01 AM         0       209      0.04      0.12      0.27         0
10:30:01 AM         0       210      0.29      0.15      0.23         0
10:35:01 AM         0       211      0.26      0.17      0.22         0
10:40:01 AM         1       212      0.39      0.23      0.24         0
10:45:01 AM         2       211      0.20      0.23      0.23         0
10:50:02 AM         1       210      0.20      0.28      0.25         0
10:55:01 AM         3       212      0.30      0.25      0.24         0
11:00:01 AM         0       211      1.00      0.75      0.47         0
11:05:01 AM         2       213      1.21      1.01      0.65         0
11:10:01 AM         1       211      0.92      1.03      0.77         0
11:15:01 AM         1       212      0.26      0.48      0.60         0
11:20:01 AM         0       209      0.35      0.34      0.50         0
11:25:01 AM         0       208      0.35      0.40      0.48         0
11:30:01 AM         0       213      0.94      0.66      0.57         0
11:35:01 AM         1       211      1.03      0.80      0.63         0
11:40:01 AM         0       213      0.60      0.81      0.70         0
11:45:01 AM         1       210      0.86      0.93      0.79         0
11:50:01 AM         2       211      1.15      0.98      0.84         0
11:55:01 AM         1       210      0.44      0.83      0.83         0
12:00:01 PM         1       214      0.30      0.45      0.66         0
12:05:01 PM         0       212      0.02      0.21      0.50         0
12:10:01 PM         1       227      1.14      0.66      0.60         0
12:15:01 PM         1       245      1.06      0.94      0.74         0
12:20:02 PM         0       234      0.91      1.04      0.85         0
12:25:02 PM         0       224      0.36      0.52      0.67         0
12:30:01 PM         0       225      0.19      0.32      0.54         0
12:35:01 PM         0       222      0.57      0.28      0.45         0
12:40:01 PM         0       222      0.08      0.18      0.36         0
12:45:01 PM         0       220      0.07      0.12      0.29         0
12:50:01 PM         0       221      0.06      0.12      0.24         0
12:55:01 PM         0       223      0.58      0.43      0.34         0
01:00:01 PM         1       228      1.85      0.87      0.52         0
01:05:01 PM         0       222      0.42      0.77      0.58         0
01:10:01 PM         0       224      0.08      0.33      0.45         0
01:15:01 PM         0       221      0.12      0.25      0.38         0
01:20:01 PM         0       221      0.20      0.24      0.33         0
01:25:01 PM         1       224      0.89      0.53      0.44         0
01:30:01 PM         0       222      0.65      0.57      0.46         0
01:35:01 PM         1       223      0.47      0.54      0.48         0
01:40:01 PM         2       225      0.74      0.76      0.59         0
01:45:01 PM         3       224      1.16      0.96      0.72         0
01:50:01 PM         0       224      0.36      0.75      0.72         0
01:55:01 PM         1       222      0.31      0.60      0.68         0
02:00:02 PM         1       224      0.35      0.51      0.63         0
02:05:01 PM         0       222      0.29      0.53      0.63         0
02:10:01 PM         3       224      0.74      0.58      0.61         0
02:15:01 PM         0       223      0.17      0.35      0.51         0
02:20:01 PM         0       221      0.08      0.18      0.39         0
02:25:01 PM         0       220      0.29      0.16      0.32         0
02:30:01 PM         1       222      0.18      0.16      0.28         0
02:35:01 PM         0       222      0.01      0.08      0.21         0
02:40:01 PM         1       225      0.83      0.39      0.30         0
02:45:01 PM         1       220      0.05      0.32      0.31         0
02:50:01 PM         0       222      0.10      0.27      0.30         0
02:55:01 PM         0       221      0.12      0.25      0.30         0
03:00:01 PM         0       220      0.16      0.17      0.25         0
03:05:01 PM         1       224      0.88      0.45      0.33         0
03:10:01 PM         1       222      1.03      0.76      0.48         0
03:15:01 PM         1       222      0.96      0.92      0.63         0
03:20:01 PM         1       222      0.61      0.85      0.69         0
03:25:01 PM         1       221      0.27      0.59      0.63         0
03:30:02 PM         0       222      0.08      0.43      0.57         0
03:35:01 PM         3       223      0.19      0.46      0.56         0
03:40:01 PM         0       220      0.50      0.58      0.59         0
03:45:01 PM         0       222      0.77      0.96      0.76         0
03:50:01 PM         2       222      0.49      0.75      0.74         0
03:55:01 PM         0       224      0.96      0.70      0.70         0
04:00:01 PM         2       229      0.75      0.67      0.69         0
04:05:01 PM         1       227      0.22      0.49      0.61         0
04:10:01 PM         0       224      0.38      0.63      0.67         0
04:15:01 PM         2       223      1.04      0.87      0.77         0
04:20:01 PM         4       225      1.33      0.98      0.84         0
04:25:01 PM         2       225      1.85      1.22      0.97         0
04:30:01 PM         8       231      3.44      2.90      1.79         0
04:35:02 PM         4       258      5.01      3.98      2.54         0
04:40:01 PM         2       290      1.64      2.97      2.54         0
04:45:02 PM         1       248      2.31      2.40      2.40         0
04:50:01 PM         2       252      2.90      2.74      2.56         0
04:55:01 PM         2       256      3.13      2.88      2.65         0
05:00:01 PM         5       257      2.58      2.83      2.68         0
05:05:01 PM         1       244      1.02      1.92      2.37         0
05:10:01 PM         0       242      0.32      1.03      1.87         0
05:15:01 PM         1       243      0.97      0.84      1.54         0
05:20:01 PM         0       244      1.20      0.85      1.33         0
05:25:01 PM         4       244      0.89      0.83      1.19         0
05:30:01 PM         1       243      0.64      0.70      1.03         0
05:35:01 PM         0       245      0.25      0.70      0.97         0
05:40:01 PM         2       245      0.98      0.82      0.94         0
05:45:01 PM         5       246      1.48      1.04      1.00         0
05:50:01 PM         6       248      1.55      1.15      1.04         0
05:55:01 PM         1       244      1.32      1.28      1.13         0
06:00:02 PM         1       244      0.98      0.94      1.02         0
06:05:01 PM         4       246      1.02      1.10      1.07         0
06:10:01 PM         1       247      1.15      1.34      1.20         0
06:15:01 PM         3       250      1.29      1.30      1.23         0
06:20:01 PM         5       250      1.83      1.59      1.38         0
06:25:01 PM         3       246      2.09      1.74      1.47         0
06:30:01 PM         3       246      0.68      0.95      1.20         0
Average:            1       220      0.52      0.53      0.52         0

------------------------------------------------------------------
sar -r | sed -e "s|$(hostname)|hostname|g"
Linux 3.10.0-1127.el7.x86_64 (hostname)     05/06/2020     _x86_64_    (6 CPU)

12:00:01 AM kbmemfree kbmemused  %memused kbbuffers  kbcached  kbcommit   %commit  kbactive   kbinact   kbdirty
12:05:01 AM    232412   7776032     97.10       332   1958092   3400024     39.36   1414324   2005976        16
12:10:01 AM    147540   7860904     98.16       348   1823900   3902512     45.18   1758004   1883988        56
12:15:01 AM    793856   7214588     90.09       348   1756860   3291480     38.10   1318300   1810640         8
12:20:01 AM    772348   7236096     90.36       348   1761564   3305652     38.27   1328260   1814988        12
12:25:01 AM    770784   7237660     90.38       348   1766848   3294836     38.14   1320972   1819172        32
12:30:01 AM    787476   7220968     90.17       348   1772216   3252008     37.65   1293404   1824176        12
12:35:01 AM    749112   7259332     90.65       348   1776444   3290476     38.09   1316800   1827732       580
12:40:01 AM    732148   7276296     90.86       348   1780584   3314080     38.37   1329624   1831476       636
12:45:01 AM    688464   7319980     91.40       348   1784556   3345732     38.73   1362756   1835148         4
12:50:01 AM    708924   7299520     91.15       348   1790168   3309480     38.31   1334332   1840412       252
12:55:01 AM    691552   7316892     91.36       348   1796088   3344352     38.72   1342876   1845556        12
01:00:01 AM    676060   7332384     91.56       348   1801776   3347576     38.75   1347832   1850504        16
01:05:01 AM    685344   7323100     91.44       348   1808852   3289976     38.09   1327464   1857220       420
01:10:01 AM    684516   7323928     91.45       348   1815776   3273460     37.90   1312240   1863520       336
01:15:01 AM    654032   7354412     91.83       348   1820508   3302244     38.23   1332928   1867688        36
01:20:01 AM    136768   7871676     98.29       356   5075500   3317868     38.41   1446248   5012564    403640
01:25:01 AM    121536   7886908     98.48       364   5226980   3354832     38.84   3284484   3360512       708
01:30:01 AM   4993236   3015208     37.65       224    447812   3302832     38.24    808500   1022848        16
01:35:01 AM   4994532   3013912     37.63       224    454496   3290148     38.09    798012   1028716         8
01:40:01 AM   4951792   3056652     38.17       224    462652   3325288     38.50    832004   1036152         0
01:45:01 AM   4965080   3043364     38.00       224    471428   3283748     38.01    795780   1042380       236
01:50:01 AM   4917324   3091120     38.60       224    480468   3326040     38.50    823220   1049404       304
01:55:01 AM   4915420   3093024     38.62       224    485976   3307604     38.29    814320   1054648       592
02:00:01 AM   4900568   3107876     38.81       224    499812   3299264     38.19    815132   1068032       320
02:05:02 AM   4862644   3145800     39.28       224    503964   3338072     38.64    848328   1071504        20
02:10:01 AM   4860952   3147492     39.30       224    508928   3325840     38.50    833944   1076064       296
02:15:01 AM   4857284   3151160     39.35       224    516100   3322312     38.46    834576   1080204         8
02:20:01 AM   4805400   3203044     40.00       224    540376   3332160     38.57    846548   1100884       404
02:25:01 AM   4818432   3190012     39.83       224    544648   3290456     38.09    819836   1103008        20
02:30:01 AM   4741832   3266612     40.79       224    550448   3349864     38.78    885204   1108344       480
02:35:01 AM   4760144   3248300     40.56       224    556996   3328692     38.53    854268   1114488        20
02:40:01 AM   4773808   3234636     40.39       224    569788   3288072     38.06    817132   1126988       304
02:45:01 AM   4772404   3236040     40.41       224    574212   3279184     37.96    808616   1131040        24
02:50:01 AM   4712504   3295940     41.16       224    578232   3327632     38.52    847276   1134700        36
02:55:01 AM   4720148   3288296     41.06       224    582968   3297460     38.17    835412   1138920         8
03:00:01 AM   4711668   3296776     41.17       224    587044   3296384     38.16    835764   1135832       528
03:05:01 AM   4652416   3356028     41.91       224    591484   3356628     38.86    878000   1139516        20
03:10:01 AM   4673256   3335188     41.65       224    595912   3317660     38.41    848540   1143596        20
03:15:01 AM   4633268   3375176     42.15       224    608668   3348900     38.77    870516   1155928       848
03:20:01 AM   4571992   3436452     42.91       232    628480   3305988     38.27    851140   1171660       844
03:25:01 AM   4580772   3427672     42.80       232    630960   3280340     37.97    833908   1174004       420
03:30:01 AM   4589696   3418748     42.69       232    637040   3260764     37.75    814144   1179548        28
03:35:01 AM   4533144   3475300     43.40       232    641112   3306960     38.28    844144   1183040       304
03:40:01 AM   4518500   3489944     43.58       232    647056   3310656     38.33    847164   1188636       288
03:45:01 AM   4486284   3522160     43.98       232    653616   3323548     38.48    861216   1194856         8
03:50:01 AM   4490408   3518036     43.93       232    656592   3315840     38.39    855124   1197440       292
03:55:01 AM   4405968   3602476     44.98       232    662500   3410484     39.48    914456   1202876       260
04:00:02 AM   4513596   3494848     43.64       232    651112   3237816     37.48    839648   1171408        20
04:05:01 AM   4454316   3554128     44.38       232    657376   3296260     38.16    881300   1176404        16
04:10:01 AM   4456796   3551648     44.35       232    662560   3266412     37.81    862936   1181332        24
04:15:01 AM   4448360   3560084     44.45       232    669152   3262392     37.77    859112   1187516        16
04:20:01 AM   4406772   3601672     44.97       232    676204   3295836     38.15    876528   1193904        28
04:25:01 AM   4379132   3629312     45.32       232    682256   3310048     38.32    887776   1199500        28
04:30:01 AM   4382052   3626392     45.28       232    687168   3292004     38.11    873960   1204248        12
04:35:01 AM   4349164   3659280     45.69       232    692760   3322848     38.47    902228   1209316       312
04:40:01 AM   4309576   3698868     46.19       232    697976   3345000     38.72    925576   1214128       308
04:45:01 AM   4366516   3641928     45.48       232    704656   3255544     37.69    857020   1219896       956
04:50:01 AM   4330316   3678128     45.93       232    711120   3284048     38.02    875688   1225680        28
04:55:01 AM   4268408   3740036     46.70       232    720024   3338052     38.64    917440   1233792       596
05:00:01 AM   4276680   3731764     46.60       232    726104   3309644     38.31    892244   1239180       288
05:05:01 AM   4270320   3738124     46.68       232    732216   3315656     38.38    887612   1244664       288
05:10:01 AM   4270536   3737908     46.67       232    739304   3268164     37.83    863596   1250920        28
05:15:01 AM   4213260   3795184     47.39       232    748416   3313324     38.36    900992   1259548        12
05:20:01 AM   4169220   3839224     47.94       232    768776   3342368     38.69    907648   1278820      3088
05:25:01 AM   4128072   3880372     48.45       232    797880   3322692     38.47    909596   1306464      2048
05:30:01 AM   4057516   3950928     49.33       232    826488   3364780     38.95    935264   1333108      1728
05:35:01 AM   3993792   4014652     50.13       232    861852   3383200     39.17    957796   1367032       288
05:40:01 AM   3983628   4024816     50.26       232    891632   3332204     38.58    923492   1395316      2120
05:45:01 AM   3950008   4058436     50.68       232    915724   3337044     38.63    922076   1417760      4336
05:50:02 AM   3918932   4089512     51.07       232    938084   3337676     38.64    925792   1438724       808
05:55:01 AM   3923172   4085272     51.01       232    954016   3290676     38.09    894960   1452900       288
06:00:01 AM   3546276   4462168     55.72       232    974208   3667508     42.46   1234304   1467792      3216
06:05:01 AM   3822784   4185660     52.27       232    986440   3321812     38.45    936032   1478808        12
06:10:01 AM   3408744   4599700     57.44       232    996684   3741012     43.31   1305252   1488060       728
06:15:01 AM   3544240   4464204     55.74       232   1005920   3598008     41.65   1136332   1500476      2752
06:20:01 AM   3697420   4311024     53.83       232   1022964   3396464     39.32    956108   1510728         0
06:25:01 AM   3334660   4673784     58.36       232   1036192   3759696     43.52   1289232   1517036      3916
06:30:01 AM   3663612   4344832     54.25       232   1057132   3371020     39.02    921792   1536320      1300
06:35:01 AM   3730204   4278240     53.42       232   1078312   3253060     37.66    827064   1553044       288
06:40:01 AM   3606548   4401896     54.97       232   1100800   3339212     38.66    904856   1573904        48
06:45:01 AM   3619808   4388636     54.80       232   1108848   3300824     38.21    879936   1580976      1532
06:50:01 AM   3540540   4467904     55.79       232   1117324   3382796     39.16    934080   1588180      1156
06:55:01 AM   3583176   4425268     55.26       232   1126588   3289100     38.08    875880   1595060         0
07:00:01 AM   3545860   4462584     55.72       232   1134236   3322676     38.46    895448   1601740       272
07:05:01 AM   3592384   4416060     55.14       232   1145928   3233536     37.43    828048   1612284        24
07:10:01 AM   3527272   4481172     55.96       232   1157788   3278416     37.95    867920   1623076        20
07:15:01 AM   3471992   4536452     56.65       232   1162328   3338272     38.65    909864   1626780       288
07:20:01 AM   3478940   4529504     56.56       232   1165020   3292200     38.11    886520   1628808        12
07:25:01 AM   3436552   4571892     57.09       232   1170056   3328024     38.53    918456   1633404       788
07:30:01 AM   3505468   4502976     56.23       232   1172216   3245552     37.57    843740   1635044        28
07:35:01 AM   3424316   4584128     57.24       232   1178520   3335180     38.61    913660   1639964       264
07:40:01 AM   3400840   4607604     57.53       232   1184056   3327712     38.52    922584   1644916        24
07:45:01 AM   3394808   4613636     57.61       232   1189240   3335276     38.61    910176   1649328       556
07:50:02 AM   3337136   4671308     58.33       232   1193540   3371996     39.04    954596   1652220        20
07:55:01 AM   3386876   4621568     57.71       232   1196808   3274496     37.91    888004   1655208        28
08:00:01 AM   3347440   4661004     58.20       232   1202704   3319092     38.42    916424   1659328         8
08:05:01 AM   3117228   4891216     61.08       232   1282976   3455432     40.00   1073408   1712744         8
08:10:01 AM   3117332   4891112     61.07       240   1318556   3299492     38.20    979880   1697076        16
08:15:01 AM   3101168   4907276     61.28       240   1324364   3298524     38.19    980408   1701872        12
08:20:01 AM   3072992   4935452     61.63       240   1329152   3315508     38.38    989544   1705368       260
08:25:01 AM   3100760   4907684     61.28       240   1332188   3285740     38.04    954212   1707360         8
08:30:01 AM   3063544   4944900     61.75       240   1338432   3312520     38.35    975976   1712512       752
08:35:01 AM   3078464   4929980     61.56       240   1342060   3281708     37.99    958356   1714812       512
08:40:01 AM   3029704   4978740     62.17       240   1354504   3319844     38.43    979772   1726676       520
08:45:01 AM   3007092   5001352     62.45       240   1357428   3331864     38.57    996092   1729044         4
08:50:01 AM   3010412   4998032     62.41       240   1364572   3305852     38.27    985340   1735500         4
08:55:01 AM   2917088   5091356     63.57       240   1376100   3401476     39.38   1057356   1745880        16
09:00:01 AM   2618660   5389784     67.30       240   1377576   3716580     43.02   1337804   1752960       556
09:05:01 AM   2517012   5491432     68.57       240   1392868   3744368     43.35   1409336   1759648      5104
09:10:02 AM   2878072   5130372     64.06       240   1400208   3336284     38.62   1027584   1766064         4
09:15:01 AM   2721664   5286780     66.02       240   1400020   3496848     40.48   1171860   1769316       240
09:20:01 AM   2782812   5225632     65.25       240   1414040   3392680     39.28   1088780   1774852       280
09:25:01 AM   2798828   5209616     65.05       240   1421348   3351560     38.80   1058192   1780164        20
09:30:01 AM   2666924   5341520     66.70       240   1427568   3485876     40.35   1168876   1785484        20
09:35:01 AM   2546924   5461520     68.20       240   1435604   3578052     41.42   1267264   1792284       328
09:40:01 AM   2643268   5365176     66.99       240   1440476   3443708     39.87   1151688   1796192       300
09:45:01 AM   2493604   5514840     68.86       240   1445068   3598400     41.66   1295680   1802884      2920
09:50:01 AM   2676628   5331816     66.58       240   1456992   3375312     39.07   1092596   1808964       524
09:55:01 AM   2435108   5573336     69.59       240   1460152   3645720     42.20   1312136   1815560      1104
10:00:01 AM   2672944   5335500     66.62       240   1469384   3340440     38.67   1068644   1817784         4
10:05:01 AM   2659212   5349232     66.79       240   1474908   3318776     38.42   1060684   1822472         4
10:10:01 AM   2666288   5342156     66.71       240   1480092   3285220     38.03   1043968   1827072        28
10:15:01 AM   2659020   5349424     66.80       240   1483980   3296712     38.16   1039728   1830268       432
10:20:01 AM   2611516   5396928     67.39       240   1487944   3346400     38.74   1078932   1833456        64
10:25:01 AM   2645920   5362524     66.96       240   1494460   3280636     37.98   1035620   1839156        40
10:30:01 AM   2601484   5406960     67.52       240   1502220   3316072     38.39   1061076   1845880       148
10:35:01 AM   2574484   5433960     67.85       240   1507420   3334460     38.60   1073364   1850304       344
10:40:01 AM   2521516   5486928     68.51       248   1515516   3388952     39.23   1108332   1857516        60
10:45:01 AM   2556100   5452344     68.08       248   1522884   3314948     38.38   1063328   1863944       468
10:50:02 AM   2555800   5452644     68.09       248   1528828   3296728     38.16   1046788   1869052        32
10:55:01 AM   2407124   5601320     69.94       248   1532452   3454464     39.99   1171824   1876936       256
11:00:01 AM   2380732   5627712     70.27       248   1547956   3437148     39.79   1179532   1884464       568
11:05:01 AM   2119868   5888576     73.53       248   1549092   3702308     42.86   1412048   1890372      1396
11:10:01 AM   2293808   5714636     71.36       248   1560644   3473364     40.21   1223900   1894516      3084
11:15:01 AM   2447932   5560512     69.43       248   1565460   3310632     38.33   1056316   1898240       312
11:20:01 AM   2461916   5546528     69.26       248   1572812   3257348     37.71   1027520   1904796         8
11:25:01 AM   2426212   5582232     69.70       248   1581108   3273088     37.89   1043480   1911828         4
11:30:01 AM   2039724   5968720     74.53       248   1538352   3729232     43.17   1453020   1870208      3452
11:35:01 AM   2061512   5946932     74.26       248   1542372   3656300     42.33   1410108   1873980      2256
11:40:01 AM   2132704   5875740     73.37       248   1550124   3574036     41.37   1316144   1879964         4
11:45:01 AM   2306676   5701768     71.20       248   1555196   3350732     38.79   1125516   1884220       292
11:50:01 AM   2180460   5827984     72.77       248   1555920   3488264     40.38   1236816   1889476      1072
11:55:01 AM   2335632   5672812     70.84       248   1568468   3301388     38.22   1061192   1895248       376
12:00:01 PM   2326472   5681972     70.95       248   1579024   3285144     38.03   1056096   1905260      1176
12:05:01 PM   2287408   5721036     71.44       248   1586044   3330832     38.56   1082516   1911656         8
12:10:01 PM   1795700   6212744     77.58       248   1592716   3983112     46.11   1523028   1917064      1224
12:15:01 PM   1396824   6611620     82.56       248   1596956   4455768     51.58   1821672   1920920      1308
12:20:02 PM   1812888   6195556     77.36       248   1606732   3765152     43.59   1338868   1929724      4120
12:25:02 PM   2069644   5938800     74.16       248   1616240   3304936     38.26   1075116   1937828         4
12:30:01 PM   2009360   5999084     74.91       248   1621644   3368040     38.99   1117280   1942492       520
12:35:01 PM   2021368   5987076     74.76       248   1626056   3324748     38.49   1089296   1946084       412
12:40:01 PM   2021264   5987180     74.76       248   1631572   3306668     38.28   1078572   1951040       616
12:45:01 PM   2042464   5965980     74.50       248   1637084   3258912     37.73   1049596   1955812        56
12:50:01 PM   1988560   6019884     75.17       248   1641728   3319308     38.43   1095700   1959728       352
12:55:01 PM   1983760   6024684     75.23       248   1646356   3337036     38.63   1071148   1963448         8
01:00:01 PM   1648968   6359476     79.41       248   1658216   3684708     42.66   1383596   1974760      2152
01:05:01 PM   1966580   6041864     75.44       248   1667272   3285100     38.03   1038912   1981028         8
01:10:01 PM   1910484   6097960     76.14       248   1672288   3358532     38.88   1084152   1985228       256
01:15:01 PM   1957712   6050732     75.55       248   1678568   3266764     37.82   1030012   1990984         8
01:20:01 PM   1940600   6067844     75.77       248   1684200   3267324     37.82   1030944   1995912       620
01:25:01 PM   1525700   6482744     80.95       248   1689044   3699432     42.83   1431264   1999732      1996
01:30:01 PM   1744572   6263872     78.22       248   1698296   3435540     39.77   1200508   2007420         4
01:35:01 PM   1807000   6201444     77.44       248   1703612   3358440     38.88   1125448   2011024        32
01:40:01 PM   1738544   6269900     78.29       248   1716352   3398340     39.34   1157096   2021412       384
01:45:01 PM   1555680   6452764     80.57       248   1720984   3575468     41.39   1317828   2028632      2872
01:50:01 PM   1732476   6275968     78.37       248   1733724   3360336     38.90   1120104   2035640         8
01:55:01 PM   1539112   6469332     80.78       248   1735952   3515144     40.69   1288060   2040588      3288
02:00:02 PM   1706300   6302144     78.69       248   1744128   3357720     38.87   1100608   2037004        72
02:05:01 PM   1748780   6259664     78.16       248   1747676   3262260     37.77   1046108   2039872        20
02:10:01 PM   1398384   6610060     82.54       248   1753340   3631300     42.04   1380776   2046828       780
02:15:01 PM   1691028   6317416     78.88       248   1761956   3280480     37.98   1074024   2052512        20
02:20:01 PM   1639472   6368972     79.53       248   1767204   3327328     38.52   1112560   2057180       260
02:25:01 PM   1664632   6343812     79.21       248   1773028   3280580     37.98   1075916   2062268         8
02:30:01 PM   1577636   6430808     80.30       248   1779852   3369708     39.01   1149036   2067248       956
02:35:01 PM   1586624   6421820     80.19       248   1786392   3347476     38.75   1129220   2071884       752
02:40:01 PM   1449148   6559296     81.90       248   1784872   3495264     40.46   1256292   2075508      1300
02:45:01 PM   1609824   6398620     79.90       248   1796332   3270772     37.86   1080056   2080132         8
02:50:01 PM   1553140   6455304     80.61       248   1804220   3328884     38.54   1116300   2084368       264
02:55:01 PM   1545664   6462780     80.70       248   1818588   3315348     38.38   1103992   2097140       232
03:00:01 PM   1555280   6453164     80.58       248   1824972   3271264     37.87   1081904   2100940         4
03:05:01 PM   1216284   6792160     84.81       248   1825332   3637712     42.11   1409312   2102348      2640
03:10:01 PM   1395748   6612696     82.57       248   1826140   3434096     39.75   1210740   2105776       188
03:15:01 PM   1367968   6640476     82.92       248   1833516   3427720     39.68   1225880   2111336       700
03:20:01 PM   1320076   6688368     83.52       248   1840340   3464268     40.10   1245304   2114424      1308
03:25:01 PM   1405888   6602556     82.44       248   1855216   3334908     38.61   1134868   2121932       260
03:30:02 PM   1382308   6626136     82.74       248   1862340   3327096     38.52   1142360   2127132       108
03:35:01 PM   1313240   6695204     83.60       248   1870732   3391304     39.26   1193872   2133456        20
03:40:01 PM   1432792   6575652     82.11       248   1852932   3252380     37.65   1079108   2113960        28
03:45:01 PM   1366572   6641872     82.94       248   1866284   3324528     38.49   1110904   2124132        32
03:50:01 PM   1212112   6796332     84.86       248   1871080   3467608     40.14   1239192   2129392       168
03:55:01 PM   1188876   6819568     85.15       248   1887316   3483984     40.33   1245076   2137724       580
04:00:01 PM    928728   7079716     88.40       248   1895708   3714272     43.00   1488728   2144488      1760
04:05:01 PM   1126624   6881820     85.93       248   1901556   3471092     40.18   1271080   2149388         0
04:10:01 PM   1169424   6839020     85.40       256   1929752   3363860     38.94   1185232   2175216         4
04:15:01 PM   1991504   6016940     75.13       256    950256   3553052     41.13   1273888   1273776      1424
04:20:01 PM   1754228   6254216     78.10       256    953988   3774748     43.70   1474548   1275148        72
04:25:01 PM   1717736   6290708     78.55       256    965760   3766228     43.60   1477840   1284520      2968
04:30:01 PM   1234808   6773636     84.58       256    980888   4278604     49.53   1907828   1294464      3164
04:35:02 PM    240548   7767896     97.00       256    999512   5401660     62.53   2856608   1303296       508
04:40:01 PM    136820   7871624     98.29       216    413056   6968424     80.67   3925484   1037368         0
04:45:02 PM   3359936   4648508     58.05       260    564932   3647892     42.23   1237244   1144248        28
04:50:01 PM   2872484   5135960     64.13       260    592908   4130868     47.82   1659284   1162752      1460
04:55:01 PM   2466692   5541752     69.20       260    706264   4436048     51.35   1929216   1258348       532
05:00:01 PM   2508348   5500096     68.68       260    701824   4406264     51.01   1861760   1257668       716
05:05:01 PM   3116152   4892292     61.09       260    719812   3583452     41.48   1228968   1269300      5036
05:10:01 PM   3391220   4617224     57.65       260    731324   3243236     37.55    922952   1278112       492
05:15:01 PM   2991632   5016812     62.64       260    742212   3620164     41.91   1288120   1288112      2116
05:20:01 PM   2970448   5037996     62.91       260    730836   3645784     42.21   1302880   1276712      3104
05:25:01 PM   3101452   4906992     61.27       260    733360   3488192     40.38   1143896   1284032      1600
05:30:01 PM   3181676   4826768     60.27       268    722288   3382172     39.15   1067736   1271856       512
05:35:01 PM   3161608   4846836     60.52       276    759468   3391704     39.26   1033432   1299096         4
05:40:01 PM   2918520   5089924     63.56       276    805480   3573848     41.37   1207008   1343668      5884
05:45:01 PM   2746828   5261616     65.70       276    817508   3714556     43.00   1351504   1355972      2744
05:50:01 PM   2846320   5162124     64.46       276    772364   3646792     42.22   1270676   1304104      1844
05:55:01 PM   2726688   5281756     65.95       276    782744   3664128     42.42   1357792   1311820      2116
06:00:02 PM   2750960   5257484     65.65       276    789084   3612668     41.82   1302140   1316716       980
06:05:01 PM   2907492   5100952     63.69       276    827444   3430888     39.72   1093128   1347944      7144
06:10:01 PM   2722936   5285508     66.00       276    930168   3509848     40.63   1164708   1444988      6840
06:15:01 PM   2611924   5396520     67.39       276   1001972   3513040     40.67   1182800   1515932      8076
06:20:01 PM   2181456   5826988     72.76       276   1085992   3858596     44.67   1507400   1589804      7692
06:25:01 PM   2451648   5556796     69.39       276   1159192   3452624     39.97   1155020   1656184      6580
06:30:01 PM   2416392   5592052     69.83       292   1214120   3420692     39.60   1126876   1707376         0
Average:      2786215   5222229     65.21       250   1264861   3439312     39.82   1127008   1648627      2633

------------------------------------------------------------------
sar -u | sed -e "s|$(hostname)|hostname|g"
Linux 3.10.0-1127.el7.x86_64 (hostname)     05/06/2020     _x86_64_    (6 CPU)

12:00:01 AM     CPU     %user     %nice   %system   %iowait    %steal     %idle
12:05:01 AM     all      2.17      0.00      0.33      0.02      0.16     97.32
12:10:01 AM     all     16.08      0.00      1.40      0.03      0.05     82.45
12:15:01 AM     all     10.20      0.00      0.95      0.01      0.05     88.79
12:20:01 AM     all      4.57      0.00      0.80      0.00      0.03     94.59
12:25:01 AM     all      1.85      0.00      0.27      0.00      0.04     97.84
12:30:01 AM     all      2.13      0.00      0.27      0.00      0.03     97.56
12:35:01 AM     all      1.92      0.00      0.28      0.00      0.04     97.75
12:40:01 AM     all      1.75      0.00      0.25      0.00      0.03     97.96
12:45:01 AM     all      2.18      0.00      0.28      0.01      0.02     97.51
12:50:01 AM     all      2.49      0.00      0.30      0.00      0.02     97.19
12:55:01 AM     all      2.30      0.00      0.29      0.00      0.02     97.38
01:00:01 AM     all      1.83      0.00      0.29      0.00      0.02     97.85
01:05:01 AM     all      2.52      0.00      0.32      0.02      0.16     96.99
01:10:01 AM     all      2.29      0.00      0.32      0.01      0.08     97.30
01:15:01 AM     all      2.05      0.00      0.26      0.01      0.04     97.65
01:20:01 AM     all     17.29      0.00      3.39      2.11      0.13     77.07
01:25:01 AM     all      4.69      0.00      1.20      0.10      0.13     93.87
01:30:01 AM     all      2.89      0.00      0.74      0.01      0.05     96.31
01:35:01 AM     all      1.58      0.00      0.24      0.00      0.04     98.14
01:40:01 AM     all      1.63      0.00      0.22      0.01      0.02     98.12
01:45:01 AM     all      2.37      0.00      0.25      0.01      0.02     97.35
01:50:01 AM     all      1.43      0.00      0.22      0.01      0.02     98.31
01:55:01 AM     all      1.84      0.00      0.26      0.00      0.02     97.87
02:00:01 AM     all      1.58      0.00      0.23      0.00      0.03     98.16
02:05:02 AM     all      1.57      0.00      0.23      0.01      0.13     98.06
02:10:01 AM     all      1.79      0.00      0.31      0.03      0.07     97.79
02:15:01 AM     all      2.49      0.00      0.28      0.03      0.05     97.15
02:20:01 AM     all      2.14      0.00      0.29      0.00      0.04     97.53
02:25:01 AM     all      1.37      0.00      0.23      0.00      0.04     98.36
02:30:01 AM     all      2.06      0.00      0.35      0.03      0.03     97.53
02:35:01 AM     all      2.26      0.00      0.28      0.01      0.07     97.39
02:40:01 AM     all      1.72      0.00      0.24      0.02      0.04     97.98
02:45:01 AM     all      1.73      0.00      0.25      0.01      0.02     97.99
02:50:01 AM     all      2.24      0.00      0.30      0.02      0.02     97.42
02:55:01 AM     all      1.68      0.00      0.23      0.00      0.02     98.07
03:00:01 AM     all      1.22      0.00      0.21      0.00      0.02     98.54
03:05:01 AM     all      1.75      0.00      0.25      0.00      0.06     97.94
03:10:01 AM     all      1.86      0.00      0.23      0.00      0.04     97.86
03:15:01 AM     all      2.04      0.00      0.25      0.01      0.03     97.66
03:20:01 AM     all      1.72      0.05      0.29      0.01      0.02     97.91
03:25:01 AM     all      1.32      0.00      0.22      0.00      0.02     98.44
03:30:01 AM     all      2.11      0.00      0.24      0.01      0.03     97.62
03:35:01 AM     all      1.54      0.00      0.24      0.00      0.03     98.18
03:40:01 AM     all      2.00      0.00      0.25      0.00      0.02     97.72
03:45:01 AM     all      1.74      0.00      0.23      0.00      0.02     98.01
03:50:01 AM     all      1.65      0.00      0.21      0.00      0.03     98.11
03:55:01 AM     all      4.40      0.00      0.78      0.00      0.03     94.79
04:00:02 AM     all      1.71      0.00      0.22      0.00      0.02     98.04
04:05:01 AM     all      2.03      0.00      0.27      0.00      0.05     97.64
04:10:01 AM     all      1.71      0.00      0.22      0.00      0.03     98.04
04:15:01 AM     all      4.15      0.00      0.72      0.01      0.02     95.11
04:20:01 AM     all      1.49      0.00      0.25      0.00      0.02     98.25
04:25:01 AM     all      2.17      0.00      0.26      0.01      0.02     97.55
04:30:01 AM     all      1.96      0.00      0.25      0.00      0.01     97.78
04:35:01 AM     all      4.08      0.00      0.75      0.01      0.04     95.13
04:40:01 AM     all      1.76      0.00      0.24      0.00      0.02     97.98
04:45:01 AM     all      1.89      0.00      0.25      0.01      0.02     97.83
04:50:01 AM     all      2.07      0.00      0.31      0.01      0.02     97.59
04:55:01 AM     all      5.05      0.00      0.77      0.01      0.03     94.14
05:00:01 AM     all      2.52      0.00      0.28      0.01      0.02     97.17
05:05:01 AM     all      2.35      0.00      0.29      0.01      0.05     97.29
05:10:01 AM     all      2.86      0.00      0.30      0.01      0.02     96.82
05:15:01 AM     all      3.01      0.00      0.31      0.01      0.02     96.65
05:20:01 AM     all      5.28      0.00      0.42      0.01      0.02     94.26
05:25:01 AM     all      7.36      0.00      0.56      0.01      0.03     92.04
05:30:01 AM     all      7.69      0.00      0.57      0.01      0.04     91.69
05:35:01 AM     all      8.64      0.00      0.60      0.01      0.05     90.70
05:40:01 AM     all      7.24      0.00      0.55      0.01      0.03     92.17
05:45:01 AM     all      6.41      0.00      0.50      0.01      0.03     93.05
05:50:02 AM     all      5.70      0.00      0.43      0.01      0.02     93.83
05:55:01 AM     all      3.43      0.00      0.36      0.01      0.02     96.18
06:00:01 AM     all     12.27      0.00      1.89      0.01      0.03     85.79
06:05:01 AM     all     13.52      0.00      2.30      0.01      0.10     84.08
06:10:01 AM     all     12.94      0.00      2.27      0.01      0.03     84.75
06:15:01 AM     all     13.17      0.00      1.85      0.01      0.06     84.90
06:20:01 AM     all     13.03      0.00      2.21      0.02      0.05     84.70
06:25:01 AM     all     10.05      0.00      1.45      0.01      0.03     88.47
06:30:01 AM     all      9.63      0.00      1.42      0.01      0.03     88.92
06:35:01 AM     all      4.05      0.00      0.40      0.01      0.05     95.48
06:40:01 AM     all     12.58      0.00      1.53      0.01      0.05     85.83
06:45:01 AM     all      4.04      0.00      0.30      0.01      0.03     95.63
06:50:01 AM     all      4.48      0.00      0.32      0.01      0.02     95.18
06:55:01 AM     all      5.76      0.00      0.35      0.01      0.04     93.84
07:00:01 AM     all      2.54      0.00      0.29      0.01      0.03     97.14
07:05:01 AM     all      6.42      0.00      0.30      0.01      0.04     93.23
07:10:01 AM     all      3.48      0.00      0.35      0.02      0.04     96.11
07:15:01 AM     all      2.44      0.00      0.27      0.03      0.04     97.22
07:20:01 AM     all      2.23      0.00      0.25      0.01      0.04     97.48
07:25:01 AM     all      4.61      0.00      0.81      0.00      0.05     94.53
07:30:01 AM     all      1.22      0.00      0.20      0.00      0.04     98.54
07:35:01 AM     all      2.66      0.00      0.26      0.01      0.08     96.99
07:40:01 AM     all      2.38      0.00      0.26      0.00      0.02     97.34
07:45:01 AM     all      2.48      0.00      0.26      0.01      0.03     97.22
07:50:02 AM     all      3.63      0.00      0.29      0.01      0.02     96.05
07:55:01 AM     all      6.61      0.00      1.20      0.01      0.06     92.11
08:00:01 AM     all      6.61      0.00      0.77      0.01      0.04     92.57
08:05:01 AM     all      7.36      0.00      0.99      0.04      0.08     91.53
08:10:01 AM     all      3.56      0.00      0.49      0.02      0.04     95.89
08:15:01 AM     all      3.08      0.00      0.26      0.01      0.06     96.60
08:20:01 AM     all      5.01      0.00      0.83      0.01      0.04     94.11
08:25:01 AM     all      1.74      0.00      0.24      0.00      0.04     97.98
08:30:01 AM     all      3.27      0.00      0.26      0.01      0.04     96.43
08:35:01 AM     all      2.11      0.00      0.23      0.00      0.05     97.61
08:40:01 AM     all      2.58      0.00      0.29      0.01      0.03     97.09
08:45:01 AM     all      2.16      0.00      0.24      0.00      0.03     97.56
08:50:01 AM     all      2.40      0.00      0.27      0.01      0.03     97.30
08:55:01 AM     all      5.96      0.00      0.33      0.01      0.05     93.66
09:00:01 AM     all      7.54      0.00      0.98      0.01      0.09     91.39
09:05:01 AM     all     18.75      0.00      2.92      0.02      0.22     78.10
09:10:02 AM     all      8.33      0.00      0.86      0.01      0.05     90.74
09:15:01 AM     all     11.60      0.00      1.51      0.01      0.13     86.75
09:20:01 AM     all     10.96      0.00      1.36      0.01      0.12     87.54
09:25:01 AM     all      8.67      0.00      0.91      0.01      0.07     90.33
09:30:01 AM     all     10.08      0.00      1.39      0.01      0.07     88.45
09:35:01 AM     all     14.62      0.00      2.03      0.02      0.13     83.20
09:40:01 AM     all     15.26      0.00      2.46      0.01      0.14     82.14
09:45:01 AM     all     12.47      0.00      1.69      0.01      0.12     85.71
09:50:01 AM     all     13.23      0.00      1.67      0.01      0.22     84.86
09:55:01 AM     all     11.47      0.00      1.18      0.01      0.13     87.21
10:00:01 AM     all      9.24      0.00      1.18      0.01      0.13     89.43
10:05:01 AM     all      3.34      0.00      0.31      0.01      0.05     96.29
10:10:01 AM     all      3.52      0.00      0.30      0.00      0.06     96.11
10:15:01 AM     all      3.11      0.00      0.27      0.01      0.05     96.57
10:20:01 AM     all      2.72      0.00      0.27      0.00      0.04     96.97
10:25:01 AM     all      2.72      0.00      0.28      0.00      0.03     96.96
10:30:01 AM     all      3.52      0.00      0.30      0.01      0.05     96.12
10:35:01 AM     all      2.25      0.00      0.26      0.00      0.05     97.43
10:40:01 AM     all      3.31      0.00      0.30      0.02      0.04     96.32
10:45:01 AM     all      3.59      0.00      0.37      0.01      0.07     95.97
10:50:02 AM     all      3.21      0.00      0.35      0.01      0.05     96.38
10:55:01 AM     all      5.53      0.00      0.50      0.01      0.08     93.88
11:00:01 AM     all     14.60      0.00      2.40      0.01      0.09     82.89
11:05:01 AM     all     14.69      0.00      2.50      0.02      0.12     82.68
11:10:01 AM     all     15.73      0.00      2.69      0.01      0.10     81.47
11:15:01 AM     all      3.06      0.00      0.34      0.01      0.04     96.55
11:20:01 AM     all      3.05      0.00      0.35      0.01      0.04     96.56
11:25:01 AM     all      6.82      0.00      0.87      0.01      0.06     92.25
11:30:01 AM     all     11.08      0.00      1.86      0.01      0.06     86.98
11:35:01 AM     all     11.48      0.00      1.85      0.01      0.10     86.56
11:40:01 AM     all     12.05      0.00      1.95      0.01      0.08     85.92
11:45:01 AM     all     13.19      0.00      2.27      0.01      0.05     84.48
11:50:01 AM     all     13.13      0.00      2.41      0.01      0.08     84.37
11:55:01 AM     all     12.49      0.00      2.10      0.01      0.09     85.32
12:00:01 PM     all      3.19      0.00      0.31      0.01      0.06     96.44
12:05:01 PM     all      3.09      0.00      0.26      0.01      0.07     96.58
12:10:01 PM     all     15.38      0.00      0.42      0.01      0.08     84.11
12:15:01 PM     all     21.50      0.00      0.52      0.00      0.12     77.86
12:20:02 PM     all     19.44      0.00      0.48      0.00      0.11     79.97
12:25:02 PM     all      3.55      0.00      0.40      0.01      0.06     95.98
12:30:01 PM     all      2.77      0.00      0.34      0.01      0.05     96.83
12:35:01 PM     all      2.06      0.00      0.27      0.00      0.09     97.57
12:40:01 PM     all      2.47      0.00      0.28      0.01      0.06     97.18
12:45:01 PM     all      2.21      0.00      0.27      0.01      0.06     97.45
12:50:01 PM     all      1.96      0.00      0.30      0.00      0.07     97.67
12:55:01 PM     all      7.88      0.00      1.45      0.01      0.12     90.53
01:00:01 PM     all     10.14      0.00      1.73      0.01      0.08     88.04
01:05:01 PM     all     11.03      0.00      1.98      0.02      0.15     86.82
01:10:01 PM     all      2.05      0.00      0.28      0.01      0.06     97.60
01:15:01 PM     all      2.54      0.00      0.29      0.01      0.09     97.09
01:20:01 PM     all      4.04      0.00      0.81      0.00      0.04     95.10
01:25:01 PM     all      8.53      0.00      1.75      0.01      0.06     89.66
01:30:01 PM     all      8.60      0.00      1.35      0.01      0.07     89.97
01:35:01 PM     all      6.98      0.00      1.29      0.01      0.10     91.63
01:40:01 PM     all     11.12      0.00      1.87      0.01      0.04     86.96
01:45:01 PM     all     15.56      0.00      2.73      0.01      0.10     81.59
01:50:01 PM     all      7.01      0.00      1.10      0.01      0.06     91.82
01:55:01 PM     all      8.48      0.00      1.66      0.01      0.08     89.78
02:00:02 PM     all      5.99      0.00      1.06      0.01      0.07     92.86
02:05:01 PM     all      8.97      0.00      1.77      0.01      0.11     89.14
02:10:01 PM     all      9.23      0.00      1.68      0.02      0.09     88.99
02:15:01 PM     all      4.84      0.00      0.86      0.01      0.08     94.22
02:20:01 PM     all      2.32      0.00      0.30      0.00      0.06     97.32
02:25:01 PM     all      2.16      0.00      0.29      0.01      0.04     97.50
02:30:01 PM     all      3.10      0.00      0.35      0.01      0.04     96.49
02:35:01 PM     all      1.89      0.00      0.28      0.01      0.08     97.74
02:40:01 PM     all      5.73      0.00      0.99      0.01      0.06     93.21
02:45:01 PM     all      6.13      0.00      1.16      0.01      0.14     92.57
02:50:01 PM     all      2.91      0.00      0.39      0.01      0.04     96.65
02:55:01 PM     all      2.91      0.00      0.33      0.00      0.05     96.71
03:00:01 PM     all      2.32      0.00      0.32      0.01      0.05     97.31
03:05:01 PM     all      7.02      0.00      1.22      0.01      0.18     91.57
03:10:01 PM     all     10.98      0.00      2.05      0.01      0.12     86.83
03:15:01 PM     all     13.17      0.00      2.44      0.01      0.14     84.23
03:20:01 PM     all     12.26      0.00      2.44      0.01      0.08     85.22
03:25:01 PM     all      9.43      0.00      1.67      0.01      0.08     88.81
03:30:02 PM     all      7.73      0.00      1.34      0.01      0.07     90.85
03:35:01 PM     all      7.72      0.00      1.38      0.01      0.09     90.80
03:40:01 PM     all      9.71      0.00      1.86      0.01      0.04     88.37
03:45:01 PM     all     14.50      0.00      2.46      0.01      0.16     82.86
03:50:01 PM     all      7.78      0.00      1.51      0.01      0.06     90.65
03:55:01 PM     all      6.40      0.00      1.17      0.01      0.06     92.36
04:00:01 PM     all      9.00      0.00      1.74      0.01      0.05     89.20
04:05:01 PM     all      5.01      0.00      0.90      0.01      0.06     94.02
04:10:01 PM     all     10.38      0.00      2.09      0.01      0.08     87.44
04:15:01 PM     all     11.77      0.00      2.22      0.01      0.10     85.90
04:20:01 PM     all     16.54      0.00      2.37      0.01      0.05     81.02
04:25:01 PM     all     25.47      0.00      2.54      0.01      0.16     71.81
04:30:01 PM     all     51.38      0.00      4.93      0.02      0.61     43.06
04:35:02 PM     all     54.18      0.00      3.70      0.02      0.55     41.54
04:40:01 PM     all     48.53      0.00      2.23      0.47      0.22     48.56
04:45:02 PM     all     33.36      0.00      2.13      0.10      0.31     64.09
04:50:01 PM     all     43.05      0.00      3.42      0.03      0.43     53.07
04:55:01 PM     all     47.19      0.00      3.51      0.03      0.51     48.76
05:00:01 PM     all     43.20      0.00      3.92      0.03      0.61     52.25
05:05:01 PM     all     22.85      0.00      3.11      0.02      0.48     73.55
05:10:01 PM     all      9.55      0.00      2.01      0.01      0.08     88.35
05:15:01 PM     all      9.59      0.00      1.90      0.01      0.07     88.42
05:20:01 PM     all     10.25      0.00      1.96      0.01      0.06     87.71
05:25:01 PM     all      9.79      0.00      2.05      0.01      0.06     88.10
05:30:01 PM     all      9.47      0.00      1.89      0.01      0.05     88.58
05:35:01 PM     all     11.38      0.00      2.21      0.02      0.12     86.28
05:40:01 PM     all     14.41      0.00      2.78      0.01      0.09     82.71
05:45:01 PM     all     16.22      0.00      3.54      0.01      0.12     80.11
05:50:01 PM     all     18.84      0.00      2.35      0.02      0.17     78.63
05:55:01 PM     all     16.84      0.00      3.77      0.02      0.10     79.28
06:00:02 PM     all      9.85      0.00      2.58      0.01      0.08     87.47
06:05:01 PM     all     15.60      0.00      3.10      0.02      0.17     81.12
06:10:01 PM     all     19.85      0.00      3.26      0.02      0.14     76.73
06:15:01 PM     all     19.06      0.00      2.88      0.03      0.13     77.91
06:20:01 PM     all     22.43      0.00      3.36      0.03      0.18     74.00
06:25:01 PM     all     22.30      0.00      3.45      0.03      0.21     74.01
06:30:01 PM     all      7.06      0.00      1.32      0.02      0.10     91.50
Average:        all      7.94      0.00      1.06      0.02      0.08     90.90

------------------------------------------------------------------
top -bHn1 -w200
top - 18:34:29 up 8 days, 20:37,  1 user,  load average: 0.62, 0.93, 1.14
Threads: 244 total,   3 running, 240 sleeping,   1 stopped,   0 zombie
%Cpu(s): 12.3 us, 20.5 sy,  0.0 ni, 65.6 id,  0.0 wa,  0.0 hi,  0.8 si,  0.8 st
KiB Mem :  8008444 total,  2347008 free,  2490484 used,  3170952 buff/cache
KiB Swap:   629756 total,   525564 free,   104192 used.  4855472 avail Mem

  PID USER      PR  NI    VIRT    RES    SHR S %CPU %MEM     TIME+ COMMAND
24310 root      20   0  191204   3356   2052 R 99.9  0.0   0:00.68 systemd
24346 nginx     10 -10  719932  15632   2364 R 70.0  0.2   0:00.14 php-fpm
    9 root      20   0       0      0      0 S  5.0  0.0  26:03.58 rcu_sched
    1 root      20   0  191204   3356   2052 S  0.0  0.0   2:54.66 systemd
    2 root      20   0       0      0      0 S  0.0  0.0   0:00.15 kthreadd
    4 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 kworker/0:0H
    6 root      20   0       0      0      0 S  0.0  0.0   0:07.32 ksoftirqd/0
    7 root      rt   0       0      0      0 S  0.0  0.0   0:00.42 migration/0
    8 root      20   0       0      0      0 S  0.0  0.0   0:00.00 rcu_bh
   10 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 lru-add-drain
   11 root      rt   0       0      0      0 S  0.0  0.0   0:03.58 watchdog/0
   12 root      rt   0       0      0      0 S  0.0  0.0   0:03.42 watchdog/1
   13 root      rt   0       0      0      0 S  0.0  0.0   0:00.45 migration/1
   14 root      20   0       0      0      0 S  0.0  0.0   0:05.23 ksoftirqd/1
   16 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 kworker/1:0H
   17 root      rt   0       0      0      0 S  0.0  0.0   0:03.13 watchdog/2
   18 root      rt   0       0      0      0 S  0.0  0.0   0:00.48 migration/2
   19 root      20   0       0      0      0 S  0.0  0.0   0:04.17 ksoftirqd/2
   21 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 kworker/2:0H
   22 root      rt   0       0      0      0 S  0.0  0.0   0:03.61 watchdog/3
   23 root      rt   0       0      0      0 S  0.0  0.0   0:00.44 migration/3
   24 root      20   0       0      0      0 S  0.0  0.0   0:47.75 ksoftirqd/3
   26 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 kworker/3:0H
   27 root      rt   0       0      0      0 S  0.0  0.0   0:02.90 watchdog/4
   28 root      rt   0       0      0      0 S  0.0  0.0   0:00.46 migration/4
   29 root      20   0       0      0      0 S  0.0  0.0   0:03.46 ksoftirqd/4
   31 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 kworker/4:0H
   32 root      rt   0       0      0      0 S  0.0  0.0   0:02.79 watchdog/5
   33 root      rt   0       0      0      0 S  0.0  0.0   0:00.41 migration/5
   34 root      20   0       0      0      0 S  0.0  0.0   0:03.06 ksoftirqd/5
   36 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 kworker/5:0H
   38 root      20   0       0      0      0 S  0.0  0.0   0:00.00 kdevtmpfs
   39 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 netns
   40 root      20   0       0      0      0 S  0.0  0.0   0:00.47 khungtaskd
   41 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 writeback
   42 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 kintegrityd
   43 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 bioset
   44 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 bioset
   45 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 bioset
   46 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 kblockd
   47 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 md
   48 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 edac-poller
   49 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 watchdogd
   55 root      20   0       0      0      0 S  0.0  0.0   1:35.01 kswapd0
   56 root      25   5       0      0      0 S  0.0  0.0   0:00.00 ksmd
   57 root      39  19       0      0      0 S  0.0  0.0   0:04.84 khugepaged
   58 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 crypto
   66 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 kthrotld
   68 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 kmpath_rdacd
   69 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 kaluad
   70 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 kpsmoused
   72 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 ipv6_addrconf
   86 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 deferwq
  131 root      20   0       0      0      0 S  0.0  0.0   0:01.25 kauditd
  267 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 ata_sff
  272 root      20   0       0      0      0 S  0.0  0.0   0:00.00 scsi_eh_0
  276 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 scsi_tmf_0
  277 root       0 -20       0      0      0 S  0.0  0.0   0:13.85 kworker/3:1H
  278 root      20   0       0      0      0 S  0.0  0.0   0:00.10 scsi_eh_1
  279 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 scsi_tmf_1
  288 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 ttm_swap
  304 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 bioset
  305 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfsalloc
  306 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfs_mru_cache
  307 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfs-buf/vda4
  308 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfs-data/vda4
  309 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfs-conv/vda4
  310 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfs-cil/vda4
  311 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfs-reclaim/vda
  312 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfs-log/vda4
  313 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfs-eofblocks/v
  314 root      20   0       0      0      0 S  0.0  0.0   5:56.29 xfsaild/vda4
  315 root       0 -20       0      0      0 S  0.0  0.0   0:13.15 kworker/2:1H
  395 root      20   0   71788  34512  34352 S  0.0  0.4   6:59.18 systemd-journal
  428 root      20   0   45160    844    796 S  0.0  0.0   0:00.06 systemd-udevd
  431 root       0 -20       0      0      0 S  0.0  0.0   0:04.45 loop0
  455 root      20   0       0      0      0 S  0.0  0.0   0:06.59 hwrng
  456 root      20   0       0      0      0 S  0.0  0.0   0:00.90 jbd2/loop0-8
  457 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 ext4-rsv-conver
  470 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfs-buf/vda2
  472 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfs-data/vda2
  482 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfs-conv/vda2
  483 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfs-cil/vda2
  484 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfs-reclaim/vda
  487 root       0 -20       0      0      0 S  0.0  0.0   0:12.63 kworker/0:1H
  488 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfs-log/vda2
  489 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 xfs-eofblocks/v
  490 root      20   0       0      0      0 S  0.0  0.0   0:00.01 xfsaild/vda2
  540 root       0 -20       0      0      0 S  0.0  0.0   0:12.62 kworker/1:1H
  548 root      16  -4   55584    616    500 S  0.0  0.0   0:03.72 auditd
  549 root      16  -4   55584    616    500 S  0.0  0.0   0:00.21 auditd
  570 root       0 -20       0      0      0 S  0.0  0.0   0:15.86 kworker/4:1H
  572 root      20   0   12188   2640    516 S  0.0  0.0   0:44.52 haveged
  576 polkitd   20   0  612400   4308   1732 S  0.0  0.1   0:02.88 polkitd
  599 polkitd   20   0  612400   4308   1732 S  0.0  0.1   0:00.00 gmain
  602 polkitd   20   0  612400   4308   1732 S  0.0  0.1   0:03.27 gdbus
  606 polkitd   20   0  612400   4308   1732 S  0.0  0.1   0:00.00 polkitd
  610 polkitd   20   0  612400   4308   1732 S  0.0  0.1   0:00.00 JS GC Helper
  613 polkitd   20   0  612400   4308   1732 S  0.0  0.1   0:00.00 JS Sour~ Thread
  620 polkitd   20   0  612400   4308   1732 S  0.0  0.1   0:00.00 polkitd
  578 dbus      20   0   58292   1676   1288 S  0.0  0.0   0:36.15 dbus-daemon
  583 chrony    20   0  117808   1268   1036 S  0.0  0.0   0:01.49 chronyd
  603 root      20   0   21692    800    704 S  0.0  0.0   0:29.49 irqbalance
  607 root      20   0   90620    868    820 S  0.0  0.0   0:48.19 rngd
  609 root      20   0   26432   1392   1216 S  0.0  0.0   0:17.18 systemd-logind
  612 root      20   0   44216    804    804 S  0.0  0.0   0:00.00 qemu-ga
  616 root      20   0  126476   1192    776 S  0.0  0.0   0:03.03 crond
  646 root      20   0  474308   2284   1628 S  0.0  0.0  55:18.23 NetworkManager
  648 root      20   0  474308   2284   1628 S  0.0  0.0   0:14.42 gmain
  650 root      20   0  474308   2284   1628 S  0.0  0.0   0:01.75 gdbus
  647 root      20   0    4388    300    296 S  0.0  0.0   0:00.00 acpid
  872 root      20   0  112976   1424   1324 S  0.0  0.0   0:03.04 sshd
  873 root      20   0  574356   3396   1692 S  0.0  0.0   0:00.26 tuned
 1728 root      20   0  574356   3396   1692 S  0.0  0.0   0:00.00 gmain
 1731 root      20   0  574356   3396   1692 S  0.0  0.0   1:42.52 tuned
 1745 root      20   0  574356   3396   1692 S  0.0  0.0   0:00.00 tuned
 1752 root      20   0  574356   3396   1692 S  0.0  0.0   0:00.00 tuned
  880 root      20   0  533484  21568  20404 S  0.0  0.3   0:00.07 rsyslogd
  908 root      20   0  533484  21568  20404 S  0.0  0.3   3:29.73 in:imjournal
  913 root      20   0  533484  21568  20404 S  0.0  0.3   0:59.34 rs:main Q:Reg
  896 root       0 -20       0      0      0 S  0.0  0.0   0:12.10 kworker/5:1H
  904 root      20   0  110208    704    576 S  0.0  0.0   0:00.01 agetty
  907 root      20   0  110208    688    560 S  0.0  0.0   0:00.02 agetty
  943 memcach+  20   0  449884    812    492 S  0.0  0.0   0:37.10 memcached
  945 memcach+  20   0  449884    812    492 S  0.0  0.0   0:29.00 memcached
  948 memcach+  20   0  449884    812    492 S  0.0  0.0   0:00.00 memcached
  949 memcach+  20   0  449884    812    492 S  0.0  0.0   0:00.00 memcached
  951 memcach+  20   0  449884    812    492 S  0.0  0.0   0:00.00 memcached
  952 memcach+  20   0  449884    812    492 S  0.0  0.0   0:00.00 memcached
  962 memcach+  20   0  449884    812    492 S  0.0  0.0   0:00.00 memcached
  963 memcach+  20   0  449884    812    492 S  0.0  0.0   0:00.05 memcached
  965 memcach+  20   0  449884    812    492 S  0.0  0.0   1:02.16 memcached
  966 memcach+  20   0  449884    812    492 S  0.0  0.0   0:00.00 memcached
 1499 root      20   0  203768   2252    860 S  0.0  0.0   0:00.12 pure-ftpd
 1661 root      20   0   90412   1380    900 S  0.0  0.0   0:03.23 master
 1666 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:11.02 mysqld
 1786 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:00.00 mysqld
 1804 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:02.94 mysqld
 1874 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:52.61 mysqld
 1875 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:58.06 mysqld
 1876 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:52.16 mysqld
 1877 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:52.30 mysqld
 1878 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:52.18 mysqld
 1879 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:56.64 mysqld
 1880 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:54.18 mysqld
 1881 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:51.55 mysqld
 1882 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   3:07.98 mysqld
 1974 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:32.00 mysqld
 1975 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:41.57 mysqld
 1976 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:06.36 mysqld
 1977 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:12.86 mysqld
 1980 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:06.50 mysqld
 1986 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   1:08.15 mysqld
 1987 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  53:34.92 mysqld
 1988 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   4:38.22 mysqld
 2014 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:00.41 mysqld
 2015 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:23.64 mysqld
 2016 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:00.00 mysqld
 2017 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:00.00 mysqld
 2020 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:00.00 mysqld
 2031 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   0:00.00 mysqld
62569 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3 140:41.04 mysqld
10083 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3 124:11.96 mysqld
10085 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3 138:45.83 mysqld
21943 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  77:16.07 mysqld
 8944 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  70:47.52 mysqld
10412 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  78:34.83 mysqld
12169 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  92:37.51 mysqld
12174 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  61:12.48 mysqld
12194 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  64:49.70 mysqld
12197 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  74:05.74 mysqld
44135 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  57:52.70 mysqld
56331 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  42:43.92 mysqld
56333 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  49:14.58 mysqld
56339 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  39:28.61 mysqld
35798 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  11:33.05 mysqld
35802 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  12:18.76 mysqld
35818 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  12:24.06 mysqld
35861 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  13:12.64 mysqld
35862 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3  14:13.64 mysqld
35341 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   3:38.30 mysqld
35354 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   4:51.30 mysqld
35372 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   5:14.83 mysqld
35431 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   4:05.60 mysqld
35469 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   5:38.20 mysqld
35472 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   6:16.48 mysqld
35494 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   4:17.66 mysqld
35503 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   8:10.68 mysqld
35627 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   4:22.41 mysqld
35668 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   3:24.02 mysqld
35670 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   4:19.05 mysqld
35961 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   4:53.57 mysqld
59368 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   1:38.31 mysqld
59371 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   2:23.38 mysqld
59374 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   4:56.52 mysqld
59376 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   6:46.39 mysqld
59378 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   1:39.43 mysqld
59380 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   2:55.03 mysqld
59383 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   3:35.08 mysqld
59385 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   3:05.41 mysqld
59402 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   1:14.96 mysqld
59738 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   1:27.07 mysqld
59740 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   3:17.49 mysqld
59742 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   2:23.32 mysqld
59744 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   3:21.03 mysqld
59746 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   1:02.92 mysqld
59748 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   1:37.41 mysqld
59753 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   1:24.63 mysqld
59754 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   1:35.35 mysqld
59756 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   3:04.69 mysqld
59841 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   1:10.46 mysqld
60144 mysql     20   0 5147704   1.1g   6588 S  0.0 14.3   1:46.56 mysqld
 1697 postfix   20   0   90692   1404   1100 S  0.0  0.0   0:00.75 qmgr
 2440 root       0 -20       0      0      0 S  0.0  0.0   0:00.00 dio/vda4
 6543 postfix   20   0   90516   4176   3088 S  0.0  0.1   0:00.00 pickup
17476 root      20   0       0      0      0 S  0.0  0.0   0:00.00 kworker/4:2
19662 root      20   0       0      0      0 S  0.0  0.0   0:00.01 kworker/4:0
22714 root      20   0       0      0      0 S  0.0  0.0   0:00.17 kworker/5:1
23605 root      20   0       0      0      0 S  0.0  0.0   0:00.00 kworker/4:1
23727 root      20   0  113544   1832   1296 S  0.0  0.0   0:00.00 cminfo
23767 root      20   0  113680   1404    728 S  0.0  0.0   0:00.01 cminfo
23768 root      20   0  108056    660    560 S  0.0  0.0   0:00.00 tee
24279 postfix   20   0   90660   2552   1312 S  0.0  0.0   0:00.48 tlsmgr
24295 root      20   0  147376  37676    588 S  0.0  0.5   0:00.00 nginx
24296 nginx     10 -10  196528  79316    884 S  0.0  1.0   0:00.02 nginx
24297 nginx     10 -10  196528  81256   2648 S  0.0  1.0   0:00.04 nginx
24298 nginx     10 -10  196528  81024   2432 S  0.0  1.0   0:00.02 nginx
24312 root      10 -10  714404   8064   1236 S  0.0  0.1   0:00.00 php-fpm
24380 root      20   0  162180   2232   1524 R  0.0  0.0   0:00.04 top
34747 root      20   0  172760  24108   1508 S  0.0  0.3   0:58.46 lfd - sleeping
38554 root      20   0       0      0      0 S  0.0  0.0   0:02.75 kworker/u12:1
42694 root      20   0       0      0      0 S  0.0  0.0   0:00.47 kworker/3:0
43141 root      20   0       0      0      0 S  0.0  0.0   0:00.39 kworker/2:2
46359 root      20   0       0      0      0 S  0.0  0.0   0:00.00 kworker/0:1
48618 root      20   0       0      0      0 S  0.0  0.0   0:00.55 kworker/1:2
58652 root      20   0       0      0      0 S  0.0  0.0   0:00.00 kworker/1:1
59117 root      20   0       0      0      0 S  0.0  0.0   0:00.00 kworker/2:1
59623 root      20   0       0      0      0 S  0.0  0.0   0:00.00 kworker/3:1
59626 root      20   0       0      0      0 S  0.0  0.0   0:00.28 kworker/0:0
59987 root      20   0       0      0      0 S  0.0  0.0   0:00.51 kworker/u12:0
59998 root      20   0       0      0      0 S  0.0  0.0   0:00.14 kworker/5:2
60318 root      20   0  151192   6020   4700 S  0.0  0.1   0:00.27 sshd
60324 root      20   0  116476   3096   1708 S  0.0  0.0   0:00.05 bash
65097 root      20   0  570072  41996   5804 T  0.0  0.5   3:07.47 glances

------------------------------------------------------------------
iotop -bton1 -P
18:34:29 Total DISK READ :       0.00 B/s | Total DISK WRITE :       0.00 B/s
18:34:29 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:
=====================================
2020-05-06 18:34:39 0x7f1de8393700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 10 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 133501 srv_active, 0 srv_shutdown, 631371 srv_idle
srv_master_thread log flush and writes: 764842
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 176086
OS WAIT ARRAY INFO: signal count 366390
RW-shared spins 0, rounds 531462, OS waits 109986
RW-excl spins 0, rounds 687316, OS waits 7696
RW-sx spins 5736, rounds 98027, OS waits 1064
Spin rounds per wait: 531462.00 RW-shared, 687316.00 RW-excl, 17.09 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 3108722
Purge done for trx's n:o < 3108722 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421242293412104, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421242293407888, not started
0 lock struct(s), heap size 1136, 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 (read thread)
I/O thread 5 state: waiting for completed aio requests (write thread)
I/O thread 6 state: waiting for completed aio requests (write thread)
I/O thread 7 state: waiting for completed aio requests (write thread)
Pending normal aio reads: [0, 0, 0] , aio writes: [0, 0, 0] ,
 ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 0
10210 OS file reads, 5589564 OS file writes, 1119491 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 14.50 writes/s, 4.50 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 4 merges
merged operations:
 insert 3, delete mark 1, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 138401, node heap has 482 buffer(s)
Hash table size 138401, node heap has 31 buffer(s)
Hash table size 138401, node heap has 76 buffer(s)
Hash table size 138401, node heap has 66 buffer(s)
Hash table size 138401, node heap has 171 buffer(s)
Hash table size 138401, node heap has 26 buffer(s)
Hash table size 138401, node heap has 62 buffer(s)
Hash table size 138401, node heap has 63 buffer(s)
10633.64 hash searches/s, 1478.85 non-hash searches/s
---
LOG
---
Log sequence number 4940473520
Log flushed up to   4940473520
Pages flushed up to 4940473520
Last checkpoint at  4940470588
0 pending log flushes, 0 pending chkp writes
1682070 log i/o's done, 3.70 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 565706752
Dictionary memory allocated 264384
Buffer pool size   32768
Free buffers       3140
Database pages     28651
Old database pages 10556
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 10131, created 18520, written 3663042
0.00 reads/s, 0.00 creates/s, 9.60 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 28651, unzip_LRU len: 0
I/O sum[0]:cur[14], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=1666, Main thread ID=139766679467776, state: sleeping
Number of rows inserted 1197297, updated 279517, deleted 510245, read 127735602583
2.00 inserts/s, 0.20 updates/s, 0.00 deletes/s, 570961.30 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 | 805306368 |
| aria_log_purge_type | immediate |
| aria_max_sort_file_size | 9223372036853727232 |
| aria_page_checksum | ON |
| aria_pagecache_age_threshold | 300 |
| aria_pagecache_buffer_size | 805306368 |
| aria_pagecache_division_limit | 100 |
| aria_pagecache_file_hash_size | 512 |
| aria_recover_options | BACKUP,QUICK |
| aria_repair_threads | 1 |
| aria_sort_buffer_size | 201326592 |
| 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_io_capacity | 1100 |
| innodb_io_capacity_max | 1833 |
| 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 | ON |
| 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_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 | 3 |
| 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 | 16 |
| innodb_thread_sleep_delay | 0 |
| 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.22 |
| innodb_write_io_threads | 3 |
| 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 | 8579 |
| 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 | 6 |
| 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 | 0152704ae3f857668dbc05803950adcf131b8685 |
| 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 | 68 |
| Aborted_connects | 0 |
| Access_denied_errors | 0 |
| Acl_column_grants | 0 |
| Acl_database_grants | 3 |
| 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 | 5 |
| Aria_pagecache_blocks_not_flushed | 0 |
| Aria_pagecache_blocks_unused | 94180 |
| Aria_pagecache_blocks_used | 4920 |
| Aria_pagecache_read_requests | 294589823 |
| Aria_pagecache_reads | 48737411 |
| Aria_pagecache_write_requests | 106116636 |
| Aria_pagecache_writes | 72191401 |
| Aria_transaction_log_syncs | 7057 |
| 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 | 54556350032 |
| Bytes_sent | 683275880578 |
| Column_compressions | 0 |
| Column_decompressions | 0 |
| Com_admin_commands | 1164 |
| 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 | 665 |
| Com_alter_tablespace | 0 |
| Com_alter_user | 0 |
| Com_analyze | 0 |
| Com_assign_to_keycache | 0 |
| Com_begin | 27 |
| Com_binlog | 0 |
| Com_call_procedure | 0 |
| Com_change_db | 184782 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 34 |
| Com_compound_sql | 0 |
| Com_create_db | 0 |
| Com_create_event | 0 |
| Com_create_function | 0 |
| Com_create_index | 9 |
| 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 | 100 |
| 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 | 751404 |
| Com_delete_multi | 100 |
| 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 | 172 |
| 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 | 1 |
| 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 | 573276 |
| Com_insert_select | 15 |
| Com_install_plugin | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_lock_tables | 74 |
| 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 | 1439 |
| 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 | 212629376 |
| Com_set_option | 555992 |
| 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 | 781 |
| Com_show_create_trigger | 0 |
| Com_show_create_user | 0 |
| Com_show_databases | 10 |
| Com_show_engine_logs | 0 |
| Com_show_engine_mutex | 0 |
| Com_show_engine_status | 2 |
| Com_show_errors | 0 |
| Com_show_events | 0 |
| Com_show_explain | 0 |
| Com_show_fields | 232945 |
| Com_show_function_status | 0 |
| Com_show_generic | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 197 |
| 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 | 1 |
| Com_show_slave_status | 1 |
| Com_show_status | 9 |
| Com_show_storage_engines | 1 |
| Com_show_table_status | 114 |
| Com_show_tables | 70 |
| Com_show_triggers | 0 |
| Com_show_variables | 179 |
| 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 | 5 |
| Com_uninstall_plugin | 0 |
| Com_unlock_tables | 74 |
| Com_update | 457028 |
| 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 | 184186 |
| Cpu_time | 0.000000 |
| Created_tmp_disk_tables | 86054751 |
| Created_tmp_files | 52821 |
| Created_tmp_tables | 86382725 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delete_scan | 671519 |
| Empty_queries | 41698014 |
| 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 | 179907 |
| Feature_system_versioning | 0 |
| Feature_timezone | 7 |
| Feature_trigger | 0 |
| Feature_window_functions | 0 |
| Feature_xml | 0 |
| Flush_commands | 1 |
| Handler_commit | 181804449 |
| Handler_delete | 510245 |
| Handler_discover | 52 |
| Handler_external_lock | 0 |
| Handler_icp_attempts | 416647842 |
| Handler_icp_match | 416082839 |
| Handler_mrr_init | 0 |
| Handler_mrr_key_refills | 0 |
| Handler_mrr_rowid_refills | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 35263 |
| Handler_read_key | 1318627990 |
| Handler_read_last | 23 |
| Handler_read_next | 3185159015 |
| Handler_read_prev | 1549657 |
| Handler_read_retry | 0 |
| Handler_read_rnd | 218574879 |
| Handler_read_rnd_deleted | 4650 |
| Handler_read_rnd_next | 123918458989 |
| Handler_rollback | 368 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_tmp_delete | 0 |
| Handler_tmp_update | 92863 |
| Handler_tmp_write | 253288854 |
| Handler_update | 392436 |
| Handler_write | 1200810 |
| Innodb_buffer_pool_dump_status | |
| Innodb_buffer_pool_load_status | Buffer pool(s) load completed at 200427 21:56:34 |
| Innodb_buffer_pool_resize_status | |
| Innodb_buffer_pool_load_incomplete | OFF |
| Innodb_buffer_pool_pages_data | 28651 |
| Innodb_buffer_pool_bytes_data | 469417984 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 3663012 |
| Innodb_buffer_pool_pages_free | 3140 |
| Innodb_buffer_pool_pages_misc | 977 |
| Innodb_buffer_pool_pages_total | 32768 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead | 438 |
| Innodb_buffer_pool_read_ahead_evicted | 0 |
| Innodb_buffer_pool_read_requests | 134223798484 |
| Innodb_buffer_pool_reads | 9691 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 21706172 |
| Innodb_data_fsyncs | 1119491 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 166070784 |
| Innodb_data_reads | 10210 |
| Innodb_data_writes | 5589564 |
| Innodb_data_written | 126856900096 |
| Innodb_dblwr_pages_written | 3662911 |
| Innodb_dblwr_writes | 233881 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 10193090 |
| Innodb_log_writes | 1584205 |
| Innodb_os_log_fsyncs | 387731 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 6778398720 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 18520 |
| Innodb_pages_read | 10131 |
| Innodb_pages0_read | 68 |
| Innodb_pages_written | 3663042 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 102819846 |
| Innodb_row_lock_time_avg | 216 |
| Innodb_row_lock_time_max | 51996 |
| Innodb_row_lock_waits | 475463 |
| Innodb_rows_deleted | 510245 |
| Innodb_rows_inserted | 1197297 |
| Innodb_rows_read | 127735622959 |
| Innodb_rows_updated | 279517 |
| Innodb_system_rows_deleted | 0 |
| Innodb_system_rows_inserted | 0 |
| Innodb_system_rows_read | 0 |
| Innodb_system_rows_updated | 0 |
| Innodb_num_open_files | 103 |
| 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 | 11 |
| Innodb_onlineddl_rowlog_rows | 0 |
| Innodb_onlineddl_rowlog_pct_used | 0 |
| Innodb_onlineddl_pct_progress | 0 |
| Innodb_secondary_index_triggered_cluster_reads | 2168890709 |
| 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 | 214330 |
| Key_blocks_used | 14 |
| Key_blocks_warm | 0 |
| Key_read_requests | 114 |
| Key_reads | 16 |
| 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 | 51 |
| Memory_used | 1177613408 |
| Memory_used_initial | 1161880344 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 62 |
| Open_streams | 0 |
| Open_table_definitions | 179 |
| Open_tables | 401 |
| Opened_files | 344272618 |
| Opened_plugin_libraries | 3 |
| Opened_table_definitions | 1532 |
| Opened_tables | 1175 |
| 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 | 3750 |
| Qcache_free_memory | 5569824 |
| Qcache_hits | 32316684 |
| Qcache_inserts | 178139972 |
| Qcache_lowmem_prunes | 137282136 |
| Qcache_not_cached | 2179648 |
| Qcache_queries_in_cache | 15765 |
| Qcache_total_blocks | 48042 |
| Queries | 215573002 |
| Questions | 215573002 |
| Rows_read | 127735644162 |
| Rows_sent | 3441422226 |
| Rows_tmp_read | 380094431 |
| 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 | 5187 |
| Select_full_range_join | 0 |
| Select_range | 1390313 |
| Select_range_check | 0 |
| Select_scan | 8699905 |
| 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 | 156 |
| Sort_merge_passes | 38719 |
| Sort_priority_queue_sorts | 150766 |
| Sort_range | 1092863 |
| Sort_rows | 232997765 |
| Sort_scan | 85968045 |
| 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 | 23696292 |
| Subquery_cache_miss | 6588350 |
| Syncs | 14354 |
| Table_locks_immediate | 746 |
| Table_locks_waited | 0 |
| Table_open_cache_active_instances | 1 |
| Table_open_cache_hits | 391740523 |
| Table_open_cache_misses | 1157 |
| 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 | 49 |
| Threads_connected | 2 |
| Threads_created | 173 |
| Threads_running | 5 |
| Transactions_gtid_foreign_engine | 0 |
| Transactions_multi_engine | 0 |
| Update_scan | 241620 |
| Uptime | 765487 |
| Uptime_since_flush_status | 765487 |
| 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.22-MariaDB     uptime 8 20:38:7    Wed May  6 18:34:39 2020

__ Key _________________________________________________________________
Buffer used    14.00k of  256.00M   %Used:   0.01
  Current      46.69M              %Usage:  18.24
Write hit       0.00%
Read hit       85.96%

__ Questions ___________________________________________________________
Total         215.57M     281.6/s
  DMS         214.41M     280.1/s  %Total:  99.46
  -Unknown     32.32M      42.2/s           14.99
  QC Hits      32.32M      42.2/s           14.99
  Com_        977.41k       1.3/s            0.45
  COM_QUIT    184.15k       0.2/s            0.09
Slow 1 s          156       0.0/s            0.00  %DMS:   0.00 Log:
DMS           214.41M     280.1/s           99.46
  SELECT      212.63M     277.8/s           98.63         99.17
  DELETE      751.50k       1.0/s            0.35          0.35
  INSERT      573.29k       0.7/s            0.27          0.27
  UPDATE      457.03k       0.6/s            0.21          0.21
  REPLACE       1.44k       0.0/s            0.00          0.00
Com_          977.41k       1.3/s            0.45
  set_option  555.99k       0.7/s            0.26
  show_fields 232.94k       0.3/s            0.11
  change_db   184.78k       0.2/s            0.09

__ Rows ________________________________________________________________
Rows          128.88G    168.4k/s
  Using idx     4.51G      5.9k/s  %Index:   3.50
Rows/question  597.83

__ SELECT and Sort _____________________________________________________
Scan            8.70M      11.4/s %SELECT:   4.09
Range           1.39M       1.8/s            0.65
Full join       5.19k       0.0/s            0.00
Range check         0         0/s            0.00
Full rng join       0         0/s            0.00
Sort scan      85.97M     112.3/s
Sort range      1.09M       1.4/s
Sort mrg pass  38.72k       0.1/s

__ Query Cache _________________________________________________________
Memory usage   74.68M of   80.00M  %Usage:  93.35
Block Fragmnt   7.80%
Hits           32.32M      42.2/s
Inserts       178.14M     232.7/s
Insrt:Prune    1.30:1      53.4/s
Hit:Insert     0.18:1

__ Table Locks _________________________________________________________
Waited              0         0/s  %Total:   0.00
Immediate         746       0.0/s

__ Tables ______________________________________________________________
Open              401 of   4096    %Cache:   9.79
Opened          1.18k       0.0/s

__ Connections _________________________________________________________
Max used           51 of    350      %Max:  14.57
Total         184.19k       0.2/s

__ Created Temp ________________________________________________________
Disk table     86.05M     112.4/s   %Disk:  99.62
Table          86.38M     112.8/s    Size: 256.0M
File           52.82k       0.1/s

__ Threads _____________________________________________________________
Running             5 of      2
Created           173       0.0/s
Slow                0         0/s
Cached             49 of    256      %Hit:  99.91

__ Aborted _____________________________________________________________
Clients            68       0.0/s
Connects            0         0/s

__ Bytes _______________________________________________________________
Sent          683.28G    892.6k/s
Received       54.56G     71.3k/s

__ InnoDB Buffer Pool __________________________________________________
Usage         462.94M of  512.00M  %Usage:  90.42
Read hit      100.00%
Pages
  Free          3.14k              %Total:   9.58
  Data         28.65k                       87.44  %Drty:   0.00
  Misc            977                        2.98
  Latched           0                        0.00
Reads         134.22G    175.3k/s
  From disk     9.69k       0.0/s   %Disk:   0.00
  Ahead Rnd         0         0/s
Writes         21.71M      28.4/s
Flushes         3.66M       4.8/s
Wait Free           0         0/s   %Wait:   0.00

__ InnoDB Lock _________________________________________________________
Waits          475463       0.6/s
Current             0
Time acquiring
  Total     102819846 ms
  Average         216 ms
  Max           51996 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
  Reads        10.21k       0.0/s
  Writes        5.59M       7.3/s
  fsync         1.12M       1.5/s
  Pending
    Reads           0
    Writes          0
    fsync           0

Pages
  Created      18.52k       0.0/s
  Read         10.13k       0.0/s
  Written       3.66M       4.8/s

Rows
  Deleted     510.25k       0.7/s
  Inserted      1.20M       1.6/s
  Read        127.74G    166.9k/s
  Updated     279.52k       0.4/s

__ Aria Pagecache ______________________________________________________
Buffer used    38.44M of  768.00M   %Used:   5.00
  Current      32.22M              %Usage:   4.20
Write hit      31.97%
Read hit       83.46%

__ Subquery Cache ______________________________________________________
Hit ratio      78.25%
Hits           23.70M     31.0/s
Miss            6.59M      8.6/s

------------------------------------------------------------------
pidstat -durh 1 10 | sed -e "s|$(hostname)|hostname|g"
...
Linux 3.10.0-1127.el7.x86_64 (hostname)     05/06/2020     _x86_64_    (6 CPU)

#      Time   UID       PID    %usr %system  %guest    %CPU   CPU  minflt/s  majflt/s     VSZ    RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s  Command
 1588790080     0       646    0.99    0.00    0.00    0.99     0      0.00      0.00  474308   2284   0.03      0.00      0.00      0.00  NetworkManager
 1588790080     0       880    0.00    0.00    0.00    0.00     2      0.99      0.00  533484  21568   0.27      0.00      0.00      0.00  rsyslogd
 1588790080   996      1666   63.37    2.97    0.00   66.34     1      3.96      0.00 5147708 1146672  14.32      0.00    447.52    245.54  mysqld
 1588790080  1000     24388   33.66    1.98    0.00   35.64     2    123.76      0.00  748268  43728   0.55      0.00      0.00      0.00  php-fpm
 1588790080     0     24413    0.00    0.99    0.00    0.99     3    304.95      0.00  108448   1088   0.01      0.00      0.00      0.00  pidstat

#      Time   UID       PID    %usr %system  %guest    %CPU   CPU  minflt/s  majflt/s     VSZ    RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s  Command
 1588790081     0       395    0.00    0.00    0.00    0.00     3      1.00      0.00   71788  34512   0.43      0.00      0.00      0.00  systemd-journal
 1588790081     0       646    0.00    1.00    0.00    1.00     0      0.00      0.00  474308   2284   0.03      0.00      0.00      0.00  NetworkManager
 1588790081   996      1666   44.00    0.00    0.00   44.00     1      0.00      0.00 5147708 1146672  14.32      0.00    328.00      8.00  mysqld
 1588790081  1000     24296    0.00    0.00    0.00    0.00     0      1.00      0.00  196528  81968   1.02      0.00      0.00      0.00  nginx
 1588790081  1000     24297    1.00    0.00    0.00    1.00     0      9.00      0.00  196528  82740   1.03      0.00      0.00      0.00  nginx
 1588790081  1000     24388    8.00    0.00    0.00    8.00     2    455.00      0.00  750316  45576   0.57      0.00    368.00      0.00  php-fpm
 1588790081  1000     24392   11.00    1.00    0.00   12.00     3     54.00      0.00  739632  35828   0.45      0.00      0.00      0.00  php-fpm
 1588790081     0     24413    0.00    1.00    0.00    1.00     4    318.00      0.00  108448   1176   0.01      0.00      0.00      0.00  pidstat

#      Time   UID       PID    %usr %system  %guest    %CPU   CPU  minflt/s  majflt/s     VSZ    RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s  Command
 1588790082     0         9    0.00    1.00    0.00    1.00     0      0.00      0.00       0      0   0.00      0.00      0.00      0.00  rcu_sched
 1588790082   996      1666   74.00    3.00    0.00   77.00     1      0.00      0.00 5147708 1146672  14.32      0.00    736.00    144.00  mysqld
 1588790082  1000     24392   23.00    2.00    0.00   25.00     3   1791.00      0.00  745776  41136   0.51      0.00      0.00      0.00  php-fpm
 1588790082     0     24413    1.00    1.00    0.00    2.00     4    296.00      0.00  108448   1176   0.01      0.00      0.00      0.00  pidstat

#      Time   UID       PID    %usr %system  %guest    %CPU   CPU  minflt/s  majflt/s     VSZ    RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s  Command
 1588790083   996      1666   42.00    0.00    0.00   42.00     1      4.00      0.00 5147708 1146672  14.32      0.00    592.00    144.00  mysqld
 1588790083  1000     24296    1.00    0.00    0.00    1.00     0      0.00      0.00  196528  81968   1.02      0.00      0.00      0.00  nginx
 1588790083  1000     24297    0.00    0.00    0.00    0.00     0      1.00      0.00  196528  82740   1.03      0.00      0.00      0.00  nginx
 1588790083  1000     24392   30.00    1.00    0.00   31.00     3   2497.00      0.00  745776  40924   0.51      0.00    440.00      0.00  php-fpm
 1588790083     0     24413    0.00    2.00    0.00    2.00     4    296.00      0.00  108448   1176   0.01      0.00      0.00      0.00  pidstat

#      Time   UID       PID    %usr %system  %guest    %CPU   CPU  minflt/s  majflt/s     VSZ    RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s  Command
 1588790084     0       314    0.00    1.00    0.00    1.00     0      0.00      0.00       0      0   0.00      0.00      0.00      0.00  xfsaild/vda4
 1588790084     0       395    0.00    0.00    0.00    0.00     3      1.00      0.00   71788  34512   0.43      0.00      0.00      0.00  systemd-journal
 1588790084     0       880    0.00    0.00    0.00    0.00     2      1.00      0.00  533484  21568   0.27      0.00      0.00      0.00  rsyslogd
 1588790084   996      1666   46.00    0.00    0.00   46.00     1      0.00      0.00 5147708 1146672  14.32      0.00     88.00     80.00  mysqld
 1588790084  1000     24388   15.00    1.00    0.00   16.00     2      1.00      0.00  750316  45788   0.57      0.00      0.00      0.00  php-fpm
 1588790084     0     24413    0.00    2.00    0.00    2.00     4    296.00      0.00  108448   1176   0.01      0.00      0.00      0.00  pidstat

#      Time   UID       PID    %usr %system  %guest    %CPU   CPU  minflt/s  majflt/s     VSZ    RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s  Command
 1588790085     0         9    0.00    1.00    0.00    1.00     0      0.00      0.00       0      0   0.00      0.00      0.00      0.00  rcu_sched
 1588790085     0       431    0.00    0.00    0.00    0.00     1      0.00      0.00       0      0   0.00      0.00     32.00      0.00  loop0
 1588790085     0       603    0.00    0.00    0.00    0.00     2      2.00      0.00   21692    800   0.01      0.00      0.00      0.00  irqbalance
 1588790085     0       646    1.00    1.00    0.00    2.00     3      0.00      0.00  474308   2284   0.03      0.00      0.00      0.00  NetworkManager
 1588790085   996      1666   42.00    3.00    0.00   45.00     1    220.00      0.00 5147708 1146672  14.32      0.00   5128.00   4768.00  mysqld
 1588790085     0     23768    0.00    0.00    0.00    0.00     1      0.00      0.00  108056    660   0.01      0.00      4.00      0.00  tee
 1588790085  1000     24388   30.00    2.00    0.00   32.00     2      0.00      0.00  750316  45788   0.57      0.00    336.00      0.00  php-fpm
 1588790085     0     24413    0.00    1.00    0.00    1.00     1    296.00      0.00  108448   1176   0.01      0.00      0.00      0.00  pidstat

#      Time   UID       PID    %usr %system  %guest    %CPU   CPU  minflt/s  majflt/s     VSZ    RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s  Command
 1588790086   996      1666   40.00    0.00    0.00   40.00     1      0.00      0.00 5147708 1146672  14.32      0.00     48.00     40.00  mysqld
 1588790086  1000     24296    0.00    0.00    0.00    0.00     0      4.00      0.00  196528  81968   1.02      4.00      0.00      0.00  nginx
 1588790086  1000     24392   12.00    1.00    0.00   13.00     2     15.00      0.00  745776  40924   0.51      0.00      0.00      0.00  php-fpm
 1588790086     0     24413    1.00    1.00    0.00    2.00     1    296.00      0.00  108448   1176   0.01      0.00      0.00      0.00  pidstat

#      Time   UID       PID    %usr %system  %guest    %CPU   CPU  minflt/s  majflt/s     VSZ    RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s  Command
 1588790087     0       880    0.00    0.00    0.00    0.00     2      1.00      0.00  533484  21580   0.27      0.00      4.00      4.00  rsyslogd
 1588790087   996      1666   73.00    3.00    0.00   76.00     1      0.00      0.00 5147708 1146672  14.32      0.00    268.00     72.00  mysqld
 1588790087  1000     24392   24.00    2.00    0.00   26.00     2    286.00      0.00  745776  41976   0.52      0.00      0.00      0.00  php-fpm
 1588790087     0     24413    0.00    2.00    0.00    2.00     1    296.00      0.00  108448   1176   0.01      0.00      0.00      0.00  pidstat
 1588790087     0     34747    1.00    2.00    0.00    3.00     0   1337.00      0.00  172760  24108   0.30      0.00      0.00      0.00  lfd - sleeping

#      Time   UID       PID    %usr %system  %guest    %CPU   CPU  minflt/s  majflt/s     VSZ    RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s  Command
 1588790088     0       646    1.00    0.00    0.00    1.00     5      0.00      0.00  474308   2284   0.03      0.00      0.00      0.00  NetworkManager
 1588790088   996      1666    3.00    2.00    0.00    5.00     1      0.00      0.00 5147708 1146672  14.32      0.00   1672.00      0.00  mysqld
 1588790088  1000     24296    1.00    0.00    0.00    1.00     0      0.00      0.00  196528  81968   1.02      0.00      0.00      0.00  nginx
 1588790088  1000     24297    1.00    1.00    0.00    2.00     3      0.00      0.00  196528  82740   1.03      0.00      0.00      0.00  nginx
 1588790088  1000     24388    1.00    0.00    0.00    1.00     3      5.00      0.00  733932  29424   0.37      0.00      0.00      0.00  php-fpm
 1588790088  1000     24392   18.00    1.00    0.00   19.00     2   1347.00      0.00  747824  44240   0.55      0.00    348.00      0.00  php-fpm
 1588790088     0     24413    0.00    1.00    0.00    1.00     1    296.00      0.00  108448   1176   0.01      0.00      0.00      0.00  pidstat

#      Time   UID       PID    %usr %system  %guest    %CPU   CPU  minflt/s  majflt/s     VSZ    RSS   %MEM   kB_rd/s   kB_wr/s kB_ccwr/s  Command
 1588790089     0         1    0.00    0.00    0.00    0.00     0      1.00      0.00  191204   3356   0.04      0.00      0.00      0.00  systemd
 1588790089     0         9    0.00    1.00    0.00    1.00     5      0.00      0.00       0      0   0.00      0.00      0.00      0.00  rcu_sched
 1588790089   996      1666   80.00    0.00    0.00   80.00     1      0.00      0.00 5147708 1146672  14.32      0.00    220.00    208.00  mysqld
 1588790089     0     23768    0.00    0.00    0.00    0.00     1      0.00      0.00  108056    660   0.01      0.00      4.00      0.00  tee
 1588790089  1000     24297    0.00    0.00    0.00    0.00     0      4.00      0.00  196528  82740   1.03      0.00      0.00      0.00  nginx
 1588790089  1000     24346   46.00    5.00    0.00   51.00     4  12393.00      0.00  771956  69076   0.86      0.00      0.00      0.00  php-fpm
 1588790089  1000     24388   29.00    2.00    0.00   31.00     3   3378.00      0.00  746220  41600   0.52      0.00      0.00      0.00  php-fpm
 1588790089     0     24413    0.00    1.00    0.00    1.00     1    296.00      0.00  108448   1176   0.01      0.00      0.00      0.00  pidstat

------------------------------------------------------------------
 CPU Utilisation % Last 7 days (6 CPU Threads):
------------------------------------------------------------------
%CPU  min:  %user:  0.07   %nice:  0.00  %system:  0.13  %iowait:  0.00  %steal:  0.01  %idle:  24.51
%CPU  avg:  %user:  7.35   %nice:  0.00  %system:  1.11  %iowait:  0.02  %steal:  0.13  %idle:  91.40
%CPU  max:  %user:  70.04  %nice:  0.06  %system:  8.48  %iowait:  2.35  %steal:  2.20  %idle:  99.77
%CPU  50%:  %user:  2.68   %nice:  0.00  %system:  0.34  %iowait:  0.01  %steal:  0.06  %idle:  96.93
%CPU  75%:  %user:  11.12  %nice:  0.00  %system:  1.94  %iowait:  0.01  %steal:  0.13  %idle:  99.70
%CPU  90%:  %user:  21.50  %nice:  0.00  %system:  2.93  %iowait:  0.03  %steal:  0.26  %idle:  99.73
%CPU  95%:  %user:  28.26  %nice:  0.00  %system:  3.45  %iowait:  0.03  %steal:  0.46  %idle:  99.75
%CPU  99%:  %user:  44.29  %nice:  0.00  %system:  4.72  %iowait:  0.08  %steal:  0.95  %idle:  99.76

------------------------------------------------------------------
 CPU Utilisation % Daily Last 7 days (6 CPU Threads):
------------------------------------------------------------------
May 06 2020 %CPU
%CPU  min:  %user:  1.22   %nice:  0.00  %system:  0.20  %iowait:  0.00  %steal:  0.01  %idle:  41.54
%CPU  avg:  %user:  7.94   %nice:  0.00  %system:  1.06  %iowait:  0.02  %steal:  0.08  %idle:  90.90
%CPU  max:  %user:  54.18  %nice:  0.05  %system:  4.93  %iowait:  2.11  %steal:  0.61  %idle:  98.54
%CPU  95%:  %user:  21.42  %nice:  0.00  %system:  3.11  %iowait:  0.03  %steal:  0.18  %idle:  98.07
May 05 2020 %CPU
%CPU  min:  %user:  1.42   %nice:  0.00  %system:  0.25  %iowait:  0.00  %steal:  0.02  %idle:  50.09
%CPU  avg:  %user:  8.11   %nice:  0.00  %system:  1.31  %iowait:  0.02  %steal:  0.16  %idle:  90.40
%CPU  max:  %user:  44.01  %nice:  0.06  %system:  4.53  %iowait:  2.34  %steal:  1.72  %idle:  98.29
%CPU  95%:  %user:  17.98  %nice:  0.00  %system:  3.03  %iowait:  0.03  %steal:  0.50  %idle:  97.81
May 04 2020 %CPU
%CPU  min:  %user:  0.97   %nice:  0.00  %system:  0.29  %iowait:  0.00  %steal:  0.03  %idle:  24.51
%CPU  avg:  %user:  16.53  %nice:  0.00  %system:  2.36  %iowait:  0.03  %steal:  0.25  %idle:  80.83
%CPU  max:  %user:  70.04  %nice:  0.05  %system:  6.17  %iowait:  2.35  %steal:  2.20  %idle:  98.65
%CPU  95%:  %user:  33.34  %nice:  0.00  %system:  3.81  %iowait:  0.05  %steal:  0.71  %idle:  97.03
May 03 2020 %CPU
%CPU  min:  %user:  1.16   %nice:  0.00  %system:  0.22  %iowait:  0.00  %steal:  0.02  %idle:  29.11
%CPU  avg:  %user:  14.37  %nice:  0.00  %system:  1.92  %iowait:  0.03  %steal:  0.20  %idle:  83.47
%CPU  max:  %user:  62.32  %nice:  0.03  %system:  7.69  %iowait:  2.29  %steal:  1.99  %idle:  98.58
%CPU  95%:  %user:  45.12  %nice:  0.00  %system:  4.03  %iowait:  0.05  %steal:  0.74  %idle:  98.18
May 02 2020 %CPU
%CPU  min:  %user:  1.06   %nice:  0.00  %system:  0.23  %iowait:  0.00  %steal:  0.02  %idle:  50.69
%CPU  avg:  %user:  10.61  %nice:  0.00  %system:  1.61  %iowait:  0.03  %steal:  0.14  %idle:  87.61
%CPU  max:  %user:  45.58  %nice:  0.02  %system:  8.48  %iowait:  1.89  %steal:  1.01  %idle:  98.66
%CPU  95%:  %user:  34.80  %nice:  0.00  %system:  4.34  %iowait:  0.03  %steal:  0.55  %idle:  97.95
May 01 2020 %CPU
%CPU  min:  %user:  0.07   %nice:  0.00  %system:  0.14  %iowait:  0.00  %steal:  0.02  %idle:  76.36
%CPU  avg:  %user:  1.01   %nice:  0.00  %system:  0.28  %iowait:  0.00  %steal:  0.06  %idle:  98.65
%CPU  max:  %user:  20.81  %nice:  0.02  %system:  2.36  %iowait:  0.05  %steal:  0.62  %idle:  99.76
%CPU  95%:  %user:  9.44   %nice:  0.00  %system:  1.34  %iowait:  0.01  %steal:  0.14  %idle:  99.74
Apr 30 2020 %CPU
%CPU  min:  %user:  0.07  %nice:  0.00  %system:  0.13  %iowait:  0.00  %steal:  0.01  %idle:  99.35
%CPU  avg:  %user:  0.08  %nice:  0.00  %system:  0.15  %iowait:  0.00  %steal:  0.05  %idle:  99.72
%CPU  max:  %user:  0.26  %nice:  0.02  %system:  0.32  %iowait:  0.04  %steal:  0.24  %idle:  99.77
%CPU  95%:  %user:  0.10  %nice:  0.00  %system:  0.17  %iowait:  0.00  %steal:  0.09  %idle:  99.76
Apr 29 2020 %CPU
%CPU  min:  %user:  0.07   %nice:  0.00  %system:  0.13  %iowait:  0.00  %steal:  0.01  %idle:  84.09
%CPU  avg:  %user:  0.24   %nice:  0.00  %system:  0.19  %iowait:  0.00  %steal:  0.05  %idle:  99.52
%CPU  max:  %user:  15.02  %nice:  0.02  %system:  1.36  %iowait:  0.04  %steal:  0.17  %idle:  99.77
%CPU  95%:  %user:  0.30   %nice:  0.00  %system:  0.26  %iowait:  0.00  %steal:  0.11  %idle:  99.76

------------------------------------------------------------------
 Memory Usage Daily Last 7 days (6 CPU Threads):
------------------------------------------------------------------

May 06 2020 Memory
Memory      min:
kbmemfree:  121536.0   kbmemused:  3013912.0  %memused:  37.6       kbbuffers:  216.0      kbcached:  413056.0
kbcommit:   3233536.0  %commit:    37.4       kbactive:  795780.0   kbinact:    1022848.0  kbdirty:   0.0
Memory      avg:
kbmemfree:  2786215.3  kbmemused:  5222228.7  %memused:  65.2       kbbuffers:  250.3      kbcached:  1264861.5
kbcommit:   3439311.7  %commit:    39.8       kbactive:  1127007.5  kbinact:    1648627.3  kbdirty:   2632.6
Memory      max:
kbmemfree:  4994532.0  kbmemused:  7886908.0  %memused:  98.5       kbbuffers:  364.0      kbcached:  5226980.0
kbcommit:   6968424.0  %commit:    80.7       kbactive:  3925484.0  kbinact:    5012564.0  kbdirty:   403640.0
Memory      95%:
kbmemfree:  4803820.4  kbmemused:  7316023.4  %memused:  91.3       kbbuffers:  348.0      kbcached:  1855101.8
kbcommit:   3766174.2  %commit:    43.6       kbactive:  1488183.6  kbinact:    2114400.8  kbdirty:   3892.8

May 05 2020 Memory
Memory      min:
kbmemfree:  126440.0   kbmemused:  3064648.0  %memused:  38.3       kbbuffers:  292.0      kbcached:  463700.0
kbcommit:   3233888.0  %commit:    37.4       kbactive:  792852.0   kbinact:    1031600.0  kbdirty:   0.0
Memory      avg:
kbmemfree:  1967045.7  kbmemused:  6041398.3  %memused:  75.4       kbbuffers:  471.6      kbcached:  1580463.5
kbcommit:   3430412.4  %commit:    39.7       kbactive:  1208126.6  kbinact:    1857040.9  kbdirty:   1482.9
Memory      max:
kbmemfree:  4943796.0  kbmemused:  7882004.0  %memused:  98.4       kbbuffers:  3144.0     kbcached:  5129356.0
kbcommit:   4031896.0  %commit:    46.7       kbactive:  3411504.0  kbinact:    4806156.0  kbdirty:   132072.0
Memory      95%:
kbmemfree:  4705966.8  kbmemused:  7587281.2  %memused:  94.7       kbbuffers:  2837.2     kbcached:  2321431.6
kbcommit:   3723122.0  %commit:    43.1       kbactive:  1550681.6  kbinact:    2512882.8  kbdirty:   4022.0

May 04 2020 Memory
Memory      min:
kbmemfree:  134372.0   kbmemused:  3484892.0  %memused:  43.5       kbbuffers:  472.0      kbcached:  490932.0
kbcommit:   3179192.0  %commit:    36.8       kbactive:  1109348.0  kbinact:    1048920.0  kbdirty:   0.0
Memory      avg:
kbmemfree:  1572101.2  kbmemused:  6436342.8  %memused:  80.4       kbbuffers:  17587.1    kbcached:  2174629.4
kbcommit:   3761529.2  %commit:    43.5       kbactive:  1745554.1  kbinact:    2137970.3  kbdirty:   2462.7
Memory      max:
kbmemfree:  4523552.0  kbmemused:  7874072.0  %memused:  98.3       kbbuffers:  31676.0    kbcached:  4582828.0
kbcommit:   4860584.0  %commit:    56.3       kbactive:  3560584.0  kbinact:    4259548.0  kbdirty:   281984.0
Memory      95%:
kbmemfree:  3698535.2  kbmemused:  7659792.4  %memused:  95.7       kbbuffers:  31632.0    kbcached:  3113288.4
kbcommit:   4616210.4  %commit:    53.4       kbactive:  2196030.0  kbinact:    2879626.4  kbdirty:   4001.6

May 03 2020 Memory
Memory      min:
kbmemfree:  129188.0   kbmemused:  2888408.0  %memused:  36.1       kbbuffers:  260.0      kbcached:  443004.0
kbcommit:   3112900.0  %commit:    36.0       kbactive:  770700.0   kbinact:    974372.0   kbdirty:   0.0
Memory      avg:
kbmemfree:  2091966.8  kbmemused:  5916477.2  %memused:  73.9       kbbuffers:  1834.0     kbcached:  1642607.6
kbcommit:   3690871.9  %commit:    42.7       kbactive:  1458336.4  kbinact:    1743780.6  kbdirty:   3388.5
Memory      max:
kbmemfree:  5120036.0  kbmemused:  7879256.0  %memused:  98.4       kbbuffers:  13112.0    kbcached:  5368004.0
kbcommit:   5051188.0  %commit:    58.5       kbactive:  3312420.0  kbinact:    5324888.0  kbdirty:   274840.0
Memory      95%:
kbmemfree:  4832990.0  kbmemused:  7565785.2  %memused:  94.5       kbbuffers:  7853.6     kbcached:  2957228.0
kbcommit:   4619149.2  %commit:    53.5       kbactive:  2279188.8  kbinact:    3193163.6  kbdirty:   7598.0

May 02 2020 Memory
Memory      min:
kbmemfree:  133904.0   kbmemused:  3148776.0  %memused:  39.3       kbbuffers:  296.0      kbcached:  480936.0
kbcommit:   3299452.0  %commit:    38.2       kbactive:  830444.0   kbinact:    994492.0   kbdirty:   0.0
Memory      avg:
kbmemfree:  1539172.2  kbmemused:  6469271.8  %memused:  80.8       kbbuffers:  2589.1     kbcached:  2768585.0
kbcommit:   3549629.8  %commit:    41.1       kbactive:  1727196.6  kbinact:    2480574.2  kbdirty:   4955.4
Memory      max:
kbmemfree:  4859668.0  kbmemused:  7874540.0  %memused:  98.3       kbbuffers:  3972.0     kbcached:  5082596.0
kbcommit:   4969736.0  %commit:    57.5       kbactive:  3453280.0  kbinact:    4393312.0  kbdirty:   368552.0
Memory      95%:
kbmemfree:  4370181.6  kbmemused:  7832682.0  %memused:  97.8       kbbuffers:  3884.0     kbcached:  4448608.4
kbcommit:   4116510.4  %commit:    47.7       kbactive:  2477203.2  kbinact:    3875516.0  kbdirty:   13002.0

May 01 2020 Memory
Memory      min:
kbmemfree:  252852.0   kbmemused:  6951640.0  %memused:  86.8       kbbuffers:  3808.0     kbcached:  3746640.0
kbcommit:   3200060.0  %commit:    37.0       kbactive:  1605820.0  kbinact:    3255772.0  kbdirty:   4.0
Memory      avg:
kbmemfree:  976619.0   kbmemused:  7031825.0  %memused:  87.8       kbbuffers:  3972.1     kbcached:  4227906.8
kbcommit:   3255152.5  %commit:    37.7       kbactive:  1649092.6  kbinact:    3444087.4  kbdirty:   121.7
Memory      max:
kbmemfree:  1056804.0  kbmemused:  7755592.0  %memused:  96.8       kbbuffers:  4016.0     kbcached:  4492016.0
kbcommit:   3766184.0  %commit:    43.6       kbactive:  2347508.0  kbinact:    3651920.0  kbdirty:   5492.0
Memory      95%:
kbmemfree:  1052137.0  kbmemused:  7472453.0  %memused:  93.3       kbbuffers:  4000.0     kbcached:  4281279.0
kbcommit:   3391196.0  %commit:    39.3       kbactive:  1964605.0  kbinact:    3466164.0  kbdirty:   337.0

Apr 30 2020 Memory
Memory      min:
kbmemfree:  962260.0   kbmemused:  6866768.0  %memused:  85.7       kbbuffers:  3928.0     kbcached:  4237372.0
kbcommit:   3230792.0  %commit:    37.4       kbactive:  1596456.0  kbinact:    3432012.0  kbdirty:   0.0
Memory      avg:
kbmemfree:  1089633.2  kbmemused:  6918810.8  %memused:  86.4       kbbuffers:  3953.3     kbcached:  4251875.7
kbcommit:   3246694.7  %commit:    37.6       kbactive:  1606015.2  kbinact:    3444650.6  kbdirty:   59.4
Memory      max:
kbmemfree:  1141676.0  kbmemused:  7046184.0  %memused:  88.0       kbbuffers:  3968.0     kbcached:  4270756.0
kbcommit:   3382684.0  %commit:    39.2       kbactive:  1735388.0  kbinact:    3459004.0  kbdirty:   5464.0
Memory      95%:
kbmemfree:  1128230.0  kbmemused:  6953787.2  %memused:  86.8       kbbuffers:  3968.0     kbcached:  4269346.8
kbcommit:   3263620.0  %commit:    37.8       kbactive:  1609613.2  kbinact:    3458340.0  kbdirty:   32.0

Apr 29 2020 Memory
Memory      min:
kbmemfree:  1071452.0  kbmemused:  5785068.0  %memused:  72.2       kbbuffers:  3560.0     kbcached:  3375856.0
kbcommit:   3222864.0  %commit:    37.3       kbactive:  1459420.0  kbinact:    2685724.0  kbdirty:   4.0
Memory      avg:
kbmemfree:  1974102.6  kbmemused:  6034341.4  %memused:  75.3       kbbuffers:  3634.7     kbcached:  3566358.9
kbcommit:   3247337.6  %commit:    37.6       kbactive:  1506921.1  kbinact:    2840276.6  kbdirty:   308.3
Memory      max:
kbmemfree:  2223376.0  kbmemused:  6936992.0  %memused:  86.6       kbbuffers:  3928.0     kbcached:  4237284.0
kbcommit:   3387640.0  %commit:    39.2       kbactive:  1655276.0  kbinact:    3448008.0  kbdirty:   17464.0
Memory      95%:
kbmemfree:  2212840.8  kbmemused:  6905595.6  %memused:  86.2       kbbuffers:  3928.0     kbcached:  4235921.2
kbcommit:   3285738.8  %commit:    38.0       kbactive:  1602986.0  kbinact:    3433137.6  kbdirty:   36.0
------------------------------------------------------------------
Stats saved at: /root/centminlogs/cminfo-top-060520-183423.log
------------------------------------------------------------------
     
  5. May 7, 2020 #5
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    10:15 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    Well Centmin Mod is provided as is, so Wordpress specific issues to your site would be left up to you to work out. Looks like only 3.5% of your query returned rows uses mysql indexes which probably related to how Woocommerce stores product/data in Wordpress database by default. So I can imagine everything would be slow as 96.5% of all queries rows are retrieved without any mysql indexes. And it's probably due to Woocommerce needing further optimisations on both MySQL database end i.e. wp_postmeta table etc + Wordpress frontend. Just google search for 'woocommerce save product high cpu load lag' terms reveals your problem is a common with Woocommerce and various fixes and workarounds that are beyond Centmin Mod itself.
     
Previous Thread Next Thread
Loading...

.