Aikesheng Open Source Community
Sep 18, 2020 · Databases
Safely Replaying Large MySQL Dump Files Using PV to Limit Production Impact
This article demonstrates how to create a test database, export data with mysqldump, and then replay a large SQL dump into a busy MySQL instance while throttling the import speed with the pv tool to keep CPU usage low and avoid disrupting ongoing business operations.
DatabasesMySQLPV
0 likes · 2 min read