Most of the time I like pt-kill
, but sometimes it gets a
little overzealous and kills a query that I need. That's why I'm
glad Percona created pt-reanimate
so I can bring
those important queries back to life. Of course the queries are
not exactly the same when they come back, but at least they come
back.
Here's an example of pt-reanimate
in action. First I
add a column to a large table:
alter table big_table add column new_col int;
Here is my DDL in the processlist table:
+---------+------+----------------+----------------------------------------------+
| command | time | state | info |
+---------+------+----------------+----------------------------------------------+
| Query | 146 | altering table | alter table big_table add column
new_col int | …