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

Remove redundant index

XMLWordPrintable

    • S24-W32/33
    • 0.5

      pt-duplicate-key-checker tool detected that userdirectory_usrgrp_3 index is redundant

      # userdirectory_usrgrp_3 is a left-prefix of userdirectory_usrgrp_1
      # Key definitions:
      #   KEY `userdirectory_usrgrp_3` (`userdirectory_idpgroupid`),
      #   UNIQUE KEY `userdirectory_usrgrp_1` (`userdirectory_idpgroupid`,`usrgrpid`),
      # Column types:
      #      `userdirectory_idpgroupid` bigint unsigned not null
      #      `usrgrpid` bigint unsigned not null
      # To remove this duplicate index, execute:
      ALTER TABLE `zabbix`.`userdirectory_usrgrp` DROP INDEX `userdirectory_usrgrp_3`;
      

      left-prefix rule should apply to all DBs that use B-trees for indexing, which covers all primary DBs we support.

            arimdjonoks Artjoms Rimdjonoks
            arimdjonoks Artjoms Rimdjonoks
            Team C
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved:

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