UPDATE: This page is no more updated. For new Presentations which we gave please check Presentations area on Percona company site.
This page lists MySQL related Talks MySQL Performance Blog team members gave during the last years. Hope you find them helpful.
As usually only portion of information is on the slides themselves, many other things are just spoken, so if you want to have it all come to one of my talks live.
If you host conference which could benefit from my talk please feel free to invite me. I also can give internal presentation for your company.
Sphinx search engine for RDBMS
Egypt, December 2007
Presentation about Sphinx, the tasks it solves, internals and examples of usage
Hg – Mercurial
Egypt, December 2007
Talk about Mercurial version systems, comparison with similar tools and basic usage patterns
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.
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.
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.
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.
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.
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.
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.
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.
MySQL Performance Optimization
Russian Internet Technologies Conference 2007, Moscow, Russia, April 2007
Short presentation about MySQL Performance Optimization. Slides are in Russian.
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.
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
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.
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.
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.
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
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.
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.
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.
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.
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)
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.
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.
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)
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