Kind of tail’ing a mysql binary log

you can’t tail -f a mysqlbinlog, but something like this give the same result ๐Ÿ™‚

# watch "mysqlbinlog /var/log/mysql/mysql-bin.004436 | tail"

4 comments on “Kind of tail’ing a mysql binary log

  1. Krishen September 22, 2015 2:06 am

    Just tried this and it worked! And made me smile ๐Ÿ™‚ Thanks for the tip.

  2. Tit Petriฤ March 31, 2017 10:46 pm

    This is very unfriendly for the system, as mysqlbinlog will read the complete binary file, only to display the last 10 lines with tail. And then every 2 seconds repeat;

    If you want poor mans tailing of the binary log, use the strings tool:

    `tail -f binary-log | strings` – it will display all the strings that are stored into the binary log. If you want to look for some query markers, this is slightly better: `tail -f binary-log | strings | egrep -i ‘(insert|update|delete|replace)’`

    • Joar Jegleim April 10, 2017 3:06 pm

      yep, definitely unfriendly for the system ! your tip works like a charm .
      Thnx for sharing ! ๐Ÿ™‚

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

This site uses Akismet to reduce spam. Learn how your comment data is processed.