Re: [Maria-developers] More Secure Kill Command

2013-08-16 Thread Roberto Spadim
Sorry Sergei i didn't read your email before sending more one... "Yes, my thought exactly. It'd be pretty easy to extend KILL to support killing by query_id, not by thread_id." some points that i think important... the "KILL [QUERY | CONNECTION] " is well know in mysql world, changing it to "KILL

Re: [Maria-developers] More Secure Kill Command

2013-08-16 Thread Roberto Spadim
yeah i liked this idea about query_id too... thread_id + query_id is a nice solution (at least i think it will work) i was considering query start time too, but since kill isn't a command with very high frequency (kills/second), the query_id could solve the problem nicely the only problem i can se

Re: [Maria-developers] More Secure Kill Command

2013-08-16 Thread Roberto Spadim
hi! i think it too complex.. i should send two SQL command!? i already know what thread and what query i want to kill... why should i send it twice? 2013/8/17 Jean Weisbuch > PEBKAC... > > If you want more safety then make a script like molly-guard that will ask > you to confirm the kill comma

Re: [Maria-developers] More Secure Kill Command

2013-08-16 Thread Sergei Golubchik
Hi, Eric! On Aug 16, Eric Bergen wrote: > As part of adding per query table/index statistics I added a per > thread query_id. This would serve your purpose too. You could do kill > connection_id query_id and be guaranteed of killing the query you want > on a specific connection. Yes, my thought e

[Maria-developers] Joining the team

2013-08-16 Thread Esteban Orduno
Hi, all: I would like to contribute to the maria-db team. Who can I talk iniatially to get some type of orientation about it? Esteban Orduno ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Uns

Re: [Maria-developers] More Secure Kill Command

2013-08-16 Thread Jean Weisbuch
PEBKAC... If you want more safety then make a script like molly-guard that will ask you to confirm the kill command you want to execute to avoid mistakes. Le 16/08/2013 23:31, Roberto Spadim a écrit : Hi guys i was mailing at maria-discuss, but i think it a new feature, and want some view poi

Re: [Maria-developers] More Secure Kill Command

2013-08-16 Thread Eric Bergen
As part of adding per query table/index statistics I added a per thread query_id. This would serve your purpose too. You could do kill connection_id query_id and be guaranteed of killing the query you want on a specific connection. On Fri, Aug 16, 2013 at 2:31 PM, Roberto Spadim wrote: > Hi guys

[Maria-developers] More Secure Kill Command

2013-08-16 Thread Roberto Spadim
Hi guys i was mailing at maria-discuss, but i think it a new feature, and want some view point from developers... check this problem: connection 1) big select... connection 2) show processlist connection 1) other query connection 2) kill connection 1 id (i take +- 1 second between show processlist

Re: [Maria-developers] Can there be a better storage engine API?

2013-08-16 Thread Zardosht Kasheff
I've worked on the TokuDB storage engine for quite a while now. I have had many experiences over the years, so I guess it's hard to know where to begin. I guess I will start small, and if the conversation evolves, I can contribute more thoughts. I think the current API is really good, as evidenced

Re: [Maria-developers] Review of patch for MDEV-4820

2013-08-16 Thread Kristian Nielsen
Ok, I've pushed to 10.0-base a patch for MDEV-4820. revid:kniel...@knielsen-hq.org-20130816131025-etjrvmfvupsjzq83 As far as I can determine (and I checked quite carefully), this fixes all the problems you mentioned in the bug description and in your test cases. But I could have misunderstood som

Re: [Maria-developers] MariaDB 10.0.4 Release Prep

2013-08-16 Thread Alexander Barkov
Hi Daniel. On 08/16/2013 05:36 AM, Daniel Bartholomew wrote: All, I've begun prep work for the MariaDB 10.0.4 release. Draft Release Notes and Changelogs are here: - https://kb.askmonty.org/en/mariadb-1004-release-notes/ Can you please join these two items into a single item with two senten