Aikesheng Open Source Community
Aug 26, 2019 · Databases
Controlling mysqldump Insert Batch Size with --net-buffer-length to Avoid Large Transactions
This article explains how mysqldump’s --net-buffer-length option can be used to split INSERT statements into manageable batches, defines large transactions, shows performance testing with different buffer sizes, and concludes that the default settings already avoid large transactions and provide acceptable import performance.
MySQLPerformance Testingdatabase backup
0 likes · 8 min read