On Wed, Jun 30, 2010 at 8:29 AM, Shawn Green (MySQL) <shawn.l.gr...@oracle.com> wrote: > 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
That is the solution. It is worth note that the facebook patch set has a new variable "reserved_super_connections" which defaults to 10. It would be very useful to have this feature in mainline MySQL. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org