-
Problem report
-
Resolution: Fixed
-
Trivial
-
7.0.0alpha6
-
None
-
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.