search cancel

Extended global sync time related to sla_path

book

Article ID: 241036

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

Extended global sync time related to sla_path

Environment

Release : 21.2.x

Component : PM Web UI Admininistration/Configuration

Resolution

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.