Want to subscribe to topics you're interested in?
Become a Member

MariaDB DB problems, daily freezes

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by redbird, Oct 9, 2015.

  1. redbird

    redbird Member

    42
    6
    8
    Aug 28, 2015
    Web
    Ratings:
    +10
    Local Time:
    11:00 PM
    Centminmod: Centmin Mod 1.2.3-eva2000.08
    MariaDB ver: 10.0.21

    Hi,

    We have a vultr.com 4GB VPS setup with centminmod. Every day at some point for 10-20 minutes websites on server are not accessible via http. At the same time, i'm getting server mail:

    PHP Warning: Error while sending QUERY packet. PID=9091 in /home/nginx/domains/domain.com/public/core/SQLWorkbench_mysqli.php on line 48
    PHP Fatal error: Uncaught exception 'SQLWorkbenchException' with message 'Execution error
    <br />MySQL server has gone away' in /home/nginx/domains/domain.com/public/core/SQLWorkbench.php:414 ......


    However in SSH I can connect to MariaDB just fine.
    The command show full processlist; shows only a few sleeping processes
    It seems that MariaDB is running but not loaded with anything.

    "php-fpm" restart does not do anything. And the weird thing is that in several minutes everything goes back to normal by itself.

    Also some of the tables are getting corrupted.

    Any ideas on what could be wrong and how to troubleshoot it?

    Thank you.
    Mike
     
  2. redbird

    redbird Member

    42
    6
    8
    Aug 28, 2015
    Web
    Ratings:
    +10
    Local Time:
    11:00 PM
    We have 4 VPS, 2 with centminmod and 2 with vestacp.

    Both centminmod servers have corrupted tables in mariadb
     
  3. eva2000

    eva2000 Administrator Staff Member

    30,961
    6,918
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,420
    Local Time:
    11:00 PM
    Nginx 1.13.x
    MariaDB 5.5
    What and how are using SQLWorkbench for ? mysql backups ? data manipulation ? time of day ? any patterns ?

    MySQL :: MySQL 5.6 Reference Manual :: B.5.2.9 MySQL server has gone away

    can you elaborate on how you came to that conclusion ? errors and tests done ? and how you are repairing it ?

    You can check your mysql error log which is listed along with all other log file locations as per How to troubleshoot Centmin Mod initial install issues (/var/log/mysqld.log) for clues.
     
    Last edited: Oct 10, 2015
  4. redbird

    redbird Member

    42
    6
    8
    Aug 28, 2015
    Web
    Ratings:
    +10
    Local Time:
    11:00 PM
    Data manipulation. it's a saas website working with content extraction and publishing.

    mysqlcheck -A -c --auto-repair
    mysqlcheck -A -o

    Here is a snippet from /var/log/mysqld.log:
    Let me describe again what's happening:
    When you open the site in browser, the page is loading forever, then eventually times out: nginx message: bad gateway
    while mysql works just fine and there are no processes running in it.
     
    Last edited: Oct 13, 2015
  5. redbird

    redbird Member

    42
    6
    8
    Aug 28, 2015
    Web
    Ratings:
    +10
    Local Time:
    11:00 PM
    Below is the report from mysqlmymonlite.sh
    Please advice if anything needs to be changed in mysql settings.

    Code (Text):
    -------------------------------------------------------------
    System MySQL monitoring stats
    mysqlmymonlite.sh - 0.5.4 mysqlmymon.com
    compiled by George Liu (eva2000) vbtechsupport.com
    -------------------------------------------------------------
    
    Report Generated:
    Mon Oct 12 10:04:21 EDT 2015
    
    ----------------------------
    MySQL Uptime:
    ----------------------------
    MySQL server was started
    Uptime: 18 hours 40 min 15 sec 
    Uptime 67215
    Uptime_since_flush_status 67215
    
    Max Used Connections:      26/300 (8.67%)
    Key Buffer Used:           26.16M/32.00M (81.74%)
    Key Buffer Used:           2.04M/8.00M (25.49%)
    Current Key Buffer Usage:  32.00M (100.00%)
    Current Key Buffer Usage:  336.00k (4.10%)
    Query Cache:               13.12M/16.00M (82.01%)
    Table Locks Waited:        1.83k Rate: 0.0/s (0.04%)
    --------------------
    Query Cache Limit (bytes): 524288
    Query Cache Min Unit (bytes): 2048
    Query Cache Size (bytes): 16777216
    Query Cache Free Mem (bytes): 3017552
    Query Cache Used Mem (bytes): 13759664
    Queries in Query Cache: 1
    Query Cache Avg Size (bytes): 13759664
    
    ----------------------------
    Hardware Info:
    ----------------------------
    Processors physical = 1, cores = 1, virtual = 2, hyperthreading = yes
          2  3600.016
          2  Virtual CPU e7da7129d3ee
          2  4096 KB
    
    
    ----------------------------
    TOP stats
    ----------------------------
    
    Linux 3.10.0-229.14.1.el7.x86_64 ((yourserverhostname))     10/12/2015     _x86_64_    (2 CPU)
    
    10:04:21 AM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest  %gnice   %idle
    10:04:23 AM  all    1.75    0.00    0.50    0.00    0.00    0.00    0.00    0.00    0.00   97.74
    10:04:23 AM    0    1.51    0.00    0.50    0.00    0.00    0.00    0.00    0.00    0.00   97.99
    10:04:23 AM    1    1.51    0.00    0.50    0.00    0.00    0.00    0.00    0.00    0.00   97.99
    
    10:04:23 AM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest  %gnice   %idle
    10:04:25 AM  all    4.75    0.00    1.25    0.25    0.00    0.00    0.00    0.00    0.00   93.75
    10:04:25 AM    0    3.00    0.00    1.50    0.00    0.00    0.00    0.00    0.00    0.00   95.50
    10:04:25 AM    1    6.53    0.00    1.51    0.00    0.00    0.00    0.00    0.00    0.00   91.96
    
    Average:     CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest  %gnice   %idle
    Average:     all    3.25    0.00    0.88    0.13    0.00    0.00    0.00    0.00    0.00   95.74
    Average:       0    2.26    0.00    1.00    0.00    0.00    0.00    0.00    0.00    0.00   96.74
    Average:       1    4.02    0.00    1.01    0.00    0.00    0.00    0.00    0.00    0.00   94.97
    
    top - 10:04:25 up 18:40,  2 users,  load average: 0.29, 0.15, 0.14
    Tasks: 135 total,   1 running, 133 sleeping,   0 stopped,   1 zombie
    %Cpu(s):  5.8 us,  1.6 sy,  0.0 ni, 92.3 id,  0.2 wa,  0.0 hi,  0.1 si,  0.1 st
    KiB Mem :  3882636 total,   122896 free,   614864 used,  3144876 buff/cache
    KiB Swap:  4095996 total,  3906216 free,   189780 used.  2753636 avail Mem
    
      PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+ COMMAND
        1 root      20   0   54208   2848   1780 S   0.0  0.1   0:11.18 systemd
        2 root      20   0       0      0      0 S   0.0  0.0   0:00.06 kthreadd
        3 root      20   0       0      0      0 S   0.0  0.0   0:00.36 ksoftirqd/0
        5 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/0:+
        7 root      rt   0       0      0      0 S   0.0  0.0   0:00.19 migration/0
        8 root      20   0       0      0      0 S   0.0  0.0   0:00.00 rcu_bh
        9 root      20   0       0      0      0 S   0.0  0.0   0:00.00 rcuob/0
       10 root      20   0       0      0      0 S   0.0  0.0   0:00.00 rcuob/1
       11 root      20   0       0      0      0 S   0.0  0.0   2:11.91 rcu_sched
       12 root      20   0       0      0      0 S   0.0  0.0   1:42.33 rcuos/0
       13 root      20   0       0      0      0 S   0.0  0.0   2:32.75 rcuos/1
       14 root      rt   0       0      0      0 S   0.0  0.0   0:00.22 watchdog/0
       15 root      rt   0       0      0      0 S   0.0  0.0   0:00.28 watchdog/1
       16 root      rt   0       0      0      0 S   0.0  0.0   0:00.10 migration/1
       17 root      20   0       0      0      0 S   0.0  0.0   0:01.56 ksoftirqd/1
       19 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/1:+
       20 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 khelper
       21 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kdevtmpfs
       22 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 netns
       23 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 writeback
       24 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kintegrityd
       25 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 bioset
       26 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kblockd
       27 root      20   0       0      0      0 S   0.0  0.0   0:00.03 khubd
       28 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 md
       32 root      20   0       0      0      0 S   0.0  0.0   0:00.01 khungtaskd
       33 root      20   0       0      0      0 S   0.0  0.0   0:27.57 kswapd0
       34 root      25   5       0      0      0 S   0.0  0.0   0:00.00 ksmd
       35 root      39  19       0      0      0 S   0.0  0.0   0:05.77 khugepaged
       36 root      20   0       0      0      0 S   0.0  0.0   0:00.00 fsnotify_m+
       37 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 crypto
       45 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kthrotld
       47 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kmpath_rda+
       48 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kpsmoused
       67 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 deferwq
       91 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kauditd
      216 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 ata_sff
      217 root      20   0       0      0      0 S   0.0  0.0   0:00.00 scsi_eh_0
      218 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 scsi_tmf_0
      219 root      20   0       0      0      0 S   0.0  0.0   0:00.00 scsi_eh_1
      220 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 scsi_tmf_1
      230 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 ttm_swap
      245 root       0 -20       0      0      0 S   0.0  0.0   0:00.14 kworker/1:+
      249 root       0 -20       0      0      0 S   0.0  0.0   0:01.07 kworker/0:+
      255 root      20   0       0      0      0 S   0.0  0.0   0:11.72 jbd2/vda1-8
      256 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 ext4-rsv-c+
      257 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 ext4-unrsv+
      325 root      20   0   43016   6676   6544 S   0.0  0.2   0:10.88 systemd-jo+
      340 root      20   0   42328    932    928 S   0.0  0.0   0:00.15 systemd-ud+
      351 root       0 -20       0      0      0 S   0.0  0.0   0:01.60 loop0
      368 root      20   0       0      0      0 S   0.0  0.0   0:00.00 vballoon
      369 root      20   0       0      0      0 S   0.0  0.0   0:01.99 hwrng
      411 root      20   0       0      0      0 S   0.0  0.0   0:00.46 jbd2/loop0+
      412 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 ext4-rsv-c+
      413 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 ext4-unrsv+
      440 root      20   0   19152    980    876 S   0.0  0.0   0:02.40 irqbalance
      441 root      20   0   12136   3224    568 S   0.0  0.1   0:07.62 haveged
      454 root      20   0  433172   3592   2848 S   0.0  0.1   0:06.12 NetworkMan+
      455 root      20   0  335620   7712   5452 S   0.0  0.2   0:04.29 rsyslogd
      458 root      20   0  550480   3644   3132 S   0.0  0.1   0:05.68 tuned
      459 root      20   0    4372    508    476 S   0.0  0.0   0:14.28 rngd
      460 dbus      20   0   26896   1524   1124 S   0.0  0.0   0:09.31 dbus-daemon
      464 ntp       20   0   31432   1412   1280 S   0.0  0.0   0:00.24 ntpd
      475 root      20   0   34788   1496   1300 S   0.0  0.0   0:05.91 systemd-lo+
      483 root      20   0  126300   1076    912 S   0.0  0.0   0:01.30 crond
      515 polkitd   20   0  513988   2356   2124 S   0.0  0.1   0:04.51 polkitd
      776 root      20   0  103760    844    608 S   0.0  0.0   0:00.03 dhclient
      831 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/1:2
      864 root      20   0   82508   2308   2216 S   0.0  0.1   0:00.02 sshd
      912 root      20   0  115352   1232   1228 S   0.0  0.0   0:00.01 mysqld_safe
     1002 root      20   0  202500   1164   1076 S   0.0  0.0   0:00.00 pure-ftpd
     1003 nsd       20   0   15340    572    524 S   0.0  0.0   0:00.03 nsd
     1006 nsd       20   0   22204    336    296 S   0.0  0.0   0:00.00 nsd
     1007 nsd       20   0   15552     96      0 S   0.0  0.0   0:00.00 nsd
     1519 root      20   0   91508   1080    996 S   0.0  0.0   0:00.50 master
     1564 postfix   20   0   91792   2592   2428 S   0.0  0.1   0:00.33 qmgr
     1699 mysql     20   0  586488 185800   7356 S   0.0  4.8  31:53.42 mysqld
     1864 root      20   0  168356   1820   1360 S   0.0  0.0   0:00.00 crond
     1869 nginx     20   0  113116   1140    964 S   0.0  0.0   0:00.00 bash
     1870 nginx     20   0  429060  28236  11604 S   0.0  0.7   0:01.00 php
     2587 root      20   0  171184   8260   1404 S   0.0  0.2   0:06.99 lfd - slee+
     2611 nobody    20   0  364624  21532    620 S   0.0  0.6   0:39.37 memcached
     2626 root      20   0  196180  19208    296 S   0.0  0.5   0:00.11 nginx
     2627 nginx     10 -10  212568  31640   1524 S   0.0  0.8   1:51.46 nginx
     2635 nginx     10 -10  212568  32608   2004 S   0.0  0.8   1:52.27 nginx
     2640 root      20   0  241628   2420    936 S   0.0  0.1   0:55.18 python
     2711 root      20   0       0      0      0 S   0.0  0.0   0:00.03 kworker/0:0
     3077 root      20   0  110004    648    644 S   0.0  0.0   0:00.00 agetty
     3390 nginx     20   0  607976 139668 102192 S   0.0  3.6   0:06.02 php-fpm
     3408 root      20   0  131212   4700   3540 S   0.0  0.1   0:00.02 sshd
     3420 root      20   0   52656   2068   1508 S   0.0  0.1   0:00.00 sftp-server
     3875 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/1:1
     3883 nginx     20   0  608980 145504 107088 S   0.0  3.7   0:04.27 php-fpm
     3983 nginx     20   0  603504 142892 109976 S   0.0  3.7   0:04.33 php-fpm
     4268 root      20   0       0      0      0 S   0.0  0.0   0:00.04 kworker/u4+
     4607 root      20   0       0      0      0 S   0.0  0.0   0:00.02 kworker/0:2
     4879 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/1:3
     5443 root      20   0  168356   1852   1392 S   0.0  0.0   0:00.00 crond
     5444 root      20   0  113116   1488   1280 S   0.0  0.0   0:00.00 run-parts
     5458 root      20   0  346088  20988   7064 S   0.0  0.5   0:00.10 yum-cron
     5459 root      20   0  113480    980    840 S   0.0  0.0   0:00.00 awk
     5484 postfix   20   0   91616   3960   2908 S   0.0  0.1   0:00.00 trivial-re+
     5668 root      20   0  168356   1856   1396 S   0.0  0.0   0:00.00 crond
     5669 nginx     20   0  113116   1192   1020 S   0.0  0.0   0:00.00 bash
     5670 nginx     20   0  426980  27256  12552 S   0.0  0.7   0:00.49 php
     6471 root      20   0  168356   1856   1392 S   0.0  0.0   0:00.00 crond
     6485 nginx     20   0  113116   1192   1020 S   0.0  0.0   0:00.00 bash
     6502 nginx     20   0  427792  27848  12572 S   0.0  0.7   0:00.57 php
     6531 nginx     20   0  609244 108136  69796 S   0.0  2.8   0:01.16 php-fpm
     6746 postfix   20   0   91612   3960   2908 S   0.0  0.1   0:00.00 pickup
     6870 root      20   0  168356   1852   1392 S   0.0  0.0   0:00.00 crond
     6871 nginx     20   0  113116   1196   1020 S   0.0  0.0   0:00.00 bash
     6872 nginx     20   0  426156  26504  12580 S   0.0  0.7   0:00.23 php
     6907 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/0:1
     6930 root      20   0  241628   4160   1252 S   0.0  0.1   0:00.00 python
     6984 root      20   0  113648   2044   1292 S   0.0  0.1   0:00.00 mysqlmymon+
     7119 root      20   0       0      0      0 Z   0.0  0.0   0:00.00 python
     7122 root      20   0  129888   1584   1196 R   0.0  0.0   0:00.00 top
     8838 root      20   0  168356   1436   1360 S   0.0  0.0   0:00.00 crond
     8844 nginx     20   0  113116    964    964 S   0.0  0.0   0:00.00 bash
     8847 nginx     20   0  437884  11980  11352 S   0.0  0.3   0:01.97 php
     9470 root      20   0  488592   8484   1408 S   0.0  0.2   0:02.66 php-fpm
    13903 postfix   20   0   91624   2968   2720 S   0.0  0.1   0:00.02 tlsmgr
    14150 root      20   0  168356   1852   1392 S   0.0  0.0   0:00.00 crond
    14154 nginx     20   0  113116   1184   1008 S   0.0  0.0   0:00.00 bash
    14158 nginx     20   0  430368  29892  12004 S   0.0  0.8   0:00.36 php
    20845 root      20   0       0      0      0 S   0.0  0.0   0:00.06 kworker/u4+
    21143 root      20   0  168356   1828   1364 S   0.0  0.0   0:00.00 crond
    21158 nginx     20   0  113116   1156    980 S   0.0  0.0   0:00.00 bash
    21163 nginx     20   0  430660  30400  12040 S   0.0  0.8   0:01.00 php
    21584 root      20   0       0      0      0 S   0.0  0.0   0:00.02 kworker/1:0
    22728 root      20   0  131080   4692   3512 S   0.0  0.1   0:00.18 sshd
    22789 root      20   0  116544   3296   1720 S   0.0  0.1   0:00.07 bash
    22821 root      20   0  131080   4680   3504 S   0.0  0.1   0:00.16 sshd
    22886 root      20   0  116412   2944   1460 S   0.0  0.1   0:00.01 bash
    
                  total        used        free      shared  buff/cache   available
    Mem:           3791         600         120         240        3071        2689
    Low:           3791        3671         120
    High:             0           0           0
    Swap:          3999         185        3814
    
    MemTotal:        3882636 kB
    MemFree:          122896 kB
    MemAvailable:    2753636 kB
    Buffers:           39192 kB
    Cached:          2218684 kB
    SwapCached:        31244 kB
    Active:          1537952 kB
    Inactive:        1274100 kB
    Active(anon):     365328 kB
    Inactive(anon):   435036 kB
    Active(file):    1172624 kB
    Inactive(file):   839064 kB
    Unevictable:           0 kB
    Mlocked:               0 kB
    SwapTotal:       4095996 kB
    SwapFree:        3906216 kB
    Dirty:               356 kB
    Writeback:             0 kB
    AnonPages:        525148 kB
    Mapped:           146156 kB
    Shmem:            246068 kB
    Slab:             887000 kB
    SReclaimable:     864776 kB
    SUnreclaim:        22224 kB
    KernelStack:        3280 kB
    PageTables:        15956 kB
    NFS_Unstable:          0 kB
    Bounce:                0 kB
    WritebackTmp:          0 kB
    CommitLimit:     6037312 kB
    Committed_AS:    1878024 kB
    VmallocTotal:   34359738367 kB
    VmallocUsed:       13724 kB
    VmallocChunk:   34359665927 kB
    HardwareCorrupted:     0 kB
    AnonHugePages:    155648 kB
    HugePages_Total:       0
    HugePages_Free:        0
    HugePages_Rsvd:        0
    HugePages_Surp:        0
    Hugepagesize:       2048 kB
    DirectMap4k:       67456 kB
    DirectMap2M:     4126720 kB
    
    --------------------------
    ps_mem.py output:
    [URL]http://www.pixelbeat.org/scripts/ps_mem.py[/URL]
    --------------------------
     Private  +   Shared  =  RAM used    Program
    
      4.0 KiB +  21.0 KiB =  25.0 KiB    agetty
      4.0 KiB +  56.0 KiB =  60.0 KiB    systemd-udevd
      4.0 KiB +  65.0 KiB =  69.0 KiB    mysqld_safe
    108.0 KiB +  15.5 KiB = 123.5 KiB    rngd
    136.0 KiB +  51.0 KiB = 187.0 KiB    irqbalance
     96.0 KiB + 121.5 KiB = 217.5 KiB    nsd (3)
     88.0 KiB + 134.0 KiB = 222.0 KiB    pure-ftpd
    140.0 KiB +  97.5 KiB = 237.5 KiB    master
    208.0 KiB +  82.5 KiB = 290.5 KiB    run-parts
    284.0 KiB +  72.0 KiB = 356.0 KiB    ntpd
    396.0 KiB +  29.5 KiB = 425.5 KiB    awk
    384.0 KiB +  67.0 KiB = 451.0 KiB    systemd-logind
    364.0 KiB + 175.5 KiB = 539.5 KiB    qmgr
    532.0 KiB +  95.5 KiB = 627.5 KiB    dhclient
    492.0 KiB + 180.5 KiB = 672.5 KiB    tlsmgr
    672.0 KiB +  96.0 KiB = 768.0 KiB    sftp-server
    456.0 KiB + 350.0 KiB = 806.0 KiB    polkitd
    752.0 KiB +  92.0 KiB = 844.0 KiB    mysqlmymonlite.
    828.0 KiB +  44.5 KiB = 872.5 KiB    dbus-daemon
    568.0 KiB + 445.5 KiB =   1.0 MiB    tuned
      1.2 MiB + 305.5 KiB =   1.5 MiB    pickup
      1.2 MiB + 305.5 KiB =   1.5 MiB    trivial-rewrite
      1.5 MiB +  95.0 KiB =   1.6 MiB    systemd
      1.4 MiB + 407.5 KiB =   1.8 MiB    NetworkManager
      2.6 MiB +  21.5 KiB =   2.6 MiB    haveged
      1.4 MiB +   2.2 MiB =   3.6 MiB    systemd-journald
      2.8 MiB + 981.5 KiB =   3.8 MiB    crond (9)
      2.7 MiB +   1.1 MiB =   3.8 MiB    python2.7 (2)
      4.2 MiB + 735.5 KiB =   4.9 MiB    bash (9)
      2.9 MiB +   2.2 MiB =   5.1 MiB    rsyslogd
      4.0 MiB +   1.3 MiB =   5.3 MiB    sshd (4)
      7.3 MiB +  65.0 KiB =   7.4 MiB    lfd - sleeping
     15.1 MiB + 890.0 KiB =  16.0 MiB    yum-cron
     21.0 MiB +  47.5 KiB =  21.0 MiB    memcached
     22.5 MiB +  19.7 MiB =  42.2 MiB    nginx (3)
     95.4 MiB +   9.9 MiB = 105.4 MiB    php (7)
    181.1 MiB + 221.5 KiB = 181.4 MiB    mysqld
    137.4 MiB + 103.8 MiB = 241.2 MiB    php-fpm (5)
    ---------------------------------
                            658.7 MiB
    =================================
    
     Private  +   Shared  =  RAM used    Program
    
    
    smem -uk
    User     Count     Swap      USS      PSS      RSS
    nsd          3     5.1M    96.0K   160.0K     1.2M
    ntp          1   480.0K   284.0K   324.0K     1.4M
    polkitd      1     6.9M   456.0K   731.0K     2.6M
    dbus         1   156.0K   828.0K   842.0K     1.7M
    postfix      4     1.8M     3.3M     3.9M    13.5M
    nobody       1     2.5M    21.0M    21.0M    21.5M
    root        41    84.2M    58.6M    74.5M   152.5M
    mysql        1    23.7M   181.1M   181.3M   183.3M
    nginx       20    42.2M   254.1M   378.2M   774.0M
    
    smem -t -p
      PID User     Command                         Swap      USS      PSS      RSS
     3077 root     /sbin/agetty --noclear tty1    0.00%    0.00%    0.00%    0.02%
      340 root     /usr/lib/systemd/systemd-ud    0.01%    0.00%    0.00%    0.02%
     1006 nsd      /usr/local/sbin/nsd -c /etc    0.11%    0.00%    0.00%    0.01%
     8838 root     /usr/sbin/CROND -n             0.02%    0.00%    0.00%    0.04%
     8844 nginx    /bin/bash -c        /usr/lo    0.00%    0.00%    0.00%    0.03%
      912 root     /bin/sh /usr/bin/mysqld_saf    0.01%    0.00%    0.00%    0.03%
     1003 nsd      /usr/local/sbin/nsd -c /etc    0.01%    0.00%    0.00%    0.02%
     1007 nsd      /usr/local/sbin/nsd -c /etc    0.01%    0.00%    0.00%    0.01%
      483 root     /usr/sbin/crond -n             0.01%    0.00%    0.00%    0.03%
      459 root     /sbin/rngd -f                  0.00%    0.00%    0.00%    0.02%
     1002 root     pure-ftpd (SERVER)             0.03%    0.00%    0.00%    0.03%
     1519 root     /usr/libexec/postfix/master    0.02%    0.00%    0.00%    0.03%
      440 root     /usr/sbin/irqbalance --fore    0.00%    0.00%    0.00%    0.03%
      864 root     /usr/sbin/sshd -D              0.02%    0.00%    0.00%    0.06%
     6485 nginx    /bin/bash -c        /usr/lo    0.00%    0.00%    0.01%    0.04%
     1869 nginx    /bin/bash -c        /usr/lo    0.00%    0.00%    0.01%    0.03%
     5669 nginx    /bin/bash -c        /usr/lo    0.00%    0.00%    0.01%    0.04%
     6871 nginx    /bin/bash -c        /usr/lo    0.00%    0.00%    0.01%    0.04%
    21158 nginx    /bin/bash -c        /usr/lo    0.00%    0.00%    0.01%    0.03%
    14154 nginx    /bin/bash -c        /usr/lo    0.00%    0.00%    0.01%    0.04%
     5444 root     /bin/bash /bin/run-parts /e    0.00%    0.01%    0.01%    0.04%
      464 ntp      /usr/sbin/ntpd -u ntp:ntp -    0.01%    0.01%    0.01%    0.04%
     5459 root     awk -v progname=/etc/cron.h    0.00%    0.01%    0.01%    0.03%
      475 root     /usr/lib/systemd/systemd-lo    0.00%    0.01%    0.01%    0.04%
     6870 root     /usr/sbin/CROND -n             0.01%    0.01%    0.01%    0.05%
     5443 root     /usr/sbin/CROND -n             0.01%    0.01%    0.01%    0.05%
     1864 root     /usr/sbin/CROND -n             0.01%    0.01%    0.01%    0.05%
    14150 root     /usr/sbin/CROND -n             0.01%    0.01%    0.01%    0.05%
     5668 root     /usr/sbin/CROND -n             0.01%    0.01%    0.01%    0.05%
    21143 root     /usr/sbin/CROND -n             0.01%    0.01%    0.01%    0.05%
     6471 root     /usr/sbin/CROND -n             0.01%    0.01%    0.01%    0.05%
     1564 postfix  qmgr -l -t unix -u             0.02%    0.01%    0.01%    0.07%
      776 root     /sbin/dhclient -H vultr5 -1    0.30%    0.01%    0.01%    0.02%
    13903 postfix  tlsmgr -l -t unix -u           0.02%    0.01%    0.02%    0.08%
     3420 root     /usr/libexec/openssh/sftp-s    0.00%    0.02%    0.02%    0.06%
      515 polkitd  /usr/lib/polkit-1/polkitd -    0.17%    0.01%    0.02%    0.07%
     6984 root     /bin/bash ./mysqlmymonlite.    0.00%    0.02%    0.02%    0.05%
      460 dbus     /bin/dbus-daemon --system -    0.00%    0.02%    0.02%    0.04%
      458 root     /usr/bin/python -Es /usr/sb    0.25%    0.01%    0.02%    0.10%
     2640 root     python /opt/nixstats/nixsta    0.26%    0.02%    0.03%    0.06%
     6746 postfix  pickup -l -t unix -u           0.00%    0.03%    0.04%    0.10%
    22728 root     sshd: root@pts/1               0.00%    0.03%    0.04%    0.12%
     5484 postfix  trivial-rewrite -n rewrite     0.00%    0.03%    0.04%    0.10%
    22821 root     sshd: root@pts/0               0.00%    0.03%    0.04%    0.12%
        1 root     /usr/lib/systemd/systemd --    0.01%    0.04%    0.04%    0.07%
    22886 root     -bash                          0.00%    0.04%    0.04%    0.08%
      454 root     /usr/sbin/NetworkManager --    0.02%    0.04%    0.05%    0.10%
     8847 nginx    /usr/local/bin/php /home/ng    0.61%    0.02%    0.05%    0.31%
     3408 root     sshd: root@notty               0.00%    0.04%    0.05%    0.12%
    22789 root     -bash                          0.00%    0.04%    0.05%    0.08%
      441 root     /usr/sbin/haveged -w 1024 -    0.04%    0.07%    0.07%    0.08%
     6930 root     python /opt/nixstats/nixsta    0.23%    0.06%    0.07%    0.11%
     9470 root     php-fpm: master process (/u    0.00%    0.06%    0.09%    0.22%
      325 root     /usr/lib/systemd/systemd-jo    0.00%    0.04%    0.09%    0.17%
      455 root     /usr/sbin/rsyslogd -n          0.01%    0.08%    0.13%    0.21%
     7129 root     python /usr/bin/smem -t -p     0.00%    0.15%    0.16%    0.20%
     2626 root     nginx: master process /usr/    0.42%    0.00%    0.16%    0.49%
     2587 root     lfd - sleepin                  0.35%    0.19%    0.19%    0.21%
     6872 nginx    /usr/local/bin/php /home/ng    0.00%    0.36%    0.39%    0.68%
     5670 nginx    /usr/local/bin/php /home/ng    0.00%    0.38%    0.42%    0.70%
     5458 root     /usr/bin/python -tt /usr/sb    0.00%    0.40%    0.42%    0.54%
     6502 nginx    /usr/local/bin/php /home/ng    0.00%    0.40%    0.43%    0.72%
     1870 nginx    /usr/local/bin/php /home/ng    0.00%    0.43%    0.46%    0.73%
     2627 nginx    nginx: worker process          0.24%    0.29%    0.46%    0.82%
     2635 nginx    nginx: worker process          0.20%    0.31%    0.48%    0.84%
    14158 nginx    /usr/local/bin/php /home/ng    0.00%    0.46%    0.49%    0.77%
    21163 nginx    /usr/local/bin/php /home/ng    0.00%    0.47%    0.51%    0.78%
     2611 nobody   /usr/local/bin/memcached -d    0.06%    0.55%    0.55%    0.57%
     6531 nginx    php-fpm: pool www              0.00%    0.86%    1.32%    2.79%
     3390 nginx    php-fpm: pool www              0.00%    0.87%    1.59%    3.60%
     3983 nginx    php-fpm: pool www              0.00%    0.89%    1.65%    3.68%
     3883 nginx    php-fpm: pool www              0.00%    0.94%    1.70%    3.75%
     1699 mysql    /usr/sbin/mysqld --basedir=    0.59%    4.76%    4.76%    4.82%
    -------------------------------------------------------------------------------
       73 9                                       4.17%   13.65%   17.38%   30.31%
    
    smem -wk
    Area                           Used      Cache   Noncache
    firmware/hardware                 0          0          0
    kernel image                      0          0          0
    kernel dynamic memory          2.9G       2.8G     108.1M
    userspace memory             659.1M     142.6M     516.4M
    free memory                  116.8M     116.8M          0
    
    
    ----------------------------
    Server Disk Usage
    ----------------------------
    Filesystem     Type      Size  Used Avail Use% Mounted on
    /dev/vda1      ext3       89G   20G   66G  23% /
    devtmpfs       devtmpfs  1.9G     0  1.9G   0% /dev
    tmpfs          tmpfs     1.9G     0  1.9G   0% /dev/shm
    tmpfs          tmpfs     1.9G   65M  1.8G   4% /run
    tmpfs          tmpfs     1.9G     0  1.9G   0% /sys/fs/cgroup
    /dev/loop0     ext4      3.7G   31M  3.5G   1% /tmp
    
    ----------------------------
    MySQL datadir disk usage
    ----------------------------
    /var/lib/mysql/ uses 2703552 kilobytes of disk space
    
    ----------------------------
    ulimit -aH
    ----------------------------
    core file size          (blocks, -c) unlimited
    data seg size           (kbytes, -d) unlimited
    scheduling priority             (-e) 0
    file size               (blocks, -f) unlimited
    pending signals                 (-i) 15100
    max locked memory       (kbytes, -l) 64
    max memory size         (kbytes, -m) unlimited
    open files                      (-n) 262144
    pipe size            (512 bytes, -p) 8
    POSIX message queues     (bytes, -q) 819200
    real-time priority              (-r) 0
    stack size              (kbytes, -s) unlimited
    cpu time               (seconds, -t) unlimited
    max user processes              (-u) 15100
    virtual memory          (kbytes, -v) unlimited
    file locks                      (-x) unlimited
    
    ----------------------------------------------------------
    tail -15 /etc/security/limits.conf
    ----------------------------------------------------------
    #@student        hard    nproc           20
    #@faculty        soft    nproc           20
    #@faculty        hard    nproc           50
    #ftp             hard    nproc           0
    #@student        -       maxlogins       4
    
    # End of file
    * soft nofile 262144
    * hard nofile 262144
    nginx soft nofile 262144
    nginx hard nofile 262144
    nobody soft nofile 262144
    nobody hard nofile 262144
    root soft nofile 262144
    root hard nofile 262144
    
    ----------------------------------------------------------
    mysqld process limits:
    cat /proc/1699/limits
    ----------------------------------------------------------
    Limit                     Soft Limit           Hard Limit           Units   
    Max cpu time              unlimited            unlimited            seconds 
    Max file size             unlimited            unlimited            bytes   
    Max data size             unlimited            unlimited            bytes   
    Max stack size            8388608              unlimited            bytes   
    Max core file size        0                    unlimited            bytes   
    Max resident set          unlimited            unlimited            bytes   
    Max processes             15100                15100                processes
    Max open files            8192                 8192                 files   
    Max locked memory         65536                65536                bytes   
    Max address space         unlimited            unlimited            bytes   
    Max file locks            unlimited            unlimited            locks   
    Max pending signals       15100                15100                signals 
    Max msgqueue size         819200               819200               bytes   
    Max nice priority         0                    0                   
    Max realtime priority     0                    0                   
    Max realtime timeout      unlimited            unlimited            us       
    
    ----------------------------------
    WEB SERVER & PHP Info:
    ----------------------------------
    PHP 5.6.13 (cli) (built: Sep 20 2015 20:31:37)
    Copyright (c) 1997-2015 The PHP Group
    Zend Engine v2.6.0, Copyright (c) 1998-2015 Zend Technologies
        with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2015, by Zend Technologies
    
    System => Linux yourserverhostname 3.10.0-229.14.1.el7.x86_64 #1 SMP Tue Sep 15 15:05:51 UTC 2015 x86_64
    Build Date => Sep 20 2015 20:28:23
    
    Configure Command =>  '../configure'  '--enable-fpm' '--enable-opcache' '--enable-intl' '--enable-pcntl' '--with-mcrypt' '--with-snmp' '--with-mhash' '--with-zlib' '--with-gettext' '--enable-exif' '--enable-zip' '--with-bz2' '--enable-soap' '--enable-sockets' '--enable-sysvmsg' '--enable-sysvsem' '--enable-sysvshm' '--enable-shmop' '--with-pear' '--enable-mbstring' '--with-openssl' '--with-mysql=mysqlnd' '--with-libdir=lib64' '--with-mysqli=mysqlnd' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-curl' '--with-gd' '--with-xmlrpc' '--enable-bcmath' '--enable-calendar' '--enable-ftp' '--enable-gd-native-ttf' '--with-freetype-dir=/usr' '--with-jpeg-dir=/usr' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--with-vpx-dir=/usr' '--with-t1lib=/usr' '--enable-pdo' '--with-pdo-sqlite' '--with-pdo-mysql=mysqlnd' '--enable-inline-optimization' '--with-imap' '--with-imap-ssl' '--with-kerberos' '--with-readline' '--with-libedit' '--with-gmp' '--with-pspell' '--with-tidy' '--with-enchant' '--with-fpm-user=nginx' '--with-fpm-group=nginx' '--disable-fileinfo' '--with-config-file-scan-dir=/etc/centminmod/php.d' 'CC=ccache 'CXX=ccache
    
    Server API | Command Line Interface
    Configuration File (php.ini) Path | /usr/local/lib
    Loaded Configuration File | /usr/local/lib/php.ini
    Additional .ini files parsed | /etc/centminmod/php.d/a_customphp.ini,
    PHP API | 20131106
    Zend Extension Build | API220131226,NTS
    PHP Extension Build | API20131226,NTS
    DOM/XML API Version | 20031129
    MHASH API Version | Emulated Support
    GSSAPI (Kerberos) | disabled
    Client API version | mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
    Client API library version | mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
    API Extensions | mysqli,mysql,pdo_mysql
    Client API version | mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
    Phar API version | 1.1.1
    
    display_errors | Off | Off
    error_log | no value | no value
    extension_dir | /usr/local/lib/php/extensions/no-debug-non-zts-20131226 | /usr/local/lib/php/extensions/no-debug-non-zts-20131226
    file_uploads | On | On
    log_errors | On | On
    log_errors_max_len | 1024 | 1024
    max_execution_time | 0 | 0
    max_file_uploads | 20 | 20
    memory_limit | 160M | 160M
    open_basedir | no value | no value
    post_max_size | 40M | 40M
    realpath_cache_size | 1024k | 1024k
    realpath_cache_ttl | 14400 | 14400
    sendmail_path | /usr/sbin/sendmail -t -i  | /usr/sbin/sendmail -t -i
    sql.safe_mode | Off | Off
    upload_max_filesize | 40M | 40M
    upload_tmp_dir | no value | no value
    sqlite3.extension_dir | no value | no value
    opcache.error_log | no value | no value
    
    cURL support | enabled
    cURL Information | 7.29.0
    ZLib Version | 1.2.7
    GD Support | enabled
    GD Version | bundled (2.1.0 compatible)
    FreeType Support | enabled
    FreeType Linkage | with freetype
    FreeType Version | 2.4.11
    GIF Read Support | enabled
    GIF Create Support | enabled
    JPEG Support | enabled
    libJPEG Version | 6b
    PNG Support | enabled
    libPNG Version | 1.5.13
    WBMP Support | enabled
    libXML support | active
    libXML Compiled Version | 2.9.1
    libXML Loaded Version | 20901
    libXML streams | enabled
    PCRE (Perl Compatible Regular Expressions) Support | enabled
    PCRE Library Version | 8.37 2015-04-28
    Soap Client | enabled
    Soap Server | enabled
    ZLib Support | enabled
    
    igbinary APC serializer ABI | 0
    
    Opcode Caching => Disabled
    Optimization => Disabled
    Startup Failed => Opcode Caching is disabled for CLI
    
    Directive => Local Value => Master Value
    opcache.blacklist_filename => no value => no value
    opcache.consistency_checks => 0 => 0
    opcache.dups_fix => Off => Off
    opcache.enable => On => On
    opcache.enable_cli => Off => Off
    opcache.enable_file_override => On => On
    opcache.error_log => no value => no value
    opcache.fast_shutdown => 1 => 1
    opcache.file_update_protection => 2 => 2
    opcache.force_restart_timeout => 180 => 180
    opcache.inherited_hack => On => On
    opcache.interned_strings_buffer => 8 => 8
    opcache.load_comments => 1 => 1
    opcache.log_verbosity_level => 1 => 1
    opcache.max_accelerated_files => 16000 => 16000
    opcache.max_file_size => 0 => 0
    opcache.max_wasted_percentage => 5 => 5
    opcache.memory_consumption => 256 => 256
    opcache.optimization_level => 0xFFFFFFFF => 0xFFFFFFFF
    opcache.preferred_memory_model => no value => no value
    opcache.protect_memory => 0 => 0
    opcache.restrict_api => no value => no value
    opcache.revalidate_freq => 180 => 180
    opcache.revalidate_path => Off => Off
    opcache.save_comments => 1 => 1
    opcache.use_cwd => On => On
    opcache.validate_timestamps => On => On
    
    
    igbinary support => enabled
    igbinary version => 1.2.2-dev
    igbinary APC serializer ABI => 0
    igbinary session support => yes
    
    Directive => Local Value => Master Value
    igbinary.compact_strings => On => On
    
    memcache support => enabled
    Version => 3.0.8
    Revision => $Revision: 329835 $
    
    Directive => Local Value => Master Value
    memcache.allow_failover => 1 => 1
    memcache.chunk_size => 32768 => 32768
    memcache.compress_threshold => 20000 => 20000
    memcache.default_port => 11211 => 11211
    memcache.hash_function => crc32 => crc32
    memcache.hash_strategy => consistent => consistent
    memcache.lock_timeout => 15 => 15
    memcache.max_failover_attempts => 20 => 20
    memcache.protocol => ascii => ascii
    memcache.redundancy => 1 => 1
    memcache.session_redundancy => 2 => 2
    
    memcached support => enabled
    Version => 2.2.0
    libmemcached version => 1.0.16
    SASL support => yes
    Session support => yes
    igbinary support => no
    json support => yes
    msgpack support => no
    
    Directive => Local Value => Master Value
    memcached.compression_factor => 1.3 => 1.3
    memcached.compression_threshold => 2000 => 2000
    memcached.compression_type => fastlz => fastlz
    memcached.serializer => php => php
    memcached.sess_binary => 0 => 0
    memcached.sess_connect_timeout => 3000 => 3000
    
    pcntl support => enabled
    
    PCRE (Perl Compatible Regular Expressions) Support => enabled
    PCRE Library Version => 8.37 2015-04-28
    
    Directive => Local Value => Master Value
    pcre.backtrack_limit => 1000000 => 1000000
    pcre.recursion_limit => 100000 => 100000
    
    PDO support => enabled
    PDO drivers => mysql, sqlite
    
    PDO Driver for MySQL => enabled
    Client API version => mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $
    
    PDO Driver for SQLite 3.x => enabled
    SQLite Library => 3.8.10.2
    
    Phar: PHP Archive support => enabled
    Phar EXT version => 2.0.2
    Phar API version => 1.1.1
    SVN revision => $Id: 72d7e004b07d106bb1ef7c5663a186cbae621385 $
    Phar-based phar archives => enabled
    Tar-based phar archives => enabled
    ZIP-based phar archives => enabled
    gzip compression => enabled
    bzip2 compression => enabled
    Native OpenSSL support => enabled
    
    
    Phar based on pear/PHP_Archive, original concept by Davey Shafik.
    Phar fully realized by Gregory Beaver and Marcus Boerger.
    Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
    Directive => Local Value => Master Value
    phar.cache_list => no value => no value
    phar.readonly => On => On
    phar.require_hash => On => On
    
    
    
    
    ---------------
    You are running Nginx
    ---------------
    
    
    user              nginx nginx;
    worker_processes 2;
    worker_rlimit_nofile 260000;
        worker_connections  4096;
        use epoll;
    log_format      main    '$remote_addr - $remote_user [$time_local] $request '
                    '"$http_user_agent" "$http_x_forwarded_for" "$gzip_ratio"'
            sendfile on;
            sendfile_max_chunk 512k;
            keepalive_timeout  8;
        gzip on;
        gzip_vary   on;
        gzip_disable "MSIE [1-6]\.";
            gzip_static on;
            gzip_min_length   1400;
            gzip_buffers      32 8k;
            gzip_http_version 1.0;
            gzip_comp_level 5;
            gzip_proxied    any;
            gzip_types text/plain text/css text/xml application/javascript application/x-javascript application/xml application/xml+rss application/ecmascript application/json image/svg+xml;
     client_body_buffer_size 256k;
     client_body_in_file_only off;
     client_body_timeout 10s;
     client_header_buffer_size 64k;
     client_header_timeout  8s;
     client_max_body_size 50m;
     large_client_header_buffers 8 64k;
     proxy_temp_path  /tmp/nginx_proxy/;
    # for nginx proxy backends to prevent redirects to backend port
    
    ----------------------------
    mysqlreport output
    ----------------------------
    
    MariaDB 10.0.21-MariaDB     uptime 0 18:40:21   Mon Oct 12 10:04:27 2015
    
    __ Key _________________________________________________________________
    Buffer used    26.16M of   32.00M   %Used:  81.74
      Current      32.00M              %Usage: 100.00
    Write hit      30.28%
    Read hit       99.21%
    
    __ Questions ___________________________________________________________
    Total           6.95M     103.5/s
      DMS           5.95M      88.4/s  %Total:  85.49
      -Unknown      1.61M      24.0/s           23.20
      QC Hits       1.61M      24.0/s           23.20
      Com_        598.22k       8.9/s            8.60
      COM_QUIT    411.23k       6.1/s            5.91
    Slow 1 s           35       0.0/s            0.00  %DMS:   0.00 Log:
    DMS             5.95M      88.4/s           85.49
      SELECT        4.90M      72.9/s           70.46         82.43
      DELETE      420.91k       6.3/s            6.05          7.08
      INSERT      350.14k       5.2/s            5.03          5.89
      UPDATE      273.76k       4.1/s            3.94          4.60
      REPLACE           0         0/s            0.00          0.00
    Com_          598.22k       8.9/s            8.60
      change_db   411.24k       6.1/s            5.91
      set_option  107.87k       1.6/s            1.55
      show_fields  70.02k       1.0/s            1.01
    
    __ Rows ________________________________________________________________
    Rows            1.56G     23.2k/s
      Using idx    69.04M      1.0k/s  %Index:   4.42
    Rows/question  224.44
    
    __ SELECT and Sort _____________________________________________________
    Scan          234.93k       3.5/s %SELECT:   4.79
    Range         157.83k       2.3/s            3.22
    Full join           5       0.0/s            0.00
    Range check         0         0/s            0.00
    Full rng join       0         0/s            0.00
    Sort scan     136.46k       2.0/s
    Sort range    204.57k       3.0/s
    Sort mrg pass       5       0.0/s
    
    __ Query Cache _________________________________________________________
    Memory usage   12.58M of   16.00M  %Usage:  78.63
    Block Fragmnt  12.87%
    Hits            1.61M      24.0/s
    Inserts         2.88M      42.9/s
    Insrt:prune    5.29:1      34.8/s
    Hit:Insert     0.56:1
    
    __ Table Locks _________________________________________________________
    Waited          1.83k       0.0/s  %Total:   0.04
    Immediate       4.24M      63.1/s
    
    __ Tables ______________________________________________________________
    Open              626 of   2048    %Cache:  30.57
    Opened          1.53k       0.0/s
    
    __ Connections _________________________________________________________
    Max used           26 of    300      %Max:   8.67
    Total         411.26k       6.1/s
    
    __ Created Temp ________________________________________________________
    Disk table     71.33k       1.1/s   %Disk:  88.28
    Table          80.80k       1.2/s    Size:  32.0M
    File              238       0.0/s
    
    __ Threads _____________________________________________________________
    Running             1 of      5
    Created            26       0.0/s
    Slow                0         0/s
    Cached             21 of     64      %Hit:  99.99
    
    __ Aborted _____________________________________________________________
    Clients            65       0.0/s
    Connects            1       0.0/s
    
    __ Bytes _______________________________________________________________
    Sent           31.22G    464.4k/s
    Received        3.86G     57.5k/s
    
    __ InnoDB Buffer Pool __________________________________________________
    Usage          13.22M of   47.98M  %Usage:  27.55
    Read hit       99.98%
    Pages
      Free          2.23k              %Total:  72.45
      Data            830                       27.03  %Drty:   0.60
      Misc             16                        0.52
      Latched           0                        0.00
    Reads          19.29M     286.9/s
      From disk     2.91k       0.0/s   %Disk:   0.02
      Ahead Rnd         0         0/s
    Writes          2.74M      40.7/s
    Flushes        68.03k       1.0/s
    Wait Free           0         0/s   %Wait:   0.00
    
    __ InnoDB Lock _________________________________________________________
    Waits              12       0.0/s
    Current             0
    Time acquiring
      Total             0 ms
      Average           0 ms
      Max               0 ms
    
    __ InnoDB Data, Pages, Rows ____________________________________________
    Data
      Reads         3.27k       0.0/s
      Writes      244.37k       3.6/s
      fsync        32.69k       0.5/s
      Pending
        Reads           0
        Writes          0
        fsync           0
    
    Pages
      Created       6.69k       0.1/s
      Read          2.93k       0.0/s
      Written      68.03k       1.0/s
    
    Rows
      Deleted      31.55k       0.5/s
      Inserted    590.21k       8.8/s
      Read          1.88M      28.0/s
      Updated     113.92k       1.7/s
    
    __ Aria Pagecache ______________________________________________________
    Buffer used     2.04M of    8.00M   %Used:  25.49
      Current     336.00k              %Usage:   4.10
    Write hit      99.98%
    Read hit       88.12%
    
    __ Subquery Cache ______________________________________________________
    Hit ratio       0.00%
    Hits                0        0/s
    Miss           18.55k      0.3/s
    
    ----------------------------
    Total Server MyISAM and InnoDB Size
    ----------------------------
    *************************** 1. row ***************************
    innodb_tablespace_utilization_perc: 100
                         total_size_gb: 2.2369415340945125
                         index_size_gb: 0.16843795776367188
                          data_size_gb: 2.0685035763308406
                  innodb_total_size_gb: 0.0059967041015625
                   innodb_data_size_gb: 0.005157470703125
                  innodb_index_size_gb: 0.0008392333984375
                  myisam_total_size_gb: 2.2307769833132625
                   myisam_data_size_gb: 2.063262182287872
                  myisam_index_size_gb: 0.16751480102539062
                            perc_index: 7.5298
                             perc_data: 92.4702
                     innodb_perc_index: 13.9949
                      innodb_perc_data: 86.0051
                     myisam_perc_index: 7.5093
                      myisam_perc_data: 92.4907
               innodb_perc_total_index: 0.4982
                innodb_perc_total_data: 0.2493
               myisam_perc_total_index: 99.4519
                myisam_perc_total_data: 99.7466
    
    
    ----------------------------
    MySQL settings
    ----------------------------
    [mysqld]
    local-infile=0
    ignore-db-dir=lost+found
    character-set-server=utf8
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    
    #bind-address=127.0.0.1
    # optimized my.cnf for MariaDB 5.5.x
    # by eva2000
    # vbtechsupport.com
    
    tmpdir=/home/mysqltmp
    
    innodb=ON
    #skip-federated
    #skip-pbxt
    #skip-pbxt_statistics
    #skip-archive
    #skip-name-resolve
    #old_passwords
    back_log = 75
    max_connections = 300
    key_buffer_size = 32M
    myisam_sort_buffer_size = 32M
    myisam_max_sort_file_size = 2048M
    join_buffer_size = 128K
    read_buffer_size = 128K
    sort_buffer_size = 256K
    table_definition_cache = 4096
    table_open_cache = 2048
    thread_cache_size = 64
    wait_timeout = 120
    connect_timeout = 10
    tmp_table_size = 32M
    max_heap_table_size = 32M
    max_allowed_packet = 32M
    max_seeks_for_key = 1000
    group_concat_max_len = 1024
    max_length_for_sort_data = 1024
    net_buffer_length = 16384
    max_connect_errors = 100000
    concurrent_insert = 2
    read_rnd_buffer_size = 256K
    bulk_insert_buffer_size = 8M
    query_cache_limit = 512K
    query_cache_size = 16M
    query_cache_type = 1
    query_cache_min_res_unit = 2K
    query_prealloc_size = 262144
    query_alloc_block_size = 65536
    transaction_alloc_block_size = 8192
    transaction_prealloc_size = 4096
    default-storage-engine = InnoDB
    
    log_warnings=1
    slow_query_log=0
    long_query_time=1
    slow_query_log_file=/var/lib/mysql/slowq.log
    log-error=/var/log/mysqld.log
    
    # innodb settings
    innodb_large_prefix=1
    innodb_purge_threads=1
    innodb_file_format = Barracuda
    innodb_file_per_table = 1
    innodb_open_files = 1000
    innodb_data_file_path= ibdata1:10M:autoextend
    innodb_buffer_pool_size = 48M
    
    ## [URL='https://mariadb.com/kb/en/mariadb/xtradbinnodb-server-system-variables/#innodb_buffer_pool_instances']XtraDB/InnoDB Server System Variables - MariaDB Knowledge Base[/URL]
    #innodb_buffer_pool_instances=2
    
    innodb_log_files_in_group = 2
    innodb_log_file_size = 128M
    innodb_log_buffer_size = 8M
    innodb_flush_log_at_trx_commit = 2
    innodb_thread_concurrency = 0
    innodb_lock_wait_timeout=50
    innodb_flush_method = O_DIRECT
    innodb_support_xa=1
    
    # 200 * # DISKS
    innodb_io_capacity = 100
    innodb_read_io_threads = 2
    innodb_write_io_threads = 2
    
    # mariadb settings
    [mariadb]
    #thread-handling = pool-of-threads
    #thread-pool-size= 20
    #mysql --port=3307 --protocol=tcp
    #extra-port=3307
    #extra-max-connections=1
    
    userstat = 0
    key_cache_segments = 1
    aria_group_commit = none
    aria_group_commit_interval = 0
    aria_log_file_size = 32M
    aria_log_purge_type = immediate
    aria_pagecache_buffer_size = 8M
    aria_sort_buffer_size = 8M
    
    [mariadb-5.5]
    #ignore_db_dirs=
    query_cache_strip_comments=0
    
    innodb_read_ahead = linear
    innodb_adaptive_flushing_method = estimate
    innodb_flush_neighbor_pages = 1
    innodb_stats_update_need_lock = 0
    innodb_log_block_size = 512
    
    log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
    
    [mysqld_safe]
    socket=/var/lib/mysql/mysql.sock
    log-error=/var/log/mysqld.log
    #nice = -5
    open-files-limit = 8192
    
    [mysqldump]
    quick
    max_allowed_packet = 32M
    
    [myisamchk]
    tmpdir=/home/mysqltmp
    key_buffer = 32M
    sort_buffer = 16M
    read_buffer = 16M
    write_buffer = 16M
    
    [mysqlhotcopy]
    interactive-timeout
    
    [mariadb-10.0]
    # 2 variables needed to switch from XtraDB to InnoDB plugins
    #plugin-load=ha_innodb
    #ignore_builtin_innodb
    
    ## MariaDB 10 only save and restore buffer pool pages
    ## warm up InnoDB buffer pool on server restarts
    innodb_buffer_pool_dump_at_shutdown=1
    innodb_buffer_pool_load_at_startup=1
    innodb_buffer_pool_populate=0
    ## Disabled settings
    performance_schema=OFF
    innodb_stats_on_metadata=OFF
    innodb_sort_buffer_size=2M
    innodb_online_alter_log_max_size=128M
    query_cache_strip_comments=0
    log_slow_filter =admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
    ---
    +--------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | Variable_name | Value |
    +--------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | aria_block_size | 8192 |
    | aria_checkpoint_interval | 30 |
    | aria_checkpoint_log_activity | 1048576 |
    | aria_force_start_after_recovery_failures | 0 |
    | aria_group_commit | none |
    | aria_group_commit_interval | 0 |
    | aria_log_file_size | 33554432 |
    | aria_log_purge_type | immediate |
    | aria_max_sort_file_size | 9223372036853727232 |
    | aria_page_checksum | ON |
    | aria_pagecache_age_threshold | 300 |
    | aria_pagecache_buffer_size | 8388608 |
    | aria_pagecache_division_limit | 100 |
    | aria_pagecache_file_hash_size | 512 |
    | aria_recover | NORMAL |
    | aria_repair_threads | 1 |
    | aria_sort_buffer_size | 8388608 |
    | 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 | 75 |
    | basedir | /usr |
    | big_tables | OFF |
    | binlog_annotate_row_events | OFF |
    | binlog_cache_size | 32768 |
    | binlog_checksum | NONE |
    | binlog_commit_wait_count | 0 |
    | binlog_commit_wait_usec | 100000 |
    | binlog_direct_non_transactional_updates | OFF |
    | binlog_format | STATEMENT |
    | binlog_optimize_thread_scheduling | ON |
    | 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/ |
    | collation_connection | utf8_general_ci |
    | collation_database | utf8_general_ci |
    | collation_server | utf8_general_ci |
    | completion_type | NO_CHAIN |
    | concurrent_insert | ALWAYS |
    | connect_timeout | 10 |
    | datadir | /var/lib/mysql/ |
    | date_format | %Y-%m-%d |
    | datetime_format | %Y-%m-%d %H:%i:%s |
    | 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_week_format | 0 |
    | delay_key_write | ON |
    | delayed_insert_limit | 100 |
    | delayed_insert_timeout | 300 |
    | delayed_queue_size | 1000 |
    | div_precision_increment | 4 |
    | event_scheduler | OFF |
    | expensive_subquery_limit | 100 |
    | expire_logs_days | 0 |
    | extra_max_connections | 1 |
    | extra_port | 0 |
    | flush | OFF |
    | flush_time | 0 |
    | foreign_key_checks | ON |
    | ft_boolean_syntax | + -><()~*:""&| |
    | ft_max_word_len | 84 |
    | ft_min_word_len | 4 |
    | ft_query_expansion_limit | 20 |
    | ft_stopword_file | (built-in) |
    | general_log | OFF |
    | general_log_file | vultr5.log |
    | group_concat_max_len | 1024 |
    | gtid_binlog_pos | |
    | gtid_binlog_state | |
    | gtid_current_pos | |
    | gtid_domain_id | 0 |
    | gtid_ignore_duplicates | OFF |
    | 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 | 128 |
    | hostname | yourserverhostname |
    | ignore_builtin_innodb | OFF |
    | ignore_db_dirs | lost+found |
    | 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_partitions | 1 |
    | innodb_adaptive_max_sleep_delay | 150000 |
    | innodb_additional_mem_pool_size | 8388608 |
    | innodb_api_bk_commit_interval | 5 |
    | innodb_api_disable_rowlock | OFF |
    | innodb_api_enable_binlog | OFF |
    | innodb_api_enable_mdl | OFF |
    | innodb_api_trx_level | 0 |
    | innodb_autoextend_increment | 64 |
    | innodb_autoinc_lock_mode | 1 |
    | innodb_buffer_pool_dump_at_shutdown | ON |
    | innodb_buffer_pool_dump_now | OFF |
    | innodb_buffer_pool_filename | ib_buffer_pool |
    | innodb_buffer_pool_instances | 8 |
    | innodb_buffer_pool_load_abort | OFF |
    | innodb_buffer_pool_load_at_startup | ON |
    | innodb_buffer_pool_load_now | OFF |
    | innodb_buffer_pool_populate | OFF |
    | innodb_buffer_pool_size | 50331648 |
    | innodb_change_buffer_max_size | 25 |
    | innodb_change_buffering | all |
    | innodb_checksum_algorithm | innodb |
    | innodb_checksums | ON |
    | innodb_cleaner_lsn_age_factor | high_checkpoint |
    | innodb_cmp_per_index_enabled | OFF |
    | innodb_commit_concurrency | 0 |
    | innodb_compression_failure_threshold_pct | 5 |
    | innodb_compression_level | 6 |
    | innodb_compression_pad_pct_max | 50 |
    | innodb_concurrency_tickets | 5000 |
    | innodb_corrupt_table_action | assert |
    | innodb_data_file_path | ibdata1:10M:autoextend |
    | innodb_data_home_dir | |
    | innodb_disable_sort_file_cache | OFF |
    | innodb_doublewrite | ON |
    | innodb_empty_free_list_algorithm | backoff |
    | innodb_fake_changes | OFF |
    | innodb_fast_shutdown | 1 |
    | innodb_file_format | Barracuda |
    | innodb_file_format_check | ON |
    | innodb_file_format_max | Antelope |
    | innodb_file_per_table | ON |
    | innodb_flush_log_at_timeout | 1 |
    | innodb_flush_log_at_trx_commit | 2 |
    | innodb_flush_method | O_DIRECT |
    | innodb_flush_neighbors | 1 |
    | innodb_flushing_avg_loops | 30 |
    | innodb_force_load_corrupted | OFF |
    | innodb_force_recovery | 0 |
    | innodb_foreground_preflush | exponential_backoff |
    | 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_io_capacity | 100 |
    | innodb_io_capacity_max | 2000 |
    | innodb_kill_idle_transaction | 0 |
    | innodb_large_prefix | ON |
    | innodb_lock_wait_timeout | 50 |
    | innodb_locking_fake_changes | ON |
    | innodb_locks_unsafe_for_binlog | OFF |
    | innodb_log_arch_dir | ./ |
    | innodb_log_arch_expire_sec | 0 |
    | innodb_log_archive | OFF |
    | innodb_log_block_size | 512 |
    | innodb_log_buffer_size | 8388608 |
    | innodb_log_checksum_algorithm | innodb |
    | innodb_log_compressed_pages | ON |
    | innodb_log_file_size | 134217728 |
    | innodb_log_files_in_group | 2 |
    | innodb_log_group_home_dir | ./ |
    | innodb_lru_scan_depth | 1024 |
    | innodb_max_bitmap_file_size | 104857600 |
    | innodb_max_changed_pages | 1000000 |
    | innodb_max_dirty_pages_pct | 75.000000 |
    | innodb_max_dirty_pages_pct_lwm | 0.001000 |
    | innodb_max_purge_lag | 0 |
    | innodb_max_purge_lag_delay | 0 |
    | innodb_mirrored_log_groups | 1 |
    | 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 | 1000 |
    | innodb_optimize_fulltext_only | OFF |
    | innodb_page_size | 16384 |
    | innodb_print_all_deadlocks | OFF |
    | innodb_purge_batch_size | 300 |
    | innodb_purge_threads | 1 |
    | innodb_random_read_ahead | OFF |
    | innodb_read_ahead_threshold | 56 |
    | innodb_read_io_threads | 2 |
    | innodb_read_only | OFF |
    | innodb_replication_delay | 0 |
    | innodb_rollback_on_timeout | OFF |
    | innodb_rollback_segments | 128 |
    | innodb_sched_priority_cleaner | 19 |
    | innodb_show_locks_held | 10 |
    | innodb_show_verbose_locks | 0 |
    | innodb_simulate_comp_failures | 0 |
    | innodb_sort_buffer_size | 2097152 |
    | innodb_spin_wait_delay | 6 |
    | innodb_stats_auto_recalc | ON |
    | 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 | OFF |
    | innodb_support_xa | ON |
    | innodb_sync_array_size | 1 |
    | innodb_sync_spin_loops | 30 |
    | innodb_table_locks | ON |
    | innodb_thread_concurrency | 0 |
    | innodb_thread_sleep_delay | 10000 |
    | innodb_track_changed_pages | OFF |
    | innodb_undo_directory | . |
    | innodb_undo_logs | 128 |
    | innodb_undo_tablespaces | 0 |
    | innodb_use_atomic_writes | OFF |
    | innodb_use_fallocate | OFF |
    | innodb_use_global_flush_log_at_trx_commit | ON |
    | innodb_use_native_aio | ON |
    | innodb_use_stacktrace | OFF |
    | innodb_use_sys_malloc | ON |
    | innodb_version | 5.6.25-73.1 |
    | innodb_write_io_threads | 2 |
    | interactive_timeout | 28800 |
    | join_buffer_size | 131072 |
    | join_buffer_space_limit | 2097152 |
    | join_cache_level | 2 |
    | keep_files_on_create | OFF |
    | key_buffer_size | 33554432 |
    | 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 | 31536000 |
    | locked_in_memory | OFF |
    | log_bin | OFF |
    | log_bin_trust_function_creators | OFF |
    | log_error | /var/log/mysqld.log |
    | log_output | FILE |
    | log_queries_not_using_indexes | OFF |
    | log_slave_updates | OFF |
    | 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_verbosity | |
    | 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 | 33554432 |
    | max_binlog_cache_size | 18446744073709547520 |
    | max_binlog_size | 1073741824 |
    | max_binlog_stmt_cache_size | 18446744073709547520 |
    | max_connect_errors | 100000 |
    | max_connections | 300 |
    | max_delayed_threads | 20 |
    | max_digest_length | 1024 |
    | max_error_count | 64 |
    | max_heap_table_size | 33554432 |
    | max_insert_delayed_threads | 20 |
    | max_join_size | 18446744073709551615 |
    | max_length_for_sort_data | 1024 |
    | max_long_data_size | 33554432 |
    | max_prepared_stmt_count | 16382 |
    | max_relay_log_size | 1073741824 |
    | max_seeks_for_key | 1000 |
    | max_sort_length | 1024 |
    | max_sp_recursion_depth | 0 |
    | 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 | DEFAULT |
    | myisam_repair_threads | 1 |
    | myisam_sort_buffer_size | 33554432 |
    | myisam_stats_method | nulls_unequal |
    | myisam_use_mmap | OFF |
    | net_buffer_length | 16384 |
    | net_read_timeout | 30 |
    | net_retry_count | 10 |
    | net_write_timeout | 60 |
    | old | OFF |
    | old_alter_table | OFF |
    | old_mode | |
    | old_passwords | OFF |
    | open_files_limit | 8192 |
    | 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 |
    | optimizer_use_condition_selectivity | 1 |
    | performance_schema | OFF |
    | performance_schema_accounts_size | -1 |
    | performance_schema_digests_size | -1 |
    | performance_schema_events_stages_history_long_size | -1 |
    | performance_schema_events_stages_history_size | -1 |
    | performance_schema_events_statements_history_long_size | -1 |
    | performance_schema_events_statements_history_size | -1 |
    | performance_schema_events_waits_history_long_size | -1 |
    | performance_schema_events_waits_history_size | -1 |
    | performance_schema_hosts_size | -1 |
    | performance_schema_max_cond_classes | 80 |
    | performance_schema_max_cond_instances | -1 |
    | performance_schema_max_digest_length | 1024 |
    | performance_schema_max_file_classes | 50 |
    | performance_schema_max_file_handles | 32768 |
    | performance_schema_max_file_instances | -1 |
    | performance_schema_max_mutex_classes | 200 |
    | performance_schema_max_mutex_instances | -1 |
    | performance_schema_max_rwlock_classes | 40 |
    | performance_schema_max_rwlock_instances | -1 |
    | performance_schema_max_socket_classes | 10 |
    | performance_schema_max_socket_instances | -1 |
    | performance_schema_max_stage_classes | 150 |
    | performance_schema_max_statement_classes | 180 |
    | performance_schema_max_table_handles | -1 |
    | performance_schema_max_table_instances | -1 |
    | performance_schema_max_thread_classes | 50 |
    | performance_schema_max_thread_instances | -1 |
    | performance_schema_session_connect_attrs_size | -1 |
    | performance_schema_setup_actors_size | 100 |
    | performance_schema_setup_objects_size | 100 |
    | performance_schema_users_size | -1 |
    | pid_file | /var/lib/mysql/yourserverhostname.pid |
    | plugin_dir | /usr/lib64/mysql/plugin/ |
    | plugin_maturity | unknown |
    | port | 3306 |
    | preload_buffer_size | 32768 |
    | profiling | OFF |
    | profiling_history_size | 15 |
    | progress_report_time | 5 |
    | protocol_version | 10 |
    | query_alloc_block_size | 65536 |
    | query_cache_limit | 524288 |
    | query_cache_min_res_unit | 2048 |
    | query_cache_size | 16777216 |
    | 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_buffer_size | 131072 |
    | read_only | OFF |
    | read_rnd_buffer_size | 262144 |
    | relay_log | |
    | relay_log_index | |
    | relay_log_info_file | relay-log.info |
    | relay_log_purge | ON |
    | relay_log_recovery | OFF |
    | relay_log_space_limit | 0 |
    | replicate_annotate_row_events | OFF |
    | 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_recovery_rank | 0 |
    | secure_auth | OFF |
    | secure_file_priv | |
    | server_id | 0 |
    | 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 | 3600 |
    | slave_parallel_max_queued | 131072 |
    | slave_parallel_threads | 0 |
    | slave_skip_errors | OFF |
    | slave_sql_verify_checksum | ON |
    | slave_transaction_retries | 10 |
    | 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 | |
    | 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 | |
    | storage_engine | InnoDB |
    | stored_program_cache | 256 |
    | sync_binlog | 0 |
    | sync_frm | ON |
    | sync_master_info | 0 |
    | sync_relay_log | 0 |
    | sync_relay_log_info | 0 |
    | system_time_zone | EDT |
    | table_definition_cache | 4096 |
    | table_open_cache | 2048 |
    | thread_cache_size | 64 |
    | thread_concurrency | 10 |
    | thread_handling | one-thread-per-connection |
    | thread_pool_idle_timeout | 60 |
    | thread_pool_max_threads | 500 |
    | thread_pool_oversubscribe | 3 |
    | thread_pool_size | 2 |
    | thread_pool_stall_limit | 500 |
    | thread_stack | 294912 |
    | time_format | %H:%i:%s |
    | time_zone | SYSTEM |
    | timed_mutexes | OFF |
    | tmp_table_size | 33554432 |
    | tmpdir | /home/mysqltmp |
    | transaction_alloc_block_size | 8192 |
    | transaction_prealloc_size | 4096 |
    | tx_isolation | REPEATABLE-READ |
    | tx_read_only | OFF |
    | unique_checks | ON |
    | updatable_views_with_limit | YES |
    | use_stat_tables | NEVER |
    | userstat | OFF |
    | version | 10.0.21-MariaDB |
    | version_comment | MariaDB Server |
    | version_compile_machine | x86_64 |
    | version_compile_os | Linux |
    | version_malloc_library | bundled jemalloc |
    | wait_timeout | 120 |
    +--------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    +-----------------------------------------------+--------------------------------------------------+
    | Variable_name | Value |
    +-----------------------------------------------+--------------------------------------------------+
    | Aborted_clients | 65 |
    | Aborted_connects | 1 |
    | Access_denied_errors | 1 |
    | Aria_pagecache_blocks_not_flushed | 0 |
    | Aria_pagecache_blocks_unused | 982 |
    | Aria_pagecache_blocks_used | 261 |
    | Aria_pagecache_read_requests | 599991 |
    | Aria_pagecache_reads | 71283 |
    | Aria_pagecache_write_requests | 146876 |
    | Aria_pagecache_writes | 31 |
    | Aria_transaction_log_syncs | 0 |
    | Binlog_commits | 0 |
    | Binlog_group_commits | 0 |
    | Binlog_group_commit_trigger_count | 0 |
    | Binlog_group_commit_trigger_lock_wait | 0 |
    | Binlog_group_commit_trigger_timeout | 0 |
    | Binlog_snapshot_file | |
    | Binlog_snapshot_position | 0 |
    | Binlog_bytes_written | 0 |
    | Binlog_cache_disk_use | 0 |
    | Binlog_cache_use | 0 |
    | Binlog_stmt_cache_disk_use | 0 |
    | Binlog_stmt_cache_use | 0 |
    | Busy_time | 0.000000 |
    | Bytes_received | 3862698274 |
    | Bytes_sent | 31219155125 |
    | Com_admin_commands | 0 |
    | 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_table | 12 |
    | Com_alter_tablespace | 0 |
    | Com_analyze | 0 |
    | Com_assign_to_keycache | 0 |
    | Com_begin | 2 |
    | Com_binlog | 0 |
    | Com_call_procedure | 0 |
    | Com_change_db | 411238 |
    | Com_change_master | 0 |
    | Com_check | 531 |
    | Com_checksum | 0 |
    | Com_commit | 2 |
    | Com_create_db | 0 |
    | Com_create_event | 0 |
    | Com_create_function | 0 |
    | Com_create_index | 0 |
    | Com_create_procedure | 0 |
    | Com_create_role | 0 |
    | Com_create_server | 0 |
    | Com_create_table | 7 |
    | Com_create_trigger | 0 |
    | Com_create_udf | 0 |
    | Com_create_user | 0 |
    | Com_create_view | 0 |
    | Com_dealloc_sql | 0 |
    | Com_delete | 420912 |
    | Com_delete_multi | 3 |
    | 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_role | 0 |
    | Com_drop_server | 0 |
    | Com_drop_table | 0 |
    | Com_drop_trigger | 0 |
    | Com_drop_user | 0 |
    | Com_drop_view | 0 |
    | Com_empty_query | 0 |
    | Com_execute_sql | 0 |
    | Com_flush | 0 |
    | Com_get_diagnostics | 0 |
    | Com_grant | 0 |
    | Com_grant_role | 0 |
    | Com_ha_close | 0 |
    | Com_ha_open | 0 |
    | Com_ha_read | 0 |
    | Com_help | 0 |
    | Com_insert | 350139 |
    | Com_insert_select | 0 |
    | Com_install_plugin | 0 |
    | Com_kill | 0 |
    | Com_load | 0 |
    | Com_lock_tables | 0 |
    | Com_optimize | 532 |
    | Com_preload_keys | 0 |
    | Com_prepare_sql | 0 |
    | Com_purge | 0 |
    | Com_purge_before_date | 0 |
    | Com_release_savepoint | 0 |
    | Com_rename_table | 0 |
    | Com_rename_user | 0 |
    | Com_repair | 0 |
    | Com_replace | 0 |
    | Com_replace_select | 0 |
    | Com_reset | 0 |
    | Com_resignal | 0 |
    | Com_revoke | 0 |
    | Com_revoke_all | 0 |
    | Com_revoke_role | 0 |
    | Com_rollback | 0 |
    | Com_rollback_to_savepoint | 0 |
    | Com_savepoint | 0 |
    | Com_select | 4900569 |
    | Com_set_option | 107868 |
    | Com_show_authors | 0 |
    | Com_show_binlog_events | 0 |
    | Com_show_binlogs | 0 |
    | Com_show_charsets | 0 |
    | Com_show_client_statistics | 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_proc | 0 |
    | Com_show_create_table | 202 |
    | Com_show_create_trigger | 0 |
    | Com_show_databases | 8 |
    | Com_show_engine_logs | 0 |
    | Com_show_engine_mutex | 0 |
    | Com_show_engine_status | 0 |
    | Com_show_errors | 0 |
    | Com_show_events | 0 |
    | Com_show_explain | 0 |
    | Com_show_fields | 70022 |
    | Com_show_function_status | 0 |
    | Com_show_grants | 0 |
    | Com_show_index_statistics | 0 |
    | Com_show_keys | 0 |
    | Com_show_master_status | 0 |
    | Com_show_open_tables | 0 |
    | Com_show_plugins | 0 |
    | Com_show_privileges | 0 |
    | Com_show_procedure_status | 0 |
    | Com_show_processlist | 4 |
    | Com_show_profile | 0 |
    | Com_show_profiles | 0 |
    | Com_show_relaylog_events | 0 |
    | Com_show_slave_hosts | 0 |
    | Com_show_slave_status | 0 |
    | Com_show_status | 14 |
    | Com_show_storage_engines | 0 |
    | Com_show_table_statistics | 0 |
    | Com_show_table_status | 91 |
    | Com_show_tables | 7204 |
    | Com_show_triggers | 89 |
    | Com_show_user_statistics | 0 |
    | Com_show_variables | 237 |
    | 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 | 160 |
    | Com_uninstall_plugin | 0 |
    | Com_unlock_tables | 0 |
    | Com_update | 273769 |
    | 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 | 411285 |
    | Cpu_time | 0.000000 |
    | Created_tmp_disk_tables | 71338 |
    | Created_tmp_files | 238 |
    | Created_tmp_tables | 80899 |
    | Delayed_errors | 0 |
    | Delayed_insert_threads | 0 |
    | Delayed_writes | 0 |
    | Empty_queries | 2030170 |
    | Executed_events | 0 |
    | Executed_triggers | 0 |
    | Feature_delay_key_write | 0 |
    | Feature_dynamic_columns | 0 |
    | Feature_fulltext | 16 |
    | Feature_gis | 0 |
    | Feature_locale | 0 |
    | Feature_subquery | 940 |
    | Feature_timezone | 2 |
    | Feature_trigger | 0 |
    | Feature_xml | 0 |
    | Flush_commands | 1 |
    | Handler_commit | 206693 |
    | Handler_delete | 131511 |
    | Handler_discover | 0 |
    | Handler_external_lock | 0 |
    | Handler_icp_attempts | 10004810 |
    | Handler_icp_match | 9661403 |
    | Handler_mrr_init | 0 |
    | Handler_mrr_key_refills | 0 |
    | Handler_mrr_rowid_refills | 0 |
    | Handler_prepare | 0 |
    | Handler_read_first | 29763 |
    | Handler_read_key | 6755966 |
    | Handler_read_last | 39 |
    | Handler_read_next | 61960883 |
    | Handler_read_prev | 295944 |
    | Handler_read_rnd | 5049671 |
    | Handler_read_rnd_deleted | 86 |
    | Handler_read_rnd_next | 1478624050 |
    | Handler_rollback | 41 |
    | Handler_savepoint | 0 |
    | Handler_savepoint_rollback | 0 |
    | Handler_tmp_update | 107220 |
    | Handler_tmp_write | 751262 |
    | Handler_update | 273309 |
    | Handler_write | 931801 |
    | Innodb_available_undo_logs | 128 |
    | Innodb_background_log_sync | 67121 |
    | Innodb_buffer_pool_bytes_data | 13598720 |
    | Innodb_buffer_pool_bytes_dirty | 81920 |
    | Innodb_buffer_pool_dump_status | not started |
    | Innodb_buffer_pool_load_status | Buffer pool(s) load completed at 151011 15:24:10 |
    | Innodb_buffer_pool_pages_data | 830 |
    | Innodb_buffer_pool_pages_dirty | 5 |
    | Innodb_buffer_pool_pages_flushed | 68031 |
    | Innodb_buffer_pool_pages_free | 2225 |
    | Innodb_buffer_pool_pages_lru_flushed | 0 |
    | Innodb_buffer_pool_pages_made_not_young | 153306 |
    | Innodb_buffer_pool_pages_made_young | 10747 |
    | Innodb_buffer_pool_pages_misc | 16 |
    | Innodb_buffer_pool_pages_old | 286 |
    | Innodb_buffer_pool_pages_total | 3071 |
    | Innodb_buffer_pool_read_ahead | 0 |
    | Innodb_buffer_pool_read_ahead_evicted | 0 |
    | Innodb_buffer_pool_read_ahead_rnd | 0 |
    | Innodb_buffer_pool_read_requests | 19287146 |
    | Innodb_buffer_pool_reads | 2908 |
    | Innodb_buffer_pool_wait_free | 0 |
    | Innodb_buffer_pool_write_requests | 2739087 |
    | Innodb_checkpoint_age | 452 |
    | Innodb_checkpoint_max_age | 216721613 |
    | Innodb_data_fsyncs | 32691 |
    | Innodb_data_pending_fsyncs | 0 |
    | Innodb_data_pending_reads | 0 |
    | Innodb_data_pending_writes | 0 |
    | Innodb_data_read | 50171904 |
    | Innodb_data_reads | 3265 |
    | Innodb_data_writes | 244368 |
    | Innodb_data_written | 2486776832 |
    | Innodb_dblwr_pages_written | 68031 |
    | Innodb_dblwr_writes | 6135 |
    | Innodb_deadlocks | 0 |
    | Innodb_have_atomic_builtins | ON |
    | Innodb_history_list_length | 2327 |
    | Innodb_ibuf_discarded_delete_marks | 0 |
    | Innodb_ibuf_discarded_deletes | 0 |
    | Innodb_ibuf_discarded_inserts | 0 |
    | Innodb_ibuf_free_list | 14 |
    | Innodb_ibuf_merged_delete_marks | 403 |
    | Innodb_ibuf_merged_deletes | 178 |
    | Innodb_ibuf_merged_inserts | 30 |
    | Innodb_ibuf_merges | 24 |
    | Innodb_ibuf_segment_size | 16 |
    | Innodb_ibuf_size | 1 |
    | Innodb_log_waits | 0 |
    | Innodb_log_write_requests | 347357 |
    | Innodb_log_writes | 164851 |
    | Innodb_lsn_current | 1469201487 |
    | Innodb_lsn_flushed | 1469201487 |
    | Innodb_lsn_last_checkpoint | 1469201035 |
    | Innodb_master_thread_active_loops | 7813 |
    | Innodb_master_thread_idle_loops | 59309 |
    | Innodb_max_trx_id | 2144718 |
    | Innodb_mem_adaptive_hash | 1063776 |
    | Innodb_mem_dictionary | 474414 |
    | Innodb_mem_total | 51511296 |
    | Innodb_mutex_os_waits | 230 |
    | Innodb_mutex_spin_rounds | 13624 |
    | Innodb_mutex_spin_waits | 1483 |
    | Innodb_oldest_view_low_limit_trx_id | 0 |
    | Innodb_os_log_fsyncs | 12596 |
    | Innodb_os_log_pending_fsyncs | 0 |
    | Innodb_os_log_pending_writes | 0 |
    | Innodb_os_log_written | 255328256 |
    | Innodb_page_size | 16384 |
    | Innodb_pages_created | 6686 |
    | Innodb_pages_read | 2929 |
    | Innodb_pages_written | 68031 |
    | Innodb_purge_trx_id | 2144718 |
    | Innodb_purge_undo_no | 0 |
    | Innodb_read_views_memory | 200 |
    | Innodb_row_lock_current_waits | 0 |
    | Innodb_row_lock_time | 0 |
    | Innodb_row_lock_time_avg | 0 |
    | Innodb_row_lock_time_max | 0 |
    | Innodb_row_lock_waits | 12 |
    | Innodb_rows_deleted | 31549 |
    | Innodb_rows_inserted | 590205 |
    | Innodb_rows_read | 1883137 |
    | Innodb_rows_updated | 113915 |
    | Innodb_system_rows_deleted | 0 |
    | Innodb_system_rows_inserted | 0 |
    | Innodb_system_rows_read | 0 |
    | Innodb_system_rows_updated | 0 |
    | Innodb_s_lock_os_waits | 4626 |
    | Innodb_s_lock_spin_rounds | 139571 |
    | Innodb_s_lock_spin_waits | 4671 |
    | Innodb_truncated_status_writes | 0 |
    | Innodb_x_lock_os_waits | 68 |
    | Innodb_x_lock_spin_rounds | 2858 |
    | Innodb_x_lock_spin_waits | 28 |
    | Key_blocks_not_flushed | 0 |
    | Key_blocks_unused | 0 |
    | Key_blocks_used | 26785 |
    | Key_blocks_warm | 26670 |
    | Key_read_requests | 79982820 |
    | Key_reads | 631132 |
    | Key_write_requests | 1055379 |
    | Key_writes | 735780 |
    | Last_query_cost | 0.000000 |
    | Max_used_connections | 26 |
    | Memory_used | 80705592 |
    | Not_flushed_delayed_rows | 0 |
    | Open_files | 1026 |
    | Open_streams | 0 |
    | Open_table_definitions | 585 |
    | Open_tables | 626 |
    | Opened_files | 290683 |
    | Opened_plugin_libraries | 3 |
    | Opened_table_definitions | 1631 |
    | Opened_tables | 1534 |
    | 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 | 2011 |
    | Qcache_free_memory | 3584224 |
    | Qcache_hits | 1613580 |
    | Qcache_inserts | 2883622 |
    | Qcache_lowmem_prunes | 544847 |
    | Qcache_not_cached | 416795 |
    | Qcache_queries_in_cache | 6618 |
    | Qcache_total_blocks | 15640 |
    | Queries | 6954836 |
    | Questions | 6954836 |
    | Rows_read | 1543237246 |
    | Rows_sent | 48545535 |
    | Rows_tmp_read | 5585555 |
    | Rpl_status | AUTH_MASTER |
    | Select_full_join | 5 |
    | Select_full_range_join | 0 |
    | Select_range | 157832 |
    | Select_range_check | 0 |
    | Select_scan | 234958 |
    | Slave_heartbeat_period | 0.000 |
    | Slave_open_temp_tables | 0 |
    | Slave_received_heartbeats | 0 |
    | Slave_retried_transactions | 0 |
    | Slave_running | OFF |
    | Slow_launch_threads | 0 |
    | Slow_queries | 35 |
    | Sort_merge_passes | 5 |
    | Sort_priority_queue_sorts | 10774 |
    | Sort_range | 204574 |
    | Sort_rows | 8241717 |
    | Sort_scan | 136464 |
    | Ssl_accept_renegotiates | 0 |
    | Ssl_accepts | 0 |
    | Ssl_callback_cache_hits | 0 |
    | Ssl_cipher | |
    | Ssl_cipher_list | |
    | Ssl_client_connects | 0 |
    | Ssl_connect_renegotiates | 0 |
    | Ssl_ctx_verify_depth | 0 |
    | Ssl_ctx_verify_mode | 0 |
    | Ssl_default_timeout | 0 |
    | Ssl_finished_accepts | 0 |
    | Ssl_finished_connects | 0 |
    | Ssl_server_not_after | |
    | Ssl_server_not_before | |
    | Ssl_session_cache_hits | 0 |
    | Ssl_session_cache_misses | 0 |
    | Ssl_session_cache_mode | NONE |
    | Ssl_session_cache_overflows | 0 |
    | Ssl_session_cache_size | 0 |
    | Ssl_session_cache_timeouts | 0 |
    | Ssl_sessions_reused | 0 |
    | Ssl_used_session_cache_entries | 0 |
    | Ssl_verify_depth | 0 |
    | Ssl_verify_mode | 0 |
    | Ssl_version | |
    | Subquery_cache_hit | 0 |
    | Subquery_cache_miss | 18549 |
    | Syncs | 3 |
    | Table_locks_immediate | 4244125 |
    | Table_locks_waited | 1827 |
    | Tc_log_max_pages_used | 0 |
    | Tc_log_page_size | 0 |
    | Tc_log_page_waits | 0 |
    | Threadpool_idle_threads | 0 |
    | Threadpool_threads | 0 |
    | Threads_cached | 22 |
    | Threads_connected | 4 |
    | Threads_created | 26 |
    | Threads_running | 1 |
    | Uptime | 67222 |
    | Uptime_since_flush_status | 67222 |
    +-----------------------------------------------+--------------------------------------------------+
    
     
    Last edited by a moderator: Sep 11, 2016
  6. redbird

    redbird Member

    42
    6
    8
    Aug 28, 2015
    Web
    Ratings:
    +10
    Local Time:
    11:00 PM
    Quick update:
    Just had another timeout. Site was not accessible: nginx bad gateway.
    Did another mysql report - did not find anything unusual.

    Restarted php-fpm - everything went back to normal.

    Any clues?
     
  7. RoldanLT

    RoldanLT Well-Known Member

    3,979
    966
    113
    May 25, 2014
    Phillipines
    Ratings:
    +1,331
    Local Time:
    9:00 PM
    1.11
    10.2
    php-fpm error logs?
    Looks like a problem with your PHP.
     
  8. eva2000

    eva2000 Administrator Staff Member

    30,961
    6,918
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +10,420
    Local Time:
    11:00 PM
    Nginx 1.13.x
    MariaDB 5.5
    when does it time out? any pattern ? i.e. when you're actually manipulating the data via SQLWorkbench and the timeout and nginx bad gateways happen ?

    2 separate or indirectly related issues

    one mysql table crash could be for a number of reasons including improper procedures when dealing with mysql data including abruptly restarting MySQL server or rebooting server while MySQL hasn't cleanly shutdown, lack of free disk space for mysql's requirments including mysql temp directory and file usage etc. You'll have to troubleshooting and figure that out on your own.

    2nd is bad gateway, is PHP-FPM and MySQL related and specific to your web app usage so you need to optimise your PHP-FPM and MySQL configuration for your requirements.

    Centmin Mod is provide as is, so short of scripted related bugs or issues, any further optimisation to the web stack components - nginx, php-fpm, mariadb mysql, csf firewall etc or web app specific configurations are left to the Centmin Mod user to deal with. So I do not provide any free support for such.

    Nginx 502 or 504 Bad Gateway Errors



    Bad gateway 502 /504 timeouts are usually related to Nginx timing out waiting on PHP-FPM to respond as PHP-FPM is overloaded or overwhelmed with requests, so may need to tune PHP-FPM values. It also maybe due to PHP-FPM in turn being queued and backed up waiting on MariaDB MySQL server to respond - so also need to look at MySQL.

    You'll need to tune your PHP-FPM settings and this is left up to end user to do but here's a thread for starters to enable php status page output outlined at PHP-FPM - CentminMod.com LEMP Nginx web stack for CentOS and PHP-FPM - pm.max_children | Centmin Mod Community which outlines the official PHP-FPM config documentation as well.

    Checking PHP-FPM etc logs



    You'll also need to check into your PHP-FPM, Nginx and MariaDB logs which you can find as outlined at How to troubleshoot Centmin Mod initial install issues

    Server logs include Nginx, PHP-FPM, MariaDB MySQL error logs as well as others. You can find your Centmin Mod install/menu logs at FAQ 7 and server logs at FAQ 19 at Centmin Mod FAQ (most up to date info in FAQ so always read that first). Spoiler tag below has info too but may not be up to date.

    Some of Centmin Mod's installed software will have their own access and error logs which maybe useful for diagnosing errors or give info, notes, or warning notices.

    Note: There's no support provided by me for diagnosing such errors which may occur for various reasons including misconfiguration of installed php/mysql scripts or applications.

    In SSH2 telnet you can use tail command to view the last X number of lines in the file.

    For example for viewing last 10 lines in the file for:

    For Nginx access and error logs:
    Code:
    tail -10 /usr/local/nginx/logs/access.log
    tail -10 /usr/local/nginx/logs/error.log
    
    For specific domainname.com access and error log:
    Code:
    tail -10 /home/nginx/domains/domainname.com/log/access.log
    tail -10 /home/nginx/domains/domainname.com/log/error.log
    
    For other system error logs located at /var/log:

    list /var/log files in ascending time order so the most recently modified files are at the bottom
    Code:
    ls -lhrt /var/log
    
    Code:
    total 2.7M
    -rw------- 1 root root 0 Aug 29 15:33 tallylog
    -rw------- 1 root root 0 Aug 29 15:33 spooler
    drwx------ 3 root root 4.0K Aug 29 15:35 samba
    drwxr-xr-x 2 root root 4.0K Aug 29 15:35 mail
    -rw-r--r-- 1 root 500 0 Oct 8 18:13 dmesg.old
    -rw------- 1 root 500 0 Oct 8 18:13 boot.log
    -rw-r--r-- 1 root 500 0 Oct 8 18:14 dmesg
    drwx------ 2 root root 4.0K Oct 8 18:14 httpd
    drwxr-xr-x 2 root root 4.0K Oct 8 19:08 php-fpm
    -rw-rw---- 1 mysql root 2.3K Oct 9 12:38 mysqld.log
    -rw------- 1 root root 9.2K Oct 26 10:48 yum.log
    -rw------- 1 root utmp 94K Nov 7 22:59 btmp
    drwxr-xr-x 2 root root 4.0K Nov 8 00:00 sa
    -rw------- 1 root root 269K Nov 8 21:39 messages
    -rw------- 1 root root 110K Nov 8 23:08 secure
    -rw-rw-r-- 1 root utmp 43K Nov 8 23:08 wtmp
    -rw-r--r-- 1 root root 144K Nov 8 23:08 lastlog
    -rw------- 1 root root 69K Nov 8 23:08 lfd.log
    -rw------- 1 root root 332K Nov 8 23:08 maillog
    -rw------- 1 root 500 1.6M Nov 8 23:10 cron
    
    For PHP-FPM error log:
    Code:
    tail -10 /var/log/php-fpm/www-error.log
    
    and/or
    Code:
    /var/log/php-fpm/www-php.error.log
    
    For MySQL / MariaDB error log:
    Code:
    tail -10 /var/log/mysqld.log
    
    For CSF firewall LFD log:
    Code:
    tail -10 /var/log/lfd.log
    
    For Mail log:
    Code:
    tail -10 /var/log/maillog
    
    For Cron job logs:
    Code:
    tail -10 /var/log/cron
    

    How to edit php.ini and php-fpm configuration files ?



    Centmin Mod install created command short cuts outlined here to allow you to quickly edit your /usr/local/lib/php.ini file and your /usr/local/etc/php-fpm.conf file. Full list of command shortcuts below:
    • Edit php.ini = phpedit ( /usr/local/lib/php.ini )
    • Edit my.cnf = mycnf ( /etc/my.cnf )
    • Edit php-fpm.conf = fpmconf ( /usr/local/etc/php-fpm.conf )
    • Edit nginx.conf = nginxconf ( /usr/local/nginx/conf/nginx.conf )
    • Edit (nginx) virtual.conf = vhostconf - only edits /usr/local/nginx/conf/conf.d/virtual.conf not the additional vhost domain.com.conf files added later
    • Edit (nginx) php.conf = phpinc ( /usr/local/nginx/conf/php.conf )
    • Edit (nginx) drop.conf = dropinc ( /usr/local/nginx/conf/drop.conf )
    • Edit (nginx) staticfiles.conf = statfilesinc ( /usr/local/nginx/conf/staticfiles.conf )
    • nginx stop/start/restart = ngxstop/ngxstart/ngxrestart
    • php-fpm stop/start/restart = fpmstop/fpmstart/fpmrestart
    • mysql stop/start/restart = mysqlstop/mysqlstart/mysqlrestart
    • nginx + php-fpm stop/start/restart = npstop/npstart/nprestart
    • memcached stop/start/restart =memcachedstop/memcachedstart/memcachedrestart
    • csf stop/start/restart = csfstop/csfstart/csfrestart

    Troubleshooting Tools



    However, there's many linux tools and scripts that can help you figure out what was causing the load issues and when.

    Tools and commands you will want to read up on and learn for basic system admin tasks and troubleshooting.
    Notes:
    However, Centmin Mod users are free to help each other out and ask questions or give answers on this community forum. My hopes are that this community forum evolves so that more veteran long time Centmin Mod users help new Centmin Mod users out :)
     
    • Like Like x 1
  9. redbird

    redbird Member

    42
    6
    8
    Aug 28, 2015
    Web
    Ratings:
    +10
    Local Time:
    11:00 PM
    Thanks everyone for the input. Although not 100% positive yet, the problem was within php-fpm setting: