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

Reply via email to