Hi. MySQL already reserves one connection to users with the process privilege. So assure that common clients don't have the process privilege and you connect with one that has it and you are done.
This is documented here (found no other place): http://www.mysql.com/doc/T/o/Too_many_connections.html Bye, Benjamin. On Wed, Dec 12, 2001 at 11:40:03AM +0000, [EMAIL PROTECTED] wrote: > Hi, > > I'd like to be able to reserve some connections to the MySQL > server for emergencies - eg. someone issued a slow query and locked out > several hundred updates from several hundred other connections. > > Currently in this sort of situation, it is possible to completely > run out of connections and then the only solution is to restart mysqld > or just wait for the slow query to end. > > Would it be possible to add a feature to MySQL so that a configurable > number of connections are reserved for a configurable list of users ? > Then, an administrator would always be able to connect and clear any > blockages. -- [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
