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
Open the following MySQL options file in a text editor:
Linux and Solaris
Add or modify the following line to modify the max_allowed_packet memory value of MySQL:
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 --
Run the following command:
update settings_quarantine set value=2 where
To increase the available memory for Tomcat on Windows
Right-click My Computer.
Click the Advanced tab.
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:
Increase the value of the following line as needed: