Optimize OneClick mysql for Performance Management integration
search cancel

Optimize OneClick mysql for Performance Management integration

book

Article ID: 261013

calendar_today

Updated On:

Products

DX NetOps

Issue/Introduction

Can we optimize mysql on OC for the netqos_integ – this oc is not used for anything else besides the PM integration.

The my-spectrum.cnf in Spectrum is configured for innodb but the netqos_integ is mostly myisam.

Are there any recommended settings we can add to optimize this?  

 

Environment

Release : 21.2

Resolution

The oneClick mysql db used for the PM integration called netqos_integ will have the storage engine changed to innoDB in 22.2.7. 

This will optimize the db and provide performance improvements for the integration.