Is it possible to configure MySQL to have different max_connections limit based on either user or host which is connecting to server?


I mean, suppose we have max_connections=500, is it possible to say that from all external clients there could be at max 490 connections, while a single host or user can have at max 10 connections? Obviously, if host who has "reserved" 10 connections uses a single connection each time, should always find a free connection to the server, even if all other servers have reserverd 490 connections.

Of course, I did take a look at "resources per hour" features, but they don't fit my need, since I need a "instant" control, not a "per hour" control.

Any hint?

Bye, Alberto.

--
http://stain.giovani.it (italian blog)


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to