{"id":3315,"date":"2013-04-27T09:25:23","date_gmt":"2013-04-26T23:25:23","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/?p=3315"},"modified":"2013-04-27T09:25:23","modified_gmt":"2013-04-26T23:25:23","slug":"tokudb","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2013\/04\/27\/tokudb\/","title":{"rendered":"TokuDB"},"content":{"rendered":"<p>Big news at Percona Live MySQL Conference and Expo this week, <a href=\"http:\/\/www.tokutek.com\/\">Tokutek<\/a> open sourced TokuDB thus making my previous post\u00c2\u00a0<a title=\"Permalink to Where are they now: MySQL Storage Engines\" href=\"http:\/\/www.flamingspork.com\/blog\/2013\/04\/18\/where-are-they-now-mysql-storage-engines\/\" rel=\"bookmark\">Where are they now: MySQL Storage Engines<\/a>\u00c2\u00a0out of date in just a few days.<\/p>\n<p>In this case, I <strong>really<\/strong> don&#8217;t mind. It&#8217;s rather exciting that they&#8217;ve gone ahead and done this &#8211; \u00c2\u00a0and it&#8217;s not just a code drop:\u00c2\u00a0<a href=\"https:\/\/github.com\/Tokutek\/ft-engine\">https:\/\/github.com\/Tokutek\/ft-engine<\/a>\u00c2\u00a0is where things are at, and recent commits were 2hrs and 18hrs ago which means that this is being maintained. This is certainly a good way to grow a developer community.<\/p>\n<p>While being a MySQL engine is really interesting, the MongoDB integration is certainly something to watch &#8211; and may be something quite huge for Tokutek (after all, it&#8217;s the database engine parts of Mongo that are the most troublesome &#8211; along with the client library license).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Big news at Percona Live MySQL Conference and Expo this week, Tokutek open sourced TokuDB thus making my previous post\u00c2\u00a0Where are they now: MySQL Storage Engines\u00c2\u00a0out of date in just a few days. In this case, I really don&#8217;t mind. &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2013\/04\/27\/tokudb\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_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":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[76,14],"tags":[371,628,515],"class_list":["post-3315","post","type-post","status-publish","format-standard","hentry","category-code","category-mysql","tag-mongodb","tag-mysql","tag-tokudb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/s5a6n8-tokudb","jetpack-related-posts":[{"id":2353,"url":"https:\/\/www.flamingspork.com\/blog\/2011\/04\/12\/innodb-and-memcached\/","url_meta":{"origin":3315,"position":0},"title":"innodb and memcached","author":"Stewart Smith","date":"2011-04-12","format":false,"excerpt":"I had a quick look at the source tree (I haven't compiled it, just read the source - that's what I do. I challenge any C\/C++ compiler to keep up with my brain!) that's got a tarball up on labs.mysql.com for the memcached interface to innodb. A few quick thoughts:\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3338,"url":"https:\/\/www.flamingspork.com\/blog\/2013\/05\/22\/some-storage-engine-features-you-only-get-if-youre-innodb\/","url_meta":{"origin":3315,"position":1},"title":"Some storage engine features you only get if you&#8217;re InnoDB","author":"Stewart Smith","date":"2013-05-22","format":false,"excerpt":"I had reason to look into the extended secondary index code in MariaDB and MySQL recently, and there was one bit that I really didn't like. MariaDB: share->set_use_ext_keys_flag(legacy_db_type == DB_TYPE_INNODB); MySQL: use_extended_sk= (legacy_db_type == DB_TYPE_INNODB); In case you were wondering what \"legacy_db_type\" actually does, let me tell you: it's not\u2026","rel":"","context":"In &quot;code&quot;","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3304,"url":"https:\/\/www.flamingspork.com\/blog\/2013\/05\/13\/the-mysql-cluster-storage-engine\/","url_meta":{"origin":3315,"position":2},"title":"The MySQL Cluster storage engine","author":"Stewart Smith","date":"2013-05-13","format":false,"excerpt":"This is one close to my heart. I've recently written on other storage engines:\u00c2\u00a0Where are they now: MySQL Storage Engines,\u00c2\u00a0The MERGE storage engine: not dead, just resting\u00e2\u20ac\u00a6. or forgotten\u00c2\u00a0and The MEMORY storage engine. Today, it's the turn of MySQL Cluster. Like InnoDB, MySQL Cluster started outside of MySQL. Those of\u2026","rel":"","context":"In &quot;code&quot;","block_context":{"text":"code","link":"https:\/\/www.flamingspork.com\/blog\/category\/code\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1642,"url":"https:\/\/www.flamingspork.com\/blog\/2009\/05\/15\/mysql-storage-engine-sloccount-over-releases\/","url_meta":{"origin":3315,"position":3},"title":"MySQL Storage Engine SLOCCount over releases","author":"Stewart Smith","date":"2009-05-15","format":false,"excerpt":"For a bit more info, what about various storage engines over MySQL releases. Have they changed much? Here we're looking at the storage\/X\/ directory for code, so for some engines this excludes the handler that interfaces with the MySQL Server. You can view the data on the spreadsheet.","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"http:\/\/spreadsheets.google.com\/pub?key=rD5FOoJk29j9RK7sm0abSsg&oid=1&output=image","width":350,"height":200,"srcset":"http:\/\/spreadsheets.google.com\/pub?key=rD5FOoJk29j9RK7sm0abSsg&oid=1&output=image 1x, http:\/\/spreadsheets.google.com\/pub?key=rD5FOoJk29j9RK7sm0abSsg&oid=1&output=image 1.5x"},"classes":[]},{"id":2145,"url":"https:\/\/www.flamingspork.com\/blog\/2010\/09\/29\/lca-miniconf-call-for-papers-data-storage-databases-filesystems-cloud-storage-sql-and-nosql\/","url_meta":{"origin":3315,"position":4},"title":"LCA Miniconf Call for Papers: Data Storage: Databases, Filesystems, Cloud Storage, SQL and NoSQL","author":"Stewart Smith","date":"2010-09-29","format":false,"excerpt":"This miniconf aims to cover many of the current methods of data storage and retrieval and attempt to bring order to the universe. We're aiming to cover what various systems do, what the latest developments are and what you should use for various applications. We aim for talks from developers\u2026","rel":"","context":"In &quot;drizzle&quot;","block_context":{"text":"drizzle","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/drizzle-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":800,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/03\/10\/code-size-of-an-engine-versus-test-suite\/","url_meta":{"origin":3315,"position":5},"title":"Code size of an engine versus test suite","author":"Stewart Smith","date":"2007-03-10","format":false,"excerpt":"If you count the lines of code in the MySQL Cluster (NDB) test suite (mysql-5.1\/storage\/ndb\/test - and exclude the old ODBC stuff) you come up with about 104000 lines of code. This is in contrast to the approximate other 350,000 lines of code for the NDB engine (excluding the handler,\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/3315","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=3315"}],"version-history":[{"count":1,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/3315\/revisions"}],"predecessor-version":[{"id":3316,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/3315\/revisions\/3316"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=3315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=3315"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=3315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}