Percona Presentations
|
Make Your Life Easier with Maatkit
Ryan Lowe
San Francisco MySQL Meetup, June 2009
This presentation show us how to use Maatkit.
Download »
|
|
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
Download »
|
|
MySQL patches
Vadim Tkachenko, Percona Inc
OpenSQL 2008, November 2008
Overview of current patches for MySQL
Download »
|
|
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.
Download »
|
|
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.
Download »
|
|
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.
Download »
|
|
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.
Download »
|
|
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.
Download »
|
|
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.
Download »
|
|
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.
Download »
|
|
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 »
|
|
Sphinx and search for DB
Vadim Tkachenko, Percona Inc
Egypt, December 2007
Presentation about Sphinx, the tasks it solves, internals and examples of usage.
Download »
|
|
Query Optimization
Peter Zaitsev, Percona Inc
Web Tuesday, Zurich, Switzerland, November 2007
Presentation covers some basic rules of queries optimization for MySQL including application based tuning such as avoiding queries if you do not need their results etc.
Download »
|
|
Landscape of OpenSource Transactional storage engines for MySQL (Russian)
Peter Zaitsev, Percona Inc
HighLoad 2007 , Moscow, Russia, September 2007
Same presentation as done on OSCON but translated to Russian. Data was not updated to the new versions.
Download »
|
|
Techniques for Scaling Web Applications (Russian)
Peter Zaitsev, Percona Inc
HighLoad 2007 , Moscow, Russia, September 2007
Presentations covers basic principle of building scalable LAMP Web applications and scaling existing ones focusing mostly on MySQL part of the stack but not only that.
Download »
|
|
Landscape of OpenSource Transactional storage engines for MySQL
Peter Zaitsev, Vadim Tkachenko, Percona Inc
OSCON 2007, Portland, OR, July 2007
Presentation looks into PBXT, Falcon and SolidDB Storage engines and compares them in terms of performance and behavior to Innodb. Pre-release versions are used for most of them so properties can change in the final release.
Download »
|
|
MySQL Performance CookBook
Peter Zaitsev, Percona Inc
MySQL Users Conference 2007, Santa Clara, CA, April 2007
Tips and Tricks on how you can speed up various things in MySQL as well as solve other performance related problems.
Download »
|
|
MySQL Server Settings Tuning
Peter Zaitsev, Percona Inc
MySQL Users Conference 2007, Santa Clara, CA, April 2007
Presentation covering most important MySQL Settings which should be tuned for optimal MySQL performance giving some advice of selecting prover values for them.
Download »
|
|
Innodb Performance Optimization
Heikki Tuuri, Innobase Oy/Oracle Corp and Peter Zaitsev, Percona Ltd
MySQL Users Conference 2007, Santa Clara,CA, April 2007
Presentation covering Innodb specific application design recommendations as well as Innodb MySQL Server Settings and Hardware selection aspects.
Download »
|
|
Distributed Architecture of LAMP Applications old
Peter Zaitsev, Percona Ltd
Russian Internet Technologies Conference 2007, Moscow, Russia, April 2007
Short presentation about designing distributed LAMP Applications. Slides are in Russian.
Download »
|
|
MySQL Performance Optimization
Peter Zaitsev, Percona Ltd
Russian Internet Technologies Conference 2007, Moscow, Russia, April 2007
Short presentation about MySQL Performance Optimization. Slides are in Russian.
Download »
|
|
Effective Full Text Search for Databases
Peter Zaitsev, Percona Ltd and Andrew Aksenoff
Russian Internet Technologies Conference 2007, Moscow, Russia, April 2007
Short presentation introducing Sphinx Full Text Search solution and comparing it to the alternatives.
Slides by Andrew Aksenoff, Russian Language. Download »
|
|
