[MDEV-7577] LOAD DATA INFILE is fast on a master but generates much more I/O when replicated Created: 2015-02-12 Updated: 2015-02-12 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Replication |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | Stoykov (Inactive) | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | replication | ||
| Description |
|
LOAD DATA INFILE is intended for fast, bulk imports into MySQL. This works pretty well. However, when replicating the content of the file is saved to bin logs on the master, but on the slave, it is: This extra step 2 generates unneeded I/O and can slow the process on the downstream slaves. One thought is to convert the LOAD DATA INFILE content when writing the bin logs into a "normal RBR binlog stream”, This feature request is created to document a previous discussion on that topic with the MariaDB engineering team. |