Bug #79670 record P_S table truncation times
Submitted: 16 Dec 2015 14:58 Modified: 17 Dec 2015 9:32
Reporter: Simon Mudd (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: SYS Schema Severity:S3 (Non-critical)
Version:5.6,5.7 OS:Any
Assigned to: CPU Architecture:Any

[16 Dec 2015 14:58] Simon Mudd 
Description:
I want to know when the P_S tables data starts.
There's currently no table to indicate when the data is valid from which means I need to record this somewhere.

Currently I truncate all P_S tables using sys.ps_truncate_all_tables() and immediately afterwards I update a table I've called truncation_time to indicate when this happened.

How to repeat:
see above.

Suggested fix:
Ideally P_S should have an extra table to record this information but in the meantime it would be nice if there were a table in the sys schema which recorded the last time that the procedure was called.
[17 Dec 2015 9:32] MySQL Verification Team 
Hello Simon,

Thank you for the feature request!

Thanks,
Umesh
[8 Nov 2019 11:49] Valeriy Kravchuk 
Looks like a duplicate of older https://bugs.mysql.com/bug.php?id=78773