cPanel® Blog

All posts by: cpanelryan

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 …

Dealing with InnoDB Corruption – Common Misconceptions

InnoDB, given its (relatively) recent change as the default engine of MySQL, can quickly take an unfamiliar administrator off-guard if they’re not aware of the way that InnoDB works behind the scenes. With that in mind, there’s a few key concepts you should probably be aware of if you’re working with any InnoDB tables – which, if you’re running MySQL 5.6+, you will at the very least have a few of MySQL’s system tables using …