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

Percona

JANUARY 17, 2019

now has a version which will support parallelism for SELECT queries (utilizing the read capacity of storage nodes underneath the Aurora cluster). Aurora Parallel Query response time (for queries which can not use indexes) can be 5x-10x better compared to the non-parallel fully cached operations. AWS Aurora (based on MySQL 5.6)

Cache 46

Cache C++ AWS Airlines 46

SQL Server According to Bob

DECEMBER 18, 2018

Device level flushing may have an impact on your I/O caching, read ahead or other behaviors of the storage system. Neal, Matt, and others from Windows Storage, Windows Azure Storage, Windows Hyper-V, … validating Windows behaviors. · Any storage device that can survive a power outage. Starting with the Linux 4.18

Servers 90

Servers Media Cache Storage 90

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. The L3 cache size is 64MB. The slightly newer Intel Xeon E5-26xx v4 (Broadwell) series which was introduced in Q1 of 2016, increased that to 2400MHz. The L3 cache size is 64MB.

Azure 42

Azure Virtualization Storage Benchmarking 42

SQL Performance

MAY 29, 2019

From SQL Server 2016 onward, FastLoadContext is enabled by default ; the trace flag is not required. For more background, see the Data Performance Loading Guide and the Tiger Team notes on the behaviour changes for SQL Server 2016. FastLoadContext can be disabled on SQL Server 2016 using documented trace flag 692. DETAILED'. )

Cache 64

Cache Testing Servers Code 64

Percona

JUNE 4, 2023

MariaDB retains compatibility with MySQL, offers support for different programming languages, including Python, PHP, Java, and Perl, and works with all major open source storage engines such as MyRocks, Aria, and InnoDB. GA 23 February 2016 5.7.10-3 MariaDB Server includes many storage engines beyond the default InnoDB.

Open Source 52

Open Source Servers Storage Scalability 52

SQL Performance

MAY 16, 2019

The calculated row size (61 bytes) differs from the true row storage size (60 bytes) by the extra one byte of internal metadata present in the insert stream. spt_values AS SV ; Plan Caching. The DMLRequestSort property is saved as part of the cached plan. Calculated data size = 61 bytes * 268 rows = 16,348 bytes. Trace Flag.

Cache 67

Cache Servers Testing Storage 67

SQL Performance

AUGUST 23, 2019

The SQL Server batch mode implementation of a Bloom filter is optimized for modern CPU cache architectures and is known internally as a complex bitmap. SQL Server 2016 introduced the ability to create a bitmap for general predicates on dictionary-encoded segment data. Bitmap Choice.

Servers 75

Servers Engineering Efficiency Retail 75

Smashing Magazine

JANUARY 15, 2019

An obvious metric here is CPU usage, but memory usage and other forms of data storage also play their part. In 2016, O’Reilly published “ Designing For Sustainability ” by Tim Frick. I predominantly use Nginx, and I have a particular fondness for FastCGI cache and have found it to be especially efficient.

Website Performance 73

Website Performance Website Energy Performance 73

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. An extension to Service Workers that enables browsers to present users with cached content when offline. But perhaps counting APIs gives a distorted view?

Media 145

Media Games Education Engineering 145

Alex Russell

OCTOBER 22, 2017

Add onto that the yawning chasm between low-end and high-end device performance thanks to chip design factors like cache sizes, and it can be difficult to know where to set a device baseline. The true median device from 2016 sold at about ~$200 unlocked. — Monica Dinculescu (@notwaldorf) September 20, 2016.

Performance 68

Performance Benchmarking Network Mobile 68