Vicentiu Ciorbaru

Vicentiu Ciorbaru

Vicentiu Ciorbaru

Software Developer, Team Lead, MariaDB Foundation

Biography:


All Sessions

MariaDB and MySQL - What Statistics Optimizer Needs Or When and How Not to Use Indexes

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 table data, but with multi gigabyte and terabyte tables, the only practical solution is to use various data statistics that were collected in advance. The better the statistics and the more precisely it describes the actual data, the faster the plan will be because the optimizer image of reality will be closer to the actual reality.

In this talk, you'll learn what data statistics MariaDB and MySQL can collect, what statements do that, how to tell the optimizer to use it (it won't necessarily do it automatically!) and how it can make your queries many times faster.

And, of course, when not to use indexes, when up-to-date statistics is enough.

MariaDB 10.4, Where We Are Now

MariaDB Server has come a long way since it forked MySQL in 2009. Nine releases later, it is now default in most major Linux distributions no longer a mere alternative to MySQL, but to Oracle, through its compatibility mode with support for PL/SQL and other non-MySQL functionality.MariaDB Foundation has also matured since it was established in 2012. With board members from MariaDB Corporation, Visma, Booking.com, IBM, Automattic, Tencent, Alibaba and Microsoft, MariaDB Foundation has created a vibrant community of contributors, with the number of submitted pull requests being four times that of MySQL over their respective lifetimes. Join MariaDB Foundation Senior Team Lead Vicențiu Ciorbaru for this keynote, where he compares the mission of MariaDB Foundation with its achievements and highlights the latest contributions and functionality in its freshest stable release, 10.4.

Connect with Percona

Stay Connected on:

Percona Live Conferences

The Percona Live Open Source Database Conferences are the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software.
 

Contact Us

For general information about the event/expo/conference, including registration, please contact us at:

  • info(@) percona.com
  • +1-888-401-3401
  • +1-919-948-2863