I've disabled foreign key checks and indexes while I am bulk inserting millions of records (to speed up the inserts).

Do I have to enable indexes and foreign keys manually or can I just restart the MariaDB instance?

CodePudding user response：

ALTER TABLE always changes the table definition permanently, neither a rollback or a restart of the server will change the table definition.

To enable the index again just execute ALTER TABLE with option INDEX NOT IGNORED.