Comments on: Sessions of interest in Percona Live 2013 https://shlomi-noach.github.io/blog/mysql/sessions-of-interest-in-percona-live-2013 Blog by Shlomi Noach Mon, 11 Feb 2013 07:00:15 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Win a free Percona Live 2013 pass — unveiling riddle hints | code.openark.org https://shlomi-noach.github.io/blog/mysql/sessions-of-interest-in-percona-live-2013/comment-page-1#comment-177760 Mon, 11 Feb 2013 07:00:15 +0000 https://shlomi-noach.github.io/blog/?p=5913#comment-177760 […] Sessions of interest in Percona Live 2013 […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/sessions-of-interest-in-percona-live-2013/comment-page-1#comment-177759 Mon, 11 Feb 2013 06:58:48 +0000 https://shlomi-noach.github.io/blog/?p=5913#comment-177759 @vishnu,

Sorry – not the right answer. Please see my followup post today for some hints.

]]> By: vishnu rao https://shlomi-noach.github.io/blog/mysql/sessions-of-interest-in-percona-live-2013/comment-page-1#comment-177701 Mon, 11 Feb 2013 03:18:16 +0000 https://shlomi-noach.github.io/blog/?p=5913#comment-177701 Shiomi,

i would now guess its ‘jetpants’.

line2 could be interpreted also – how developer friendly it is – reduces human error / set of scripts etc
etc

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/sessions-of-interest-in-percona-live-2013/comment-page-1#comment-177458 Sun, 10 Feb 2013 18:29:55 +0000 https://shlomi-noach.github.io/blog/?p=5913#comment-177458 @vishnu – I don’t see an answer here, so at this time I will not even tell you whether you’re going the right way or not… Good of you to try and break down the riddle.

@Andrew – not answering yet whether your answer is correct or not — but would you care to elaborate?

]]> By: Andrew Moore https://shlomi-noach.github.io/blog/mysql/sessions-of-interest-in-percona-live-2013/comment-page-1#comment-177397 Sun, 10 Feb 2013 16:25:20 +0000 https://shlomi-noach.github.io/blog/?p=5913#comment-177397 The ‘query optimizer’, Shlomi?

]]> By: vishnu rao https://shlomi-noach.github.io/blog/mysql/sessions-of-interest-in-percona-live-2013/comment-page-1#comment-176658 Sat, 09 Feb 2013 13:04:28 +0000 https://shlomi-noach.github.io/blog/?p=5913#comment-176658 line2 – means that the tool forces the client to play good with the db.

line 3 – talks abouts making everything clean and tidy – i.e. this could mean rebalancing / re distributing data across the storage

it has to do something with sharding and balancing shards.

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/sessions-of-interest-in-percona-live-2013/comment-page-1#comment-176177 Fri, 08 Feb 2013 19:10:02 +0000 https://shlomi-noach.github.io/blog/?p=5913#comment-176177 What, not a single guess?

]]> By: Justin Swanhart https://shlomi-noach.github.io/blog/mysql/sessions-of-interest-in-percona-live-2013/comment-page-1#comment-173971 Tue, 05 Feb 2013 20:17:23 +0000 https://shlomi-noach.github.io/blog/?p=5913#comment-173971 It is probably close to trivial to write a http://code.google.com/p/shard-key-mapper range mapping plugin compatible with Jetpants, because it could simply use the Jetpants metadata.

Shard-Query uses the Shard-Key-Mapper interface for enumerating shards and mapping requests to them. SQ is very pluggable, including sharding metadata, query routing, the database access layer and even user defined functions (partially pluggable parser).

This would allow you to run OLTP queries via their framework (lightweight parser) and OLAP queries via the Shard-Query proxy (heavy parser + extra latency, but parallel query and aggregation).

]]>