System Reporter 2.8 | 3PAR System Reporter User’s Guide |
Table |
|
Policy | Default |
|
|
Number of days to keep Adaptive | 7 |
Optimization hourly samples |
|
|
|
Number of days to keep daily samples | 366 |
|
|
Ratio of | 6 |
| |
Typically space changes are slower than |
|
performance so space sampling can be configured |
|
at a slower rate than performance sampling. |
|
|
|
Perform compaction of the database after | daily |
next sample (SQLite only. Sampling will be |
|
stopped and database will be unavailable for |
|
several minutes) |
|
| |
|
|
If there is a problem with sampling, send | (blank) |
email to this address. |
|
Email is only sent if the sampling problem requires |
|
the sampler service/daemon to exit. |
|
|
|
7.2.1 Compacting Databases
When some sampling policies are changed or when the number or sizes of systems being sampled is reduced the size of the database may be reduced significantly.
If a MySQL or Oracle database is being used and there is a significant change in size, the database’s tables do not automatically shrink. A compaction must be performed on the database in order to recover the file space. To start a compaction on the database, change the policy labelled Perform compaction of the database after next sample to now, daily or to the specific day of the week depending on whether you want to perform the compaction now, immediately after each daily sample or immediately after the daily sample on the specified day of the week.
Configuring Sampling Policies | 7.3 |