Please join Percona’s Principal Technical Services Engineer, Sveta Smirnova, Senior Software Engineer, George Lorch, MariaDB's Query Optimizer Developer Sergei Petrunia and Facebook's Database Engineer Yoshinori Matsunobu as they present “MyRocks Troubleshooting” on March 30, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7).
MyRocks is an alternative storage engine designed for flash storage. It provides great write workload performance and space efficiency. Like any other powerful engine, it has its own specific configuration scenarios that require special troubleshooting solutions.
We will discuss how to deal with:
- Data corruption issues
- Inconsistent data
- Slow performance
We will use well-known instruments and tools, as well as MyRocks-specific tools, and show how they work with the MyRocks storage engine.
About the Authors
George LorchGeorge joined the Percona development team in April 2012. George has over 25 years of experience in software support, development, architecture and project management. Prior to joining Percona, George was focused on Windows based enterprise application server development and network protocol classification and optimization with heavy doses of database schema design, architecture and tuning. George lives in the beautiful mountains of north-central Arizona with his wife and cat. His hobbies are fiddling with cool bits of technology, home brewing and winemaking, tending his ever growing garden, hiking, fishing, camping and otherwise enjoying the out of doors as much as possible.
Sveta SmirnovaSveta joined Percona in 2015. Her main professional interests are problem solving, working with tricky issues, bugs, finding patterns which can solve typical issues quicker, teaching others how to deal with MySQL issues, bugs and gotchas effectively. Before joining Percona Sveta worked as Support Engineer in MySQL Bugs Analysis Support Group in MySQL AB-Sun-Oracle. She is author of book "MySQL Troubleshooting" and JSON UDF functions for MySQL.
Yoshinori Matsunobu, Database Engineer, Facebook
Yoshinori is a database engineer at Facebook. Before joining Facebook, Yoshinori was a database and infrastructure architect at DeNA, living in Tokyo. Yoshinori's primary responsibility at DeNA is to make our database infrastructure more reliable, faster and more scalable. Before joining DeNA, Yoshinori worked at MySQL/Sun/Oracle as a lead consultant in APAC for four years. Yoshinori has written eight MySQL related technical books so far and has published technical articles about MySQL, Linux, and Java for a monthly database magazine since 2004.
Sergei Petrunia, Query Optimizer Developer, MariaDB Corporation
Sergei Petrunia is a query optimizer developer at MariaDB Corporation Ab. He implemented MariaDB's optimizer features like Table Elimination (MariaDB 5.1), improvements to semi-join subquery optimizations (MariaDB 5.3/5.5), SHOW EXPLAIN (MariaDB 10.0), and ANALYZE for statements (MariaDB 10.1) Prior to Monty Program, he has worked for MySQL Ab/Sun Microsystems, where he was the author of query optimizer features like Partition Pruning, Index Merge (MySQL 5.1), and numerous smaller improvements in query optimizer and other parts of the server. He maintains a highly technical blog at http://s.petrunia.net/blog