Server Tuning Help (Apache and MySQL)

Fernis

Well-Known Member
Oct 28, 2006
192
1
168
I would appreciate some help in tuning my server to have it be as efficient as possible serving pages as fast as possible while not overloading the server.

I have tried to adjust some things, but it's more like a shot in the dark so I figured I would ask the experts for some advice to optimize apache and MySQL.

Below is my server information that was generated thanks to the script from eva2000 mysqlmymonlite.sh & mysqlmymon.sh server and mysql stats gathering tool

Code:
-------------------------------------------------------------
System MySQL monitoring stats
mysqlmymonlite.sh - 0.5.4 mysqlmymon.com
compiled by George Liu (eva2000) vbtechsupport.com
-------------------------------------------------------------

Report Generated:
Sat Nov 26 14:10:56 CST 2016

----------------------------
MySQL Uptime:
----------------------------
MySQL server was started 2016-11-23 16:25:50.000000
Uptime: 2 days 21 hours 45 min 6 sec
Uptime 251106
Uptime_since_flush_status 251106

--------------------
Query Cache Limit (bytes): 4194304
Query Cache Min Unit (bytes): 4096
Query Cache Size (bytes): 134217728
Query Cache Free Mem (bytes): 134199904
Query Cache Used Mem (bytes): 17824
Queries in Query Cache: 1
Query Cache Avg Size (bytes): 17824

----------------------------
Hardware Info:
----------------------------
Processors physical = 1, cores = 4, virtual = 8, hyperthreading = yes
      1  3242.250
      1  3243.625
      1  3296.000
      1  3298.625
      1  3299.875
      1  3335.250
      1  3341.375
      1  3350.750
      8  Intel(R) Xeon(R) CPU E31230 @ 3.20GHz
      8  8192 KB


----------------------------
TOP stats
----------------------------

Linux 3.10.0-427.18.2.lve1.4.24.el7.x86_64 ((yourserverhostname))     11/26/2016     _x86_64_    (8 CPU)

02:10:56 PM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest  %gnice   %idle
02:10:58 PM  all    2.94    0.00    0.38    0.06    0.00    0.00    0.00    0.00    0.00   96.62
02:10:58 PM    0   22.00    0.00    2.50    0.00    0.00    0.00    0.00    0.00    0.00   75.50
02:10:58 PM    1    0.00    0.00    0.50    0.00    0.00    0.00    0.00    0.00    0.00   99.50
02:10:58 PM    2    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
02:10:58 PM    3    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
02:10:58 PM    4    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
02:10:58 PM    5    0.50    0.00    0.00    0.50    0.00    0.00    0.00    0.00    0.00   98.99
02:10:58 PM    6    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
02:10:58 PM    7    0.50    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.50

02:10:58 PM  CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest  %gnice   %idle
02:11:00 PM  all    0.19    0.00    0.06    0.06    0.00    0.00    0.00    0.00    0.00   99.69
02:11:00 PM    0    1.50    0.00    0.50    0.00    0.00    0.00    0.00    0.00    0.00   98.00
02:11:00 PM    1    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
02:11:00 PM    2    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
02:11:00 PM    3    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
02:11:00 PM    4    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
02:11:00 PM    5    0.50    0.00    0.00    0.50    0.00    0.00    0.00    0.00    0.00   99.00
02:11:00 PM    6    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
02:11:00 PM    7    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00

Average:     CPU    %usr   %nice    %sys %iowait    %irq   %soft  %steal  %guest  %gnice   %idle
Average:     all    1.56    0.00    0.22    0.06    0.00    0.00    0.00    0.00    0.00   98.15
Average:       0   11.75    0.00    1.50    0.00    0.00    0.00    0.00    0.00    0.00   86.75
Average:       1    0.00    0.00    0.25    0.00    0.00    0.00    0.00    0.00    0.00   99.75
Average:       2    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
Average:       3    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
Average:       4    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
Average:       5    0.50    0.00    0.00    0.50    0.00    0.00    0.00    0.00    0.00   99.00
Average:       6    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00  100.00
Average:       7    0.25    0.00    0.00    0.00    0.00    0.00    0.00    0.00    0.00   99.75

top - 14:11:00 up 3 days, 42 min,  1 user,  load average: 0.61, 0.55, 0.46
Tasks: 219 total,   1 running, 218 sleeping,   0 stopped,   0 zombie
%Cpu(s):  2.8 us,  0.6 sy,  0.0 ni, 95.9 id,  0.6 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem :  7983772 total,   447388 free,  1845996 used,  5690388 buff/cache
KiB Swap:  8257532 total,  7675016 free,   582516 used.  5617324 avail Mem

    PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+ COMMAND
904909 root      20   0  155788   2008   1468 R   6.7  0.0   0:00.01 top
      1 root      20   0  191248   3576   2140 S   0.0  0.0   2:12.66 systemd
      2 root      20   0       0      0      0 S   0.0  0.0   0:00.10 kthreadd
      3 root      20   0       0      0      0 S   0.0  0.0   0:01.04 ksoftirq+
      5 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/+
      7 root      rt   0       0      0      0 S   0.0  0.0   0:00.58 migratio+
      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   0:00.00 rcuob/2
     12 root      20   0       0      0      0 S   0.0  0.0   0:00.00 rcuob/3
     13 root      20   0       0      0      0 S   0.0  0.0   0:00.00 rcuob/4
     14 root      20   0       0      0      0 S   0.0  0.0   0:00.00 rcuob/5
     15 root      20   0       0      0      0 S   0.0  0.0   0:00.00 rcuob/6
     16 root      20   0       0      0      0 S   0.0  0.0   0:00.00 rcuob/7
     17 root      20   0       0      0      0 S   0.0  0.0  12:17.28 rcu_sched
     18 root      20   0       0      0      0 S   0.0  0.0   3:13.84 rcuos/0
     19 root      20   0       0      0      0 S   0.0  0.0   3:28.24 rcuos/1
     20 root      20   0       0      0      0 S   0.0  0.0   3:28.02 rcuos/2
     21 root      20   0       0      0      0 S   0.0  0.0   3:27.57 rcuos/3
     22 root      20   0       0      0      0 S   0.0  0.0   0:41.98 rcuos/4
     23 root      20   0       0      0      0 S   0.0  0.0   2:06.40 rcuos/5
     24 root      20   0       0      0      0 S   0.0  0.0   3:07.72 rcuos/6
     25 root      20   0       0      0      0 S   0.0  0.0   0:45.50 rcuos/7
     26 root      rt   0       0      0      0 S   0.0  0.0   0:00.78 watchdog+
     27 root      rt   0       0      0      0 S   0.0  0.0   0:00.76 watchdog+
     28 root      rt   0       0      0      0 S   0.0  0.0   0:00.42 migratio+
     29 root      20   0       0      0      0 S   0.0  0.0   0:00.28 ksoftirq+
     31 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/+
     32 root      rt   0       0      0      0 S   0.0  0.0   0:00.68 watchdog+
     33 root      rt   0       0      0      0 S   0.0  0.0   0:00.44 migratio+
     34 root      20   0       0      0      0 S   0.0  0.0   0:00.05 ksoftirq+
     36 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/+
     37 root      rt   0       0      0      0 S   0.0  0.0   0:00.68 watchdog+
     38 root      rt   0       0      0      0 S   0.0  0.0   0:00.21 migratio+
     39 root      20   0       0      0      0 S   0.0  0.0   0:00.04 ksoftirq+
     41 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/+
     42 root      rt   0       0      0      0 S   0.0  0.0   0:00.67 watchdog+
     43 root      rt   0       0      0      0 S   0.0  0.0   0:00.84 migratio+
     44 root      20   0       0      0      0 S   0.0  0.0   0:00.00 ksoftirq+
     46 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/+
     47 root      rt   0       0      0      0 S   0.0  0.0   0:00.65 watchdog+
     48 root      rt   0       0      0      0 S   0.0  0.0   0:00.76 migratio+
     49 root      20   0       0      0      0 S   0.0  0.0   0:00.11 ksoftirq+
     51 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/+
     52 root      rt   0       0      0      0 S   0.0  0.0   0:00.84 watchdog+
     53 root      rt   0       0      0      0 S   0.0  0.0   0:01.22 migratio+
     54 root      20   0       0      0      0 S   0.0  0.0   0:11.69 ksoftirq+
     56 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/+
     57 root      rt   0       0      0      0 S   0.0  0.0   0:00.70 watchdog+
     58 root      rt   0       0      0      0 S   0.0  0.0   0:01.12 migratio+
     59 root      20   0       0      0      0 S   0.0  0.0   0:00.08 ksoftirq+
     61 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kworker/+
     62 root      20   0       0      0      0 S   0.0  0.0   0:01.00 khelper
     63 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kdevtmpfs
     64 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 netns
     65 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 perf
     66 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 writeback
     67 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kintegri+
     68 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 bioset
     69 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kblockd
     70 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 md
     75 root      20   0       0      0      0 S   0.0  0.0   0:00.00 ubstatd
     76 root      20   0       0      0      0 S   0.0  0.0   0:00.11 khungtas+
     77 root      20   0       0      0      0 S   0.0  0.0   1:25.87 kswapd0
     78 root      25   5       0      0      0 S   0.0  0.0   0:00.00 ksmd
     79 root      39  19       0      0      0 S   0.0  0.0   0:08.39 khugepag+
     80 root      20   0       0      0      0 S   0.0  0.0   0:00.00 fsnotify+
     81 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 crypto
     89 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kthrotld
     92 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kmpath_r+
     93 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kpsmoused
     95 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 ipv6_add+
     96 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 bioset
    115 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 deferwq
    155 root      20   0       0      0      0 S   0.0  0.0   0:01.01 kauditd
    339 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 ata_sff
    342 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 events_p+
    357 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 ttm_swap
    364 root      20   0       0      0      0 S   0.0  0.0   0:00.00 scsi_eh_0
    365 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 scsi_tmf+
    366 root      20   0       0      0      0 S   0.0  0.0   0:00.00 scsi_eh_1
    367 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 scsi_tmf+
    372 root      20   0       0      0      0 S   0.0  0.0   0:00.04 scsi_eh_2
    373 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 scsi_tmf+
    374 root      20   0       0      0      0 S   0.0  0.0   0:00.08 scsi_eh_3
    375 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 scsi_tmf+
    389 root       0 -20       0      0      0 S   0.0  0.0   0:00.27 kworker/+
    449 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kdmflush
    450 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 bioset
    459 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kdmflush
    460 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 bioset
    475 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfsalloc
    476 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs_mru_+
    477 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-buf/+
    478 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-data+
    479 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-conv+
    480 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-cil/+
    481 root      20   0       0      0      0 S   0.0  0.0   1:15.31 xfsaild/+
    546 root       0 -20       0      0      0 S   0.0  0.0   0:00.14 kworker/+
    554 root      20   0   78232  36908  32768 S   0.0  0.5   2:54.74 systemd-+
    561 root       0 -20       0      0      0 S   0.0  0.0   0:40.30 kworker/+
    567 root       0 -20       0      0      0 S   0.0  0.0   0:00.02 kworker/+
    571 root      20   0   43408   1012   1008 S   0.0  0.0   0:00.22 systemd-+
    585 root      20   0  192620    752    752 S   0.0  0.0   0:00.00 lvmetad
    587 root       0 -20       0      0      0 S   0.0  0.0   0:00.90 kworker/+
    635 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 edac-pol+
    639 root       0 -20       0      0      0 S   0.0  0.0   0:00.13 kworker/+
    663 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kvm-irqf+
    666 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-buf/+
    667 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-data+
    668 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-conv+
    669 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-cil/+
    670 root      20   0       0      0      0 S   0.0  0.0   0:00.00 xfsaild/+
    671 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 kdmflush
    672 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 bioset
    680 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-buf/+
    681 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-data+
    682 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-conv+
    683 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 xfs-cil/+
    684 root      20   0       0      0      0 S   0.0  0.0   1:13.10 xfsaild/+
    685 root       0 -20       0      0      0 S   0.0  0.0   0:00.78 kworker/+
    711 root      16  -4   55416   1436   1320 S   0.0  0.0   0:02.61 auditd
    733 root      20   0   19168   1000    916 S   0.0  0.0   0:07.33 irqbalan+
    737 dbus      20   0   24756   1640   1192 S   0.0  0.0   0:34.82 dbus-dae+
    745 root      20   0  434416   3840   2940 S   0.0  0.0   0:08.14 NetworkM+
    750 root      20   0   24324   1472   1392 S   0.0  0.0   0:00.12 smartd
    751 root      20   0   22388   1528   1280 S   0.0  0.0   0:15.56 systemd-+
    752 root      20   0  145708   1448   1408 S   0.0  0.0   0:00.51 pure-aut+
    754 polkitd   20   0  525936   4804   2384 S   0.0  0.1   0:14.51 polkitd
    759 root      20   0   25844    828    824 S   0.0  0.0   0:00.00 atd
    796 nscd      20   0 1667696   2852   1584 S   0.0  0.0   2:06.97 nscd
    801 root      20   0  108124    624    620 S   0.0  0.0   0:00.05 agetty
    814 root      20   0       0      0      0 S   0.0  0.0   0:09.02 lve_tag_+
    815 root      20   0       0      0      0 S   0.0  0.0   0:00.05 lve_init+
    816 root      20   0       0      0      0 S   0.0  0.0   0:03.20 lve_load+
    988 mailnull  20   0   78864   1152    992 S   0.0  0.0   0:07.20 exim
   1038 root      20   0  100696   2636   1600 S   0.0  0.0   0:13.80 cf-execd
   1051 root      20   0   36568    968    708 S   0.0  0.0   0:00.73 cf-serve+
   1137 root      20   0  149852   5604   1820 S   0.0  0.1  28:34.09 queuepro+
   1138 root      20   0   36668   5624   1864 S   0.0  0.1   1:07.35 cf-monit+
   1355 root      20   0  551252   4440   3976 S   0.0  0.1   0:21.61 tuned
   1359 root      20   0  146320   2436   2360 S   0.0  0.0   0:00.49 pure-ftpd
   1360 root      20   0  222668   7172   5372 S   0.0  0.1   2:38.78 snmpd
   1363 root      20   0  678716  18980  18636 S   0.0  0.2   1:40.77 rsyslogd
   1364 root      20   0   15124   1476   1308 S   0.0  0.0   0:03.71 dovecot
   2166 root      20   0   81540    592    488 S   0.0  0.0   0:00.01 sshd
   2572 root       0 -20       0      0      0 S   0.0  0.0   0:00.03 kworker/+
   2860 root      20   0   28064   4236   2124 S   0.0  0.1   0:41.44 cpsrvd (+
   2944 root      20   0  131164   2052   1724 S   0.0  0.0   0:00.25 dnsadmin+
   2957 root      38  18   26500   1932   1388 S   0.0  0.0   0:00.53 cpanello+
   3150 dovecot   20   0    9588   1036    952 S   0.0  0.0   0:00.72 anvil
   3226 root      20   0   10600    200    152 S   0.0  0.0   0:01.14 proxyexec
   3270 root      20   0   45252   5440   1540 S   0.0  0.1   0:07.11 tailwatc+
   3353 root      20   0  723780 408284   1744 S   0.0  5.1   1:39.82 clamd
   3521 root      20   0  165096   2024   1400 S   0.0  0.0   0:03.59 lvestats+
   3527 root      20   0  107912    512    404 S   0.0  0.0   0:00.00 rhnsd
   3673 root      20   0  252084   2164   1872 S   0.0  0.0   0:16.17 cpanel_p+
   7595 named     20   0  826840  21552   2196 S   0.0  0.3   1:20.67 pdns_ser+
  39348 root      20   0  131724   1544   1004 S   0.0  0.0   0:00.26 cpdavd -+
  42414 mysql     20   0  113252   1268   1264 S   0.0  0.0   0:00.01 mysqld_s+
  43459 mysql     20   0 2652676 445440   6328 S   0.0  5.6  44:06.07 mysqld
  48298 root      20   0       0      0      0 S   0.0  0.0   0:00.06 jbd2/sdb+
  48299 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 ext4-rsv+
  48300 root       0 -20       0      0      0 S   0.0  0.0   0:00.00 ext4-unr+
  61247 mailman   20   0  233268   1236    988 S   0.0  0.0   0:00.02 mailmanc+
  61248 mailman   20   0  230992   8372   3952 S   0.0  0.1   0:24.50 python
  61249 mailman   20   0  231012   8480   3952 S   0.0  0.1   0:25.65 python
  61250 mailman   20   0  231020   8412   3952 S   0.0  0.1   0:24.18 python
  61251 mailman   20   0  231020   8432   3952 S   0.0  0.1   0:24.13 python
  61252 mailman   20   0  231032   8372   3952 S   0.0  0.1   0:24.69 python
  61253 mailman   20   0  231024   8428   3952 S   0.0  0.1   0:25.59 python
  61254 mailman   20   0  230968   8416   3952 S   0.0  0.1   0:24.91 python
  61255 mailman   20   0  230972   8432   3952 S   0.0  0.1   0:00.18 python
  86411 dovenull  20   0   44304   3536   2904 S   0.0  0.0   0:00.98 pop3-log+
  86412 dovenull  20   0   44680   3888   2920 S   0.0  0.0   0:04.05 imap-log+
  86413 root      20   0    9840   1276   1040 S   0.0  0.0   0:01.52 log
  86415 dovenull  20   0   43688   3276   2904 S   0.0  0.0   0:00.82 pop3-log+
  86416 root      20   0   26376   4424   1156 S   0.0  0.1   0:03.21 config
  86417 dovenull  20   0   44872   4080   2920 S   0.0  0.1   0:06.83 imap-log+
344181 root      20   0  221576  30596   9588 S   0.0  0.4   0:09.13 httpd
358819 root      20   0  124340   1344    924 S   0.0  0.0   0:00.93 crond
497535 root      20   0   27180   2984   1676 S   0.0  0.0  12:32.65 spamd-do+
697353 root      20   0  180116  27740   2080 S   0.0  0.3   0:54.73 lfd - sl+
704305 root      20   0       0      0      0 S   0.0  0.0   0:00.95 kworker/+
792883 root      20   0       0      0      0 S   0.0  0.0   0:00.37 kworker/+
816553 root      20   0       0      0      0 S   0.0  0.0   0:00.45 kworker/+
817982 root      20   0  141032   5152   1744 S   0.0  0.1   0:00.04 cpgreyli+
852330 root      20   0       0      0      0 S   0.0  0.0   0:00.58 kworker/+
885100 root      20   0       0      0      0 S   0.0  0.0   0:01.87 kworker/+
888177 root      20   0       0      0      0 S   0.0  0.0   0:00.87 kworker/+
893106 root      20   0       0      0      0 S   0.0  0.0   0:00.08 kworker/+
893837 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/+
894444 nobody    20   0  221576  21640    632 S   0.0  0.3   0:04.48 httpd
894445 root      20   0   97116  22172   3168 S   0.0  0.3   0:00.18 leechpro+
894446 nobody    20   0 2146804  69512   7952 S   0.0  0.9   0:06.26 httpd
894447 nobody    20   0 2146804 240260   8012 S   0.0  3.0   0:08.86 httpd
894506 nobody    20   0 2146804  71428   7948 S   0.0  0.9   0:06.16 httpd
894543 nobody    20   0 2146804 214160   7936 S   0.0  2.7   0:08.75 httpd
897984 root      20   0       0      0      0 S   0.0  0.0   0:00.72 kworker/+
899449 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/+
900250 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/+
900777 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/+
900793 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/+
901382 root      20   0       0      0      0 S   0.0  0.0   0:00.12 kworker/+
901761 root      20   0  150996   5672   4344 S   0.0  0.1   0:00.06 sshd
901763 root      20   0   51184   2180   1468 S   0.0  0.0   0:00.01 sftp-ser+
901791 root      20   0  151012   5892   4476 S   0.0  0.1   0:00.16 sshd
901803 root      20   0  113600   2056   1596 S   0.0  0.0   0:00.03 bash
902127 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/+
902420 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/+
903033 root      20   0  150996   5652   4336 S   0.0  0.1   0:00.04 sshd
903036 root      20   0   51000   1948   1412 S   0.0  0.0   0:00.00 sftp-ser+
903114 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/+
903116 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/+
903382 root      20   0    9584    840    704 S   0.0  0.0   0:00.00 ssl-para+
904337 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/+
904351 root      20   0       0      0      0 S   0.0  0.0   0:00.00 kworker/+
904744 root      20   0  113652   2024   1272 S   0.0  0.0   0:00.01 mysqlmym+

              total        used        free      shared  buff/cache   available
Mem:           7796        1802         437         149        5557        5486
Low:           7796        7359         437
High:             0           0           0
Swap:          8063         568        7495

MemTotal:        7983772 kB
MemFree:          447824 kB
MemAvailable:    5617760 kB
Buffers:             616 kB
Cached:          2702484 kB
SwapCached:        47820 kB
Active:          3009280 kB
Inactive:        1242512 kB
Active(anon):    1013208 kB
Inactive(anon):   688788 kB
Active(file):    1996072 kB
Inactive(file):   553724 kB
Unevictable:           0 kB
Mlocked:               0 kB
SwapTotal:       8257532 kB
SwapFree:        7675016 kB
Dirty:              2016 kB
Writeback:             0 kB
AnonPages:       1504320 kB
Mapped:            56824 kB
Shmem:            153256 kB
Slab:            2987288 kB
SReclaimable:    2873532 kB
SUnreclaim:       113756 kB
KernelStack:        6448 kB
PageTables:        17384 kB
NFS_Unstable:          0 kB
Bounce:                0 kB
WritebackTmp:          0 kB
CommitLimit:    12249416 kB
Committed_AS:    3060324 kB
VmallocTotal:   34359738367 kB
VmallocUsed:      303404 kB
VmallocChunk:   34359317060 kB
HardwareCorrupted:     0 kB
AnonHugePages:    358400 kB
Tcache:                0 kB
Tswap:                 0 kB
HugePages_Total:       0
HugePages_Free:        0
HugePages_Rsvd:        0
HugePages_Surp:        0
Hugepagesize:       2048 kB
DirectMap4k:      137424 kB
DirectMap2M:     8228864 kB

--------------------------
ps_mem.py output:
[URL]http://www.pixelbeat.org/scripts/ps_mem.py[/URL]
--------------------------
Private  +   Shared  =  RAM used    Program

  4.0 KiB +  23.5 KiB =  27.5 KiB    agetty
  4.0 KiB +  75.5 KiB =  79.5 KiB    systemd-udevd
68.0 KiB +  16.5 KiB =  84.5 KiB    proxyexec
  4.0 KiB +  83.5 KiB =  87.5 KiB    lvmetad
48.0 KiB +  81.5 KiB = 129.5 KiB    pure-authd
84.0 KiB +  49.0 KiB = 133.0 KiB    atd
116.0 KiB +  68.5 KiB = 184.5 KiB    anvil
116.0 KiB +  71.0 KiB = 187.0 KiB    irqbalance
168.0 KiB +  29.0 KiB = 197.0 KiB    rhnsd
  4.0 KiB + 217.0 KiB = 221.0 KiB    mysqld_safe
176.0 KiB +  66.5 KiB = 242.5 KiB    ssl-params
180.0 KiB +  86.5 KiB = 266.5 KiB    auditd
144.0 KiB + 137.5 KiB = 281.5 KiB    pure-ftpd
216.0 KiB +  93.0 KiB = 309.0 KiB    dovecot
248.0 KiB +  70.5 KiB = 318.5 KiB    log
172.0 KiB + 159.5 KiB = 331.5 KiB    smartd
376.0 KiB +  96.5 KiB = 472.5 KiB    exim
308.0 KiB + 171.5 KiB = 479.5 KiB    mailmanctl
372.0 KiB + 132.0 KiB = 504.0 KiB    cf-serverd
336.0 KiB + 170.0 KiB = 506.0 KiB    dnsadmin - dorm
464.0 KiB +  43.0 KiB = 507.0 KiB    crond
560.0 KiB +  96.0 KiB = 656.0 KiB    cpdavd - accept
612.0 KiB +  48.5 KiB = 660.5 KiB    systemd-logind
544.0 KiB + 143.0 KiB = 687.0 KiB    cpanellogd - sl
796.0 KiB +  52.0 KiB = 848.0 KiB    dbus-daemon
664.0 KiB + 238.5 KiB = 902.5 KiB    bash
756.0 KiB + 225.0 KiB = 981.0 KiB    mysqlmymonlite.
576.0 KiB + 454.0 KiB =   1.0 MiB    tuned
908.0 KiB + 141.0 KiB =   1.0 MiB    lvestats-server
  1.0 MiB + 408.0 KiB =   1.4 MiB    cf-execd
  1.1 MiB + 466.0 KiB =   1.6 MiB    pop3-login (2)
  1.3 MiB + 305.0 KiB =   1.6 MiB    sftp-server (2)
  1.5 MiB + 163.5 KiB =   1.7 MiB    spamd-dormant:
  1.6 MiB + 204.0 KiB =   1.8 MiB    nscd
  1.5 MiB + 557.0 KiB =   2.0 MiB    NetworkManager
  2.4 MiB +  94.5 KiB =   2.5 MiB    systemd
  2.1 MiB + 482.0 KiB =   2.5 MiB    imap-login (2)
  2.4 MiB + 188.5 KiB =   2.6 MiB    cpsrvd (SSL) -
  1.6 MiB +   1.2 MiB =   2.8 MiB    cpanel_php_fpm
  2.5 MiB + 504.5 KiB =   3.0 MiB    polkitd
  3.3 MiB +  83.5 KiB =   3.4 MiB    config
  3.3 MiB + 173.0 KiB =   3.5 MiB    cpgreylistd - p
  3.7 MiB + 221.0 KiB =   4.0 MiB    queueprocd - wa
  3.8 MiB + 177.0 KiB =   4.0 MiB    tailwatchd
  3.9 MiB + 410.0 KiB =   4.3 MiB    cf-monitord
  4.0 MiB + 311.5 KiB =   4.3 MiB    snmpd
  4.6 MiB +   2.1 MiB =   6.7 MiB    sshd (4)
  1.5 MiB +   6.3 MiB =   7.8 MiB    rsyslogd
  8.0 MiB +  10.1 MiB =  18.1 MiB    systemd-journald
19.0 MiB + 316.5 KiB =  19.3 MiB    leechprotect
20.6 MiB + 152.5 KiB =  20.8 MiB    pdns_server
25.1 MiB + 230.5 KiB =  25.4 MiB    lfd - sleeping
35.0 MiB +   2.6 MiB =  37.7 MiB    python2.7 (8)
397.7 MiB + 138.0 KiB = 397.9 MiB    clamd
435.4 MiB + 274.5 KiB = 435.7 MiB    mysqld
473.1 MiB +  27.7 MiB = 500.8 MiB    httpd (6)
---------------------------------
                          1.5 GiB
=================================

Private  +   Shared  =  RAM used    Program


smem -uk
User     Count     Swap      USS      PSS      RSS
dovecot      1    80.0K   116.0K   171.0K     1.1M
mailnull     1     3.6M   376.0K   400.0K     1.1M
dbus         1   160.0K   796.0K   819.0K     1.7M
nscd         1   360.0K     1.6M     1.7M     3.0M
polkitd      1     4.0M     2.5M     2.9M     4.9M
dovenull     4     3.3M     3.2M     3.9M    14.6M
named        1     2.7M    20.6M    20.7M    21.6M
mailman      9    54.1M    35.3M    37.1M    67.3M
mysql        2   182.1M   435.4M   435.8M   438.1M
nobody       5  1020.0K   472.1M   493.7M   603.6M
root        49    60.8M   511.8M   539.5M   658.0M

smem -t -p
  PID User     Command                         Swap      USS      PSS      RSS
  801 root     /sbin/agetty --noclear tty1    0.00%    0.00%    0.00%    0.01%
  585 root     /usr/sbin/lvmetad -f           0.01%    0.00%    0.00%    0.01%
  571 root     /usr/lib/systemd/systemd-ud    0.01%    0.00%    0.00%    0.01%
3226 root     /usr/sbin/proxyexec -q -d -    0.00%    0.00%    0.00%    0.00%
  752 root     /usr/sbin/pure-authd -s /va    0.01%    0.00%    0.00%    0.02%
  759 root     /usr/sbin/atd -f               0.00%    0.00%    0.00%    0.01%
2166 root     /usr/sbin/sshd                 0.01%    0.00%    0.00%    0.01%
  733 root     /usr/sbin/irqbalance --fore    0.00%    0.00%    0.00%    0.01%
3150 dovecot  dovecot/anvil                  0.00%    0.00%    0.00%    0.01%
3527 root     rhnsd                          0.00%    0.00%    0.00%    0.01%
42414 mysql    /bin/sh /usr/bin/mysqld_saf    0.00%    0.00%    0.00%    0.02%
  711 root     /sbin/auditd -n                0.00%    0.00%    0.00%    0.02%
903382 root     dovecot/ssl-params             0.00%    0.00%    0.00%    0.01%
1359 root     pure-ftpd (SERVER)             0.01%    0.00%    0.00%    0.03%
1364 root     /usr/sbin/dovecot -F -c /et    0.00%    0.00%    0.00%    0.02%
  988 mailnull /usr/sbin/exim -ps -bd -q1h    0.04%    0.00%    0.00%    0.01%
  750 root     /usr/sbin/smartd -n -q neve    0.01%    0.00%    0.00%    0.02%
86413 root     dovecot/log                    0.00%    0.00%    0.00%    0.02%
61247 mailman  /usr/bin/python /usr/local/    0.12%    0.00%    0.00%    0.02%
1051 root     /var/cfengine/bin/cf-server    0.05%    0.00%    0.01%    0.01%
2944 root     dnsadmin - dormant mode        0.02%    0.00%    0.01%    0.03%
358819 root     /usr/sbin/crond -n             0.00%    0.01%    0.01%    0.02%
39348 root     cpdavd - accepting connecti    0.02%    0.01%    0.01%    0.02%
  751 root     /usr/lib/systemd/systemd-lo    0.00%    0.01%    0.01%    0.02%
2957 root     cpanellogd - sleeping for l    0.01%    0.01%    0.01%    0.02%
86415 dovenull dovecot/pop3-login             0.01%    0.01%    0.01%    0.04%
904914 mailnull /usr/sbin/exim -ps -bd -q1h    0.04%    0.01%    0.01%    0.02%
903036 root     /usr/libexec/openssh/sftp-s    0.00%    0.01%    0.01%    0.03%
  737 dbus     /bin/dbus-daemon --system -    0.00%    0.01%    0.01%    0.02%
86411 dovenull dovecot/pop3-login             0.01%    0.01%    0.01%    0.04%
901763 root     /usr/libexec/openssh/sftp-s    0.00%    0.01%    0.01%    0.03%
1355 root     /usr/bin/python -Es /usr/sb    0.13%    0.01%    0.01%    0.06%
901803 root     -bash                          0.00%    0.01%    0.01%    0.03%
904744 root     /bin/bash ./mysqlmymonlite.    0.00%    0.01%    0.01%    0.03%
3521 root     /usr/bin/python -tt /sbin/l    0.07%    0.01%    0.01%    0.03%
86412 dovenull dovecot/imap-login             0.01%    0.01%    0.01%    0.05%
86417 dovenull dovecot/imap-login             0.01%    0.01%    0.02%    0.05%
1038 root     /var/cfengine/bin/cf-execd     0.01%    0.01%    0.02%    0.03%
3673 root     php-fpm: master process (/u    0.05%    0.02%    0.02%    0.03%
497535 root     spamd-dormant: waiting for     0.00%    0.02%    0.02%    0.04%
  796 nscd     /usr/sbin/nscd                 0.00%    0.02%    0.02%    0.04%
901761 root     sshd: [email protected]               0.00%    0.02%    0.02%    0.07%
  745 root     /usr/sbin/NetworkManager --    0.01%    0.02%    0.02%    0.05%
903033 root     sshd: [email protected]               0.00%    0.02%    0.03%    0.07%
901791 root     sshd: [email protected]/0               0.00%    0.02%    0.03%    0.08%
    1 root     /usr/lib/systemd/systemd --    0.01%    0.03%    0.03%    0.04%
2860 root     cpsrvd (SSL) - dormant mode    0.00%    0.03%    0.03%    0.05%
  754 polkitd  /usr/lib/polkit-1/polkitd -    0.05%    0.03%    0.04%    0.06%
86416 root     dovecot/config                 0.14%    0.04%    0.04%    0.06%
817982 root     cpgreylistd - processo         0.00%    0.04%    0.04%    0.06%
1137 root     queueprocd - wait to proces    0.05%    0.05%    0.05%    0.07%
3270 root     tailwatch                      0.06%    0.05%    0.05%    0.07%
894444 nobody   /usr/sbin/httpd -k start       0.00%    0.01%    0.05%    0.27%
1360 root     /usr/sbin/snmpd -LS0-6d -f     0.04%    0.05%    0.05%    0.09%
1138 root     /var/cfengine/bin/cf-monito    0.01%    0.05%    0.05%    0.07%
61248 mailman  /usr/bin/python /usr/local/    0.07%    0.06%    0.06%    0.11%
61252 mailman  /usr/bin/python /usr/local/    0.07%    0.06%    0.06%    0.11%
61254 mailman  /usr/bin/python /usr/local/    0.07%    0.06%    0.06%    0.11%
61250 mailman  /usr/bin/python /usr/local/    0.07%    0.06%    0.06%    0.11%
61253 mailman  /usr/bin/python /usr/local/    0.07%    0.06%    0.06%    0.11%
61251 mailman  /usr/bin/python /usr/local/    0.07%    0.06%    0.06%    0.11%
61255 mailman  /usr/bin/python /usr/local/    0.07%    0.06%    0.06%    0.11%
61249 mailman  /usr/bin/python /usr/local/    0.07%    0.06%    0.06%    0.11%
344181 root     /usr/sbin/httpd -k start       0.00%    0.01%    0.07%    0.38%
1363 root     /usr/sbin/rsyslogd -n          0.00%    0.02%    0.10%    0.24%
904916 root     python /usr/bin/smem -t -p     0.00%    0.18%    0.18%    0.21%
  554 root     /usr/lib/systemd/systemd-jo    0.00%    0.10%    0.23%    0.46%
894445 root     /usr/local/cpanel/3rdparty/    0.00%    0.24%    0.25%    0.28%
7595 named    /usr/sbin/pdns_server --dae    0.03%    0.26%    0.27%    0.28%
697353 root     lfd - sleepin                  0.00%    0.32%    0.32%    0.35%
894446 nobody   /usr/sbin/httpd -k start       0.00%    0.52%    0.58%    0.87%
894506 nobody   /usr/sbin/httpd -k start       0.00%    0.54%    0.60%    0.90%
894543 nobody   /usr/sbin/httpd -k start       0.00%    2.33%    2.39%    2.69%
894447 nobody   /usr/sbin/httpd -k start       0.00%    2.66%    2.71%    3.01%
3353 root     /usr/local/cpanel/3rdparty/    0.01%    5.10%    5.10%    5.12%
43459 mysql    /usr/sbin/mysqld --basedir=    2.25%    5.58%    5.59%    5.60%
-------------------------------------------------------------------------------
   76 11                                      3.91%   19.04%   19.72%   23.30%

smem -wk
Area                           Used      Cache   Noncache
firmware/hardware                 0          0          0
kernel image                      0          0          0
kernel dynamic memory          5.7G       5.3G     445.1M
userspace memory               1.5G      55.6M       1.4G
free memory                  431.9M     431.9M          0


----------------------------
Server Disk Usage
----------------------------
Filesystem              Type      Size  Used Avail Use% Mounted on
/dev/mapper/centos-root xfs        50G   38G   13G  76% /
devtmpfs                devtmpfs  3.8G     0  3.8G   0% /dev
tmpfs                   tmpfs     3.9G     0  3.9G   0% /dev/shm
tmpfs                   tmpfs     3.9G  393M  3.5G  11% /run
tmpfs                   tmpfs     3.9G     0  3.9G   0% /sys/fs/cgroup
/dev/mapper/centos-home xfs       873G  105G  769G  12% /home
/dev/sda2               xfs       497M  241M  257M  49% /boot
/dev/sda1               vfat      200M  9.5M  191M   5% /boot/efi
/dev/sdb1               ext4      917G   77M  871G   1% /backup
tmpfs                   tmpfs     780M     0  780M   0% /run/user/0

----------------------------
MySQL datadir disk usage
----------------------------
/var/lib/mysql/ uses 8242440 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) 31015
max locked memory       (kbytes, -l) 64
max memory size         (kbytes, -m) unlimited
open files                      (-n) 4096
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) 31015
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited

----------------------------------------------------------
tail -15 /etc/security/limits.conf
----------------------------------------------------------
#        - nice - max nice priority allowed to raise to values: [-20, 19]
#        - rtprio - max realtime priority
#
#<domain>      <type>  <item>         <value>
#

#*               soft    core            0
#*               hard    rss             10000
#@student        hard    nproc           20
#@faculty        soft    nproc           20
#@faculty        hard    nproc           50
#ftp             hard    nproc           0
#@student        -       maxlogins       4

# End of file

----------------------------------------------------------
mysqld process limits:
cat /proc/43459/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             31015                31015                processes
Max open files            65536                65536                files  
Max locked memory         65536                65536                bytes  
Max address space         unlimited            unlimited            bytes  
Max file locks            unlimited            unlimited            locks  
Max pending signals       31015                31015                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.28 (cli) (built: Nov 14 2016 16:37:44)
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
    with the ionCube PHP Loader (enabled) + Intrusion Protection from ioncube24.com (unconfigured) v6.0.4, Copyright (c) 2002-2016, by ionCube Ltd.

System => Linux yourserverhostname 3.10.0-427.18.2.lve1.4.24.el7.x86_64 #1 SMP Tue Oct 25 17:18:26 EDT 2016 x86_64
Build Date => Nov 14 2016 16:37:36

Configure Command =>  './configure'  '--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu' '--program-prefix=' '--disable-dependency-tracking' '--prefix=/opt/cpanel/ea-php56/root/usr' '--exec-prefix=/opt/cpanel/ea-php56/root/usr' '--bindir=/opt/cpanel/ea-php56/root/usr/bin' '--sbindir=/opt/cpanel/ea-php56/root/usr/sbin' '--sysconfdir=/opt/cpanel/ea-php56/root/etc' '--datadir=/opt/cpanel/ea-php56/root/usr/share' '--includedir=/opt/cpanel/ea-php56/root/usr/include' '--libdir=/opt/cpanel/ea-php56/root/usr/lib64' '--libexecdir=/opt/cpanel/ea-php56/root/usr/libexec' '--localstatedir=/opt/cpanel/ea-php56/root/usr/var' '--sharedstatedir=/opt/cpanel/ea-php56/root/usr/com' '--mandir=/opt/cpanel/ea-php56/root/usr/share/man' '--infodir=/opt/cpanel/ea-php56/root/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib64' '--with-config-file-path=/opt/cpanel/ea-php56/root/etc' '--with-config-file-scan-dir=/opt/cpanel/ea-php56/root/etc/php.d' '--disable-debug' '--with-pic' '--enable-rpath=/opt/cpanel/ea-php56/root/usr/lib64' '--without-pear' '--with-bz2' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-xpm-dir=/usr' '--with-vpx-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-sockets' '--with-kerberos' '--enable-shmop' '--enable-calendar' '--with-libxml-dir=/usr' '--enable-xml' '--with-system-tzdata' '--with-mhash' '--enable-dtrace' '--libdir=/opt/cpanel/ea-php56/root/usr/lib64/php' '--enable-pcntl' '--enable-opcache' '--with-imap=shared,/opt/cpanel/ea-php56/root/usr' '--with-imap-ssl' '--enable-mbstring=shared' '--enable-mbregex' '--with-t1lib=/usr' '--with-gd=shared' '--with-gmp=shared' '--enable-calendar=shared' '--enable-bcmath=shared' '--with-bz2=shared' '--enable-ctype=shared' '--enable-dba=shared' '--with-db4=/usr' '--with-tcadb=/usr' '--enable-exif=shared' '--enable-ftp=shared' '--with-gettext=shared' '--with-iconv=shared' '--enable-sockets=shared' '--enable-tokenizer=shared' '--with-xmlrpc=shared' '--with-ldap=shared' '--with-ldap-sasl' '--enable-mysqlnd=shared' '--with-mysql=shared,mysqlnd' '--with-mysqli=shared,mysqlnd' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--enable-dom=shared' '--with-pgsql=shared' '--enable-simplexml=shared' '--enable-xml=shared' '--enable-wddx=shared' '--with-snmp=shared,/usr' '--enable-soap=shared' '--with-xsl=shared,/usr' '--enable-xmlreader=shared' '--enable-xmlwriter=shared' '--with-curl=shared,/usr' '--enable-pdo=shared' '--with-pdo-odbc=shared,unixODBC,/usr' '--with-pdo-mysql=shared,mysqlnd' '--with-pdo-pgsql=shared,/usr' '--with-pdo-sqlite=shared,/usr' '--with-sqlite3=shared,/usr' '--enable-json=shared' '--enable-zip=shared' '--without-readline' '--with-libedit' '--with-pspell=shared' '--enable-phar=shared' '--with-mcrypt=shared,/opt/cpanel/libmcrypt' '--enable-sysvmsg=shared' '--enable-sysvshm=shared' '--enable-sysvsem=shared' '--enable-shmop=shared' '--enable-posix=shared' '--with-unixODBC=shared,/usr' '--enable-intl=shared' '--with-icu-dir=/usr' '--with-enchant=shared,/usr' '--with-recode=shared,/usr' '--enable-fileinfo=shared' 'build_alias=x86_64-redhat-linux-gnu' 'host_alias=x86_64-redhat-linux-gnu' 'CFLAGS=-O2 '-g' '-pipe' '-Wall' '-Wp,-D_FORTIFY_SOURCE=2' '-fexceptions' '-fstack-protector-strong' '--param=ssp-buffer-size=4' '-grecord-gcc-switches' '-specs=/usr/lib/rpm/redhat/redhat-hardened-cc1' '-m64' '-mtune=generic' '-fno-strict-aliasing' '-Wno-pointer-sign'' 'LDFLAGS=-Wl,-z,relro '-specs=/usr/lib/rpm/redhat/redhat-hardened-ld'' 'LIBS= '-lpthread'' 'CXXFLAGS=-O2 '-g' '-pipe' '-Wall' '-Wp,-D_FORTIFY_SOURCE=2' '-fexceptions' '-fstack-protector-strong' '--param=ssp-buffer-size=4' '-grecord-gcc-switches' '-specs=/usr/lib/rpm/redhat/redhat-hardened-cc1' '-m64' '-mtune=generic''
    with the ionCube PHP Loader (enabled) + Intrusion Protection from ioncube24.com (unconfigured) v6.0.4, Copyright (c) 2002-2016, by ionCube Ltd.

Server API | Command Line Interface
Configuration File (php.ini) Path | /opt/cpanel/ea-php56/root/etc
Loaded Configuration File | /opt/cpanel/ea-php56/root/etc/php.ini
PHP API | 20131106
Zend Extension Build | API220131226,NTS
PHP Extension Build | API20131226,NTS
DOM/XML API Version | 20031129
API Version | 3001
MHASH API Version | Emulated Support
Client API version | mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
Client API library version | mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
API Extensions | mysql,mysqli,pdo_mysql
Client API version | mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
Phar API version | 1.1.1

display_errors | Off | Off
error_log | error_log | error_log
extension_dir | /opt/cpanel/ea-php56/root/usr/lib64/php/modules | /opt/cpanel/ea-php56/root/usr/lib64/php/modules
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 | 128M | 128M
open_basedir | no value | no value
post_max_size | 8M | 8M
realpath_cache_size | 16K | 16K
realpath_cache_ttl | 120 | 120
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
sql.safe_mode | Off | Off
upload_max_filesize | 8M | 8M
upload_tmp_dir | no value | no value
sqlite3.extension_dir | 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.32 2012-11-30
Soap Client | enabled
Soap Server | enabled
ZLib Support | enabled


pcntl support => enabled

PCRE (Perl Compatible Regular Expressions) Support => enabled
PCRE Library Version => 8.32 2012-11-30

Directive => Local Value => Master Value
pcre.backtrack_limit => 1000000 => 1000000
pcre.recursion_limit => 100000 => 100000

PDO support => enabled
PDO drivers => mysql, odbc, pgsql, sqlite

PDO Driver for MySQL => enabled
Client API version => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $

PDO Driver for SQLite 3.x => enabled
SQLite Library => 3.7.17

Phar: PHP Archive support => enabled
Phar EXT version => 2.0.2
Phar API version => 1.1.1
SVN revision => $Id: 14b80e175ed4d5bf11c890e1f30ea8225935b16c $
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




   Server Version: Apache/2.4.23 (cPanel) OpenSSL/1.0.1e-fips
   Server Built: Nov 10 2016 09:00:04
   Current Time: Saturday, 26-Nov-2016 14:10:55 CST
   Restart Time: Thursday, 24-Nov-2016 20:53:14 CST
   Total accesses: 228021 - Total Traffic: 4.4 GB
   CPU Usage: u37.71 s11.01 cu0 cs0 - .0328% CPU load
   1.53 requests/sec - 31.1 kB/second - 20.3 kB/request
   1 requests currently being processed, 99 idle workers

Server version: Apache/2.4.23 (cPanel)
Server built:   Nov 10 2016 09:00:04
Server's Module Magic Number: 20120211:61
Server loaded:  APR 1.5.2, APR-UTIL 1.5.2
Compiled using: APR 1.5.2, APR-UTIL 1.5.2
Architecture:   64-bit
Server MPM:     worker
  threaded:     yes (fixed thread count)
    forked:     yes (variable process count)
Server compiled with....
-D APR_HAS_SENDFILE
-D APR_HAS_MMAP
-D APR_HAVE_IPV6 (IPv4-mapped addresses disabled)
-D APR_USE_SYSVSEM_SERIALIZE
-D APR_USE_PTHREAD_SERIALIZE
-D SINGLE_LISTEN_UNSERIALIZED_ACCEPT
-D APR_HAS_OTHER_CHILD
-D AP_HAVE_RELIABLE_PIPED_LOGS
-D DYNAMIC_MODULE_LIMIT=256
-D HTTPD_ROOT="/etc/apache2"
-D SUEXEC_BIN="/usr/sbin/suexec"
-D DEFAULT_PIDLOG="/var/run/apache2/httpd.pid"
-D DEFAULT_SCOREBOARD="logs/apache_runtime_status"
-D DEFAULT_ERRORLOG="logs/error_log"
-D AP_TYPES_CONFIG_FILE="conf/mime.types"
-D SERVER_CONFIG_FILE="conf/httpd.conf"

Loaded Modules:
core_module (static)
so_module (static)
http_module (static)
mpm_worker_module (shared)
cgid_module (shared)
access_compat_module (shared)
actions_module (shared)
alias_module (shared)
auth_basic_module (shared)
authn_core_module (shared)
authn_file_module (shared)
authz_core_module (shared)
authz_groupfile_module (shared)
authz_host_module (shared)
authz_user_module (shared)
autoindex_module (shared)
deflate_module (shared)
dir_module (shared)
expires_module (shared)
filter_module (shared)
headers_module (shared)
include_module (shared)
log_config_module (shared)
logio_module (shared)
mime_module (shared)
negotiation_module (shared)
proxy_module (shared)
proxy_fcgi_module (shared)
proxy_http_module (shared)
rewrite_module (shared)
setenvif_module (shared)
slotmem_shm_module (shared)
socache_dbm_module (shared)
socache_shmcb_module (shared)
status_module (shared)
suexec_module (shared)
unique_id_module (shared)
unixd_module (shared)
userdir_module (shared)
ssl_module (shared)
bwlimited_module (shared)
security2_module (shared)
suphp_module (shared)
hostinglimits_module (shared)

Compiled in modules:
  core.c
  mod_so.c
  http_core.c


-------------------------------
From /etc/apache2/conf/httpd.conf
-------------------------------
Timeout 300
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5

StartServers 5
<IfModule prefork.c>
</IfModule>
ServerLimit 256
</IfModule>


----------------------------
mysqlreport output
----------------------------


----------------------------
Total Server MyISAM and InnoDB Size
----------------------------
*************************** 1. row ***************************
innodb_tablespace_utilization_perc: 100
                     total_size_gb: 7.467245786450803
                     index_size_gb: 1.278172492980957
                      data_size_gb: 6.189073293469846
              innodb_total_size_gb: 0.057647705078125
               innodb_data_size_gb: 0.0350189208984375
              innodb_index_size_gb: 0.0226287841796875
              myisam_total_size_gb: 7.409598081372678
               myisam_data_size_gb: 6.154054372571409
              myisam_index_size_gb: 1.2555437088012695
                        perc_index: 17.117053900
                         perc_data: 82.882946000
                 innodb_perc_index: 39.253573300
                  innodb_perc_data: 60.746426600
                 myisam_perc_index: 16.944828700
                  myisam_perc_data: 83.055171200
           innodb_perc_total_index: 1.770401400
            innodb_perc_total_data: 0.565818400
           myisam_perc_total_index: 98.229598500
            myisam_perc_total_data: 99.434181500

----------------------------
MySQL settings
----------------------------
[mysqld]
performance-schema=0
default-storage-engine=MyISAM
innodb_file_per_table=1
max_allowed_packet=268435456
#open_files_limit=50000
local-infile=0


max_user_connections=500
max_connections=500
interactive_timeout=300
wait_timeout=300
connect_timeout=300

low_priority_updates=1
concurrent_insert=ALWAYS

key_buffer_size = 128M
query_cache_size = 128M
query_cache_limit = 4M---
+--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| autocommit | ON |
| automatic_sp_privileges | ON |
| avoid_temporal_upgrade | OFF |
| back_log | 150 |
| basedir | /usr/ |
| big_tables | OFF |
| bind_address | * |
| binlog_cache_size | 32768 |
| binlog_checksum | CRC32 |
| binlog_direct_non_transactional_updates | OFF |
| binlog_error_action | IGNORE_ERROR |
| binlog_format | STATEMENT |
| binlog_gtid_simple_recovery | OFF |
| binlog_max_flush_queue_time | 0 |
| binlog_order_commits | ON |
| binlog_row_image | FULL |
| binlog_rows_query_log_events | OFF |
| binlog_stmt_cache_size | 32768 |
| binlogging_impossible_mode | IGNORE_ERROR |
| block_encryption_mode | aes-128-ecb |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | NO_CHAIN |
| concurrent_insert | ALWAYS |
| connect_timeout | 300 |
| core_file | OFF |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_storage_engine | MyISAM |
| default_tmp_storage_engine | InnoDB |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| disconnect_on_expired_password | ON |
| div_precision_increment | 4 |
| end_markers_in_json | OFF |
| enforce_gtid_consistency | OFF |
| eq_range_index_dive_limit | 10 |
| event_scheduler | OFF |
| expire_logs_days | 0 |
| explicit_defaults_for_timestamp | OFF |
| 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 | /var/lib/mysql/saints.log |
| group_concat_max_len | 1024 |
| gtid_executed | |
| gtid_mode | OFF |
| gtid_owned | |
| gtid_purged | |
| have_compress | YES |
| have_crypt | YES |
| have_dynamic_loading | YES |
| have_geometry | YES |
| have_openssl | DISABLED |
| have_profiling | YES |
| have_query_cache | YES |
| have_rtree_keys | YES |
| have_ssl | DISABLED |
| have_symlink | YES |
| host_cache_size | 628 |
| hostname | yourserverhostname |
| ignore_builtin_innodb | OFF |
| ignore_db_dirs | |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_adaptive_flushing | ON |
| innodb_adaptive_flushing_lwm | 10 |
| innodb_adaptive_hash_index | ON |
| 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 | OFF |
| 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 | OFF |
| innodb_buffer_pool_load_now | OFF |
| innodb_buffer_pool_size | 134217728 |
| innodb_change_buffer_max_size | 25 |
| innodb_change_buffering | all |
| innodb_checksum_algorithm | innodb |
| innodb_checksums | ON |
| 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_data_file_path | ibdata1:12M:autoextend |
| innodb_data_home_dir | |
| innodb_disable_sort_file_cache | OFF |
| innodb_doublewrite | ON |
| innodb_fast_shutdown | 1 |
| innodb_file_format | Antelope |
| 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 | 1 |
| innodb_flush_method | |
| innodb_flush_neighbors | 1 |
| innodb_flushing_avg_loops | 30 |
| innodb_force_load_corrupted | OFF |
| innodb_force_recovery | 0 |
| innodb_ft_aux_table | |
| innodb_ft_cache_size | 8000000 |
| innodb_ft_enable_diag_print | OFF |
| innodb_ft_enable_stopword | ON |
| innodb_ft_max_token_size | 84 |
| innodb_ft_min_token_size | 3 |
| innodb_ft_num_word_optimize | 2000 |
| innodb_ft_result_cache_limit | 2000000000 |
| innodb_ft_server_stopword_table | |
| innodb_ft_sort_pll_degree | 2 |
| innodb_ft_total_cache_size | 640000000 |
| innodb_ft_user_stopword_table | |
| innodb_io_capacity | 200 |
| innodb_io_capacity_max | 2000 |
| innodb_large_prefix | OFF |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_buffer_size | 8388608 |
| innodb_log_compressed_pages | ON |
| innodb_log_file_size | 50331648 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_lru_scan_depth | 1024 |
| innodb_max_dirty_pages_pct | 75 |
| innodb_max_dirty_pages_pct_lwm | 0 |
| 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 | 2000 |
| 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 | 4 |
| innodb_read_only | OFF |
| innodb_replication_delay | 0 |
| innodb_rollback_on_timeout | OFF |
| innodb_rollback_segments | 128 |
| innodb_sort_buffer_size | 1048576 |
| innodb_spin_wait_delay | 6 |
| innodb_stats_auto_recalc | ON |
| innodb_stats_method | nulls_equal |
| innodb_stats_on_metadata | OFF |
| innodb_stats_persistent | ON |
| innodb_stats_persistent_sample_pages | 20 |
| innodb_stats_sample_pages | 8 |
| 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_tmpdir | |
| innodb_undo_directory | . |
| innodb_undo_logs | 128 |
| innodb_undo_tablespaces | 0 |
| innodb_use_native_aio | ON |
| innodb_use_sys_malloc | ON |
| innodb_version | 5.6.34 |
| innodb_write_io_threads | 4 |
| interactive_timeout | 300 |
| join_buffer_size | 262144 |
| keep_files_on_create | OFF |
| key_buffer_size | 134217728 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| large_files_support | ON |
| large_page_size | 0 |
| large_pages | OFF |
| lc_messages | en_US |
| lc_messages_dir | /usr/share/mysql/ |
| lc_time_names | en_US |
| license | GPL |
| local_infile | OFF |
| lock_wait_timeout | 31536000 |
| locked_in_memory | OFF |
| log_bin | OFF |
| log_bin_basename | |
| log_bin_index | |
| log_bin_trust_function_creators | OFF |
| log_bin_use_v1_row_events | OFF |
| log_error | /var/lib/mysql/yourserverhostname.err |
| log_output | FILE |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_admin_statements | OFF |
| log_slow_slave_statements | OFF |
| log_throttle_queries_not_using_indexes | 0 |
| log_warnings | 1 |
| long_query_time | 10.000000 |
| low_priority_updates | ON |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| master_info_repository | FILE |
| master_verify_checksum | OFF |
| max_allowed_packet | 268435456 |
| max_binlog_cache_size | 18446744073709547520 |
| max_binlog_size | 1073741824 |
| max_binlog_stmt_cache_size | 18446744073709547520 |
| max_connect_errors | 100 |
| max_connections | 500 |
| max_delayed_threads | 20 |
| max_digest_length | 1024 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 18446744073709551615 |
| max_sort_length | 1024 |
| max_sp_recursion_depth | 0 |
| max_tmp_tables | 32 |
| max_user_connections | 500 |
| max_write_lock_count | 18446744073709551615 |
| metadata_locks_cache_size | 1024 |
| metadata_locks_hash_instances | 8 |
| min_examined_row_limit | 0 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 9223372036853727232 |
| myisam_mmap_size | 18446744073709551615 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 8388608 |
| 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 |
| new | OFF |
| old | OFF |
| old_alter_table | OFF |
| old_passwords | 0 |
| open_files_limit | 65536 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| optimizer_switch | index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on |
| optimizer_trace | enabled=off,one_line=off |
| optimizer_trace_features | greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on |
| optimizer_trace_limit | 1 |
| optimizer_trace_max_mem_size | 16384 |
| optimizer_trace_offset | -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 | 168 |
| 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/ |
| port | 3306 |
| preload_buffer_size | 32768 |
| profiling | OFF |
| profiling_history_size | 15 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 4194304 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 134217728 |
| query_cache_type | OFF |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 4096 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log | |
| relay_log_basename | |
| relay_log_index | |
| relay_log_info_file | relay-log.info |
| relay_log_info_repository | FILE |
| relay_log_purge | ON |
| relay_log_recovery | OFF |
| relay_log_space_limit | 0 |
| report_host | |
| report_password | |
| report_port | 3306 |
| report_user | |
| rpl_stop_slave_timeout | 31536000 |
| secure_auth | ON |
| secure_file_priv | |
| server_id | 0 |
| server_id_bits | 32 |
| server_uuid | 71b9202c-9596-11e5-9cf6-002590743ef4 |
| show_old_temporals | OFF |
| simplified_binlog_gtid_recovery | OFF |
| skip_external_locking | ON |
| skip_name_resolve | OFF |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_allow_batching | OFF |
| slave_checkpoint_group | 512 |
| slave_checkpoint_period | 300 |
| slave_compressed_protocol | OFF |
| slave_exec_mode | STRICT |
| slave_load_tmpdir | /tmp |
| slave_max_allowed_packet | 1073741824 |
| slave_net_timeout | 3600 |
| slave_parallel_workers | 0 |
| slave_pending_jobs_size_max | 16777216 |
| slave_rows_search_algorithms | TABLE_SCAN,INDEX_SCAN |
| 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/saints-slow.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 | NO_ENGINE_SUBSTITUTION |
| sql_notes | ON |
| sql_quote_show_create | ON |
| sql_safe_updates | OFF |
| sql_select_limit | 18446744073709551615 |
| sql_slave_skip_counter | 0 |
| sql_warnings | OFF |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_crl | |
| ssl_crlpath | |
| ssl_key | |
| storage_engine | MyISAM |
| stored_program_cache | 256 |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_master_info | 10000 |
| sync_relay_log | 10000 |
| sync_relay_log_info | 10000 |
| system_time_zone | CST |
| table_definition_cache | 1400 |
| table_open_cache | 2000 |
| table_open_cache_instances | 1 |
| thread_cache_size | 13 |
| thread_concurrency | 10 |
| thread_handling | one-thread-per-connection |
| thread_stack | 262144 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 16777216 |
| tmpdir | /tmp |
| 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 |
| version | 5.6.34 |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | Linux |
| wait_timeout | 300 |
+--------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+-----------------------------------------------+-------------+
| Variable_name | Value |
+-----------------------------------------------+-------------+
| Aborted_clients | 50 |
| Aborted_connects | 27 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Binlog_stmt_cache_disk_use | 0 |
| Binlog_stmt_cache_use | 0 |
| Bytes_received | 2708976971 |
| Bytes_sent | 67598674589 |
| Com_admin_commands | 5334 |
| Com_assign_to_keycache | 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 | 0 |
| Com_alter_tablespace | 0 |
| Com_alter_user | 0 |
| Com_analyze | 30 |
| Com_begin | 0 |
| Com_binlog | 0 |
| Com_call_procedure | 0 |
| Com_change_db | 57452 |
| Com_change_master | 0 |
| Com_check | 162 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 3 |
| Com_create_event | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_procedure | 0 |
| Com_create_server | 0 |
| Com_create_table | 1069 |
| Com_create_trigger | 0 |
| Com_create_udf | 0 |
| Com_create_user | 0 |
| Com_create_view | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 132778 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_event | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_procedure | 0 |
| Com_drop_server | 0 |
| Com_drop_table | 0 |
| Com_drop_trigger | 0 |
| Com_drop_user | 0 |
| Com_drop_view | 0 |
| Com_empty_query | 2075 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_get_diagnostics | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 480076 |
| Com_insert_select | 0 |
| Com_install_plugin | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_lock_tables | 157 |
| Com_optimize | 183 |
| 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 | 29885 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_resignal | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_rollback_to_savepoint | 0 |
| Com_savepoint | 0 |
| Com_select | 2967984 |
| Com_set_option | 296995 |
| Com_signal | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 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 | 13185 |
| Com_show_create_trigger | 0 |
| Com_show_databases | 15 |
| Com_show_engine_logs | 0 |
| Com_show_engine_mutex | 0 |
| Com_show_engine_status | 0 |
| Com_show_events | 2 |
| Com_show_errors | 0 |
| Com_show_fields | 13496 |
| Com_show_function_code | 0 |
| Com_show_function_status | 2 |
| Com_show_grants | 6 |
| Com_show_keys | 6 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_plugins | 0 |
| Com_show_privileges | 0 |
| Com_show_procedure_code | 0 |
| Com_show_procedure_status | 2 |
| Com_show_processlist | 996 |
| 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 | 19 |
| Com_show_storage_engines | 1 |
| Com_show_table_status | 1795 |
| Com_show_tables | 27647 |
| Com_show_triggers | 1760 |
| Com_show_variables | 797 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 612264 |
| Com_stmt_execute | 631033 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 653548 |
| Com_stmt_reprepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 721 |
| Com_truncate | 640 |
| Com_uninstall_plugin | 0 |
| Com_unlock_tables | 158 |
| Com_update | 150244 |
| Com_update_multi | 2324 |
| 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 | 234794 |
| Created_tmp_disk_tables | 61643 |
| Created_tmp_files | 1027 |
| Created_tmp_tables | 128504 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 56261 |
| Handler_delete | 282098 |
| Handler_discover | 0 |
| Handler_external_lock | 9671588 |
| Handler_mrr_init | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 185210 |
| Handler_read_key | 34295764 |
| Handler_read_last | 7558 |
| Handler_read_next | 819183076 |
| Handler_read_prev | 8880029 |
| Handler_read_rnd | 12861858 |
| Handler_read_rnd_next | 3919116349 |
| Handler_rollback | 1 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 5946788 |
| Handler_write | 7516603 |
| Innodb_buffer_pool_dump_status | not started |
| Innodb_buffer_pool_load_status | not started |
| Innodb_buffer_pool_pages_data | 2064 |
| Innodb_buffer_pool_bytes_data | 33816576 |
| Innodb_buffer_pool_pages_dirty | 1 |
| Innodb_buffer_pool_bytes_dirty | 16384 |
| Innodb_buffer_pool_pages_flushed | 3289 |
| Innodb_buffer_pool_pages_free | 6121 |
| Innodb_buffer_pool_pages_misc | 6 |
| Innodb_buffer_pool_pages_total | 8191 |
| Innodb_buffer_pool_read_ahead_rnd | 0 |
| Innodb_buffer_pool_read_ahead | 0 |
| Innodb_buffer_pool_read_ahead_evicted | 0 |
| Innodb_buffer_pool_read_requests | 1965724 |
| Innodb_buffer_pool_reads | 1775 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 31865 |
| Innodb_data_fsyncs | 3750 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 31166464 |
| Innodb_data_reads | 2717 |
| Innodb_data_writes | 6021 |
| Innodb_data_written | 111696384 |
| Innodb_dblwr_pages_written | 3289 |
| Innodb_dblwr_writes | 524 |
| Innodb_have_atomic_builtins | ON |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 6567 |
| Innodb_log_writes | 1489 |
| Innodb_os_log_fsyncs | 2009 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 3656192 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 290 |
| Innodb_pages_read | 1774 |
| Innodb_pages_written | 3289 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Innodb_rows_deleted | 145 |
| Innodb_rows_inserted | 153 |
| Innodb_rows_read | 3573575 |
| Innodb_rows_updated | 391 |
| Innodb_num_open_files | 397 |
| Innodb_truncated_status_writes | 0 |
| Innodb_available_undo_logs | 128 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 107171 |
| Key_blocks_used | 44772 |
| Key_read_requests | 123617857 |
| Key_reads | 578856 |
| Key_write_requests | 3853178 |
| Key_writes | 2280377 |
| Last_query_cost | 0.000000 |
| Last_query_partial_plans | 0 |
| Max_used_connections | 22 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 3622 |
| Open_streams | 0 |
| Open_table_definitions | 2000 |
| Open_tables | 2000 |
| Opened_files | 636530 |
| Opened_table_definitions | 124577 |
| Opened_tables | 127040 |
| Performance_schema_accounts_lost | 0 |
| Performance_schema_cond_classes_lost | 0 |
| Performance_schema_cond_instances_lost | 0 |
| Performance_schema_digest_lost | 0 |
| Performance_schema_file_classes_lost | 0 |
| Performance_schema_file_handles_lost | 0 |
| Performance_schema_file_instances_lost | 0 |
| Performance_schema_hosts_lost | 0 |
| Performance_schema_locker_lost | 0 |
| Performance_schema_mutex_classes_lost | 0 |
| Performance_schema_mutex_instances_lost | 0 |
| Performance_schema_rwlock_classes_lost | 0 |
| Performance_schema_rwlock_instances_lost | 0 |
| Performance_schema_session_connect_attrs_lost | 0 |
| Performance_schema_socket_classes_lost | 0 |
| Performance_schema_socket_instances_lost | 0 |
| Performance_schema_stage_classes_lost | 0 |
| Performance_schema_statement_classes_lost | 0 |
| Performance_schema_table_handles_lost | 0 |
| Performance_schema_table_instances_lost | 0 |
| Performance_schema_thread_classes_lost | 0 |
| Performance_schema_thread_instances_lost | 0 |
| Performance_schema_users_lost | 0 |
| Prepared_stmt_count | 0 |
| Qcache_free_blocks | 1 |
| Qcache_free_memory | 134199904 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 2962544 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 1 |
| Queries | 5688527 |
| Questions | 4417374 |
| Select_full_join | 3005 |
| Select_full_range_join | 3 |
| Select_range | 430944 |
| Select_range_check | 0 |
| Select_scan | 473733 |
| Slave_heartbeat_period | |
| Slave_last_heartbeat | |
| Slave_open_temp_tables | 0 |
| Slave_received_heartbeats | |
| Slave_retried_transactions | |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 31 |
| Sort_merge_passes | 512 |
| Sort_range | 155926 |
| Sort_rows | 13491288 |
| Sort_scan | 100242 |
| 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 | |
| Table_locks_immediate | 4802288 |
| Table_locks_waited | 237 |
| Table_open_cache_hits | 5522109 |
| Table_open_cache_misses | 127040 |
| Table_open_cache_overflows | 124154 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 12 |
| Threads_connected | 1 |
| Threads_created | 59 |
| Threads_running | 1 |
| Uptime | 251114 |
| Uptime_since_flush_status | 251114 |
+-----------------------------------------------+-------------+
+--------+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------+-----------+----+---------+------+-------+------------------+
| 234793 | root | localhost | | Query | 0 | init | show processlist |
+--------+------+-----------+----+---------+------+-------+------------------+

----------------------------
MySQL Error Log
----------------------------


Report Complete:
Sat Nov 26 14:11:04 CST 2016
----------------------------
 
Last edited:

SysSachin

Well-Known Member
Aug 23, 2015
604
48
28
India
cPanel Access Level
Root Administrator
Twitter
For the apache optimization, You can install nginx OR Litespeed on your server but I'll recommend you to install Litespeed for the best web server performance.

And for MySQL optimization I can see your mysql uptime is more than 24 hours so you can use MySQLTuner-perl by major scripts for the optimization
 

Fernis

Well-Known Member
Oct 28, 2006
192
1
168
I appreciate the feedback but I am must stay with apache and I have already used the tuner script. I was hoping to get some personal expert advice that a script can't give.
 

danielpmc

Well-Known Member
Nov 3, 2016
78
33
18
usa
cPanel Access Level
Reseller Owner
Hello Fernis,

Login to your cPanel:

cPanel/Databases/MySQL Databases/Check Database and/or Repair Database

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Login to your WHM: WHM/Server Configuration/Tweak Settings/SQL

Allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration? ON

Allow cPanel & WHM to determine the best value for your MySQL max_allowed_packet configuration? ON

Allow cPanel & WHM to determine the best value for your MySQL innodb_buffer_pool_size configuration? ON

Hope this helps you out,
danielpmc
 

danielpmc

Well-Known Member
Nov 3, 2016
78
33
18
usa
cPanel Access Level
Reseller Owner
Hello Fernis,

Since you supplied your website in your signature, i visited it. To be honest i experienced no issues with page loading or rendering. All seems to be within expected load times. I did not do any analytics or pings, just clicked around like a regular visitor would.

Just my opinion,
danielpmc
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,228
463
Hello,

You may also want to consult with a qualified system administrator for additional help if the user-feedback isn't sufficient. The following page provides a list of system administration services:

Resources | cPanel Forums

Thank you.