Vicentiu Ciorbaru

Vicentiu Ciorbaru

Vicentiu Ciorbaru

Software Engineer, MariaDB Foundation

Biography:

Vicentiu works at the MariaDB Foundation as a Software Engineer. He focuses on Optimizer development, but has also worked on other parts of the MariaDB Server.

Notable projects include:
Window Functions in MariaDB
Custom Aggregate Functions in MariaDB
Roles in MariaDB


All Sessions

MariaDB 10.4 Reverse Privileges (DENY)

How do you exclude one table access from a database with too many tables? In previous versions of MariaDB and MySQL, you have to specifically grant access to all other tables individually. This does not scale, especially if tables are created and dropped frequently.

Reverse privileges solve this problem and many other use cases. With just one SQL statement you can ensure a user can never access a resource, regardless which roles or other privileges are granted to it.

Reverse privileges do not work in a vacuum, so we will start with a broad view of the full privilege system, before diving into the specifics of denying access to resources.

MariaDB 10.3 Optimizer and beyond

Database optimizers are constantly improving. During this session, we will cover the new optimizations implemented by the optimizer team for MariaDB 10.3 release and the planned projects for the next 10.4 release.

Highlights are:
* Condition Pushdown through GROUP BY and PARTITION BY
* Split-grouping for derived tables (a guaranteed speedup where the optimization applies)
* Improved Engine-Independent Table Statistics support
* New optimizer default settings

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