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.
Software Engineer, MemSQL
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.