Skip to content

Vettabase

Watch your data from the top of a mountain. We take care of the machinery.

Menu

Primary menu

  • Services
    • Database Automation
    • Health Checks
      • MariaDB
      • MySQL
      • Cassandra
      • PostgreSQL
    • Monthly Time
    • Training
      • MariaDB
      • MySQL
      • Analysts Training
    • Upgrades and Migrations
      • Database Upgrades
      • Migration from CentOS
  • Articles
    • Vettabase
    • Automation
    • MariaDB
    • MySQL
    • PostgreSQL
  • Resources
    • Ebooks
    • VettaArchive
  • About
    • Testimonials
    • On the Web
    • Careers
    • Contact Us

Category Archives: 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.

Sizing Aria Pagecache

Posted on 18 February 2021 by Federico Razzoli — No Comments ↓

Aria pagecache is used to cache frequently read index blocks, reducing the accesses to disks. Let’s see how to check if its size is adequate. Continue reading Sizing Aria Pagecache→

Posted inMariaDB Storage Engines | Leave a reply

How to skip an Ansible task by default

Posted on 2 February 2021 by Federico Razzoli — 2 Comments ↓

Ansible can skip certain tasks by default. This can be useful when we automate databases. Let’s see how to do it and why. Continue reading How to skip an Ansible task by default→

Posted inDatabase Automation, MariaDB | 2 Replies

Can we shrink InnoDB Buffer Pool?

Posted on 21 January 2021 by Federico Razzoli — No Comments ↓

An oversized InnoDB buffer pool will consume too many resources and can be slower than necessary. Let’s see how to check if we can shrink it. Continue reading Can we shrink InnoDB Buffer Pool?→

Posted inMariaDB InnoDB, MySQL InnoDB | Taggedinnodb-buffer-pool | Leave a reply

Is InnoDB Buffer Pool big enough?

Posted on 6 January 2021 by Federico Razzoli — 2 Comments ↓

InnoDB buffer pool is the most important memory area to allocate. It contains the most frequently read data and index entries from InnoDB tables. Let’s see how to check if it is big enough. Continue reading Is InnoDB Buffer Pool big enough?→

Posted inMariaDB InnoDB, MySQL InnoDB | Taggedinnodb-buffer-pool | 2 Replies

MariaDB/MySQL IS NULL conditions and indexes

Posted on 14 November 2020 by Federico Razzoli — 2 Comments ↓

It is quite common to use an equality condition and an IS NULL condition on the same columns. Unfortunately, this could make queries very slow. Continue reading MariaDB/MySQL IS NULL conditions and indexes→

Posted inMariaDB, MySQL | Taggednull | 2 Replies

Monitoring that AUTO_INCREMENT values won’t reach the limit

Posted on 13 November 2020 by Federico Razzoli — 2 Comments ↓

AUTO_INCREMENT primary keys are useful, because they save usthe trouble to generate a unique value for every row, delegating this task to the database. But when we reach the limit we need to take some action, or we won’t be able to insert more rows. Continue reading Monitoring that AUTO_INCREMENT values won’t reach the limit→

Posted inMariaDB, MySQL | 2 Replies

MySQL/MariaDB: use SQL properly to run less queries

Posted on 29 October 2020 by Federico Razzoli — No Comments ↓

Reducing the number of queries is important with any DBMS. There are two reasons for this: reducing the latency of applications; and reducing the workload for the database servers. Continue reading MySQL/MariaDB: use SQL properly to run less queries→

Posted inMariaDB, MySQL, SQL Language | Leave a reply

The risks of MySQL release policy

Posted on 27 October 2020 by Federico Razzoli — No Comments ↓

MySQL 8.0 and 5.7 follow a new release policy that exposes users to important risks. They broke compatibility with Xtrabackup (again). Continue reading The risks of MySQL release policy→

Posted inMariaDB, MySQL | Leave a reply

READ ONLY transactions in MariaDB and MySQL

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

Transactions can be read only. This article explains what read only transactions are and why we should use them when appropriate. Continue reading READ ONLY transactions in MariaDB and MySQL→

Posted inMariaDB InnoDB, MySQL InnoDB | TaggedMariaDB-10.0, MySQL-5.6 | Leave a reply

Using CONNECT to access remote MariaDB or MySQL tables

Posted on 23 September 2020 by Federico Razzoli — 2 Comments ↓

This article discusses how to access data from a remote table using the CONNECT storage engine, in MariaDB. Continue reading Using CONNECT to access remote MariaDB or MySQL tables→

Posted inMariaDB Storage Engines | TaggedMariaDB-10.0 | 2 Replies

Post navigation

← Older posts

Primary Sidebar Widget Area


en_GB English

en_GB English


it_IT Italian

Vettabase Ltd logo

Content License

Creative Commons License
Except where otherwise noted, the content on this site is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Recent Posts

  • Basic practices for optimizing read and write performance in PostgreSQL
  • Vettabase is now a MariaDB Foundation Technology Partner
  • Sizing Aria Pagecache
  • How to skip an Ansible task by default
  • Can we shrink InnoDB Buffer Pool?

Categories

  • Amazon Redshift
  • Database Automation
  • Databases
  • MariaDB
  • MariaDB InnoDB
  • MariaDB Storage Engines
  • MySQL
  • MySQL InnoDB
  • PostgreSQL
  • SQL Language
  • Stored Procedures
  • Systems
  • Vettabase

Services

Check how Vettabase can maximise the efficiency and reliability of your database infrastructure!

  • Health Checks
  • Monthly Time
  • Training
  • Facebook
  • Twitter
  • Linkedin
  • RSS Feed
  • Instagram
  • Email
Copyright © 2021 Vettabase. All Rights Reserved.
Theme: Catch Box by Catch Themes
Scroll Up
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking "Accept", you consent to the use of ALL the cookies.
Cookie settingsACCEPT
Policy dei Cookie

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

SAVE & ACCEPT