• Resolved Tnace

    (@radiocure1)


    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]

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘exceedingly long queries running that never completed, filling up MySQL’ is closed to new replies.