First step in addressing the parent ticket. And at least reducing the growth rate of s1 and s8
Description
Details
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Stalled | None | T174043 Deploy Multi-Content Revisions | |||
Stalled | None | T174045 DB schema migration for MCR | |||
Open | None | T183490 MCR schema migration stage 4: Migrate External Store URLs (wmf production) | |||
Resolved | Ladsgroup | T366705 beta-update-databases-eqiad failure for frwiktionary | |||
Resolved | Ladsgroup | T362566 Stop growth of text table by storing ES addresses in content table |
Event Timeline
Change #1020948 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[mediawiki/core@master] SqlBlobStore: Directly store ES addresses in content table
Change #1020948 merged by jenkins-bot:
[mediawiki/core@master] SqlBlobStore: Directly store ES addresses in content table
MariaDB [enwiki]> select * from content where content_id = 547295; +------------+--------------+---------------------------------+---------------+------------------------------------------+ | content_id | content_size | content_sha1 | content_model | content_address | +------------+--------------+---------------------------------+---------------+------------------------------------------+ | 547295 | 66 | lp53apdzyatqddqr5uvcrzn8cecx7m0 | 1 | es:DB://cluster1/692465?flags=utf-8,gzip | +------------+--------------+---------------------------------+---------------+------------------------------------------+ 1 row in set (0.001 sec)
root@deployment-db14:/srv/sqldata/enwiki# ls -l | grep -i text -rw-r----- 1 mysql mysql 973 Feb 26 21:36 aft_article_answer_text.frm -rw-r----- 1 mysql mysql 65536 Feb 26 21:32 aft_article_answer_text.ibd -rw-r----- 1 mysql mysql 1001 Feb 26 21:36 text.frm -rw-r----- 1 mysql mysql 432013312 May 4 19:21 text.ibd -rw-r----- 1 mysql mysql 1001 Feb 26 21:36 unittest_external_text.frm -rw-r----- 1 mysql mysql 65536 Feb 26 21:32 unittest_external_text.ibd
Everything works as expected.
Change #1028865 had a related patch set uploaded (by Ladsgroup; author: Amir Sarabadani):
[mediawiki/core@wmf/1.43.0-wmf.3] Partial cherry-pick of I9d8409fdbd757e
Change #1028865 merged by jenkins-bot:
[mediawiki/core@wmf/1.43.0-wmf.3] Partial cherry-pick of I9d8409fdbd757e
Mentioned in SAL (#wikimedia-operations) [2024-05-07T19:18:53Z] <jhuneidi@deploy1002> Started scap: Backport for [[gerrit:1028865|Partial cherry-pick of I9d8409fdbd757e (T361398 T362566)]]
Mentioned in SAL (#wikimedia-operations) [2024-05-07T19:21:29Z] <jhuneidi@deploy1002> ladsgroup and jhuneidi: Backport for [[gerrit:1028865|Partial cherry-pick of I9d8409fdbd757e (T361398 T362566)]] synced to the testservers (https://wikitech.wikimedia.org/wiki/Mwdebug)
Mentioned in SAL (#wikimedia-operations) [2024-05-07T19:34:33Z] <jhuneidi@deploy1002> Finished scap: Backport for [[gerrit:1028865|Partial cherry-pick of I9d8409fdbd757e (T361398 T362566)]] (duration: 15m 39s)