{"id":914,"date":"2007-11-09T13:29:02","date_gmt":"2007-11-09T03:29:02","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/2007\/11\/09\/mysql-5122-stew2\/"},"modified":"2007-11-09T17:49:42","modified_gmt":"2007-11-09T07:49:42","slug":"mysql-5122-stew2","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2007\/11\/09\/mysql-5122-stew2\/","title":{"rendered":"mysql-5.1.22-stew2"},"content":{"rendered":"<p>New:<\/p>\n<ul>\n<li>Updated NDB Compressed LCP and BACKUP patches (now with O_DIRECT support)<\/li>\n<li>InnoDB patch for Windows that should give ~5x improvement on commits\/sec (Bug31876)<\/li>\n<li>Everything in current telco-6.3 tree (ndb ~6.3.5)\n<ul>\n<li>Lots of NDB improvements and new features over regular 5.1.\n<ul>\n<li>\n<ul>\n<li>WL3686 Remove read before update<\/li>\n<li>WL2680 NDB Batched Update<\/li>\n<li>WL2679 NDB Batched Delete<\/li>\n<li>WL4108 NDB Handler statistics<\/li>\n<li>WL4096 NDB Realtime performance and settings<\/li>\n<li>WL3126 and WL3127 Client and Replication bind address<\/li>\n<li>NDB Online ALTER TABLE ADD COLUMN<\/li>\n<li>NDB Multi-Master replication conflict resolution (limitations apply :)<\/li>\n<li>NDB prepare for endian independence<\/li>\n<li>NDB micro-gcp (reduces replication lag)<\/li>\n<li>NDB SendBuffer throttling<\/li>\n<li>NDB MySQL Server TC selection (improve performance)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul><\/ul>\n<\/li>\n<\/ul>\n<p>Old (In previous patchset too):<\/p>\n<ul>\n<li>Remove ndb_use_exact_count giving up to 300% performance improvements on Joins in NDB<\/li>\n<li>INFORMATION_SCHEMA table for NDB node status<\/li>\n<li>NDB Cluster Log as CSV file (suitable for ENGINE=CSV)<\/li>\n<li>Skeleton Engine (build from storage\/skeleton)<\/li>\n<li>MyHTTP Engine (build from storage\/myhttp)<\/li>\n<li>PBXT Engine (build from storage\/pbxt)<\/li>\n<li>Make ARCHIVE faster at compressing (at slight expense of space usage)<\/li>\n<\/ul>\n<p>Availability:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.flamingspork.com\/mysql\/patch-5.1.22-stew2\/patch-5.1.22-stew2.gz\">Patch<\/a> (apply with -p1 to mysql 5.1.22) 4.0 MB\n<ul>\n<li>Applies cleanly on a BK source tree&#8230; a few files don&#8217;t exist in the tarball on dev.mysql.com (due to the way it&#8217;s built)&#8230; so when asked for &#8220;file to patch&#8221; just hit enter and then choose y to skip that patch.<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"http:\/\/www.flamingspork.com\/mysql\/patch-5.1.22-stew2\/README\">README<\/a> (list of patches, descriptions) 13kb<\/li>\n<li><a href=\"http:\/\/www.flamingspork.com\/mysql\/patch-5.1.22-stew2\/patches.tar.gz\">quilt patch series tarball<\/a> (individual patches) 4.1MB<\/li>\n<li><a href=\"http:\/\/www.flamingspork.com\/mysql\/patch-5.1.22-stew2\/diffstat\">diffstat<\/a> 228k<\/li>\n<\/ul>\n<p>Feedback much appreciated.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2007\/11\/09\/mysql-5122-stew2\/\">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":[14],"tags":[],"class_list":["post-914","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-eK","jetpack-related-posts":[{"id":3304,"url":"https:\/\/www.flamingspork.com\/blog\/2013\/05\/13\/the-mysql-cluster-storage-engine\/","url_meta":{"origin":914,"position":0},"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":1229,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/10\/14\/mysql-cluster-ndb-on-win32-progress\/","url_meta":{"origin":914,"position":1},"title":"MySQL Cluster (NDB) on Win32 progress","author":"Stewart Smith","date":"2008-10-14","format":false,"excerpt":"Many things have been happenning in the land of NDB on Win32 as of late. I've fixed about 700 compiler warnings (some of which were real bugs) leaving about 161 to go on Win32 (VS2003). We're getting a few more warnings on Win64 (some of which look merely semantic, while\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":762,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/11\/22\/pluggable-ndb\/","url_meta":{"origin":914,"position":2},"title":"pluggable NDB","author":"Stewart Smith","date":"2006-11-22","format":false,"excerpt":"Spoke with Brian the other day on what was required to get NDB to be a pluggable engine - and started hacking. The tricky bits invole dependencies of things like mysqldump and ndb_restore on some headers to determine what tables shouldn't be dumped (hint: the cluster database used for replication).\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":754,"url":"https:\/\/www.flamingspork.com\/blog\/2006\/10\/26\/mysql-ndb-team-trees-up-on-bkbitsnet\/","url_meta":{"origin":914,"position":3},"title":"mysql NDB team trees up on bkbits.net","author":"Stewart Smith","date":"2006-10-26","format":false,"excerpt":"If you head over here: mysql on bkbits.net you can get a copy of the NDB team trees. This is where we push stuff before it hits the main MySQL trees so that we can get some extra testing in (also for when pulling from the main tree). So you\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":3697,"url":"https:\/\/www.flamingspork.com\/blog\/2014\/03\/11\/ghosts-of-mysql-past-part-8-the-first-fork\/","url_meta":{"origin":914,"position":4},"title":"Ghosts of MySQL Past, Part 8: The First Fork.","author":"Stewart Smith","date":"2014-03-11","format":false,"excerpt":"This is the 8th installment in the rather long series that started with Part 1 about a month ago. Back in 2006, we were in the situation where MySQL 5.0 had taken forever, and the first \"GA\" release was not suitable for production. Looking towards MySQL 5.1, it was also\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":904,"url":"https:\/\/www.flamingspork.com\/blog\/2007\/10\/16\/mysql-5122ish-stew1\/","url_meta":{"origin":914,"position":5},"title":"MySQL 5.1.22(ish)-stew1","author":"Stewart Smith","date":"2007-10-16","format":false,"excerpt":"I'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't think so). It's not designed for use in production.. I don't really\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\/914","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=914"}],"version-history":[{"count":0,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/914\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=914"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=914"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=914"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}