Marostegui added a comment.

@aude: don't run update.php on s3 for altering a table- you will create lag
on 900 wikis unless connections are cleared and table is pre-warmed-up (and
appropiately tested).

Also, the only wiki mentioned here was wikidatawiki, you have to create a
separate request for other wikis.

Ah, thanks for the good catch, I didn't know he meant s3 (I thought he was talking about another small host or something that wasn't on my radar, hence my two questions to see where that database he wanted to alter lives in, as I was planning to check the table size and if there were slaves or stuff).
I am glad you mentioned s3 now I have the full picture.

By the way:

root@db1075:/srv/sqldata/testwikidatawiki# ls -lh wb_terms.ibd
-rw-rw---- 1 mysql mysql 68M May 14 13:43 wb_terms.ibd

TASK DETAIL
https://phabricator.wikimedia.org/T162539

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

To: Marostegui
Cc: Stashbot, hoo, jcrespo, Marostegui, WMDE-leszek, Lydia_Pintscher, daniel, Aklapper, gerritbot, aude, Ladsgroup, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, Lewizho99, Minhnv-2809, Maathavan, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Reply via email to