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)
• Status: Closed
• 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

Description:
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.