Did they ddo me on mysql?

Question

MySQL

Hello.
The load has sharply increased, although the online constant is not so big. But, it immediately began to rise. Screenshots.

Is there any way to check the number of connections and requests in real time through the console? And how to eliminate ddos?

Answer 1

Couldn't you arrange this for yourself?
Check if you get a 404 error, such a request to the database is not formed?

Answer 2

Look through mytop

Answer 3

It is possible to throw in telegraph in influxdb - tincture of 5 minutes. And from there draw a dashboard in graphana. Of course, it is better to do this before the load has stopped. Perhaps the insert select ratio has simply changed and the cache has become inefficient, or there is no index somewhere, where requests have become more frequent (you need to look at the plan).

Answer 4

Obviously you have a hole somewhere, you got access to the database and they throw requests. Is there a web site? It can be seen from the lines that the game server. So you won’t understand right away. You need to look at all the connection strings to the database from the outside and how it is implemented.