Bug #78190 Add eviction count metric for table cache lru cleanup (contribution)
Submitted: 24 Aug 2015 11:47 Modified: 27 Aug 2015 19:15
Reporter: OCA Admin (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[24 Aug 2015 11:47] OCA Admin 
Description:
This bug tracks a contribution by Daniel van Eeden (Github user: dveeden) as described in http://github.com/mysql/mysql-server/pull/26

How to repeat:
See description

Suggested fix:
See contribution code attached
[24 Aug 2015 11:47] OCA Admin 
Contribution submitted via Github - Add eviction count metric for table cache lru cleanup 
(*) Contribution by Daniel van Eeden (Github dveeden, mysql-server/pull/26#issuecomment-133682536): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_43055039.txt (text/plain), 2.41 KiB.
[24 Aug 2015 12:38] MySQL Verification Team 
Hello Daniel,

Thank you for the report and contribution.

Thanks,
Umesh
[26 Aug 2015 9:41] Daniël van Eeden 
Addition: https://github.com/dveeden/mysql-server/commit/555ca34958a8ed191f34eeb2333e0d7c30e12fce.pa...

Attachment: 555ca34958a8ed191f34eeb2333e0d7c30e12fce.patch (text/x-patch), 3.13 KiB.
[27 Aug 2015 19:15] Daniel Price 
Fixed as of the upcoming 5.7.9, 5.8.0 releases, and here's the changelog entry:

A new INNODB_METRICS server operations counter (innodb_dict_lru_count)
counts the number of tables evicted from the table cache LRU list. Thanks
to Daniël van Eeden for the patch. 

Thank you for the bug report.
[28 Aug 2015 8:45] Daniël van Eeden 
That changelog seems to indicate that that was the initial patch only without the additional patch as uploaded this bugreport.
[14 Sep 2015 14:41] Daniel Price 
Posted by developer:
 
The existing changelog entry is correct. Only a single counter was added (innodb_dict_lru_count), as per the original patch.