MySQL Bugs: #69673: Add P_S instrumentation which allows to observe LSN per page per tablespace

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.