Limiting the numbr of req / sec by user

[netswitch]

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.

 

[jmstacey]

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.