BestHub
search
Sign in
Tag

import_table

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 27, 2021 · Databases

Efficient Data Import with MySQL Shell import_table and Its Performance Compared to LOAD DATA

This article introduces MySQL Shell’s import_table utility, demonstrates its core features and configuration options such as parallel import, speed throttling, and custom chunk sizes, provides side‑by‑side command examples with LOAD DATA, and shows that import_table can achieve more than double the import speed in practical tests.

MySQLMySQL ShellPerformance
0 likes · 10 min read
Efficient Data Import with MySQL Shell import_table and Its Performance Compared to LOAD DATA
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 10, 2020 · Databases

Custom Row Input with MySQL Shell util.import_table and decodeColumns in MySQL 8.0.22

The article explains how MySQL 8.0.22 enhances the util.import_table function with the decodeColumns option, allowing users to preprocess each row during import, replace load data statements, and customize column values directly within MySQL Shell.

MySQLMySQL Shelldata-import
0 likes · 4 min read
Custom Row Input with MySQL Shell util.import_table and decodeColumns in MySQL 8.0.22
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 24, 2019 · Databases

Using MySQL Shell Util import_table and import_json for Fast Data Import

This article demonstrates how to use MySQL Shell's util.import_table and util.import_json functions to import CSV and JSON data efficiently, compares their performance with the traditional mysqlimport tool, explains required options such as file path, schema, table, dialect, threading, and shows example sessions in both JavaScript and Python modes.

MySQLdata-importimport_json
0 likes · 11 min read
Using MySQL Shell Util import_table and import_json for Fast Data Import