Created
February 20, 2015 20:22
-
-
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)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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