Help!!!!!!
I’m trying to load a 2 million row input file into a table and it just never returns.
I did a sample load on a few hundred rows and it returns very quickly. However, when I try to load the entire file I can leave it for hours and it just doesn’t come back.
Here’s the ddl for the table:
mysql> show full columns from tst_load;
+-------------+-------------+-------------------+------+-----+---------+-------+---------------------------------+--------------------------------------------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+-------------+-------------+-------------------+------+-----+---------+-------+---------------------------------+--------------------------------------------+
| user_agent | varchar(30) | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | LOOKUP; Size[MB]: 0.1; Ratio: 0.00; unique |
| ip | varchar(15) | latin1_swedish_ci | YES | | NULL | | select,insert,update,references | Size[MB]: 0.1; Ratio: 0.00; unique |
| new_visitor | tinyint(4) | NULL | YES | | NULL | | select,insert,update,references | Size[MB]: 0.1; Ratio: 0.00; unique |
| created | datetime | NULL | YES | | NULL | | select,insert,update,references | Size[MB]: 0.1; Ratio: 0.00; unique |
+-------------+-------------+-------------------+------+-----+---------+-------+---------------------------------+--------------------------------------------+
4 rows in set (0.00 sec)
