cPanel® Blog

InnoDB Anatomy/Alchemy Companion Material

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. Portions 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.

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:

InnoDB Anatomy (cPanelCon 2014):
InnoDB Alchemy (cPanelCon 2015):

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 in the tabs at the top as well – it’s easy to miss):

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.  As usual, though, definitely let me know 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.