Planet MariaDB Server

Hello friends, on certain occasions, some clients, for whatever reason, ask us to migrate a supposedly “equivalent” brand of an engine in terms of belonging to the MySQL family or ecosystem.In this case, we will be analyzing the migration of MariaDB to Percona Server for MySQL 8 in particular. A comment worth clarifying is that, […]… Read more

A previous post shared results from the insert benchmark for Postgres 15.3 with a variety of configurations. This has results for even more configurations to understand the impact of several tuning variables. The goal is to understand which config options improve average throughput and/or reduce throughput variance. The focus in on the l.i1 benchmark step (inserts with secondary index maintenance) as that is the largest source of stress for MVCC GC.tl;dr (for this workload):the base config I have been using is pretty good once I tuned autovacuum to be more agressiveadding wal_compression=lz4 helps a lottuning autovac scale factor might helpIncreasing… Read more

In the SQL standard delimiters are for separating tokens; in MySQL/MariaDB they’re for ending statements, particularly compound statements as in CREATE PROCEDURE p() BEGIN VALUES (5); END; The problem is that a dumb client could stop at the first semicolon “;” in the statement (the one after VALUES (5)) instead of the one that truly… Continue Reading Delimiters in MySQL and MariaDB… Read more

The MariaDB Foundation values our partnerships with our sponsors. Our partnership with IONOS allows us to get insight into how MariaDB Server is used and the direction it should take. … Continue reading "MariaDB & IONOS: Improving performance for hosting" The post MariaDB & IONOS: Improving performance for hosting appeared first on MariaDB.org…. Read more

Melissa Logan, managing director of Data on Kubernetes (DoK), led one of the best panels I’ve been to at a conference at Kubecon EU in Amsterdam about challenges with and the state of the art of running databases on Kubernetes. This panel united the Data on Kubernetes Community Operator SIG and Kubernetes Storage SIG to discuss key features of Kubernetes database operators. Xing Yang from VMware, Sergey Pronin from Percona, and Álvaro Hernández from OnGres came together to discuss what works, what doesn’t, and where the industry is going…. Read more

This has results for an in-memory, low-concurrency insert benchmark on a small server. The previous report is here. This used the –delete_per_insert option so that the write-heavy steps ran for a long time while the working set remained in memory.tl;dr5.6.35 has better perf than 8.0.28 courtesy of new CPU overheads in upstream MySQL 8Variance is visible, but not horrible.BenchmarksThe small server is a Beelink SER 4700u with 8 AMD cores, 16G RAM and NVMe SSD and low-concurrency was 1 and 4 clients. An overview of the insert benchmark is here, here and here. The insert benchmark was run for a cached database with both 1 and 4 clients…. Read more

The insert benchmark can now be called the insert+delete benchmark.While I continue to work on the replacement for the insert benchmark (see insert benchmark v3) progress on that is slow. I recently enhanced the insert benchmark to let me run the write-heavy insert benchmark steps while keeping the working set in-memory and this allows me to run the write-heavy steps for much longer than a few minutes and search for problems in MVCC GC implementations.This is done via the –delete_per_insert option that works as advertised — a delete is done per insert to avoid growing the number of rows in… Read more

MariaDB Foundation’s CEO Kaj Arnö chatted to MariaDB CRO (as well as chairman of the CloudFest advisory board) Soeren von Varchmin about the the successful CloudFest 2023, which took place in Germany, from 21 to 23 March. … Continue reading "CloudFest 2023 review" The post CloudFest 2023 review appeared first on MariaDB.org…. Read more

Why does Intel sponsor the MariaDB Foundation? I had the opportunity to interview Steve Shaw, Principal Engineer at Intel and a Board Member at MariaDB Foundation. … Continue reading "The value of sponsoring MariaDB Foundation" The post The value of sponsoring MariaDB Foundation appeared first on MariaDB.org…. Read more

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in.Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights, critical […]… Read more

In MySQL, operators in a query execution plan can be classified as streaming or blocking based on how they process and propagate rows during query execution. Let’s explore the differences between streaming and blocking operators […] The post Streaming versus blocking operators in MySQL appeared first on The WebScale Database Infrastructure Operations Experts…. Read more

Troubleshooting redo performance in InnoDB involves identifying and addressing potential bottlenecks or issues that affect the efficiency of redo log processing. The redo log plays a critical role in ensuring data durability and crash recovery […] The post Tips and Tricks – Troubleshooting Redo Performance in InnoDB. appeared first on The WebScale Database Infrastructure Operations Experts…. Read more

Scalar subquery unnesting is a transformation technique used by the MySQL optimizer to optimize queries that involve scalar subqueries. Scalar subqueries are subqueries that return a single value, typically used in expressions or as part […] The post MySQL Scalar Subquery Unnesting transformation appeared first on The WebScale Database Infrastructure Operations Experts…. Read more

This sounds like a lame cross-genre joke, but it is not. It is a lame cross-genre math problem. I have to admit, it didn’t have those names when I read about it, but I wanted to make it a bit more epic. … Continue reading "Sauron says to Dumbledore and Merlin…" The post Sauron says to Dumbledore and Merlin… appeared first on MariaDB.org…. Read more

In this blog we will show how to access MySQL and MariaDB DBMS tables from MariaDB Server. For that we will use Connect Storage Engine (SE), which supports different table types options. … Continue reading "Connect SE JDBC table type: Accessing Tables From Another DBMS" The post Connect SE JDBC table type: Accessing Tables From Another DBMS appeared first on MariaDB.org…. Read more