Videos from Percona
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.
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