Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Key areas include: Configuration parameter tuning : This tuning involves altering variables such as memory allocation, disk I/O settings, and concurrent connections based on specific hardware and requirements.

Tuning 52

Tuning Database Efficiency Performance 52

SQL Performance

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile.

Servers 46

Servers Hardware Architecture Retail 46

The Morning Paper

DECEMBER 1, 2019

Memory might be durable, but… …it is expected that caches and registers will remain volatile. Moreover, for better performance, the processor may change the order in which writes reach the NVRAM, making it difficult for the NVRAM to even reflect a consistent prefix of the computation.

Efficiency 60

Efficiency Cache C++ Performance 60

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. Their powers combined are going to fundamentally transform the optimal page-load for 2018 and beyond.

Performance 74

Performance Network Benchmarking Mobile 74

Smashing Magazine

JANUARY 15, 2019

The Mozilla Internet Health Report 2018 states that — especially as the Internet expands into new territory — “sustainability should be a bigger priority.” how much data does the browser have to download to display your website) and resource usage of the hardware serving and receiving the website.

Website Performance 74

Website Performance Website Energy Performance 74

Randon ASCII

AUGUST 16, 2018

The slow scanning of CFG memory is actually fixed in Windows 10 RS4 (April 2018 Update), which briefly had me wondering if all of this investigation was pointless. The CFG memory block is best thought of a cache with bounded size. But it’s not. Well, that’s not quite true. MiB of CFG memory, and 59.2 Source code. Rabbit holes.

Programming 75

Programming Virtualization Code Processing 75

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. 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. The second and third run used the cached data.

Cache 48

Cache C++ AWS Airlines 48

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. FILE_FLAG_NO_BUFFERING is the Win32, CreateFile API flags and attributes setting to bypass file system cache. FILE_FLAG_NO_BUFFERING is the Win32, CreateFile API flags and attributes setting to bypass file system cache.

Servers 90

Servers Media Cache Storage 90

Smashing Magazine

JANUARY 6, 2020

Globally in 2018–2019, according to the IDC, 87% of all shipped mobile phones are Android devices. On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing times (we’ll talk about them in detail later). From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19).

Performance 112

Performance Cache Network Servers 112

Smashing Magazine

JANUARY 7, 2019

On the other hand, we have hardware constraints on memory and CPU due to JavaScript parsing times (we’ll talk about them in detail later). Gatsby.js (React), Preact CLI , and PWA Starter Kit provide reasonable defaults for fast loading out of the box on average mobile hardware. Image credit: Addy Osmani ) ( Large preview ).

Performance 105

Performance Cache Metrics Network 105

Smashing Magazine

JANUARY 21, 2021

Plus a service worker that caches all static assets and serves them for repeat views, along with cached versions of articles that a reader has already visited. The reasons for it are numerous, but the most important one is a huge difference in network conditions and device hardware across the world. KB, Brotlified).

Performance 111

Performance Cache Mobile Network 111

Smashing Magazine

JANUARY 11, 2021

Build Optimizations JavaScript modules, module/nomodule pattern, tree-shaking, code-splitting, scope-hoisting, Webpack, differential serving, web worker, WebAssembly, JavaScript bundles, React, SPA, partial hydration, import on interaction, 3rd-parties, cache. This improves page load time and caching during navigations.

Performance 145

Performance Cache Media Metrics 145