I have a 1 billion record stored in csv file. I'm using
LOAD DATA INFILE to import the record to the table.
create table weibo_bind ( column1 bigint primary key, column2 bigint );
And my csv file is
LOAD DATA INFILE '/path/to/demo.csv' IGNORE INTO TABLE weibo_bind FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 ROWS;
But how can I debug or how can I check the progress of importing? Because it takes a lot of time to import.
Or is there any way to speed up?
mysql Ver 8.0.22, Innodb