It is a common question to MySQL experts when there are running ALTER TABLE on production environments especially for large tables with millions of records. How to monitor ALTER TABLE progress? How much time does it take? You can get details using the following SQL query
SELECT EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED FROM performance_schema.events_stages_current;It should be needed to enable Performance_schema in MySQL . More details and more good blog from Percona Blog
MeriaDB information_shema.processlist table has added a column called “progress”. It can show you Alter command progress if you are using MeriaDB
This Query also loaded in SmartWorkbench tool and if you type “AM(AlterMonitor)” and enter then this query will be replaced
.SmartMySQL‘s SmartWorkbench is a GUI tool for MySQL to develop MySQL 10X faster demo.
It is Free , DownlaodSpeed up your SQL queries 100X DemoFix production issues with your fingertips
