Apr 29, 2016

Troubleshooting Slow Queries

Effective queries are a core requirement of MySQL performance. Even a perfectly optimized MySQL server running on the most powerful hardware can lag due to badly optimized queries. EXPLAIN is one of the most powerful and always-available query tuning instruments built-in to MySQL.

In this...

Percona MySQL Webinars


Apr 7, 2016

Introduction to Troubleshooting Performance: What Affects Query Execution?

Slow running queries, threads stacking for ages during peak times, application performance suddenly lagging: these are some of the things on a long list of possible database performance issues. How can you figure out why your MySQL installation isn't running as fast as you'd like?

In this introductory webinar, we will concentrate on the three main reasons for performance slowdown:

- Poorly optimized queries
-...

Percona MySQL Webinars


Mar 24, 2016

MongoDB Revs You Up: What Storage Engine is Right for You?

Join Jon Tobin, Percona's Director of Solutions Engineering, as he presents "MongoDB Revs You Up: What Storage Engine is Right for You?" As you may or may not know, MongoDB now supports multiple storage engines – a feature the community has been requesting for years! Now that it's here, you might be...

Percona MySQL Webinars


Mar 10, 2016

Introduction to MySQL troubleshooting: basic techniques

Percona MySQL Webinars


Mar 2, 2016

MySQL Troubleshooting Webinars - Part 1

In order to fix an issue, you must first understand it. The easiest way to understand and fix an issue is to repeat its occurrence, make assumptions, create some possible workarounds, then try to test them. Ideally this process occurs on the application development machine, then the fix is pushed live to the production environment.

In the database world, however, this process can fail – often because you need a real production...

Percona MySQL Webinars


Feb 24, 2016

Using Grafana for MySQL Monitoring

Grafana is the leading graph and dashboard builder for visualizing time series, which is a great tool for visual monitoring of MySQL databases. In this webinar, Torkel Odegaard, Grafana Founder and Creator, will provide an intro to...

Percona MySQL Webinars


Feb 16, 2016

MySQL 5.7: Introduction for Operational DBAs

MySQL 5.7 is a great release, providing valuable features for both daily operations and ongoing development. In this, part two of our ongoing 5.7 webinar series, we will look into the new MySQL 5.7 features and enhancements that improve operations, with a specific focus on monitoring. These include:

  • An improved optimizer, including updates to EXPLAIN and enhanced JSON support...

Percona MySQL Webinars


Jan 27, 2016

Compression In Open Source Databases

Data growth has been tremendous in the last decade and has no signs of stopping. To deal with this trend, database technologies have implemented a number of approaches and allowing for data compression is by far the most common and important. Yes compression in open source databases is complicated, however there is a lot of different approaches with their own implications.
In this talk we will perform a survey of compression in...

Percona MySQL Webinars


Jan 8, 2016

Tired of MySQL Making You Wait?

Too often developers and DBAs struggle to pinpoint the root cause of performance issues and then spend too much time in trying to fix them. Discover how you can significantly increase the performance of your applications while also reducing database response time. In this webinar, Principal Architect, Alexander Rubin and Database Evangelist, Janis Griffin will provide the key steps needed to identify, prioritize, and improve query...

Percona MySQL Webinars


Pages