Cisco Cisco Web Security Appliance S170 Guía Del Usuario
D A T A B A S E T U N I N G O P T I O N S
C H A P T E R 5 : G U I D E L I N E S A N D T I P S
65
Optimizing the Database Tuning Options
To optimize the Database Tuning options:
1. Navigate to the Config page for the Profile you want to edit.
2. In the Reports Menu, expand the Database category, and click Database Tuning.
3. Click Edit Database Tuning.
4. In the “Maximum main table segment size” field, enter the amount of free memory
available on the machine and divide it by the number of processors (threads).
For example, if the machine has 2 GB of free memory and a single processor, enter 2 GB.
If the machine has 8 GB of free memory and two processors, enter 4 GB.
If the machine has 8 GB of free memory and two processors, enter 4 GB.
5. In the “Maximum main table segment size to merge” field, enter a number that is 10% of
the amount you entered in step 4.
For example, if you entered 2 GB in step 4, enter 200 MB in this field.
6. Enable all check boxes.
Note — When you enable all check boxes here, Sawmill for IronPort builds indices and
cross reference tables at the same time it builds the main database table. This requires a
lot of RAM. If the machine does not have a lot of RAM, leave the default values for all
check boxes.
cross reference tables at the same time it builds the main database table. This requires a
lot of RAM. If the machine does not have a lot of RAM, leave the default values for all
check boxes.
7. Click Save and Close.
Build indices in threads
Indicates where Sawmill for IronPort builds the indices
when it is configured to use multiple log processing
threads (one for each processor).
When Sawmill for IronPort is configured to use multiple
log processing threads:
• Option is enabled. Each process builds indices for the
when it is configured to use multiple log processing
threads (one for each processor).
When Sawmill for IronPort is configured to use multiple
log processing threads:
• Option is enabled. Each process builds indices for the
table segments in that process.
• Option is disabled. The main process builds the indices
for the main database table after the table segments for
each process have been merged into the main table.
each process have been merged into the main table.
Build indices in memory
Indicates whether indices are managed as buffers
allocated in memory or as memory mapped files on disk.
Building indices in memory requires more RAM, but is
typically faster.
allocated in memory or as memory mapped files on disk.
Building indices in memory requires more RAM, but is
typically faster.
Table 5-1 Database Tuning Page Options (Continued)
Option
Description
WSA_Sawmill.book Page 65 Tuesday, February 22, 2011 2:54 PM