EmergencyEMERGENCY? Get 24/7 Help Now!

A Look at MariaDB Subquery Cache

 | March 2, 2017 |  Posted In: MariaDB, MySQL

MariaDB Subquery Cache

The MariaDB subquery cache feature added in MariaDB 5.3 is not widely known. Let’s see what it is and how it works. What is a subquery cache? The MariaDB subquery cache optimizes the execution of correlated subqueries. Correlated subqueries refer to a value from the parent query. For example:

MariaDB only uses this optimization if […]

Read More

MariaDB at Percona Live Open Source Database Conference 2017

 | February 16, 2017 |  Posted In: MariaDB, MongoDB, MySQL, Percona Live

Percona Live

UPDATE: Sveta Smirnova will be speaking at M17! Her talk is titled Lessons Learned: Troubleshooting Replication. It covers the similarities and differences between MySQL and MariaDB replication, and how to make the correct configuration choices to avoid problems. In this blog, we’ll look at how we plan to represent MariaDB at Percona Live. The MariaDB Corporation […]

Read More

MariaDB ColumnStore

 | January 30, 2017 |  Posted In: MySQL, Solutions Engineering

MariaDB ColumnStore

Last month, MariaDB officially released MariaDB ColumnStore, their column store engine for MySQL. This post discusses what it is (and isn’t), why it matters and how you can approach a test of it. What is ColumnStore? ColumnStore is a storage engine that turns traditional MySQL storage concepts on their head. Instead of storing the data […]

Read More

Webinar Thursday, December 8: Virtual Columns in MySQL and MariaDB

 | December 6, 2016 |  Posted In: MariaDB, MySQL, Technical Webinars

Virtual Columns

Please join Federico Razzoli, Consultant at Percona, on Thursday, December 8, 2016, at 8 AM PT / 11 AM ET (UTC – 8) as he presents Virtual Columns in MySQL and MariaDB. 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 […]

Read More

Percona XtraBackup 2.4.5 is now available

 | November 29, 2016 |  Posted In: MySQL

Percona XtraBackup

Percona announces the GA release of Percona XtraBackup 2.4.5 on November 29th, 2016. You can download it from our download site and from apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered […]

Read More

Percona Live Europe 2016: Day Two Keynote Speakers

 | October 5, 2016 |  Posted In: MySQL, Percona Live

percona live europe

Hello again, from day two of the sold out Percona Live Europe Open Source Database Conference! There is still much excitement here at the conference, and today looks to be just as busy as yesterday. Day two of Percona Live Europe 2016 kicked off once again with a keynote presentation by Percona co-founder and CEO […]

Read More

MariaDB Sessions at Percona Live Europe 2016

 | September 23, 2016 |  Posted In: MariaDB, Percona Live

Percona Live Europe

If you’re going to Percona Live Europe Amsterdam 2016, and are specifically interested in MariaDB-related technologies, there are many talks for you to attend. On Tutorial Monday, you will want to attend my tutorial The Complete MariaDB Server Tutorial. In those three hours, you’ll learn about all the differences that MariaDB Server has to offer […]

Read More

MariaDB 10.2 CHECK and DEFAULT clauses

 | July 29, 2016 |  Posted In: MariaDB, MySQL

MariaDB 10.2 CHECK and DEFAULT

In this blog post, we’ll look at the MariaDB 10.2 CHECK and DEFAULT clauses. MariaDB 10.2 includes some long-awaited features. In this blog, we are going to discuss the improvements to some table definitions: the DEFAULT clause and the CHECK constraints. These clauses describe columns default values and rules for data validation. Note that MariaDB […]

Read More

Percona Live featured talk with Stewart Smith: Why Would I Run MySQL or MariaDB on POWER Anyway?

 | March 23, 2016 |  Posted In: Percona Live

Welcome to the next installment of our talks with Percona Live Data Performance Conference 2016 speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference, as well as discuss the technologies and outlooks of the speakers themselves. Make sure to read to the end to get a special Percona […]

Read More