Re: MySQL 8.0 InnoDB Cluster Size of Transactions

[Frederic Descamps]

Hello,

To have a good overview of the size of a transaction, the best is to verify what's written on the binary log.

So before moving to MySQL InnoDB Cluster, I recommend you to verify the size of those trx parsing the binary log (or binlog events).

I've also written a MySQL Shell Plugin that allows you to verify this: https://github.com/lefred/mysqlshell-plugins/wiki/check#showtrxsizesort

binlog_row_image and binlog_transaction_compression also affects this.

Regards,