Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-6892

Zabbix MySQL DB schema contains clustered indexes with redundant suffixes

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • 2.1.1
    • 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

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

              Created:
              Updated:

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