Bug #91667 show latest trx id in global status
Submitted: 16 Jul 2018 14:47 Modified: 21 Nov 2019 13:54
Reporter: Ye Jinrong Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[16 Jul 2018 14:47] Ye Jinrong 
Description:
suggest add some global status to show the latest trx id, like what Percona Server do:

[yejr@imysql.com][blkchain]>show global status like '%trx_id%';
+-------------------------------------+---------+
| Variable_name                       | Value   |
+-------------------------------------+---------+
| Innodb_max_trx_id                   | 4379957 |
| Innodb_purge_trx_id                 | 4379957 |
+-------------------------------------+---------+

How to repeat:
add two global status like Innodb_max_trx_id and Innodb_purge_trx_id in Percona Server at least, they are very useful in InnoDB transaction status monitor, thanks much.
[18 Nov 2018 15:51] Ye Jinrong 
i think this feature request is useful in mysql monitor, and it will be easy to be implemented, thanks much.
[21 Nov 2019 13:54] MySQL Verification Team 
Hi Mr. Jinrong,

Thank you for your feature request.

I find your feature request justified.

Verified as reported.