We had an
ALTER TABLE statement that added a new column which was taking quite a long time on status
copying to tmp table
Given we did not know how long it will take we decided to kill the query in MySQL using kill.
Now the query is on status killed but still blocks the whole table and except for the CPU being 100% the kill does not seem to have any effect.
How does the kill work and can I get a status indication of the time it will take?