Re: Server Stopped Responding When Having Around 1000 Request

[Rick James]

> to user should have order by Name in asecnding that is why i would have to do it
The url I gave you explains how to do it _much_ more efficiently -- without LIMIT and OFFSET.

The index will not prevent the problem you are having.

Also, _decreasing_ max_connections will help the system from recovering from the problem when it happens again. And it _will_ happen again.
Recommend
max_connections = 50
Your STATUS shows that you had not used more than 39 simultaneous connections in the 5 days it had been up. 50 will probably be sufficient for your legitimate users, while denying access to the crawler. Still, there will be a brief "freeze" when the crawler does its thing.