MySQL Webinars and Videos from Percona
If you don’t understand MySQL’s EXPLAIN output, this webinar is for you. EXPLAIN output is confusing, but if you understand how it’s created, it’ll make sense to you. You’ll leave this webinar with the knowledge necessary to understand the most complex query plans, including those with filesorts, subqueries, and UNIONs. You’ll see the internals of [...]
Many systems that speak over TCP have simple call-and-response protocols. These lend themselves well to extracting reasonably accurate request and response start and end times. This is a fabulously rich source of data that can be mined for many types of purposes. All that is needed is the first 384 bytes of each packet, containing [...]
Successfully scaling an application requires that you understand the businesses tolerances for data availability, performance, and cost before trying to tackle the challenges of backup, load balancing, and high availability. All too often, development teams are asked to build highly available systems, without justification or an understanding of the business needs for the data. These [...]
Everyone wants to prevent database downtime by being proactive. But how effective are the common measures such as inspecting logs and analyzing SQL? To be truly proactive, one must prevent problems, which requires studying and understanding the reasons for downtime. We have analyzed a selection of emergency issues that we have resolved to better understand [...]
