Springle added a subscriber: jcrespo.
Herald added a subscriber: Aklapper.
TASK DETAIL
https://phabricator.wikimedia.org/T62539
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Springle
Cc: Aklapper, jcrespo, greg, aude, Springle, MZMcBride
Springle added a comment.
Smaller fields are still better for performance, so I vote for a conservative
300, unless 400 is demonstrably needed.
Correct, 767 bytes (bytes, not characters) is the limit for a single InnoDB
index with our current DB config, which is enough, and in any case
Springle closed this task as Resolved.
Springle added a comment.
Done.
Actually, this was fun. Dropping a not-null field across the fleet without
causing replag or explosion needs an unusual approach. Will update wikitech and
the OSC script for this scenario.
TASK DETAIL
https
Springle closed blocking task T95179: Deploy schema changes to wbc_entity_usage
table on wikidatawiki as Resolved.
TASK DETAIL
https://phabricator.wikimedia.org/T95181
REPLY HANDLER ACTIONS
Reply to comment or attach files, or !close, !claim, !unsubscribe or !assign
username.
EMAIL
Springle added a comment.
In https://phabricator.wikimedia.org/T96468#1222975, @Krenair wrote:
- Sanitarium config (@Coren/@Springle? This needs your confirmation)
Sanitarium is ready.
Not yet confirmed for labs replica views, but that need not block the wiki
creation upstream.
TASK
Springle added a comment.
Anything touching wikidatawiki needs to be done online, either with the OSC
script (a wrapper for percona toolkit) or slave-by-slave depool/repool. The
kind of change described in this ticket can be done using --no-replicate. It
should be added to the tracking ticket
Springle added a comment.
Unsure if your #1 and #2 are both on labsdb replicas, or if #2 is some other db
like tools-db or a custom instance.
If #1 and #2 are both connections to the labsdb production replicas, then yes,
either connection going idle for 60s will result in its disconnection
Springle added a comment.
No smoking gun yet.
As discussed a few times on labs-l in order fight abuse and replag we kill
things explicitly when:
1. A query runs for more that 28800 seconds
2. One or more queries are about to collectively cause an OOM (rare)
3. A client holds a connection open