Limiting the numbr of req / sec by user

netswitch

Verified User
Joined
Dec 15, 2003
Messages
224
Location
Belgium
Hello,

Recently one of users had his page scanned by googlebot, and it generated up to 130 req / sec, throwing our server on the knees and crashing.

The only thing I could do (after spending hours to find where was coming the load from, I was thinking about a ddos..) is suspend his account.

Now I have banned the searchbots from his site using htaccess but I would like to be able to limit the number of request/sec a user can launch to the mysql server.

Is this possible ?

How ?


Regards.
 
Yes, those settings are a part of the grant command and can be modified through an application such as phpmyadmin or through the command line if you know what commands you want to run. Personally I wouldn't mind this being a configuration in DirectAdmin to automatically set newly created databases with a specified settings, but thats later in the future, possibly.
 
Back
Top