{"id":904,"date":"2007-10-16T17:34:04","date_gmt":"2007-10-16T07:34:04","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/2007\/10\/16\/mysql-5122ish-stew1\/"},"modified":"2007-10-16T17:34:04","modified_gmt":"2007-10-16T07:34:04","slug":"mysql-5122ish-stew1","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2007\/10\/16\/mysql-5122ish-stew1\/","title":{"rendered":"MySQL 5.1.22(ish)-stew1"},"content":{"rendered":"<p>I&#8217;ve decided to publish my patch series. The goal of the -stew patches is to collect things I find interesting and that at some point could (should) make it into the main MySQL tree (even if others don&#8217;t think so).<\/p>\n<p>It&#8217;s not designed for use in production.. I don&#8217;t really care if there&#8217;s failing test cases&#8230;. if it builds it&#8217;s perfect.<\/p>\n<p>It includes the following which could be interesting:<\/p>\n<ul>\n<li>Removal of ndb_use_exact_count (performance for NDB)<\/li>\n<li>NDB node status in an INFORMATION_SCHEMA table<\/li>\n<li>Compressed Backup and LCP for NDB<\/li>\n<li>Cluster log as CSV<\/li>\n<li>Skeleton Engine<\/li>\n<li>MyHTTP Engine<\/li>\n<li>PBXT Engine<\/li>\n<li>Skeleton of MyBS support for NDB\n<ul>\n<li>(in the hope that somebody finishes it)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Currently the additional engines have to be built separately in their storage\/ENGINE directories. I have some preliminary patches to get them to build in-tree via the plug.in file, but it&#8217;s not finished (patches welcome).<\/p>\n<p>This is all currently based off the 5.1-ndb tree. In future, it will likely be based off 5.1-telco.<\/p>\n<p><a href=\" http:\/\/www.flamingspork.com\/mysql\/patch-5.1-ndb-stew1-20071016.patch.gz\">\u00c2\u00a0http:\/\/www.flamingspork.com\/mysql\/patch-5.1-ndb-stew1-20071016.patch.gz<\/a><\/p>\n<p>and broken out in:<br \/>\n<a href=\"http:\/\/www.flamingspork.com\/mysql\/patch-5.1-ndb-stew1-20071016\/\">http:\/\/www.flamingspork.com\/mysql\/patch-5.1-ndb-stew1-20071016\/<\/a><br \/>\n(including the not-quite-working ENGINE_in_tree_build patches)<\/p>\n<p>Known to apply against this tree:<\/p>\n<p><a href=\"http:\/\/www.flamingspork.com\/mysql\/mysql-5.1-ndb-20071016.tar.bz2\">http:\/\/www.flamingspork.com\/mysql\/mysql-5.1-ndb-20071016.tar.bz2<\/a><\/p>\n<p>Comments, thoughts, patches to include, all welcome!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve decided to publish my patch series. The goal of the -stew patches is to collect things I find interesting and that at some point could (should) make it into the main MySQL tree (even if others don&#8217;t think so). &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2007\/10\/16\/mysql-5122ish-stew1\/\">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_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":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[14],"tags":[],"class_list":["post-904","post","type-post","status-publish","format-standard","hentry","category-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-eA","jetpack-related-posts":[{"id":914,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/11\/09\/mysql-5122-stew2\/","url_meta":{"origin":904,"position":0},"title":"mysql-5.1.22-stew2","author":"Stewart Smith","date":"2007-11-09","format":false,"excerpt":"New: Updated NDB Compressed LCP and BACKUP patches (now with O_DIRECT support) InnoDB patch for Windows that should give ~5x improvement on commits\/sec (Bug31876) Everything in current telco-6.3 tree (ndb ~6.3.5) Lots of NDB improvements and new features over regular 5.1. WL3686 Remove read before update WL2680 NDB Batched Update\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":[]},{"id":478,"url":"https:\/\/www.flamingspork.com\/blog\/2005\/10\/03\/a-funky-thing-done-last-week\/","url_meta":{"origin":904,"position":1},"title":"a funky thing done last week&#8230;","author":"Stewart Smith","date":"2005-10-03","format":false,"excerpt":"still have to talk to people about standards for this sort of thing and all that. But as a first checkin - funkyness++! mysql> select * from INFORMATION_SCHEMA.DATAFILES; select * from INFORMATION_SCHEMA.TABLESPACES; Empty set (0.03 sec) Empty set (0.00 sec) mysql> CREATE TABLESPACE ts1 ADD DATAFILE 'datafile.dat' USE LOGFILE GROUP\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":[]},{"id":828,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/04\/27\/experimental-ndb-patches\/","url_meta":{"origin":904,"position":2},"title":"Experimental NDB Patches","author":"Stewart Smith","date":"2007-04-27","format":false,"excerpt":"I've just put up the current \"add node\" patch... which is like, totally experimental and kills kittens... but could be interesting for people to have a look at as it progresses. Still lots of work before production ready - but people here at the MySQL Conf have said they're interested\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":[]},{"id":776,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/01\/08\/ndb-ndb-the-storage-engine-for-me\/","url_meta":{"origin":904,"position":3},"title":"NDB! NDB! The storage engine for me!","author":"Stewart Smith","date":"2007-01-08","format":false,"excerpt":"Today I set up a mysqld connected to my not-quite-HA cluster at home here to replicate from my MythTV database into cluster. The idea behind this is to eat an increasing amount of my own dogfood around the house. To do this, I also set up the MySQL Instance Manager\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":[]},{"id":800,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/03\/10\/code-size-of-an-engine-versus-test-suite\/","url_meta":{"origin":904,"position":4},"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":[]},{"id":578,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/02\/15\/information_schemafiles-querying-disk-usage-from-sql\/","url_meta":{"origin":904,"position":5},"title":"INFORMATION_SCHEMA.FILES (querying disk usage from SQL)","author":"Stewart Smith","date":"2006-02-15","format":false,"excerpt":"In MySQL 5.1.6 there's a new INFORMATION_SCHEMA table. Currently, it only has information on files for NDB but we're hoping to change that in a future release (read: I think it would be neat). This table is a table generated by the MySQL server listing all the different files that\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\/904","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=904"}],"version-history":[{"count":0,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/904\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=904"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=904"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}