MyRocks and Group Commit with Binary log
You are viewing an old version of this article. View
the current version here.
MyRocks supports group commit with the binary log.
Counter values to watch
(This is only necessary if you are studying MyRocks internals) MariaDB's group commit counters are:
Binlog_commits - how many transactions were written to the binary log
Binlog_group_commits - how many group commits happened. (e.g. if each group had two transactions, this will be twice as small as Binlog_commits)
On the RocksDB side, there is one relevant counter:
Rocksdb_wal_synced - How many times RocksDB's WAL file was synced. Multiple sync requests may share the same sync operation (this is RocksDB's internal group commit)
TODO: So for a workload with concurrency=50, n_queries=10K, one gets
- Binlog_commits=10K
- Binlog_group_commits=794
- Rocksdb_wal_synced=8362
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
