The Ultimate Guide to High Availability with MariaDB

Batch insert mode for INSERTS

You are viewing an old version of this article. View the current version here.

MariaDB ColumnStore has the ability to utilize the cpimport fast data import tool for non-transactional “LOAD DATA INFILE’ and “INSERT INTO SELECT FROM” SQL statements. Using this method results in a significant increase in performance in loading data through these two SQL statements.

There are two variables that can be used:

  • The infinidb_use_import_for_batchinsert variable is used to control if cpimport is used for these statements. This variable may be set as a default for the instance, set at the session level, or at the statement level by toggling this variable on and off.
  • The infinidb_import_for_batchinsert_delimiter variable is used internally by MariaDB ColumnSTore on a non-transactional INSERT INTO SELECT FROM statement as the default delimiter passed to the cpimport tool. With a default value ascii 7, there should be no need to change this value unless your data contains ascii 7 values.

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.