Agenda
----------
- Location: #wikimedia-office IRC channel
- [Meeting type](https://www.mediawiki.org/wiki/Good_meetings#Taxonomy): Consensus for final comment (on the three options).
- Time: Weekly, Wednesday 21:00 UTC (2pm [PDT](https://en.wikipedia.org/wiki/America/Los_Angeles), 23:00 [CEST](https://en.wikipedia.org/wiki/Central_European_Summer_Time))
- Topic: T105652 Content model storage
In this meeting, we discussed the storage of content model and format in the database. A proposal (T105652) was approved a year ago, but never implemented. Three options were discussed:
1. Implement {T105652} as originally approved a year ago, with new columns in the page, revision, and archive tables.
2. Implement a modified version, {T142980}, with one extra table but no new columns, to also cater to the needs of multi content revisions.
3. take a step back and reconsider.
We agreed that Daniel should continue to develop the plan articulated in T142980.
Meeting summary
---------------
* Please note: Channel is logged and publicly posted (DO NOT REMOVE THIS
NOTE) | Logs:
http://bots.wmflabs.org/~wm-bot/logs/%23wikimedia-office/ (robla,
21:03:15)
* LINK: https://phabricator.wikimedia.org/E261 (robla, 21:03:31)
* LINK: https://phabricator.wikimedia.org/T105652 (robla, 21:03:47)
* LINK: https://phabricator.wikimedia.org/T105652 (DanielK_WMDE_,
21:03:48)
* LINK: https://phabricator.wikimedia.org/T142980 (DanielK_WMDE_,
21:03:54)
* LINK: https://phabricator.wikimedia.org/T142980 (DanielK_WMDE_ 's
revised proposal) (robla, 21:04:16)
* primary question to resolve: do a) legoktm 's original T105652 b)
DanielK_WMDE_ 's modification T142980 c) none of the above (stay
with status quo) (robla, 21:06:41)
* 14:08:34Â <legoktm>Â my original plan wasn't to do joins, but to store
the id => string mapping in a cache like APC since it would be
mostly static once initialized (robla, 21:09:24)
* ar_rev_id is not fully populated on enwiki. we can assign fresh
revision ids though (and bump rev_id accordingly) (DanielK_WMDE_,
21:15:31)
* <DanielK_WMDE_> we will need to construct legacy rows eventually,
when we move the blob address into the content table. (brion,
21:19:19)
* 14:16:31Â <jynus>Â the main issues happen when dataset doesn't fit
into memory, which is exactly what I blocked (as the initial rolling
in was going to do) (robla, 21:19:28)
* Discussion of DanielK_WMDE_'s question: "can I assume that there is
still consensus on representing content model and format as
integers, and have a mappoing in the db and in memory?" (robla,
21:23:20)
* <brion>Â jynus: I always hear enums are cheap to change. Lies? :)
<jynus>Â they are cheap to add [...]Â but if you want to delete, it
would be one of our most complex changes (robla, 21:26:14)
* re managing ids for content models etc: on a cache miss, check the
db. if the db doesn't have it, add it. (DanielK_WMDE_, 21:26:26)
* tentative agreement to content model and format as int; we rule out
option (c) then (DanielK_WMDE_, 21:28:38)
* <jynus>Â I think a) -> b) is easy to do, why do we want to do b
directly (genune question) (robla, 21:30:18)
* <DanielK_WMDE_>Â we have not discussed whether the new table should
just have the minimum fields for now, or the full set needed for MCR
<jynus>Â adding new columns on a small table with low traffic is easy
(robla, 21:53:42)
* 14:58:08Â <TimStarling>Â can I just repeat that I am putting my 2c in
for MCR fields in the initial content table, with slot=1 always
(robla, 21:59:12)
Meeting ended at 22:04:31 UTC.
People present (lines said)
---------------------------
* DanielK_WMDE_ (98)
* jynus (87)
* brion (45)
* TimStarling (33)
* robla (27)
* gwicke (26)
* anomie (20)
* legoktm (13)
* stashbot (9)
* James_F (4)
* SMalyshev (3)
* wm-labs-meetbot` (3)
* Scott_WUaS (3)
* ori (2)
* tgr (1)
* aude (1)
Full log
---------
{P3846}
Other meetings
------------------
| **[Architecture meetings](https://www.mediawiki.org/wiki/Architecture_meetings) ** |
|-----------------|
| 13:00 PT ArchCom Planning Meetings | [upcoming](https://phabricator.wikimedia.org/calendar/query/DlzGwrbxMLu9/) | [all since 2016-03-30](https://phabricator.wikimedia.org/calendar/query/M4fMy2PZOBQQ/) |
| **14:00 PT ArchCom-RFC Meetings** | **[upcoming](https://phabricator.wikimedia.org/calendar/query/ShzbHT6BPGCE/)** | **[all since 2015-09-09](https://phabricator.wikimedia.org/calendar/query/XJjy54s3PEFf/)**