VPS - DA - Debian 10. - OpenLiteSpeed - Isphp - Speed?

ibossonline

Verified User
Joined
Oct 26, 2019
Messages
103
Location
NYC
is there anything to make the server very fast?
i want to make webserver so fast like crazy fast.

i have hosted few domains and seems very slow.

listify.ge
likeakinginc.com

mostly WordPress websites.

srv.likeakinginc.com

please help and advices.
maybe my vps is very slow.? https://www.vpsdime.com

please recommendations.
 
Last edited:
What CPU they provide?
cat /proc/cpuinfo
What type of virtualization?
uname -a
what type of disks?
how much RAM? OS latest?
for me enough NGINX + PHP-FPM 7.4 + Opcache + mariadb 10.4 Recommended with InnoDB engine
with your Litespeed it must be faster. when you told VPN you mean VPS?
 
Last edited:
Code:
The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Mon Nov 16 00:11:17 2020 from 108.54.229.181
root@srv:~# cat /proc/cpuinfo
processor       : 0
vendor_id       : GenuineIntel
cpu family      : 6
model           : 62
model name      : Intel(R) Xeon(R) CPU E5-2697 v2 @ 2.70GHz
stepping        : 4
microcode       : 0x42e
cpu MHz         : 3000.585
cache size      : 30720 KB
physical id     : 0
siblings        : 24
core id         : 0
cpu cores       : 12
apicid          : 0
initial apicid  : 0
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov                                                                                                                                                              pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdt                                                                                                                                                             scp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc ap                                                                                                                                                             erfmperf eagerfpu cpuid_faulting pni pclmulqdq dtes64 monitor ds_cpl vmx smx est                                                                                                                                                              tm2 ssse3 cx16 xtpr pdcm pcid dca sse4_1 sse4_2 x2apic popcnt tsc_deadline_time                                                                                                                                                             r aes xsave avx f16c rdrand lahf_lm ssbd ibrs ibpb stibp tpr_shadow vnmi flexpri                                                                                                                                                             ority ept vpid fsgsbase smep erms xsaveopt dtherm ida arat pln pts md_clear spec                                                                                                                                                             _ctrl intel_stibp flush_l1d
bogomips        : 5400.17
clflush size    : 64
cache_alignment : 64
address sizes   : 46 bits physical, 48 bits virtual
power management:

processor       : 1
vendor_id       : GenuineIntel
cpu family      : 6
model           : 62
model name      : Intel(R) Xeon(R) CPU E5-2697 v2 @ 2.70GHz
stepping        : 4
microcode       : 0x42e
cpu MHz         : 2999.926
cache size      : 30720 KB
physical id     : 1
siblings        : 24
core id         : 0
cpu cores       : 12
apicid          : 32
initial apicid  : 32
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov                                                                                                                                                              pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdt                                                                                                                                                             scp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc ap                                                                                                                                                             erfmperf eagerfpu cpuid_faulting pni pclmulqdq dtes64 monitor ds_cpl vmx smx est                                                                                                                                                              tm2 ssse3 cx16 xtpr pdcm pcid dca sse4_1 sse4_2 x2apic popcnt tsc_deadline_time                                                                                                                                                             r aes xsave avx f16c rdrand lahf_lm ssbd ibrs ibpb stibp tpr_shadow vnmi flexpri                                                                                                                                                             ority ept vpid fsgsbase smep erms xsaveopt dtherm ida arat pln pts md_clear spec                                                                                                                                                             _ctrl intel_stibp flush_l1d
bogomips        : 5406.37
clflush size    : 64
cache_alignment : 64
address sizes   : 46 bits physical, 48 bits virtual
power management:

processor       : 2
vendor_id       : GenuineIntel
cpu family      : 6
model           : 62
model name      : Intel(R) Xeon(R) CPU E5-2697 v2 @ 2.70GHz
stepping        : 4
microcode       : 0x42e
cpu MHz         : 3002.069
cache size      : 30720 KB
physical id     : 0
siblings        : 24
core id         : 1
cpu cores       : 12
apicid          : 2
initial apicid  : 2
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov                                                                                                                                                              pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdt                                                                                                                                                             scp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc ap                                                                                                                                                             erfmperf eagerfpu cpuid_faulting pni pclmulqdq dtes64 monitor ds_cpl vmx smx est                                                                                                                                                              tm2 ssse3 cx16 xtpr pdcm pcid dca sse4_1 sse4_2 x2apic popcnt tsc_deadline_time                                                                                                                                                             r aes xsave avx f16c rdrand lahf_lm ssbd ibrs ibpb stibp tpr_shadow vnmi flexpri                                                                                                                                                             ority ept vpid fsgsbase smep erms xsaveopt dtherm ida arat pln pts md_clear spec                                                                                                                                                             _ctrl intel_stibp flush_l1d
bogomips        : 5400.17
clflush size    : 64
cache_alignment : 64
address sizes   : 46 bits physical, 48 bits virtual
power management:

processor       : 3
vendor_id       : GenuineIntel
cpu family      : 6
model           : 62
model name      : Intel(R) Xeon(R) CPU E5-2697 v2 @ 2.70GHz
stepping        : 4
microcode       : 0x42e
cpu MHz         : 2999.926
cache size      : 30720 KB
physical id     : 1
siblings        : 24
core id         : 1
cpu cores       : 12
apicid          : 34
initial apicid  : 34
fpu             : yes
fpu_exception   : yes
cpuid level     : 13
wp              : yes
flags           : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov                                                                                                                                                              pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdt                                                                                                                                                             scp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc ap                                                                                                                                                             erfmperf eagerfpu cpuid_faulting pni pclmulqdq dtes64 monitor ds_cpl vmx smx est                                                                                                                                                              tm2 ssse3 cx16 xtpr pdcm pcid dca sse4_1 sse4_2 x2apic popcnt tsc_deadline_time                                                                                                                                                             r aes xsave avx f16c rdrand lahf_lm ssbd ibrs ibpb stibp tpr_shadow vnmi flexpri                                                                                                                                                             ority ept vpid fsgsbase smep erms xsaveopt dtherm ida arat pln pts md_clear spec                                                                                                                                                             _ctrl intel_stibp flush_l1d
bogomips        : 5406.37
clflush size    : 64
cache_alignment : 64
address sizes   : 46 bits physical, 48 bits virtual
power management:

root@srv:~#
Code:
Memory Information
Total Memory    30 GB
Free Memory    23.19 GB
Available Memory    27.3 GB
Total Swap Memory    0 B
Free Swap Memory    0 B
Cached Swap Memory    0 B

Code:
Services
DirectAdmin  
Running
1.61.5  
Dovecot  
Running
2.3.11.3 (502c39af9)  
Exim  
Running
4.94  
MySQL  
Running
10.5.8  
Named  
Running
9.11.5  
OpenLiteSpeed  
Running
1.6.14  
php  
Installed
7.2.34  
php2  
Installed
7.3.24  
php3  
Installed
7.4.12  
php4  
Installed
8.0.0RC4  
Pure-FTPd  
Running
1.0.49  
sshd  
Running
Code:
Linux srv.likeakinginc.com 4.19.0 #1 SMP Wed May 15 09:45:34 MSK 2019 x86_64 GNU/Linux
 
Last edited:
Code:
Nginx Unit: 1.20.0
OpenLitespeed: 1.6.14
Dovecot: 2.3.11.3
Dovecot configuration: yes
AWstats: 7.8
Exim: 4.94
exim.conf update: yes, release 4.5
BlockCracking: yes
Easy Spam Fighter: yes
SpamAssassin: 3.4.4
SpamAssassin rule updates: daily
ClamAV: 0.103.0
MariaDB: 10.5.8
MySQL backup: yes
MySQL backup directory: /usr/local/directadmin/custombuild/mysql_backups
MySQL compress backups: yes
PHP (default): 7.2 as lsphp
PHP (additional): 7.3 as lsphp
PHP (additional, 3rd): 7.4 as lsphp
PHP (additional, 4th): 8.0 as lsphp
phpMyAdmin: 5.0.4-all-languages
ProFTPD: no
Pure-FTPd: 1.0.49
RoundCube webmail: 1.4.9
Replace "php.ini" with './build all' and './build php_ini': yes
Replace "php.ini" using type: production
Cron for notifications and (or) updates: yes
Cron frequency: daily
Auto updates: yes
Run "clean" every time: yes
Run "clean_old_webapps" every time: yes
Run "clean_old_tarballs" every time: yes
Show texts in bold: yes
SquirrelMail: 1.4.23-20190509_0200
Zend Guard Loader: yes
ionCube loader: 10.4.4
Suhosin: no
 
nice but old CPU, check TOP/ATOP Where are bottleneck? CPU-load? WA? iotop?
try mysqltuner.
 
nice but old CPU, check TOP/ATOP Where are bottleneck? CPU-load? WA? iotop?
try mysqltuner.
i am trying my best. self learner i did not had any experience before. this forum helped a lot. i was thinking to move on AWS maybe? idk. i am worried about billing how much it will cost me and of the month. i am already paying $50+ i have few IP`s too. i want to move on AWS and use S3 as storage.
 
Code:
root@srv:~# atop
ATOP - srv                                                          2020/11/17  09:33:21                                                          --------------                                                          1d12h18m26s elapsed
PRC | sys   12m52s |  user  17m43s |              |               | #proc    119 |  #trun      1 |              | #tslpi   147  | #tslpu     0 |               | #zombie    0 | clones 384e3  |              |               | #exit      0 |
CPU | sys       6% |  user     12% | irq       0% |               |              |  idle    382% | wait      0% | steal     0%  | guest     0% |               | ipc notavail |               | cycl unknown | curf 3.00GHz  | curscal   ?% |
cpu | sys       2% |  user      4% | irq       0% |               |              |  idle     94% | cpu002 w  0% | steal     0%  | guest     0% |               | ipc notavail |               | cycl unknown | curf 3.00GHz  | curscal   ?% |
cpu | sys       2% |  user      4% | irq       0% |               |              |  idle     94% | cpu000 w  0% | steal     0%  | guest     0% |               | ipc notavail |               | cycl unknown | curf 3.00GHz  | curscal   ?% |
cpu | sys       1% |  user      2% | irq       0% |               |              |  idle     97% | cpu001 w  0% | steal     0%  | guest     0% |               | ipc notavail |               | cycl unknown | curf 3.00GHz  | curscal   ?% |
cpu | sys       1% |  user      2% | irq       0% |               |              |  idle     97% | cpu003 w  0% | steal     0%  | guest     0% |               | ipc notavail |               | cycl unknown | curf 3.00GHz  | curscal   ?% |
CPL | avg1    0.22 |               | avg5    0.13 |               | avg15   0.14 |               |              | csw 50242963  |              | intr       0  |              |               |              | numcpu     4  |              |
MEM | tot    30.0G |  free   22.8G | cache   4.4G |  dirty   0.1M | buff    0.0M |  slab  734.2M | slrec 662.1M | shmem 292.5M  | shrss   0.0M | shswp   0.0M  |              | vmbal   0.0M  |              | hptot   0.0M  | hpuse   0.0M |
SWP | tot     0.0M |  free    0.0M |              |               |              |               |              |               |              |               |              |               | vmcom   0.0M | vmlim   0.0M  |              |
NET | transport    |  tcpi  691137 | tcpo  882073 |               | udpi  368834 |  udpo  355807 | tcpao  10907 | tcppo  28352  |              | tcprs  12223  | tcpie      0 | tcpor  15554  | udpnp      0 |               | udpie      0 |
NET | network      |  ipi 20332837 |              |  ipo  1014333 | ipfrw      1 |               | deliv 1231e3 |               |              |               |              |               | icmpi 171081 | icmpo     10  |              |
NET | eth0      0% |               | pcki 50391e3 |  pcko  943110 |              |  sp   10 Gbps | si  960 Kbps | so   53 Kbps  |              | coll       0  | mlti       0 | erri       0  | erro       0 | drpi     110  | drpo       0 |
NET | lo      ---- |               | pcki   71732 |  pcko   71732 |              |  sp    0 Mbps | si    1 Kbps | so    1 Kbps  |              | coll       0  | mlti       0 | erri       0  | erro       0 | drpi       0  | drpo       0 |
Window resized to 237x63...
  PID         SYSCPU          USRCPU           VGROW           RGROW           RDDSK          WRDSK          RUID              EUID              ST          EXC          THR          S          CPUNR           CPU          CMD        1/3
  544          4m17s          11m27s            2.5G          427.1M          247.2M           3.2G          mysql             mysql             N-            -           20          S              2            1%          mariadbd
27852          4m37s          20.11s          36732K          30548K            508K             8K          root              root              N-            -            1          S              1            0%          lfd - sleeping
 9010         20.87s          85.80s          132.5M          102.7M           4796K         593.0M          apache            apache            N-            -            1          S              2            0%          litespeed
 9008         20.82s          61.53s          120.6M          94888K          11428K         585.1M          apache            apache            N-            -            1          S              0            0%          litespeed
  337          6.15s          63.81s            1.3G            1.1G          470.7M            24K          root              root              N-            -            2          S              2            0%          clamd
19253         15.05s          48.29s          325.7M          120.6M            100K            56K          admin             admin             N-            -            1          S              0            0%          lsphp
   47         27.03s          22.53s          137.4M          92848K            376K             0K          root              root              N-            -            1          S              0            0%          systemd-journa
  261         44.31s           0.53s          15840K           3880K          84888K         309.0M          root              root              N-            -            1          S              2            0%          sshd
  620         13.47s          12.74s          336.4M          24500K             44K            32K          bind              bind              N-            -            7          S              2            0%          named
 2313         24.73s           0.30s          220.1M          22008K          16332K         115.5M          admin             admin             N-            -            1          S              2            0%          lsphp
    1          8.29s          14.67s          102.4M           7340K            1.3G           5.7G          root              root              N-            -            1          S              2            0%          systemd
 8992         10.35s           8.54s          97028K          71596K              0K            40K          root              root              N-            -            1          S              2            0%          litespeed
  153          9.75s           9.03s          220.5M           2688K            916K         439.1M          root              root              N-            -            4          S              0            0%          rsyslogd
  163         11.33s           0.12s           7252K           1312K          953.2M           2.4G          root              root              N-            -            1          S              2            0%          cron
25492          2.95s           8.39s          359.7M          123.7M              0K             0K          admin             admin             N-            -            1          S              1            0%          lsphp
10101          0.81s           4.93s          104.8M          93444K            968K             0K          root              root              N-            -            1          S              0            0%          spamd
  253          5.12s           0.11s          13208K           2604K          39604K         11848K          root              root              N-            -            1          S              2            0%          directadmin
10102          0.25s           4.80s          110.1M          98220K              0K         12072K          root              root              N-            -            1          S              0            0%          spamd child
  255          4.03s           0.16s           5392K           1648K          13536K          6828K          root              root              N-            -            1          S              0            0%          dovecot
  322          3.49s           0.37s          93716K           5576K          88064K           1.2G          clamav            clamav            N-            -            1          S              1            0%          freshclam
26503          0.85s           2.77s          362.3M          95528K              0K             0K          admin             admin             N-            -            1          S              2            0%          lsphp
  228          2.85s           0.05s          15732K           4040K           7456K          6312K          mail              mail              N-            -            1          S              0            0%          exim
  229          1.41s           0.61s           6452K            684K            216K          6140K          root              root              N-            -            1          S              0            0%          da-popb4smtp
  378          0.25s           1.37s          13136K           7924K            272K             0K          root              root              N-            -            1          S              0            0%          config
  435          0.14s           0.95s          11044K           4312K            700K             0K          root              root              N-            -            1          S              3            0%          auth
27128          0.43s           0.59s          238.6M          74208K              0K             4K          admin             admin             N-            -            1          S              0            0%          lsphp
 9002          0.82s           0.09s          19256K           7908K            168K            60K          root              root              N-            -            1          S              3            0%          litespeed
26863          0.19s           0.68s          296.3M          44280K              0K             0K          admin             admin             N-            -            1          S              3            0%          lsphp
   85          0.50s           0.17s          20932K           4380K           1888K             0K          systemd-          systemd-          N-            -            1          S              2            0%          systemd-networ
  379          0.22s           0.26s          11336K           3596K            256K             0K          dovecot           dovecot           N-            -            1          S              3            0%          stats
  227          0.39s           0.00s           8704K           2008K            356K             0K          root              root              N-            -            1          S              2            0%          pure-ftpd
  349          0.12s           0.14s           5336K           1548K            100K             0K          root              root              N-            -            1          S              2            0%          log
  348          0.11s           0.08s           5204K           1216K             88K             0K          dovecot           dovecot           N-            -            1          S              0            0%          anvil
27604          0.16s           0.02s          10524K           7900K            712K            16K          root              root              N-            -            1          S              0            0%          atop
26865          0.06s           0.10s          222.1M          30036K              0K             0K          admin             admin             N-            -            1          S              2            0%          lsphp
26862          0.11s           0.03s          219.1M          21444K              0K             0K          admin             admin             N-            -            1          S              1            0%          lsphp
  135          0.11s           0.02s           6812K           1748K            864K             0K          _rpc              _rpc              N-            -            1          S              2            0%          rpcbind
   84          0.11s           0.01s          19536K           2620K            960K             0K          root              root              N-            -            1          S              1            0%          systemd-udevd
10266          0.00s           0.12s          13340K            924K              0K             0K          root              nobody            N-            -            1          S              0            0%          directadmin
10265          0.00s           0.11s          13340K            924K              0K             0K          root              nobody            N-            -            1          S              3            0%          directadmin
10275          0.00s           0.11s          13340K            924K              0K             0K          root              nobody            N-            -            1          S              1            0%          directadmin
22818          0.00s           0.11s          13340K            924K              0K             0K          root              nobody            N-            -            1          S              3            0%          directadmin
22819          0.00s           0.11s          13340K            924K              0K             0K          root              nobody            N-            -            1          S              1            0%          directadmin
22820          0.00s           0.11s          13340K            924K              0K             0K          root              nobody            N-            -            1          S              3            0%          directadmin
10255          0.00s           0.10s          13340K            924K              0K             0K          root              nobody            N-            -            1          S              2            0%          directadmin
10264          0.00s           0.10s          13340K            924K              0K             0K          root              nobody            N-            -            1          S              3            0%          directadmin
10267          0.00s           0.10s          13340K            924K              0K             0K          root              nobody            N-            -            1          S              0            0%          directadmin
 
Code:
root@srv:~# apt-get install mysqltuner
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
  default-mysql-server libcgi-fast-perl libcgi-pm-perl libfcgi-perl libhtml-template-perl libtext-template-perl mariadb-server-10.3
Suggested packages:
  libipc-sharedcache-perl mailx mariadb-test netcat-openbsd tinyca
The following NEW packages will be installed:
  default-mysql-server libcgi-fast-perl libcgi-pm-perl libfcgi-perl libhtml-template-perl libtext-template-perl mariadb-server-10.3 mysqltuner
0 upgraded, 8 newly installed, 0 to remove and 3 not upgraded.
13 not fully installed or removed.
Need to get 0 B/4726 kB of archives.
After this operation, 69.0 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Preconfiguring packages ...
Setting up mariadb-common (1:10.3.25-0+deb10u1) ...
update-alternatives: error: alternative path /etc/mysql/mariadb.cnf doesn't exist
dpkg: error processing package mariadb-common (--configure):
 installed mariadb-common package post-installation script subprocess returned error exit status 2
Errors were encountered while processing:
 mariadb-common
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@srv:~#
 
you may not install mysqltuner, just download script:
wget -o mysqltuner.pl mysqltuner.pl
chmod +x mysqltuner.pl
./mysqltuner.pl
it may require mysql credentials in such case
./mysqltuner.pl -u da_admin -p
-----------
also about CPU: idle 382% - so You just using 18% from one core, all other unused.
wait 0% - also perfect.
all must work like a flash!
 
you may not install mysqltuner, just download script:
wget -o mysqltuner.pl mysqltuner.pl
chmod +x mysqltuner.pl
./mysqltuner.pl
it may require mysql credentials in such case
./mysqltuner.pl -u da_admin -p
-----------
also about CPU: idle 382% - so You just using 18% from one core, all other unused.
wait 0% - also perfect.
all must work like a flash!
i just did that.

Code:
root@srv:~# atop
ATOP - srv                                                            2020/11/17  10:02:52                                                            --------------                                                            7m20s elapsed
PRC | sys   11.19s |  user  34.02s |              |               | #proc    122 |  #trun      1 |              | #tslpi   146  | #tslpu     0 |               | #zombie    0 | clones  1237  |              |               | #exit      0 |
CPU | sys       4% |  user      9% | irq       0% |               |              |  idle    387% | wait      0% | steal     0%  | guest     0% |               | ipc notavail |               | cycl unknown | curf 3.00GHz  | curscal   ?% |
cpu | sys       1% |  user      4% | irq       0% |               |              |  idle     95% | cpu001 w  0% | steal     0%  | guest     0% |               | ipc notavail |               | cycl unknown | curf 3.00GHz  | curscal   ?% |
cpu | sys       1% |  user      2% | irq       0% |               |              |  idle     97% | cpu003 w  0% | steal     0%  | guest     0% |               | ipc notavail |               | cycl unknown | curf 3.00GHz  | curscal   ?% |
cpu | sys       1% |  user      2% | irq       0% |               |              |  idle     97% | cpu000 w  0% | steal     0%  | guest     0% |               | ipc notavail |               | cycl unknown | curf 3.00GHz  | curscal   ?% |
cpu | sys       1% |  user      1% | irq       0% |               |              |  idle     98% | cpu002 w  0% | steal     0%  | guest     0% |               | ipc notavail |               | cycl unknown | curf 3.00GHz  | curscal   ?% |
CPL | avg1    0.00 |               | avg5    0.04 |               | avg15   0.07 |               |              | csw   122959  |              | intr       0  |              |               |              | numcpu     4  |              |
MEM | tot    30.0G |  free   26.5G | cache   1.8G |  dirty   0.0M | buff    0.0M |  slab   66.4M | slrec  34.5M | shmem 163.8M  | shrss   0.0M | shswp   0.0M  |              | vmbal   0.0M  |              | hptot   0.0M  | hpuse   0.0M |
SWP | tot     0.0M |  free    0.0M |              |               |              |               |              |               |              |               |              |               | vmcom   0.0M | vmlim   0.0M  |              |
NET | transport    |  tcpi     991 | tcpo    1146 |               | udpi     279 |  udpo     294 | tcpao     26 | tcppo     69  |              | tcprs     20  | tcpie      0 | tcpor     40  | udpnp      6 |               | udpie      0 |
NET | network      |  ipi    62114 |              |  ipo     1361 | ipfrw      5 |               | deliv   1752 |               |              |               |              |               | icmpi    474 | icmpo     10  |              |
NET | eth0      0% |               | pcki  162582 |  pcko    1181 |              |  sp   10 Gbps | si  933 Kbps | so    9 Kbps  |              | coll       0  | mlti       0 | erri       0  | erro       0 | drpi       0  | drpo       0 |
NET | lo      ---- |               | pcki     183 |  pcko     183 |              |  sp    0 Mbps | si    2 Kbps | so    2 Kbps  |              | coll       0  | mlti       0 | erri       0  | erro       0 | drpi       0  | drpo       0 |
Window resized to 237x63...
  PID         SYSCPU          USRCPU           VGROW           RGROW           RDDSK          WRDSK          RUID              EUID              ST          EXC          THR          S          CPUNR           CPU          CMD        1/3
  331          1.74s          18.40s            1.3G            1.1G          443.6M             0K          root              root              N-            -            2          S              0            4%          clamd
  601          1.26s           3.69s          334.6M          131.4M          91672K             0K          admin             admin             N-            -            1          S              3            1%          lsphp
  616          0.82s           2.21s          324.2M          93460K           1864K             0K          admin             admin             N-            -            1          S              1            1%          lsphp
  619          0.65s           2.18s          309.1M          123.8M          35612K             0K          admin             admin             N-            -            1          S              0            1%          lsphp
  576          2.27s           0.30s          36692K          31428K            124K             8K          root              root              N-            -            1          S              0            1%          lfd - sleeping
  507          0.15s           1.35s          104.8M          93080K           3868K             0K          root              root              N-            -            1          S              0            0%          spamd
  489          0.47s           0.67s            1.7G          118.9M          98332K          3356K          mysql             mysql             N-            -           16          S              0            0%          mariadbd
  580          0.36s           0.62s          99472K          73728K           1744K          8888K          apache            apache            N-            -            1          S              2            0%          litespeed
  618          0.23s           0.75s          299.0M          50828K          13032K             0K          admin             admin             N-            -            1          S              2            0%          lsphp
  526          0.27s           0.65s          96004K          71676K          16076K            44K          root              root              N-            -            1          S              0            0%          litespeed
  579          0.33s           0.49s          106.6M          75504K           3536K          8952K          apache            apache            N-            -            1          S              0            0%          litespeed
    1          0.67s           0.14s          22044K           7088K          74844K          9360K          root              root              N-            -            1          S              1            0%          systemd
  855          0.31s           0.37s          296.6M          35716K           1648K             8K          admin             admin             N-            -            1          S              1            0%          lsphp
  883          0.20s           0.21s          229.4M          58120K           2112K             0K          admin             admin             N-            -            1          S              0            0%          lsphp
  622          0.19s           0.19s          224.1M          31172K            860K             0K          admin             admin             N-            -            1          S              1            0%          lsphp
  608          0.04s           0.27s          106.5M          94584K           1860K           748K          root              root              N-            -            1          S              0            0%          spamd child
   46          0.19s           0.10s          29544K           8916K            152K             0K          root              root              N-            -            1          S              0            0%          systemd-journa
  593          0.17s           0.02s          220.1M          21380K           4268K             0K          admin             admin             N-            -            1          S              0            0%          lsphp
  595          0.14s           0.04s          219.1M          20860K              0K             0K          admin             admin             N-            -            1          S              2            0%          lsphp
  243          0.15s           0.02s           5392K           1776K           8828K            92K          root              root              N-            -            1          S              2            0%          dovecot
  276          0.00s           0.13s          13340K           1064K              0K             0K          root              nobody            N-            -            1          S              3            0%          directadmin
  277          0.00s           0.12s          13340K           1064K              0K             0K          root              nobody            N-            -            1          S              1            0%          directadmin
  280          0.00s           0.12s          13340K           1064K              0K             0K          root              nobody            N-            -            1          S              3            0%          directadmin
  272          0.00s           0.11s          13340K           1064K              0K             0K          root              nobody            N-            -            1          S              2            0%          directadmin
  273          0.00s           0.11s          13340K           1064K              0K             0K          root              nobody            N-            -            1          S              1            0%          directadmin
  274          0.00s           0.11s          13340K           1064K              0K             0K          root              nobody            N-            -            1          S              0            0%          directadmin
  275          0.00s           0.11s          13340K           1064K              0K             0K          root              nobody            N-            -            1          S              2            0%          directadmin
  279          0.00s           0.11s          13340K           1064K              0K             0K          root              nobody            N-            -            1          S              3            0%          directadmin
  268          0.00s           0.11s          13340K           1060K            152K             0K          root              nobody            N-            -            1          S              3            0%          directadmin
  654          0.04s           0.06s          332.8M          20180K              8K            16K          bind              bind              N-            -            7          S              2            0%          named
  271          0.00s           0.10s          13340K           1064K              0K             0K          root              nobody            N-            -            1          S              3            0%          directadmin
  309          0.09s           0.00s          15840K           3432K            284K            32K          root              root              N-            -            1          S              2            0%          sshd
  185          0.07s           0.01s          10480K           7852K           1476K             8K          root              root              N-            -            1          S              3            0%          atop
  140          0.05s           0.03s          220.5M           2200K            908K          1148K          root              root              N-            -            4          S              1            0%          rsyslogd
  236          0.07s           0.00s           5740K           1976K           3872K             0K          mysql             mysql             N-            -            1          S              0            0%          mysqld_safe
 1199          0.03s           0.02s          16180K           4672K             16K             0K          root              root              N-            -            1          S              2            0%          sshd
  400          0.01s           0.03s          13044K           7640K            272K             0K          root              root              N-            -            1          S              2            0%          config
  159          0.04s           0.00s           7252K           1400K          18496K           620K          root              root              N-            -            1          S              1            0%          cron
  548          0.03s           0.00s          19256K           7776K          53272K             0K          root              root              N-            -            1          S              0            0%          litespeed
 1074          0.01s           0.02s          11568K           4528K            596K             8K          admin             admin             N-            -            1          S              0            0%          imap
   86          0.02s           0.01s          20932K           4372K           1888K             0K          systemd-          systemd-          N-            -            1          S              1            0%          systemd-networ
  288          0.03s           0.00s          15736K           3896K           7792K           156K          mail              mail              N-            -            1          S              0            0%          exim
  238          0.02s           0.01s          13208K           2508K           2036K             0K          root              nobody            N-            -            1          S              0            0%          directadmin
 1237          0.02s           0.00s           9888K           7756K              0K             0K          root              root              N-            -            1          R              1            0%          atop
  494          0.01s           0.01s           9384K           4240K              0K             0K          dovecot           dovecot           N-            -            1          S              0            0%          imap-login
  394          0.00s           0.01s          15204K           5784K            356K           124K          root              admin             N-            -            1          S              0            0%          lmtp
  484          0.00s           0.01s          10940K           3952K            696K             0K          root              root              N-            -            1          S              1            0%          auth
 
Code:
root@srv:~# ./mysqltuner.pl
 >>  MySQLTuner 1.7.20 - Major Hayden <[email protected]>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.pl/
 >>  Run with '--help' for additional options and output filtering

[--] Skipped version check for MySQLTuner script
[!!] Your MySQL version 10.5.8-MariaDB is EOL software!  Upgrade soon!
[OK] Operating on 64-bit architecture

-------- Log file Recommendations ------------------------------------------------------------------
[OK] Log file /usr/local/mysql/data/srv.likeakinginc.com.err exists
[--] Log file: /usr/local/mysql/data/srv.likeakinginc.com.err(247K)
[OK] Log file /usr/local/mysql/data/srv.likeakinginc.com.err is readable.
[OK] Log file /usr/local/mysql/data/srv.likeakinginc.com.err is not empty
[OK] Log file /usr/local/mysql/data/srv.likeakinginc.com.err is smaller than 32 Mb
[!!] /usr/local/mysql/data/srv.likeakinginc.com.err contains 1396 warning(s).
[!!] /usr/local/mysql/data/srv.likeakinginc.com.err contains 22 error(s).
[--] 29 start(s) detected in /usr/local/mysql/data/srv.likeakinginc.com.err
[--] 1) 2020-11-17  9:55:36 0 [Note] /usr/local/mysql/bin/mariadbd: ready for connections.
[--] 2) 2020-11-17  9:55:06 0 [Note] /usr/local/mysql/bin/mariadbd: ready for connections.
[--] 3) 2020-11-15 21:15:00 0 [Note] /usr/local/mysql/bin/mariadbd: ready for connections.
[--] 4) 2020-11-12  1:59:19 0 [Note] /usr/local/mysql/bin/mariadbd: ready for connections.
[--] 5) 2020-11-12  1:59:11 0 [Note] /usr/local/mysql/bin/mariadbd: ready for connections.
[--] 6) 2020-11-08  1:59:15 0 [Note] /usr/local/mysql/bin/mariadbd: ready for connections.
[--] 7) 2020-11-08  1:59:07 0 [Note] /usr/local/mysql/bin/mariadbd: ready for connections.
[--] 8) 2020-11-07  1:59:12 0 [Note] /usr/local/mysql/bin/mariadbd: ready for connections.
[--] 9) 2020-11-07  1:59:03 0 [Note] /usr/local/mysql/bin/mariadbd: ready for connections.
[--] 10) 2020-11-06  0:25:28 0 [Note] /usr/local/mysql/bin/mariadbd: ready for connections.
[--] 28 shutdown(s) detected in /usr/local/mysql/data/srv.likeakinginc.com.err
[--] 1) 2020-11-17  9:55:24 0 [Note] /usr/local/mysql/bin/mariadbd: Shutdown complete
[--] 2) 2020-11-17  9:55:04 0 [Note] /usr/local/mysql/bin/mariadbd: Shutdown complete
[--] 3) 2020-11-15 21:14:46 0 [Note] /usr/local/mysql/bin/mariadbd: Shutdown complete
[--] 4) 2020-11-12  1:59:18 0 [Note] /usr/local/mysql/bin/mariadbd: Shutdown complete
[--] 5) 2020-11-12  1:59:00 0 [Note] /usr/local/mysql/bin/mariadbd: Shutdown complete
[--] 6) 2020-11-08  1:59:14 0 [Note] /usr/local/mysql/bin/mariadbd: Shutdown complete
[--] 7) 2020-11-08  1:58:56 0 [Note] /usr/local/mysql/bin/mariadbd: Shutdown complete
[--] 8) 2020-11-07  1:59:11 0 [Note] /usr/local/mysql/bin/mariadbd: Shutdown complete
[--] 9) 2020-11-07  1:58:50 0 [Note] /usr/local/mysql/bin/mariadbd: Shutdown complete
[--] 10) 2020-11-06  0:25:15 0 [Note] /usr/local/mysql/bin/mariadbd: Shutdown complete

-------- Storage Engine Statistics -----------------------------------------------------------------
[--] Status: +Aria +CSV +InnoDB +MEMORY +MRG_MyISAM +MyISAM +PERFORMANCE_SCHEMA +SEQUENCE
[--] Data in InnoDB tables: 471.5M (Tables: 1353)
[--] Data in MyISAM tables: 12.0M (Tables: 61)
[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
[!!] User 'mariadb.sys@localhost' has no password set.
[!!] There is no basic password file list!

-------- CVE Security Recommendations --------------------------------------------------------------
[--] Skipped due to --cvefile option undefined

-------- Performance Metrics -----------------------------------------------------------------------
[--] Up for: 8m 43s (2K q [4.122 qps], 40 conn, TX: 18M, RX: 628K)
[--] Reads / Writes: 92% / 8%
[--] Binary logging is disabled
[--] Physical Memory     : 30.0G
[--] Max MySQL memory    : 10.3G
[--] Other process memory: 0B
[--] Total buffers: 417.0M global + 66.9M per thread (151 max threads)
[--] P_S Max memory usage: 0B
[--] Galera GCache Max memory usage: 0B
[OK] Maximum reached memory usage: 684.6M (2.23% of installed RAM)
[OK] Maximum possible memory usage: 10.3G (34.25% of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
[OK] Slow queries: 0% (0/2K)
[OK] Highest usage of available connections: 2% (4/151)
[OK] Aborted connections: 0.00%  (0/40)
[!!] 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 / 1K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 132 sorts)
[OK] No joins without indexes
[!!] Temporary tables created on disk: 56% (36 on disk / 64 total)
[OK] Thread cache hit rate: 90% (4 created / 40 connections)
[OK] Table cache hit rate: 93% (88 open / 94 opened)
[!!] table_definition_cache(400) is lower than number of tables(1711)
[OK] Open file limit used: 0% (28/32K)
[OK] Table locks acquired immediately: 100% (215 immediate / 215 locks)

-------- Performance schema ------------------------------------------------------------------------
[--] Performance schema is disabled.
[--] Memory used by P_S: 0B
[--] Sys schema is installed.

-------- ThreadPool Metrics ------------------------------------------------------------------------
[--] ThreadPool stat is enabled.
[--] Thread Pool Size: 4 thread(s).
[--] Using default value is good enough for your version (10.5.8-MariaDB)

-------- MyISAM Metrics ----------------------------------------------------------------------------
[!!] Key buffer used: 18.2% (24M used / 134M cache)
[OK] Key buffer size / total MyISAM indexes: 128.0M/457.0K

-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[--] InnoDB Thread Concurrency: 0
[OK] InnoDB File per table is activated
[!!] InnoDB buffer pool / data size: 128.0M/471.5M
[!!] Ratio InnoDB log file size / InnoDB Buffer pool size (75 %): 96.0M * 1/128.0M should be equal to 25%
[--] 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: 96.75% (75039 hits/ 77560 total)
[!!] InnoDB Write Log efficiency: 57.54% (229 hits/ 398 total)
[OK] InnoDB log waits: 0.00% (0 waits / 169 writes)

-------- AriaDB Metrics ----------------------------------------------------------------------------
[--] AriaDB is enabled.
[OK] Aria pagecache size / total Aria indexes: 128.0M/368.0K
[!!] Aria pagecache hit rate: 88.9% (425 cached / 47 reads)

-------- 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: MIXED
[--] XA support enabled: ON
[--] Semi synchronous replication Master: OFF
[--] Semi synchronous replication Slave: OFF
[--] This is a standalone server

-------- Recommendations ---------------------------------------------------------------------------
General recommendations:
    Control warning line(s) into /usr/local/mysql/data/srv.likeakinginc.com.err file
    Control error line(s) into /usr/local/mysql/data/srv.likeakinginc.com.err file
    Set up a Secure Password for mariadb.sys@localhost user: SET PASSWORD FOR 'mariadb.sys'@'SpecificDNSorIp' = PASSWORD('secure_password');
    MySQL was started within the last 24 hours - recommendations may be inaccurate
    Configure your accounts with ip or subnets only, then update your configuration with skip-name-resolve=1
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries which have no LIMIT clause
    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)
    tmp_table_size (> 16M)
    max_heap_table_size (> 16M)
    table_definition_cache(400) > 1711 or -1 (autosizing if supported)
    performance_schema = ON enable PFS
    innodb_buffer_pool_size (>= 471.5M) if possible.
    innodb_log_file_size should be (=32M) if possible, so InnoDB total log files size equals to 25% of buffer pool size.
root@srv:~#
 
add/modify your mysql config, at [mysqld] section:
query_cache_size=0
query_cache_type=0
tmp_table_size=256M
max_heap_table_size=256M
table_definition_cache=2000
innodb_buffer_pool_size=1G
innodb_buffer_pool_instances=1
and restart mariadb
 
also i am getting many erros on openlitespeed server. and guessing this is affecting too.

Code:
2020-11-15 00:15:02.612226    ERROR    Hostname [*] on listener [104.237.9.154:80] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 00:15:02.612295    ERROR    Hostname [*] on listener [104.237.9.154:443] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 01:59:49.425595    ERROR    Hostname [*] on listener [104.237.9.154:80] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 01:59:49.425656    ERROR    Hostname [*] on listener [104.237.9.154:443] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 02:01:04.743442    ERROR    Hostname [*] on listener [104.237.9.154:80] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 02:01:04.743495    ERROR    Hostname [*] on listener [104.237.9.154:443] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 19:49:10.915751    ERROR    Hostname [*] on listener [104.237.9.154:80] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 19:49:10.915804    ERROR    Hostname [*] on listener [104.237.9.154:443] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 20:03:02.834865    ERROR    Hostname [*] on listener [104.237.9.154:80] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 20:03:02.834931    ERROR    Hostname [*] on listener [104.237.9.154:443] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
 
add/modify your mysql config, at [mysqld] section:
query_cache_size=0
query_cache_type=0
tmp_table_size=256M
max_heap_table_size=256M
table_definition_cache=2000
innodb_buffer_pool_size=1G
innodb_buffer_pool_instances=1
and restart mariadb
thank you, i will edit now just find on google how to do it :)
 
is this right? /etc/my.cfn

Code:
[mysqld]
max_allowed_packet=64M
local-infile=0
innodb_file_per_table

[client]
socket=/usr/local/mysql/data/mysql.sock

did i do it right?

Code:
[mysqld]
max_allowed_packet=64M
local-infile=0
innodb_file_per_table

query_cache_size=0
query_cache_type=0
tmp_table_size=256M
max_heap_table_size=256M
table_definition_cache=2000
innodb_buffer_pool_size=1G
innodb_buffer_pool_instances=1

[client]
socket=/usr/local/mysql/data/mysql.sock
 
Last edited:
yes, all correct with my.cnf
thank you so much. i got feeling it will be a little fast now.
i appreciate you.

do u have suggestion the openlitespeed server?
about error i posted

Code:
2020-11-15 00:15:02.612226    ERROR    Hostname [*] on listener [104.237.9.154:80] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 00:15:02.612295    ERROR    Hostname [*] on listener [104.237.9.154:443] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 01:59:49.425595    ERROR    Hostname [*] on listener [104.237.9.154:80] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 01:59:49.425656    ERROR    Hostname [*] on listener [104.237.9.154:443] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 02:01:04.743442    ERROR    Hostname [*] on listener [104.237.9.154:80] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 02:01:04.743495    ERROR    Hostname [*] on listener [104.237.9.154:443] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 19:49:10.915751    ERROR    Hostname [*] on listener [104.237.9.154:80] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 19:49:10.915804    ERROR    Hostname [*] on listener [104.237.9.154:443] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 20:03:02.834865    ERROR    Hostname [*] on listener [104.237.9.154:80] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
2020-11-15 20:03:02.834931    ERROR    Hostname [*] on listener [104.237.9.154:443] is mapped to virtual host [104.237.9.154], can't map to virtual host [hostname]!
 
Back
Top