A Look at MariaDB Subquery Cache

Mar 02, 2017 | MariaDB, MySQL

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 […]

Consul Architecture

Oct 10, 2016 | MySQL, Percona Software

In this blog post, I’ll provide my thoughts about Consul for ProxySQL service discovery and automation. I approached Consul recently while looking for a service discovery and configuration automation solution for ProxySQL. My colleague Nik Vyzas wrote a great post on this topic, and I suggest you read it. I wrote this article to share my first impressions […]

MariaDB 10.2 CHECK and DEFAULT clauses

Jul 29, 2016 | MariaDB, MySQL

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 […]