Planet MariaDB Server

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

We are happy to release the schedule (https://mariadb.org/fest2023-schedule/) of our upcoming meeting week Tue-Thu 3-5 October 2023. The week comes with meetings in four flavours: During the week, we plan to work on the MariaDB Server roadmap together with ecosystem members who drive it. … Continue reading "MariaDB Un(Conference) and ServerFest Schedule 3-5 Oct 2023" The post MariaDB Un(Conference) and ServerFest Schedule 3-5 Oct 2023 appeared first on MariaDB.org…. Read more

You can show your support for open source software by participating in an event next March in Pasadena, California – The Southern California Linux Expo, or SCaLE. SCaLE is the largest community-run open source and free software conference in North America. Percona has sponsored this show for many years, provided presenters, and participated in the […]… Read more

The MariaDB Foundation is pleased to announce the availability of MariaDB 11.3.0, a preview release in the MariaDB 11.3 series. MariaDB 11.3 is a short-term release and will be maintained for one year after its G.A (stable) release. … Continue reading "MariaDB 11.3.0 preview release available" The post MariaDB 11.3.0 preview release available appeared first on MariaDB.org…. Read more

As a MySQL database administrator, you’re likely familiar with the SHOW REPLICA STATUS command. It is an important command for monitoring the replication status on your MySQL replicas. However, its output can be overwhelming for beginners, especially regarding the binary log coordinates. I have seen confusion amongst new DBAs on which binary log file and […]… Read more