Archivio di categoria: MariaDB

MariaDB is a widely used open source database for both OLTP and OLAP workloads. It was born as a MySQL fork, which makes it very competitive for transactional environments at scale. However, MariaDB Corporation chosen to develop features and optimisation that allows MariaDB to compete with Oracle in the analytics market.

At Vettabase we are MariaDB experts, not just MySQL professional with some knowledge of MariaDB. Here we share hints and insights about MariaDB specific features, optimisations and internals.

A MariaDB Server Fest 2020 review

Pubblicato il 21 Settembre 2020 da Federico Razzoli — Nessun commento ↓

MariaDB Server Fest 2020 was a great online event for the MariaDB community. This is a review from Vettabase. Continua a leggere A MariaDB Server Fest 2020 review→

Dropping database objects in a safe way

Pubblicato il 28 Agosto 2020 da Federico Razzoli — 3 commenti ↓

Running DROP statements in production is always dangerous. But there are some measures we can take to make them safer. Continua a leggere Dropping database objects in a safe way→

Logging all MariaDB and MySQL queries into the Slow Log

Pubblicato il 18 Agosto 2020 da Federico Razzoli — 2 commenti ↓

MySQL and MariaDB optionally log slow queries into the Slow Query Log – or just Slow Log, as friends call it. However, there are good reasons to log all the queries, not just some of them. Continua a leggere Logging all MariaDB and MySQL queries into the Slow Log→

Understanding tables usage with User Statistics on MariaDB and Percona Server

Pubblicato il 12 Agosto 2020 da Federico Razzoli — 2 commenti ↓

A measuring tape

User Statistics plugin allows to analyse the way tables are used, which of them are used most – and therefore, on what we need to focus on to optimise the server’s workload. Continua a leggere Understanding tables usage with User Statistics on MariaDB and Percona Server→

Why Tables need a Primary Key in MariaDB and MySQL

Pubblicato il 10 Agosto 2020 da Federico Razzoli — 3 commenti ↓

In MariaDB and MySQL, all tables should have a primary key – especially InnoDB tables. Here’s why. Continua a leggere Why Tables need a Primary Key in MariaDB and MySQL→

MariaDB/MySQL: Using views to grant or deny row-level privileges

Pubblicato il 7 Agosto 2020 da Federico Razzoli — 4 commenti ↓

A view of the Isle of Skye, Scotland

It is possible to prevent some users from seeing a set of rows in a certain table. Continua a leggere MariaDB/MySQL: Using views to grant or deny row-level privileges→

DROP TABLE improvements in MariaDB

Pubblicato il 6 Agosto 2020 da Federico Razzoli — Nessun commento ↓

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. Continua a leggere DROP TABLE improvements in MariaDB→

MariaDB RETURNING Statements

Pubblicato il 5 Agosto 2020 da Federico Razzoli — 1 commento ↓

MariaDB supports RETURNING statements, that can save one query making our applications faster and reducing server source usage. Continua a leggere MariaDB RETURNING Statements→