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

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

Jun 17, 2019

MariaDB and MySQL - What Statistics Optimizer Needs Or When and How Not to Use Indexes

Vicentiu Ciorbaru (MariaDB Foundation) delivers the talk, "MariaDB and MySQL - What Statistics Optimizer Needs Or When and How Not to Use Indexes", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

When your SQL query reaches the DBMS, it's the optimizer's job to decide how to execute it for you to get the result as fast as possible. To make this decision optimizer can examine the actual...

Percona Live SessionsMariaDBMySQLBig DataPerformance Optimization