Foglight filters out its the MySQL PI agent queries in Performance Investigator.
How can this be setting be changed to view the queries coming from the MySQL PI agent?
WORKAROUND
To enable the MySQL PI agent to display its own queries in the Performance Investigator component, run the following script in script console with the value in line 15 set to false. Changing the value in line 15 to true will revert back to not displaying the MySQL PI agent's own queries.
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("");
// default true
setAspParams(agents, "paecFilterDmvRequest", "false");
return true;
STATUS
An enhancement FOG-3948 has been logged to be included in a future release of the MySQL PI cartridge to no longer limit the get_active MySQL PI query by default. This will be considered for a future release fo the MySQL PI cartridge.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center