mkill (MySQL kill) monitors a MySQL server for long running queries and kills them after a specified time interval. Queries can be selected based on regexes on the user, host, command, database, state and query.
Other mysql utilities
New feature to 'fold' select columns in main display so you can see more of the WHERE clause. Use the F key to fold or the --fold option from the command line. Also, includes mkill.PL which was missing from the v0.6.5 distribution.2004-09-12 v0.6.5:
Minor fix to no longer require connection to test database.2003-06-20 v0.6.4:
Fixed negative slave offsets. Just show 0. Since the slave position is checked after the master position, it might be a bit ahead.
Fixed slave offsets where the master and slave are on different logfiles. Instead of showing a wierd number, show '> master position' since we know that we're at least that far behind plus any other intervening log files.
Fixed Mac OSX curses bugs.
Added documentation for new features. Expanded documentation on the header section.2002-07-01 v0.6.2:
Comments are now stripped from monitor winodw. Comments will still appear in the zoom/explain views. Also removed leading spaces from display columns.2002-05-18 v0.6.1:
Added replication status page (screen command 'r'). This page updates similar to the main screen. Three types of replication status are shown on this page: 1) master servers running on this machine, 2) slave servers running on this machine, 3) slave servers attached to this master.2002-03-07 v0.5.1:
Added new vars and stats screens. The stats screen updates until a key is pressed. The vars screen shows the page and returns to the main screen.
Moved some of the common key handling routines into functions.
Reduced the amount of space statistics numbers take by only showing 2-4 significant digits.
Added mysqld memory usage for localhost in main header. Currently uses /proc fs and only works for root or mysql user because either the pidfile may not have permissive permissions or the proc directory may not.2002-02-18 v0.4.1:
Resolved some install path issues with certain perl installs.2002-01-18 v0.3.1:
Screen refresh was broken in 0.1.1. This has been fixed. A manual refresh mode was added to simulate the 'broken' behavior. A couple of other fatal runtime errors were fixed. An option was added to the install process to allow installation in a directory other than the perl binary location. Use the --prefix option to 'perl Makefile.PL'. A keyboard command to clear mysqld variables was added.
Copyright (C) 2002, Marc Prewitt/Chelsea Networks
$Id: index.html,v 1.15 2004/09/13 11:25:06 mdprewitt Exp $
|Site Hosted By SourceForge.net