Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-6144

Zabbix Proxy history housekeeping using partitioning out of the box

    XMLWordPrintable

    Details

    • Type: Change Request
    • Status: Confirmed
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 3.0.31, 4.0.24rc2, 5.0.3rc2, 5.2.0alpha1
    • Fix Version/s: None
    • Component/s: Proxy (P)
    • Team:
      Team A

      Description

      Proxy database: MySQL*, PgSQL, Oracle;
      Partitioning: database specific (partitioning is not part of SQL9X standard);
      Schema: create by default 6 partitions for proxy_history* with 1 hour range;
      Workflow: using ProxyOfflineBuffer value rotate partitions;

      Why: DELETE .. IN () .. - slow and not efficient.

        Attachments

          Activity

            People

            Assignee:
            zabbix.dev Zabbix Development Team
            Reporter:
            edgar.akhmetshin Edgar Akhmetshin
            Votes:
            2 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated: