Query mass kill

Pokud mysql napr. opravuje velkou tabuli, pak dalsi query do teto tabulky cekaji az oprava dobehne. Pokud je oprava dlouha a query caste, pak muze snadno dojit k prekroceni connection limitu. Snadno pozabijet cekajici query lze tak, ze je podle nejakeho klice seselectujeme a do souboru nechame vygenerovat prislusny command, ktery pak spustime:

mysql> select concat('KILL ',id,';') from information_schema.processlist where info like 'INSERT INTO users_log_sessions_steps%' AND db like 'earmyshop_cz_' into outfile '/tmp/kill-earmy';

mysql> source /tmp/kill-earmy;