{"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":"

Given the frustration that many of our customers (and ourselves) have had with InnoDB over the past couple of years, I’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

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 “simplified” format (ie. animations removed, etc.), so that they could be uploaded and shared easily:<\/p>\n

InnoDB Anatomy (cPanelCon 2014):\u00a0http:\/\/www.slideshare.net\/ringo380\/cpanelcon-2014-innodb-anatomy<\/a>
\nInnoDB Alchemy (cPanelCon 2015):\u00a0
http:\/\/www.slideshare.net\/ringo380\/innodb-alchemy<\/a><\/p>\n

Along with these, I’ve collected some information from the MySQL source along the way, and kept much of it in a Google Docs spreadsheet. I’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– it’s easy to miss):<\/p>\n

https:\/\/docs.google.com\/spreadsheets\/d\/1T-5TYPdZTgtswqQVvtZD57QVakZi4f4nebJVHB1VLCY\/pubhtml#<\/a><\/p>\n

These are a little rough around the edges still, and obviously it does not represent a full snapshot of all the “hard” 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’re interested in this kind of thing.\u00a0\u00a0As usual, though, definitely let me\u00a0know if I’ve left out any information here, or even if you’ve just got questions about any of it. It’s a fascinating topic, so I’m always looking for more excuses to dive into it and dig up some new dirt.<\/p>\n","protected":false},"excerpt":{"rendered":"

Given the frustration that many of our customers (and ourselves) have had with InnoDB over the past couple of years, I’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 […]<\/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":"\nInnoDB 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’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 […]\" \/>\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 & 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’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 […]","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 & 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}]}}