Process list progression
You certainly know the show process list
command that shows you the current list of running queries on your MariaDB instance. Since the Version 5.3 of MariaDB, another option is available that shows you the progression of certain long tasks such as the following:
ALTER TABLE
CREATE INDEX
DROP INDEX
LOAD DATA IN FILE
CHECK TABLE
REPAIR TABLE
ANALYZE TABLE
OPTIMIZE TABLE
By default, it's enabled in MariaDB, but your client or driver should be recent enough to support this feature. MariaDB sends back the information to the client every 5 seconds by default.
Here is an example of changing the storage engine of a table:
MariaDB [chapter2]> ALTER TABLE s_explain ENGINE = Aria; Stage: 1 of 2 'copy to tmp table' 9.09e+03% of stage done ...
Get MariaDB High Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.