Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. As datasets continue to grow in size, the amount of RAM required to store and process these datasets also increases. Refer to innodb_redo_log_capacity below.

Performance 127

Performance Hardware Tuning Storage 127

Dynatrace

AUGUST 30, 2019

Reducing CPU Utilization to now only consume 15% of initially provisioned hardware. Missing Cache Settings – Make sure you cache resources that don’t change often on the browser or use a CDN. Missing caching layers, e.g. provide a read-only cache for static data. Missing retry and failover implementations.

Cache 195

Cache Architecture Database Government 195

Scalegrid

JANUARY 5, 2024

Despite initial investment costs, DBMS presents long-term savings and improved efficiency through automated processes, efficient query optimizations, and scalability, contributing to enhanced decision-making and end-user productivity. It provides tools for organizing and retrieving data efficiently.

Efficiency 147

Efficiency Storage Database Scalability 147

Percona

MAY 1, 2023

PostgreSQL performance optimization aims to improve the efficiency of a PostgreSQL database system by adjusting configurations and implementing best practices to identify and resolve bottlenecks, improve query speed, and maximize database throughput and responsiveness.

Tuning 52

Tuning Efficiency Database Performance 52

KeyCDN

JULY 11, 2019

This is crucial due to mobile devices requiring additional optimizations because they typically have less powerful hardware and a slower network connection when compared to desktop devices. For example, while the average mobile download speed on 4G in Switzerland is fast at 35.2 Mbps ( Opensignal ). For example, the query string ?width=600&quality=70

Speed 52

Speed Website Mobile Latency 52

Brendan Gregg

FEBRUARY 28, 2023

## References I've reproduced the references from my SREcon22 keynote below, so you can click on links: - [Gregg 08] Brendan Gregg, “ZFS L2ARC,” [link] Jul 2008 - [Gregg 10] Brendan Gregg, “Visualizations for Performance Analysis (and More),” [link] 2010 - [Greenberg 11] Marc Greenberg, “DDR4: Double the speed, double the latency?

Performance 110

Performance Latency Cache Virtualization 110

Percona

JUNE 22, 2023

Query performance Query performance is a key performance indicator (KPI) in MySQL, as it measures the efficiency and speed of query execution. This includes metrics such as query execution time, the number of queries executed per second, and the utilization of query cache and adaptive hash index.

Performance 106

Performance Monitoring Traffic Database 106

HammerDB

JUNE 27, 2022

This post is targeted towards the questions most often asked by non-technical management who want to get up to speed on what HammerDB is (what it isn’t) and how it can benefit their organization. It enables the user to measure database performance and make comparative judgements about database hardware and software.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

The Morning Paper

APRIL 14, 2019

The paper sets out what we can do in software given today’s hardware, and along the way also highlights areas where cooperation from hardware will be needed in the future. Microarchitectural channels. There are also stateless interconnects including buses and on-chip networks. Threat scenarios. The five requirements of Time Protection.

Hardware 44

Hardware Cache Latency Speed 44

CSS - Tricks

JULY 25, 2019

In this article, we uncover how PageSpeed calculates it’s critical speed score. It’s no secret that speed has become a crucial factor in increasing revenue and lowering abandonment rates. Now that Google uses page speed as a ranking factor, many organizations have become laser-focused on performance. Cache-Headers missing?

Google 71

Google Engineering Speed Mobile 71

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. Establish a performance culture.

Performance 145

Performance Cache Media Metrics 145

HammerDB

APRIL 19, 2023

GHz 4th Generation Intel Xeon Scalable processors (code-named Sapphire Rapids) Up to 20% higher compute performance than z1d instances Up to 50 Gbps of networking speed Up to 40 Gbps of bandwidth to the Amazon Elastic Block Store (EBS) We can also verify these capabilities by running some simple benchmarks on the different subsystems.

Performance 54

Performance Benchmarking Cache Storage 54

Brendan Gregg

FEBRUARY 28, 2023

References I've reproduced the references from my SREcon22 keynote below, so you can click on links: [Gregg 08] Brendan Gregg, “ZFS L2ARC,” [link] , Jul 2008 [Gregg 10] Brendan Gregg, “Visualizations for Performance Analysis (and More),” [link] , 2010 [Greenberg 11] Marc Greenberg, “DDR4: Double the speed, double the latency?

Performance 52

Performance Latency Cache Virtualization 52

Alex Russell

JUNE 19, 2020

During the port from Wordpress I've also been pleasantly surprised at how quick the build process is, particularly given the ways build-time work has grown as I've added features like comment imports. Eleventy is I/O heavy, and for correctness sake, it didn't do much caching. So can we go faster? seconds ( 4.9ms each, v0.11.0 ).

Cache 49

Cache Hardware Speed Cloud 49

Smashing Magazine

JANUARY 6, 2020

So, if we created an overview of all the things we have to keep in mind when improving performance — from the very start of the process until the final release of the website — what would that list look like? Establish a performance culture. Treo Sites provides competitive analysis based on real-world data. Large preview ).

Performance 145

Performance Cache Network Metrics 145

The Morning Paper

OCTOBER 4, 2020

We are standing on the eve of the 5G era… 5G, as a monumental shift in cellular communication technology, holds tremendous potential for spurring innovations across many vertical industries, with its promised multi-Gbps speed, sub-10 ms low latency, and massive connectivity. Throughput and latency. Application performance.

Energy 130

Energy Latency Performance Network 130

SQL Server According to Bob

JANUARY 11, 2020

Stable media is commonly physical disk storage, but other devices and certain caching facilities qualify as well. Many high-end disk subsystems provide high-speed cache facilities to reduce the latency of read and write operations. This cache is often supported by a battery-powered backup facility.

Servers 40

Servers Cache Media Hardware 40

Alex Russell

MARCH 6, 2021

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. Advances in browser content processing. Hardware Past As Performance Prologue. The Moto G4 , for example. Modern network performance and availability. Content Is Dead, Long Live Content.

Performance 124

Performance Network Cache Metrics 124

Smashing Magazine

JANUARY 7, 2019

So, if we created an overview of all the things we have to keep in mind when improving performance — from the very start of the process until the final release of the website — what would that list look like? Also, as Patrick Meenan suggested, it’s worth to plan out a loading sequence and trade-offs during the design process.

Performance 103

Performance Cache Metrics Network 103

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

SEPTEMBER 19, 2019

It handles an order of magnitude more throughput than a prototype built on a stream processing engine. Could it be Analyzing efficient stream processing on modern hardware ? Some cool algorithms: Pigeonring speeds up thresholded similarity searches. for machine generated emails sent to humans). What’s their secret???

Blockchain 46

Blockchain Hardware Google Analytics 46

SQL Performance

DECEMBER 17, 2019

This removes the burden of purchasing and maintaining your hardware, storage and networking infrastructure, while still giving you a very familiar experience with Windows and SQL Server itself. BTW, the "i" in the Standard_E64is_v3 naming means that the instance is isolated to hardware dedicated to a single customer.

Azure 72

Azure Virtualization Servers Storage 72

Sutter's Mill

FEBRUARY 13, 2017

” This contains updated and new material that reflects the latest C++ standards and compilers, with a focus to using modern C++11/14/17 effectively on modern hardware and memory architectures. On April 25-27, I’ll be in Stockholm (Kista) giving a three-day seminar on “High-Performance and Low-Latency C++.”

Latency 51

Latency C++ Hardware Performance 51

Dotcom-Montior

JUNE 15, 2020

The censorship and monitoring of internet have evolved from anti-virus-like and firewall software to hardware security patches for all devices that uses internet. A website that is accessed in China for the first time will have a slow loading time due to this process. All information typed by users are collected for future analysis.

Monitoring 52

Monitoring Performance Artificial Intelligence Internet 52

SQL Performance

JUNE 21, 2019

Prior to SQL Server 2012, the maximum server memory value only applied to the bufferpool, so customers needed to limit the amount of memory the bufferpool could use to save memory for the operating system and other processes. Part of that process is his Index Optimize procedure, which can take additional parameters to update statistics.

Servers 49

Servers Azure Hardware Database 49

Smashing Magazine

JANUARY 21, 2021

The build process on its own has become quite a beast over time as well, with critical CSS injects, Webpack’s code splitting, dynamic inserts of advertising and feature panels, RSS (re)generation, and eventual A/B testing on the edge. So we looked into options on automating this process as a part of the build routine.

Performance 145

Performance Cache Mobile Network 145

Randon ASCII

FEBRUARY 25, 2018

In this particular investigation, which spanned twenty months, we suspected hardware failure, compiler bugs, linker bugs, and other possibilities. Jumping too quickly to blaming hardware or build tools is a classic mistake, but in this case the mistake was that we weren’t thinking big enough. 9658 errors : @$ip (00408000-00415815).

Programming 79

Programming Hardware Cache Code 79

The Netflix TechBlog

NOVEMBER 15, 2022

Rachel Kelley (AWS), Ranjit Raju (AWS) Rendering is core to the the VFX process VFX studios around the world create amazing imagery for Netflix productions. By: Peter Cioni (Netflix), Alex Schworer (Netflix), Mac Moore (Conductor Tech.), Rendering on AWS provides the flexibility to control how quickly a project is completed.

Cloud 282

Cloud Entertainment AWS Infrastructure 282

Alex Russell

OCTOBER 22, 2017

Answering it requires an understanding of how browsers process resources (which differs by type) and the concept of the critical path. This input processing happens on document’s main thread , where JavaScript runs. Processing input (including scrolling w/ active touch listeners). ” A good question!

Performance 68

Performance Benchmarking Network Mobile 68

ACM Sigarch

NOVEMBER 1, 2019

This blog post gives a glimpse of the computer systems research papers presented at the USENIX Annual Technical Conference (ATC) 2019, with an emphasis on systems that use new hardware architectures. GAIA proposed to expand the OS page cache into accelerator memory. ATC ’19 was refreshingly different. Heterogeneous ISA.

Architecture 12

Architecture Hardware Cache Storage 12

SQL Server According to Bob

JANUARY 11, 2020

DBCC Page Auditing DBCC page auditing is the process of executing common DBCC consistency checks as pages are read from disk. Time of Last Access The time of last access is a caching ​​ algorithm ​​ that enables ​​ cache ​​ entries to be ordered by their ​​ access times.

Servers 40

Servers Cache Database Media 40

SQL Performance

MARCH 8, 2021

. ( MAXDOP 1 , USE HINT ( 'DISABLE_BATCH_MODE_ADAPTIVE_JOINS' ) ) ; The execution plan is ( click to enlarge ): Every operator in this plan runs in batch mode, thanks to the batch mode on rowstore Intelligent Query Processing feature in SQL Server 2019 (no columnstore index needed).

Servers 95

Servers Tuning Architecture Processing 95

Smashing Magazine

APRIL 29, 2021

From Speed at Scale with Katie Hempenius and I at Google I/O. Device Pixel Ratio (DPR) represents how a CSS pixel is translated to physical pixels on a hardware screen. will optimize images dynamically upon request and store them in a local cache. Large preview ). This typically corresponds to the page’s responsive breakpoints.

Media 145

Media Network Metrics Mobile 145

Abhishek Tiwari

DECEMBER 27, 2017

In 2018, we anticipate that ETL will either lose relevance or the ETL process will disintegrate and be consumed by new data architectures. Apache Arrow's in-memory columnar layout is specifically optimized for data locality for better performance on modern hardware like CPUs and GPUs. Leveraging the recent hardware advances.

Big Data 49

Big Data Artificial Intelligence Storage Hardware 49

Smashing Magazine

AUGUST 22, 2021

A Primer on Speed. Discussing performance and “speed” can quickly get complex, because many underlying aspects contribute to a web-page loading “slowly”. It is physically limited by the speed of light or, practically, how fast signals can travel in wires or in the open air.

Performance 105

Performance Network Latency Servers 105

High Scalability

NOVEMBER 25, 2019

Your Laptop has a filesystem used by hundreds of processes. It is limited by the disk space; it can’t expand storage elastically; it chokes if you run few I/O intensive processes or try collaborating with 100 other users. On prem data processing. Edge caching. Nginx for disk based caching. Document store.

Architecture 52

Architecture Cache Azure Storage 52