Documentation Home
MySQL Enterprise Monitor 8.0 Manual
Related Documentation Download this Manual
PDF (US Ltr) - 6.0Mb
PDF (A4) - 6.0Mb


MySQL Enterprise Monitor 8.0 Manual  /  ...  /  MySQL Enterprise Monitor Installation Types

5.1 MySQL Enterprise Monitor Installation Types

MySQL Enterprise Service Manager installer enables you to choose your installation type. This choice sets parameters which suit your installation type.

The following are the possible installation types:

  • Small: 1 to 5 MySQL Servers monitored from a laptop or low-end server with no more than 4GB of RAM.

  • Medium: Up to 100 MySQL Servers monitored from a medium-sized, but shared, server with 4 to 8GB of RAM.

  • Large: More than 100 MySQL Servers monitored from a high-end server, dedicated to MySQL Enterprise Service Manager, with more than 8GB RAM.

These parameters are set in the following configuration files:

  • setenv.sh/ setenv.bat:

    • Tomcat Heap Size (-Xms and -Xmx): defines the minimum (-Xms) and maximum (-Xmx) amount of RAM available to Tomcat's JVM. -Xmx and -Xms are set to the same value.

    • Tomcat MaxPermSize: defines the maximum size of the pool containing the data used by Tomcat's JVM.

  • my.cnf/my.ini:

    • table_definition_cache: defines the number of table definitions that can be stored in the definition cache.

    • innodb_buffer_pool_size: defines the size, in megabytes, of the InnoDB buffer pool.

Table 5.1 Installation Parameters

Parameter Small Medium Large

Tomcat Heap Size

512MB

768MB

2048MB

Tomcat MaxPermSize

200MB

512MB

1024MB

table_definition_cache

800

2048

2048

innodb_buffer_pool_size

100MB

768MB

8096MB


Important

These values are not hard-coded. You can change them, if your installation requires it, by editing setenv.sh/setenv.bat, or my.cnf/my.ini.