Tag: MariaDB
-
Passbolt renews its support for MariaDB Foundation
MariaDB Foundation is pleased to announce that Passbolt has renewed its Silver sponsorship for another year, continuing its long-term support for the MariaDB open-source ecosystem.
Passbolt is an open-source password manager designed for teams, with a strong focus on security, privacy, and user control. Its continued support reflects a shared commitment to building practical, trustworthy open-source infrastructure that organizations can deploy and operate with confidence.
Building on the Privacy-First Stack
During the first year of collaboration, Passbolt became part of […]
-
Simple tool to build MariaDB commits for performance-change analysis
Tracking down changes in database performance is one of the hardest parts of engineering, especially when the change is buried somewhere in a long commit history.
To make this work easier and more repeatable, I put together a small but important tool:
MariaDBCommitBuilder.sh
This script does one thing well:
Given a commit hash, it checks out that commit, builds it cleanly, and packages it in a deterministic way so the Test Automation Framework (TAF) can run consistent performance tests.
Why […]
-
DuckDB Storage Engine for MariaDB. When the Sea Lion Learns to Quack.
An early look at the DuckDB storage engine for MariaDB — columnar, vectorized analytics that live right next to your transactional tables.
The problem
MariaDB’s InnoDB is excellent at what it was built for: transactions. Row-by-row inserts, updates, point lookups, strong consistency. But the moment you ask it to scan tens of millions of rows for a multi-way join with a few aggregations, a row store has to work hard.
The usual answer is to stand up a separate analytical […]
-
The Power Of The Community!
A proper comparison of the distinct committers to MariaDB and MySQL repositories since Q1 2025.
-
MariaDB Foundation: Bringing TPC-B Back To Life
Pervasive PSQL
TPC-B
Pervasive PSQL
TPC-C
https://en.wikipedia.org/wiki/Pervasive_Software
During that time, about seventy percent of all regressions came from TPC-B, with the remaining issues coming from ATOMICs and TPC-C. TPC-B was simple, direct, and very sensitive to performance changes. It caught issues that other workloads did not.
Moving to MySQL AB, and working on the MySQL NDB Cluster and MySQL Global Replication teams, I created a TPC-B style test that could be used inside mysql-test.
That version is still visible today:
-
Documented: The MariaDB Server (Community) Contribution Process
If you ever considered contributing code to the MariaDB server, you should know that this is an intricate process involving multiple steps and multiple actors. To help you see your contributions successfully merged into the MariaDB Server codebase I’ve compiled a comprehensive description of the contribution process itself, the roles involved into it, the sequence of actions and conditions for transition from one to another. There’s even a diagram!
Please go to COMMUNITY_CONTRIBUTIONS.md.
This of course is going to be […]
-
MariaDB Vector: How it works. Part III
In the previous parts of this series we’ve seen how MariaDB stores vector indexes in a table and how to implement HNSW for a good performance. But MariaDB is not implementing HNSW, it calls its vector search algorithm mHNWS, a modified HNSW. Let’s see how exactly it was modified.
MathJax = { output: { linebreaks: { inline: false } } }
Not so greedy!
HWNS, like many, if not most, graph based vector search algorithms is greedy. Think of it […]
-
MariaDB Vector: How it works. Part II
In the first post of this series, I’ve described how the vector index is stored in a table and how it achieves full transactional behavior and ACID properties compatible with the storage engine of the table the user created. But while the table provides persistent storage of the index, it’s in-memory part that gives it the performance. This is how it works.
Distance calculations
This is the most performance sensitive part of the HNSW. According to various estimates, distance calculations […]