Skip to content

Instantly share code, notes, and snippets.

@rhemz

rhemz/gist:1c6912987398dc203461293dcacba98f

Created February 27, 2017 18:43
Show Gist options
  • Save rhemz/1c6912987398dc203461293dcacba98f to your computer and use it in GitHub Desktop.
Save rhemz/1c6912987398dc203461293dcacba98f to your computer and use it in GitHub Desktop.
Download ZIP
poll mysql processlist, output to csv
Raw
gistfile1.txt
while sleep 5; do mysql -u dbuser -p$MYSQLPW -e "SELECT HOST, COMMAND, TIME, STATE, SUBSTRING(INFO, 1, 100) AS INFO, ROWS_SENT, ROWS_EXAMINED FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY HOST, TIME DESC INTO OUTFILE '//path/to/dir/mysqlproclist_$(date +%s).csv' FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'"; done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment