Join the community today
Become a Member

MySQL Runs at 100% during attack

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by Oxide, Jul 10, 2020.

  1. rdan

    rdan Well-Known Member

    5,439
    1,397
    113
    May 25, 2014
    Ratings:
    +2,186
    Local Time:
    5:51 AM
    Mainline
    10.2
    Then limit_req that specific page and other comment attack URI.
    To something sensitive settings like 15 per seconds only.


    Yeah, that will surely solve this issue.
     
  2. rdan

    rdan Well-Known Member

    5,439
    1,397
    113
    May 25, 2014
    Ratings:
    +2,186
    Local Time:
    5:51 AM
    Mainline
    10.2
    I tried that setup and not satisfied with the IO speed.
    Looks like common speed you also got from OVH :).

    This is the fastest Disk I ever got.
    [​IMG]
     
  3. Oxide

    Oxide Active Member

    534
    29
    28
    Mar 19, 2015
    Ratings:
    +59
    Local Time:
    7:51 AM
    You reckon that would help with the database?

    I do not have any big queries, rather lots of small ones. That one is quite pricey tho.

    43 euro extra per drive
     
  4. rdan

    rdan Well-Known Member

    5,439
    1,397
    113
    May 25, 2014
    Ratings:
    +2,186
    Local Time:
    5:51 AM
    Mainline
    10.2
    Based on my experience, Yes.