← Back to team overview

maria-developers team mailing list archive

Re: RFC: Pausing a query thread


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.


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)

Follow ups