Continuing with the background task of unifying revision table in all the shards, this is a task to fix s2:
bgwiki bgwiktionary cswiki enwikiquote enwiktionary eowiki fiwiki idwiki itwiki nlwiki nowiki plwiki ptwiki svwiki thwiki trwiki zhwiki
Most of the slaves look like:
PRIMARY KEY (`rev_page`,`rev_id`), UNIQUE KEY `rev_id` (`rev_id`), KEY `rev_timestamp` (`rev_timestamp`), KEY `page_timestamp` (`rev_page`,`rev_timestamp`), KEY `user_timestamp` (`rev_user`,`rev_timestamp`), KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`)
So they'd need:
./osc_host.sh --host=xxxx --port=3306 --db=$i --table=revision --method=ddl --no-replicate "drop key rev_id, drop primary key, add primary key (rev_id), add key page_user_timestamp (rev_page,rev_user,rev_timestamp), add key rev_page_id (rev_page,rev_id)"
The rc slaves (db2035, db1036) need minor fixing for the following databases only:
bgwiktionary eowiki idwiki
As those look like:
PRIMARY KEY (`rev_page`,`rev_id`), UNIQUE KEY `rev_id` (`rev_id`), KEY `rev_timestamp` (`rev_timestamp`,`rev_id`), KEY `page_timestamp` (`rev_page`,`rev_timestamp`,`rev_id`), KEY `user_timestamp` (`rev_user`,`rev_timestamp`,`rev_id`), KEY `usertext_timestamp` (`rev_user_text`,`rev_timestamp`,`rev_id`), KEY `page_user_timestamp` (`rev_page`,`rev_user`,`rev_timestamp`,`rev_id`), KEY `rev_page_id` (`rev_page`,`rev_id`)
So they would need:
drop key rev_id, drop primary key, add primary key (rev_id,rev_user);