Marostegui added a comment.
db2084 got those keys dropped:
root@db2084.codfw.wmnet[wikidatawiki]> show create table wb_changes;
+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table
|
+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| wb_changes | CREATE TABLE `wb_changes` (
`change_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`change_type` varbinary(25) NOT NULL,
`change_time` varbinary(14) NOT NULL,
`change_object_id` varbinary(14) NOT NULL,
`change_revision_id` int(10) unsigned NOT NULL,
`change_user_id` int(10) unsigned NOT NULL,
`change_info` mediumblob NOT NULL,
PRIMARY KEY (`change_id`),
KEY `wb_changes_change_type` (`change_type`),
KEY `wb_changes_change_time` (`change_time`),
KEY `wb_changes_change_object_id` (`change_object_id`),
KEY `wb_changes_change_user_id` (`change_user_id`),
KEY `wb_changes_change_revision_id` (`change_revision_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1274872346 DEFAULT CHARSET=binary
ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 |
+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.032 sec)
root@db2084.codfw.wmnet[wikidatawiki]> alter table wb_changes drop key
wb_changes_change_type, drop key wb_changes_change_object_id, drop key
wb_changes_change_user_id, drop key wb_changes_change_revision_id;
Query OK, 0 rows affected (0.101 sec)
Records: 0 Duplicates: 0 Warnings: 0
root@db2084.codfw.wmnet[wikidatawiki]> show create table wb_changes;
+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table
|
+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| wb_changes | CREATE TABLE `wb_changes` (
`change_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`change_type` varbinary(25) NOT NULL,
`change_time` varbinary(14) NOT NULL,
`change_object_id` varbinary(14) NOT NULL,
`change_revision_id` int(10) unsigned NOT NULL,
`change_user_id` int(10) unsigned NOT NULL,
`change_info` mediumblob NOT NULL,
PRIMARY KEY (`change_id`),
KEY `wb_changes_change_time` (`change_time`)
) ENGINE=InnoDB AUTO_INCREMENT=1274872503 DEFAULT CHARSET=binary
ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 |
+------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.032 sec)
I am going to slowly repool it back, we need to look for regressions there.
@Ladsgroup if you have some queries in mind, please try them there to see
what's the response time.
TASK DETAIL
https://phabricator.wikimedia.org/T262856
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Marostegui
Cc: Kormat, Marostegui, Lucas_Werkmeister_WMDE, Addshore, Aklapper, Ladsgroup,
LSobanski, Akuckartz, Iflorez, darthmon_wmde, Nandana, Lahi, Gq86,
GoranSMilovanovic, QZanden, LawExplorer, Minhnv-2809, _jensen, rosalieper,
Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331, Jay8g, Krenair
_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
