Skip to content

Instantly share code, notes, and snippets.

@isopropylcyanide

isopropylcyanide/connector-lostevent-mysql-binlog-check.sh

Created February 5, 2021 20:05
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 isopropylcyanide/d69fae1c124bcacd0113f8e22483befe to your computer and use it in GitHub Desktop.
Save isopropylcyanide/d69fae1c124bcacd0113f8e22483befe to your computer and use it in GitHub Desktop.
Download ZIP
connector-lostevent-mysql-binlog-check.sh
Raw
connector-lostevent-mysql-binlog-check.sh
# Note the oldest binlog file position
mysql -u <> -h <> -e "show binary logs";
# Know the offset in the oldest binlog and its timestamp T
mysqlbinlog -vv /usr/local/var/mysql/mysql-bin.000038 --base64-output=DECODE-ROWS | less --base64-output=DECODE-ROWS
# If timestamp of lost event <= T, events have not rolled over (yet).
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment