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