Many database queries

patrickkasie

Verified User
Joined
Sep 21, 2021
Messages
241
Location
Een echte Hollander
Dear DirectAdmin forum,

I have noticed a spike of MySQL queries being lined up without understanding why or how they are happening. Is this a problem, or is this regular use? My first instinct is that this is not normal behavior I'm looking at here.

I acknowledge the similar IP addresses starting with 93. It has also happened with IP addresses starting with 102 or 105 on a later date.

Code:
This is an automated message notifying you that the 5 minute load average on your system is 27.37.
This has exceeded the 10 threshold.

One Minute      - 74.01
Five Minutes    - 27.37
Fifteen Minutes - 10.07

top - 20:11:01 up 1 day,  9:17,  0 users,  load average: 76.09, 28.58, 10.55
Tasks: 292 total,  82 running, 210 sleeping,   0 stopped,   0 zombie
%Cpu(s): 58.6 us, 41.4 sy,  0.0 ni,  0.0 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st
KiB Mem :  3879968 total,   226212 free,  2738632 used,   915124 buff/cache
KiB Swap:  1048572 total,  1036992 free,    11580 used.   835240 avail Mem 

  PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+ COMMAND
  860 mysql     20   0 1669508 275684   6996 S  56.3  7.1 109:26.67 /usr/sbin/mysqld
24945 crystal   20   0  298764  23476   5040 R   2.9  0.6   0:02.15 php-fpm: pool crystal
24950 crystal   20   0  298764  23460   5036 R   2.9  0.6   0:02.10 php-fpm: pool crystal
24954 crystal   20   0  302860  27304   5036 R   2.9  0.7   0:01.68 php-fpm: pool crystal
24962 crystal   20   0  302860  27328   5032 R   2.9  0.7   0:01.66 php-fpm: pool crystal
24968 crystal   20   0  302860  26248   5040 R   2.9  0.7   0:01.54 php-fpm: pool crystal
24984 crystal   20   0  300748  23932   5036 R   2.9  0.6   0:01.32 php-fpm: pool crystal
25027 crystal   20   0  302860  26052   5036 R   2.9  0.7   0:01.48 php-fpm: pool crystal
25189 crystal   20   0  300812  24264   5040 R   2.9  0.6   0:01.31 php-fpm: pool crystal
25191 crystal   20   0  302796  26220   5036 R   2.9  0.7   0:01.49 php-fpm: pool crystal
25192 crystal   20   0  300812  24236   5040 R   2.9  0.6   0:01.33 php-fpm: pool crystal
25195 crystal   20   0  302860  25492   5036 R   2.9  0.7   0:01.42 php-fpm: pool crystal
25230 crystal   20   0  298700  22776   5024 R   2.9  0.6   0:01.30 php-fpm: pool crystal
25251 crystal   20   0  300748  24704   5036 R   2.9  0.6   0:01.32 php-fpm: pool crystal
24943 crystal   20   0  298700  23464   5036 R   1.9  0.6   0:02.09 php-fpm: pool crystal
24944 crystal   20   0  298764  23488   5040 R   1.9  0.6   0:02.15 php-fpm: pool crystal
24946 crystal   20   0  300812  24344   5044 R   1.9  0.6   0:02.18 php-fpm: pool crystal
24949 crystal   20   0  302860  25736   5036 R   1.9  0.7   0:01.50 php-fpm: pool crystal
24951 crystal   20   0  298764  23448   5036 R   1.9  0.6   0:02.01 php-fpm: pool crystal
24957 crystal   20   0  302796  27132   5016 R   1.9  0.7   0:01.65 php-fpm: pool crystal
24960 crystal   20   0  299176  23688   5036 R   1.9  0.6   0:01.89 php-fpm: pool crystal
24967 crystal   20   0  298764  23372   5032 R   1.9  0.6   0:01.67 php-fpm: pool crystal
24969 crystal   20   0  298764  23280   5036 R   1.9  0.6   0:01.73 php-fpm: pool crystal

Connection counts:
      1 114.119.139.70
      1 40.77.167.33
      1 40.77.167.43
      1 50.225.222.218
      1 54.36.148.12
      1 54.36.148.46
      1 66.249.76.134
      1 92.67.140.57
      1 93.158.91.250
      1 93.158.91.252
      2 93.158.91.239
      2 93.158.91.241
      2 93.158.91.244
      2 93.158.91.253

IP '93.158.91.253' currently has '2' connections

Connection info for '93.158.91.253':
tcp6      32      0 37.97.169.253:443       93.158.91.253:50571     CLOSE_WAIT 
tcp6       0      0 37.97.169.253:443       93.158.91.253:48789     TIME_WAIT  

Top Memory Usage:
mysql      860  5.4  7.1 1669508 275684 ?      Ssl  Jan30 109:31 /usr/sbin/mysqld
root      1636  0.0  2.4 333132 93136 ?        S    03:11   0:00 spamd child
root      1635  0.0  2.4 333132 93136 ?        S    03:11   0:00 spamd child
root      1632  0.0  2.4 333132 96092 ?        Ss   03:11   0:12 spamd
named     2538  0.0  1.5 247492 60372 ?        Ssl  Jan30   0:01 /usr/sbin/named -u named -c /etc/named.conf
apache   28805  0.1  0.9 2163116 35752 ?       Sl   00:11   1:44 /usr/sbin/httpd -DFOREGROUND
apache   28643  0.1  0.8 2294360 34056 ?       Sl   00:11   1:32 /usr/sbin/httpd -DFOREGROUND
root       868  0.0  0.7 1930680 27700 ?       Ssl  Jan30   0:41 /usr/local/directadmin/directadmin server --syslog
crystal  25027  1.3  0.7 302860 27432 ?        S    20:09   0:01 php-fpm: pool crystal
crystal  24977  1.4  0.7 302860 27400 ?        R    20:09   0:01 php-fpm: pool crystal

Virtual Memory Info:
procs -----------------------memory---------------------- ---swap-- -----io---- -system-- --------cpu-------- -----timestamp-----
 r  b         swpd         free         buff        cache   si   so    bi    bo   in   cs  us  sy  id  wa  st                 CET
42  0        11580       150044           24       916824    0    0    66    44   24   96   6   4  90   0   0 2024-01-31 20:11:09
32  0        11580       169440           24       916856    0    0    12   457 2617 7832  60  40   0   0   0 2024-01-31 20:11:10
58  0        11580       165660           24       916876    0    0    80   318 2480 7666  59  41   0   0   0 2024-01-31 20:11:11

Current MySQL Queries
21901    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '297' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21904    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '297' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21905    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '107' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21906    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '59' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21909    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '300' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21913    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '199' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21917    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '211' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21918    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
21919    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '189' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21921    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '85' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21923    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
21925    crystal_db    localhost    crystal_db    Query    0    Removing tmp table    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '1') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '244' AND cd.language_id = '1' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21926    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '279' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21927    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '85' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21928    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '107' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21929    crystal_db    localhost    crystal_db    Query    0    Removing tmp table    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '245' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21930    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21931    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '101' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'    0.000
21932    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '221' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21933    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
21935    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '221' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21936    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '151' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21937    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '159' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21938    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '179' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21939    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '269' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'    0.000
21940    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '225' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21941    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '308' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21942    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '127' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21943    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '115' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21944    crystal_db    localhost    crystal_db    Query    0    Removing tmp table    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '270' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21945    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '67' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21946    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '67' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21947    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '59' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21948    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '304' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21949    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '319' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21950    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '293' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21951    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '298' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21952    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '310' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21953    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '91' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21954    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '179' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21955    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '173' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21956    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '103' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21957    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '91' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21958    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '308' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21960    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '99' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21961    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '61' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21962    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '167' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21963    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '115' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21964    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '274' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21965    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '113' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21966    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '239' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21967    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '101' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'    0.000
21968    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '111' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21969    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '179' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21970    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '308' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21971    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '195' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21972    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '167' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21973    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '320' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21974    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '167' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'    0.000
21975    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '113' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21976    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '296' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21977    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '298' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21978    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '75' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21979    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '199' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21980    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '298' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21981    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '89' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'    0.000
21982    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '269' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'    0.000
21983    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '67' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21984    crystal_db    localhost    crystal_db    Query    0    Removing tmp table    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '83' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21985    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '269' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21986    crystal_db    localhost    crystal_db    Query    0    Removing tmp table    SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '207' AND cd.language_id = '2' AND c2s.store_id = '0'  AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)    0.000
21987    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
21988    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
21989    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
21990    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
21991    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
21992    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
21993    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
21994    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
21995    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
21996    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
21997    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
21998    crystal_db    localhost    crystal_db    Sleep    1        NULL    0.000
21999    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
22000    crystal_db    localhost    crystal_db    Sleep    1        NULL    0.000
22001    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
22002    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
22003    crystal_db    localhost    crystal_db    Sleep    1        NULL    0.000
22004    crystal_db    localhost    crystal_db    Sleep    2        NULL    0.000
22005    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
22006    crystal_db    localhost    crystal_db    Query    0    Sending data    SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_description_seo cds ON (c.category_id = cds.category_id AND cds.language_id = '2') LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '131' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'    0.000
22008    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
22009    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
22010    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
22011    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
22012    crystal_db    localhost    crystal_db    Sleep    0        NULL    0.000
22013    da_admin    localhost    NULL    Query    0    starting    SHOW FULL PROCESSLIST    0.000


================================
Automated Message Generated by DirectAdmin 1.658
 
it 's ddos, trying check in "Resource Limits" page when happend again.
Compare if there have any high usage cpu/ram/task.
 
Forgive me for the basic question, but I do not seem to know where a "Resource Limits" page would be located at in DirectAdmin. It's not in the Control Panel.
 
I know this has been a month ago, but what are some more tools besides using TransIP's servers, and using CloudFlare? We're renting servers from a datacenter that's supposedly protecting us from volumetric DDOS attacks, but not with this kind of DDOS
 
Not fond of transIP, but this is what they say on there site:

Our VPSs are automatically protected against DDoS attacks. You should mainly think of larger attacks in which our systems determine that the traffic to your VPS is suspicious, or your VPS cannot handle the traffic.

Attacks that use little bandwidth, or small packets, etc. can slip through this protection.
The rule here is that these are minor attacks that have little impact on the functioning of your VPS. Your server can handle such a small attack, but since incoming and outgoing traffic counts towards your Traffic Pool, a small attack can have a negative impact on it. Thorough monitoring of the traffic on your VPS is therefore certainly recommended.

If you are hit by a DDoS attack in which our DDoS protection is (automatically) activated, the traffic will be 'cleaned'. The DDoS traffic is routed and normal traffic then continues to your VPS. If the attack is very large, your VPS will automatically be temporarily made untraceable for all traffic to and from your VPS.We cannot provide further details and numbers for security reasons.


So i guess the attack is not big enough for their system to protect you.

Looking at your stats tho:

KiB Mem : 3879968 total, 226212 free, 2738632 used, 915124 buff/cache
KiB Swap: 1048572 total, 1036992 free, 11580 used. 835240 avail Mem

4GB MEM
1GB SWAP?

Still 2GB (ish) free and almost full swap.

4GB is not a lot of memory and swap is recommended to be 2GB.
 
Not fond of transIP, but this is what they say on there site:




So i guess the attack is not big enough for their system to protect you.
Yeah they've told me so about that, which is why I've mentioned volumetric DDOS attacks. But yeah, the server does let us know about that incident and that its load is at 74, last time was 50, but that's aight.

Btw why are you not fond of TransIP? I know it's off-topic, perhaps this should be asked elsewhere, but since you've mentioned it...
 
You are misunderstood about anti-ddos.

Anti-ddos from datacenter isn't fully secure your server. if you want to fight ddos, you need to adjust firewall in your server, like csf firewall and you need more server resource like 16Core, 32gb ram. to fight super hyper ddos attack.

because ddos-bot doesn't use only one IPs, they can use multiple IP, multi devices to rape your server.
 
Back
Top