THX Shawn Green i going to try this soluctions 2011/1/4 Shawn Green (MySQL) <shawn.l.gr...@oracle.com>
> 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/