Tip: try the myvars module (for example: moodss myvars --host myhost),
and optimize your server configuration very efficiently, by simply
comparing each variable value with its corresponding documentation
(only a mouse move away thanks to the balloon help on the variable
name). Take a similar approach for dynamic values by also loading the
mystatus module.
### CHANGES ###
--- version 15.5 ---
completely redesigned MySQL myvars and mystatus modules:
- added support for 4.x servers
- removed support for 3.22.x servers
- only display variables returned by the server during the modules
initialization phase in order to reduce the risk of internal
errors due to the many different servers configurations in the
field
- dynamic help (through widget tips (balloons)) is now drawn
directly from the MySQL documentation for greater accuracy
- displayed variable names are now strictly those returned by the
corresponding 'SHOW VARIABLES' and 'SHOW STATUS' queries
- in mystatus module, added separate table for queries counters
- successfully tested with 3.23.47 and 4.0.1 servers
in sensors module, forgot to close pipe in local host case
in sensors module, added support for values with no limits, such as
vid
viewers and thresholds with cells pointing to a non existing module
would fail (could happen if a module was unloaded prior to saving to
a file and then opening that same file)
moomps daemon:
- added --pid-file option for saving process ID in a file at startup
- could crash when loading old configuration files with viewers
other than summary tables
- added rpm specification file to tarball so that rpms can be
rebuilt directly
- in rpm, try to add moomps user even when upgrading, not only
installing
- in rpm, eventually stop moomps daemon when uninstalling or
upgrading
- in rpm, use process ID file for daemon management
module development: column labels no longer need new lines (except for
forced formatting) as widget tips (balloons) now wrap lines
automatically
fixed potential bug when loading a module with a new view from an
older save file
### README ###
This is moodss (Modular Object Oriented Dynamic SpreadSheet) version
15.5.
Moodss won in the Best System Admin Technology category (Tcl Tips and
Tricks, Valuable Real World Programming Examples) at the O'Reilly
Tcl/Tk 1999 Conference.
Linux Magazine calls it a "lifesaver".
Tucows gives it 5 stars (cows or penguins :-).
Moodss is a modular application. It displays data described and
updated in one or more modules, which can be specified in the command
line or dynamically loaded or unloaded while the application is
running. Data is originally displayed in tables. Graphical views
(graph, bar, 3D pie charts, ...), summary tables (with current,
average, minimum and maximum values) and free text viewers can be
created from any number of table cells, originating from any of the
displayed viewers. Thresholds can be set on any number of cells.
Moomps (shipped with moodss) is a monitoring daemon which works using
configuration files created by moodss. Thresholds, when crossed,
create messages in the system log, and eventually trigger the sending
of email alert messages.
Specific modules can easily be developed in the Tcl, Perl and Python
scripting languages or in C.
A thorough and intuitive drag'n'drop scheme is used for most viewer
editing tasks: creation, modification, type mutation, destruction,
... and thresholds creation. Table rows can be sorted in increasing or
decreasing order by clicking on column titles. The current
configuration (modules, tables and viewers geometry, ...) can be saved
in a file at any time, and later reused through a command line switch,
thus achieving a dashboard functionality.
The module code is the link between the moodss core and the data to be
displayed. All the specific code is kept in the module package. Since
module data access is entirely customizable (through C code, Tcl,
Perl, Python, HTTP, ...) and since several modules can be loaded at
once, applications for moodss become limitless.
For example, thoroughly monitor a dynamic web server on a single
dashboard with graphs, using the Apache, MySQL, ODBC, cpustats,
memstats, ... modules. If you have replicated servers, dynamically add
them to your view, even load the snmp module on the fly and let your
imagination take over...
Along with a core trace module, arp, cpustats, diskstats, interrupts,
kernmods, memstats, minimal, mounts, netdev, pci, ps, random, route,
sensors, system modules for Linux, MySQL (myprocs, myquery, mystatus,
myvars), odbcquery, ping, snmp, snmptrap for UNIX, apache and apachex,
Minimal and Random Perl modules, minipy and randpy Python modules are
included. Running "wish moodss ps cpustats memstats" mimics the "top"
application with a graphic edge and remote monitoring capability.
Thorough help is provided through menus, widget tips, a message area,
a module help window and a global help window with a complete HTML
documentation.
Moodss is multi-langual thanks to Tcl internationalization
capabilities. So far only English and partially French are
supported. Help with other languages will be very warmly welcomed.
Development of moodss is continuing and as more features are added in
future versions, backward module code compatibility will be maintained.
I cannot thank the authors of the tkTable, BLT, MIME/SMTP and the HTML
libraries enough for their great work.
In order to run moodss, you need to install the following packages
(unless you can use the rpm utility, see below):
Tcl/Tk 8.3.1 or above, at (or at a mirror near you)
http://dev.scriptics.com/ or ftp://ftp.scriptics.com/
the latest tkTable widget library at:
http://tktable.sourceforge.net/
the latest BLT library at:
ftp://tcltk.sourceforge.net/pub/tcltk/blt/
eventually the latest tclperl library for writing modules in Perl, or
the latest tclpython library for writing modules in Python at:
http://jfontain.free.fr/
(see the INSTALL file for complete instructions, for UNIX and also
Windows platforms).
You also have the option of using the moodss rpm file (also in my
homepage), if you are using a Redhat Linux system (6.0 or above).
You can find the required tcl, tk, tktable, blt, tcpperl and other
rpms at: http://jfontain.free.fr/
Whether you like it (or hate it), please let me know. I would like to
hear about bugs and improvements you would like to see. I will correct
the bugs quickly, especially if you send me a test script (module code
with a data trace would be best).
###
you may find it now at my homepage:
http://jfontain.free.fr/moodss-15.5.tar.bz2
http://jfontain.free.fr/moodss-15.5-1.i386.rpm
http://jfontain.free.fr/moomps-1.1-1.i386.rpm
http://jfontain.free.fr/moodss-15.5-1.spec
Enjoy and please let me know what you think.
Jean-Luc (mailto:[EMAIL PROTECTED])
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
