Cisco Cisco Web Security Appliance S360 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
63
table segments and indices. When the main database table is stored in a very large number of
segments, the index for each segment gets proportionately much larger. This can increase the
amount of hard disk space required for the main database and the amount of time required to
build the database. For example, if you have 200 GB of data to store, the database size might
be four times that when the segment size is left at the default value. Therefore, for very large
datasets, you should increase the size of each segment to improve performance and decrease
the amount of space the database (especially the indices) uses on disk.
segments, the index for each segment gets proportionately much larger. This can increase the
amount of hard disk space required for the main database and the amount of time required to
build the database. For example, if you have 200 GB of data to store, the database size might
be four times that when the segment size is left at the default value. Therefore, for very large
datasets, you should increase the size of each segment to improve performance and decrease
the amount of space the database (especially the indices) uses on disk.
Figure 5-1 shows the Database Tuning page where you can optimize the database settings.
Figure 5-1 Database Tuning Page
Table 5-1 on page 63 describes the options you can configure on the Database Tuning page.
Table 5-1 Database Tuning Page Options
Option
Description
Maximum main table segment size
The amount of space on the hard disk taken up by each
database table segment. Each processor on the machine
requires this much RAM to build the database.
IronPort recommends increasing this value to the amount
of free memory (RAM) divided by the number of
processors. 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.
database table segment. Each processor on the machine
requires this much RAM to build the database.
IronPort recommends increasing this value to the amount
of free memory (RAM) divided by the number of
processors. 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.
WSA_Sawmill.book Page 63 Tuesday, February 22, 2011 2:54 PM