[08:28:33] DBA, OTRS: OTRS database is "too large" - https://phabricator.wikimedia.org/T138915#2413851 (jcrespo) [08:32:06] akosiaris ^ [12:02:05] DBA, OTRS: OTRS database is "too large" - https://phabricator.wikimedia.org/T138915#2413851 (pajz) Just noting here that OTRS started to include a script to move attachments from the database to the filesystem a couple of versions back, see https://otrs.github.io/doc/manual/admin/stable/en/html/performan... [12:08:15] lol [12:20:12] DBA, OTRS: OTRS database is "too large" - https://phabricator.wikimedia.org/T138915#2414542 (jcrespo) @pajz Thank you for the tip- The otrs owner already mention that as a possibility. I am personally unsure if we will go that way- probably it will depend on how many of those files are there and how eas... [12:54:19] DBA, OTRS: OTRS database is "too large" - https://phabricator.wikimedia.org/T138915#2414663 (akosiaris) I 've been starting to look into the storage of articles/attachment in the filesystem. It is the recommended way of storing attachments in large setups (and/or large attachment sizes). We don't control... [16:29:45] DBA, Performance-Team, Availability, MW-1.27-release-notes, and 2 others: Make LoadBalancer slave lag check and read-only mode more robust (for example, using pt-heartbeat) - https://phabricator.wikimedia.org/T111266#2415159 (jcrespo) So, I need an extra brain about heartbeat architecture, and de... [17:22:24] DBA, Labs: Labs database replica drift - https://phabricator.wikimedia.org/T138967#2415416 (valhallasw) [17:32:04] DBA, Labs: Labs database replica drift - https://phabricator.wikimedia.org/T138967#2415464 (jcrespo) [17:33:49] DBA, Labs: Labs database replica drift - https://phabricator.wikimedia.org/T138967#2415416 (jcrespo) [17:33:52] DBA, Labs, Operations, Tracking: Database replication services (tracking) - https://phabricator.wikimedia.org/T50930#2415469 (jcrespo) [18:39:53] DBA, Datasets-General-or-Unknown, Patch-For-Review: Select of revisions for stub history files does not explicitly order revisions - https://phabricator.wikimedia.org/T29112#2415663 (ArielGlenn) Thanks to MaxSem and Chad, this is now deployed for 1.28.0-wmf.7 and 1.28.0-wmf.8. It ***should*** impact... [19:40:43] DBA, Beta-Cluster-Infrastructure, Continuous-Integration-Infrastructure, MediaWiki-Database, WorkType-NewFunctionality: Enable MariaDB/MySQL's Strict Mode - https://phabricator.wikimedia.org/T108255#1516355 (Anomie) One potential issue I see with `ONLY_FULL_GROUP_BY` is that the optimizer sti... [20:03:17] DBA, Operations, ops-codfw: es2017 and es2019 crashed with no logs - https://phabricator.wikimedia.org/T130702#2415881 (Papaul) @jcrespo any new update on es2017? [20:05:56] DBA, Operations, ops-codfw: es2017 and es2019 crashed with no logs - https://phabricator.wikimedia.org/T130702#2415898 (jcrespo) No. No crash. But I was expecting to hear their response from support. [20:55:31] DBA, Beta-Cluster-Infrastructure, Continuous-Integration-Infrastructure, MediaWiki-Database, WorkType-NewFunctionality: Enable MariaDB/MySQL's Strict Mode - https://phabricator.wikimedia.org/T108255#2416094 (jcrespo) This was fixed on 5.7: http://mysqlserverteam.com/mysql-5-7-only_full_group_... [22:20:46] DBA, Patch-For-Review: dbstore1001 low available space - https://phabricator.wikimedia.org/T131705#2416388 (jcrespo) This has been solved temporarily by moving away otrs backups to es2001. The above patch will move them permanently.