Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.