Skip to content

Instantly share code, notes, and snippets.

View lukavia's full-sized avatar

Anton Avramov lukavia

View GitHub Profile
@lukavia
lukavia / mysqlbinlog-stats
Last active January 9, 2021 20:28
Print statistic from mysql/mariadb binary logs by number of operations on tables. You can add additional filters from mysqlbinlog, like --start-datetime, --stop-datetime, etc
#!/bin/sh
mysqlbinlog --base64-output=decode-row --verbose "$@" \
| grep '^###.*`.*`.`' \
| sort \
| uniq -c \
| sort -nr
Verifying that +lukavia is my blockchain ID. https://onename.com/lukavia