MySQL Webinars and Videos from Percona
MySQL scalability depends on getting many things right including the architecture, hardware, operating system, MySQL version, MySQL configuration, schema design and indexing, and query design. To avoid having any one of them become the bottleneck that limits the scalability of the entire system, you need to follow best practices in all of these technology areas. [...]
MySQL is the first choice for a large majority of web applications thanks to its ease of use and low cost of operation. However, running big apps on MySQL is still a challenge even for experts. In this webinar we will show you how to combine Percona Server and Percona XtraBackup with Continuent Tungsten to [...]
Proper indexing is a key ingredient of database performance and MySQL is no exception. In this session we will talk about how MySQL uses indexes for query execution, how to come up with an optimal index strategy, how to decide when you need to add an index, and how to discover indexes which are not [...]
As MySQL powers more and more business critical applications it is very important to be able to upgrade MySQL server with as low risk as possible. In this presentation we will go into details of best practices used by Percona to perform hundreds of MySQL upgrade projects as well as learn how to use Percona [...]
MySQL continues to grow and evolve in new and valuable ways. New services and initiatives to move MySQL to the cloud are launching constantly while the largest MySQL users continue to scale rapidly in size and value. This session will provide an overview of the MySQL landscape and the rapid changes that are driving its [...]
MySQL’s configuration file is often the focus of too much attention and too much tweaking of variables that make no difference — or worse, have the potential to negatively impact performance. The sample default configuration files that come with MySQL are unfortunately not very helpful or good, either. You’ll learn a practical approach to generate [...]
Peter Zaitsev, founder and CEO of Percona, speaks about the state of the MySQL ecosystem. ;Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master’s Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling. Presented by Peter Zaitsev at Percona [...]
MySQL 5.5 and 5.6 include many great improvements to the database server, from the Performance Schema to multi-threaded replication. Peter goes beyond merely explaining what they are and what they do. He tells you what the new features are actually going to help you with, and help you understand when to use them and when [...]
MySQL Performance Schema, available in MySQL 5.5 provides tremendous wealth of information. In this presentation we’ll look into using Performance Schema for Performance Optimization and Troubleshooting. Slides are here. More MySQL Presentations.
An interview with Peter Zaitsev, author of High Performance MySQL and CEO of Percona, in 2008.
