I’ve finally gotten around to adding the last little things that I wanted to do to version 2 of Statpack - my python script for aggregating SHOW [GLOBAL] STATUS output.
Now it connects to a running instance, and allows you to gather statistics from there to generate reports.
Here are the options it supports:
[markleith@medusa:~/Development/statpack/statpack-v2] $ ./statpack.py
Error: No arguments supplied
usage: ./statpack.py [list of arguments]
Non-interactive mode (aggregate txt files containing SHOW STATUS snapshots):
-f –files List of statistics files to aggregate (–files=stat1.txt[, stat2.txt..])
Argument must be first within list of arguments, on it’s own
Interactive mode (connect to running MySQL server for SHOW STATUS snapshots):