Category: Performance
-
The Real Operational Cost of Vacuuming in PostgreSQL
There was a time when PostgreSQL’s own developers were far more open about the real cost of their MVCC design. Back in the 8.1 era, the documentation spelled out the resource drain, the vacuum overhead, and the “cold comfort” of wraparound risk in plain language. I first read that line in 2003, and it stuck with me for more than twenty years. I could not imagine any serious operations team wanting a database that required a separate background process to […]
-
Why sysbench‑tpcc results on outdated hardware should not be presented as a valid OLTP vendor comparison
Benchmark results only have meaning when the workload, hardware, and methodology are clearly defined and reproducible. When those elements are unclear or incomplete, the conclusions can easily mislead readers into assuming the results represent something they do not.
That is the core issue with the recent Percona post comparing MySQL, Percona Server, and MariaDB.
This is not about disputing Percona’s numbers. Their results may be valid for their environment.
The problem is that the post presents the results in a […]
-
Open Source Performance, Benchmarks and MariaDB: A Conversation with Steve Shaw
Right after the recent MariaDB Meetup in London, I had the pleasure of sitting down with Steve Shaw – founder and CEO of HammerDB, former Principal Engineer at Intel, and board member of the MariaDB Foundation. Steve delivered the keynote talk at the event and has a unique perspective on performance, open source, and the intersection between commercial and community-driven database development.
This blog post captures our conversation – a dialogue between two people passionate about open source and database […]
-
Tempesta Technologies Becomes Silver Sponsor of MariaDB Foundation
We are delighted to welcome Tempesta Technologies as a Silver Sponsor of the MariaDB Foundation!
Tempesta Technologies is the developer of Tempesta FW, an open-source hybrid of a web accelerator and a multi-layer firewall. Engineered for maximum efficiency, Tempesta FW is tightly integrated with the Linux TCP/IP stack and leverages cutting-edge technologies to deliver exceptional web application performance. It provides robust protection against DDoS and web attacks while ensuring smooth, high-speed operation under normal conditions.
This partnership underscores MariaDB Server’s […]
-
Intel improving the performance of MariaDB Vector
As you have probably seen in earlier posts, the preview version of MariaDB Vector is out and ready for you to play with. We have had input from several different places during the development of this feature. This, of course, includes hardware manufacturers such as Intel.
In the background, Intel have been prototyping using AVX512 instructions for dot product and bloom filter. Both of these are functions are part of vector searches. If you haven’t heard of these terms, let […]
-
How Intel helps MariaDB become even faster
There are many forums in the past couple of years where I have talked about how non-code contributions are just as important to MariaDB Server and us at the MariaDB Foundation as the code contributions I typically help with. I’ve also highlighted in the past how Intel have provided some fantastic non-code contributions. They assist us by detecting performance issues on their new and future platforms, as well guidance in finding the root cause of these issues.
The outcome: Over […]
-
How MariaDB and MySQL performance changed over releases
Is performance important for you, along with the latest features and long-term support? Go with MariaDB 11.4. But don’t take our word for it. We asked well known benchmarking expert Mark Callaghan to check out a number of MariaDB and MySQL releases, hit them hard with a tool of his choice, and share his findings.
MariaDB’s performance is stable over the years
The outcome: On the low concurrency load (high concurrency results are being prepared), MariaDB maintained stable performance over […]
-
Accelerating MariaBackup with Intel QuickAssist
With Intel QuickAssist Technology, you can see a 5x performance in your MariaBackup compression, and lower CPU usage as well. Today I’m going to show you how.
What is Intel QuickAssist?
Nearly a decade ago, Intel released a technology called QuickAssist, which started out as a PCI-e card and then became integrated in many Xeon processes starting with the Skylake generation. QuickAssist Technology (often called QAT) is a special unit that the CPU can offload compression and encryption tasks onto.