BestHub
Sign in
Tagged articles
3 articles
Page 1 of 1
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.

MySQL Shelldata importimport_table
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
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.

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