{"id":6335,"date":"2013-05-07T07:47:22","date_gmt":"2013-05-07T05:47:22","guid":{"rendered":"http:\/\/code.openark.org\/blog\/?p=6335"},"modified":"2013-05-07T07:47:22","modified_gmt":"2013-05-07T05:47:22","slug":"opeark-kit-revision-196-released","status":"publish","type":"post","link":"https:\/\/code.openark.org\/blog\/mysql\/opeark-kit-revision-196-released","title":{"rendered":"opeark-kit revision 196 released"},"content":{"rendered":"<p>This is a long due maintenance release of <a href=\"http:\/\/code.google.com\/p\/openarkkit\/\"><strong>openark-kit<\/strong>.<\/a> This release includes bugfixes and some enhancements, mainly to <a href=\"http:\/\/openarkkit.googlecode.com\/svn\/trunk\/openarkkit\/doc\/html\/oak-online-alter-table.html\">oak-online-alter-table<\/a>.<\/p>\n<p><em>oak-online-alter-table<\/em> Changes \/ bug fixes include:<\/p>\n<ul>\n<li>Support for keyword-named columns<\/li>\n<li>Use of FORCE INDEX due to lack of MySQL&#8217;s ability for figure out the chunking key at all times<\/li>\n<li><strong>&#8211;sleep-ratio<\/strong> option added; allows for sleep time proportional to execution time (as opposed to constant sleep time with <strong>&#8211;sleep<\/strong>)<\/li>\n<li>Support for chunk-retry (in case of deadlock) via <strong>&#8211;max-lock-retries<\/strong>)<\/li>\n<li>Fixed order of cleanup<\/li>\n<li>Fixed bug with verbose messages with non-integer chunking key<\/li>\n<li>Fixed bug with single-row tables (people, no need for this tool for single row tables :))<\/li>\n<li>Friendly verbose messages to remind you what&#8217;s being executed<\/li>\n<\/ul>\n<p><em>oak-chunk-update<\/em> changes includes:<\/p>\n<ul>\n<li>Verbosing query comment if exists (friendly printing of what&#8217;s being executed)<\/li>\n<\/ul>\n<p><!--more-->(Do check out <a href=\"http:\/\/common-schema.googlecode.com\/svn\/trunk\/common_schema\/doc\/html\/query_script_split.html\">QueryScript&#8217;s split()<\/a>; it&#8217;s a simple, server side solution which works almost same way as <em>oak-chunk-update<\/em>)<\/p>\n<p>More issues and changes not listed here.<\/p>\n<h4>Download<\/h4>\n<p><em>openark-kit<\/em> is released under the new BSD license, and is freely available.<\/p>\n<ul>\n<li><a href=\"http:\/\/code.google.com\/p\/openarkkit\/\">Download latest openark-kit revision (#196)<\/a>.<\/li>\n<li>Browse <a href=\"http:\/\/openarkkit.googlecode.com\/svn\/trunk\/openarkkit\/doc\/html\/introduction.html\">openark-kit documentation<\/a>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This is a long due maintenance release of openark-kit. This release includes bugfixes and some enhancements, mainly to oak-online-alter-table. oak-online-alter-table Changes \/ bug fixes include: Support for keyword-named columns Use of FORCE INDEX due to lack of MySQL&#8217;s ability for figure out the chunking key at all times &#8211;sleep-ratio option added; allows for sleep time [&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":[120,57,34,76],"class_list":["post-6335","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-development","tag-open-source","tag-openark-kit","tag-queryscript"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2bZZp-1Eb","_links":{"self":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/6335","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=6335"}],"version-history":[{"count":15,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/6335\/revisions"}],"predecessor-version":[{"id":6350,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/6335\/revisions\/6350"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/media?parent=6335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/categories?post=6335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/tags?post=6335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}