Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

Virtual Columns in MySQL and MariaDB

Virtual Columns in MySQL and MariaDB

 5 October 4:25 PM - 5:15 PM @ Zürich 1
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
OSDBMS
MySQL
Topics:
MySQL
Optimization

Description

MariaDB 5.2 and MySQL 5.7 introduced virtual columns, with different implementations. Their features and limitations are similar, but not identical. The main difference is that only MySQL allows you to build an index on a non-persistent column. In this talk we'll present some use cases for virtual columns, such as query simplification and UNIQUE constraints based on an SQL expression. In particular, we will see how to use virtual columns to index JSON data in MySQL, or dynamic columns in MariaDB. Performance and limitations will also be discussed.

Speakers

Federico Razzoli's picture

Federico Razzoli

Consultant, Percona

Biography:

Relational databases lover and open source supporter. I am a MariaDB Community Ambassador and I wrote "Mastering MariaDB" in 2014. Currently I work for Percona.

Share this talk


Slides