My Oracle Support Banner

How to Monitor Progress of InnoDB Transaction (Doc ID 1521244.1)

Last updated on MARCH 11, 2024

Applies to:

MySQL Server - Version 4.0 and later
Information in this document applies to any platform.

Goal

Assuming that expected number of rows (which transaction must process) is known, it is possible to approximately estimate transaction completion time.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Solution 1 - Use INFORMATION_SCHEMA
 Solution 2 - Use INNODB STATUS
 Solution 3 - Monitoring progress of ALTER commands in MySQL Server 5.7 using PERFORMANCE_SCHEMA
 Notes
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.