Close connetion

--0016361e7f1c96e38004990a8b73
Content-Type: text/plain; charset=ISO-8859-1

Hi everyone:

I've a problem , this is error http://pastebin.com/eCEqLQ9b , i've looking
in for google and documentation of mysql and nothing.

there any way to close connections with any command of mysql, i've
modification the timeout and connexion number

--
Mit forever
My Blog
My Faborite Web
http://www.technologyreview.com/

--0016361e7f1c96e38004990a8b73--

Re: Close connetion

Nothing is coming up at that url, so I"m afraid we can't be of much help.

The normal practice on this list is to put relevant information in the
email posting.

- michael dykman

On Tue, Jan 4, 2011 at 2:47 PM, Rafael Valenzuela wrote:
> Hi everyone:
>
> I've a problem , this is =A0 error http://pastebin.com/eCEqLQ9b , i've lo=
oking
> in for google and documentation of =A0mysql =A0and nothing.
>
> there any way to close connections with any command of mysql, =A0i've
> modification the =A0timeout and connexion number
>
> --
> Mit forever
> My Blog
> My Faborite Web uter-Science/index.htm>
> http://www.technologyreview.com/
>



--=20
=A0- michael dykman
=A0- mdykman@gmail.com

=A0May the Source be with you.

--
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

Re: Close connetion

On 1/4/2011 14:47, Rafael Valenzuela wrote:
> Hi everyone:
>
> I've a problem , this is error http://pastebin.com/eCEqLQ9b , i've looking
> in for google and documentation of mysql and nothing.
>
> there any way to close connections with any command of mysql, i've
> modification the timeout and connexion number
>

Any user with the SUPER privilege should be able to use the KILL command
to tell a MySQL client connection to self-terminate. Note, MySQL does
not have a way to force-close a connection; the must see that it was
flagged to stop and clean up after itself.

Stopping a long-running command may require a rollback. Rollbacks may be
up to 30x slower to unwind than the command itself required to make the
pending changes. Be aware of this as you evaluate your options.

http://dev.mysql.com/doc/refman/5.1/en/kill.html
http://dev.mysql.com/doc/refman/5.1/en/innodb-tuning.html

--
Shawn Green
MySQL Principal 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: Close connetion

--00163631020d55727504990bf9ca
Content-Type: text/plain; charset=ISO-8859-1

THX Shawn Green i going to try this soluctions

2011/1/4 Shawn Green (MySQL)

> On 1/4/2011 14:47, Rafael Valenzuela wrote:
>
>> Hi everyone:
>>
>> I've a problem , this is error http://pastebin.com/eCEqLQ9b , i've
>> looking
>> in for google and documentation of mysql and nothing.
>>
>> there any way to close connections with any command of mysql, i've
>> modification the timeout and connexion number
>>
>>
> Any user with the SUPER privilege should be able to use the KILL command to
> tell a MySQL client connection to self-terminate. Note, MySQL does not have
> a way to force-close a connection; the must see that it was flagged to stop
> and clean up after itself.
>
> Stopping a long-running command may require a rollback. Rollbacks may be up
> to 30x slower to unwind than the command itself required to make the pending
> changes. Be aware of this as you evaluate your options.
>
> http://dev.mysql.com/doc/refman/5.1/en/kill.html
> http://dev.mysql.com/doc/refman/5.1/en/innodb-tuning.html
>
> --
> Shawn Green
> MySQL Principal Technical Support Engineer
> Oracle USA, Inc.
> Office: Blountville, TN
>



--
Mit forever
My Blog
My Faborite Web
http://www.technologyreview.com/

--00163631020d55727504990bf9ca--