Slow running restore mysql
How can I speed up a MySQL restore from a dump file?
Answer Answered by Daniel Black in this comment.
Ask MySQL.
If doing a MariaDB restore, look at having a large enough innodb buffer pool to cover the indexes of the table and an innodb log file size of several gigabytes or more depending how big the SQL file and the speed of storage.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
