{"id":34322,"date":"2015-10-29T13:00:00","date_gmt":"2015-10-29T18:00:00","guid":{"rendered":"http:\/\/blog.cpanel.com\/?p=34322"},"modified":"2015-10-29T13:00:00","modified_gmt":"2015-10-29T18:00:00","slug":"innodb-anatomyalchemy-companion-material","status":"publish","type":"post","link":"https:\/\/devel.www.cpanel.net\/blog\/cpeople\/innodb-anatomyalchemy-companion-material\/","title":{"rendered":"InnoDB Anatomy\/Alchemy Companion Material"},"content":{"rendered":"<p>Given the frustration that many of our customers (and ourselves) have had with InnoDB over the past couple of years, I&#8217;ve made it a point to try and learn everything I can about it. As a result, I presented a couple of InnoDB talks in the 2014 and 2015 cPanel conferences, focusing a lot on the back-end functionality of InnoDB and its basic structure.\u00a0Portions of both of these presentations involved playing with some really cool command-line ways to manipulate InnoDB, applying the structural InnoDB knowledge established in the presentation material.<\/p>\n<p>These exercises, however, are of course a lot more fun when you actually get to play around with them yourself. So this year I promised to make sure that all of the material would be made publicly available for access. With that in mind, I spent some time modifying the presentations to a &#8220;simplified&#8221; format (ie. animations removed, etc.), so that they could be uploaded and shared easily:<\/p>\n<p>InnoDB Anatomy (cPanelCon 2014):\u00a0<a href=_-1503.html target=\"_blank\" rel=\"noopener\">http:\/\/www.slideshare.net\/ringo380\/cpanelcon-2014-innodb-anatomy<\/a><br \/>\nInnoDB Alchemy (cPanelCon 2015):\u00a0<a href=_-1504.html target=\"_blank\" rel=\"noopener\">http:\/\/www.slideshare.net\/ringo380\/innodb-alchemy<\/a><\/p>\n<p>Along with these, I&#8217;ve collected some information from the MySQL source along the way, and kept much of it in a Google Docs spreadsheet. I&#8217;ve cleaned it up a bit and will make that available as well, as it contains quite a bit more data than what was mentioned in the slides themselves (be aware that there are a few other sheets\u00a0in the tabs at the top\u00a0as well\u00a0&#8211; it&#8217;s easy to miss):<\/p>\n<p><a href=pubhtml.html#\" target=\"_blank\" rel=\"noopener\">https:\/\/docs.google.com\/spreadsheets\/d\/1T-5TYPdZTgtswqQVvtZD57QVakZi4f4nebJVHB1VLCY\/pubhtml#<\/a><\/p>\n<p>These are a little rough around the edges still, and obviously it does not represent a full snapshot of all the &#8220;hard&#8221; values you can get out of the source, but it was essentially my scratchpad when digging around, and the information collected there may prove useful if you&#8217;re interested in this kind of thing.\u00a0\u00a0As usual, though, definitely let me\u00a0know if I&#8217;ve left out any information here, or even if you&#8217;ve just got questions about any of it. It&#8217;s a fascinating topic, so I&#8217;m always looking for more excuses to dive into it and dig up some new dirt.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Given the frustration that many of our customers (and ourselves) have had with InnoDB over the past couple of years, I&#8217;ve made it a point to try and learn everything I can about it. As a result, I presented a couple of InnoDB talks in the 2014 and 2015 cPanel conferences, focusing a lot on [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":35542,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[73],"tags":[1253,1257,705,993],"class_list":["post-34322","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cpeople","tag-alchemy","tag-anatomy","tag-conference","tag-innodb"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>InnoDB Anatomy\/Alchemy Companion Material | cPanel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=_-1505.html \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"InnoDB Anatomy\/Alchemy Companion Material | cPanel\" \/>\n<meta property=\"og:description\" content=\"Given the frustration that many of our customers (and ourselves) have had with InnoDB over the past couple of years, I&#8217;ve made it a point to try and learn everything I can about it. As a result, I presented a couple of InnoDB talks in the 2014 and 2015 cPanel conferences, focusing a lot on [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devel.www.cpanel.net\/blog\/cpeople\/innodb-anatomyalchemy-companion-material\/\" \/>\n<meta property=\"og:site_name\" content=\"cPanel\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/cpanel\/\" \/>\n<meta property=\"article:published_time\" content=\"2015-10-29T18:00:00+00:00\" \/>\n<meta name=\"author\" content=\"cPanel Community\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@cPanel\" \/>\n<meta name=\"twitter:site\" content=\"@cPanel\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"cPanel Community\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/cpeople\/innodb-anatomyalchemy-companion-material\/\",\"url\":\"https:\/\/devel.www.cpanel.net\/blog\/cpeople\/innodb-anatomyalchemy-companion-material\/\",\"name\":\"InnoDB Anatomy\/Alchemy Companion Material | cPanel\",\"isPartOf\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/#website\"},\"datePublished\":\"2015-10-29T18:00:00+00:00\",\"dateModified\":\"2015-10-29T18:00:00+00:00\",\"author\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8\"},\"breadcrumb\":{\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/cpeople\/innodb-anatomyalchemy-companion-material\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/devel.www.cpanel.net\/blog\/cpeople\/innodb-anatomyalchemy-companion-material\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/devel.www.cpanel.net\/blog\/cpeople\/innodb-anatomyalchemy-companion-material\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/devel.www.cpanel.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"InnoDB Anatomy\/Alchemy Companion Material\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#website\",\"url\":\"https:\/\/devel.www.cpanel.net\/\",\"name\":\"cPanel\",\"description\":\"Hosting Platform of Choices\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/devel.www.cpanel.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8\",\"name\":\"cPanel Community\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g\",\"caption\":\"cPanel Community\"},\"description\":\"The web hosting industry's most reliable management solution since 1997. With our first-class support and rich feature set, it's easy to see why our customers and partners make cPanel &amp; WHM their hosting platform of choice. For more information, visit cPanel.net.\",\"sameAs\":[\"https:\/\/cpanel.net\"],\"url\":\"https:\/\/devel.www.cpanel.net\/blog\/author\/cpadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"InnoDB Anatomy\/Alchemy Companion Material | cPanel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devel.www.cpanel.net\/blog\/cpeople\/innodb-anatomyalchemy-companion-material\/","og_locale":"en_US","og_type":"article","og_title":"InnoDB Anatomy\/Alchemy Companion Material | cPanel","og_description":"Given the frustration that many of our customers (and ourselves) have had with InnoDB over the past couple of years, I&#8217;ve made it a point to try and learn everything I can about it. As a result, I presented a couple of InnoDB talks in the 2014 and 2015 cPanel conferences, focusing a lot on [&hellip;]","og_url":"https:\/\/devel.www.cpanel.net\/blog\/cpeople\/innodb-anatomyalchemy-companion-material\/","og_site_name":"cPanel","article_publisher":"https:\/\/www.facebook.com\/cpanel\/","article_published_time":"2015-10-29T18:00:00+00:00","author":"cPanel Community","twitter_card":"summary_large_image","twitter_creator":"@cPanel","twitter_site":"@cPanel","twitter_misc":{"Written by":"cPanel Community","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/devel.www.cpanel.net\/blog\/cpeople\/innodb-anatomyalchemy-companion-material\/","url":"https:\/\/devel.www.cpanel.net\/blog\/cpeople\/innodb-anatomyalchemy-companion-material\/","name":"InnoDB Anatomy\/Alchemy Companion Material | cPanel","isPartOf":{"@id":"https:\/\/devel.www.cpanel.net\/#website"},"datePublished":"2015-10-29T18:00:00+00:00","dateModified":"2015-10-29T18:00:00+00:00","author":{"@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8"},"breadcrumb":{"@id":"https:\/\/devel.www.cpanel.net\/blog\/cpeople\/innodb-anatomyalchemy-companion-material\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devel.www.cpanel.net\/blog\/cpeople\/innodb-anatomyalchemy-companion-material\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/devel.www.cpanel.net\/blog\/cpeople\/innodb-anatomyalchemy-companion-material\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/devel.www.cpanel.net\/"},{"@type":"ListItem","position":2,"name":"InnoDB Anatomy\/Alchemy Companion Material"}]},{"@type":"WebSite","@id":"https:\/\/devel.www.cpanel.net\/#website","url":"https:\/\/devel.www.cpanel.net\/","name":"cPanel","description":"Hosting Platform of Choices","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devel.www.cpanel.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/8cf97408aad4fb70cf55d11a1d4f57f8","name":"cPanel Community","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/devel.www.cpanel.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e1949945083b5526bb95711bd3d616b3?s=96&d=mm&r=g","caption":"cPanel Community"},"description":"The web hosting industry's most reliable management solution since 1997. With our first-class support and rich feature set, it's easy to see why our customers and partners make cPanel &amp; WHM their hosting platform of choice. For more information, visit cPanel.net.","sameAs":["https:\/\/cpanel.net"],"url":"https:\/\/devel.www.cpanel.net\/blog\/author\/cpadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts\/34322"}],"collection":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/comments?post=34322"}],"version-history":[{"count":0,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/posts\/34322\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/media?parent=34322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/categories?post=34322"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devel.www.cpanel.net\/wp-json\/wp\/v2\/tags?post=34322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}