Bug #87478 Method to match original table to alter intermediary (#sql%)
Submitted: 18 Aug 2017 19:09
Reporter: Trey Raymond Email Updates:
Status: Open Impact on me:
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:5.6/5.7 OS:Any
Assigned to: CPU Architecture:Any

[18 Aug 2017 19:09] Trey Raymond
It'd be nice to be able to match a running alter on an existing table to the intermediary it's using.
- there can be many alters running at the same time on a server, so you can't just check processlist
- identifying it by matching columns, indexes, etc (like in the innodb_sys_* tables) isn't practical as the alter could be adding/removing as many of those as it wants

How to repeat:
alter some tables and start guessing

Suggested fix:
some way to link it.  it's easy to find the thread doing the alter (from perf schema, processlist, innodb_trx, anywhere), and it's easy to identify the intermediary (perf schema file info, innodb_sys tables), but there's no way to connect the two.