Tag: Performance
-
MariaDB Foundation: TAF Now Supports Embedded Database Configuration in User Properties
TAF: One File to Rule Them All
In a one‑on‑one review of TAF with Monty Widenius, the creator of MySQL and MariaDB, he looked at me and said: “I want everything in one user file.”
It was simple, direct, and completely right direction.
TAF’s configuration model had inherited its design from older frameworks — a user properties file and a separate database configuration file.
Monty’s comment cut straight through it. He wanted simplicity — one file that defines everything.
So […]
-
From a Chocolate Wrapper to Concurrent InnoDB Page Splits
This work started from a conversation with Monty Widenius at Meet Magento Czech in August. We discussed possible ways to improve the scalability of the InnoDB B+Tree, especially its insert path and page splits.
Monty explained several ideas about reducing synchronization during structural changes and allowing independent parts of the tree to make progress concurrently. We did not have a whiteboard, so we made the first design sketch on the back of a dark chocolate wrapper.
The sketch contained a […]
-
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 […]
-
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 […]
-
MariaDB & IONOS: Improving performance for hosting
The MariaDB Foundation values our partnerships with our sponsors. Our partnership with IONOS allows us to get insight into how MariaDB Server is used and the direction it should take. As well as generally improving MariaDB Server in many different ways.
IONOS story
At CloudFest 2023, one of the first meetings we had was with Stefan Erkeling from IONOS. It was a very good meeting and it was great to see how much IONOS values our partnership. Stefan indicated in […]
-
This one trick can make MariaDB 30x faster!
Yes, it is a bit of a click-bait title, but in this case running one SQL command did improve a community user’s performance by that much. It could help you too.
The story
A community user posted in a couple of places that when migrating a large WordPress installation to MariaDB that they were seeing a certain query performing terribly. The query was taking 1.5 seconds to execute and it was clear from the explain plan that the optimizer was […]
-
Early tests show MariaDB 5.3.0 having a performance speed-up against DBT-3 query set
Posted recently on the maria-developers mailing list, by Igor Babaev, Principal MariaDB developer at Monty Program is some interesting preliminary results for MariaDB 5.3.0 benchmarked against the DBT-3 benchmarking program.
DBT-3 is a benchmark to test a decision support workload, with a suite of business-oriented queries and concurrent data modifications.
Read Igor’s discoveries, which he ran on a laptop with 4 cores (multi-threaded = 8 cores in total), 8GB RAM and SSD on SuSE, and as Igor says, enjoy his numbers. […]