Excellent talk. Very dense. I will have to revisit the talk one or two more times to understand it fully.
Excellent talk! Very detailed examples.
Very well done. My only criticism is that I wish you had spoken a little slower.
Really amazing details about how MySQL works to attempt to optimize queries and how they can be analyzed and tweaked. It was helpful to have a metric (cost units?) to measure what a specific query will "cost". That helped provide a nice way to determine by how much a query is improved, even though a time measurement is a little more intuitive. The example data sets were awesome to look at and see how he worked with them.
Excellent talk, great information on optimizing queries.
Very index-heavy talk without getting too technical into how indices work. Might have liked to see more background into what explain is telling us, with temp tables or file sorts.
I really enjoyed the talk, especially showing the graph examples and what they spikes might mean. Well presented, and useful.
I could see a companion talk about how to actually use the profiling information to track down and fix the performance problems uncovered by XHProf.
Good information for optimizing queries with MySQL. I felt the talk was too heavily focused on indexing, and I was hoping to hear more about temp table creation and file sort results from EXPLAIN. Overall a great overview on how to tackle query optimization.
Great talk!
I understand Morgan is from Oracle, but I would like to have some hints it this is MySQL only or MariaDB also...
Thank you!
Fantastic overview of Varnish!