Page MenuHomePhabricator

Remove commonswiki.templatelinks partitions
Closed, ResolvedPublic

Description

For some reason db1144:3314 has partitions on the commonwiki.templatelinks table.
This must be a leftover from T149079

This is the only host that has them:

labsdb1012.eqiad.wmnet:3306
labsdb1011.eqiad.wmnet:3306
labsdb1010.eqiad.wmnet:3306
labsdb1009.eqiad.wmnet:3306
dbstore1004.eqiad.wmnet:3314
db2140.codfw.wmnet:3306
db2139.codfw.wmnet:3314
db2138.codfw.wmnet:3314
db2137.codfw.wmnet:3314
db2136.codfw.wmnet:3306
db2119.codfw.wmnet:3306
db2110.codfw.wmnet:3306
db2106.codfw.wmnet:3306
db2099.codfw.wmnet:3314
db2095.codfw.wmnet:3314
db2090.codfw.wmnet:3306
db2073.codfw.wmnet:3306
db1149.eqiad.wmnet:3306
db1148.eqiad.wmnet:3306
db1147.eqiad.wmnet:3306
db1146.eqiad.wmnet:3314
db1145.eqiad.wmnet:3314
db1144.eqiad.wmnet:3314
 PARTITION BY RANGE (`tl_namespace`)
(PARTITION `p_9` VALUES LESS THAN (10) ENGINE = InnoDB,
 PARTITION `p_10` VALUES LESS THAN (11) ENGINE = InnoDB,
 PARTITION `p_827` VALUES LESS THAN (828) ENGINE = InnoDB,
 PARTITION `p_828` VALUES LESS THAN (829) ENGINE = InnoDB,
 PARTITION `p_max` VALUES LESS THAN MAXVALUE ENGINE = InnoDB)
db1143.eqiad.wmnet:3306
db1142.eqiad.wmnet:3306
db1141.eqiad.wmnet:3306
db1138.eqiad.wmnet:3306
db1125.eqiad.wmnet:3314
db1121.eqiad.wmnet:3306
db1081.eqiad.wmnet:3306

Event Timeline

Marostegui triaged this task as Medium priority.Jul 27 2020, 2:58 PM
Marostegui moved this task from Triage to In progress on the DBA board.
mysql:root@localhost [commonswiki]>  alter table templatelinks remove partitioning;
Query OK, 2383408636 rows affected (10 hours 40 min 48.339 sec)
Records: 2383408636  Duplicates: 0  Warnings: 0

mysql:root@localhost [commonswiki]> show create table templatelinks\G
*************************** 1. row ***************************
       Table: templatelinks
Create Table: CREATE TABLE `templatelinks` (
  `tl_from` int(8) unsigned NOT NULL DEFAULT 0,
  `tl_namespace` int(11) NOT NULL DEFAULT 0,
  `tl_title` varbinary(255) NOT NULL DEFAULT '',
  `tl_from_namespace` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`tl_from`,`tl_namespace`,`tl_title`),
  KEY `tl_namespace` (`tl_namespace`,`tl_title`,`tl_from`),
  KEY `tl_backlinks_namespace` (`tl_from_namespace`,`tl_namespace`,`tl_title`,`tl_from`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
1 row in set (0.000 sec)