[MDEV-18585] Annotate_rows_log_event written for each wsrep streaming fragment Created: 2019-02-14 Updated: 2024-01-31 Resolved: 2019-02-18 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Galera |
| Affects Version/s: | 10.4 |
| Fix Version/s: | 10.4.3 |
| Type: | Bug | Priority: | Major |
| Reporter: | Teemu Ollakka | Assignee: | Teemu Ollakka |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Annotate_rows_log_event is written for each wsrep streaming fragment. To reproduce, start servers with the following options:
Run the following statements:
Now binlog contains INSERT statement twice:
This behavior will effectively make replication traffic scale as N^2 with small fragment sizes and bulk inserts with N rows. |
| Comments |
| Comment by Teemu Ollakka [ 2019-02-14 ] | |
|
This is especially pronounced when running sysbench prepare with `binlog-annotate-row-events=ON` and streaming replication enabled:
|