[MDEV-9260] Improve progress report on on-line alter table Created: 2015-12-10  Updated: 2024-01-18

Status: Open
Project: MariaDB Server
Component/s: Performance Schema, Storage Engine - InnoDB
Fix Version/s: None

Type: Task Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Marko Mäkelä
Resolution: Unresolved Votes: 2
Labels: None

Issue Links:
PartOf
includes MDEV-9148 Assertion `thd->stmt_arena != thd->pr... Closed
Relates
relates to MDEV-12512 Accurately report progress for ALTER ... Open
relates to MDEV-13626 Merge InnoDB test cases from MySQL 5.7 Closed
relates to MDEV-16329 Engine-independent online ALTER TABLE Closed

 Description   

There is very limited progress report and no real progress report on FT-indexes.



 Comments   
Comment by Marko Mäkelä [ 2019-03-22 ]

With MDEV-16329 replacing the InnoDB internal table rebuild, the progress reporting should be limited to ADD INDEX creating secondary indexes.

Comment by Marko Mäkelä [ 2023-11-02 ]

MDEV-16329 did not replace the InnoDB internal table rebuild. In MySQL 5.7 there is a test innodb.alter_table_stage_progress that would execute the following query:

SELECT
event_name,
work_completed > 0,
work_estimated > 0,
work_completed <= work_estimated
FROM performance_schema.events_stages_history
WHERE event_name LIKE 'stage/innodb/alter table%'
ORDER BY 1;

This query would fail in MariaDB because there are no columns work_completed or work_estimated in the performance_schema.event_stages_history.

There is also https://mariadb.com/kb/en/progress-reporting/ which might be worth supporting.

Generated at Thu Feb 08 07:33:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.