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=arch...@jab.org
