HP 3PAR StoreServ 7200 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 114
Compacting Databases
View all HP 3PAR StoreServ 7200 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 114 highlights
Table 54 Sampling Policies (continued) Policy Default Default number of hours to keep hi-res samples (in force by default for all systems 24 unless specified otherwise on an individual basis) Default number of days to keep hourly samples (in force by default for all systems 7 unless specified otherwise on an individual basis) Default number of days to keep Adaptive Optimization hourly samples (in force 7 by default for all systems unless specified otherwise on an individual basis) Default number of days to keep daily samples (in force by default for all systems 366 unless specified otherwise on an individual basis) Ratio of Hi-Res performance samples to Hi-Res space samples. 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 next sample (SQLite only. Sampling will be stopped and database will be unavailable for several minutes) see "Compacting Databases" (page 114) daily If there is a problem with sampling, send email to this address. (blank) Email is only sent if the sampling problem requires the sampler service/daemon to exit. 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. If the policy value is set to now the compaction is done once and the value is automatically reset to 0. To achieve compaction with MySQL databases, System Reporter uses the OPTIMIZE command. For Oracle databases System Reporter uses the ALTER TABLE SHRINK SPACE command. See your SQLite, MySQL or Oracle database documentation for further information about database compaction using these commands. For MySQL and Oracle databases, compaction is done by an external process so that data sampling can continue in parallel with database compaction. However, for SQLIte databases sampling is suspended until the compaction is complete. For MS SQL, the compaction is performed using the following procedure: DBCC SHRINKDATABASE ( database_name [ , target_percent ] [ , { NOTRUNCATE | TRUNCATEONLY } ] ) DBCC SHRINKFILE ( { file_name | file_id } { [ , target_size ] | [ , { EMPTYFILE | NOTRUNCATE | TRUNCATEONLY } ] 114 Configuring the System Reporter Policy Settings