{"id":6512,"date":"2013-09-04T07:04:38","date_gmt":"2013-09-04T05:04:38","guid":{"rendered":"http:\/\/code.openark.org\/blog\/?p=6512"},"modified":"2013-09-04T10:43:31","modified_gmt":"2013-09-04T08:43:31","slug":"three-wished-for-a-new-year-2013","status":"publish","type":"post","link":"https:\/\/code.openark.org\/blog\/mysql\/three-wished-for-a-new-year-2013","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>Get auto-vacuuming, disk space reclaiming InnoDB tablespaces<\/li>\n<\/ol>\n<p>No one likes rebuilding huge InnoDB tables. Rebuilds take time, effort, system resources and loss of sleep. I recently rebuilt a <strong>300GB<\/strong> table to realize it reduced to a mere <strong>45GB<\/strong>. How about some background automation?<\/p>\n<p>My wishes in previous two 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>] have not come true. 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 Get auto-vacuuming, disk space reclaiming InnoDB tablespaces No one likes rebuilding huge InnoDB tables. Rebuilds take time, effort, system resources and loss of sleep. I recently rebuilt a 300GB table to realize it reduced to [&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":[],"class_list":["post-6512","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\/p2bZZp-1H2","_links":{"self":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/6512","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=6512"}],"version-history":[{"count":3,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/6512\/revisions"}],"predecessor-version":[{"id":6521,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/6512\/revisions\/6521"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/media?parent=6512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/categories?post=6512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/tags?post=6512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}