MySQLが突然の死を迎えた時の対処法 ref: http://qiita.com/tbaba/items/3fe24cffabf4e1f0c437

file0.txt

> show processlist;
| 284788 | tbaba | localhost:33573 | forkwell_dev | Sleep   |    1 |                                 | NULL                                                                                                 |
| 285029 | tbaba | localhost:37715 | forkwell_dev | Query   | 3595 | Waiting for table metadata lock | SELECT  DISTINCT `job_endorsements`.`id` AS t0_r0, `job_endorsements`.`job_id` AS t0_r1, `job_endors |
| 285342 | tbaba | localhost:43623 | forkwell_dev | Query   | 3654 | Waiting for table metadata lock | ALTER TABLE `users` DROP `facebook_identifier`                                                       |
| 285347 | tbaba | localhost:43685 | forkwell_dev | Query   | 3599 | Waiting for table metadata lock | SELECT `users`.* FROM `users`  WHERE `users`.`id` IN (9987, 5353, 8381, 9298, 8885, 9979, 519, 5805, |
| 285350 | tbaba | localhost:43717 | forkwell_dev | Query   | 3566 | Waiting for table metadata lock | SELECT  `users`.* FROM `users`  WHERE `users`.`id` = 298 LIMIT 1                                     |
| 285351 | tbaba | localhost:43725 | forkwell_dev | Query   | 3555 | Waiting for table metadata lock | SELECT  `users`.* FROM `users`  WHERE `users`.`id` = 9920 LIMIT 1                                    |
| 285352 | tbaba | localhost:43726 | forkwell_dev | Query   | 3558 | Waiting for table metadata lock | SELECT  `users`.* FROM `users`  WHERE `users`.`id` = 298 LIMIT 1                                     |
| 285353 | tbaba | localhost:43729 | forkwell_dev | Query   | 3555 | Waiting for table metadata lock | SELECT  `users`.* FROM `users`  WHERE `users`.`id` = 298 LIMIT 1                                     |
| 285354 | tbaba | localhost:43731 | forkwell_dev | Query   | 3553 | Waiting for table metadata lock | SELECT  `users`.* FROM `users`  WHERE `users`.`id` = 9545 LIMIT 1                                    |
| 285355 | tbaba | localhost:43736 | forkwell_dev | Query   | 3544 | Waiting for table metadata lock | SELECT  DISTINCT `job_endorsements`.`id` AS t0_r0, `job_endorsements`.`job_id` AS t0_r1, `job_endors |

file1.txt

> kill 284788
Query OK, 0 rows affected (0.00 sec)