building large database uploads is a pain in the ass
Commit
b4ed22e
I have problems with RAM spikes during importing one single >10GB database.. I'm not really sure why, still in debugging mode.
My RAM issues come from SET @@AUTOCOMMIT=0 in the dump, likely written by the backup tool.
For a table with a FULLTEXT index, InnoDB defers the full-text indexing of new rows until the transaction commits and keeps the bookkeeping in memory until then. So memory grows with the…