Bug #87708 MDL for column statistics is not properly reflected in P_S.METADATA_LOCKS
Submitted: 8 Sep 2017 13:52 Modified: 5 Oct 2017 18:08
Reporter: Erik Frøseth Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: CPU Architecture:Any

[8 Sep 2017 13:52] Erik Frøseth
Description:
MDL for column statistics is not properly reflected in P_S.METADATA_LOCKS. In particular, the column OBJECT_TYPE is empty.

How to repeat:
SELECT * FROM PERFORMANCE_SCHEMA.METADATA_LOCKS;

Observe that the column OBJECT_TYPE is empty
[5 Oct 2017 18:08] Paul Dubois
Posted by developer:
 
Fixed in 9.0.0.

Metadata locks for column statistics were not displayed properly in
the Performance Schema metadata_locks and events_waits_xxx tables.
[22 Mar 11:35] Jon Stephens
Fixed in MySQL 8.0.11.