The parameters for the Tomcat hosting system used to support MySQL Enterprise Service Manager and MySQL Enterprise Dashboard can have an affect on the performance of the system.
The default settings for Java for Tomcat are as follows:
Initial heap size | -Xms | 768MB |
Maximum heap size | -Xmx | 768MB |
Java stack size | -Xss | 128MB |
You can change these parameters to higher values,by editing the
JAVA_OPTS
setting within the corresponding
platform script.
On Unix/Linux and Mac OS X
Edit the values within
apache-tomcat/bin/setenv.sh
file within
your MySQL Enterprise Service Manager directory. You should avoid setting
maximum figures higher than the physical memory of your system
as this may reduce, rather than increase the performace.
If you change these parameters, you will need to shutdown and restart MySQL Enterprise Service Manager for the changes to take effect.
Windows
Edit the JAVA_OPTS
settings within the
apache-tomcat/bin/setenv.bat
file.
To enable the changes, you must re-install your service. To do this, shutdown your MySQL Enterprise Service Manager service and then reinstall the service by running:
shell> mysqlmonitorctl.bat uninstall shell> mysqlmonitorctl.bat install
On all platforms, changes to the JAVA_OPTS
using the above methods should be retained over an upgrade of the
MySQL Enterprise Service Manager service.
If you change these parameters, you must restart MySQL Enterprise Service Manager for the changes to take effect.