A. masterhost continued to burn ...
What we have.
We rent a server from these beautiful people, one piece and pay them for the administration. Exactly - so that the head about the glands would not hurt and it was not necessary to find out who was to blame - Vasya-administrator or provider. In any case, all questions to the provider.
A letter arrives:
Your queries to the database XXXXXX create an increasedand, of course, examples of queries in the attack (mostly - “select * from xxx where X = 'Y'”, while table xxx is three Ints, with indices for several hundred thousand entries).
MySQL server load Examples of such queries are given.
in the attachment.
Please optimize your scripts, as this
adversely affects the performance of the entire server.
The question of who this server is, where it came from and why our requests are executed on it, and not on our machine, comes the answer:
Your virtual platform uses a standard virtual hosting server.and in response to my letter about the fact that we are not very worried, because we did not ask to use their database server and our requests are our local problem:
All the best.
With increasing load, we will be forced to block access to databases.
... these are the pies with kittens.
Zvinyayte, if emotionally and incomprehensibly - ready to clarify.
PS: for lovers to blame for nagging and inertia - I can say that the removal of all the ugliness from this provider requires a lot of preparatory work (almost completed) and a noticeable amount of change to the move itself. Therefore, still not faded.
upd: the problem was resolved, letters were received from the head of the client administration department and directly from the support engineer; the site is really lured with virtual hosting and therefore threatened with repression
')
Source: https://habr.com/ru/post/9396/
All Articles