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.

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 — Nessun commento ↓

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→

Archivio di categoria: MariaDB

READ ONLY transactions in MariaDB and MySQL

Using CONNECT to access remote MariaDB or MySQL tables

A MariaDB Server Fest 2020 review

Dropping database objects in a safe way

Logging all MariaDB and MySQL queries into the Slow Log

Understanding tables usage with User Statistics on MariaDB and Percona Server

Why Tables need a Primary Key in MariaDB and MySQL

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

DROP TABLE improvements in MariaDB

MariaDB RETURNING Statements