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 ([mw:RFC/Content_model_storage](https://www.mediawiki.org/wiki/Talk:Requests_for_comment/Content_model_storage))
Decide how to proceed regarding the storage of content model and format in the database. A proposal for this was approved a year ago, but never implemented, possibly because the solution overlaps with planned work for supporting multi-content-revisions. Three options are up for discussion:
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.
Should we agree on (1) or (2), the expectation is that the proposal will be put on "last call", and then be implemented very soon.
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/)**