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

Remove redundant index

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • 7.0 (plan)
    • 7.0.0alpha6
    • Server (S)
    • None

      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.

            zabbix.dev Zabbix Development Team
            arimdjonoks Artjoms Rimdjonoks
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: