Percona

JANUARY 24, 2023

Some of the built-in features ( wal_compression ) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. Such “torn pages” are corruptions from the database point of view. This is generally referred to as “ partial page writes ” or “ torn pages.”

Database 114

Database Benchmarking Open Source Latency 114

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52

Percona

JANUARY 14, 2019

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. Although such databases can be very efficient with counts and averages, some queries will be slow or simply non existent. Processed 4.15

Database 40

Database Analytics Blockchain Healthcare 40

SQL Server According to Bob

NOVEMBER 8, 2016

SQL Server 2016 Service Pack 1 (all SKUs) , in combination with Windows Server 2016 (All SKUs) or Windows 10 Client introduces non-volatile memory support for the tail of the log file (LDF) which can significantly increase transaction throughput. Block storage is what you think of today as disk access. Tail Of Log Caching.

Cache 40

Cache Servers Media Storage 40

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage.

Performance 124

Performance Network Cache Metrics 124

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. Both of these Intel processors are special bespoke models that are not in the Intel ARK database. They feature low latency, local NVMe storage that can directly leverage the 128 PCIe 3.0

Azure 42

Azure Virtualization Storage Benchmarking 42

SQL Performance

MAY 1, 2019

The summary rows for heap tables without indexes are the same in both documents (no changes for SQL Server 2016): An explicit TABLOCK hint is not the only way to meet the requirement for table-level locking. The following demo script should be run on a development instance in a new test database set to use the SIMPLE recovery model.

Servers 47

Servers Database Testing Performance 47

Smashing Magazine

JANUARY 15, 2019

The Green Web Foundation maintains an ever-growing database of web hosts who are either wholly powered by renewable energy or are at least committed to being carbon neutral. In 2013, A List Apart published Sustainable Web Design by James Christie. Sustainable Web Design. These include data transfer (i.e.

Website Performance 73

Website Performance Website Energy Performance 73

Particular Software

OCTOBER 3, 2017

This article was originally published on the NDC 2016 Blog. Event-Driven Architecture to the Rescue Event-driven architecture is a software design style that uses messaging techniques to convey events to other services. Because you're on the outside of the monolith, your database technology constraints also disappear.

Architecture 49

Architecture Database Code Systems 49

Alex Russell

APRIL 29, 2021

At the time of the last Confluence run, the gap had stretched to nearly 1000 APIs, doubling since 2016. Chrome has missed several APIs for 3+ years: Storage Access API. For example, an area where Apple is absolutely killing it is in mobile CPU design. But perhaps counting APIs gives a distorted view? Where Chrome Has Lagged.

Media 145

Media Games Education Engineering 145