Link You Today
Bookmark your Free, Libre software & tech link

data base How to monitor ALTER TABLE progress in MySQL

mariadb, mysql, percona

While working on a recent support issue as a Percona Support Engineer, I got one question from a customer asking how to monitor ALTER TABLE progress. Actually, for MySQL 5.5 and prior versions, it’s quite difficult to ALTER the table in a running production environment especially for large tables (with millions records).