I have some recent (and CC!) material I can use:
http://www.slideshare.net/jynus/mysql-schema-design-in-practice
http://www.slideshare.net/jynus/query-optimization-from-0-to-10-and-up-to-57

Can you add related tags/projects, please?

I am sorry, @Qgil, are there Summit-specific tags or do you mean general phab categories/tags?

General projects/tags. The idea is that people who are watching those tags/projects are aware that this proposal has been submitted.

Soliciting SQL queries to fix/optimize on labs-l: https://lists.wikimedia.org/pipermail/labs-l/2016-December/004835.html

This session is my personal current pick for most important in the "APIs and Developer Resources" track because of the potential to reuse the recorded talk to help many Labs and Tool Labs developers.

... on the other hand this basically looks like a proposal for a presentation/training session? The description doesn't offer any points for discussion and this task has been consistently silent so far.

Video recording should not be the main reason to make this proposal the top pick of your main topic. Number of people interested at the event should be a stronger factor. There will be video recording available in other rooms as well.

In terms of space, what would be your preferred option?

• The biggest room in theater configuration (up to 200 people, only chairs, no tables) and required video recording (meaning also that people have to wait for the mic to speak etc).
• A big room in classroom configuration (up to 70-80 people, chairs and tables) and required video recording (meaning also that people have to wait for the mic to speak etc).
• A big room in classroom configuration (up to 70-80 people, chairs and tables) and optional video recording (i.e. only recording the initial introduction but then relaxing things during the discussion, or no recording at all).
• A smaller room, flexible configuration, optional video recording...

In T149624#2853591, @Qgil wrote:

... on the other hand this basically looks like a proposal for a presentation/training session? The description doesn't offer any points for discussion and this task has been consistently silent so far.

From the abstract:

• Answer community questions about how to do some things better
• Get suggestions on how to improve the labsdb service

Does it have tens of questions already stacked up? No, it does not. Will it have some by the point that the conference starts? I really don't know. Ideally yes, but in the world of the wikis it seems that the only topics which draw discussion are subjects of high contention or at least subjects where there is one tireless detractor. I'd be pretty surprised to see someone challenge @jcrespo on query optimization and the architecture and advantages of the new labsdb cluster that is rolling out.

Potential question for discussion (or moving to somewhere more appropriate!) -

• Where should volunteers go to get help, if they are having difficulties with Quarry, either due to
  • (a) not knowing where to even begin writing/adapting a query,
  • (b) their own inefficiently written queries (which just need minor tweaking), or
  • (c) due to unavoidable timeouts even with efficient queries (which would need to be run from a terminal)?

Context: I regularly see questions in various IRC channels, with people at various levels of SQL expertise, asking how to do something, or why something isn't working.
It would be best to direct these people somewhere onwiki, so that busy staffers aren't getting pinged whilst they're busy with something else, or asleep, or etc. There currently doesn't seem to be an ideal place to point people towards, beyond suggesting they look through the examples given in these 2 pages:

• https://wikitech.wikimedia.org/wiki/Help:MySQL_queries
• https://meta.wikimedia.org/wiki/Grants:Evaluation/Wikiresearch_webinars

https://quarry.wmflabs.org itself, points to https://www.mediawiki.org/wiki/Talk:Quarry from "Discuss", and I see there are quite a few questions along these lines - perhaps that page just needs to be watchlisted/regularly-checked by a few more SQL experts? (And then linked to, from the other relevant pages.) Then we can point people to there from IRC, with more confidence.

For unavoidably expensive queries, I think we need a [queue/process/thing], where non-experts can request that somebody else run a query for them, from terminal.
(I.e. IIUC, I could hypothetically follow the instructions at https://wikitech.wikimedia.org/wiki/Help:Tool_Labs#Database_access to re-run a timing-out Quarry query, but that's way outside my comfort-area, and I wouldn't know if I was about to cause problems by running a badly written or insane query. I like the safety-net of an auto-timeout! It gives me the comfort to experiment.)

To the owner of this session: Here is the link to the session guidelines page: https://www.mediawiki.org/wiki/Wikimedia_Developer_Summit/2017/Session_Guidelines. We encourage you to recruit Note-taker(s) 2(min) and 3(max), Remote Moderator, and Advocate (optional) on the spot before the beginning of your session. Instructions about each role player's task are outlined in the guidelines. The physical version of the role cards will be made available in all the session rooms. Good luck prepping, see you at the summit! :)

Thank you.

Note-taker(s) of this session: Follow the instructions here: https://www.mediawiki.org/wiki/Wikimedia_Developer_Summit/2017/Session_Guidelines#NOTE-TAKER.28S.29 After the session, DO NOT FORGET to copy the relevant notes and summary into a new wiki page following the template here: https://www.mediawiki.org/wiki/Wikimedia_Developer_Summit/2017/Your_Session and also link this from the All Session Notes page: https://www.mediawiki.org/wiki/Wikimedia_Developer_Summit/2017/All_Session_Notes. The EtherPad links are also now linked from the Schedule page (https://www.mediawiki.org/wiki/Wikimedia_Developer_Summit/2017/Schedule) for you!

Etherpad at https://etherpad.wikimedia.org/p/devsummit17-Labsdbs

Slides at: https://commons.wikimedia.org/wiki/File:Labsdbs-_get_more_data,_faster.pdf

I have moved the notes to https://www.mediawiki.org/wiki/Wikimedia_Developer_Summit/2017/Labsdb