[Wikidata-bugs] [Maniphest] [Commented On] T144010: Drop eu_touched in production

[Marostegui]

Marostegui added a comment.

Similar to T144010#2737391 I have renamed the column on db1110 in eqiad, which is a host that receives reads. We'll see if some errors arise.

root@db1110[dewiki]> show create table wbc_entity_usage;
+------------------+--------------------------------------------------------------------------------------------------------------------
| Table            | Create Table
+------------------+--------------------------------------------------------------------------------------------------------------------
| wbc_entity_usage | CREATE TABLE `wbc_entity_usage` (
  `eu_row_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `eu_entity_id` varbinary(255) NOT NULL,
  `eu_aspect` varbinary(37) NOT NULL,
  `eu_page_id` int(11) NOT NULL,
  `TO_DROP_eu_touched` binary(14) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  PRIMARY KEY (`eu_row_id`),
  UNIQUE KEY `eu_entity_id` (`eu_entity_id`,`eu_aspect`,`eu_page_id`),
  KEY `eu_page_id` (`eu_page_id`,`eu_entity_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32592567 DEFAULT CHARSET=binary |

TASK DETAIL

https://phabricator.wikimedia.org/T144010

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Marostegui
Cc: Stashbot, PokestarFan, Marostegui, jcrespo, Aklapper, gerritbot, hoo, AndyTan, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, Minhnv-2809, Luke081515, Wikidata-bugs, aude, Mbch331, Jay8g, Krenair

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs