Percona Live: Data Performance Conference 2016 Logo

April 18-21, 2016

Santa Clara, California

MyRocks Internals

MyRocks Internals

 19 April 01:20 PM - 2:20 PM @ Ballroom D
Experience level: 
Advanced
Duration: 
50 minutes conference
Tracks:
Architecture/Design
Topics:
MySQL
Devops
Tools and Techniques

Description

MyRocks is a new open source storage engine for MySQL. It is jointly developed by engineers from Facebook and MariaDB. The engine is built on top of RocksDB storage library. Since it uses LSM as a data format, it provides much better compression ratio and much smaller write rate. It is especially beneficial to use MyRocks engine for write heavy workloads on flash storage. In this talk, I will talk briefly about characteristics and benefits of MyRocks. I will spend most of the time looking at internals. I will cover the structure of LSM tree, tuning and parameters. I will talk about how table data is stored on disk. I will especially focus on optimizer stats, how they are computed, how they are persisted. Finally, I will cover some aspects of query optimization and performance tuning.

Speakers

Alexey Maykov's picture

Alexey Maykov

Software Engineer, MemSQL

Biography:

Alexey Maykov is a full stack Software Engineer with emphasis on backend infrastructure. His recent project involves changing internals of MySQL engine. Before that, he built systems which are now in production and support hundreds of millions of users. Alexey's current language is C++ in Linux. He also has great experience of using Python, Bash, Hive/Hadoop.

Share this talk


Slides