mariadb-10.6 Archives - Vettabase

MariaDB: WITH TIES syntax

Posted on 13 December 2021 by Federico Razzoli — No Comments ↓

<img width="283" height="200" src="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" srcset="https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small.jpeg 283w, https://vettabase.com/blog/wp-content/uploads/2021/05/training_mariadb_small-16x12.jpeg 16w" sizes="(max-width: 283px) 100vw, 283px" />

Semantics and use cases of the WITH TIES syntax. Continue reading MariaDB: WITH TIES syntax→

A summary of MariaDB 10.6

Posted on 7 July 2021 by Federico Razzoli — No Comments ↓

<img width="640" height="318" src="https://vettabase.com/blog/wp-content/uploads/2021/07/upgrade_to_mariadb_10_6-640x318.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" loading="lazy" srcset="https://vettabase.com/blog/wp-content/uploads/2021/07/upgrade_to_mariadb_10_6-640x318.jpeg 640w, https://vettabase.com/blog/wp-content/uploads/2021/07/upgrade_to_mariadb_10_6-16x8.jpeg 16w" sizes="(max-width: 640px) 100vw, 640px" />

MariaDB 10.6 is now Generally Available! Let’s see what’s new and if it’s worth an upgrade. Continue reading A summary of MariaDB 10.6→

MariaDB Ignored Indexes

Posted on 12 June 2021 by Federico Razzoli — No Comments ↓

<img width="640" height="318" src="https://vettabase.com/blog/wp-content/uploads/2021/06/mariadb_ignored_indexes_smaller-640x318.jpeg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="" loading="lazy" srcset="https://vettabase.com/blog/wp-content/uploads/2021/06/mariadb_ignored_indexes_smaller-640x318.jpeg 640w, https://vettabase.com/blog/wp-content/uploads/2021/06/mariadb_ignored_indexes_smaller-16x8.jpeg 16w" sizes="(max-width: 640px) 100vw, 640px" />

Ignored Index are a MariaDB 10.6 feature that allows us to drop an index in production reducing the risks. Continue reading MariaDB Ignored Indexes→

Updating triggers in production with MariaDB and MySQL

Posted on 8 August 2020 by Federico Razzoli — No Comments ↓

<img width="300" height="200" src="https://vettabase.com/blog/wp-content/uploads/2020/08/landslide_danger.jpg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="Landslide danger road sign" loading="lazy" />

Landslide danger road sign

Updating triggers in production without causing a service disruption Continue reading Updating triggers in production with MariaDB and MySQL→

DROP TABLE improvements in MariaDB

Posted on 6 August 2020 by Federico Razzoli — No Comments ↓

<img width="640" height="318" src="https://vettabase.com/blog/wp-content/uploads/2020/08/loch_lomond-640x318.jpg" class="attachment-featured-slider size-featured-slider wp-post-image" alt="Loch Lomond" loading="lazy" />

Loch Lomond

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. Continue reading DROP TABLE improvements in MariaDB→