September 30, 2014

Presentations

This page is not updated anymore. For new presentations, please check the presentations page on our company website.

We love speaking at conferences and other events. Please contact us if you’d like us to present at yours! We can also give internal presentations for your company or group.

Sphinx search engine for RDBMS
Egypt, December 2007

Presentation about Sphinx, the tasks it solves, internals and examples of usage

Download

Hg – Mercurial
Egypt, December 2007

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

Download

Query Optimization
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

Techniques for Scaling Web Applications (Russian)
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 (Russian)
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

Landscape of OpenSource Transactional storage engines for MySQL
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 Server Settings Tuning
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

MySQL Performance CookBook
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

Innodb Performance Optimization
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

Effective Full Text Search for Databases
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

MySQL Performance Optimization
Russian Internet Technologies Conference 2007, Moscow, Russia, April 2007

Short presentation about MySQL Performance Optimization. Slides are in Russian.

Download

Distributed Architecture of LAMP Applications
Russian Internet Technologies Conference 2007, Moscow, Russia, April 2007

Short presentation about designing distributed LAMP Applications. Slides are in Russian.

Download

MySQL/Innodb Architecture and Performance Optimization
OpenSource Database Conference 2006, Frankfurt, Germany, November 2006

Very condenced 1h 15min presentation about Innodb Architecture and Performance Optimization. Good reading for beginners,
while even advanced users may find one or two things about Innodb they did not know before

Download

MySQL Performance Optimization
OpenSource Database Conference 2006, Frankfurt, Germany, November 2006

This is 3 hour workshop presentation which covers wide range of MySQL Performance Optimization topics. It was written from scratch as material I had on this topic was written for MySQL AB so I could not reuse it. Good reading but it a bit so shallow in places – it is very hard to cover such wide topic as performance optimization in such short timeframe.

Download

High Performance FullText Search
EuroOSCON 2006, Brussels, Belgium, September 2006

This presentation speaks about FullText search techniques for content stored in database focusing on delivering high performance for large databases. We look at performance properties of MySQL build in full text search functionality using real medium size text collection – Wikipedia Articles dump, when we compare it to other opensource full text search search engines such as lucene,sphinx,tbgsearch,sienna, mnogosearch and perform benchmarks.

Download

Note: Following presentations were done while I was MySQL employee and so copyrighted by MySQL and published here with MySQL Permission. I have them published here as copy of materials published on conference sites and in other places.

MySQL Performance Landscape
MySQL Users Conference 2006, Santa Clara, CA

MySQL was benchmarked on different platforms – hardware operation systems, file systems etc. Large number of benchmarks with little explanations on the slides. Explanations were just spoken. In many cases results are self explanatory. Very good reading if you’re planing hardware purchase or OS upgrade. Too bad such results outdate pretty quickly.

Download

MySQL Performance 5.0 vs 4.1
MySQL Users Conference 2006, Santa Clara, CA

This presentation shows in numbers performance differences in MySQL 4.1 and 5.0, showing most important performance improvements and regressions known to our team. Good reading if you’re planing on upgrading to MySQL 5.0

Download

Optimizing MySQL on Source Code Level
MySQL Users Conference 2006, Santa Clara, CA
This presentation was co-authered by Vadim Tkachanko and myself and presented on Vadim, so I’m also adding it with his kind permission. This presentation covers some real world scalability performance problems we’ve discovered in MySQL Server, how did we found what exacty the problems were and how did we fix some of them. It also contains some multithreaded high performance programming tips which should be of general interest.

Download

Advanced Innodb Optimization
MySQL Users Conference 2005, Santa Clara, CA

This presentation has a lot of details about optimizing applications for Innodb Storage Engine. Especially if you’re migrating data from other databases or other Storage Engines to Innodb this one is must read.

Download

Advanced MySQL Performance Optimization Tutorial
MySQL Users Conference 2005, Santa Clara, CA
Co-Presented with Tobias Asplund.

Presentation from 3 hour Tutorial, so it has a lot of information not only about MySQL but about optimization of Web applications in general. Some people say there were too much of this general things. So good reading both for MySQL Performance Optimization data as well as for general MySQL application design practices.

Download

MySQL: New Features in versions 4.1, 5.0, 5.1
Open Source Forum 2005, Moscow, Russia

Presentation speaks about new features in new MySQL Versions.

Download

Improving MySQL Performance with Intel C++ Compiler
LinuxWorld 2005, Boston

Updated version now covering new platforms and ICC version.
Has numbers for Improvements one can get by using ICC complier (still outdated)

Download

MySQL/Innodb Performance Optimization
OSCON 2004, Portland, OR

Performance optimization in numbers. Presentation shows how changing various MySQL Server OS and Hardware parameters affect MySQL Performance in DBT2 benchmark. Focuses mostly on Innodb but many findings are generally valid.

Download

MySQL/Innodb Performance: Server and Schema
MySQL Users Conference 2004, Orlando, FL

Presentation shows how much you can improve performance by adjusting schema and MySQL Server options, using DBT2 Benchmark as example. Focuses on Innodb but most things are relevant for any storage engine.
Download

MySQL/Innodb Performance: OS and Hardware
MySQL Users Conference 2004, Orlando, FL

Presentation shows how much you can improve performance by OS setting and Hardware configuration, using DBT2 Benchmark as example. Focuses on Innodb but most things are relevant for any storage engine.

Download

Improving MySQL Performance with Intel C++ Compiler
LinuxWorld 2004, San Francisco

Very short presentation I gave on Intel both.
Has numbers for Improvements one can get by using ICC complier (Outdated)

Download

Scaling and Performance Issues in MySQL
MiracleAS Database Forum 2003, Denmark

Presentation speaks about benchmarking issues and MySQL performance issues and settings.
This presentation was written for Oracle audience so it is kind of special.
Download

MySQL Benchmark and Testing Project
MySQL Users Conference 2003, San Jose, CA

Presentation about projects MySQL Benchmark Group was working at the time. Does not have too much meat about MySQL Performance.
Download

MySQL and PHP for Web Applications
Open Source Revolution 2002, Stockholm, Sweden

Presentation about MySQL Server features and ways
Focuses on MySQL 4.0 but covers some tricks which are still helpful.
Download