Planet MariaDB Server

Easy question, easier answer. Docker Official Images are the official image distributor of MariaDB Server. It was years ago that the Docker Official Image of MariaDB Server gained all its environment variables in MARIADB_* form and its fork on the MariaDB Corporation Docker Hub was deprecated and eventually removed. … Continue reading "Where is the official MariaDB Container Image?" The post Where is the official MariaDB Container Image? appeared first on MariaDB.org…. Read more

I previously shared results for MyRocks 5.6 and claimed there was a perf regression in the Insert Benchmark. I then shared a follow up post as I searched for the source of the regression. The results were bogus, there is no regression and this post explains what happened.The mistake I made is that all builds used FDO (feedback driven optimization) and while the builds tested span ~18 months (from early 2022 until mid 2023) they were all using the same profile input for FDO. While I don't know much about FDO I assume that is a bad idea. So I recompiled everything… Read more

This blog post discusses the limitations of the MySQL Clone plugin.The MySQL clone plugin significantly simplifies the process of replica provisioning. All you need to do is: Ensure that the source server has binary logs enabled Grant appropriate permissions Execute the [crayon-6512e589e4980208296281-i/]  command on the recipient This works extremely easily when you provision a new […]… Read more

As MySQL database administrators, we are well aware of the significance of implementing a primary key within a table. Throughout our careers, most of us have encountered situations where the absence of a primary key has led to operational challenges. Primary keys play an indispensable role in sound database design by uniquely identifying individual rows […]… Read more

This has results for Sysbench, a small server and Postgres 11, 12, 13, 14, 15 and 16. The goal is to see if there are perf regressions over time. This is a common problem as code gets added over time the cumulative impact is using more CPU to do the same amount of work. MySQL is an example where there are significant regressions over time.Context – the workload here is a cached database with 1 client. I am searching for CPU regressions. I will repeat this on a medium server with more concurrency (8 clients).tl;drPostgres avoids perf regressions over time…. Read more

Peak RSS for jemalloc 5.2.1 has much variance with the Insert Benchmark with MyRocks. The variance is a function of how you build and configure jemalloc. The worst case (largest peak RSS) is jemalloc 5.2.1 provided by Ubuntu 22.04 and I have yet to figure out how to reproduce that result using jemalloc 5.2.1 compiled from source.I previously shared results to show that jemalloc and tcmalloc are better than glibc malloc for RocksDB. That was followed by a post that shows the peak RSS with different jemalloc versions. This post has additional results for jemalloc 5.2.1 using different jemalloc config options. tl;drPeak… Read more

ProxySQL is a high-performance SQL proxy, which runs as a daemon watched by a monitoring process. The process monitors the daemon and restarts it in case of a crash to minimize downtime.The daemon accepts incoming traffic from MySQL clients and forwards it to backend MySQL servers.The proxy is designed to run continuously without needing to […]… Read more

SSL (let’s call it that, even though SSL 2.0 and SSL 3.0 were long replaced by TLS 1.0–1.3 protocols) support was implemented in MySQL in 2001, so MariaDB (born in 2009) always had it. … Continue reading "Mission Impossible: Zero-Configuration SSL" The post Mission Impossible: Zero-Configuration SSL appeared first on MariaDB.org…. Read more

Unlocking MariaDB Query Performance: EXPLAIN and Slow Query Log Introduction Understanding how queries are executed by a database system is paramount for database administrators and developers seeking to optimize performance. In the realm of MariaDB, […] The post Mastering MariaDB Query Optimization: EXPLAIN in the Slow Query Log appeared first on The WebScale Database Infrastructure Operations Experts…. Read more

VAR_POP: Population Variance In MySQL 8: MySQL 8 introduced the VAR_POP() function to calculate population variance. Step 1: Create a Table and Insert Financial Data Assuming you have a table named daily_returns for stock return data: CREATE TABLE […] The post Calculating Population Variance in Financial Data using MySQL 8: A Practical Guide appeared first on The WebScale Database Infrastructure Operations Experts…. Read more

Using Recursive Self-Joins with Common Table Expressions (CTEs) in InnoDB Steps to implement a SELF JOIN with Recursive CTE in InnoDB: CREATE TABLE categories (id INT PRIMARY KEY,name VARCHAR(255),parent_id INT); 2. Insert Sample Data: Insert some […] The post Hierarchical Data Retrieval in InnoDB: Implementing Recursive Self-Joins with CTEs appeared first on The WebScale Database Infrastructure Operations Experts…. Read more

This has results for Postgres 16.0 vs sysbench on a medium server and the news continues to be good. I previously shared results for this on a small server.tl;drPostgres 16.0 is faster than 15.2The improvement for reads is larger than for writesBuildsI compiled Postgres 15.2, 15.3, 15.4, 16 beta1, 16 beta2, 16 beta3, 16 rc1 and 16.0 from source. The builds are named o3_native_lto which is shorthand for using: -O3 -march=native -mtune=native -flto.BenchmarkI used sysbench and my usage is explained here. Postgres was configured to cache all tables.This benchmark used a c2-standard-30 server from GCP with 15 cores, hyperthreads disabled, 120G of RAM,… Read more

I recently shared results for Postgres 16rc1 vs sysbench on a small server. Now I have results for Postgres 16.0 and the news continues to be good.tl;drinsert QPS might have dropped by ~5%, otherwise there are no regressions for writesfor everything else QPS in Postgres 16.0 is within ~2% of 15.2, which is a great resultBuildsI compiled Postgres 15.2, 15.3, 15.4, 16 beta1, 16 beta2, 16 beta3, 16 rc1 and 16.0 from source. The builds are named o3_native_lto which is shorthand for using: -O3 -march=native -mtune=native -flto.BenchmarkI used sysbench and my usage is explained here. Postgres was configured to cache all tables.This benchmark… Read more

Percona is dedicated to open source software. But recently, open source software has come under attack. Once open source software is being locked away by changing licenses and code that you depended on. You either get to pay for the privilege of having less freedom or find yourself sequestered with rapidly aging software.Before open source […]… Read more

Codership, the developers of Galera Cluster and Galera Manager, have new dates for the online DBA for Galera Cluster Training. There are two sets of times for our EMEA and American attendees, with the former happening on October 9th  and 10th, starting 10 AM CET and the latter happening on October 11th and 12th, starting 9 AM EST.​​​​​ This is […]… Read more