MySAR

Collects MySQL runtime and configuration information
Download

MySAR Ranking & Summary

Advertisement

  • Rating:
  • License:
  • GPL
  • Price:
  • FREE
  • Publisher Name:
  • Gerardo Narvaja
  • Publisher web site:
  • https://launchpad.net/~gnarvaja

MySAR Tags


MySAR Description

Collects MySQL runtime and configuration information 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.Options List: --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' (default: mysar) --purge Specify the number of days to keep in the table(s) being updated. --process Record the processlist (default: off). Requirements: · Perl What's New in This Release: · I plan to add other information as well in future releases.


MySAR Related Software