Michael, > It would be nice to extend the user permissions table to have per-user > limits like max_user_connections and the various timeouts applying > directly to specific user/host combinations.
As of MySQL 4.0.2, you can set some limits per user. Here's an excerpt from my mysql.user table: +---------------+-------------+-----------------+ | max_questions | max_updates | max_connections | +---------------+-------------+-----------------+ | 0 | 0 | 0 | Zero means the option is disabled for this user. The meaning is (all numbers are per hour): - max_question: number of commands user can send to server, - max_updates: number of changes user can submit, - max_connections: well, I let you guess ;-) http://www.mysql.com/doc/en/User_resources.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] --------------------------------------------------------------------- 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
