Reserving threads for root user

------=_NextPart_000_013A_01CB1853.B2097EB0
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_013B_01CB1853.B2097EB0"


------=_NextPart_001_013B_01CB1853.B2097EB0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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?



Current version running: 5.0.72sp1-enterprise-gpl-log



Machiel Richards

MySQL DBA

Relational Database Consulting



RDC_Logo




------=_NextPart_001_013B_01CB1853.B2097EB0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" =
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" =
xmlns:odc=3D"urn:schemas-microsoft-com:office:odc" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" =
xmlns:rtc=3D"http://microsoft.com/officenet/conferencing" =
xmlns:D=3D"DAV:" xmlns:Repl=3D"http://schemas.microsoft.com/repl/" =
xmlns:mt=3D"http://schemas.microsoft.com/sharepoint/soap/mee tings/" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/x ml" =
xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/oi s/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/di rectory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sub=3D"http://schemas.microsoft.com/sharepoint/soap/20 02/1/alerts/"=
xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#" =
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/soap" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " =
xmlns:udcp2p=3D"http://schemas.microsoft.com/data/udc/partto part" =
xmlns:wf=3D"http://schemas.microsoft.com/sharepoint/soap/wor kflow/" =
xmlns:dsss=3D"http://schemas.microsoft.com/office/2006/digsi g-setup" =
xmlns:dssi=3D"http://schemas.microsoft.com/office/2006/digsi g" =
xmlns:mdssi=3D"http://schemas.openxmlformats.org/package/200 6/digital-sig=
nature" =
xmlns:mver=3D"http://schemas.openxmlformats.org/markup-compa tibility/2006=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns:mrels=3D"http://schemas.openxmlformats.org/package/200 6/relationshi=
ps" xmlns:spwp=3D"http://microsoft.com/sharepoint/webpartpages" =
xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/2006/types"=
=
xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/2006/messag=
es" =
xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ SlideLibrary/=
" =
xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor talServer/Pub=
lishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" =
xmlns:st=3D"
" xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">

Re: Reserving threads for root user

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.h tml#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=gcdmg-mysql-2@m.gmane.org

Re: Reserving threads for root user

On Wed, Jun 30, 2010 at 8:29 AM, Shawn Green (MySQL)
wrote:
> On 6/30/2010 6:56 AM, Machiel Richards wrote:
>>
>> Good day all
>>
>>
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Sorry one more question.
>>
>>
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0I have seen many questions about this on =
the web but no
>> resolution yet.
>>
>>
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0When MySQL runs out of threads, you are u=
nable to stop /
>> restart the database.
>>
>>
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Is 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.h tml#priv_supe=
r
>
> Your applications and non-administrative users should be using accounts w=
ith
> the least privileges necessary to to their jobs. That way the "extra
> connection" allocated to the SUPER user accounts will not be consumed wit=
h
> 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.


--=20
Rob Wultsch
wultsch@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg