Alberto Mucignat <[EMAIL PROTECTED]> wrote: > 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?
A dirty hint: write a script which will run SHOW PROCESSLIST each second and hmm.. enforce restrictions. Somehow, but not killing threads. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
