Using Stage Tracking function to track DDL progress in mysql 5.7,

This article mainly introduces the use of Stage Tracking function to track the progress of DDL in mysql 5.7. the content of the article is carefully selected and edited by the author, which has a certain pertinence and is of great significance to everyone's reference. the following is to understand with the author the use of Stage Tracking function to track the progress of DDL in mysql 5.7s.

Mysql 5.7performance_schema provides a progress tracking function, which is not very intuitive, but it is quite good.

This feature is disabled by default and needs to be enabled manually:

1meme update performance_schema.setup_instruments SET ENABLED = 'YES', TIMED =' YES' WHERE NAME = 'stage/sql/altering table'

3. In this way, the opening is successful.

Example:

Check the progress through the following sql:

SELECT EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED, (WORK_COMPLETED/WORK_ESTIMATED) * 100 as COMPLETED FROM performance_schema.events_stages_current

After reading the above about using the Stage Tracking function to track the progress of DDL in mysql 5.7, many readers must have some understanding. If you need more industry knowledge and information, you can continue to follow our industry information section.