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.shfile 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, shut down and restart MySQL Enterprise Service Manager for the changes to take effect.
Windows
Edit the
JAVA_OPTSsettings within theapache-tomcat/bin/setenv.batfile.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, restart MySQL Enterprise Service Manager for the changes to take effect.