Skip to content

Instantly share code, notes, and snippets.

@tvlooy
Created February 20, 2015 20:22
Show Gist options
  • Select an option

  • Save tvlooy/222f597c41904b7bb7bb to your computer and use it in GitHub Desktop.

Select an option

Save tvlooy/222f597c41904b7bb7bb to your computer and use it in GitHub Desktop.
pt-duplicate-key-checker on Drupal 8 (after this patch https://www.drupal.org/node/2428297)
root@Debian77:~# pt-duplicate-key-checker --user=root --password=vagrant --database=drupal8
# ########################################################################
# drupal8.url_alias
# ########################################################################
# Key source_langcode_pid ends with a prefix of the clustered index
# Key definitions:
# KEY `source_langcode_pid` (`source`,`langcode`,`pid`)
# PRIMARY KEY (`pid`),
# Column types:
# `source` varchar(255) not null default '' comment 'the drupal path this alias is for; e.g. node/12.'
# `langcode` varchar(12) not null default '' comment 'the language code this alias is for; if ''und'', the alias will be used for unknown languages. each drupal path can have an alias for each supported language.'
# `pid` int(10) unsigned not null auto_increment comment 'a unique path alias identifier.'
# To shorten this duplicate clustered index, execute:
ALTER TABLE `drupal8`.`url_alias` DROP INDEX `source_langcode_pid`, ADD INDEX `source_langcode_pid` (`source`,`langcode`);
# Key alias_langcode_pid ends with a prefix of the clustered index
# Key definitions:
# KEY `alias_langcode_pid` (`alias`,`langcode`,`pid`),
# PRIMARY KEY (`pid`),
# Column types:
# `alias` varchar(255) not null default '' comment 'the alias for this path; e.g. title-of-the-story.'
# `langcode` varchar(12) not null default '' comment 'the language code this alias is for; if ''und'', the alias will be used for unknown languages. each drupal path can have an alias for each supported language.'
# `pid` int(10) unsigned not null auto_increment comment 'a unique path alias identifier.'
# To shorten this duplicate clustered index, execute:
ALTER TABLE `drupal8`.`url_alias` DROP INDEX `alias_langcode_pid`, ADD INDEX `alias_langcode_pid` (`alias`,`langcode`);
# ########################################################################
# Summary of indexes
# ########################################################################
# Size Duplicate Indexes 1618
# Total Duplicate Indexes 2
# Total Indexes 221
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment