wmjsql is a WindowMaker dock app that monitors the status of a MySQL server. It
is based on the jDockApp library from Jettero Heller. Information is available
at:
http://www.voltar.org/dockapps/

MySQL information available from:
http://www.mysql.com

What it does...
----------------
The application connects to a local or remote database server and collects the
following statistics:
Threads: The number of threads currently running on the server. 
OT: Number of currently open tables.
SQ: Slow queries delta (number since last check).
QPS, QPM: Queries per second/minute answered during the last interval.
Max: The maximum queries per x rate seen since the application started.
Failure: If a connection to the server can not be set up, the contents of the
window are replaced with the text 'failure' in red. Things will return to 
normal once the server is back on line.

As the slow query, query rate and Max values are based on deltas, they will 
not appear at first when the application is started. Once a second status is 
collected, they are calculated and displayed.

Configuration
-------------

wmjsql will attempt to locate its configuration file in the default location,
$HOME/.wmjsqlrc. This behavior is overridden with the command line -c option. 
The file is made up of a brief series of key:value pairs. A sample:

host:localhost
user:username
password:password
frequency:60
port:3306
granularity:minute

What each of these mean:
host: The name of the MySQL server. Use localhost if the server is running on the
	same box as the dock app. localhost is the default.
user: The MySQL username to use. Make sure that this account is configured to 
	allow select access from the specified host.
password: The password for this account. For security purposes, please use an
	account that has only select access from a finite number of hosts and
	that the configuration file is only readable by the owner.
frequency: How often the server should be polled in seconds. Default is 60.
port: The port on which to connect to the server. The default is 3306 and most
	likely will not need to be changed.
granularity: This sets the Query Per value to either seconds or minutes. The 
	default is Queries per Second, but on a less busy server Queries per
	Minute may be more interesting.

Any of the keys with specified default values can be omitted. Only user and 
password do not default.

Command Line Options
--------------------

There are three valid command line options:

-s <sec>  : The number of seconds between updates. Setting this overrides the 
	value in the configuration file.
-c <filename>  : Indicates where to find the configuration file. Default location
	is '$HOME/.wmjsqlrc'.
-h   : Display help on command line options.

Contact
-------

Please feel free to contact me with any questions, comments, complaints or 
patches. Thanks,
Jay <jay@munsterman.com>

