Designing Effective Schema for Innodb


When someone decides to write a web application that will use MySQL, the data will very likely be stored inside InnoDB tables since InnoDB is by far, the most popular storage engine for MySQL. Like all storage engines, InnoDB has some characteristics that are inherited from its architecture and because of that, a perfectly sane schema may end up under performing. This talk will show you how to take advantage of InnoDB in order to build scalable web applications. An example fictive new file sharing application will be used to illustrate the purpose.