Sample Header Ad - 728x90

Is my import still committing?

-1 votes
1 answer
414 views
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 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: enter image description here What could be going on here? Is it safe to assume that my import has finished and I can kill the terminal?
Asked by Jonathan (188 rep)
Jul 26, 2015, 11:33 AM
Last activity: Oct 3, 2019, 09:00 AM