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


Aug 9, 2018

Bringing Multi-threading to the I/O Level

Rodrigo Medeiros (DataCore) delivers the talk, "Bringing Multi-threading to the I/O Level", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

Many administrators responsible for databases confront two clashing phenomena:

· Data is coming at increasingly higher rates (from an expanding number of sources)
· The time required to process transactions and analyze data is rapidly...

Percona Live SessionsCloudPerformanceBig Data


Aug 9, 2018

Buffering to Redis for Efficient Real-Time Processing

Jonathan Hyman (Braze Inc.) delivers the talk, "Buffering to Redis for Efficient Real-Time Processing", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

Braze is a lifecycle engagement platform used by consumer brand to deliver great customer experiences to over 1 billion monthly active users. In this talk, co-founder and CTO Jon Hyman will go over multiple production use cases Braze...

Percona Live SessionsPerformanceBig Data


Aug 9, 2018

Brothers in Arms - How to Make MySQL and PostgreSQL Work Together

Charly Batista (Percona) delivers the talk, "Brothers in Arms - How to Make MySQL and PostgreSQL Work Together", on DAY 1 of the Percona Live Open Source Database Conference 2018, 4/24, at Santa Clara, CA.

The world is becoming increasingly complex for professionals working with data. The amount and diversity of data are on a level never before seen, and we often have to use different tools to store the increasing amount of data...

MySQLBig Data


Dec 16, 2017

Capacity Planning for your Data Stores

In this webinar, Colin uses a ticket sales website that does “normal” events like an M2M concert, but also occasionally also sells tickets to the Harry Potter theatre show.
Selling tickets requires that you don’t sell more tickets than you actually have. You want to load balance your queries. You want to shard your data stores. You may want to split reads and writes. You need to determine where the system bottlenecks, so for that...

MongoDBMySQLPercona MySQL WebinarsStorageBig Data


May 5, 2017

Building a scalable time-series database on PostgreSQL

Michael J. Freedman, Co-founder/CTO, Timescale - Professor of Computer Science, TimescaleDB delivers his talk, "Building a scalable time-series database on PostgreSQL", on DAY 2 of the Percona Live Open Source Database Conference 2017, 4/26, at Santa Clara, CA.

Today everything is instrumented, generating more and more time-series data streams that need to be monitored and analyzed. When it comes to storing this data, many...

Percona Live SessionsCloudMySQLNon-MySQLPerformanceBig DataNoSQL