After completion of tests gnocchi db has following data:-
MariaDB [gnocchi]> select * from archive_policy; +-----------+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+ | name | back_window | definition | aggregation_methods | +-----------+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+ | bool | 3600 | [{"points": 31536000, "granularity": 1.0, "timespan": 31536000.0}] | ["last"] | | gabbilive | 0 | [{"points": 60, "granularity": 1.0, "timespan": 60.0}, {"points": 30, "granularity": 2.0, "timespan": 60.0}, {"points": 5, "granularity": 60.0, "timespan": 300.0}] | ["max", "mean", "min"] | | high | 0 | [{"points": 3600, "granularity": 1.0, "timespan": 3600.0}, {"points": 10080, "granularity": 60.0, "timespan": 604800.0}, {"points": 8760, "granularity": 3600.0, "timespan": 31536000.0}] | ["std", "count", "min", "max", "sum", "mean"] | | low | 0 | [{"points": 8640, "granularity": 300.0, "timespan": 2592000.0}] | ["std", "count", "min", "max", "sum", "mean"] | | medium | 0 | [{"points": 10080, "granularity": 60.0, "timespan": 604800.0}, {"points": 8760, "granularity": 3600.0, "timespan": 31536000.0}] | ["std", "count", "min", "max", "sum", "mean"] | +-----------+-------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------+ 5 rows in set (0.00 sec)
MariaDB [gnocchi]> select * from archive_policy_rule; +---------+---------------------+----------------+ | name | archive_policy_name | metric_pattern | +---------+---------------------+----------------+ | default | low | * | +---------+---------------------+----------------+
and gnocchi pool: (rados ls -p gnocchi) has one object: measure
After completion of tests gnocchi db has following data:-
MariaDB [gnocchi]> select * from archive_policy; -----+- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ----+-- ------- ------- ------- ------- ------- ------- ---+ -----+- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ----+-- ------- ------- ------- ------- ------- ------- ---+ -----+- ------- -----+- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ------- ----+-- ------- ------- ------- ------- ------- ------- ---+
+------
| name | back_window | definition | aggregation_methods |
+------
| bool | 3600 | [{"points": 31536000, "granularity": 1.0, "timespan": 31536000.0}] | ["last"] |
| gabbilive | 0 | [{"points": 60, "granularity": 1.0, "timespan": 60.0}, {"points": 30, "granularity": 2.0, "timespan": 60.0}, {"points": 5, "granularity": 60.0, "timespan": 300.0}] | ["max", "mean", "min"] |
| high | 0 | [{"points": 3600, "granularity": 1.0, "timespan": 3600.0}, {"points": 10080, "granularity": 60.0, "timespan": 604800.0}, {"points": 8760, "granularity": 3600.0, "timespan": 31536000.0}] | ["std", "count", "min", "max", "sum", "mean"] |
| low | 0 | [{"points": 8640, "granularity": 300.0, "timespan": 2592000.0}] | ["std", "count", "min", "max", "sum", "mean"] |
| medium | 0 | [{"points": 10080, "granularity": 60.0, "timespan": 604800.0}, {"points": 8760, "granularity": 3600.0, "timespan": 31536000.0}] | ["std", "count", "min", "max", "sum", "mean"] |
+------
5 rows in set (0.00 sec)
MariaDB [gnocchi]> select * from archive_ policy_ rule; ---+--- ------- ------- ----+-- ------- ------- + ---+--- ------- ------- ----+-- ------- ------- + ---+--- ------- ------- ----+-- ------- ------- +
+------
| name | archive_policy_name | metric_pattern |
+------
| default | low | * |
+------
and gnocchi pool: (rados ls -p gnocchi) has one object: measure