Analyzing MySQL Binlogs
How many transaction does the database handle per table, per hour? Which table has the most inserts? Does it affect replication lag? Do we delete data from this table? Which hour has the highest peak of updates, and on which tables? By parsing MySQL binlogs , analyzing them, and summarizing them in a table, not only you can answers all these questions but you can also quickly find out potential transactions that can affect Mysql replication lag.