2008: Technical Presentations

Sphinx full-text search engine

Piotr Biel, Percona Inc
Andrew Aksyonoff, Sphinx Technologies
Peter Zaitsev, Percona Inc
OpenSQL 2008, November 2008

Sphinx full-text search engine presentation describes the usage of Sphinx and comparison with MySQL full-text search. You also can find information of new features in Sphinx 0.9.9

MySQL patches

Vadim Tkachenko, Percona Inc
OpenSQL 2008, November 2008

Overview of current patches for MySQL

Scaling MySQL-powered Web Sites by Sharding and Replication

Peter Zaitsev, Percona Inc
San Francisco MySQL Meetup, San Francisco, CA, November 2008

This presentation discusses how to choose the proper scaling strategy for your application; the limitations of replication and sharding, implementation complexities, and other aspects of the operation. It supplements a similar presentation prepared for the June 2008 Velocity Conference, in Burlingame CA. Additional topics include optimizing MySQL replication, moving data between shards, data archiving, and capacity planning.

InnoDB Scalability and New Features (Russian)

Peter Zaitsev, Percona Inc
HighLoad++ 2008, Moscow, Russia, October 2008

Presented for the HighLoad++ 2008 conference in Moscow, Russia. Essentially, a Russian version of the "InnoDB Scalability Limits" presentation prepared for the MySQL Users Conference 2008.

Scaling MySQL-powered Web Sites by Sharding and Replication (Russian)

Peter Zaitsev, Percona Inc
HighLoad++ 2008, Moscow, Russia, October 2008

Russian version of a presentation prepared for the HighLoad++ 2008 conference in Moscow, Russia.

Wonderful World of MySQL Storage Engine (Russian)

Peter Zaitsev, Percona Inc
HighLoad++ 2008, Moscow, Russia, October 2008

Russian version of a presentation prepared for the HighLoad++ 2008 conference in Moscow, Russia.

Outrun the Lions

Baron Schwartz
Las Vegas, NV, July 2008

Wonderful World of MySQL Storage Engine

Peter Zaitsev, Percona Inc
OSCON 2008, Portland, OR, July 2008

Ever wondered what are all those MySQL Storage engine and what they are good for ? This storage engine looks at most popular current and future MySQL storage engine compares their functionality and gives advice when one or another should be used. We also do benchmarks for those which are stable enough.

Scaling MySQL - powered Web Sites by Sharding and Replication

Peter Zaitsev, Percona Inc
Velocity Conference Burlingame, CA, June 2008

MySQL Performance Basics for beCamp 2008

Baron Schwartz
beCamp 2008, May 2008

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.

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.

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.