Planet MariaDB Server

Historically, Percona has been providing our customers with enterprise-grade solutions for MySQL that meet the highest standards of compatibility and compliance. To follow this commitment, Percona now offers RHEL9-certified builds for the users of Percona software for MySQL. These builds have been rigorously tested and are available as rpm packages, ensuring seamless integration with your […]… Read more

This has benchmark results for MySQL and Postgres vs the Insert Benchmark on a large server. My intent is to document how performance changes over time more so than start a Postgres vs MySQL argument.MySQL has accumulated large regressions from 5.6 to 8.0 that are obvious on low-concurrency benchmarks. While they are less obvious on high-concurrency benchmarks, and there have been significant improvements to make MySQL 8 better at high-concurrency, the regressions that hurt low-concurrency results also reduce throughput at high-concurrency.tl;drFor Postgres 17rc1 vs 15.8Performance is mostly the sameFor MySQL 8.0.39 vs 5.6.51Writes are much faster in 8.0.39Reads throughput is… Read more

The release of Percona Server for MySQL 8.4.0 includes the new UUID_VX component, which implements UUID versions 1, 3, 4, 5, 6, and 7 according to recently published RFC 9562. UUIDs (Universally Unique Identifiers) are unique identifiers that can be generated independently without a central authority or coordination with other parties. Unlike sequential integer identifiers, which […]… Read more

For a few years I have only used sysbench and the Insert Benchmark for work but now I need an HTAP benchmark. There are several to choose from but I will start with HATrick. The source is here. It uses C++ and ODBC. I prefer Java (and JDBC), golang or Python but lets see how this goes.My current OS is Ubuntu 22.04 and I install MySQL in custom locations so I assume that I need to install MySQL's Connector/ODBC from source. That depends on an ODBC driver manager, and for Ubuntu I will try iodbc. I have no experience with… Read more

This has benchmark results for MySQL 5.6.51, 5.7.44 and 8.0.39 using sysbench on a large server. I also add a few results comparing Postgres 17rc1 with MySQL 8.0.39. My goal with that is to highlight things that can be made better in MySQL (and in Postgres).One of the responses to my claims that MySQL is getting too many performance regressions over time is that this is true for low-concurrency tests but not for high-concurrency tests. Alas, that claim is more truthy than true and fixing some of these regressions would help make modern MySQL not look so slow when compared… Read more

In this post I have more results on the impact of compile-time options for MySQL, InnoDB and sysbench. I previously wrote about the impact of PGO and LTO on MySQL performance.tl;drThere is no silver bullet to undo the performance regressionsYou can improve QPS by 10% to 20% with -O3, LTO and disabling most of the perf schema at compile time but I am reluctant to suggest running in production without the perf schemaYou can improve QPS by 5% to 10% with -O3 and LTOCompiling with -Os is bad for performanceBuildsI used InnoDB from MySQL 8.0.39. The compiler was gcc 11.4.0.The… Read more

Percona Monitoring and Management 2.43.0 Tech Preview Release Hello everyone! Percona Monitoring and Management (PMM) 2.43.0 is now available as a Tech Preview Release. We encourage you to try this PMM preview release in testing environments only, as these packages and images are not fully production-ready. The final version is expected to be released through the standard channels in the coming week. To see the full list of changes, check out the PMM 2…. Read more

I recently helped two of our sponsors simultaneously, DBS Bank and MariaDB Plc, with a recent issue they were experiencing. This actually helped us add support for an extra cloud vendor. … Continue reading "MariaDB Foundation assisting multiple vendors" The post MariaDB Foundation assisting multiple vendors appeared first on MariaDB.org…. Read more

This long article aims to provide you with the instructions and tools to migrate your production database from your current environment to a solution based on Percona Everest (MySQL). Nice. You decided to test Percona Everest and found that it is the tool you were looking for to manage your private DBaaS. The easiest part […]… Read more

Let’s see how to install MariaDB ColumnStore (single node) on Ubuntu. Let’s also prepare the system to run ColumnStore with good performance, as we should always do in production. The following steps should work on any modern Ubuntu version up to and including 24.04 LTS. Installing and configuring MariaDB and ColumnStore First, let’s configure the server parameters: Also, change the system characterset to the only one that is supported by MariaDB ColumnStore: apparmor can be disabled: Let’s install che dependencies. The following commands are suitable for any Ubuntu system, including minimal systems (e.g., containers). Install MariaDB signature and the official… Read more

This has benchmark results for Postgres 15.8, 16.4 and 17 (beta3, rc1) using sysbench with large and small servers. A recent result for Postgres 17 beta3 from a large server is here. The server in this case is an ax162-s from Hetzner.This work was done by Small Datum LLC.tl;dr17rc1 looks great – there are no big regressions and several big improvementsThere might be small regressions (~2%) from Postgres 15 and 16 to 17 but this benchmark was not setup to diagnose that.Builds, configuration and hardwareI compiled Postgres versions 15.8, 16.4, 17beta3 and 17rc1 from source using -O2 -fno-omit-frame-pointer.The servers are:smallThe server is named v5 or Beelink… Read more

New maintenance releases for MariaDB Enterprise Server 10.6.19-15 and 10.5.26-20 are now available. These releases include new backported features. Download … Continued… Read more

This has results from the db_bench benchmarks for RocksDB on both a small and medium server using a database that is cached by RocksDB. Previous posts are here and here with results for RocksDB 6.0 to 9.3. This has results up to version 9.6.tl;drBug 12038 arrived in RocksDB 8.6 and has yet to be fixed, but a fix arrives soon. This effects results on servers when the workload is IO-bound, buffered IO is used (no O_DIRET) and max_sectors_kb for storage is smaller than 1MB.The worst-case regression from 6.0 to 9.6 is ~20% but in most cases it is… 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.  American happening on September 23rd  and 24th, starting starting 9 AM EST and EMEA happening on September 25th  and 25th, starting 9 AM EST.​​​​​ This is […]… Read more

Codership will be a sponsor at DOAG 2024 in Nuremberg, Germany. There will also be 2 Galera Cluster related talks to attend: Building a Global, High-Availability Database with Galera Cluster: A Live Demo Colin Charles Codership Safe Harbor! Wie der Galera Cluster ihre MySQL Datenbanken „unsinkbar“ macht. Matthias Jung Ordix There are also a few […]… Read more