maria-developers team mailing list archive
Mailing list archive
Re: RFC: Pausing a query thread
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.
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 -
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)