MariaDB DB problems, daily freezes

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

---

 

We have 4 VPS, 2 with centminmod and 2 with vestacp.

Both centminmod servers have corrupted tables in mariadb

 

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.

 

Below is the report from mysqlmymonlite.sh
Please advice if anything needs to be changed in mysql settings.

Spoiler: click for output

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

 

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?

 

Thanks everyone for the input. Although not 100% positive yet, the problem was within php-fpm setting: