These bash scripts do the smallest amount of work possible to collect simple MySQL metrics and running SQL queries of a running system for subsequent analysis. These scripts include:
collect-mysql-status
Snapshot of Status, ProcessList and supporting information for 60 secondssample-mysql-queries
SQL sampling (brute force approach) for approximately 20 seconds
These scripts are designed to be executed on a Linux host, and require the mysql
client to be installed, and MySQL credentials to run SQL placed in the $HOME/.my.cnf
file.
NOTE: The output of information of SQL statements may include PII information. It is important data is reviewed and masked.