if you killed the query and was the wrong one you should have to look better next time. I don't see probable that query ids had to be reused (unless we are talking here from a really uncommon scenario where you make queries fast enough to overflow and get old ids again...)
I recommend you to use innotop [1] or mtop [2] to monitor your long-running queries and kill the right one. Also, there is other kind of information like user and host that you can use to "identify" the query. Remember, this is not MS Windows, so you won't be asked twice :D [1] http://code.google.com/p/innotop/ [2] http://mtop.sourceforge.net/ On Fri, Aug 16, 2013 at 4:48 PM, Roberto Spadim <[email protected]>wrote: > hi guys, i hit a problem in this exact second... > some programs are running and i want to kill only one big query > well i executed > kill 17143 > > ok.. but when i execute this command, the query was done, and starting a > second query... in other words... i killed the wrong query > > could we add a hash information to kill, to make it more secure and > precise? > for example... > > kill 17143 md5 "123456789......." > where md5 = id + start time of query + others informations to make it > relative unique > > maybe it exists and i don't know... any other idea how to solve this? > > thanks > > -- > Roberto Spadim > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > > -- Gabriel Sosa Sometimes the questions are complicated and the answers are simple. -- Dr. Seuss
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
