Percona

MAY 1, 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. Throughput: The throughput of an application is directly influenced by the speed at which the database can process and serve queries.

Tuning 52

Tuning Efficiency Database Performance 52

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. In fact, choosing the right metric is a process without obvious winners.

Performance 145

Performance Cache Media Metrics 145

CSS - Tricks

JULY 25, 2019

This article is from my friend Ben who runs Calibre , a tool for monitoring the performance of websites. In this article, we uncover how PageSpeed calculates it’s critical speed score. Cache-Headers missing? This process works by obtaining mobile 75th and 95th percentiles from HTTP Archive , then applying a log normal function.

Google 71

Google Engineering Speed Mobile 71

Smashing Magazine

JANUARY 21, 2021

We were designing and building things, setting up new products, refactoring the components, and publishing articles. The entire site is built with progressive enhancement in mind, meaning that you, dear reader, can read every Smashing article in its entirety without the need to boot the application at all. We had to fix that.

Performance 145

Performance Cache Mobile Network 145

Brendan Gregg

FEBRUARY 28, 2023

As I was determined to become great at my new occupation regardless of my location, I read every sysadmin book, article, and magazine I could find on the shelf. I didn't end up getting published in SysAdmin directly, but my performance work did make it as a feature article (thanks Matty). Or even on a plane.

Performance 52

Performance Latency Cache Virtualization 52

SQL Server According to Bob

JANUARY 11, 2020

Important When planning, deploying, and maintaining a Microsoft SQL Server installation, ensure that the I/O system supports all the factors outlined in this article. Stable media is commonly physical disk storage, but other devices and certain caching facilities qualify as well.

Servers 40

Servers Cache Media Hardware 40

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? Also, as Patrick Meenan suggested, it’s worth to plan out a loading sequence and trade-offs during the design process.

Performance 145

Performance Cache Network Metrics 145

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

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 104

Performance Cache Network Metrics 104

Brendan Gregg

AUGUST 18, 2019

Originally posted at https:/opensource.com/article/19/8/introduction-bpftrace. bpftrace uses BPF (Berkeley Packet Filter), an in-kernel execution engine that processes a virtual instruction set. hardware Hardware counter-based instrumentation. pid process ID. comm Process or command name.

Latency 68

Latency C++ Cache Programming 68

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

ACM Sigarch

FEBRUARY 23, 2018

The rest of the article presents some examples of this behavior and how it impacts our field, whether we care to admit it or not. However, what these articles miss is that historically this was not always the case. I recall heated discussions 20+ years ago on whether speculative data in caches improves or degrades cache performance.

Architecture 47

Architecture Cache Hardware Virtualization 47

Highly Scalable

APRIL 2, 2012

In this article, I describe major architectural decisions we made and techniques we used. I can recommend this article by Peter Morville and Jeffrey Callender for further reading. So, the only way was to cache all necessary data to minimize interaction with RDBMS. There is a lot of information about faceted search on the web.

Ecommerce 100

Ecommerce Cache Storage Architecture 100

Percona

APRIL 17, 2023

The swap issue is explained in the excellent article by Jeremy Cole at the Swap Insanity and NUMA Architecture. Make sure the drives are mounted with noatime and also if the drives are behind a RAID controller with appropriate battery-backed cache. The report focuses on MySQL, but it is valid for MongoDB as well. 25.84 - Total 21.04

Best Practices 52

Best Practices Design Tuning Database 52

SQL Performance

JUNE 21, 2019

This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. Part of that process is his Index Optimize procedure, which can take additional parameters to update statistics. If you have more than 8 logical processers, keep MAXDOP at 8.

Servers 49

Servers Azure Hardware Database 49

SQL Server According to Bob

DECEMBER 18, 2018

Durability is a cornerstone of any database system and starting with SQL Server 2017 on Linux Cumulative Update 6 (CU6), SQL Server on Linux enables “Forced Flush” behavior as described in this article , improving durability on non-Fua optimized systems. “Be Linux open command flag used to bypass file system cache. Device Flush.

Servers 90

Servers Media Cache Storage 90

Smashing Magazine

AUGUST 22, 2021

HTTP/3 performance features ( current article ). This is because, as we said, each network link has only a certain amount of data it can (physically) process every second. This is because most articles only consider the worst case (TCP + TLS 1.2, (a)), not mentioning that the modern TCP + TLS 1.3 see figure 2c above).

Performance 106

Performance Network Latency Servers 106

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. Disk based caching.

Architecture 52

Architecture Cache Azure Storage 52

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

Smashing Magazine

JANUARY 15, 2019

how much data does the browser have to download to display your website) and resource usage of the hardware serving and receiving the website. For the more adventurous/technical, the top (table of processes) command provides similar metrics on most Unix-like operating systems such as macOS and Ubuntu. These include data transfer (i.e.

Website Performance 73

Website Performance Website Energy Performance 73

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

Highly Scalable

SEPTEMBER 18, 2012

Although it can hardly be said that NoSQL movement brought fundamentally new techniques into distributed data processing, it triggered an avalanche of practical studies and real-life trials of different combinations of protocols and algorithms. Read/Write requests are processes with a minimal latency. Data Placement. Fault-tolerance.

Database 213

Database Latency C++ Scalability 213

SQL Performance

MARCH 8, 2021

This article aims to help you understand where the timings come from in each case, and how they can be best interpreted in context. This uses hardware, typically a crystal oscillator, that produces ticks at a very high constant rate regardless of processor speed, power settings, or anything of that nature.

Servers 95

Servers Tuning Architecture Processing 95

Smashing Magazine

APRIL 29, 2021

Imagine you’ve started reading an article when all of a sudden elements shift around the page, throwing you off and requiring you to find your place again. Device Pixel Ratio (DPR) represents how a CSS pixel is translated to physical pixels on a hardware screen. In addition to applying image compression (e.g Large preview ).

Media 145

Media Network Metrics Mobile 145