После kill-9 и запуска шустро обрабатывает квадратики, но через некоторое время начинает замедляться и в конце концов виснет.
Код:
| 16765 | billing | 10.0.6.8:43019 | bgbilling | Query | 0 | updating | DELETE FROM log_incoming_session_10_201602 WHERE source_id=7 AND hour='2016-02-13 07:00:00' | 0 | 37736 | 1 |
| 16766 | billing | 10.0.6.8:43032 | bgbilling | Query | 13 | Waiting for table metadata lock | LOCK TABLES log_session_10_201602 WRITE, log_incoming_session_10_201602 WRITE | 0 | 0 | 1 |
| 16767 | billing | 10.0.6.8:43033 | bgbilling | Query | 1 | Waiting for table metadata lock | LOCK TABLES log_session_10_201602 WRITE, log_incoming_session_10_201602 WRITE | 0 | 0 | 1 |
| 16780 | billing | 10.0.6.8:60376 | bgbilling | Sleep | 0 | | NULL | 0 | 0 | 2 |
| 16785 | billing | 10.0.6.8:38960 | bgbilling | Sleep | 7 | | NULL | 0 | 0 | 2 |
| 16786 | billing | 10.0.6.8:32911 | bgbilling | Sleep | 0 | | NULL | 1 | 6 | 2 |
| 16787 | billing | 10.0.6.8:43057 | bgbilling | Query | 26 | Waiting for table metadata lock | LOCK TABLES log_session_10_201602 WRITE, log_incoming_session_10_201602 WRITE | 0 | 0 | 1 |
| 16788 | billing | 10.0.6.8:42800 | bgbilling | Sleep | 0 | | NULL | 0 | 0 | 2 |
| 16789 | billing | 10.0.6.8:43062 | bgbilling | Query | 34 | Waiting for table metadata lock | LOCK TABLES log_session_10_201602 WRITE, log_incoming_session_10_201602 WRITE | 0 | 0 | 1 |
| 16790 | billing | 10.0.6.8:43063 | bgbilling | Sleep | 0 | | NULL | 1 | 0 | 3 |
| 16791 | billing | 10.0.6.8:43066 | bgbilling | Sleep | 0 | | NULL | 1 | 0 | 3 |
| 16792 | billing | 10.0.6.8:43067 | bgbilling | Query | 30 | Waiting for table metadata lock | LOCK TABLES log_session_10_201602 WRITE, log_incoming_session_10_201602 WRITE | 0 | 0 | 1 |
| 16793 | billing | 10.0.6.8:43068 | bgbilling | Sleep | 0 | | NULL | 0 | 1 | 1 |
| 16794 | billing | 10.0.6.8:43082 | bgbilling | Query | 22 | Waiting for table metadata lock | LOCK TABLES log_session_10_201602 WRITE, log_incoming_session_10_201602 WRITE | 0 | 0 | 1 |
| 16795 | billing | 10.0.6.8:43119 | bgbilling | Query | 9 | Waiting for table metadata lock | LOCK TABLES log_session_10_201602 WRITE, log_incoming_session_10_201602 WRITE | 0 | 0 | 1 |
| 16796 | billing | 10.0.6.8:43138 | bgbilling | Sleep | 0 | | NULL | 1 | 0 | 697 |
| 16797 | billing | 10.0.6.8:43141 | bgbilling | Query | 18 | Waiting for table metadata lock | LOCK TABLES log_session_10_201602 WRITE, log_incoming_session_10_201602 WRITE | 0 | 0 | 1 |
| 16798 | billing | 10.0.6.8:43144 | bgbilling | Query | 5 | Waiting for table metadata lock | LOCK TABLES log_session_10_201602 WRITE, log_incoming_session_10_201602 WRITE | 0 | 0 | 1 |