Planet MariaDB Server

This has performance results for Postgres 18 beta1 and several older Postgres releases using the sysbench benchmark and a small server. Results like this from me are usually boring because Postgreshas done a great job at avoiding performance regressions over time. This work was done by Small Datum LLC and not sponsored.tl;dr – from Postgres 17.5 to 18 beta1there might be small regressions (1% to 4%) in a few range query microbenchmarksthere might be a few small improvements (… Read more

At Percona, we constantly search for ways to make query processing more performant. Our activities include continuous monitoring of Percona Server for MySQL performance by doing performance regression tests. We also challenge Percona Server for MySQL with newly designed tests and analyze bottlenecks for possible improvements. Among our activities in this area is monitoring what […]… Read more

MariaDB is pleased to announce the immediate availability of MariaDB Community Server 11.4.7, and 10.11.13 maintenance releases. See the release […]… Read more

long_query_time and how everybody is using it wrong on MySQL and MariaDB The post long_query_time for Optimal Query Monitoring appeared first on Shattered Silicon…. Read more

Ubuntu 20.04 LTS (Focal Fossa) is scheduled to reach its official end of life on May 31, 2025. In alignment with the upstream vendor’s lifecycle, we are also ending platform support for Ubuntu 20.04 for all our MySQL related product offerings. This date and others are published in advance on our Percona Release Lifecycle Overview page. As part of our support policy, Percona will continue to provide advisory support for databases running on EOL platforms, but effective April 1, 2025, we have discontinued:… Read more

Do you want to explore the advanced capabilities of MariaDB MaxScale 25.01 without a subscription? We’re thrilled to introduce MaxScale Trial: a free, time-limited version that unlocks hands-on access to the full feature set of our powerful database proxy. This is your opportunity to experience cutting-edge functionalities like advanced query routing, seamless load balancing, flexible filtering… Source… Read more

Setting up an InnoDB Cluster requires three key components: Group Replication, MySQL Shell, and MySQL Router. In the previous post, we covered the process of building a 3-node InnoDB Cluster. In this post, we shift our focus to configuring MySQL Router and validating failover functionality. Environment overview We are using three InnoDB Cluster nodes along […]… Read more

In this blog post, we will describe typical usage scenarios for dictionary operations in the Data Masking Component, which is available in Percona Server for MySQL as an open source alternative to Oracle’s enterprise version. In particular, we will consider the following functions. gen_dictionary() – a function that returns a random term from a dictionary. gen_blocklist() – […]… Read more

We have long had a vision: that learning relational databases with MariaDB should be accessible to everyone — students, educators, and self-learners alike. Today, MariaDB Foundation and MariaDB plc together take a major step forward in realizing that vision. … Continue reading "Releasing MariaDB for Universities: Lecture Materials for a New Generation" The post Releasing MariaDB for Universities: Lecture Materials for a New Generation appeared first on MariaDB.org…. Read more

At Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open-source form, report back on any issues or bugs you might encounter along the way. We constantly update our bug reports and monitor other boards to ensure we have the latest information, but we wanted to make it a little easier for you to keep track of the most critical ones…. Read more

I previously shared benchmark results for RocksDB using the larger server that I have. In this post I share more results from two other large servers and one small server. This is arbitrary but I mean >= 20 cores for large, 10 to 19 cores for medium and less than 10 cores for small.tl;drThere are several big improvementsThere might be small regression in fillseq performance, I will revisit thisFor the block cache hyperclock does much better than LRU on CPU-bound testsI am curious about issue 13546 but not sure the builds I tested include itSoftwareI used RocksDB versions 6.29.5, 7.10.2,… Read more

We welcome Senticore Technologies as a Silver Sponsor. Senticore, a leader in engineering and manufacturing applications, focuses on cutting-edge AI solutions, particularly for the aerospace and defense sectors, and powers critical systems worldwide. … Continue reading "New Silver Sponsor: Senticore Technologies Chooses MariaDB for High-Performance Engineering and AI Applications" The post New Silver Sponsor: Senticore Technologies Chooses MariaDB for High-Performance Engineering and AI Applications appeared first on MariaDB.org…. Read more

ClusterControl v2.3.2 is here and is taking its first sincere step into the cloud native world with its Kubernetes operator management panelTech Preview and support for PostgreSQL’s cloudnative-pg and MySQL’s MOCO operators. It also comes with new major versions for PG and MySQL, as well as a new metrics watchlist mode for improved situational awareness! […] The post ClusterControl adds Kubernetes Database Operator management in v2.3.2 appeared first on Severalnines…. Read more

Every year new cohorts of programmers, DBAs, managers, and more learn MySQL. After MySQL and HeatWave Summit 2025 a few weeks ago, I realized what job needs to be done for these people and how I could help them make progress: revamping this website to focus on “the path”…. Read more

Context This is why you need to learn about common challenges when using MySQL: This chapter is a short but important laundry list of common MySQL challenges and how to mitigate them. These challenges don’t fit into other chapters because most are not directly related to performance. But don’t underestimate them: the first two challenges, for example, can ruin a database. More importantly, these challenges are not special cases that only happen when the stars align and The Fates conspire to ruin your day. These are common challenges. Take them seriously, and expect to face them. Excerpt from Efficient MySQL… Read more