List:General Discussion« Previous MessageNext Message »
From:Rafael Valenzuela Date:January 4 2011 9:29pm
Subject:Re: Close connetion
View as plain text  
THX Shawn Green i going to try this soluctions

2011/1/4 Shawn Green (MySQL) <shawn.l.green@stripped>

> 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 <http://www.redcloverbi.wordpress.com>
My Faborite
Web<http://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm>
http://www.technologyreview.com/

Thread
Close connetionRafael Valenzuela4 Jan
  • Re: Close connetionMichael Dykman4 Jan
  • Re: Close connetionMySQL)4 Jan
    • Re: Close connetionRafael Valenzuela4 Jan