Thank you to the Drupal User Group Toronto for hosting me last night. My slides are now available online:
In response to some discussions:
- There is a new 'tree-like' EXPLAIN format in MySQL 5.6 called
FORMAT=JSON. You can see an example in this post.
innodb_buffer_pool_sizeis the in memory setting for how much of your data+indexes can be in RAM, and defaults to 128MB (far too small for most production environments).
innodb_flush_method=O_DIRECTis the option to disable filesystem caching. Both are mentioned in my what to tune after installation guide.