INSERT INTO SELECT of a huge table (1TB). When the process is finished, MySQL/InnoDB still does post-processing (
creating updating secondary indices, etc.) for hours.
Since these are internal processes, they do not appear in
SHOW PROCESSLIST or
SHOW ENGINE INNODB STATUS \G.
I can only check the process by I/O activities.
Is there any way to properly monitor the ongoing processes?