Load Testing · Senior · Question 53 of 76
How do you test a long-running database migration's impact?
- 1Run normal traffic and measure latency while the migration runs
- 2Run it at night, because night traffic is always zero
- 3Run the migration on an empty database and time it
Show the answer
Correct answer: Run normal traffic and measure latency while the migration runs
Explanation
Migrations can lock tables or saturate I/O. The risk is user impact during the migration, so measure exactly that, with prod-sized data.