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. regards, Martin --------------------------------------------------------------------- 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