I am using Percona Server for MySQL 8.0.x. I have setup replication between two instances with GTID mode turned OFF. Almost all UPDATE and INSERTS are wrapped in the transaction from the application side.
On the slave server when looking at the binlog coming from master, I noticed there are lots of empty transactions. What are those and why are they present in the binlog when there is nothing to be executed in that transaction.
/*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; # original_commit_timestamp=1587391567871055 (2020-04-20 14:06:07.871055 UTC) # immediate_commit_timestamp=1587391567871055 (2020-04-20 14:06:07.871055 UTC) /*!80001 SET @@session.original_commit_timestamp=1587391567871055*//*!*/; /*!80014 SET @@session.original_server_version=80019*//*!*/; /*!80014 SET @@session.immediate_server_version=80019*//*!*/; SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/; SET TIMESTAMP=1587391567/*!*/; BEGIN /*!*/; COMMIT/*!*/;