...
maintenance_work_mem
parameter (buffer for index rebuild routines)max_wal_size
parameterMySQL and it's forks are pretty similar to PostgreSQL in available techniques and best practices [1]. MySQL also has COPY
command [2], which is the fastest data load method, reducing a lot parsing and network overhead. MySQL also advises to disable indexes, unique and FK constraints. But as MySQL is index-organized database and has key-value MyISAM engine, there are two unique points:
[1] https://dev.mysql.com/doc/refman/8.0/en/insert-optimization.html
[2] https://dev.mysql.com/doc/refman/8.0/en/load-data.html
[3] https://dev.mysql.com/doc/internals/en/bulk-insert.htmlTODO
TODO
...