PRESENTATIONS

MySQL Emergency? Call right now and get help
MySQL Basics beCamp 2008

MySQL Performance Basics for beCamp 2008

Baron Schwartz
beCamp 2008, May 2008

This was a quick and loosely organized talk Baron created for an un-conference. The slides have only basic information; most of the information was in the spoken portion of the talk. Download »

EXPLAIN Demystified

Baron Schwartz, Percona Inc
MySQL Users Conference 2008, Santa Clara, CA, April 2008

This presentation shows you how the MySQL query optimizer creates an execution plan, how MySQL converts that to the EXPLAIN output, and how you can figure out the execution plan from the EXPLAIN output. Download »

The MySQL Query Cache

Baron Schwartz, Percona Inc
MySQL Users Conference 2008, Santa Clara, CA, April 2008

This presentation shows you how the MySQL query cache works, how it uses memory, and how to monitor and tune it. Download »

InnoDB Scalability Limits

Peter Zaitsev, Vadim Tkachenko, Percona Inc
MySQL Users Conference 2008, Santa Clara, CA, April 2008

This presentation talks about Innodb scalability aspects for various workloads. It focuses mostly on CPU bound workload but compares filesystems IO scheduler for Linux kernel as well. You may find some benchmarks results pretty surprising same as it was for us. Download »

Hg - Mercurial

Vadim Tkachenko, Percona Inc
Egypt, December 2007

Talk about Mercurial version systems, comparison with similar tools and basic usage patterns. Download »