[MDEV-15455] LOAD DATA INFILE COMMIT=n parameter Created: 2018-03-02 Updated: 2018-08-13 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Admin statements, Scripts & Clients |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Juan | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | Compatibility, Data, Load | ||
| Description |
|
Suggestion for LOAD DATA INFILE I'd like to suggest that a COMMIT=n (where n>=0) parameter be added to LOAD DATA INFILE to match Oracle's IMP COMMIT=Y BUFFER=n functionality. With the suggestion, COMMIT=0, would be the default and commit only when the LOAD DATA INFILE completes. Otherwise, LOAD DATA INFILE would commit after each set of n lines are processed. This is extremely useful when dealing with data being loaded to columnstore, data that is frequently over a billion rows, too big for a single transaction. https://docs.oracle.com/cd/B10501_01/server.920/a96652/ch02.htm#1005347 (with apologies: feature request is not an available option on the issue-type dropdown) |