How do I need to set up mysql to withstand the load of bot requests?

sanhpv

mysql How do I set it up to withstand the bot's load?

The bot's request causes my CPU to reach 100%, so how can I handle the bot's load?

This is a bot request

i am using vps contabo
4 vCPU Cores
6 GB RAM
or 400 GB SSD

sanhpv

helpme

aaPanel_Kern

First check whether the robot is accessing normally? If there are too many accesses, you can first ban their IP access.
Note that there are also bad guys using the same UA for access. You can try 2-4G running configuration for mysql