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


May 26, 2020

Mostly mistaken and ignored parameters while optimizing a PostgreSQL database - Percona Live 2020

Avi Vallarapu talked about Optimizing a PostgreSQL database may be a challenge if some of the important parameters are ignored. And a bigger challenge may be the algorithm behind setting those parameters correctly. In my experience with PostgreSQL Consulting for more than a decade, I have seen a bigger list of parameters that are wrongly set or ignored. This talk details such a list of important PostgreSQL parameters considering the latest...

Percona Live SessionsPostgreSQLPerformance Optimization


May 26, 2020

Diagnosing memory utilization, leaks and stalls in production - Marcos Albe - Percona Live 2020

Finding out what parts of our code are consuming (or leaking!) memory can be a challenge if we don't have the right tools. Until not so long ago most of us relied on Valgrind/Massif to find out, but this had a huge impact on performance and was not really practical for production systems. Gladly this has been slowly changing as more systems get upgraded to Linux releases with 4.x Kernels, where it's easy to set up tools like eBPF and perf...

Percona Live SessionsPerformance Optimization


May 26, 2020

Kubernetes - the Swiss Army Knife for your ProxySQL deployments - Rene Cannao - Percona Live 2020

ProxySQL is a high performance proxy from design to implementation. It speaks the MySQL protocol, and can go beyond load balancing. This talk covers various deployment options for ProxySQL in a Kubernetes environment.
Typically ProxySQL is deployed in one of three ways depending on the scale and needs of your environment:
- Directly on each application server
- On a separate server (or layer)
- Cascaded, i.e. on each...

Percona Live SessionsMySQLPerformance Optimization


May 26, 2020

Creating an Open Source MySQL Firewall - Alex Rubin - Percona Live Online 2020

Creating an Open Source MySQL Firewall

Percona Live SessionsMySQLPerformance Optimization


May 20, 2020

18 Things To Do When You Have a MySQL Bottleneck

Peter Zaitsev, Founder and CEO at Percona, presents a webinar focused on dealing with an unexpected high traffic event as it is happening. He'll address the impact a traffic spike can have on your database - from poor query response time to replication lag issues - and provide actionable tips and tricks. Join us and learn how to bring your database under control, earn performance gains and delight your customers!

MySQLHigh AvailabilityPerformance Optimization


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


Jan 15, 2020

MongoDB 4.0 and 4.2 Performance Review - What’s New

This webinar will walk you through the performance improvements for the MongoDB 4.0 and 4.2 versions:
- No more blocking secondary reads for the replica set.
- Improved Index builds with foreground but non-blocking behavior!
- Wild card index for the queries against unknown fields.

MongoDBPerformance Optimization


Pages