Bug #104583 buf_resize_thread missing in performance_schema.threads
Submitted: 10 Aug 2021 13:46 Modified: 6 Oct 2021 11:16
Reporter: Kaige Ye (OCA) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:5.7 OS:Any
Assigned to: Marc ALFF CPU Architecture:Any

[10 Aug 2021 13:46] Kaige Ye
The `buf_resize_thread` should be in the performance_schema.threads table.

How to repeat:
select thread_id,name,thread_os_id from performance_schema.threads;

Suggested fix:
A `pfs_register_thread()` call should be added in `fts_optimize_thread()`.

Here is the fix: https://github.com/mysql/mysql-server/pull/350
[11 Aug 2021 11:51] MySQL Verification Team
Hi Mr. Ye,

Thank you for your bug report.

We find your feature request quite interesting. This is we verify your report as a feature request. Since all new features go into 8.0, we change the version to 8.0.

Verified as a feature request.
[27 Aug 2021 13:06] OCA Admin
Contribution submitted via Github - fix buf_resize_thread missing in performance_schema.threads 
(*) Contribution by Kaige Ye (Github YKG, mysql-server/pull/364#issuecomment-907067962): 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_720971162.txt (text/plain), 2.35 KiB.

[8 Sep 2021 11:13] Marc ALFF
To clarify,

incomplete performance_schema instrumentation is considered a bug,
because it affects the quality of stats returned by the performance schema.
[8 Sep 2021 11:41] MySQL Verification Team
Thank you , Marc.
[6 Oct 2021 11:16] Edward Gilmore
Posted by developer:
Noted in 5.7.36 and 8.0.27 changelogs
The following threads are now present in the performance_schema.threads table:
- buf_resize_thread
- fts_optimize_thread
Thanks to Kaige Ye for the contribution.
[6 Oct 2021 16:36] Edward Gilmore
Posted by developer:
text updated for 8.0.27 only.