Zabbix MySQL DB schema contains clustered indexes with redundant suffixes

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Trivial
    • None
    • Affects Version/s: 2.1.1
    • Component/s: Installation (I)

      InnoDB uses a clustered index and that means that the secondary keys contains the primary key column.

      Some indexes shall be reconsidered:

      • escalations_1
      • events_1
      • history_log_2
      • history_str_sync_1
      • history_sync_1
      • history_text_2
      • history_uint_sync_1
      • profiles_2

            Assignee:
            Unassigned
            Reporter:
            Alexander Vladishev
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 1h
                1h