My slides can be found here.
Simply some take aways are
- Use Innodb for everything (unless another engine is appropriate)
- Having the working set in bufferpool makes MySQL Innodb fast by eliminating those foreground randrom reads of tablespace
- Use a RAID controller with BBU and write back cache for transactional log performance
Thanks To Evan Bottcher for owning and organising the meetup!