maria-developers team mailing list archive

[Marian Marinov <mm@xxxxxxxx>]

Hi Roberto,
MDEV-4623 is does exactly what I want in a different manner.

I have a similar thing as MDEV-4427 written as MySQL plugin. Unfortunately this have one very big problem. It sometimes 
breaks tables. I have seen even InnoDB tables broken by this type of intervention :( I can't reproduce it very easy for 
InnoDB, but for MyISAM it should be pretty easy.
Also killing query, even one that takes a lot of resources may result in a loss of data, which in turn says, that the 
service is bad.

My opinion is, we should either accept a query and try to execute it while preventing resource starvation or we should 
deny it. It is very bad to accept it and then kill it in the middle of its work.
This is a DataBase, it should either accept data or not.

Marian

On 06/24/2013 08:15 PM, Roberto Spadim wrote:
> hi marian, could you see MDEV-4623 and MDEV-4427, and tell me if that could help you?
>
> MDEV-4623 <https://mariadb.atlassian.net/browse/MDEV-4623> - https://mariadb.atlassian.net/browse/MDEV-4623 -
> lock/unlock connection
> MDEV-4427 <https://mariadb.atlassian.net/browse/MDEV-4427> - https://mariadb.atlassian.net/browse/MDEV-4427 - twitter
> like patch (this one is to kill a query, but after MDEV-4623 we could use lock connection)