building large database uploads is a pain in the ass
Commit
193fa5f
In what way?
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 size of the table and isn't capped at all. In my case a ~9 GB searchindex table pushed MariaDB from 1.4 GB to over 8 GB. With autocommit on, it stayed flat at ~1.5 GB.
commit 193fa5f