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
