[MDEV-6172] Monitor progress of ALTER TABLE ... ADD INDEX, ALGORITHM=INPLACE for InnoDB Created: 2014-04-25  Updated: 2023-11-20  Resolved: 2014-08-18

Status: Closed
Project: MariaDB Server
Component/s: None
Fix Version/s: 10.1.1

Type: Task Priority: Minor
Reporter: Kolbe Kegel (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-29913 Assertion `thd->stmt_arena != thd->pr... Closed

 Description   

When adding an index to an InnoDB table using algorithm=inplace, it is not possible to monitor the progress of the merge sort operation, which can take a great deal of time.

It would be nice if the "Progress" column of SHOW PROCESSLIST was updated with some information about how far along the merge sort has progressed. It might also be possible or desirable to make some progress information available by other means.

 Comments   
Comment by Jan Lindström (Inactive) [ 2014-08-18 ]

commit 8984bef2e431db42761d3f267b950293cfd864de
Author: Jan Lindström <jan.lindstrom@skysql.com>
Date: Mon Aug 18 10:52:59 2014 +0300

MDEV-6172: Monitor progress of ALTER TABLE ... ADD INDEX,
ALGORITHM=INPLACE for InnoDB

Added thd_progress calls to row_merge_sort to give
some hint how merge sort progresses.

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