]]>
]]>

2008: Technical Presentations

You are here

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

This is a talk I gave at a Facebook developer's conference sponsored by Offerpal Media. Since many of our customers are Facebook applications I just skipped a lot of the "you might consider this or that option" and just gave direct advice based on the patterns we see with these applications. The sponsor gave all attendees copies of our book High Performance MySQL 2nd Edition, so you will see some references to that.

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

The general presentation speaking about use of Sharding and Replication techniques to scale MySQL driven web application.
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.

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.

Contact Us 24 Hours A Day
Support Contact us 24×7
Emergency? Contact us for help now!
Sales North America (888) 316-9775 or
(208) 473-2904
Sales
Europe
+44-208-133-0309 (UK)
0-800-051-8984 (UK)
0-800-181-0665 (GER)
Training (855) 55TRAIN or
(925) 271-5054

 

Share This
]]>