Jun 17, 2019

Tips and Tricks with MariaDB ColumnStore

Jim Tommaney delivers the talk, "Tips and Tricks with MariaDB ColumnStore", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

Make the most of your ColumnStore columnar analytics engine!
Deep dive into best practices for columnar engines in general, what are the best use cases for columnar, and tips and trick for both ColumnStore and other analytics engines.

Analytics without...

Percona Live SessionsMariaDBQuery Tuning and Optimization


Jun 17, 2019

The MySQL Query Optimizer Explained Through Optimizer Trace

Øystein Grøvlen (Alibaba Cloud) delivers the talk, "The MySQL Query Optimizer Explained Through Optimizer Trace", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

All major considerations and decisions made by the MySQL Query Optimizer may be recorded in an Optimizer Trace. While EXPLAIN will show the query execution plan the Query Optimizer has decided to use, MySQL's Optimizer Trace will...

Percona Live SessionsMySQLQuery Tuning and Optimization


Sep 27, 2018

Best Practices Using Indexes in MongoDB

Please watch Percona’s Principal Architect Alex Rubin as he presents “Best Practices Using Indexes in MongoDB”.

Indexes support the efficient execution of queries in MongoDB. Without indexes, MongoDB must perform a collection scan, i.e. scan every document in a collection, to select those documents that match the query statement.

In this webinar we’ll discuss the following:
* How MongoDB uses indexes
* What...

MongoDBPercona MySQL WebinarsQuery Tuning and Optimization


Aug 27, 2018

Observability features of Vitess

Sugu Sougoumarane (PlanetScale Data) delivers the talk, "Observability features of Vitess", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

Vitess is now used in production at multiple companies. This has led to many inquiries about Observability. Vitess shines in this area by providing query logs, transaction logs, information URLs, and status variables that can feed into a monitoring...

Percona Live SessionsMySQLQuery Tuning and Optimization


Aug 20, 2018

MariaDB Optimizer in 10.3, where does it stand?

Vicentiu Ciorbaru (MariaDB Foundation), Sergei Petrunia (MariaDB Corporation) delivers the talk, "MariaDB Optimizer in 10.3, where does it stand?", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

This talk will go through the set of optimizations available to MariaDB's query optimizer in 10.3.

We will also compare MariaDB's optimizer and special querying capabilities with that...

Percona Live SessionsMariaDBQuery Tuning and Optimization


Aug 20, 2018

Top Five MySQL Query Tuning Tips

Janis Griffin (SolarWinds) delivers the talk, "Top Five MySQL Query Tuning Tips", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

Query tuning can be complex. It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, database performance evangelist at SolarWinds, will share her secrets for determining the...

Percona Live SessionsMySQLMonitoring and OperationsQuery Tuning and OptimizationMySQL-related Technologies


Aug 10, 2018

Tuning PostgreSQL for High-Write Workloads

Grant McAlister (Amazon Web Services) delivers the talk, "Tuning PostgreSQL for High-Write Workloads", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

In this session, we will cover a number of the way that you can tune PostgreSQL to better handle high write workloads. We will cover both application and database tuning methods as each type can have substantial benefits but can also...

Percona Live SessionsPostgreSQLQuery Tuning and Optimization


Aug 9, 2018

Query Optimizer - MySQL vs. PostgreSQL

Christian Antognini (Trivadis) delivers the talk, "Query Optimizer - MySQL vs. PostgreSQL", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

MySQL and PostgreSQL are the two most popular open-source relational databases. To help choosing between them, a comparison of their query optimizers has been carried out. The aim of this session is to summarize the outcome of the comparison....

MySQLQuery Tuning and OptimizationMySQL-related Technologies


Aug 9, 2018

Engineering The Application/Database Boundary

Baron Schwartz (VividCortex) delivers the talk, "Engineering The Application/Database Boundary", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

The interaction between applications and the database is one of the most intricate and important in the systems we build. This boundary region is special and complex for a number of reasons. It's the surface that separates stateful from...

Query Tuning and Optimization


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