Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
From time to time I will have large structural changes to make on my MySQL DB, things like adding columns, changing datatypes, adding indexes etc. These types of changes result in downtime and what...
Question
mysql
#1: Initial revision
by
Charlie Brumbaugh
·
2020-09-23T20:31:38Z (about 4 years ago)
Is there a way to estimate the execution time of a statement in MySQL?
From time to time I will have large structural changes to make on my MySQL DB, things like adding columns, changing datatypes, adding indexes etc. These types of changes result in downtime and **what I would like to be able to do is produce reasonable estimates of how long the changes will take before I implement them.** Currently my estimates are based on how long similar changes took. Is there a way to estimate ahead of time how long a MySQL statement will take?