MySQL Forums
Forum List  »  InnoDB clusters

Re: MySQL 8.0 InnoDB Cluster Size of Transactions
Posted by: Frederic Descamps
Date: January 22, 2021 04:10AM

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,

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 8.0 InnoDB Cluster Size of Transactions
126
January 22, 2021 04:10AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.