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:
To increase the MySQL BLOB size
Open the following MySQL options file in a text editor:
Add or modify the following line to modify the max_allowed_packet memory value of MySQL:
max_allowed_packet=16M
Restart the MySQL service.
To change the MAX_MSG_SIZE_ALLOWED setting in the settings_quarantine table
Log on to the MySQL client using the following command:
mysql --user=brightmailuser --password=PASSWORD --
host=127.0.0.1 brightmail
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
Right-click My Computer.
Click .
Click the Advanced tab.
Click .
Under system variables, increase the value of the environment variable, JAVA_OPTS.
To increase the available memory for Tomcat on Linux or Solaris
Open the following script in a text editor:
/etc/init.d/tomcat4
Increase the value of the following line as needed:
JAVA_OPTS="-Xmx384"
Thank you.