Mar 27, 2020

When is MyRocks Good?

In this talk, we'll walk through RocksDB technology and look into situations where MyRocks is a good fit verses other engines such as InnoDB. We will go over internals, benchmarks, and tuning of MyRocks engine. We will also explore the benefits of using MyRocks within the MySQL ecosystem. Attendees will leave with solid knowledge of the latest development tools and integrations within MySQL.

MySQLOperationsPerformance Optimization


Mar 20, 2020

Optimize and Troubleshoot MySQL using Percona Monitoring and Management (PMM)

As a MySQL DBA, the databases powering your applications need to handle changing traffic workloads while remaining responsive and stable so you can deliver an excellent user experience. Optimizing MySQL performance and troubleshooting MySQL problems cost efficiently are some of the most critical and challenging tasks for MySQL DBAs. In this presentation, we will look at specific, common MySQL problems and demonstrate how PMM, built on...

MySQLMonitoring and OperationsPerformance Optimization


Mar 17, 2020

MySQL 8 vs MariaDB 10.4

At the moment MySQL 8 and MariaDB 10.4 are the latest versions of the corresponding database management systems. Each of these DBMS has a unique set of features. For example, specific MariaDB features might be unavailable in MySQL, and vice versa. In this presentation, we’ll cover these new features and provide recommendations regarding which will work best on which DBMS.

MariaDBMySQL


Mar 12, 2020

17 Things Developers Need to Know about Databases

Most applications use databases, yet many fail to follow even the most basic best practices resulting in poor performance, downtime and security incidents.
In this presentation, we will look into the foundational best practices you as a Developer should know about databases, with particular focus on the most popular Open Source Databases - MySQL, PostgreSQL, and MongoDB.

PostgreSQLMongoDBMySQL


Jan 24, 2020

How to Upgrade to MySQL 8 Like a Boss

During this webinar, we will review the MySQL 8.0 upgrade process. In this deep dive session, we will review the latest version of MySQL 8.0, discuss upgrade challenges, bugs, gotchas and how to successfully upgrade to MySQL 8.0.

MySQLOperations


Jan 8, 2020

The Pros and Cons of PCI/DSS Certification with MySQL

This talk uncovers which tools/plugins/settings you need to use to comply with PCI/DSS when using MySQL. Gain a solid grasp of the possibilities, as well as the limitations, MySQL offers to someone looking to become PCI/DSS certified.

MySQLOperations


Dec 31, 2019

Top 3 Features of MySQL

MySQL has been ranked as the second most popular database since 2012 according to DB-Engines: https://db-engines.com/en/ranking_trend. Three features help it retain its top position: replication, storage engines and NoSQL support. During this webinar, we'll discuss the MySQL architecture surrounding these features and how to utilize their full power when...

MySQLPerformanceReplication


Dec 9, 2019

Introduction to MySQL Query Tuning for DevOps

MySQL does its best to return requested bytes as fast as possible. However, it needs human help to identify what is important and should be accessed in the first place. Queries, written smartly, can significantly outperform automatically generated ones. Indexes and Optimizer statistics, not limited to the Histograms only, help increase the speed of the query.

DeveloperMySQLOperations


Aug 26, 2019

Flame Graphs 201

Visualizing profiling information can be a very powerful tool for performance diagnostics, specially if we zoom right into the problem. Flame graphs were developed for this purpose and we use them on a daily basis at Percona to successfully solve complex performance issues. In this presentation, attendees will learn advanced techniques for profiling with performance and visualizing those profiles with flame graphs, as well as other...

MySQLPercona MySQL Webinars


Aug 7, 2019

Performance Analyses and Troubleshooting Technologies for Databases

Have you heard about the USE Method (Utilization - Saturation - Errors), RED (Rate - Errors - Duration) or Golden Signals (Latency - Traffic - Errors - Saturations)?

In this presentation, we will talk briefly about these different-but-similar “focuses” and discuss how we can apply them to data infrastructure performance analysis troubleshooting and monitoring.

We will use MySQL as an example, but most of this talk applies...

MySQLPercona MySQL WebinarsPerformance Optimization


Pages