Skip to main content

access website slow

Xin.g88
Hello anyone can helpme, i get issue on my cpanel. ------------------------------------------------------------- System MySQL monitoring stats mysqlmymonlite.sh - 0.5.7 mysqlmymon.com compiled by George Liu (eva2000) centminmod.com ------------------------------------------------------------- Report Generated: Fri Dec 25 10:22:33 +07 2020 ---------------------------- MySQL Uptime: ---------------------------- MySQL server was started Uptime: 1 day 10 hours 20 min 18 sec Uptime 123618 Uptime_since_flush_status 123618 -------------------- Query Cache Limit (bytes): 1048576 Query Cache Min Unit (bytes): 4096 Query Cache Size (bytes): 1048576 Query Cache Free Mem (bytes): 1031832 Query Cache Used Mem (bytes): 16744 Queries in Query Cache: 1 Query Cache Avg Size (bytes): 16744 ---------------------------- Hardware Info: ---------------------------- Processors physical = 32, cores = 32, virtual = 32, hyperthreading = no 32 2599.996 32 QEMU Virtual CPU version 2.5+ 32 16384 KB ---------------------------- TOP stats ---------------------------- Linux 3.10.0-1160.11.1.el7.x86_64 ((yourserverhostname)) 12/25/2020 _x86_64_ (32 CPU) 10:22:36 AM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %gnice %idle 10:22:38 AM all 12.11 0.00 3.50 0.05 0.00 0.03 0.06 0.00 0.00 84.25 10:22:38 AM 0 1.50 0.00 1.00 0.50 0.00 0.00 0.00 0.00 0.00 97.00 10:22:38 AM 1 9.05 0.00 2.01 0.50 0.00 0.00 0.00 0.00 0.00 88.44 10:22:38 AM 2 3.52 0.00 3.52 0.00 0.00 0.00 0.00 0.00 0.00 92.96 10:22:38 AM 3 3.50 0.00 1.50 0.00 0.00 0.00 0.00 0.00 0.00 95.00 10:22:38 AM 4 27.14 0.00 7.04 0.00 0.00 0.00 0.00 0.00 0.00 65.83 10:22:38 AM 5 2.00 0.00 1.50 0.00 0.00 0.00 0.00 0.00 0.00 96.50 10:22:38 AM 6 8.59 0.00 2.53 0.00 0.00 0.00 0.00 0.00 0.00 88.89 10:22:38 AM 7 27.27 0.00 7.58 0.00 0.00 0.00 0.00 0.00 0.00 65.15 10:22:38 AM 8 29.50 0.00 4.50 1.00 0.00 0.00 0.00 0.00 0.00 65.00 10:22:38 AM 9 6.60 0.00 2.03 0.00 0.00 0.00 0.00 0.00 0.00 91.37 10:22:38 AM 10 14.00 0.00 3.00 0.00 0.00 0.00 0.00 0.00 0.00 83.00 10:22:38 AM 11 25.13 0.00 5.03 0.00 0.00 0.00 0.00 0.00 0.00 69.85 10:22:38 AM 12 15.15 0.00 4.55 0.00 0.00 0.00 0.51 0.00 0.00 79.80 10:22:38 AM 13 7.54 0.00 2.51 0.00 0.00 0.00 0.00 0.00 0.00 89.95 10:22:38 AM 14 2.51 0.00 3.02 0.00 0.00 0.00 0.00 0.00 0.00 94.47 10:22:38 AM 15 35.35 0.00 5.56 0.00 0.00 0.00 0.00 0.00 0.00 59.09 10:22:38 AM 16 18.09 0.00 5.03 0.00 0.00 0.00 0.00 0.00 0.00 76.88 10:22:38 AM 17 7.04 0.00 4.52 0.00 0.00 0.00 0.00 0.00 0.00 88.44 10:22:38 AM 18 19.60 0.00 5.53 0.00 0.00 0.00 0.00 0.00 0.00 74.87 10:22:38 AM 19 1.51 0.00 2.51 0.00 0.00 0.00 0.00 0.00 0.00 95.98 10:22:38 AM 20 25.76 0.00 4.04 0.00 0.00 1.01 0.00 0.00 0.00 69.19 10:22:38 AM 21 8.00 0.00 4.50 0.00 0.00 0.00 0.00 0.00 0.00 87.50 10:22:38 AM 22 5.03 0.00 5.03 0.00 0.00 0.00 0.00 0.00 0.00 89.95 10:22:38 AM 23 18.50 0.00 4.50 0.00 0.00 0.00 0.00 0.00 0.00 77.00 10:22:38 AM 24 23.74 0.00 6.06 0.00 0.00 0.00 0.00 0.00 0.00 70.20 10:22:38 AM 25 5.53 0.00 2.01 0.00 0.00 0.00 0.00 0.00 0.00 92.46 10:22:38 AM 26 6.03 0.00 1.01 0.00 0.00 0.00 0.00 0.00 0.00 92.96 10:22:38 AM 27 5.03 0.00 2.01 0.00 0.00 0.00 0.00 0.00 0.00 92.96 10:22:38 AM 28 1.52 0.00 1.52 0.00 0.00 0.00 0.00 0.00 0.00 96.97 10:22:38 AM 29 15.92 0.00 4.48 0.00 0.00 0.00 0.50 0.00 0.00 79.10 10:22:38 AM 30 3.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 96.50 10:22:38 AM 31 4.02 0.00 1.51 0.00 0.00 0.00 0.00 0.00 0.00 94.47 10:22:38 AM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %gnice %idle 10:22:40 AM all 14.48 0.00 3.95 0.03 0.00 0.02 0.17 0.00 0.00 81.34 10:22:40 AM 0 1.01 0.00 1.52 0.00 0.00 0.00 0.00 0.00 0.00 97.47 10:22:40 AM 1 25.37 0.00 4.98 0.00 0.00 0.00 0.50 0.00 0.00 69.15 10:22:40 AM 2 4.52 0.00 1.51 0.00 0.00 0.00 0.00 0.00 0.00 93.97 10:22:40 AM 3 15.50 0.00 2.50 0.00 0.00 0.00 0.50 0.00 0.00 81.50 10:22:40 AM 4 35.00 0.00 5.00 0.00 0.00 0.00 0.50 0.00 0.00 59.50 10:22:40 AM 5 21.21 0.00 5.05 0.00 0.00 0.00 0.00 0.00 0.00 73.74 10:22:40 AM 6 28.64 0.00 5.03 0.00 0.00 0.00 0.00 0.00 0.00 66.33 10:22:40 AM 7 23.12 0.00 5.53 0.50 0.00 0.00 0.00 0.00 0.00 70.85 10:22:40 AM 8 20.50 0.00 2.00 0.00 0.00 0.00 0.50 0.00 0.00 77.00 10:22:40 AM 9 21.50 0.00 4.50 0.00 0.00 0.00 0.00 0.00 0.00 74.00 10:22:40 AM 10 4.04 0.00 1.52 0.00 0.00 0.00 0.00 0.00 0.00 94.44 10:22:40 AM 11 27.00 0.00 3.50 0.00 0.00 0.00 1.00 0.00 0.00 68.50 10:22:40 AM 12 20.20 0.00 5.05 0.00 0.00 0.00 0.00 0.00 0.00 74.75 10:22:40 AM 13 18.37 0.00 5.61 0.00 0.00 0.00 0.00 0.00 0.00 76.02 10:22:40 AM 14 7.07 0.00 5.05 0.00 0.00 0.00 0.00 0.00 0.00 87.88 10:22:40 AM 15 15.58 0.00 5.03 0.00 0.00 0.00 0.00 0.00 0.00 79.40 10:22:40 AM 16 24.12 0.00 5.53 0.00 0.00 0.00 0.00 0.00 0.00 70.35 10:22:40 AM 17 4.00 0.00 6.50 0.00 0.00 0.00 0.00 0.00 0.00 89.50 10:22:40 AM 18 34.85 0.00 4.55 0.00 0.00 0.00 0.51 0.00 0.00 60.10 10:22:40 AM 19 4.46 0.00 3.47 0.00 0.00 0.00 0.50 0.00 0.00 91.58 10:22:40 AM 20 5.00 0.00 3.00 0.00 0.00 0.50 0.50 0.00 0.00 91.00 10:22:40 AM 21 10.61 0.00 2.53 0.00 0.00 0.00 0.00 0.00 0.00 86.87 10:22:40 AM 22 8.59 0.00 6.06 0.00 0.00 0.00 0.51 0.00 0.00 84.85 10:22:40 AM 23 7.50 0.00 8.50 0.00 0.00 0.00 0.50 0.00 0.00 83.50 10:22:40 AM 24 16.34 0.00 7.92 0.00 0.00 0.00 0.99 0.00 0.00 74.75 10:22:40 AM 25 3.00 0.00 3.00 0.00 0.00 0.00 0.50 0.00 0.00 93.50 10:22:40 AM 26 1.49 0.00 1.49 0.00 0.00 0.00 0.00 0.00 0.00 97.01 10:22:40 AM 27 2.00 0.00 1.50 0.00 0.00 0.00 0.00 0.00 0.00 96.50 10:22:40 AM 28 5.47 0.00 2.49 0.00 0.00 0.00 0.00 0.00 0.00 92.04 10:22:40 AM 29 25.76 0.00 4.04 0.00 0.00 0.00 0.00 0.00 0.00 70.20 10:22:40 AM 30 20.10 0.00 3.52 0.00 0.00 0.00 0.00 0.00 0.00 76.38 10:22:40 AM 31 2.01 0.00 1.01 0.00 0.00 0.00 0.00 0.00 0.00 96.98 Average: CPU %usr %nice %sys %iowait %irq %soft %steal %guest %gnice %idle Average: all 13.30 0.00 3.73 0.04 0.00 0.02 0.12 0.00 0.00 82.79 Average: 0 1.26 0.00 1.26 0.25 0.00 0.00 0.00 0.00 0.00 97.24 Average: 1 17.25 0.00 3.50 0.25 0.00 0.00 0.25 0.00 0.00 78.75 Average: 2 4.02 0.00 2.51 0.00 0.00 0.00 0.00 0.00 0.00 93.47 Average: 3 9.50 0.00 2.00 0.00 0.00 0.00 0.25 0.00 0.00 88.25 Average: 4 31.08 0.00 6.02 0.00 0.00 0.00 0.25 0.00 0.00 62.66 Average: 5 11.56 0.00 3.27 0.00 0.00 0.00 0.00 0.00 0.00 85.18 Average: 6 18.64 0.00 3.78 0.00 0.00 0.00 0.00 0.00 0.00 77.58 Average: 7 25.19 0.00 6.55 0.25 0.00 0.00 0.00 0.00 0.00 68.01 Average: 8 25.00 0.00 3.25 0.50 0.00 0.00 0.25 0.00 0.00 71.00 Average: 9 14.11 0.00 3.27 0.00 0.00 0.00 0.00 0.00 0.00 82.62 Average: 10 9.05 0.00 2.26 0.00 0.00 0.00 0.00 0.00 0.00 88.69 Average: 11 26.07 0.00 4.26 0.00 0.00 0.00 0.50 0.00 0.00 69.17 Average: 12 17.68 0.00 4.80 0.00 0.00 0.00 0.25 0.00 0.00 77.27 Average: 13 12.91 0.00 4.05 0.00 0.00 0.00 0.00 0.00 0.00 83.04 Average: 14 4.79 0.00 4.03 0.00 0.00 0.00 0.00 0.00 0.00 91.18 Average: 15 25.44 0.00 5.29 0.00 0.00 0.00 0.00 0.00 0.00 69.27 Average: 16 21.11 0.00 5.28 0.00 0.00 0.00 0.00 0.00 0.00 73.62 Average: 17 5.51 0.00 5.51 0.00 0.00 0.00 0.00 0.00 0.00 88.97 Average: 18 27.20 0.00 5.04 0.00 0.00 0.00 0.25 0.00 0.00 67.51 Average: 19 2.99 0.00 2.99 0.00 0.00 0.00 0.25 0.00 0.00 93.77 Average: 20 15.33 0.00 3.52 0.00 0.00 0.75 0.25 0.00 0.00 80.15 Average: 21 9.30 0.00 3.52 0.00 0.00 0.00 0.00 0.00 0.00 87.19 Average: 22 6.80 0.00 5.54 0.00 0.00 0.00 0.25 0.00 0.00 87.41 Average: 23 13.00 0.00 6.50 0.00 0.00 0.00 0.25 0.00 0.00 80.25 Average: 24 20.00 0.00 7.00 0.00 0.00 0.00 0.50 0.00 0.00 72.50 Average: 25 4.26 0.00 2.51 0.00 0.00 0.00 0.25 0.00 0.00 92.98 Average: 26 3.75 0.00 1.25 0.00 0.00 0.00 0.00 0.00 0.00 95.00 Average: 27 3.51 0.00 1.75 0.00 0.00 0.00 0.00 0.00 0.00 94.74 Average: 28 3.51 0.00 2.01 0.00 0.00 0.00 0.00 0.00 0.00 94.49 Average: 29 20.80 0.00 4.26 0.00 0.00 0.00 0.25 0.00 0.00 74.69 Average: 30 11.78 0.00 1.75 0.00 0.00 0.00 0.00 0.00 0.00 86.47 Average: 31 3.02 0.00 1.26 0.00 0.00 0.00 0.00 0.00 0.00 95.73 top - 10:22:40 up 2 days, 18:55, 2 users, load average: 4.12, 4.34, 4.56 Tasks: 478 total, 7 running, 471 sleeping, 0 stopped, 0 zombie %Cpu(s): 11.1 us, 4.1 sy, 0.0 ni, 84.7 id, 0.0 wa, 0.0 hi, 0.0 si, 0.2 st KiB Mem : 61671400 total, 1119676 free, 4046688 used, 56505036 buff/cache KiB Swap: 8388604 total, 8381940 free, 6664 used. 57004320 avail Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 10776 mysql 20 0 3267056 346556 9672 S 164.7 0.6 1764:28 mysqld 1566 user 20 0 206364 17888 7804 S 35.3 0.0 0:00.06 php-cgi 1571 user 20 0 206364 17864 7776 S 23.5 0.0 0:00.04 php-cgi 1564 root 20 0 160456 2256 1432 R 11.8 0.0 0:00.03 top 1572 user 20 0 200268 9536 5208 R 11.8 0.0 0:00.02 php-cgi 27039 user 20 0 208836 8236 3864 S 11.8 0.0 0:06.98 httpd 828 nscd 20 0 1467608 2704 1392 S 5.9 0.0 5:44.66 nscd 1573 user 20 0 185400 9200 5000 R 5.9 0.0 0:00.01 php-cgi 1574 user 20 0 195944 9296 5064 R 5.9 0.0 0:00.01 php-cgi 1575 user 20 0 154360 8304 4424 R 5.9 0.0 0:00.01 php-cgi 21190 user 20 0 208840 8268 3884 S 5.9 0.0 0:07.25 httpd 1 root 20 0 191432 4304 2524 S 0.0 0.0 1:11.12 systemd 2 root 20 0 0 0 0 S 0.0 0.0 0:00.04 kthreadd 4 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/0:+ 6 root 20 0 0 0 0 S 0.0 0.0 0:00.50 ksoftirqd/0 7 root rt 0 0 0 0 S 0.0 0.0 0:02.31 migration/0 8 root 20 0 0 0 0 S 0.0 0.0 0:00.00 rcu_bh 9 root 20 0 0 0 0 S 0.0 0.0 4:26.78 rcu_sched 10 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 lru-add-dr+ 11 root rt 0 0 0 0 S 0.0 0.0 0:01.11 watchdog/0 12 root rt 0 0 0 0 S 0.0 0.0 0:00.90 watchdog/1 13 root rt 0 0 0 0 S 0.0 0.0 0:02.35 migration/1 14 root 20 0 0 0 0 S 0.0 0.0 0:00.46 ksoftirqd/1 16 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/1:+ 17 root rt 0 0 0 0 S 0.0 0.0 0:00.85 watchdog/2 18 root rt 0 0 0 0 S 0.0 0.0 0:03.12 migration/2 19 root 20 0 0 0 0 S 0.0 0.0 0:00.43 ksoftirqd/2 21 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/2:+ 22 root rt 0 0 0 0 S 0.0 0.0 0:00.81 watchdog/3 23 root rt 0 0 0 0 S 0.0 0.0 0:03.80 migration/3 24 root 20 0 0 0 0 S 0.0 0.0 0:00.42 ksoftirqd/3 26 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/3:+ 27 root rt 0 0 0 0 S 0.0 0.0 0:00.82 watchdog/4 28 root rt 0 0 0 0 S 0.0 0.0 0:03.74 migration/4 29 root 20 0 0 0 0 S 0.0 0.0 0:00.60 ksoftirqd/4 31 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/4:+ 32 root rt 0 0 0 0 S 0.0 0.0 0:00.79 watchdog/5 33 root rt 0 0 0 0 S 0.0 0.0 0:03.48 migration/5 34 root 20 0 0 0 0 S 0.0 0.0 0:00.64 ksoftirqd/5 36 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/5:+ 37 root rt 0 0 0 0 S 0.0 0.0 0:00.78 watchdog/6 38 root rt 0 0 0 0 S 0.0 0.0 0:03.15 migration/6 39 root 20 0 0 0 0 S 0.0 0.0 0:00.63 ksoftirqd/6 41 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/6:+ 42 root rt 0 0 0 0 S 0.0 0.0 0:00.78 watchdog/7 43 root rt 0 0 0 0 S 0.0 0.0 0:02.97 migration/7 44 root 20 0 0 0 0 S 0.0 0.0 0:00.56 ksoftirqd/7 46 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/7:+ 47 root rt 0 0 0 0 S 0.0 0.0 0:00.76 watchdog/8 48 root rt 0 0 0 0 S 0.0 0.0 0:02.89 migration/8 49 root 20 0 0 0 0 S 0.0 0.0 0:00.51 ksoftirqd/8 51 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/8:+ 52 root rt 0 0 0 0 S 0.0 0.0 0:00.78 watchdog/9 53 root rt 0 0 0 0 S 0.0 0.0 0:02.88 migration/9 54 root 20 0 0 0 0 S 0.0 0.0 0:00.48 ksoftirqd/9 56 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/9:+ 57 root rt 0 0 0 0 S 0.0 0.0 0:00.78 watchdog/10 58 root rt 0 0 0 0 S 0.0 0.0 0:02.80 migration/+ 59 root 20 0 0 0 0 S 0.0 0.0 0:00.46 ksoftirqd/+ 61 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/10+ 62 root rt 0 0 0 0 S 0.0 0.0 0:00.77 watchdog/11 63 root rt 0 0 0 0 S 0.0 0.0 0:02.66 migration/+ 64 root 20 0 0 0 0 S 0.0 0.0 0:00.45 ksoftirqd/+ 66 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/11+ 67 root rt 0 0 0 0 S 0.0 0.0 0:00.77 watchdog/12 68 root rt 0 0 0 0 S 0.0 0.0 0:02.66 migration/+ 69 root 20 0 0 0 0 S 0.0 0.0 0:00.44 ksoftirqd/+ 71 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/12+ 72 root rt 0 0 0 0 S 0.0 0.0 0:00.78 watchdog/13 73 root rt 0 0 0 0 S 0.0 0.0 0:02.60 migration/+ 74 root 20 0 0 0 0 S 0.0 0.0 0:00.43 ksoftirqd/+ 76 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/13+ 77 root rt 0 0 0 0 S 0.0 0.0 0:00.76 watchdog/14 78 root rt 0 0 0 0 S 0.0 0.0 0:02.61 migration/+ 79 root 20 0 0 0 0 S 0.0 0.0 0:00.42 ksoftirqd/+ 80 root 20 0 0 0 0 S 0.0 0.0 0:00.64 kworker/14+ 81 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/14+ 82 root rt 0 0 0 0 S 0.0 0.0 0:00.78 watchdog/15 83 root rt 0 0 0 0 S 0.0 0.0 0:02.54 migration/+ 84 root 20 0 0 0 0 S 0.0 0.0 0:00.42 ksoftirqd/+ 86 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/15+ 87 root rt 0 0 0 0 S 0.0 0.0 0:00.81 watchdog/16 88 root rt 0 0 0 0 S 0.0 0.0 0:02.48 migration/+ 89 root 20 0 0 0 0 S 0.0 0.0 0:00.43 ksoftirqd/+ 90 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/16+ 91 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/16+ 92 root rt 0 0 0 0 S 0.0 0.0 0:00.77 watchdog/17 93 root rt 0 0 0 0 S 0.0 0.0 0:02.51 migration/+ 94 root 20 0 0 0 0 S 0.0 0.0 0:00.40 ksoftirqd/+ 95 root 20 0 0 0 0 S 0.0 0.0 0:00.53 kworker/17+ 96 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/17+ 97 root rt 0 0 0 0 S 0.0 0.0 0:00.78 watchdog/18 98 root rt 0 0 0 0 S 0.0 0.0 0:02.46 migration/+ 99 root 20 0 0 0 0 S 0.0 0.0 0:00.39 ksoftirqd/+ 101 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/18+ 102 root rt 0 0 0 0 S 0.0 0.0 0:00.78 watchdog/19 103 root rt 0 0 0 0 S 0.0 0.0 0:02.31 migration/+ 104 root 20 0 0 0 0 S 0.0 0.0 0:00.39 ksoftirqd/+ 106 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/19+ 107 root rt 0 0 0 0 S 0.0 0.0 0:00.91 watchdog/20 108 root rt 0 0 0 0 S 0.0 0.0 0:02.45 migration/+ 109 root 20 0 0 0 0 S 0.0 0.0 0:11.11 ksoftirqd/+ 111 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/20+ 112 root rt 0 0 0 0 S 0.0 0.0 0:00.80 watchdog/21 113 root rt 0 0 0 0 S 0.0 0.0 0:06.20 migration/+ 114 root 20 0 0 0 0 S 0.0 0.0 0:00.41 ksoftirqd/+ 116 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/21+ 117 root rt 0 0 0 0 S 0.0 0.0 0:00.80 watchdog/22 118 root rt 0 0 0 0 S 0.0 0.0 0:06.03 migration/+ 119 root 20 0 0 0 0 S 0.0 0.0 0:00.42 ksoftirqd/+ 121 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/22+ 122 root rt 0 0 0 0 S 0.0 0.0 0:00.81 watchdog/23 123 root rt 0 0 0 0 S 0.0 0.0 0:03.28 migration/+ 124 root 20 0 0 0 0 S 0.0 0.0 0:01.27 ksoftirqd/+ 126 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/23+ 127 root rt 0 0 0 0 S 0.0 0.0 0:00.78 watchdog/24 128 root rt 0 0 0 0 S 0.0 0.0 0:02.65 migration/+ 129 root 20 0 0 0 0 S 0.0 0.0 0:00.78 ksoftirqd/+ 131 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/24+ 132 root rt 0 0 0 0 S 0.0 0.0 0:00.79 watchdog/25 133 root rt 0 0 0 0 S 0.0 0.0 0:02.29 migration/+ 134 root 20 0 0 0 0 S 0.0 0.0 0:00.61 ksoftirqd/+ 136 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/25+ 137 root rt 0 0 0 0 S 0.0 0.0 0:00.77 watchdog/26 138 root rt 0 0 0 0 S 0.0 0.0 0:02.16 migration/+ 139 root 20 0 0 0 0 S 0.0 0.0 0:00.45 ksoftirqd/+ 141 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/26+ 142 root rt 0 0 0 0 S 0.0 0.0 0:00.77 watchdog/27 143 root rt 0 0 0 0 S 0.0 0.0 0:02.29 migration/+ 144 root 20 0 0 0 0 S 0.0 0.0 0:00.41 ksoftirqd/+ 146 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/27+ 147 root rt 0 0 0 0 S 0.0 0.0 0:00.77 watchdog/28 148 root rt 0 0 0 0 S 0.0 0.0 0:02.31 migration/+ 149 root 20 0 0 0 0 S 0.0 0.0 0:00.35 ksoftirqd/+ 150 root 20 0 0 0 0 S 0.0 0.0 0:00.60 kworker/28+ 151 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/28+ 152 root rt 0 0 0 0 S 0.0 0.0 0:00.77 watchdog/29 153 root rt 0 0 0 0 S 0.0 0.0 0:02.26 migration/+ 154 root 20 0 0 0 0 S 0.0 0.0 0:00.35 ksoftirqd/+ 156 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/29+ 157 root rt 0 0 0 0 S 0.0 0.0 0:00.78 watchdog/30 158 root rt 0 0 0 0 S 0.0 0.0 0:02.21 migration/+ 159 root 20 0 0 0 0 S 0.0 0.0 0:00.34 ksoftirqd/+ 161 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/30+ 162 root rt 0 0 0 0 S 0.0 0.0 0:00.79 watchdog/31 163 root rt 0 0 0 0 S 0.0 0.0 0:02.10 migration/+ 164 root 20 0 0 0 0 S 0.0 0.0 0:00.36 ksoftirqd/+ 166 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kworker/31+ 168 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kdevtmpfs 169 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 netns 170 root 20 0 0 0 0 S 0.0 0.0 0:00.18 khungtaskd 171 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 writeback 172 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kintegrityd 173 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 174 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 175 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 bioset 176 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kblockd 177 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 md 178 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 edac-poller 179 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 watchdogd 182 root 20 0 0 0 0 S 0.0 0.0 0:02.58 kswapd0 183 root 25 5 0 0 0 S 0.0 0.0 0:00.00 ksmd 184 root 39 19 0 0 0 S 0.0 0.0 0:03.53 khugepaged 185 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 crypto 193 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kthrotld 195 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kmpath_rda+ 196 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kaluad 198 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 kpsmoused 200 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ipv6_addrc+ 214 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 deferwq 215 root 20 0 0 0 0 S 0.0 0.0 0:00.73 kworker/6:1 254 root 20 0 0 0 0 S 0.0 0.0 0:03.83 kauditd 412 root 20 0 0 0 0 S 0.0 0.0 0:00.65 kworker/13+ 424 root 20 0 0 0 0 S 0.0 0.0 0:00.65 kworker/12+ 425 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ata_sff 426 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0 427 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 scsi_tmf_0 428 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1 429 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 scsi_tmf_1 433 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ttm_swap 435 root 20 0 0 0 0 S 0.0 0.0 0:00.45 kworker/27+ 436 root 0 -20 0 0 0 S 0.0 0.0 0:00.30 kworker/27+ 443 root 0 -20 0 0 0 S 0.0 0.0 0:00.65 kworker/3:+ 455 root 0 -20 0 0 0 S 0.0 0.0 0:00.30 kworker/14+ 457 root 20 0 0 0 0 S 0.0 0.0 0:26.31 jbd2/vda1-8 458 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-rsv-c+ 464 root 0 -20 0 0 0 S 0.0 0.0 0:00.19 kworker/15+ 522 root 0 -20 0 0 0 S 0.0 0.0 0:00.16 kworker/26+ 527 root 0 -20 0 0 0 S 0.0 0.0 0:00.34 kworker/12+ 530 root 0 -20 0 0 0 S 0.0 0.0 0:00.25 kworker/13+ 537 root 0 -20 0 0 0 S 0.0 0.0 0:00.46 kworker/16+ 543 root 0 -20 0 0 0 S 0.0 0.0 0:00.27 kworker/17+ 545 root 0 -20 0 0 0 S 0.0 0.0 0:00.38 kworker/5:+ 546 root 20 0 47252 12388 12072 S 0.0 0.0 0:45.48 systemd-jo+ 548 root 0 -20 0 0 0 S 0.0 0.0 0:00.41 kworker/6:+ 551 root 0 -20 0 0 0 S 0.0 0.0 0:00.35 kworker/8:+ 555 root 0 -20 0 0 0 S 0.0 0.0 0:00.35 kworker/7:+ 566 root 0 -20 0 0 0 S 0.0 0.0 0:00.37 kworker/9:+ 580 root 0 -20 0 0 0 S 0.0 0.0 0:00.30 kworker/10+ 587 root 20 0 45864 2244 1244 S 0.0 0.0 0:00.24 systemd-ud+ 589 root 0 -20 0 0 0 S 0.0 0.0 0:00.46 kworker/4:+ 612 root 16 -4 55532 1068 616 S 0.0 0.0 0:10.46 auditd 615 root 20 0 0 0 0 S 0.0 0.0 0:00.65 kworker/18+ 616 root 20 0 0 0 0 S 0.0 0.0 0:00.58 kworker/30+ 617 root 20 0 0 0 0 S 0.0 0.0 0:00.62 kworker/29+ 755 root 0 -20 0 0 0 S 0.0 0.0 0:00.25 kworker/11+ 814 root 20 0 24472 1624 1316 S 0.0 0.0 0:05.69 systemd-lo+ 819 root 20 0 21640 1280 960 S 0.0 0.0 0:19.93 irqbalance 821 root 0 -20 0 0 0 S 0.0 0.0 0:00.29 kworker/23+ 823 polkitd 20 0 610660 12156 4664 S 0.0 0.0 0:04.71 polkitd 825 root 0 -20 0 0 0 S 0.0 0.0 0:00.21 kworker/30+ 835 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/6:0 843 root 0 -20 0 0 0 S 0.0 0.0 0:00.22 kworker/29+ 844 rpc 20 0 69256 1216 660 S 0.0 0.0 0:00.46 rpcbind 845 root 0 -20 0 0 0 S 0.0 0.0 0:00.26 kworker/19+ 846 root 20 0 52852 2664 1848 S 0.0 0.0 0:00.05 smartd 847 dbus 20 0 56412 2312 1708 S 0.0 0.0 0:10.50 dbus-daemon 851 root 0 -20 0 0 0 S 0.0 0.0 0:00.42 kworker/22+ 872 chrony 20 0 94568 1288 968 S 0.0 0.0 0:00.63 chronyd 883 root 0 -20 0 0 0 S 0.0 0.0 0:01.37 kworker/0:+ 884 root 0 -20 0 0 0 S 0.0 0.0 0:00.33 kworker/31+ 892 root 0 -20 0 0 0 S 0.0 0.0 0:00.92 kworker/20+ 900 root 0 -20 0 0 0 S 0.0 0.0 0:00.56 kworker/21+ 904 root 20 0 124476 1520 904 S 0.0 0.0 0:01.10 crond 905 root 20 0 24208 976 784 S 0.0 0.0 0:00.00 atd 914 root 0 -20 0 0 0 S 0.0 0.0 0:00.80 kworker/2:+ 918 root 20 0 108296 756 640 S 0.0 0.0 0:00.00 agetty 930 root 0 -20 0 0 0 S 0.0 0.0 0:00.21 kworker/24+ 938 root 0 -20 0 0 0 S 0.0 0.0 0:01.25 kworker/1:+ 967 root 0 -20 0 0 0 S 0.0 0.0 0:00.22 kworker/18+ 1024 root 20 0 45728 10780 3792 S 0.0 0.0 0:17.61 queueprocd+ 1031 root 0 -20 0 0 0 S 0.0 0.0 0:06.55 loop0 1036 root 20 0 113816 2000 1244 S 0.0 0.0 0:00.02 mysqlmymon+ 1039 root 20 0 0 0 0 S 0.0 0.0 0:01.46 jbd2/loop0+ 1040 root 0 -20 0 0 0 S 0.0 0.0 0:00.00 ext4-rsv-c+ 1157 root 20 0 572376 19220 5864 S 0.0 0.0 0:33.77 tuned 1160 named 20 0 659912 12372 4664 S 0.0 0.0 0:25.25 pdns_server 1169 root 20 0 270956 9228 7340 S 0.0 0.0 0:32.14 rsyslogd 1191 root 0 -20 0 0 0 S 0.0 0.0 0:00.25 kworker/28+ 1196 root 0 -20 0 0 0 S 0.0 0.0 0:00.26 kworker/25+ 1449 root 20 0 119540 27448 7000 S 0.0 0.0 1:14.85 cpsrvd (SS+ 1458 root 38 18 26300 2748 1648 S 0.0 0.0 0:01.22 cpanellogd+ 1485 root 20 0 129452 2772 2012 S 0.0 0.0 0:06.78 dnsadmin -+ 1505 root 20 0 67392 18832 3676 S 0.0 0.0 0:04.94 tailwatchd 1521 root 20 0 129984 3312 2236 S 0.0 0.0 0:02.15 cpdavd - a+ 1569 root 20 0 1426504 1.1g 1608 S 0.0 1.9 1:12.90 clamd 1576 user 20 0 132416 7960 4228 R 0.0 0.0 0:00.00 php-cgi 1577 user 20 0 76792 3552 2680 R 0.0 0.0 0:00.00 php-cgi 1987 nobody 20 0 208628 8144 3888 S 0.0 0.0 0:09.09 httpd 2318 nobody 20 0 208752 8396 4036 S 0.0 0.0 0:08.85 httpd 2386 root 20 0 0 0 0 S 0.0 0.0 0:00.61 kworker/11+ 3055 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/3:1 3619 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/u1+ 5071 root 20 0 0 0 0 S 0.0 0.0 0:00.19 kworker/5:2 5591 nobody 20 0 208740 8472 4124 S 0.0 0.0 0:07.22 httpd 5674 nobody 20 0 208772 8360 4028 S 0.0 0.0 0:08.54 httpd 5993 root 20 0 249436 6596 1072 S 0.0 0.0 0:10.98 cpanel_php+ 6130 nobody 20 0 208612 8436 4188 S 0.0 0.0 0:06.16 httpd 7277 root 20 0 15144 1860 1408 S 0.0 0.0 0:00.91 dovecot 7281 dovecot 20 0 10172 1212 1028 S 0.0 0.0 0:00.16 anvil 7288 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/8:0 7314 mailnull 20 0 80620 5620 1196 S 0.0 0.0 0:00.33 exim 7428 root 20 0 0 0 0 S 0.0 0.0 0:00.08 kworker/15+ 8029 dovenull 20 0 46848 4548 3448 S 0.0 0.0 0:00.22 pop3-login 8030 dovenull 20 0 46752 4432 3408 S 0.0 0.0 0:00.13 imap-login 8031 root 20 0 10304 1408 1048 S 0.0 0.0 0:00.32 log 8032 dovenull 20 0 46736 4432 3400 S 0.0 0.0 0:00.13 pop3-login 8033 dovenull 20 0 46896 4440 3412 S 0.0 0.0 0:00.25 imap-login 8034 root 20 0 12448 3140 1304 S 0.0 0.0 0:01.12 config 8035 dovecot 20 0 44340 2736 2144 S 0.0 0.0 0:00.47 stats 8039 nobody 20 0 208760 8252 3880 S 0.0 0.0 0:06.25 httpd 8151 nobody 20 0 208768 8196 3884 S 0.0 0.0 0:08.55 httpd 8152 nobody 20 0 208732 8160 3884 S 0.0 0.0 0:06.64 httpd 8289 nobody 20 0 208724 8144 3880 S 0.0 0.0 0:07.55 httpd 8389 user 20 0 208752 8188 3888 S 0.0 0.0 0:08.31 httpd 8390 nobody 20 0 208768 8236 3884 S 0.0 0.0 0:07.26 httpd 9202 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/12+ 9230 root 20 0 0 0 0 S 0.0 0.0 0:00.06 kworker/17+ 9739 root 20 0 0 0 0 S 0.0 0.0 0:00.20 kworker/23+ 9997 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/15+ 10033 root 20 0 207284 6212 2892 S 0.0 0.0 0:05.77 httpd 10034 root 20 0 12732 1348 1164 S 0.0 0.0 0:18.11 splitlogs 10035 root 20 0 12740 1352 1164 S 0.0 0.0 0:23.80 splitlogs 10036 root 20 0 53548 12244 2360 S 0.0 0.0 0:00.08 leechprote+ 10679 root 20 0 248824 128200 5444 S 0.0 0.2 0:13.21 spamd 10831 root 20 0 0 0 0 S 0.0 0.0 0:00.74 kworker/3:0 10892 root 20 0 111448 4220 3208 S 0.0 0.0 0:05.87 sshd 10917 nobody 20 0 208748 8460 4120 S 0.0 0.0 0:04.97 httpd 11903 nobody 20 0 208772 8244 3876 S 0.0 0.0 0:07.44 httpd 11962 nobody 20 0 208704 8404 4120 S 0.0 0.0 0:06.67 httpd 12952 root 20 0 249784 125644 1828 S 0.0 0.2 0:06.75 spamd child 12953 root 20 0 248692 124060 1352 S 0.0 0.2 0:00.05 spamd child 13099 root 20 0 151428 10664 3184 S 0.0 0.0 0:00.82 cPhulkd - + 13584 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/2:1 13590 nobody 20 0 208748 8404 4116 S 0.0 0.0 0:05.35 httpd 13668 nobody 20 0 208756 8232 3880 S 0.0 0.0 0:06.96 httpd 13669 nobody 20 0 208732 8612 4272 S 0.0 0.0 0:08.43 httpd 13670 nobody 20 0 208764 8488 4120 S 0.0 0.0 0:05.28 httpd 13673 nobody 20 0 208784 8376 4032 S 0.0 0.0 0:07.28 httpd 13674 nobody 20 0 208760 8184 3884 S 0.0 0.0 0:07.16 httpd 13675 nobody 20 0 208764 8212 3880 S 0.0 0.0 0:06.58 httpd 13759 nobody 20 0 208708 8148 3884 S 0.0 0.0 0:07.00 httpd 13761 user 20 0 208748 8184 3884 S 0.0 0.0 0:06.87 httpd 13768 nobody 20 0 208756 8252 3880 S 0.0 0.0 0:07.63 httpd 13774 nobody 20 0 208756 8484 4120 S 0.0 0.0 0:07.49 httpd 15464 root 20 0 0 0 0 S 0.0 0.0 0:00.59 kworker/1:0 15740 nobody 20 0 208772 8296 3884 S 0.0 0.0 0:08.51 httpd 16134 root 20 0 0 0 0 S 0.0 0.0 0:00.58 kworker/25+ 16413 nobody 20 0 208644 8316 4032 S 0.0 0.0 0:07.68 httpd 16747 root 20 0 0 0 0 S 0.0 0.0 0:01.22 kworker/20+ 16883 root 20 0 0 0 0 S 0.0 0.0 0:00.12 kworker/27+ 17190 nobody 20 0 208752 8240 3928 S 0.0 0.0 0:05.10 httpd 17314 nobody 20 0 208724 8144 3880 S 0.0 0.0 0:07.70 httpd 17319 nobody 20 0 208804 8492 4120 S 0.0 0.0 0:07.06 httpd 17901 nobody 20 0 208768 8260 3880 S 0.0 0.0 0:09.22 httpd 17917 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/10+ 19000 nobody 20 0 208884 8252 3880 S 0.0 0.0 0:06.85 httpd 19109 root 20 0 0 0 0 S 0.0 0.0 0:00.50 kworker/23+ 20258 nobody 20 0 208712 8224 3880 S 0.0 0.0 0:08.50 httpd 20307 nobody 20 0 208780 8372 4032 S 0.0 0.0 0:06.79 httpd 20308 nobody 20 0 208740 8480 4124 S 0.0 0.0 0:08.34 httpd 20774 nobody 20 0 208780 8232 3884 S 0.0 0.0 0:06.02 httpd 20850 nobody 20 0 208772 8456 4120 S 0.0 0.0 0:07.31 httpd 20887 nobody 20 0 208756 8252 3884 S 0.0 0.0 0:07.27 httpd 20890 nobody 20 0 208772 8432 4032 S 0.0 0.0 0:08.39 httpd 20941 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/1:1 20966 nobody 20 0 208772 8264 3876 S 0.0 0.0 0:07.05 httpd 21061 nobody 20 0 208772 8416 4032 S 0.0 0.0 0:08.58 httpd 21062 nobody 20 0 208720 8148 3888 S 0.0 0.0 0:05.01 httpd 21063 nobody 20 0 208756 8344 4032 S 0.0 0.0 0:07.48 httpd 21065 nobody 20 0 208736 8160 3884 S 0.0 0.0 0:05.73 httpd 21067 nobody 20 0 208740 8420 4124 S 0.0 0.0 0:07.38 httpd 21070 nobody 20 0 208740 8216 3880 S 0.0 0.0 0:06.47 httpd 21071 nobody 20 0 208752 8252 3888 S 0.0 0.0 0:07.14 httpd 21072 nobody 20 0 208644 8304 4032 S 0.0 0.0 0:06.37 httpd 21076 nobody 20 0 208776 8264 3888 S 0.0 0.0 0:07.17 httpd 21193 nobody 20 0 208716 8388 4128 S 0.0 0.0 0:06.77 httpd 21195 nobody 20 0 208756 8392 4032 S 0.0 0.0 0:05.16 httpd 21196 nobody 20 0 208768 8276 3888 S 0.0 0.0 0:07.69 httpd 21202 nobody 20 0 208768 8608 4312 S 0.0 0.0 0:09.43 httpd 21203 nobody 20 0 208844 8660 4272 S 0.0 0.0 0:07.62 httpd 21207 nobody 20 0 208756 8268 3904 S 0.0 0.0 0:07.94 httpd 21695 root 20 0 0 0 0 S 0.0 0.0 0:00.13 kworker/7:0 23337 root 20 0 0 0 0 S 0.0 0.0 0:02.27 kworker/26+ 23735 root 20 0 0 0 0 S 0.0 0.0 0:00.15 kworker/21+ 23996 user 20 0 208712 8136 3884 S 0.0 0.0 0:05.52 httpd 24117 nobody 20 0 208764 8280 3884 S 0.0 0.0 0:07.59 httpd 24118 nobody 20 0 208772 8208 3876 S 0.0 0.0 0:05.69 httpd 24183 nobody 20 0 208832 8260 3884 S 0.0 0.0 0:07.32 httpd 24184 nobody 20 0 208612 8116 3884 S 0.0 0.0 0:06.82 httpd 24235 nobody 20 0 208732 8312 4036 S 0.0 0.0 0:06.73 httpd 24236 nobody 20 0 208872 8436 4032 S 0.0 0.0 0:07.95 httpd 24238 nobody 20 0 208780 8244 3884 S 0.0 0.0 0:07.61 httpd 24241 nobody 20 0 208764 8420 4036 S 0.0 0.0 0:08.20 httpd 24443 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/9:2 24949 nobody 20 0 208760 8332 4032 S 0.0 0.0 0:06.61 httpd 25049 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/26+ 25054 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/4:1 25416 nobody 20 0 208700 8340 4036 S 0.0 0.0 0:08.96 httpd 25580 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/24+ 25733 root 20 0 0 0 0 S 0.0 0.0 0:00.60 kworker/4:2 25784 user 20 0 208772 8204 3884 S 0.0 0.0 0:06.86 httpd 26823 nobody 20 0 208644 8140 3884 S 0.0 0.0 0:07.52 httpd 26824 nobody 20 0 208752 8228 3880 S 0.0 0.0 0:06.75 httpd 26893 nobody 20 0 208724 8300 4032 S 0.0 0.0 0:05.86 httpd 26895 nobody 20 0 208636 8144 3884 S 0.0 0.0 0:06.45 httpd 26965 nobody 20 0 208784 8220 3880 S 0.0 0.0 0:06.37 httpd 26967 nobody 20 0 208752 8220 3880 S 0.0 0.0 0:05.71 httpd 26968 nobody 20 0 208768 8256 3904 S 0.0 0.0 0:07.24 httpd 26969 nobody 20 0 208648 8348 4104 S 0.0 0.0 0:06.68 httpd 26970 nobody 20 0 208740 8232 3876 S 0.0 0.0 0:05.96 httpd 26971 nobody 20 0 208648 8156 3880 S 0.0 0.0 0:06.78 httpd 26972 nobody 20 0 208832 8416 4032 S 0.0 0.0 0:07.18 httpd 27033 nobody 20 0 208760 8424 4048 S 0.0 0.0 0:06.88 httpd 27034 nobody 20 0 208708 8372 4120 S 0.0 0.0 0:06.85 httpd 27035 nobody 20 0 208620 8108 3884 S 0.0 0.0 0:06.93 httpd 27037 nobody 20 0 208768 8304 3952 S 0.0 0.0 0:07.25 httpd 27038 user 20 0 208760 8268 3892 S 0.0 0.0 0:07.43 httpd 27040 nobody 20 0 208696 8128 3888 S 0.0 0.0 0:08.43 httpd 27041 nobody 20 0 208808 8252 3884 S 0.0 0.0 0:07.09 httpd 27043 nobody 20 0 208908 8348 3900 S 0.0 0.0 0:07.01 httpd 27044 nobody 20 0 208748 8172 3888 S 0.0 0.0 0:04.30 httpd 27045 nobody 20 0 208768 8264 3888 S 0.0 0.0 0:07.24 httpd 27046 nobody 20 0 208772 8228 3912 S 0.0 0.0 0:06.27 httpd 27047 nobody 20 0 208764 8220 3888 S 0.0 0.0 0:07.24 httpd 27048 nobody 20 0 208728 8188 3884 S 0.0 0.0 0:07.07 httpd 27515 root 20 0 162296 5964 4540 S 0.0 0.0 0:00.44 sshd 27609 root 20 0 113636 1988 1564 S 0.0 0.0 0:00.14 bash 27913 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/22+ 29019 nobody 20 0 208836 8272 3884 S 0.0 0.0 0:06.69 httpd 29126 nobody 20 0 208636 8152 3880 S 0.0 0.0 0:06.70 httpd 29215 nobody 20 0 208628 8112 3884 S 0.0 0.0 0:04.82 httpd 29216 nobody 20 0 208752 8180 3884 S 0.0 0.0 0:06.78 httpd 29217 nobody 20 0 208740 8404 4120 S 0.0 0.0 0:05.31 httpd 29218 nobody 20 0 208768 8404 4032 S 0.0 0.0 0:04.85 httpd 29308 root 20 0 0 0 0 S 0.0 0.0 0:00.14 kworker/2:2 29315 nobody 20 0 208768 8460 4116 S 0.0 0.0 0:07.79 httpd 29317 nobody 20 0 208628 8260 4032 S 0.0 0.0 0:07.86 httpd 29318 nobody 20 0 208772 8224 3876 S 0.0 0.0 0:08.60 httpd 29319 nobody 20 0 208768 8248 3880 S 0.0 0.0 0:06.59 httpd 29321 nobody 20 0 208784 8504 4116 S 0.0 0.0 0:06.59 httpd 29525 root 20 0 0 0 0 S 0.0 0.0 0:00.61 kworker/31+ 29837 root 20 0 162296 5956 4540 S 0.0 0.0 0:00.36 sshd 29991 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/18+ 30165 root 20 0 113632 1964 1556 S 0.0 0.0 0:00.04 bash 30456 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/11+ 30951 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/14+ 31270 nobody 20 0 208764 8256 3888 S 0.0 0.0 0:07.50 httpd 31405 root 20 0 0 0 0 S 0.0 0.0 0:00.15 kworker/16+ 31584 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/5:0 31709 nobody 20 0 208752 8468 4120 S 0.0 0.0 0:05.68 httpd 33230 nobody 20 0 208772 8260 3880 S 0.0 0.0 0:08.73 httpd 33242 nobody 20 0 208768 8440 4120 S 0.0 0.0 0:07.81 httpd 33619 root 20 0 0 0 0 S 0.0 0.0 0:00.11 kworker/9:0 33789 nobody 20 0 208752 8536 4212 S 0.0 0.0 0:06.79 httpd 33850 nobody 20 0 208736 8416 4120 S 0.0 0.0 0:08.41 httpd 33851 nobody 20 0 208760 8176 3888 S 0.0 0.0 0:08.26 httpd 33923 nobody 20 0 208748 8216 3888 S 0.0 0.0 0:08.08 httpd 33924 nobody 20 0 208648 8108 3884 S 0.0 0.0 0:07.16 httpd 33925 nobody 20 0 208736 8236 3880 S 0.0 0.0 0:07.25 httpd 33927 nobody 20 0 208692 8212 3884 S 0.0 0.0 0:06.73 httpd 33991 nobody 20 0 208744 8256 3884 S 0.0 0.0 0:06.75 httpd 33992 nobody 20 0 208756 8376 4032 S 0.0 0.0 0:07.65 httpd 33993 nobody 20 0 208768 8596 4268 S 0.0 0.0 0:08.12 httpd 33994 nobody 20 0 208740 8200 3884 S 0.0 0.0 0:06.76 httpd 33995 nobody 20 0 208772 8244 3884 S 0.0 0.0 0:07.24 httpd 33996 nobody 20 0 208740 8248 3884 S 0.0 0.0 0:06.41 httpd 33997 nobody 20 0 208636 8152 3880 S 0.0 0.0 0:04.96 httpd 33998 nobody 20 0 208780 8204 3880 S 0.0 0.0 0:06.30 httpd 34055 nobody 20 0 208636 8116 3884 S 0.0 0.0 0:05.90 httpd 34057 nobody 20 0 208776 8256 3880 S 0.0 0.0 0:08.44 httpd 34058 nobody 20 0 208768 8360 4036 S 0.0 0.0 0:07.36 httpd 34059 user 20 0 208700 8288 4032 S 0.0 0.0 0:05.94 httpd 34060 nobody 20 0 208756 8192 3884 S 0.0 0.0 0:05.70 httpd 34061 nobody 20 0 208764 8228 3888 S 0.0 0.0 0:07.05 httpd 34062 nobody 20 0 208764 8492 4128 S 0.0 0.0 0:06.67 httpd 34063 nobody 20 0 208768 8248 3884 S 0.0 0.0 0:06.26 httpd 34064 nobody 20 0 208876 8524 4124 S 0.0 0.0 0:07.56 httpd 34066 nobody 20 0 208776 8212 3880 S 0.0 0.0 0:06.93 httpd 34067 nobody 20 0 208768 8456 4108 S 0.0 0.0 0:04.78 httpd 34068 nobody 20 0 208724 8388 4124 S 0.0 0.0 0:04.92 httpd 34069 nobody 20 0 208636 8104 3888 S 0.0 0.0 0:07.47 httpd 34070 nobody 20 0 208768 8280 3892 S 0.0 0.0 0:06.21 httpd 34072 nobody 20 0 208776 8264 3892 S 0.0 0.0 0:07.13 httpd 34229 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/31+ 34269 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/20+ 34388 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/30+ 34436 nobody 20 0 208764 8244 3884 S 0.0 0.0 0:05.74 httpd 34514 nobody 20 0 208732 8308 4032 S 0.0 0.0 0:07.18 httpd 34515 nobody 20 0 208772 8244 3880 S 0.0 0.0 0:05.58 httpd 34654 root 20 0 0 0 0 S 0.0 0.0 0:00.64 kworker/24+ 36008 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/25+ 36406 root 20 0 0 0 0 S 0.0 0.0 0:00.01 kworker/0:0 36516 nobody 20 0 208700 8128 3884 S 0.0 0.0 0:06.38 httpd 36826 nobody 20 0 208676 8164 3884 S 0.0 0.0 0:07.83 httpd 38198 root 20 0 0 0 0 S 0.0 0.0 0:00.73 kworker/22+ 38695 root 20 0 0 0 0 S 0.0 0.0 0:00.65 kworker/10+ 40513 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/19+ 43066 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/21+ 44819 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/29+ 45213 nobody 20 0 208760 8576 4272 S 0.0 0.0 0:08.24 httpd 45341 root 20 0 152412 12316 3292 S 0.0 0.0 0:18.12 cPhulkd - + 46826 nobody 20 0 208724 8152 3884 S 0.0 0.0 0:08.40 httpd 47451 root 20 0 0 0 0 S 0.0 0.0 0:18.28 kworker/0:2 47481 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/28+ 47717 nobody 20 0 208740 8236 3880 S 0.0 0.0 0:06.39 httpd 48615 nobody 20 0 208636 8316 4036 S 0.0 0.0 0:08.86 httpd 48693 nobody 20 0 208628 8536 4284 S 0.0 0.0 0:09.59 httpd 50070 root 20 0 0 0 0 S 0.0 0.0 0:00.13 kworker/19+ 50419 nobody 20 0 208756 8424 4124 S 0.0 0.0 0:07.57 httpd 51790 dovecot 20 0 70780 4196 3144 S 0.0 0.0 0:00.02 auth 52262 root 20 0 0 0 0 S 0.0 0.0 0:00.69 kworker/u1+ 52700 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/0:1 53162 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/13+ 54036 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/u1+ 54794 root 20 0 0 0 0 S 0.0 0.0 0:00.00 kworker/7:2 56108 root 20 0 0 0 0 S 0.0 0.0 0:00.66 kworker/8:1 56584 nobody 20 0 208736 8252 3884 S 0.0 0.0 0:07.75 httpd total used free shared buff/cache available Mem: 60225 3969 1075 102 55180 55650 Low: 60225 59150 1075 High: 0 0 0 Swap: 8191 6 8185 MemTotal: 61671400 kB MemFree: 1099996 kB MemAvailable: 56984144 kB Buffers: 484860 kB Cached: 53686520 kB SwapCached: 48 kB Active: 29620540 kB Inactive: 26609924 kB Active(anon): 2059304 kB Inactive(anon): 104460 kB Active(file): 27561236 kB Inactive(file): 26505464 kB Unevictable: 0 kB Mlocked: 0 kB SwapTotal: 8388604 kB SwapFree: 8381940 kB Dirty: 304 kB Writeback: 0 kB AnonPages: 2050900 kB Mapped: 62612 kB Shmem: 104680 kB Slab: 2479100 kB SReclaimable: 2333656 kB SUnreclaim: 145444 kB KernelStack: 9776 kB PageTables: 74752 kB NFS_Unstable: 0 kB Bounce: 0 kB WritebackTmp: 0 kB CommitLimit: 39224304 kB Committed_AS: 3270664 kB VmallocTotal: 34359738367 kB VmallocUsed: 128628 kB VmallocChunk: 34359555792 kB Percpu: 10976 kB HardwareCorrupted: 0 kB AnonHugePages: 1501184 kB CmaTotal: 0 kB CmaFree: 0 kB HugePages_Total: 0 HugePages_Free: 0 HugePages_Rsvd: 0 HugePages_Surp: 0 Hugepagesize: 2048 kB DirectMap4k: 272232 kB DirectMap2M: 62642176 kB Private + Shared = RAM used Program 160.0 KiB + 20.5 KiB = 180.5 KiB agetty 216.0 KiB + 41.5 KiB = 257.5 KiB atd 216.0 KiB + 76.5 KiB = 292.5 KiB anvil 396.0 KiB + 73.5 KiB = 469.5 KiB log 380.0 KiB + 92.0 KiB = 472.0 KiB irqbalance 532.0 KiB + 55.5 KiB = 587.5 KiB chronyd 556.0 KiB + 59.5 KiB = 615.5 KiB auditd 388.0 KiB + 238.0 KiB = 626.0 KiB splitlogs (2) 540.0 KiB + 99.0 KiB = 639.0 KiB dovecot 668.0 KiB + 39.0 KiB = 707.0 KiB crond 684.0 KiB + 86.0 KiB = 770.0 KiB rpcbind 788.0 KiB + 44.5 KiB = 832.5 KiB systemd-logind 744.0 KiB + 167.5 KiB = 911.5 KiB stats 760.0 KiB + 210.0 KiB = 970.0 KiB mysqlmymonlite. 844.0 KiB + 165.0 KiB = 1.0 MiB dnsadmin - dorm 808.0 KiB + 262.0 KiB = 1.0 MiB dbus-daemon 1.1 MiB + 130.0 KiB = 1.3 MiB cpanellogd - sl 1.2 MiB + 117.0 KiB = 1.3 MiB smartd 1.2 MiB + 94.5 KiB = 1.3 MiB systemd-udevd 1.3 MiB + 180.0 KiB = 1.4 MiB cpdavd - accept 844.0 KiB + 675.0 KiB = 1.5 MiB bash (2) 1.6 MiB + 138.0 KiB = 1.7 MiB nscd 1.6 MiB + 279.5 KiB = 1.9 MiB auth 1.9 MiB + 93.0 KiB = 2.0 MiB config 2.1 MiB + 792.0 KiB = 2.8 MiB imap-login (2) 2.1 MiB + 776.0 KiB = 2.9 MiB pop3-login (2) 3.1 MiB + 124.5 KiB = 3.2 MiB systemd 4.7 MiB + 97.5 KiB = 4.7 MiB exim 2.8 MiB + 2.5 MiB = 5.3 MiB rsyslogd 5.9 MiB + 127.5 KiB = 6.0 MiB cpanel_php_fpm 3.8 MiB + 2.5 MiB = 6.3 MiB sshd (3) 6.5 MiB + 1.1 MiB = 7.6 MiB cPhulkd - dbpro 5.0 MiB + 2.8 MiB = 7.8 MiB systemd-journald 8.1 MiB + 223.5 KiB = 8.3 MiB queueprocd - wa 8.3 MiB + 834.0 KiB = 9.1 MiB cPhulkd - proce 9.7 MiB + 232.0 KiB = 9.9 MiB leechprotect 9.6 MiB + 563.5 KiB = 10.1 MiB polkitd 10.2 MiB + 230.0 KiB = 10.4 MiB pdns_server 14.3 MiB + 1.4 MiB = 15.6 MiB tuned 15.1 MiB + 603.0 KiB = 15.7 MiB tailwatchd 22.8 MiB + 476.5 KiB = 23.2 MiB cpsrvd (SSL) - 19.8 MiB + 4.5 MiB = 24.3 MiB php-cgi (2) 4.3 MiB + 42.7 MiB = 46.9 MiB spamd 27.3 MiB + 75.0 MiB = 102.2 MiB spamd child (2) 204.6 MiB + 32.9 MiB = 237.6 MiB httpd (151) 339.0 MiB + 235.5 KiB = 339.2 MiB mysqld 1.1 GiB + 110.5 KiB = 1.1 GiB clamd --------------------------------- 2.0 GiB ================================= Private + Shared = RAM used Program ---------------------------- Server Disk Usage ---------------------------- Filesystem Type Size Used Avail Use% Mounted on devtmpfs devtmpfs 30G 0 30G 0% /dev tmpfs tmpfs 30G 0 30G 0% /dev/shm tmpfs tmpfs 30G 106M 30G 1% /run tmpfs tmpfs 30G 0 30G 0% /sys/fs/cgroup /dev/vda1 ext4 337G 58G 263G 18% / /dev/loop0 ext4 3.9G 8.3M 3.7G 1% /tmp tmpfs tmpfs 5.9G 0 5.9G 0% /run/user/0 ---------------------------- MySQL datadir disk usage ---------------------------- /var/lib/mysql/ uses 1033540 kilobytes of disk space ---------------------------- ulimit -aH ---------------------------- core file size (blocks, -c) 1000000 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 240665 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) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 14335 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 # # # #* 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/10776/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 240665 240665 processes Max open files 40000 40000 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 240665 240665 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: ---------------------------------- Server Version: Apache/2.4.46 (cPanel) OpenSSL/1.1.1i mod_bwlimited/1.4 Server Built: Dec 23 2020 10:40:56 Current Time: Friday, 25-Dec-2020 10:22:33 +07 Restart Time: Thursday, 24-Dec-2020 23:12:26 +07 Total accesses: 538920 - Total Traffic: 4.0 GB - Total Duration: 144880866 CPU Usage: u386.41 s674.73 cu13915.3 cs10035.2 - 62.2% CPU load 13.4 requests/sec - 105.5 kB/second - 7.9 kB/request - 268.836 ms/request 150 requests currently being processed, 0 idle workers Server version: Apache/2.4.46 (cPanel) Server built: Dec 23 2020 10:40:56 Server's Module Magic Number: 20120211:93 Server loaded: APR 1.7.0, APR-UTIL 1.6.1 Compiled using: APR 1.7.0, APR-UTIL 1.6.1 Architecture: 64-bit Server MPM: prefork threaded: no 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_prefork_module (shared) cgi_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) proxy_wstunnel_module (shared) rewrite_module (shared) setenvif_module (shared) slotmem_shm_module (shared) socache_dbm_module (shared) socache_shmcb_module (shared) socache_redis_module (shared) status_module (shared) unique_id_module (shared) unixd_module (shared) userdir_module (shared) bwlimited_module (shared) ssl_module (shared) security2_module (shared) ruid2_module (shared) Compiled in modules: core.c mod_so.c http_core.c ------------------------------- From /etc/apache2/conf/httpd.conf ------------------------------- Timeout 300 KeepAlive On MaxKeepAliveRequests 100 KeepAliveTimeout 5 StartServers 5 ServerLimit 256 ---------------------------- mysqlreport output ---------------------------- ---------------------------- Total Server MyISAM and InnoDB Size ---------------------------- ---------------------------- MySQL settings ---------------------------- # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html [mysqld] performance-schema=0 # # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid innodb_buffer_pool_size=54525952 max_allowed_packet=268435456 open_files_limit=40000 innodb_file_per_table=1 --- +----------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +----------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | auto_generate_certs | ON | | auto_increment_increment | 1 | | auto_increment_offset | 1 | | autocommit | ON | | automatic_sp_privileges | ON | | avoid_temporal_upgrade | OFF | | back_log | 80 | | basedir | /usr/ | | big_tables | OFF | | bind_address | * | | binlog_cache_size | 32768 | | binlog_checksum | CRC32 | | binlog_direct_non_transactional_updates | OFF | | binlog_error_action | ABORT_SERVER | | binlog_format | ROW | | binlog_group_commit_sync_delay | 0 | | binlog_group_commit_sync_no_delay_count | 0 | | binlog_gtid_simple_recovery | ON | | 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 | | binlog_transaction_dependency_history_size | 25000 | | binlog_transaction_dependency_tracking | COMMIT_ORDER | | 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/ | | check_proxy_users | OFF | | collation_connection | latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | | completion_type | NO_CHAIN | | concurrent_insert | AUTO | | connect_timeout | 10 | | core_file | OFF | | datadir | /var/lib/mysql/ | | date_format | %Y-%m-%d | | datetime_format | %Y-%m-%d %H:%i:%s | | default_authentication_plugin | mysql_native_password | | default_password_lifetime | 0 | | default_storage_engine | InnoDB | | 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 | | disabled_storage_engines | | | disconnect_on_expired_password | ON | | div_precision_increment | 4 | | end_markers_in_json | OFF | | enforce_gtid_consistency | OFF | | eq_range_index_dive_limit | 200 | | 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/sv01.log | | group_concat_max_len | 1024 | | gtid_executed | | | gtid_executed_compression_period | 1000 | | gtid_mode | OFF | | gtid_owned | | | gtid_purged | | | have_compress | YES | | have_crypt | YES | | have_dynamic_loading | YES | | have_geometry | YES | | have_openssl | YES | | have_profiling | YES | | have_query_cache | YES | | have_rtree_keys | YES | | have_ssl | YES | | have_statement_timeout | YES | | have_symlink | DISABLED | | host_cache_size | 279 | | 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_hash_index_parts | 8 | | innodb_adaptive_max_sleep_delay | 150000 | | 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_chunk_size | 54525952 | | innodb_buffer_pool_dump_at_shutdown | ON | | innodb_buffer_pool_dump_now | OFF | | innodb_buffer_pool_dump_pct | 25 | | innodb_buffer_pool_filename | ib_buffer_pool | | innodb_buffer_pool_instances | 1 | | innodb_buffer_pool_load_abort | OFF | | innodb_buffer_pool_load_at_startup | ON | | innodb_buffer_pool_load_now | OFF | | innodb_buffer_pool_size | 54525952 | | innodb_change_buffer_max_size | 25 | | innodb_change_buffering | all | | innodb_checksum_algorithm | crc32 | | innodb_checksums | ON | | innodb_cmp_per_index_enabled | OFF | | innodb_commit_concurrency | 0 | | innodb_compression_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_deadlock_detect | ON | | innodb_default_row_format | dynamic | | innodb_disable_sort_file_cache | OFF | | innodb_doublewrite | ON | | innodb_fast_shutdown | 1 | | innodb_file_format | Barracuda | | innodb_file_format_check | ON | | innodb_file_format_max | Barracuda | | innodb_file_per_table | ON | | innodb_fill_factor | 100 | | innodb_flush_log_at_timeout | 1 | | innodb_flush_log_at_trx_commit | 1 | | innodb_flush_method | | | innodb_flush_neighbors | 1 | | innodb_flush_sync | ON | | 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 | ON | | innodb_lock_wait_timeout | 50 | | innodb_locks_unsafe_for_binlog | OFF | | innodb_log_buffer_size | 16777216 | | innodb_log_checksums | ON | | innodb_log_compressed_pages | ON | | innodb_log_file_size | 50331648 | | innodb_log_files_in_group | 2 | | innodb_log_group_home_dir | ./ | | innodb_log_write_ahead_size | 8192 | | innodb_lru_scan_depth | 1024 | | innodb_max_dirty_pages_pct | 75.000000 | | innodb_max_dirty_pages_pct_lwm | 0.000000 | | innodb_max_purge_lag | 0 | | innodb_max_purge_lag_delay | 0 | | innodb_max_undo_log_size | 1073741824 | | innodb_monitor_disable | | | innodb_monitor_enable | | | innodb_monitor_reset | | | innodb_monitor_reset_all | | | innodb_numa_interleave | OFF | | 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_cleaners | 1 | | innodb_page_size | 16384 | | innodb_print_all_deadlocks | OFF | | innodb_purge_batch_size | 300 | | innodb_purge_rseg_truncate_frequency | 128 | | innodb_purge_threads | 4 | | 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_include_delete_marked | OFF | | 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 | ON | | innodb_support_xa | ON | | innodb_sync_array_size | 1 | | innodb_sync_spin_loops | 30 | | innodb_table_locks | ON | | innodb_temp_data_file_path | ibtmp1:12M:autoextend | | innodb_thread_concurrency | 0 | | innodb_thread_sleep_delay | 10000 | | innodb_tmpdir | | | innodb_undo_directory | ./ | | innodb_undo_log_truncate | OFF | | innodb_undo_logs | 128 | | innodb_undo_tablespaces | 0 | | innodb_use_native_aio | ON | | innodb_version | 5.7.32 | | innodb_write_io_threads | 4 | | interactive_timeout | 28800 | | internal_tmp_disk_storage_engine | InnoDB | | join_buffer_size | 262144 | | keep_files_on_create | OFF | | key_buffer_size | 8388608 | | key_cache_age_threshold | 300 | | key_cache_block_size | 1024 | | key_cache_division_limit | 100 | | keyring_operations | ON | | 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 | ON | | 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_builtin_as_identified_by_password | OFF | | log_error | /var/log/mysqld.log | | log_error_verbosity | 3 | | log_output | FILE | | log_queries_not_using_indexes | OFF | | log_slave_updates | OFF | | log_slow_admin_statements | OFF | | log_slow_slave_statements | OFF | | log_statements_unsafe_for_binlog | ON | | log_syslog | OFF | | log_syslog_facility | daemon | | log_syslog_include_pid | ON | | log_syslog_tag | | | log_throttle_queries_not_using_indexes | 0 | | log_timestamps | UTC | | log_warnings | 2 | | long_query_time | 10.000000 | | low_priority_updates | OFF | | 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 | 151 | | max_delayed_threads | 20 | | max_digest_length | 1024 | | max_error_count | 64 | | max_execution_time | 0 | | max_heap_table_size | 16777216 | | max_insert_delayed_threads | 20 | | max_join_size | 18446744073709551615 | | max_length_for_sort_data | 1024 | | max_points_in_geometry | 65536 | | 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 | 0 | | 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 | | mysql_native_password_proxy_users | OFF | | net_buffer_length | 16384 | | net_read_timeout | 30 | | net_retry_count | 10 | | net_write_timeout | 60 | | new | OFF | | ngram_token_size | 2 | | offline_mode | OFF | | old | OFF | | old_alter_table | OFF | | old_passwords | 0 | | open_files_limit | 40000 | | 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,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=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 | | parser_max_mem_size | 18446744073709551615 | | performance_schema | OFF | | performance_schema_accounts_size | 0 | | performance_schema_digests_size | 0 | | performance_schema_events_stages_history_long_size | 0 | | performance_schema_events_stages_history_size | 0 | | performance_schema_events_statements_history_long_size | 0 | | performance_schema_events_statements_history_size | 0 | | performance_schema_events_transactions_history_long_size | 0 | | performance_schema_events_transactions_history_size | 0 | | performance_schema_events_waits_history_long_size | 0 | | performance_schema_events_waits_history_size | 0 | | performance_schema_hosts_size | 0 | | performance_schema_max_cond_classes | 0 | | performance_schema_max_cond_instances | 0 | | performance_schema_max_digest_length | 0 | | performance_schema_max_file_classes | 0 | | performance_schema_max_file_handles | 0 | | performance_schema_max_file_instances | 0 | | performance_schema_max_index_stat | 0 | | performance_schema_max_memory_classes | 0 | | performance_schema_max_metadata_locks | 0 | | performance_schema_max_mutex_classes | 0 | | performance_schema_max_mutex_instances | 0 | | performance_schema_max_prepared_statements_instances | 0 | | performance_schema_max_program_instances | 0 | | performance_schema_max_rwlock_classes | 0 | | performance_schema_max_rwlock_instances | 0 | | performance_schema_max_socket_classes | 0 | | performance_schema_max_socket_instances | 0 | | performance_schema_max_sql_text_length | 0 | | performance_schema_max_stage_classes | 0 | | performance_schema_max_statement_classes | 0 | | performance_schema_max_statement_stack | 0 | | performance_schema_max_table_handles | 0 | | performance_schema_max_table_instances | 0 | | performance_schema_max_table_lock_stat | 0 | | performance_schema_max_thread_classes | 0 | | performance_schema_max_thread_instances | 0 | | performance_schema_session_connect_attrs_size | 0 | | performance_schema_setup_actors_size | 0 | | performance_schema_setup_objects_size | 0 | | performance_schema_users_size | 0 | | pid_file | /var/run/mysqld/mysqld.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 | 1048576 | | query_cache_min_res_unit | 4096 | | query_cache_size | 1048576 | | query_cache_type | OFF | | query_cache_wlock_invalidate | OFF | | query_prealloc_size | 8192 | | range_alloc_block_size | 4096 | | range_optimizer_max_mem_size | 8388608 | | rbr_exec_mode | STRICT | | read_buffer_size | 131072 | | read_only | OFF | | read_rnd_buffer_size | 262144 | | relay_log | | | relay_log_basename | /var/lib/mysql/sv01-relay-bin | | relay_log_index | /var/lib/mysql/sv01-relay-bin.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 | | | require_secure_transport | OFF | | rpl_stop_slave_timeout | 31536000 | | secure_auth | ON | | secure_file_priv | /var/lib/mysql-files/ | | server_id | 0 | | server_id_bits | 32 | | server_uuid | 8c361450-4417-11eb-a189-00163e2c9394 | | session_track_gtids | OFF | | session_track_schema | ON | | session_track_state_change | OFF | | session_track_system_variables | time_zone,autocommit,character_set_client,character_set_results,character_set_connection | | session_track_transaction_info | OFF | | sha256_password_auto_generate_rsa_keys | ON | | sha256_password_private_key_path | private_key.pem | | sha256_password_proxy_users | OFF | | sha256_password_public_key_path | public_key.pem | | show_compatibility_56 | OFF | | show_create_table_verbosity | OFF | | show_old_temporals | 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 | 60 | | slave_parallel_type | DATABASE | | slave_parallel_workers | 0 | | slave_pending_jobs_size_max | 16777216 | | slave_preserve_commit_order | OFF | | 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/sv01-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_off | OFF | | sql_mode | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | | sql_notes | ON | | sql_quote_show_create | ON | | sql_safe_updates | OFF | | sql_select_limit | 18446744073709551615 | | sql_slave_skip_counter | 0 | | sql_warnings | OFF | | ssl_ca | ca.pem | | ssl_capath | | | ssl_cert | server-cert.pem | | ssl_cipher | | | ssl_crl | | | ssl_crlpath | | | ssl_key | server-key.pem | | stored_program_cache | 256 | | super_read_only | OFF | | sync_binlog | 1 | | sync_frm | ON | | sync_master_info | 10000 | | sync_relay_log | 10000 | | sync_relay_log_info | 10000 | | system_time_zone | +07 | | table_definition_cache | 1400 | | table_open_cache | 2000 | | table_open_cache_instances | 16 | | thread_cache_size | 9 | | thread_handling | one-thread-per-connection | | thread_stack | 262144 | | time_format | %H:%i:%s | | time_zone | SYSTEM | | tls_version | TLSv1,TLSv1.1,TLSv1.2 | | tmp_table_size | 16777216 | | tmpdir | /tmp | | transaction_alloc_block_size | 8192 | | transaction_isolation | REPEATABLE-READ | | transaction_prealloc_size | 4096 | | transaction_read_only | OFF | | transaction_write_set_extraction | OFF | | tx_isolation | REPEATABLE-READ | | tx_read_only | OFF | | unique_checks | ON | | updatable_views_with_limit | YES | | version | 5.7.32 | | version_comment | MySQL Community Server (GPL) | | version_compile_machine | x86_64 | | version_compile_os | Linux | | wait_timeout | 28800 | +----------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ +-----------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Variable_name | Value | +-----------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Aborted_clients | 0 | | Aborted_connects | 32 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 0 | | Binlog_stmt_cache_disk_use | 0 | | Binlog_stmt_cache_use | 0 | | Bytes_received | 1862524695 | | Bytes_sent | 21396822530 | | Com_admin_commands | 9 | | Com_assign_to_keycache | 0 | | Com_alter_db | 0 | | Com_alter_db_upgrade | 0 | | Com_alter_event | 0 | | Com_alter_function | 0 | | Com_alter_instance | 0 | | Com_alter_procedure | 0 | | Com_alter_server | 0 | | Com_alter_table | 0 | | Com_alter_tablespace | 0 | | Com_alter_user | 11 | | Com_analyze | 0 | | Com_begin | 0 | | Com_binlog | 0 | | Com_call_procedure | 0 | | Com_change_db | 23 | | Com_change_master | 0 | | Com_change_repl_filter | 0 | | Com_check | 31 | | Com_checksum | 0 | | Com_commit | 0 | | Com_create_db | 0 | | Com_create_event | 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_procedure | 0 | | Com_create_server | 0 | | Com_create_table | 0 | | Com_create_trigger | 0 | | Com_create_udf | 0 | | Com_create_user | 3 | | Com_create_view | 0 | | Com_dealloc_sql | 0 | | Com_delete | 10112 | | 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 | 0 | | Com_execute_sql | 0 | | Com_explain_other | 0 | | Com_flush | 0 | | Com_get_diagnostics | 0 | | Com_grant | 98 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_help | 0 | | Com_insert | 15029 | | Com_insert_select | 0 | | Com_install_plugin | 0 | | Com_kill | 0 | | Com_load | 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_preload_keys | 0 | | Com_prepare_sql | 0 | | Com_purge | 0 | | Com_purge_before_date | 0 | | Com_release_savepoint | 0 | | Com_rename_table | 0 | | Com_rename_user | 0 | | Com_repair | 0 | | Com_replace | 0 | | 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 | 7509140 | | Com_set_option | 3866754 | | Com_signal | 0 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 1 | | 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 | 0 | | Com_show_create_trigger | 0 | | Com_show_databases | 10 | | Com_show_engine_logs | 0 | | Com_show_engine_mutex | 0 | | Com_show_engine_status | 0 | | Com_show_events | 0 | | Com_show_errors | 0 | | Com_show_fields | 0 | | Com_show_function_code | 0 | | Com_show_function_status | 0 | | Com_show_grants | 20 | | Com_show_keys | 0 | | Com_show_master_status | 0 | | Com_show_open_tables | 0 | | Com_show_plugins | 0 | | Com_show_privileges | 0 | | Com_show_procedure_code | 0 | | Com_show_procedure_status | 0 | | Com_show_processlist | 444 | | 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 | 10 | | Com_show_storage_engines | 0 | | Com_show_table_status | 0 | | Com_show_tables | 1 | | Com_show_triggers | 0 | | Com_show_variables | 23 | | Com_show_warnings | 0 | | Com_show_create_user | 0 | | Com_shutdown | 0 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_group_replication_start | 0 | | Com_group_replication_stop | 0 | | Com_stmt_execute | 0 | | Com_stmt_close | 0 | | Com_stmt_fetch | 0 | | Com_stmt_prepare | 0 | | Com_stmt_reset | 0 | | Com_stmt_send_long_data | 0 | | Com_truncate | 0 | | Com_uninstall_plugin | 0 | | Com_unlock_tables | 0 | | Com_update | 28223 | | Com_update_multi | 0 | | Com_xa_commit | 0 | | Com_xa_end | 0 | | Com_xa_prepare | 0 | | Com_xa_recover | 0 | | Com_xa_rollback | 0 | | Com_xa_start | 0 | | Com_stmt_reprepare | 0 | | 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 | 3867637 | | Created_tmp_disk_tables | 49275 | | Created_tmp_files | 77723 | | Created_tmp_tables | 1211832 | | Delayed_errors | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Flush_commands | 1 | | Handler_commit | 5703891 | | Handler_delete | 4220 | | Handler_discover | 0 | | Handler_external_lock | 24454993 | | Handler_mrr_init | 0 | | Handler_prepare | 0 | | Handler_read_first | 3862564 | | Handler_read_key | 700972958 | | Handler_read_last | 399790 | | Handler_read_next | 72699738 | | Handler_read_prev | 9424899593 | | Handler_read_rnd | 35671978 | | Handler_read_rnd_next | 160193038710 | | Handler_rollback | 230 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_update | 85103 | | Handler_write | 8951296221 | | Innodb_buffer_pool_dump_status | Dumping of buffer pool not started | | Innodb_buffer_pool_load_status | Buffer pool(s) load completed at 201224 0:02:15 | | Innodb_buffer_pool_resize_status | | | Innodb_buffer_pool_pages_data | 3235 | | Innodb_buffer_pool_bytes_data | 53002240 | | Innodb_buffer_pool_pages_dirty | 3 | | Innodb_buffer_pool_bytes_dirty | 49152 | | Innodb_buffer_pool_pages_flushed | 252419 | | Innodb_buffer_pool_pages_free | 0 | | Innodb_buffer_pool_pages_misc | 93 | | Innodb_buffer_pool_pages_total | 3328 | | Innodb_buffer_pool_read_ahead_rnd | 0 | | Innodb_buffer_pool_read_ahead | 109024075 | | Innodb_buffer_pool_read_ahead_evicted | 7497364 | | Innodb_buffer_pool_read_requests | 48930803774 | | Innodb_buffer_pool_reads | 116171505 | | Innodb_buffer_pool_wait_free | 60337 | | Innodb_buffer_pool_write_requests | 1999312 | | Innodb_data_fsyncs | 135797 | | Innodb_data_pending_fsyncs | 0 | | Innodb_data_pending_reads | 0 | | Innodb_data_pending_writes | 0 | | Innodb_data_read | 3689610891776 | | Innodb_data_reads | 225192189 | | Innodb_data_writes | 358627 | | Innodb_data_written | 6835832832 | | Innodb_dblwr_pages_written | 153897 | | Innodb_dblwr_writes | 24649 | | Innodb_log_waits | 0 | | Innodb_log_write_requests | 43600 | | Innodb_log_writes | 61086 | | Innodb_os_log_fsyncs | 74894 | | Innodb_os_log_pending_fsyncs | 0 | | Innodb_os_log_pending_writes | 0 | | Innodb_os_log_written | 69457920 | | Innodb_page_size | 16384 | | Innodb_pages_created | 50834 | | Innodb_pages_read | 225196120 | | Innodb_pages_written | 258660 | | Innodb_row_lock_current_waits | 0 | | Innodb_row_lock_time | 8125 | | Innodb_row_lock_time_avg | 76 | | Innodb_row_lock_time_max | 197 | | Innodb_row_lock_waits | 106 | | Innodb_rows_deleted | 4208 | | Innodb_rows_inserted | 4764670 | | Innodb_rows_read | 170052455700 | | Innodb_rows_updated | 81842 | | Innodb_num_open_files | 178 | | Innodb_truncated_status_writes | 0 | | Innodb_available_undo_logs | 128 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 6661 | | Key_blocks_used | 37 | | Key_read_requests | 7537967 | | Key_reads | 46 | | Key_write_requests | 49 | | Key_writes | 49 | | Locked_connects | 0 | | Max_execution_time_exceeded | 0 | | Max_execution_time_set | 0 | | Max_execution_time_set_failed | 0 | | Max_used_connections | 28 | | Max_used_connections_time | 2020-12-24 15:30:17 | | Not_flushed_delayed_rows | 0 | | Ongoing_anonymous_transaction_count | 0 | | Open_files | 199 | | Open_streams | 0 | | Open_table_definitions | 462 | | Open_tables | 1884 | | Opened_files | 80232 | | Opened_table_definitions | 462 | | Opened_tables | 5753 | | 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_index_stat_lost | 0 | | Performance_schema_locker_lost | 0 | | Performance_schema_memory_classes_lost | 0 | | Performance_schema_metadata_lock_lost | 0 | | Performance_schema_mutex_classes_lost | 0 | | Performance_schema_mutex_instances_lost | 0 | | Performance_schema_nested_statement_lost | 0 | | Performance_schema_prepared_statements_lost | 0 | | Performance_schema_program_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_table_lock_stat_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 | 1031832 | | Qcache_hits | 0 | | Qcache_inserts | 0 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 7502341 | | Qcache_queries_in_cache | 0 | | Qcache_total_blocks | 1 | | Queries | 15316153 | | Questions | 15316139 | | Select_full_join | 123002 | | Select_full_range_join | 0 | | Select_range | 3850 | | Select_range_check | 0 | | Select_scan | 4243361 | | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 0 | | Sort_merge_passes | 38861 | | Sort_range | 110 | | Sort_rows | 35672239 | | Sort_scan | 128250 | | 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 | 18446744073709551615 | | Ssl_ctx_verify_mode | 5 | | Ssl_default_timeout | 0 | | Ssl_finished_accepts | 0 | | Ssl_finished_connects | 0 | | Ssl_server_not_after | Dec 20 05:35:49 2030 GMT | | Ssl_server_not_before | Dec 22 05:35:49 2020 GMT | | Ssl_session_cache_hits | 0 | | Ssl_session_cache_misses | 0 | | Ssl_session_cache_mode | SERVER | | Ssl_session_cache_overflows | 0 | | Ssl_session_cache_size | 128 | | 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 | 3600270 | | Table_locks_waited | 0 | | Table_open_cache_hits | 12233977 | | Table_open_cache_misses | 5753 | | Table_open_cache_overflows | 3862 | | Tc_log_max_pages_used | 0 | | Tc_log_page_size | 0 | | Tc_log_page_waits | 0 | | Threads_cached | 4 | | Threads_connected | 7 | | Threads_created | 26421 | | Threads_running | 5 | | Uptime | 123651 | | Uptime_since_flush_status | 123651 | +-----------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ +---------+----------------+-----------+-------------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ ------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ ---------------------------- MySQL Error Log ---------------------------- Report Complete: Fri Dec 25 10:23:06 +07 2020 ----------------------------
ERROR 3167 (HY000) at line 1: The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for 'show_compatibility_56' ------------------------------------------------------------- System MySQL monitoring stats mysqlmymonlite.sh - 0.5.7 mysqlmymon.com compiled by George Liu (eva2000) centminmod.com ------------------------------------------------------------- Report Generated: Fri Dec 25 10:27:41 +07 2020 ------------------------------------------------- mysqltuner output ------------------------------------------------- >> MySQLTuner 1.7.14 - Major Hayden >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Modified by George Liu (eva2000) at https://centminmod.com/ >> Run with '--help' for additional options and output filtering [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.7.32 [OK] Operating on 64-bit architecture -------- Log file Recommendations ------------------------------------------------------------------ [--] Log file: /var/log/mysqld.log(55K) [OK] Log file /var/log/mysqld.log exists [OK] Log file /var/log/mysqld.log is readable. [OK] Log file /var/log/mysqld.log is not empty [OK] Log file /var/log/mysqld.log is smaller than 32 Mb [!!] /var/log/mysqld.log contains 36 warning(s). [OK] /var/log/mysqld.log doesn't contain any error. [--] 7 start(s) detected in /var/log/mysqld.log [--] 1) 2020-12-23T17:02:15.911113Z 0 [Note] /usr/sbin/mysqld: ready for connections. [--] 2) 2020-12-23T05:49:22.181053Z 0 [Note] /usr/sbin/mysqld: ready for connections. [--] 3) 2020-12-22T08:27:18.909531Z 0 [Note] /usr/sbin/mysqld: ready for connections. [--] 4) 2020-12-22T07:34:48.368527Z 0 [Note] /usr/sbin/mysqld: ready for connections. [--] 5) 2020-12-22T07:31:17.469459Z 0 [Note] /usr/sbin/mysqld: ready for connections. [--] 6) 2020-12-22T07:25:06.778988Z 0 [Note] /usr/sbin/mysqld: ready for connections. [--] 7) 2020-12-22T05:35:53.374314Z 0 [Note] /usr/sbin/mysqld: ready for connections. [--] 6 shutdown(s) detected in /var/log/mysqld.log [--] 1) 2020-12-23T17:02:14.552923Z 0 [Note] /usr/sbin/mysqld: Shutdown complete [--] 2) 2020-12-23T05:49:19.470726Z 0 [Note] /usr/sbin/mysqld: Shutdown complete [--] 3) 2020-12-22T08:26:04.233317Z 0 [Note] /usr/sbin/mysqld: Shutdown complete [--] 4) 2020-12-22T07:32:57.222345Z 0 [Note] /usr/sbin/mysqld: Shutdown complete [--] 5) 2020-12-22T07:30:03.508615Z 0 [Note] /usr/sbin/mysqld: Shutdown complete [--] 6) 2020-12-22T07:25:03.560565Z 0 [Note] /usr/sbin/mysqld: Shutdown complete -------- Storage Engine Statistics ----------------------------------------------------------------- [--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MEMORY +MRG_MYISAM +MyISAM +PERFORMANCE_SCHEMA [--] Data in MyISAM tables: 6.6M (Tables: 85) [--] Data in InnoDB tables: 319.7M (Tables: 159) [OK] Total fragmented tables: 0 -------- Analysis Performance Metrics -------------------------------------------------------------- [--] innodb_stats_on_metadata: OFF [OK] No stat updates during querying INFORMATION_SCHEMA. -------- Security Recommendations ------------------------------------------------------------------ [OK] There are no anonymous accounts for any database users [OK] All database users have passwords assigned [!!] There is no basic password file list! -------- CVE Security Recommendations -------------------------------------------------------------- [--] Skipped due to --cvefile option undefined -------- Performance Metrics ----------------------------------------------------------------------- [--] Up for: 1d 10h 25m 29s (15M q [124.706 qps], 3M conn, TX: 20G, RX: 1G) [--] Reads / Writes: 99% / 1% [--] Binary logging is disabled [--] Physical Memory : 58.8G [--] Max MySQL memory : 262.9M [--] Other process memory: 0B [--] Total buffers: 93.0M global + 1.1M per thread (151 max threads) [--] P_S Max memory usage: 0B [--] Galera GCache Max memory usage: 0B [OK] Maximum reached memory usage: 124.5M (0.21% of installed RAM) [OK] Maximum possible memory usage: 262.9M (0.44% of installed RAM) [OK] Overall possible memory usage with other process is compatible with memory available [OK] Slow queries: 0% (0/15M) [OK] Highest usage of available connections: 18% (28/151) [OK] Aborted connections: 0.00% (32/3899913) [!!] name resolution is active : a reverse name resolution is made for each new connection and can reduce performance [!!] Query cache may be disabled by default due to mutex contention. [!!] Query cache efficiency: 0.0% (0 cached / 7M selects) [OK] Query cache prunes per day: 0 [!!] Sorts requiring temporary tables: 30% (39K temp sorts / 129K sorts) [!!] Joins performed without indexes: 123849 [OK] Temporary tables created on disk: 4% (49K on disk / 1M total) [OK] Thread cache hit rate: 99% (26K created / 3M connections) [OK] Table cache hit rate: 32% (1K open / 5K opened) [OK] Open file limit used: 0% (199/40K) [OK] Table locks acquired immediately: 100% (3M immediate / 3M locks) -------- Performance schema ------------------------------------------------------------------------ [--] Performance schema is disabled. [--] Memory used by P_S: 0B [--] Sys schema is installed. -------- ThreadPool Metrics ------------------------------------------------------------------------ [--] ThreadPool stat is disabled. -------- MyISAM Metrics ---------------------------------------------------------------------------- [!!] Key buffer used: 18.7% (1M used / 8M cache) [OK] Key buffer size / total MyISAM indexes: 8.0M/899.0K [OK] Read Key buffer hit rate: 100.0% (7M cached / 46 reads) [OK] Write Key buffer hit rate: 100.0% (49 cached / 49 writes) -------- InnoDB Metrics ---------------------------------------------------------------------------- [--] InnoDB is enabled. [--] InnoDB Thread Concurrency: 0 [OK] InnoDB File per table is activated [!!] InnoDB buffer pool / data size: 52.0M/319.7M [!!] Ratio InnoDB log file size / InnoDB Buffer pool size (184.615384615385 %): 48.0M * 2/52.0M should be equal 25% [OK] InnoDB buffer pool instances: 1 [--] Number of InnoDB Buffer Pool Chunk : 1 for 1 Buffer Pool Instance(s) [OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances [OK] InnoDB Read buffer efficiency: 99.76% (49245891177 hits/ 49363122534 total) [!!] InnoDB Write Log efficiency: 40.21% (17654 hits/ 43905 total) [OK] InnoDB log waits: 0.00% (0 waits / 61559 writes) -------- AriaDB Metrics ---------------------------------------------------------------------------- [--] AriaDB is disabled. -------- TokuDB Metrics ---------------------------------------------------------------------------- [--] TokuDB is disabled. -------- XtraDB Metrics ---------------------------------------------------------------------------- [--] XtraDB is disabled. -------- Galera Metrics ---------------------------------------------------------------------------- [--] Galera is disabled. -------- Replication Metrics ----------------------------------------------------------------------- [--] Galera Synchronous replication: NO [--] No replication slave(s) for this server. [--] Binlog format: ROW [--] XA support enabled: ON [--] Semi synchronous replication Master: Not Activated [--] Semi synchronous replication Slave: Not Activated [--] This is a standalone server -------- Recommendations --------------------------------------------------------------------------- General recommendations: Control warning line(s) into /var/log/mysqld.log file Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1 Adjust your join queries to always utilize indexes. Please note this calculation is made by adding Select_full_join + Select_range_check status values and triggered when the total >250 Performance schema should be activated for better diagnostics Before changing innodb_log_file_size and/or innodb_log_files_in_group read this: https://bit.ly/2TcGgtU Variables to adjust: query_cache_size (=0) query_cache_type (=0) query_cache_limit (> 1M, or use smaller result sets) sort_buffer_size (> 256K) read_rnd_buffer_size (> 256K) join_buffer_size (> 256.0K, or always use indexes with JOINs) performance_schema = ON enable PFS innodb_buffer_pool_size (>= 319.7M) if possible. innodb_log_file_size should be (=6M) if possible, so InnoDB total log files size equals to 25% of buffer pool size. Report Complete:
i'm not sure why i access to website very slow. can nayone help me check which setting should i changed. i'm new to here. thank you,

Comments

0 comments

Please sign in to leave a comment.

Didn't find what you were looking for?

New post