Runtime and ODW database partitioning

The Runtime and ODW database are installed with partitioning enabled by default. This allows more efficient use of the database to store the long term availability and performance metrics of all Opsview’s service checks. Anyone upgrading from previous versions of Opsview will have to manually enable partitioning.

We recommend all users enable partitioning. Take note of the following considerations:

The amount of space needed to complete the partitioning will be the same as the largest database table you have from the lists given below.

To see the size of the tables within your database, you may run the below command as the root user in your database. Please note this command is running against your Runtime database - you would need to change the table_schema to check for odw tables

mysql> SELECT TABLE_NAME, round(((data_length + index_length) / 1024 / 1024),2) Size_in_MB FROM information_schema.TABLES WHERE table_schema = 'runtime' order by Size_in_MB desc;

Runtime Copied

The following tables will be partitioned by Opsview:

When upgrading Opsview Monitor a notice such as the following will be displayed if any of the tables are not currently partitioned:

############################################################
If you want to speed up housekeeping, run the following:
  /opt/opsview/coreutils/installer/apply_runtime_partitions
############################################################

After the upgrade is complete you may then run the script. Opsview does not need to be shut down while this script runs.

Take note of the following considerations:

ODW Copied

The following tables will be partitioned by Opsview:

When upgrading Opsview Monitor a notice such as the following will be displayed if any of the tables are not currently partitioned:

############################################################
If you want to speed up housekeeping, run the following:
/opt/opsview/coreutils/installer/apply_odw_partitions
############################################################

After the upgrade is complete you may then run the script. Opsview does not need to be shut down while this script runs.

Take note of the following considerations:

["Opsview On-premises"] ["User Guide"]

Was this topic helpful?