Jan 4, 2019

High-Performance PostgreSQL, Tuning and Optimization Guide

Please watch Percona’s Senior Software Engineer, Ibrar Ahmed as he presents his talk “High-Performance PostgreSQL, Tuning and Optimization Guide”.

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...

PostgreSQLPercona MySQL WebinarsPerformance Optimization


Aug 23, 2018

MySQL Performance Optimization and Troubleshooting with Percona Monitoring and Management

Peter Zaitsev (Percona) delivers the talk, "MySQL Performance Optimization and Troubleshooting with Percona Monitoring and Management ", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBA's. The databases powering your applications need to be able to handle...

Percona Live SessionsMySQLMonitoring and OperationsPerformance OptimizationMySQL-related Technologies


Aug 20, 2018

Automated DBA

Nikolay Samokhvalov (Nombox) delivers the talk, "Automated DBA", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

postgres_dba (https://github.com/NikolayS/postgres_dba) - is a brand new open source DBA tool set, which can be used by any application developer to find database issues possible solutions much faster.

In this...

Percona Live SessionsPostgreSQLSecurityPerformance Optimization


Aug 20, 2018

Cassandra on RocksDB

Dikang Gu (Facebook) delivers the talk, "Cassandra on RocksDB", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

This year the Cassandra team in Instagram has been working on a very interesting project to make Apache Cassandra's storage engine pluggable and implemented a new RocksDB-based storage engine into Cassandra. The new storage engine can improve the performance of Apache...

Percona Live SessionsPerformance OptimizationNoSQL


Aug 13, 2018

How Microsoft Built MySQL, PostgreSQL and MariaDB for the Cloud

Jun Su (Microsoft) delivers the talk, "How Microsoft Built MySQL, PostgreSQL and MariaDB for the Cloud", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

Offering MySQL, PostgreSQL and MariaDB database services in the cloud is different than doing so on-premise. Latency, connection redirection, optimal performance configuration are just a few challenges. In this session, Jun Su will...

Percona Live SessionsPostgreSQLCloudMariaDBMySQLPerformance OptimizationScalabilityCloud Solutions


Jun 21, 2018

How to Analyze and Tune MySQL Queries for Better Performance

Please join Percona’s MySQL Database Administrator, Brad Mickel as he presents How to Analyze and Tune MySQL Queries for Better Performance.

Query performance is essential in making any application successful. In order to finely tune your queries you first need to understand how MySQL executes them, and what tools are available to help identify problems.

In this session you will learn:
1) The common tools for...

MySQLPercona MySQL WebinarsPerformance OptimizationQuery Tuning and Optimization


Jun 13, 2018

Performance Analysis and Troubleshooting Methodologies 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 WebinarsMonitoring and OperationsPerformance Optimization


May 29, 2018

MySQL,PXC, ProxySQL, Kubernetes: How they work together

In this webinar, Alex will discuss how to deploy a highly available MySQL database environment on Kubernetes/Openshift using Percona XtraDB Cluster (PXC) together with MySQL Proxy to implement read/write splitting.

If you have never used Kubernetes and Openshift, or never used PXC / MySQL Proxy, Alex will do a quick introduction to these technologies. There will also be a demo where Alex sets up a PXC cluster with ProxySQL in...

MySQLPercona MySQL WebinarsPercona XtraDB ClusterPerformance Optimization


May 9, 2018

MySQL Troubleshooting and Performance Optimization with PMM

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 heavy traffic loads while remaining responsive and stable so that you can deliver an excellent user experience. Further, DBAs are also expected to find cost-efficient means of solving these issues.

In this webinar, Peter will discuss...

MySQLPercona MySQL WebinarsPerformance Optimization


Apr 2, 2018

How Percona Maintains the Optimal Health of Customers

How do you guarantee optimal database performance for your critical applications and services? Proactive monitoring and intervention is one way.
Percona Technical Account Managers (TAM) are expert DBAs that provide proactive assistance to our Managed Service customers -- helping to guarantee performance, availability and reliability.
In today's webinar, we'll discuss some of the tools and methodologies used by Percona's...

MongoDBMySQLNoSQLPercona MySQL WebinarsPercona Open Source SoftwarePerformance Optimization


Pages