Planet MariaDB Server

This post has results for vector index support in MariaDB and Postgres. I am new to vector indexes so I will start small and over time add more results.  This work was done by Small Datum LLC and sponsored by the MariaDB Corporation.I compare MariaDB with pgvector because I respect the work that the Postgres community has done to support vector search workloads. And I am happy to report that MariaDB has also done a great job on this. While I don't know the full story of the development effort, this feature came from the MariaDB Foundation and the community… Read more

This is part 4 in my (possibly) final series on performance regressions in MySQL using cached sysbench as the workload. For previous posts, see part 1, part 2 and part 3. This post covers performance differences between InnoDB in upstream MySQL 8.0.32, InnoDB in FB MySQL 8.0.32 and MyRocks in FB MySQL 8.0.32 using a server with 32 cores and 128G of RAM.I don't claim that the MyRocks CPU overhead isn't relevant, but this workload (CPU-bound, database is cached) is a worst-case for it.tl;dr InnoDB from FB MySQL is no worse than ~10% slower than InnoDB from upstreamFixing bug 1506 is important for InnoDB in FB MySQLMyRocks… Read more

This is part 3 in my (possibly) final series on performance regressions in MySQL using cached sysbench as the workload. For previous posts, see part 1 and part 2. This post covers performance differences between InnoDB in upstream MySQL 8.0.32, InnoDB in FB MySQL 8.0.32 and MyRocks in FB MySQL 8.0.32 using a server with 24 cores and 64G of RAM.I don't claim that the MyRocks CPU overhead isn't relevant, but this workload (CPU-bound, database is cached) is a worst-case for it.tl;dr InnoDB from FB MySQL is no worse than ~10% slower than InnoDB from upstreamMyRocks is ~35% slower than InnoDB from… Read more

This is part 2 in my (possibly) final series on performance regressions in MySQL using cached sysbench as the workload. Part 1 of this series is here. Part 1 documents performance regressions from MySQL 5.6 to 8.0. This post and the ones that follow cover performance differences between InnoDB in upstream MySQL 8.0.32, InnoDB in FB MySQL 8.0.32 and MyRocks in FB MySQL 8.0.32.tl;drInnoDB in FB MySQL 8.0.32 is about 10% slower than InnoDB from upstream 8.0.32, once a few perf bugs get fixedMyRocks in FB MySQL 8.0.32 uses more CPU than InnoDB, thus QPS for CPU-bound workloads is lower… Read more

I spent much time in 2024 documenting performance regressions from old to new versions of MySQL with InnoDB and MyRocks. More posts will be published in 2025, including this sequence of posts, but my work on that is winding down. Most of the problems are from many small regressions rather than a few big ones and it is very expensive to find and fix regressions long after they arrive.Hopefully someone else will emerge to do work like this for MySQL going forward or upstream finds more resources to prevent new small regressions from arriving. The trend over the past decade… Read more

If you’re considering migrating from Oracle to MariaDB, you need to know the sql_mode configuration property in MariaDB as well … Continued… Read more

Here is part two of my MySQL with Diagrams series (Here’s part one – MySQL with Diagrams Part One: Replication Architecture). We are going to explore how MySQL handles thread termination using the KILL command, as visualized in the provided diagram, and provide sample demonstrations to help you better understand. Many people think they know […]… Read more

At Percona, we’ve always prioritized performance, and recent trends in MySQL’s development have been a point of concern for us. In particular, the performance deterioration in the MySQL 8.4.x and 9.y versions caught our attention, as highlighted in Marco Tusa’s insightful blog post, Sakila, Where Are You Going? We’re pleased to report that the latest […]… Read more

Percona Toolkit 3.7.0 has been released on Dec 23, 2024. The main feature of this release is MySQL 8.4 support. In this blog, I will explain what has been changed. A full list of improvements and bug fixes can be found in the release notes. TLDR; Replication statements in 8.4 are fully supported by the Percona Toolkit pt-slave-delay has been deprecated. pt-slave-find has been renamed to pt-replica-find. The old name has been deprecated but exists in the repository as an alias of the pt-replica-find…. Read more

In this post, we focus on working with the features of mysql_fdw PostgreSQL extension on Amazon RDS for PostgreSQL to help manage a large set of data that on an external database scenarios. It enables you to interact with your MySQL database for importing individual/large/selectively number of objects at the schema level and simplifying how we get information about the MySQL/MariaDB schema, to make it easier to ultimately read/write data. We will also provide an introduction to understand query performance on foreign tables…. Read more

New Year’s Eve is when everyone takes stock of the year that has passed. At MariaDB Foundation, we’re no different. The technical highlight: MariaDB Vector It’s not hard to pick the technical MariaDB highlight of the year: It’s MariaDB Vector. … Continue reading "MariaDB highlights in 2024: Vectors, K1, and contributions" The post MariaDB highlights in 2024: Vectors, K1, and contributions appeared first on MariaDB.org…. Read more

As Chief Development Officer of the MariaDB Foundation, I’ve worked to ensure that our development efforts focus where they matter most. On this final day of 2024, I want to reflect on the significant technical achievements we’ve accomplished and the collaborative processes that made them possible. … Continue reading "What we’ve developed in 2024" The post What we’ve developed in 2024 appeared first on MariaDB.org…. Read more

We’re no mind readers, so from time to time, we like to do polls. Polls are quantitative in nature, so coming up with the right question is not enough – … Continue reading "What do you expect from vector storage in databases?" The post What do you expect from vector storage in databases? appeared first on MariaDB.org…. Read more

Good news: IBM is upgrading their Gold sponsorship to Platinum! Our trinity: Adoption, Openness, Continuity The three pillars of MariaDB Foundation are Adoption, Openness, and Continuity. … Continue reading "IBM upgrading Gold to Platinum" The post IBM upgrading Gold to Platinum appeared first on MariaDB.org…. Read more

I am happy to read about storage engines that claim to be faster than RocksDB. Sometimes the claims are true and might lead to ideas for making RocksDB better. I am wary about evaluating such claims because that takes a lot of time and when the claim is bogus I am reluctant to blog about that because I don't want to punch down on a startup.Here I share results from the RocksDB benchmark scripts to compare Speedb and RocksDB and I am happy to claim that Speedb does some things better than RocksDB.tl;drRocksDB and Speedb have similar average throughput for… Read more