Accounting Parameters

New Accounting parameter in Abiquo v4.0

The new Consolidation-time-sensitivity-secs parameter enables the administrator to skip short accounting events, such as the ones generated by failed reconfigures.

 

The Accounting parameters include general configuration and resource specific parameters. This document describes the general configuration parameters. For more information see Abiquo Accounting Services Integration

Accounting Parameter List

Set these parameters in the kinton_accounting.accounting_parameters table.

Name

Default

Value

Description
AccountingEnabled1

Controls if the accounting functionality is active or not.

0 or no parameter means that no rows are calculated and added into the accounting_event_detail table. A non-zero value means that the accounting process is active.

DeleteRegEventsUseSPParam0Controls if DeleteOldRegisteredEvents uses its parameter value instead of DeleteRegEventsDeleteHours to control the age of data in accounting_event master tables.
Default value is 0, using DeleteRegEventsDeleteHours as record maximum age.
DeleteRegEventsDeleteHours26280

This controls the number of hours worth of 'old' data that should be held in the accounting_event_... tables.

When DeleteOldRegisteredEvents is run, it will remove any rows from the tables which are inactive and older than the specified number of hours.

The default value of 26280 hours means that data is held for approximately 3 years by default (three years of 365 days).

AccountPeriodSizeHOUR

Controls the size of the aggregated account period of the accounting_event_detail table.

It may be one of the following values: HOUR, DAY, WEEK, MONTH. If the value is bad or missing, the default value is used.

AccountPeriodGranularityHOUR

Controls the granularity of an accounting period, i.e. how many resource units are recorded.: For example:

  • if account period = DAY and granularity = HOUR, then for a single CPU VM, Abiquo would record 24 resource units for the period;
  • if account period = DAY and granularity = DAY, then Abiquo would record 1 resource unit.

Possible values are HOUR, DAY, WEEK and MONTH. If the value is bad or missing, the default value is used.

MaximumPeriodsToFirstInit1

This parameter is only used when accounting_event_detail is empty. It determines how many previous accounting periods will be used to populate the accounting initially.

The default value is 1, which means that accounting data will be generated from the last period.

However, for existing installations this value can be adjusted to ensure that accounting is generated for any previous number of hours, days, weeks, or months, depending on the account period size.

The minimum number of periods is 1, and the maximum is 720. Values outside of this range will use the default value of 1.

MaximumPeriodsToProcess24

This parameters controls how many periods will be processed in each call to the UpdateAccounting stored procedure.

This setting ensures a degree of quality of service for the DBMS, minimizing the resource impact of recovering missed accounting data.

The default value is 24, which would process 1 day of accounting data, assuming the default settings for other parameters.

The minimum number of periods to process is 1, and the maximum is 720 - if a value outside of this range is supplied, then the default value of 24 is used.

Consolidation-time-sensitivity-secs30

Abiquo registers an accounting event with the desired values for each configuration change.

The accounting consolidation process will apply the maximum values found in a period, even if they were only registered for a short time, for example, because of an error.

This parameter will make the consolidation process ignore all accounting events that were only active for a small user-defined amount of time.The default value is 30 seconds, which should be enough to skip short events


Viewing the Accounting Parameters

You can use the ACCOUNTING_CONFIG_VW to view these parameters or you can select directly from the table.

Copyright © 2006-2022, Abiquo Holdings SL. All rights reserved