Annyce Davis

Helping you write beautiful code

  • Home
  • Public Speaking
  • About Me
  • Courses
  • Life

Killing Long Running Processes in MySQL

October 18, 2010 by Annyce Davis Leave a Comment

This should never happen, but it does and so I’m going to tell you one way that I kill stale processes on my MySQL database server:

cat longprocesses.txt | awk ‘{print “kill “$1″;”}’

I run the show full processlist command on MySQL and then copy the list of stale processes to a file that I have named longprocesses.txt. Once that is done I have several lines of code that look like this:

kill 12345;
kill 93479;
….

I then copy this into MySQL or SequelPro and run the kill commands. This is somewhat tedious so I’m looking for a faster way to do this, any ideas, just post a comment. Thanks.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Related

Filed Under: Uncategorized

Newsletter

Start a new tech group on Meetup

Follow Me

Android Dev Summit 2019 Recap

This was my first time attending Android Dev Summit in person.  It was great to come to California and reconnect with many of my Android friends. I put … [Read More...]

Dev Machine Setup – Mobile Development

A new machine. Now what? Time to set it all up. Inevitably I end up going back and forth from my old machine or worse yet, my memory, to figure out what needs … [Read More...]

Categories

  • Android (50)
  • Career (2)
  • Communication (4)
  • Flutter (1)
  • Git (4)
  • Gradle (4)
  • Grails (23)
  • Java (8)
  • JavaScript (6)
  • Kotlin (12)
  • Life (4)
  • Public Speaking (22)
  • RxJava (1)
  • Software Development (3)
  • Twitter (3)
  • Uncategorized (11)
  • Video Course (4)

Copyright © 2021 · Beautiful Pro Theme on Genesis Framework · WordPress · Log in