by Federico Razzoli | Dec 13, 2021 | MariaDB, MariaDB Features
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...
by Federico Razzoli | Jul 7, 2021 | MariaDB
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...
by Federico Razzoli | Jun 11, 2021 | MariaDB
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...
by Federico Razzoli | Aug 8, 2020 | MariaDB, MySQL
This is what can happen if triggers areupdated while applications are running Sometimes it is necessary to update multiple triggers in production. It may be necessary to do so without causing temporary inconsistencies between them, which could cause a service...
by Federico Razzoli | Aug 6, 2020 | 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,...