MySAR Publisher's description
from Gerardo Narvaja
MySAR is a Perl script that collects information from a MySQL running server and stores it in a DB so it can later be queried and manipulated by other tools.
MySAR is a Perl script that collects information from a MySQL running server and stores it in a DB so it can later be queried and manipulated by other tools. Currently is capable of storing the results of SHOW GLOBAL STATUS and SHOW GLOBAL VARIABLES. The project is currently licensed under GPL v2.
--host < hostname > Connect to a remote host to perform tests (default: localhost)
--socket < socket > Use a different socket for a local connection
--port < port > Port to use for connection (default: 3306)
--user < username > (required) Username to use for authentication
--pass < password > (required) Password to use for authentication
--variables Gather the global variables values
--status Gather the global status values
You need to specify at least one of the options above
--varfile File with the list of variables to monitor. (default: all)
--statfile File with the list of status variables to monitor (default: all)
For variables/status specification you may use '%' as wildcard
--database Specifies which schema contains the tables 'value_var' & 'value_stat'
--purge Specify the number of days to keep in the table(s) being updated.
--process Record the processlist (default: off).
System Requirements:No special requirements.
Program Release Status: Minor Update
Program Install Support: Install and Uninstall