Rafael Valenzuela
2011-01-04 21:29:53 UTC
THX Shawn Green i going to try this soluctions
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
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 tolooking
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
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/
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/