Skip to content

Instantly share code, notes, and snippets.

@flug

flug/mysql bin log

Created November 10, 2017 09:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save flug/2ae402ba80e5e4a585089a2d12fe32f5 to your computer and use it in GitHub Desktop.
Save flug/2ae402ba80e5e4a585089a2d12fe32f5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql bin log
# mysqlbinlog mysql-bin.005757 | grep -i -e "^update" -e "^insert" -e "^delete" -e "^replace" -e "^alter" | cut -c1-100 | tr '[A-Z]' '[a-z]' | sed -e "s/\t/ /g;s/\`//g;s/(.*$//;s/ set .*$//;s/ as .*$//" | sed -e "s/ where .*$//" | sort | uniq -c | sort -nr | head -50
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment