MySQL 8 Query Performance Tuning: A Systematic Method for Improving Execution Speeds

© Jesper Wisborg Krogh 2020

J. W. KroghMySQL 8 Query Performance Tuninghttps://doi.org/10.1007/978-1-4842-5584-1_25

25. DDL and Bulk Data Load

Jesper Wisborg Krogh¹ 

(1)

Hornsby, NSW, Australia

 

From time to time, it is necessary to perform schema changes or to import large amount of data into a table. This may be to accommodate a new feature, restore a backup, import data generated by a third-party process, or similar. While the raw disk write performance is naturally very important, there are also several things you can do on the MySQL side to improve the performance of these operations.

Tip

If you have problems that restoring your backups takes too long, consider switching to a backup method that copies the data files directly (a physical backup) ...