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

3.15 Installing the Database Server
System Reporter 2.8 3PAR System Reporter User’s Guide
SQLite supports only limited database concurrency because it relies on a single file lock for the
entire database. The sampling process needs exclusive access to the database when inserting
new samples. If the database is very large or if there are a large number of concurrent web
requests, the sampler or the Web server can time out. Furthermore, database compaction (see
7.2.1 Compacting Databases on page 7.3) cannot be done in parallel with sample insertion so
there could be a large gap in samples during database compaction.
Sampling of multiple InServ Storage Servers is not supported with an SQLite database, either
the MySQL or the Oracle database servers should be used instead.
For large databases (over about 1 GB) or a large number of concurrent Web users, either the
MySQL® or the Oracle database servers should be used instead.
3.8.1.2 MySQL
A MySQL database server can be used with System reporter but is not included with it. You
must purchase it separately. MySQL is a good choice for System reporter because it supports
MyISAM tables. These tables do not support transactions (which are not required for System
Reporter) and are consequently somewhat higher performance than Oracle for sample
insertion and deletion.
3.8.1.3 Oracle
Beginning with the 2.4 release, System Reporter also supports an Oracle 11g database server
but it is not included with it. You must purchase it separately. Compared with MySQL, Oracle is
slightly slower and more resource intensive for sample insertion and deletion. However, Oracle
is also a good choice for large and active System Reporter installation.
NOTE: The optionally licensed Adaptive Optimization feature is not supported
with the SQLite database. Please consider another database if you plan on
utilizing the storage optimization capabilities provided by Adaptive
Optimization.
NOTE: System Reporter does not currently support Oracle RAC implementations.
NOTE: System Reporter requires the 32-bit Oracle client and does not support the
64-bit version.