I'm importing around 9 million rows into my MySQL DB using the following command:
SET autocommit=0;
SOURCE my_import.sql;
COMMIT;
The command line is no longer outputting lines of
What could be going on here? Is it safe to assume that my import has finished and I can kill the terminal?
Query OK, X rows affected...
, and SELECT COUNT(*)
query confirms that all the rows are there. Additionally, I'm no longer seeing an increase in my database size and the CPU/IOPS activity is very low.
However, I'm anxious that the command line cursor has not returned:

Asked by Jonathan
(188 rep)
Jul 26, 2015, 11:33 AM
Last activity: Oct 3, 2019, 09:00 AM
Last activity: Oct 3, 2019, 09:00 AM