Planet MariaDB Server

We’re excited to welcome RAVATAR as our Silver Sponsor! A bold innovator in artificial intelligence, RAVATAR is defining the emerging Face of AI through high-quality interactive digital humans and real-time AI avatars. … Continue reading "RAVATAR becomes Silver Sponsor of MariaDB Foundation" The post RAVATAR becomes Silver Sponsor of MariaDB Foundation appeared first on MariaDB.org…. Read more
By Anna Widenius
2025-05-02
After reading a blog post from JFG on changes to innodb_doublewrite_pages and bug 111353, I wanted to understand the impact from that on the Insert Benchmark using a large server.I test the impact from:using a larger (non-default) value for innodb_doublewrite_pagesdisabling the doublewrite buffertl;drUsing a larger value for innodb_doublewrite_pages improves QPS by up to 10%Disabling the InnoDB doublewrite buffer is great for performance, but bad for durability. I don't suggest you do this in production.Builds, configuration and hardwareI compiled upstream MySQL 8.0.41 from source.The server is an ax162-s from Hetzner with 48 cores, AMD 128G RAM and AMD SMT disabled. It uses Ubuntu… Read more
By Mark Callaghan
2025-05-02
Source: Small Datum
I suppose not all of my readers have a first hand (or even second hand) experience of the girls-night-in. So let me shed some light on this sacred ritual of tea, sympathy and soul-baring conversation that zigzags from the ridiculous to the profound and back again in under 30 seconds. … Continue reading "The Queen, the contributions and the wardrobe" The post The Queen, the contributions and the wardrobe appeared first on MariaDB.org…. Read more
By Anna Widenius
2025-05-01
I had the delight of being accepted to talk about “Making AI transparent with RAG on your own data” at foss-north 2025 in Gothenburg, Sweden. … Continue reading "MariaDB Vector and RAG at foss-north 2025" The post MariaDB Vector and RAG at foss-north 2025 appeared first on MariaDB.org…. Read more
By Robert Silén
2025-04-29
While doing benchmarks on 5.7 and 8.0, I came across a performance regression in MySQL 8.0 over 5.7 and opened a bug (Bug #111353 : 3x Performance Regression from 5.7 to 8.0 on ALTER TABLE FORCE).  There has been recent activity on this bug, showing an easy workaround.  This, even with being known since 16 Jul 2024, has not been talked about much, so this deserves a blog post…. Read more
By Jean-François Gagné
2025-04-28
We’re pleased to welcome Kinsta as a Silver Sponsor of the MariaDB Foundation. Kinsta, one of the leading managed WordPress hosting providers, powers thousands of websites globally with a platform built for speed, scalability, and security — … Continue reading "New Silver Sponsor: Kinsta Chooses MariaDB for Scalable, Open WordPress Hosting" The post New Silver Sponsor: Kinsta Chooses MariaDB for Scalable, Open WordPress Hosting appeared first on MariaDB.org…. Read more
By Anna Widenius
2025-04-28
MariaDB is pleased to announce the immediate availability of the MariaDB Connector/Node.js 3.4.2 GA release. Release Notes MariaDB Connector/Node.js MariaDB […]… Read more
By Daniel Bartholomew
2025-04-25
This is a guest post by Libing Song from Alibaba Cloud. This blog post introduces a new feature which speeds […]… Read more
By MariaDB
2025-04-25
This is a guest post by Libing Song from Alibaba Cloud. If the transaction takes 30 minutes to execute, it […]… Read more
By MariaDB
2025-04-25
Kubernetes has become the standard for container orchestration, offering scalability and resilience. However, managing stateful applications like databases on Kubernetes can be complex. The MariaDB Enterprise Kubernetes Operator provides a streamlined and automated solution for deploying and operating MariaDB Enterprise Platform within your Kubernetes clusters. Source… Read more
By Tina Yang
2025-04-23
When using the Percona Operator for MySQL based on Percona XtraDB Cluster (PXC), it’s common to encounter scenarios where cluster nodes request a full State Snapshot Transfer (SST) when rejoining the cluster. One typical scenario where a State Snapshot Transfer (SST) is required is when a node has been offline long enough that the GCache […]… Read more
By Juan Arruti
2025-04-21
Source: Percona
button#focus {display:none; visibility:hidden;} nav#toc {display: none;} Conference Video Slides MySQL Performance for Application Developers @ MySQL and HeatWave Summit 2025† mysql-summit-2025.pdf MySQL Performance for Developers @ Percona Live 2023† PL23.pdf Efficient MySQL Performance @ Percona Live 2022 PL22.pdf Efficient MySQL Performance @ FOSDEM 2022 – † Video recording not available… Read more
2025-04-21
Source: Hack MySQL
This post addresses some of the feedback I received from my previous post on the impact of the malloc library when using RocksDB and MyRocks. Here I test:MALLOC_ARENA_MAX with glibc mallocsee here for more background on MALLOC_ARENA_MAX. By default glibc can use too many arenas for some workloads (8 X number_of_CPU_cores) so I tested it with 1, 8, 48 and 96 arenas.compiling RocksDB and MyRocks with jemalloc specific code enabledIn my previous results I just set malloc-lib in my.cnf which uses LD_LIBRARY_PATH to link with your favorite malloc library implementation.tl;dr: jemallocFor mysqld with jemalloc enabled via malloc-lib (LD_LIBRARY_PATH) versus mysqld… Read more
By Mark Callaghan
2025-04-19
Source: Small Datum
MySQL has been evolving rapidly, and with the recent release of MySQL 8.4, there’s a lot to unpack. While MySQL 8.4 is officially dubbed a Long-Term Support (LTS) release, many features introduced between 8.0 and 8.4 have now matured into defaults or become deprecated/removed. This blog provides a comprehensive, side-by-side comparison of the key differences […]… Read more
By Arunjith Aravindan
2025-04-17
Source: Percona
There’s a question I like to ask people sometimes—especially at turning points: “What’s your word?” One word to capture how you feel, where you are, or what’s driving you right now. … Continue reading "The Queen’s Gambit: Through the Looking Glass into the Query Optimizer" The post The Queen’s Gambit: Through the Looking Glass into the Query Optimizer appeared first on MariaDB.org…. Read more
By Anna Widenius
2025-04-17