Analyzing MySQL Binlogs
Channel: Southern California Linux Expo
Date: 2018-03-09

Talk by Franck Leveneur

How many transaction does the database handle per table, per hour? Which table has the most inserts? Do we delete data from this table? Which hour has the highest peak of updates, and on which tables? These are common questions asked frequently to DBAs. Although Performance schema and Sys answer many questions it does not allow to track this type of granularity. By parsing the binlogs, analyzing them, and summarizing them in a table, you can answers all these questions in no time.

More info at: https://www.socallinuxexpo.org/scale/16x/presentations/analyzing-mysql-binlogs