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.

[{"Product":{"code":"SS9GLA","label":"IBM Control Center"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

NFX3848

Document Information

Modified date:
17 December 2019

UID

swg21552217

Page Feedback