Page cleaner worker threads are not instrumented for performance schema

Bug #1532747 reported by Laurynas Biveinis on 2016-01-11
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Server
Unknown
Unknown
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.1
Invalid
Undecided
Unassigned
5.5
Invalid
Undecided
Unassigned
5.6
Invalid
Undecided
Unassigned
5.7
Fix Released
Medium
Laurynas Biveinis

Bug Description

Copy of https://bugs.mysql.com/bug.php?id=79894:

[8 Jan 13:56] Laurynas Biveinis
Description:
Credit shared with Alexey Stroganov.

Page cleaner worker threads do not call pfs_register_thread.

This means:
1) (if I recall correctly how PFS thread instrumentation works) no events by these threads are actually accounted.
2) they are invisible in PERFORMANCE_SCHEMA.THREADS table.

If 1) is correct, then any results so far on 5.7 to gain insights into MT page cleaner performance by PFS are basically invalid. To verify 2), start server in default configuration, and query P_S.THREADS. You will see one cleaner thread there only. The three worker threads there are purge. The cleaner worker threads are not there.

How to repeat:
See above, check buf0flu.cc for buf_flush_page_cleaner_worker NOT calling pfs_register_thread.

Suggested fix:
Add a new thread key, register cleaner worker threads with PFS.

tags: added: performance upstream
tags: added: innodb

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3356

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.