I'm importing a large .sql file into my servers MySQL Database,
However the import has only so far imported a few tables and is currently on record ~17mill of one table. However the import pauses after it does every couple thousand record and these pauses are getting longer the more records imported into the table. It's basically going to grind to a halt very soon.
I'm thinking this could be to do with some memory constrictions?
however running iotop shows that jbd2 process is using a huge amount of disk I/O at any time.
could this be a cause? and if so are there any methods to disable the journaling until import is completed?