⚓ T273361 Schema change for renaming two indexes of site

Ladsgroup created this task.Jan 30 2021, 12:51 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJan 30 2021, 12:51 PM

Marostegui claimed this task.Feb 1 2021, 9:11 AM

Marostegui triaged this task as Medium priority.

Marostegui moved this task from Backlog to In progress on the Schema-change-in-production board.

Marostegui updated the task description. (Show Details)

Altered s6 codfw - leaving it for a day before going for some slaves in eqiad

# for i in frwiki jawiki ruwiki; do echo $i; mysql.py -hdb2097:3316 $i -e "show create table site_identifiers\G" | grep KEY ; done
frwiki
  PRIMARY KEY (`si_type`,`si_key`),
  KEY `si_site` (`si_site`),
  KEY `si_key` (`si_key`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
jawiki
  PRIMARY KEY (`si_type`,`si_key`),
  KEY `si_site` (`si_site`),
  KEY `si_key` (`si_key`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
ruwiki
  PRIMARY KEY (`si_type`,`si_key`),
  KEY `si_site` (`si_site`),
  KEY `si_key` (`si_key`)
) ENGINE=InnoDB DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8