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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.