Skip to content

Vettabase

Expert consulting and automation for your database infrastructure

Menu

Primary menu

  • Services
    • Monthly Time
    • Database Training
      • MariaDB
      • MySQL
      • Data Analysts Training
    • Health Checks
      • MariaDB
      • MySQL
      • PostgreSQL
      • Cassandra
    • Database Automation
    • Database Upgrades
  • Blog
    • Database Automation
    • MariaDB
    • MySQL
    • PostgreSQL
    • Cassandra
  • Resources
    • Ebooks
    • VettaArchive
  • About
    • Company updates
    • Testimonials
    • Partners
    • 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.

MariaDB/MySQL: Working with MD5 or other hashes

Posted on 17 February 2022 by Federico Razzoli — 2 Comments ↓

The optimal way to store a MD5 hashes in MariaDB, and how to work with them. Continue reading MariaDB/MySQL: Working with MD5 or other hashes→

Posted in MariaDB, MySQL | 2 Replies

MariaDB: The regexp + LIKE optimisation

Posted on 27 January 2022 by Federico Razzoli — No Comments ↓

MariaDB supports regular expressions, but regexps won’t use indexes. Here’s a workaround that can be used in some cases. Continue reading MariaDB: The regexp + LIKE optimisation→

Posted in MariaDB, MySQL | Leave a reply

MariaDB: WITH TIES syntax

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

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

Posted in MariaDB Features | Tagged mariadb-10.6 | Leave a reply

How to delete duplicate rows in MariaDB

Posted on 28 November 2021 by Federico Razzoli — No Comments ↓

How to remote duplicate values from a table to add a UNIQUE index, in MariaDB. Continue reading How to delete duplicate rows in MariaDB→

Posted in MariaDB | Tagged mariadb-10.2 | Leave a reply

How slow is SELECT * ?

Posted on 18 September 2021 by Federico Razzoli — 4 Comments ↓

The most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all columns are needed, they should list their names, because more columns could be created in the future. But developers find this really Continue reading How slow is SELECT * ?→

Posted in MariaDB, MySQL, SQL Language | 4 Replies

Identify useless queries in MariaDB/MySQL

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

Some queries always fail or never return rows. They should be eliminated to improve database performance. Continue reading Identify useless queries in MariaDB/MySQL→

Posted in MariaDB, MySQL | Leave a reply

NULL comparisons in MariaDB, PostgreSQL, and SQLite

Posted on 6 September 2021 by Federico Razzoli — No Comments ↓

Comparisons are tricky when NULL values are involved. But some databases offer some special, handy syntax to solve the problem. Continue reading NULL comparisons in MariaDB, PostgreSQL, and SQLite→

Posted in MariaDB, MySQL, Other Databases, PostgreSQL | Tagged null | Leave a reply

A summary of MariaDB 10.6

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

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→

Posted in MariaDB | Tagged mariadb-10.6 | Leave a reply

MariaDB Ignored Indexes

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

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→

Posted in MariaDB | Tagged index, mariadb-10.6 | Leave a reply

Finding Duplicate Indexes and Unused Indexes in MariaDB/MySQL

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

Having many indexes in our databases comes with a cost. It is good to periodically eliminate duplicate and unused indexes. Continue reading Finding Duplicate Indexes and Unused Indexes in MariaDB/MySQL→

Posted in MariaDB, MySQL | Tagged index | Leave a reply

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

  • Tuning PostgreSQL Auto-vacuum
  • How to fix git mistakes
  • MariaDB/MySQL: Working with MD5 or other hashes
  • How to test database backups
  • MariaDB: The regexp + LIKE optimisation

Categories

  • Amazon Redshift
  • Cassandra
  • Company updates
  • Database Automation
  • Databases
  • MariaDB
  • MariaDB Features
  • MariaDB InnoDB
  • MariaDB Storage Engines
  • MySQL
  • MySQL InnoDB
  • Other Databases
  • PostgreSQL
  • SQL Language
  • Stored Procedures
  • Strategy
  • Systems

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 © 2022 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
Cookie Policy

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