Anthony Stanton elblivion
diafygi
/ slow_query_log_dump.py
Created
December 16, 2011 04:38
— forked from memonic/cronjob.sh
Script to transform Amazon RDS slow log table into the MySQL slow query log format
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| """ | |
| Queries the slowlog database table maintained by Amazon RDS and outputs it in | |
| the normal MySQL slow log text format. Modified version of the script by | |
| memonic (Thanks!) at https://gist.github.com/1481025 | |
| Things to change in this script for your own setup: | |
| <root_user> to your mysql root user (e.g. "root") | |
| <root_pass> to your mysql root password (e.g. "hunter2") | |
| <host_domain> to your mysql root password (e.g. "prod-01.w3rfs2.us-east-1.rds.amazonaws.com") |