[05:02:52] T105440 caught me out for the s6 partitioning, so it's a bit delayed... [05:04:50] jynus, springle: I drafted https://www.mediawiki.org/wiki/Requests_for_comment/Content_model_storage to clean this up. Your opinions would be appreciated before I send it on to wikitech-l :) [05:08:36] cool :) [06:44:07] legoktm, I think it is a step in the right direction, but I do not fully understand/it is not explicitly written how cm_id will be used [06:44:50] I assume cm_id will be stored on *_content_model? [06:45:43] an example will help us (mainly other people) fully get it, as foreign keys are not defined [06:46:32] jynus: yes, the *_content_model and *_content_format columns will be replaced with a new column *_content_model_id that is cm_id [06:46:47] ah! now I get it [06:46:54] I will add an example [06:47:11] and more resons to do that [06:47:16] thanks :) [06:47:44] btw, are you coming to wikimania? [06:48:01] legoktm, nope, have to keep the whole things up [06:48:10] :( [06:48:16] legoktm, one question [06:48:26] sure [06:49:06] from time to time we see slow queries on the logs and I would like to present suggestion for improvement (but not tickets) [06:49:25] what would you consider a good mean to communicate with core devs? [06:49:46] (if you know it :-)) [06:50:14] phab tickets or wikitech-l for more involved discussions IMO [06:50:27] ok, thanks [06:51:27] will definitelly do some proposals to make the wiki faster for end users! [06:51:34] :D [08:41:17] re: 600GB revision table. "331G Jul 10 08:39 revision.ibd" on s1-master [08:41:59] I either double it with no reason or saw that value in another server [09:14:03] fun fact of the day: 5.7 to have super_read_only variable [13:43:31] jynus: were you going to edit the RfC? [13:44:02] yes, but I had no time yet, if you are going to share it, feel free to do it [13:44:45] ok, I [13:44:54] I'll do that after breakfast* [22:50:15] very short tendril downtime [22:50:28] i saw no DBAs working currently so going ahead [22:50:40] took backup [22:56:19] all done. tendril back [22:56:24] and freshly cloned from gerrit repo [22:56:41] it should now update on changes automatically [22:56:55] still one manual step was needed. to copy the config.php in place