Oneclick mysql using 99% CPU Utilization Constantly

Products

• Spectrum

Issue/Introduction

The mysql process on the OneClick server is using 99% cpu utilization constantly. Restarting the OneClick tomcat does not correct the problem as
   the cpu utilization returns shortly there after.

Environment

Release : 10.x

Component : Spectrum OneClick

Cause

OneClick was integrated with CA Performance Manager and did not have enough memory to run efficiently. The memory resource issue was causing the OneClick
   server to run slow and we could see continual mysql queries executing for the PM integration.

via mysql show full process list

Resolution

Increased the OneClick tomcat memory from 4096M to 12288M (12GB)

* Note: the amount of memory you will need to set for the tomcat server will depend on the amount of memory available on the
       server and the size of the environment being monitored. In some cases 8192 would be ok and in others more might be needed 24576.



After increasing the OneClick Web Server memory and restarting tomcat mysql returned to normal cpu utilization and the
   CA PM synchronization succeeded as well.