The following are the recommended settings for MySQL Enterprise Monitor Agent:
A single agent, with default settings and all advisors enabled, should monitor no more than 10 MySQL instances.
If the agent is monitoring more than 10 MySQL instances, the agent heap size must be increased by 64MB for every 10 additional MySQL instances.
The agent heap size is defined in the
MEM_AGENT_JAVA_OPTSparameter in the
The default heap size is 128MB.
data-reporting-threadsparameter must be increased by 2 for every 15-20 MySQL instances monitored.
data-reporting-threadsparameter is defined in the agent's