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]