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. This not only results in cost savings by minimizing hardware requirements but also has the potential to decrease cloud expenses.

Tuning 52

Tuning Efficiency Database Performance 52

Scalegrid

JANUARY 5, 2024

This article cuts through the complexity to showcase the tangible benefits of DBMS, equipping you with the knowledge to make informed decisions about your data management strategies. Enhanced data security, better data integrity, and efficient access to information.

Efficiency 147

Efficiency Storage Database Scalability 147

SQL Performance

APRIL 27, 2020

Gen 5 is the primary hardware option now for most regions since Gen 4 is aging out. Hyperscale achieves high performance from each compute node having SSD-based caches which helps minimize the network round trips to fetch data. New Hardware Configuration for Provisioned Compute Tier. GB per vCore. Serverless Database.

Azure 55

Azure Database Serverless Hardware 55

ACM Sigarch

OCTOBER 12, 2020

have pointed out in their recent Science article (“There’s plenty of room at the Top”) — and cited by Hennessy in his Turing lecture — a naive implementation of matrix-matrix multiply in Python runs between 100x and 60,000x slower than their counterparts written in a “metal” language (highly optimized C).

C++ 108

C++ Benchmarking Hardware Architecture 108

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. Largest Contentful Paint ( LCP ) < 2.5 considerations.

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? Service workers that will cache the bytecode result of a parsed and compiled script. Related Articles.

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

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 6, 2020

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 Addy’s article “ Loading Web Pages Fast On A $20 Feature Phone ”. To achieve the goals stated in the first paragraph, we have to consider the critical file size budget for JavaScript.

Performance 145

Performance Cache Network Metrics 145

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). awesome-webpack is a curated list of useful Webpack resources, libraries and tools, including articles, videos, courses, books and examples for Angular, React and framework-agnostic projects.

Performance 104

Performance Cache Network Metrics 104

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

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

Brendan Gregg

AUGUST 18, 2019

Originally posted at https:/opensource.com/article/19/8/introduction-bpftrace. hardware Hardware counter-based instrumentation. There are also two modes visible, one between 1 and 2 milliseconds, and another between 8 and 16 milliseconds: this sounds like cache hits and cache misses. BEGIN Start of bpftrace.

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. Hardware Past As Performance Prologue. Regardless, the overall story for hardware progress remains grim, particularly when we recall how long device replacement cycles are: Tap for a larger version.

Performance 124

Performance Network Cache Metrics 124

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

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. If you have big physical hardware with defaults, then you should look at optimizing MAXDOP. With modern hardware, the cost estimation of 5 is outdated. SQL Server Agent Alerts.

Servers 49

Servers Azure Hardware Database 49

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. There is an issue with this, which causes the OS to swap even with memory available.

Best Practices 52

Best Practices Design Tuning Database 52

Smashing Magazine

JUNE 18, 2020

In this article, we’re going to see some of those differences and how to overcome them. Flutter isn’t that, though: it runs natively on each platform, and it means each app runs just like it would run if it were written in Java/Kotlin or Objective-C/Swift on Android and iOS, pretty much. In React Native.

Storage 93

Storage Mobile Website Java 93

High Scalability

NOVEMBER 25, 2019

In this article, I will share the current architecture and some of the lessons we learned scaling it along with some of the things we are looking to improve upon in the near future. Edge caching. In general, Egnyte connect architecture shards and caches data at different levels based on: Amount of data. Disk based caching.

Architecture 52

Architecture Cache Azure Storage 52

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. In this article, we will look at how this can improve the reporting/analytical query performance in MySQL. The second and third run used the cached data. This query is 100% cached.

Cache 46

Cache C++ AWS Airlines 46

Smashing Magazine

AUGUST 22, 2021

HTTP/3 performance features ( current article ). This has led to many articles claiming that QUIC also doesn’t use congestion control, that QUIC can instead start sending data at a much higher rate over UDP (relying on the removal of HOL blocking to deal with packet loss), that this is why QUIC is much faster than TCP.

Performance 106

Performance Network Latency Servers 106

SQL Server According to Bob

JANUARY 11, 2020

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. I predominantly use Nginx, and I have a particular fondness for FastCGI cache and have found it to be especially efficient. A particular favorite in the WordPress space is WP Super Cache.

Website Performance 73

Website Performance Website Energy Performance 73

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. Previous versions of this article discussed slow-start, bdp, tcp window scaling, and the like. seconds: 400 Kbps = 50KB/s. 50KB/s * 3.4 = 170KB.

Performance 68

Performance Benchmarking Network Mobile 68

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

Highly Scalable

AUGUST 20, 2013

This article is an effort to explore techniques used by developers of in-stream data processing systems, trace the connections of these techniques to massive batch processing and OLTP/OLAP databases, and discuss how one unified query engine can support in-stream, batch, and OLAP processing at the same time. Interoperability with Hadoop.

Big Data 154

Big Data Processing Lambda Database 154

Highly Scalable

SEPTEMBER 18, 2012

In this article I’m trying to provide more or less systematic description of techniques related to distributed operations in NoSQL databases. In the rest of this article we study a number of distributed activities like replication of failure detection that could happen in a database. Data Placement. Consistency. Read-Write consistency.

Database 213

Database Latency C++ Scalability 213

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