Thank you to DUG-TO!

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_size is 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_DIRECT is the option to disable filesystem caching. Both are mentioned in my what to tune after installation guide.

Thanks again!