Tuning MySQL and Tomcat for large numbers of users

Article:HOWTO59402  |  Created: 2011-10-04  |  Updated: 2011-10-04  |  Article URL http://www.symantec.com/docs/HOWTO59402
Article Type
How To


Subject


Tuning MySQL and Tomcat for large numbers of users

The maximum number of entries in the group members list for a group policy is 10,000. If you require more than 10,000 entries, you need to configure MySQL and Tomcat to support more entries.

Some ways to increase the number of users a policy can support are as follows:

Increase the MySQL BLOB size.

You can increase the MySQL BLOB size and take no other action for a minimal increase in members. Any significant increase can result in Tomcat memory overload. In most cases, you should perform all of the items in this list together.

The default value is 1 MB.

Change the MAX_MSG_SIZE_ALLOWED setting in the settings_quarantine table.

Do this task through the SQL command.

Increase available Tomcat memory.

To do this task, increase the value of the environment variable, JAVA_OPTS.

To increase the MySQL BLOB size

  1. Open the following MySQL options file in a text editor:

    Linux and Solaris

    /etc/my.cnf

    Windows

    c:\Windows

  2. Add or modify the following line to modify the max_allowed_packet memory value of MySQL:

    max_allowed_packet=16M
  3. Restart the MySQL service.

To change the MAX_MSG_SIZE_ALLOWED setting in the settings_quarantine table

  1. Log on to the MySQL client using the following command:

    mysql --user=brightmailuser --password=PASSWORD -- 
    host=127.0.0.1 brightmail
  2. Run the following command:

    update settings_quarantine set value=2 where 
    name='MAX_MSG_SIZE_ALLOWED';

To increase the available memory for Tomcat on Windows

  1. Right-click My Computer.

  2. Click Properties.

  3. Click the Advanced tab.

  4. Click Environment.

  5. Under system variables, increase the value of the environment variable, JAVA_OPTS.

To increase the available memory for Tomcat on Linux or Solaris

  1. Open the following script in a text editor:

    /etc/init.d/tomcat4

  2. Increase the value of the following line as needed:

    JAVA_OPTS="-Xmx384"

Legacy ID



v41520230_v64406064


Article URL http://www.symantec.com/docs/HOWTO59402


Terms of use for this information are found in Legal Notices