News

21-Jun-2011

This version introduces two new major features. The first one refers to a new MySQL statistics multigraph which includes a complete and an overall state of the current performance of a MySQL server. The six nested graphs cover the most important and relevant status information which should help System Administrators to optimize their MySQL server accordingly.

This graph requires an unprivileged MySQL user (with password) in order to collect all the statistics. So it's strongly recommended to NOT grant any privilege to any database to this user.

The following are the two commands in order to create such unprivileged user:

mysql> CREATE USER ’user’@’localhost’ IDENTIFIED BY ‘password’;
mysql> FLUSH PRIVILEGES;
      

Please refer to the monitorix.conf(5) man page for a more detailed information.

The following is an example of the new MySQL graph:

Although almost every value is clearly auto explanatory and they represent the same value collected using SHOW GLOBAL STATUS statement, the monitorix.conf(5) man page includes a detailed description of each option appeared in the Overall Stats graph, since these options are the result of a calculation between two different values.

My very special thanks to Luca Ferrario for his suggestion to add this new graph, for his assistance during all the process, and for being a good friend that made it possible.

The other new major feature introduces support for OpenBSD systems with the same level of accomplishment that Monitorix already has on FreeBSD systems. My special thanks to Devio.us team for giving me a complete free shell account where to put hands to work.

Among of these two special new features, it also includes a new fork() and vfork() rates values (being the later only on BSD systems) that appear in the Context Switches graph. It also improves the way how are shown the Interrupt Devices graphs on Xen guest systems and other interesting enhancements.

Finally a number of important bugs were also fixed. Please refer to the Changes file for all the details.

All users still using older versions are encouraged to upgrade to this one.

IMPORTANT NOTICE: The configuration file monitorix.conf has been extended with important changes.