2007: Technical Presentations
Hg - MercurialVadim Tkachenko, Percona Inc Talk about Mercurial version systems, comparison with similar tools and basic usage patterns. |
Sphinx and search for DBVadim Tkachenko, Percona Inc Presentation about Sphinx, the tasks it solves, internals and examples of usage. |
Query OptimizationPeter Zaitsev, Percona Inc 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. |
Landscape of OpenSource Transactional storage engines for MySQL (Russian)Peter Zaitsev, Percona Inc Same presentation as done on OSCON but translated to Russian. Data was not updated to the new versions. |
Techniques for Scaling Web Applications (Russian)Peter Zaitsev, Percona Inc 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 MySQLPeter Zaitsev, Vadim Tkachenko, Percona Inc 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 Performance CookBookPeter Zaitsev, Percona Inc Tips and Tricks on how you can speed up various things in MySQL as well as solve other performance related problems. |
MySQL Server Settings TuningPeter Zaitsev, Percona Inc Presentation covering most important MySQL Settings which should be tuned for optimal MySQL performance giving some advice of selecting prover values for them. |
Innodb Performance OptimizationHeikki Tuuri, Innobase Oy/Oracle Corp and Peter Zaitsev, Percona Ltd Presentation covering InnoDB specific application design recommendations as well as InnoDB MySQL Server Settings and Hardware selection aspects. |
Distributed Architecture of LAMP Applications oldPeter Zaitsev, Percona Ltd Short presentation about designing distributed LAMP Applications. Slides are in Russian. |
MySQL Performance OptimizationPeter Zaitsev, Percona Ltd Short presentation about MySQL Performance Optimization. Slides are in Russian. |
Effective Full Text Search for DatabasesPeter Zaitsev, Percona Ltd and Andrew Aksenoff Short presentation introducing Sphinx Full Text Search solution and comparing it to the alternatives. Slides by Andrew Aksenoff, Russian Language. |













