Regresar
-
Título
How to enable the display of background processes in MySQL PI -
Descripción
Background processes are filtered out by default in the MySQL Pi agent. How can the background processes by seen in the MySQL PI statements? -
Causa
Monitor the MySQL databases and and enable PI
Check the Agent Status Property parameters paecFilterDmvRequest and paecDmvCollectBackgroundProcess in the MySQL PI agent log
To see the background processes, paecFilterDmvRequest should be 0 and paecDmvCollectBackgroundProcess should be 1.
-
Resolución
The following groovy script run in the Script Console can be used to display the background processes for the MySQL PI agent. Replace AGENTNAME with the name of the agent.
agentService = server.get("AgentService");
configService = server.get("ConfigService");def setAspParams(agents, aspName, aspValue) {
for (agent in agents) {
def primaryASP = configService.getAgentInstancePrimaryAsp(agent.getAgentNamespace(), agent.getTypeId(), agent.getId());
primaryASP.setValueByString(aspName, aspValue);
configService.saveConfig(primaryASP);
}
}
def agents = agentService.findByName("AGENTNAME");
setAspParams(agents, "paecFilterDmvRequest", "false");
setAspParams(agents, "paecDmvCollectBackgroundProcess", "true");return true;