Planet MariaDB Server
Fifteen years ago, Internet Explorer made up about two-thirds of all browsers, Firefox the majority of the rest, while a newly-released browser called Chrome was starting to appear in the rankings. … Continue reading "MariaDB Server turns fifteen!" The post MariaDB Server turns fifteen! appeared first on MariaDB.org….
Read more
2024-10-29
Source:
MariaDB Foundation
October 29, 2009 was a special day in the database community—it saw the first release of MariaDB Server. Started as … Continued…
Read more
2024-10-29
Source:
MariaDB Corporation
In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables. I already wrote a post about my work (Faster MySQL Startup with Many Tables). In that post, I link to a bug report (Bug #115988 : Too Much Disk Read on Startup, penalizing deployments with many tables). In that bug report, I write, without much details, that the…
Read more
2024-10-28
Source:
J-F Gagné’s MySQL Blog
Inspired by this comment in the Hacker News discussion, I posted polls on my LinkedIn network about the tendency (or perception of tendency) to abandon features without deprecating them in some of the most popular open source databases – MySQL, MariaDB, and PostgreSQL. First, let’s look at why “Abandoning” features rather than formally depreciating them […]…
Read more
2024-10-28
Source:
Percona
Galera : understanding Flow ControlAs explained in a previous article Galera cluster from Codership is a robust synchronous multi-master replication technology integrated directly into MariaDB Server. This powerful feature enables high availability and data consistency across multiple database nodes without the need for additional software. This tight integration helps MariaDB users can leverage this advanced clustering features without complex setup procedures, making it an attractive option for organizations seeking robust database solutions.Galera Cluster employs a sophisticated replication mechanism that combines synchronous global ordering with asynchronous application of changes across nodes. This approach ensures consistency while allowing for efficient processing. However, to maintain…
Read more
2024-10-28
Source:
The consistent voice
Today, we are excited to announce a new fund to help give MariaDB Vector a high-quality integration into as many LLM frameworks as possible. … Continue reading "Announcing the MariaDB Vector Bounty Program!" The post Announcing the MariaDB Vector Bounty Program! appeared first on MariaDB.org….
Read more
2024-10-25
Source:
MariaDB Foundation
MariaDB is pleased to announce the immediate availability of MariaDB Connector/Java 3.5.0, Connector/R2DBC 1.3.0, and Connector/Node.js 3.4.0. Download Now … Continued…
Read more
2024-10-25
Source:
MariaDB Corporation
I shared benchmark results for RocksDB a few weeks ago and there was a suggestion for me to repeat tests using different (older) values for format_version. Then while replacing a failed SSD, I also updated the OS and changed a few kernel-related config options. Thus, I ended up repeating all tests.This post has results from a small server with leveled compaction. Results from a large server and from universal compaction are in progress.tl;dr – on a small server with a low concurrency workloadolder values of format_version (2 thru 5) don't impact QPSauto hyperclock cache makes read-heavy tests up to 15%…
Read more
2024-10-24
Source:
Small Datum
The performance of MariaDB Server has been improved over the years thanks to many enhancements to the InnoDB storage engine … Continued…
Read more
2024-10-24
Source:
MariaDB Corporation
This blog post attempts to explain some of the performance regressions that landed in InnoDB with MySQL 8.0.30. I'd rather not try to debug perf regressions long after they arrived but here we are. I assume that most of the problems landing in MySQL 8.0.28+ are also in 8.4 and 9.X, so these are problems the community will be dealing with for a long time.One blog post that documents the regressions is here. The regression that I am trying to explain occurs on the dell32 server (see below) where the throughput for the update-index microbenchmark drops in half after MySQL…
Read more
2024-10-23
Source:
Small Datum
Introduction Tungsten Clustering allows for many types of maintenance to happen with no downtime at all. This blog post will explore how to upgrade the actual MySQL Server on all cluster nodes with zero downtime. These same steps may be used to upgrade the MySQL server or patch the OS. Zero-Downtime Upgrade Steps This is a zero-downtime upgrade: Pick a replica node and shun it, and take all replication offline cctrl > datasource NODENAME shun tungsten@shell > trepctl -all-services offline Upgrade the MySQL Server on that node Bring up replication and verify health tungsten@shell > trepctl -all-services online tungsten@shell >…
Read more
2024-10-22
Source:
Continuent Tungsten
This post has results for the impact of PGO, LTO and other compiler options for MySQL using the Insert Benchmark. I previously shared results like this for sysbench. The PGO builds here were created from profiles captured during sysbench and I am curious to understand whether the benefit from those builds extends to other workloads. tl;drPGO builds created using sysbench also help other workloads like the Insert Benchmarkresults here are similar to results from sysbenchgcc does slightly better than clang without LTO or PGOclang does slightly better than gcc with PGOclang does more than slightly better than gcc with PGO +…
Read more
2024-10-22
Source:
Small Datum
Performance regressions arrived in InnoDB with MySQL 8.0.30. Eventually multiple bugs were filed. The worst regressions were from changes to the hash function (perhaps fixed in 8.0.36) and from changes to how functions are inlined for InnoDB (bug 111538). The problems are obvious if you run CPU-bound workloads, and my CPU-bound workload is sysbench with a cached database.Bug 111538 is now closed and marked as fixed in 8.0.40. Alas, there are still significant CPU perf regressions in 8.0.40 relative to 8.0.28. My advice to upstream is to stop innovating if you don't have the CI setup to catch the new…
Read more
2024-10-21
Source:
Small Datum
MySQL 8.0 and newer change and improve how we measure and monitor replication lag. Even though multi-threaded replication (MTR) has been on by default for the last three years (since v8.0.27 released October 2021), the industry has been steeped in single-threaded replication for nearly 30 years. As a result, replication lag with MTR is a complicated topic because it depends on version, configuration, and more. This three-part series provides a detailed understanding, starting from what was originally an unrelated feature but is now the basis: binary log group commit….
Read more
2024-10-21
Source:
Hack MySQL
This has results for MySQL 8.0.28 vs sysbench on a laptop-class CPU (AMD 4700u) to understand the impact of various compile-time optimizations including LTO and PGO. I will have results from a server-class CPU next weeok. I previously published results on this but then retracted some of them as they appeared bogus.tl;drclang and gcc have similar performance with a few exceptionsclang does ~7% better than gcc with PGOclang does ~25% better than gcc with PGO+LTOoddly, gcc with PGO is ~3% faster than gcc with PGO+LTOLTO makes things ~6% fasterPGO or PGO+LTO makes things between 1.4X and 1.8X fastergcc and clang…
Read more
2024-10-17
Source:
Small Datum