Documentation Home
MySQL Enterprise Monitor 4.0 Manual
Related Documentation Download this Manual

9.2 Tuning CPU

If both Apache Tomcat server and MySQL repository are installed on the same host, the best option within large scale environments is to move the MySQL Instance to its own host. This enables both processes to use up the resources of each host, and allows scaling to monitor hundreds of MySQL Instances and Hosts.

To do this, you should:

  1. Stop the application Apache Tomcat server and MySQL Instance.

  2. Copy the datadir contents to the new host (if moving to a fresh MySQL instance), or run mysqldump and import the dump into the new MySQL instance.

  3. Modify Tomcat's configuration to use the new MySQL Instance on the new host.

The configuration should be updated with the configuration tool. This tool can be found at the following location:

Table 9.4 Configuration utility location (default)

Operating System Path

Microsoft Windows

C:\Program Files\MySQL\Enterprise\Monitor\bin\config.bat

Linux / Unix

/opt/mysql/enterprise/monitor/bin/config.sh

Mac OS X

/Applications/mysql/enterprise/monitor/bin/config.sh


For more information on the configuration utilities, see Chapter 10, Configuration Utilities.


User Comments
Sign Up Login You must be logged in to post a comment.