QAN MariaDB Data Structures - Modify for Partitioning and Partition Based Pruning

[gordan-bobic]

Tables:

query_class_metrics
query_examples
query_classes
agent_log
query_global_metrics

• Modify tables for partitioning by day
• Implement stored procedure and scheduled events for partition creation and pruning. Every day a partition for tomorrow should be created, and partitions that exceed retention period should be dropped
• Query retention period environment variable interpretation should be converted to days, round up, and then that number of daily partitions should be kept, e.g. 40h should become 2d and acted upon accordingly.

This will make data pruning near-instantaneous, and space reclamation much more effective.