[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
https://groups.google.com/forum/#!topic/comp.databases.oracle.misc/Uhba-9Yh_uk

(with apologies: feature request is not an available option on the issue-type dropdown)


Generated at Thu Feb 08 08:21:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.