156559 - mysqld-watcher.pl should kill multiple queries at once, quicker, and with better notification

Status: RESOLVED FIXED

(Bugzilla :: Bugzilla-General, defect)

Description

[Myk Melez [:myk] [@mykmelez]]

[not sure in which component to file contrib/ scripts]

mysqld-watcher.pl should kill all queries that have taken too long to run, not
just the longest running one.  Also, it should kill queries after 3 minutes (at
the most); queries taking more time than that are unlikely to ever return. 
Finally, it should output more information about the queries it kills, f.e. the
full query string, so admins can more effectively fix slow-running queries.

Comment 1

[Myk Melez [:myk] [@mykmelez]]

Attachment: patch v1: implementation

Oh yeah, and this script shouldn't include globals.pl, since it doesn't use it
and since doing so means it has to be moved to the Bugzilla root directory to
work, whereas without that line it can live happily in the contrib directory
cleverly slaughtering its queries from there.

dmose- Can you give these changes the once-over to make sure I'm not
egregriously violatingy your code?

Comment 2

[Dan Mosedale (:dmosedale, :dmose)]

Comment on attachment 90689 [details] [diff] [review]
patch v1: implementation

rheeet=dmose

Comment 3

[Myk Melez [:myk] [@mykmelez]]

Checking in mysqld-watcher.pl;
/cvsroot/mozilla/webtools/bugzilla/contrib/mysqld-watcher.pl,v  <-- 
mysqld-watcher.pl
new revision: 1.3; previous revision: 1.2
done