On 6/30/2010 6:56 AM, Machiel Richards wrote:
Good day all
Sorry one more question.
I have seen many questions about this on the web but no
resolution yet.
When MySQL runs out of threads, you are unable to stop /
restart the database.
Is there a way to reserve threads for the root user /
database restarts?
Yes. Don't give normal users the SUPER privilege.
http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_super
Your applications and non-administrative users should be using accounts
with the least privileges necessary to to their jobs. That way the
"extra connection" allocated to the SUPER user accounts will not be
consumed with non-administrative activities.
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org