Skip to content

David Goodwin

Linux, PHP, geeky stuff … boring man.

  • Home
  • Mastodon
  • GitHub
  • About

Tag: rds

Posted on November 12, 2018November 12, 2018

Finding and killing long running MySQL queries

Sometimes (Woocommerce?) related queries on a MySQL server can seemingly run forever and eventually lead to the server being clogged up (and few free connections).

Something like this can help …. (i.e. kill all MySQL queries which have been running longer than 900 seconds, and aren’t from the ‘root’ user).
Continue reading “Finding and killing long running MySQL queries”

Rummage

Tag Cloud

  • aws (5)
  • azure (8)
  • bash (5)
  • bbcqt (4)
  • beer (4)
  • birmingham (10)
  • brexit (29)
  • bromsgrove (29)
  • btrfs (9)
  • comic (6)
  • debian (17)
  • dns (4)
  • docker (5)
  • Dogs (4)
  • email (5)
  • fail (32)
  • fsck (4)
  • google (4)
  • hockey (6)
  • iptables (4)
  • Java (4)
  • linux (39)
  • mysql (10)
  • NHS (4)
  • nuc (5)
  • performance (4)
  • php (43)
  • phpnw15 (4)
  • Pixel2XL (5)
  • postfix (4)
  • programming (5)
  • rain (6)
  • running (5)
  • security (6)
  • sigh (6)
  • spam (6)
  • sysadmin (18)
  • TheMashReport (4)
  • twitter (77)
  • uksnow (12)
  • varnish (7)
  • win (4)
  • wordpress (15)
  • wtf (5)
  • z3c (4)
Proudly powered by WordPress