{"id":7002,"date":"2014-09-23T11:21:13","date_gmt":"2014-09-23T09:21:13","guid":{"rendered":"http:\/\/code.openark.org\/blog\/?p=7002"},"modified":"2014-09-23T16:04:54","modified_gmt":"2014-09-23T14:04:54","slug":"three-wishes-for-a-new-year-3","status":"publish","type":"post","link":"https:\/\/code.openark.org\/blog\/mysql\/three-wishes-for-a-new-year-3","title":{"rendered":"Three wishes for a new year"},"content":{"rendered":"<div>\n<p>Another new year by Jewish calendar. What do I wish for the following year?<\/p>\n<ol>\n<li>World peace<\/li>\n<li>Good health to all<\/li>\n<li>Multi-core execution for queries<\/li>\n<\/ol>\n<p>After having evaluated a few columnar databases, and having seen how a single query gets 24 cores busy, I can&#8217;t look at MySQL the same way again. The fact that a single query consumes a single core only doesn&#8217;t seem right in the year 2014. <a href=\"https:\/\/github.com\/greenlion\/swanhart-tools\/tree\/master\/shard-query\">Shard-query<\/a> is a cool application-level attempt to solve the above; I would like to see stuff like this implemented inside the server (or inside the storage engine where possible).<\/p>\n<p>None of my wishes in previous years [<a href=\"http:\/\/code.openark.org\/blog\/mysql\/three-wishes-for-a-new-year\">2010<\/a>], [<a href=\"http:\/\/code.openark.org\/blog\/mysql\/three-wishes-for-a-new-year-2\">2011<\/a>], [<a href=\"http:\/\/code.openark.org\/blog\/mysql\/three-wishes-for-a-new-year-201\">2012<\/a>], [<a href=\"http:\/\/code.openark.org\/blog\/mysql\/three-wished-for-a-new-year-2013\">2013<\/a>] came true (and mostly gone worse). I&#8217;m still willing to settle for two out of three.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Another new year by Jewish calendar. What do I wish for the following year? World peace Good health to all Multi-core execution for queries After having evaluated a few columnar databases, and having seen how a single query gets 24 cores busy, I can&#8217;t look at MySQL the same way again. The fact that a [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[5],"tags":[51,112],"class_list":["post-7002","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-opinions","tag-secondary"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2bZZp-1OW","_links":{"self":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/7002","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/comments?post=7002"}],"version-history":[{"count":3,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/7002\/revisions"}],"predecessor-version":[{"id":7005,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/7002\/revisions\/7005"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/media?parent=7002"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/categories?post=7002"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/tags?post=7002"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}