search cancel

Extended global sync time related to sla_path


Article ID: 241036


Updated On:


CA Performance Management - Usage and Administration DX NetOps


Extended global sync time related to sla_path


Release : 21.2.x

Component : PM Web UI Admininistration/Configuration


The cause of the long-running query seems to be an inefficiency in the query optimizer in MySQL < 8.0.28 (MySQL version 8.0.27 is used in 21.2.9) 

The release notes for MySQL 8.0.28 state that performance improvements were made and this type of query must have been impacted by those improvements because the same query does not exhibit this behavior in MySQL 8.0.28

MySQL 8.0.28 is included DX Netops Performance Management 21.2.10 release, so the issue with this query will not be seen in the future.