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

Consul Architecture

 | October 10, 2016 |  Posted In: MySQL, Percona XtraDB Cluster

consul

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

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