MySQL Webinars and Videos from Percona
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 [...]
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) [...]
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 [...]
Today many organizations are moving their MySQL deployments from traditional spindle-based storage to flash-based solid-state storage for improved performance and scalability. The promise of database server consolidation, improved space/energy efficiency, and decreased system and operational costs is driving this migration. But IT professionals are cautious about this transition because the best way to configure and [...]
Learn how to use Percona Monitoring Plugins to increase MySQL uptime and availability. The Percona Monitoring Plugins are high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your existing in-house, on-premises monitoring solutions. The components are designed to integrate seamlessly with widely deployed solutions such as Nagios and Cacti, and are delivered in [...]
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 [...]
Percona Toolkit 2.0 has a newly upgraded tool for verifying replication integrity, pt-table-checksum. This unique tool verifies that your replicas have exactly the same logical dataset as their masters. No other tool offers this capability, yet it’s vitally important to check that replication isn’t causing data drift, and correct any problems that might be uncovered. [...]
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 [...]
