Nov 3, 2020

Boosting MySQL Performance - Jose Luis Martinez - Percona Live ONLINE 2020

Discover the basic tips and tricks on how to build your MySQL schemas so you don't get caught up in early performance problems.

Learn how to select your tables data types and what performance implications they have. Review how indexing works, as well as basic indexing tips and tricks. A healthy schema is one of the first steps to having a performant database.

MySQLPerformance Optimization

Nov 3, 2020

Sharding: DIY or Out of the Box Solution? - Art van Scheppingen - Percona Live ONLINE 2020

Once vertically scaling your databases can’t help you any further you need to think about sharding them. Sharding basically means you are going to distribute your (write) workload over multiple database hosts using an algorithm. For some OpenSource Databases, you get sharding out of the box, but for MySQL, you don’t.

This means you either implement a sharding yourself and have absolute control over what data goes where or choose...

MySQLPerformance Optimization

Nov 3, 2020

Advanced Optimization and Troubleshooting MySQL Using PMM2 - Peter Zaitsev - Percona Live ONLINE 2020

Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBAs.

The databases powering your applications need to be able to handle changing traffic workloads while remaining responsive and stable so that you can deliver an excellent user experience. Further, DBA’s are also expected to find cost-efficient means of solving these issues. In this presentation, we will...

MySQLPerformance Optimization

Oct 8, 2020

BPFTrace - Dtrace Replacement on Linux

Join Peter Zaitsev, Percona CEO, as he discusses bpfTrace and Dtrace on Linux.

While eBPF was included in Linux kernel for quite a few years, it lacked a good “front end” to complete Dtrace functionality in the Linux ecosystem. In this presentation, Peter will look into BPFTrace as a capable Dtrace replacement. He will also demonstrate how you can develop your own tools and utilities using BPFTrace as well as how you can use the...

OperationsPerformance Optimization

Sep 23, 2020

PostgreSQL High-Performance Tuning and Optimization

Please watch Percona’s Senior Software Engineer, Ibrar Ahmed as he presents the “PostgreSQL High-Performance Tuning and Optimization" webinar.

PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any workload. Thus, any system with least resources can run it. PostgreSQL does not give optimum performance on high permanence machines because it is not using the...

PostgreSQLPerformance Optimization

Sep 21, 2020

Using PMM to identify and troubleshoot problematic MySQL queries

Michael Coburn discusses two methods to identify and troubleshoot problematic MySQL queries using the RED Method and PMM Query Analytics. Michael highlights specific Dashboards in PMM that visualize the rate, errors, and duration of MySQL events that may be impacting the stability and performance of your database instance.

MySQLPerformance Optimization

Sep 21, 2020

Deep Dive Into InnoDB Page Merging and Page Splitting

MySQL/InnoDB constantly performs merge and split operations, and you have very limited visibility of them. But they can bite you, and bite hard, especially if using a spindle storage VS SSD (which have different issues, by the way).

This is an important point to keep in mind. In InnoDB you cannot have fragmented records, but you can have a nightmare at the page-extent level.

The sad story is there is also very little we...

MySQLPerformance Optimization

Jul 27, 2020

Multi-Primary Replication Solutions for PostgreSQL

Join Ibrar Ahmed, Sr. Software Engineer, Percona, as he discusses the concept of multi-primary replication and elaborates on the well-known multi-master replication available.
Scalability can be achieved horizontally or vertically. Vertical scalability means adding more resources/hardware to existing nodes to enhance the capability of the database to store and process more data, for example, adding a new process, memory, or disk to an...

PostgreSQLHigh AvailabilityPerformance Optimization

Jun 12, 2020

Using eBPF for Linux Performance Analysis

eBPF is one of the most powerful instrumentation frameworks in modern Linux Kernel. In this presentation we will cover eBPF basics as well as usage of Interactive eBPF tools, showing practical examples when and how they can help to resolve performance problems. Finally we will look into Cloudflare’s ebpf_exporter and show how you can integrate eBPF with Prometheus for Long Term Monitoring

Performance Optimization

Jun 5, 2020

The journey from a MySQL proxy to being the de-facto multi-functional tool that scales MySQL

ProxySQL has had a stable, generally available release since December 2015, and since that time has moved from Version 1.x to Version 2.x, now with a more fast track release cadence.
The goal of this hour long webinar is to go through some of our design principles and how we have managed to progress from database proxy to multi-function tool that so many benefit from.

ProxySQL 2.0 has so many new features, from setting up...

MySQLPercona XtraDB ClusterPerformance Optimization