Bug #90417 Contribution by Facebook: port new stage info for committing threads
Submitted: 12 Apr 2018 23:03 Modified: 11 Jun 2018 18:50
Reporter: FBContrib Admin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:8.0.4 OS:Any
Assigned to: CPU Architecture:Any

[12 Apr 2018 23:03] FBContrib Admin 
Description:
Background innformation provided by Facebook:
Abstract:
This diff adds a new stage info for threads going through transaction commit.

It has been useful to identify the stages of the slaves threads to determine if it's stuck in commit or query processing at times.

Repo: https://github.com/mysql/mysql-server
Patch on top of 8.0.4: https://github.com/mysql/mysql-server/commit/577fbcf856cd693434d554545d499559bcdd3695
Facebook commits: https://github.com/facebook/mysql-5.6/commit/8379e07

How to repeat:
See description

Suggested fix:
See contribution code attached
[12 Apr 2018 23:03] FBContrib Admin 
port new stage info for committing threads 
(*) This code is contributed under the Facebook agreement

Contribution: fb_patch_40.txt (text/plain), 3.53 KiB.
[29 May 2018 20:48] Chris Powers 
Posted by developer:
 

New stage "waiting for handler commit" for threads going through transaction commit.

This stage can be used to determine if a slave thread is stuck in the commit or query processing.
[11 Jun 2018 18:50] Paul DuBois 
Posted by developer:
 
Fixed in 8.0.13.

A new Performance Schema stage, waiting for handler commit, is
available to detect threads going through transactiuon commit. Thanks
to Facebook for the patch.