Credit for this gist goes to Alexander Rubin at https://www.percona.com/blog/author/alexanderrubin/
Article used for this was at: https://www.percona.com/blog/2017/05/08/chasing-a-hung-transaction-in-mysql-innodb-history-length-strikes-back/
To identify hung transactions:
show engine innodb status