IBM Support

Control Center mysqld-nt.exe (MySQL) is using 100% CPU on Windows server for hours

Troubleshooting


Problem

Control Center mysqld-nt.exe (MySQL) is using 100% CPU on Windows server for hours

Symptom

Sterling Control Center 4.2.02

The executable file for MySQL (mysqld-nt.exe) is using 100% CPU on Windows server for hours. This occurs when the Prod database begins to move data to the Staging database. In particular, it appears that the CE_STATS_LOG table in the database is the culprit.

Data must be manually removed from the CE_STATS_LOG table. Re-initializing the databases temporarily will resolve this until the Prod database again begins moving data to the Staging database.

Error Message

CPU for MySQL at 100% - Performance Issue

Taking seven hours for prodPurge to complete.

Resolving The Problem

Apply fix from SR 1371147.

Fix is included in Sterling Control Center 4.2.05.

[{"Product":{"code":"SS9GLA","label":"IBM Control Center"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

NFX3848

Product Synonym

[<p><b>]Escalation ID[</b><p>];1371147;[<p><b>]Fix ID[</b><p>];1371147;[<p><b>]Severity[</b><p>];Normal;[<p><b>]Type[</b><p>];NormalFix

Document Information

Modified date:
17 December 2019

UID

swg21552217

Page Feedback