Discussion:
Close connetion
(too old to reply)
Rafael Valenzuela
2011-01-04 21:29:53 UTC
Permalink
THX Shawn Green i going to try this soluctions
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/
Michael Dykman
2011-01-04 19:56:33 UTC
Permalink
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
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 <http://www.redcloverbi.wordpress.com>
My Faborite Web<http://ocw.mit.edu/OcwWeb/Electrical-Engineering-and-Computer-Science/index.htm>
http://www.technologyreview.com/
--
 - michael dykman
 - ***@gmail.com

 May 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=gcdmg-mysql-***@m.gmane.org
Shawn Green (MySQL)
2011-01-04 20:14:06 UTC
Permalink
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-***@m.gmane.org
Loading...