MySQL loop execution kill statement kills connection

When creating an index in MySQL, has been stuck, just beginning to think it may be too large data volume caused, but has been waiting for a long time or no response, it appears that the operation of the table is locked, execute show processlist really found a lot of lock, using kill ID Kill the connection alone is possible, but very stupid, not strong enough, here is a big trick: 1, find all connection ID generation Kill ID; Text in format

2. SELECT concat (' KILL ', id, '; ') From information_schema.processlist to OUTFILE ' d/lock.txt ';

3, execute the script in the text: source d/lock.txt;

MySQL loop execution kill statement kills connection