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. [...]
Percona Toolkit is a must-have set of tools that can help serious MySQL administrators perform tasks that are common but difficult to do manually. Years of deployments by tens of thousands of users including some of the best-known Internet sites, have proven the reliability of the Percona Toolkit tools for MySQL. In this presentation, you [...]
Imagine a query that barely fits your monitor screen such as a 7 table join. In this MySQL webinar, we will discuss filling the gap between reading explain output and optimizing really large queries. Practical techniques used to address real-world situations will be shared, while pointing out common mistakes organizations often make. The talk will [...]
Building a robust and high performance MySQL application requires a combination of using the right techniques and avoiding the wrong ones. In this MySQL webinar you will learn the most common traps that lead to bad performance, complicated architectures, and waste of money when you are designing or running a MySQL application. You will then [...]
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 [...]
In this webinar we will discuss Solid State Drives internals and how they affect database performance. IO level benchmarks for SATA (Intel 320 SSD) and PCI-e (FusionIO and Virident) cards will be presented to show absolute performance and give an indication of performance per dollar. We will also discuss how you can use MySQL and [...]
Do schema changes (“migrations”) require a lot of advance scheduling and impact your development and business progress? Is an ALTER TABLE on the critical path in your project planning chart? This common problem comes from the fact that most ALTER operations in MySQL cause the table to be locked and rebuilt, which can be a [...]
Industry leaders from HP, Amazon Web Services, McAfee, Clustrix, and Akiban discuss the future of MySQL. Topics includes insights on the latest technology trends, predictions for the future of MySQL, and thoughts on the how the ecosystem will evolve in response to these developments. Panelists: Paul Mikesell (CEO, Clustrix) Sundar Raghavan (Director Product Management, Amazon) [...]
Over the past decade MySQL has made huge improvements in performance and is starting to get a lot better in manageability. But there are some problems that have yet to be addressed. This talk describes features we hope to see in future releases of MySQL. Presented by Mark Callaghan (Software Engineer, Database Infrastructure, Facebook) at [...]
