DDL progression - FR

[lefred]

Would be nice to implement a panel to see the progression of the eventual ALTER statements.

Something inspired by

select stmt.thread_id, stmt.sql_text, stage.event_name as state, 
                   stage.work_completed, stage.work_estimated, 
                   lpad(concat(round(100*stage.work_completed/stage.work_estimated, 2),"%"),10," ") 
                   as completed_at, 
                   lpad(format_pico_time(stmt.timer_wait), 10, " ") as started_ago, 
                   lpad(format_pico_time(stmt.timer_wait/round(100*stage.work_completed/stage.work_estimated,2)*100), 
                        10, " ") as estimated_full_time, 
                   lpad(format_pico_time((stmt.timer_wait/round(100*stage.work_completed/stage.work_estimated,2)*100)
                        -stmt.timer_wait), 10, " ") as estimated_remaining_time, 
                   current_allocated memory 
            from performance_schema.events_statements_current stmt 
            inner join sys.memory_by_thread_by_current_bytes mt 
                    on mt.thread_id = stmt.thread_id 
            inner join performance_schema.events_stages_current stage 
                    on stage.thread_id = stmt.thread_id\G

[charles-001]

How many people are doing raw DDLs? Even if they're considered "online", they block replicas once it gets to them which is a show stopper. Almost everyone I know use pt-osc or gh-ost so not sure how applicable this panel would be.

[charles-001]

Closing this since it's been 2 weeks with no response