Schedule Meeting

a
MariaDB: WITH TIES syntax

MariaDB: WITH TIES syntax

MariaDB implemented the WITH TIES syntax in version 10.6. This feature may not be a ground breaker, but it is useful in some cases and it increases compatibility with some other DBMSs. Let’s see what it does, and what use cases it has. Some history MariaDB (just...
MariaDB 10.6: A Review

MariaDB 10.6: A Review

MariaDB 10.6 went Generally Available (production ready)! The first GA version is 10.6.3, released on 6th July 2021. I’ve made a quick test and I want to put my own thoughts and comments here. For more details, take a look at the Changes and Improvements in...
MariaDB Ignored Indexes

MariaDB Ignored Indexes

MariaDB introduced ignored Indexes in version 10.6. The feature is substantially very similar to MySQL Invisible Indexes (docs), introduced in version 8.0. Here we’ll see how to use Ignored Indexes drop indexes in production with a reasonable risk. See our...
DROP TABLE improvements in MariaDB

DROP TABLE improvements in MariaDB

MariaDB implemented several improvements to the DROP TABLE statement. We summarise them here. This article will be kept up to date when MariaDB implements further improvements, in the future. Loch Lomond, Scotland Contributions Before listing the improvements,...