Bug #69673 Add P_S instrumentation which allows to observe LSN per page per tablespace
Submitted: 4 Jul 2013 18:42
Reporter: Sveta Smirnova Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S4 (Feature request)
Version:5.6.13 OS:Any
Assigned to: CPU Architecture:Any

[4 Jul 2013 18:42] Sveta Smirnova
Description:
Currently there is no way to find out when an InnoDB table changed last time: see bug #14374

However, even if "InnoDB currently does not write a timestamp to any file about the latest INSERT, DELETE, UPDATE of a table.", InnoDB still writes LSN (http://dev.mysql.com/doc/internals/en/innodb-page-structure.html#innodb-fil-header) and END LSN (http://dev.mysql.com/doc/internals/en/innodb-page-structure.html#innodb-fil-trailer) to its page.

But user can not get this number without necessity to access InnoDB tablespace directly.

How to repeat:
See description.

Suggested fix:
Add new Performance Schema instrumentation: page and show user current LSN per page.