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


Jun 17, 2019

Squash That Old Bug

Daniel Black (IBM) delivers the talk, "Squash That Old Bug", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

MySQL and MariaDB have a long list of old, potentially trivial bugs that are annoying if you hit them. No one's really bothered to fix them, so why not you? It doesn't take a large amount of C/C++ knowledge to pick out an old bug and build/test a MySQL/MariaDB patch to fix an old bug...

Percona Live SessionsMariaDBMySQLOperations


Jun 17, 2019

MariaDB Security Features and Best Practices

Robert Bindar (MariaDB Foundation) delivers the talk, "MariaDB Security Features and Best Practices", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

Most Enterprises today own information of critical value such as intellectual property, customers personal data or private financial data. This type of data should never be exposed to unauthorized malicious access.

Our session covers...

Percona Live SessionsOpen Source DatabaseMariaDBMySQLMonitoring and Operations


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

MySQL and ZFS

Yves Trudeau (Percona) delivers the talk, "MySQL and ZFS", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

MySQL, as a database, strives on a filesystem but not all filesystems are equal! On Linux, ZFS is gaining attention and there are good reasons for that, especially if you happen to also run MySQL. In this talk, I'll describe the main characteristics and features of ZFS and draw...

Percona Live SessionsMySQL


Jun 17, 2019

A Discussion on the Advantages Afforded MySQL DBaaS offerings hosted on Intel's Next Gen Platfo

David Cohen (Intel), Steve Scargall (Intel), Jeff Smits (Intel) deliver the talk, "A Discussion on the Advantages Afforded MySQL DBaaS offerings hosted on Intel's Next Gen Platform", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

In this talk, we discuss the use of the open source MySQL Community Edition and Percona Server projects and Intel's Cascade Lake server platform as the primary...

Percona Live SessionsMariaDBMySQL


Jun 17, 2019

MySQL 8.0 Performance: Scalability & Benchmarks

Dimitri KRAVTCHUK (MySQL/Oracle) delivers the talk, "", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

This session will be interesting to everyone looking for the latest news about MySQL 8.0 Performance:
- since MySQL 8.0 we moved to "continuous release" model
- so with every update, many new improvements are delivered
- but how does it also improve MySQL 8.0 Performance...

Percona Live SessionsOpen Source DatabaseMariaDBMySQL


Jun 17, 2019

InnoDB Management and Scalability Improvements in MySQL 8.0

Percona Live SessionsMySQLPerformance 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


Jun 17, 2019

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 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

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

Percona Live SessionsOpen Source DatabasePostgreSQLMariaDBMySQLPercona Monitoring and Management


Pages