MySQL Workbench表数据导入向导非常慢 [英] MySQL workbench table data import wizard extremely slow

问题描述

我需要将具有2000万行和2列的csv文件导入数据库，但是当我尝试使用MySQL Workbench的数据导入向导执行此操作时，它的运行速度非常慢，可能需要1个月才能完成，看起来在进度条上.

I need to import a csv file with 20 million rows and 2 columns into a database, but when I try to do this with MySQL Workbench's data import wizard it is extremely slow, probably is going to take 1 month to finish, looking at the progress bar.

我希望必须有一些更快的方法.

There has to be some faster way to do this, I hope.

推荐答案

始终将Load Data Infile用作处理大量数据的第一次尝试.

Always use Load Data Infile as a first attempt for huge sets of data.

Mysql手册页.

Mysql Manual page on Load Data Infile.

为这个问题写了几个答案，但是为了与同龄人比较，请看这个人的问题和我的答案以及他的时间比较工作台vs加载数据文件中的内容.

Wrote up several answers for this question, but for a peer comparison, see this guy's question and my Answer and his time comparisons of Workbench vs Load Data Infile.

这篇关于MySQL Workbench表数据导入向导非常慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！