Bug #77666 Implement control of priority for InnoDB Online ALTER (throttle IO)
Submitted: 9 Jul 2015 7:56 Modified: 9 Jul 2015 7:56
Reporter: Andrii Nikitin Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[9 Jul 2015 7:56] Andrii Nikitin
ONLINE ALTER on huge table may cause very high IO load, which may disrupt normal database operation. 

How to repeat:

Suggested fix:
Being able to throttle IO load from ALTER should help in such scenarios, so this report requests way to control priority of ALTER operation, which may reduce IO load.
[9 Jul 2015 7:58] Andrii Nikitin
Posted by developer:
This priority should be dynamic, including 'pause' on ALTER operation as edge case.