Remove partitions from metawiki.pagelinks
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	• Marostegui
	Dec 14 2016, 1:18 PM

Description

The table pagelinks in the metawiki database has partitioning.
At this point MariaDB doesn't support moving partitions (https://jira.mariadb.org/browse/MDEV-11351) there is a non official procedure which might be to risky.
So for now

Remove partitioning

alter table pagelinks remove partitioning

Do the transfer to dbstore2001
Add partitioning back to db2068.? (Probably not needed as the new hosts in eqiad do not have them: T151552#2872382

alter table pagelinks
PARTITION BY RANGE (pl_namespace)
(PARTITION p_2 VALUES LESS THAN (3) ENGINE = InnoDB,
 PARTITION p_9 VALUES LESS THAN (10) ENGINE = InnoDB,
 PARTITION p_10 VALUES LESS THAN (11) ENGINE = InnoDB,
 PARTITION p_max VALUES LESS THAN MAXVALUE ENGINE = InnoDB);

Related Objects
Search...

Status	Assigned	Task
Resolved	• Marostegui	T130128 Fix dbstore2001 and dbstore2002
Resolved	• Marostegui	T151552 Import S2,S6,S7,m3 and x1 to dbstore2001 and dbstore2002
Resolved	• Marostegui	T153194 Remove partitions from metawiki.pagelinks

Event Timeline

• Marostegui created this task.Dec 14 2016, 1:18 PM

Restricted Application removed a project: Patch-For-Review. · View Herald TranscriptDec 14 2016, 1:18 PM

Mentioned in SAL (#wikimedia-operations) [2016-12-14T13:25:01Z] <marostegui> Deploy alter table to remove partitions on metawiki.pagelinks - db2068 - T153194

• MZMcBride subscribed.Dec 14 2016, 1:26 PM

This is now running on db2068:

./software/dbtools/osc_host.sh --host=db2068.codfw.wmnet --port=3306 --db=metawiki --table=pagelinks --method=ddl --no-replicate "remove partitioning"

• Marostegui updated the task description. (Show Details)Dec 14 2016, 3:10 PM

• Marostegui moved this task from Triage to In progress on the DBA board.

The partitions are now removed

root@neodymium:/home/marostegui/git/software/dbtools# mysql -hdb2068.codfw.wmnet -A metawiki -e "show create table pagelinks\G"
*************************** 1. row ***************************
       Table: pagelinks
Create Table: CREATE TABLE `pagelinks` (
  `pl_from` int(8) unsigned NOT NULL DEFAULT '0',
  `pl_namespace` int(11) NOT NULL DEFAULT '0',
  `pl_title` varbinary(255) NOT NULL DEFAULT '',
  `pl_from_namespace` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `pl_from` (`pl_from`,`pl_namespace`,`pl_title`) KEY_BLOCK_SIZE=4,
  KEY `pl_namespace` (`pl_namespace`,`pl_title`,`pl_from`) KEY_BLOCK_SIZE=4,
  KEY `pl_backlinks_namespace` (`pl_from_namespace`,`pl_namespace`,`pl_title`,`pl_from`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8

Given that the new hosts in eqiad do not have partitions, I will not add them back to this host.

• Marostegui closed this task as Resolved.Dec 14 2016, 4:49 PM

• Marostegui mentioned this in T151552: Import S2,S6,S7,m3 and x1 to dbstore2001 and dbstore2002.Dec 14 2016, 5:14 PM

• Marostegui mentioned this in T153300: Remove partitions from metawiki.pagelinks in s7.Dec 15 2016, 10:50 AM

Remove partitions from metawiki.pagelinksClosed, ResolvedPublicActions

Description

Related ObjectsSearch...

Event Timeline

Remove partitions from metawiki.pagelinks
Closed, ResolvedPublic
Actions

Related Objects
Search...