Category: Performance
-
Database changes should be SCARY
“The only workload that matters is my production workload” (for all values of “my”). So you can manage this responsibility, SCARY is a software tool which aims to take the uncertainty out of change; software, configuration and hardware changes. This is very early in development, but projects have to start somewhere.
SCARY takes a read view of the production database query execution, and does the equivalent query on a copy of the production database, that has differences. The query speed, […]
-
Multi-tenancy through catalogs in MariaDB Server
Let’s say you are a Cloud Service Provider, with many customers – each having many MariaDB Server users and databases. What if several such customers could share a single instance of MariaDB Server? That’s what we call the catalog feature, a feature that – if implemented – could potentially save lots of resources (and thus costs!) in a number of high-end use cases.
How the idea was born
At CloudFest 2023 near Frankfurt in March, we had in-depth meetings with a number […]
-
MariaDB 11.0 – new optimizer, new major version series
MariaDB Foundation announces the release of MariaDB Server 11.0, an important milestone in the development of MariaDB Server.
-
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 […]
-
ARM improvements in 2020
2020 has seen quite a few developments with the ARM architecture. For MariaDB things are no different. First we have expanded our testing infrastructure to cover more Linux distributions (Debian, Ubuntu, Fedora, CentOS, RedHat) on ARM and we are now building packages for all of them. The next MariaDB release will include additional binary tarballs for ARM distributions, in addition to the already existing RPM and DEB packages.
All this could not be accomplished without the help of Huawei, who […]
-
Improved MariaDB performance using Shannon Systems PCIe and atomic writes
We recently had a chance to test how the Shannon Direct-IO PCIe Flash G3i devices improves the performance of MariaDB. Anybody who cares about I/O performance has noticed that PCIe drives have become readily available in recent years and that they are significantly faster than normal SSD drives connected to the traditional SATA port (not to mention hard disk drives). In addition to being great hardware, the Shannon drives offer an extra boost by having a device driver that supports atomic […]
-
MyISAM and KPTI – Performance Implications From The Meltdown Fix
Recently we had a report from a user who had seen a stunning 90% performance regression after upgrading his server to a Linux kernel with KPTI (kernel page-table isolation – a remedy for the Meltdown vulnerability).
A big deal of those 90% was caused by running in an old version of VMware which doesn’t pass the PCID and INVPCID capabilities of the CPU to the guest. But I could reproduce a regression around 40% even on bare metal.
This is […]
-
MariaDB 10.1 and MySQL 5.7 performance on commodity hardware
When you have read my previous blog post about MariaDB 10.1 GA performance, you have probably wondered why I didn’t include any numbers for MySQL 5.7. There are two reasons: first MySQL wasn’t GA at that time and secondly MySQL is not running stable on Power8.
Today I will come up with a comparison benchmark. I have chosen some more down-to-earth hardware for that because that is what the majority of our users will be running. Specifically it’s a SP-64 […]