10.4 Tuning Agent Memory Requirements

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_OPTS parameter in the setenv.sh/bat file.

  Note

  The default heap size is 128MB.

• The data-reporting-threads parameter must be increased by 2 for every 15-20 MySQL instances monitored.

  The data-reporting-threads parameter is defined in the agent's bootstrap.properties file.