I am doing a large import (~300GB – MyISAM) into a MySQL server version
5.6.48 within a FreeBSD jail, before starting I did:
SET GLOBAL bulk_insert_buffer_size = 1024 * 1024 * 1024; SET GLOBAL net_buffer_length=1000000; SET GLOBAL max_allowed_packet=1000000000; SET foreign_key_checks = 0;
The dump started to load but after a while, the server memory RAM/SWAP got full and the
mysqld process exited.
What I notice and surprised me is that when the MySQL server came up again, the
source command continued to load the dump, kind of “resuming” the process.
From the docs, I haven’t found much documentation about the
source command, only from the MySQL shell:
mysql> source ERROR: Usage: \. <filename> | source <filename>
Therefore wondering what is keeping the state or track of the inserted data and how could I check/monitor the
source progress, besides willing to understand if this “resume” option is the expected behavior and if it could be configured.