exceedingly long queries running that never completed, filling up MySQL
-
I’m getting exceedingly long queries running that never completed, filling up MySQL connection slots effectively bringing it down:
+
| 405497 | digitalr_TEN | localhost | digitalr_TEN | Query | 30554 | update | INSERT INTO cerber_lab (ip, reason_id, details, stamp) VALUES (“185.56.80.242″,333,””,1534054592) |
| 405520 | sciencet_ten | localhost | sciencet_ten | Query | 30403 | update | INSERT INTO cerber_lab (ip, reason_id, details, stamp) VALUES (“18.222.194.243″,40,””,1534054743) |
| 405649 | taxbrack_TCN | localhost | taxbrack_TCN | Query | 29928 | update | INSERT INTO cerber_lab (ip, reason_id, details, stamp) VALUES (“18.222.253.52″,40,””,1534055218) |
| 405661 | sciencet_ten | localhost | sciencet_ten | Query | 29883 | Waiting for table level lock | INSERT INTO cerber_lab (ip, reason_id, details, stamp) VALUES (“34.207.102.158″,40,””,1534055263) |
| 405691 | taxbrack_TCN | localhost | taxbrack_TCN | Query | 29823 | Waiting for table level lock | INSERT INTO cerber_lab (ip, reason_id, details, stamp) VALUES (“18.222.194.243″,40,””,1534055323) |
| 405740 | kiklogin_ten | localhost | kiklogin_ten | Query | 29682 | update | INSERT INTO cerber_lab (ip, reason_id, details, stamp) VALUES (“185.86.164.102″,40,””,1534055464) |
| 405754 | digitalr_TEN | localhost | digitalr_TEN | Query | 29654 | Waiting for table level lock | INSERT INTO cerber_lab (ip, reason_id, details, stamp) VALUES (“185.56.80.242″,8,”a:1:{s:3:\”uri\”;s |
| 405803 | kiklogin_ten | localhost | kiklogin_ten | Query | 29534 | Waiting for table level lock | INSERT INTO cerber_lab (ip, reason_id, details, stamp) VALUES (“185.85.191.201″,40,””,1534055612) |The page I need help with: [log in to see the link]
- The topic ‘exceedingly long queries running that never completed, filling up MySQL’ is closed to new replies.