MySQL Webinars and Videos from Percona
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 [...]
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 [...]
What if you had all the data you needed to measure system performance and scalability at any tier, discover performance and stability problems before they happen, and plan for capacity and performance by modeling the system’s behavior at greater load than you currently have? Now it is as easy as running tcpdump and processing the [...]
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 [...]
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 [...]
What if you had all the data you needed to measure system performance and scalability at any tier, discover performance and stability problems before they happen, and plan for capacity and performance by modeling the system’s behavior at greater load than you currently have? Now it is as easy as running tcpdump and processing the [...]
TCP network traffic is great for analyzing and modeling system performance, scalability, and capacity. This talk introduces tools for detecting performance problems and applying formal mathematical models easily, to forecast performance and scalability. This isn’t your typical queueing theory talk — it’s actually practical and usable for ordinary mortals in the real world. Baron Schwartz [...]
What if you had all the data you needed to measure system performance and scalability at any tier, discover performance and stability problems before they happen, and plan for capacity by modeling the system’s behavior at greater load than you currently have? Now it is as easy as running tcpdump and processing the result with [...]
Ronald Bradford’s talk at the 2009 Percona Performance Conference. Slides. Direct Download: http://blip.tv/file/get/Percona-TheIdealPerformanceArchitecture846.m4v
Learn how to emulate a more granular slow query log using mk-query-digest
