HP 3PAR System Reporter Software - Manual (Page 172)

7.4 Configuring Sampling Policies
3PAR System Reporter User’s Guide System Reporter 2.8
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. Refer to
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.
7.2.2 Editing Sampling Policies
To edit a System Reporter database sampling policy:
1 Access 3PAR System Reporter by pointing your browser at the Web server where Apache
HTTP Server and the 3PAR System Reporter Web server scripts are installed.
The 3PAR System Reporter window appears.
2 In the Extras Menu area, select Policy Settings.
3 If the Web server has been configured to require a password to read the database and view
sampling policies, a connection dialog box appears. Type the user name and password and
click OK ( Figure 7-1 ).