Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first.

Servers 110

Servers Best Practices Database Open Source 110

Smashing Magazine

SEPTEMBER 28, 2022

Every unnecessary bit of JavaScript code you bundle and serve will be more code the client has to load and process. The resource loading waterfall is a cascade of files downloaded from the network server to the client to load your website from start to finish. Client Side Rendering, Server Side Rendering And Jamstack.

Cache 126

Cache Performance Servers Social Media 126

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. This article will cover many areas that database administrators need to be aware of in order to properly license, recover, and tune a Reporting Services installation.

Tuning 67

Tuning Servers Database Best Practices 67

Smashing Magazine

AUGUST 30, 2021

In previous articles from this series, we’ve covered auditing CSS codebase health and the incremental CSS refactoring strategy , testing, and maintenance. In this article, we’re going to cover CSS optimization strategies that can optimize CSS file size, loading times, and render performance. Adrian Bece. 2021-08-30T10:00:00+00:00.

Media 109

Media Performance Cache Strategy 109

Smashing Magazine

AUGUST 3, 2023

However, achieving a good LCP score is often a multi-faceted process that involves optimizing several stages of loading and rendering. Time To First Byte (TTFB) This is the time it takes for the first piece of information from the server to reach the user’s browser. Here’s a breakdown of the moving pieces.

Performance 74

Performance Cache Traffic Metrics 74

Smashing Magazine

NOVEMBER 4, 2021

One of the main benefits of GraphQL is the client’s ability to request what they need from the server and receive that data exactly and predictably. In this article, we’re going to learn how to handle real-time updates on the client-side using GraphQL. Updating the cache directly using update function on the useMutation.

Cache 115

Cache Servers Transportation Code 115

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. 4 Socket, TPCC.

Servers 90

Servers Media Cache Storage 90

SQL Performance

DECEMBER 17, 2019

One initial, easy step to moving your SQL Server on-premises workloads to the cloud is using Azure VMs to run your SQL Server workloads in an infrastructure as a service (IaaS) scenario. You will still have to maintain your operating system, SQL Server and databases just like you would in an on-premises scenario.

Azure 72

Azure Virtualization Servers Storage 72

KeyCDN

FEBRUARY 4, 2021

This query is performed by a Domain Name Server (DNS server) or servers nearby that have been assigned responsibility for that hostname. You can think of a DNS server as a phone book for the internet. A DNS server maintains a directory of domain names and translates them to IPs. So DNS services definitely go down!

Cache 134

Cache Website Internet Internet 134

Smashing Magazine

OCTOBER 2, 2023

In this second article, I’ll go over some key technical highlights from the project. In the first article, I briefly discussed the technical stack that includes a React-based front-end framework, Next.js Definitely read up on the strategy and reasoning behind this stack in the first article if you missed it.

Cache 72

Cache Strategy Best Practices Design 72

CSS - Tricks

APRIL 1, 2021

In that spirit, what we’re looking at in this article is focused more on the incremental wins and less on providing an exhaustive list or checklist of performance strategies. I’m going to audit the performance of my slow site before and after the things we tackle in this article. Compressing, minifying and caching assets.

Cache 92

Cache Social Media Media Network 92

Dynatrace

MAY 17, 2023

When software runs in a monolithic stack on on-site servers, observability is manageable enough. To demonstrate how that can work, we’ve chosen a pristine web application without any observability and are going to make it observable step-by-step during the next few chapters of this article.

Metrics 185

Metrics Open Source Traffic Cache 185

Smashing Magazine

MAY 25, 2022

When the JavaScript engine runs a garbage-collection process, the man object will be removed from memory and from the WeakMap that we assigned it to. The process of clearing memory when objects are no longer being used is referred to as garbage collection. With caching, a copy of the result from a request is saved locally.

Cache 117

Cache Programming Storage Code 117

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory. Or even on a plane.

Performance 110

Performance Latency Cache Virtualization 110

KeyCDN

DECEMBER 8, 2022

A WordPress website comprises many parts, including web servers and their settings, different plugins, and themes. Unfortunately, it is a bit difficult to point out the problem directly– there are many possibilities that we will explore in this article. So let's discuss the process one step at a time. Why is WordPress slow?

Cache 52

Cache Website Speed Website Performance 52

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. 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. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS.

Servers 49

Servers Azure Hardware Database 49

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. Large preview ). What does it mean?

Performance 145

Performance Cache Media Metrics 145

The Netflix TechBlog

JULY 21, 2022

Problem Statement The purpose of this article is to give insights into analyzing and predicting “out of memory” or OOM kills on the Netflix App. device characteristics come from our on-field knowledge and runtime memory data comes from real-time user data pushed to our servers. Labeling the data?—?Ground

Big Data 179

Big Data Cache Engineering Data Engineering 179

SQL Performance

MARCH 29, 2022

Simple parameterization has a number of quirks in this area, which can result in more parameterized plans being cached than expected, or finding different results compared with the unparameterized version. When SQL Server applies simple parameterization to an ad-hoc statement, it makes a guess about the data type of the replacement parameter.

Cache 90

Cache Servers Database Testing 90

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

Percona

SEPTEMBER 1, 2023

A finely tuned database processes queries more efficiently, leading to swifter results. Reduced Resource Usage Optimizing resource-intensive queries and configurations can lead to a reduced burden on your server. An improperly configured server may not allocate sufficient resources or be optimized for the specific workload.

Tuning 52

Tuning Database Performance Hardware 52

Smashing Magazine

DECEMBER 23, 2020

The service workers enable the offline usage of the PWA by fetching cached data or informing the user about the absence of an Internet connection. The service workers also retrieve the latest data once the server connection is restored. When developing a PWA, you can cache the application shell’s resources and assets in the browser.

Cache 124

Cache Internet Internet Google 124

SQL Performance

NOVEMBER 10, 2021

Last month I explained when SQL Server inlines iTVFs, it applies parameter embedding optimization by default. Parameter embedding means SQL Server replaces parameter references in the query with the literal constant values from the current execution, and then the code with the constants gets optimized. Constant Folding.

Cache 121

Cache Servers Code Database 121

Smashing Magazine

NOVEMBER 26, 2021

In this article, we will discuss a few of those techniques as well as some of the things I wish I had known earlier to help manage large Next.js Note : While this article is specific to Next.js, some of the points will also work for a wide variety of front-end applications. This can be reduced by a proper code-review process.

Cache 143

Cache Code Testing Design 143

The Netflix TechBlog

SEPTEMBER 8, 2020

This allows the app to query a list of “paths” in each HTTP request, and get specially formatted JSON (jsonGraph) that we use to cache the data and hydrate the UI. ecosystem was chosen for this new service deserves an article in and of itself. video titles, descriptions) could be aggressively cached and reused across multiple requests.

Latency 233

Latency Cache Java Traffic 233

Smashing Magazine

JANUARY 6, 2020

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? 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

AUGUST 23, 2019

In traditional row-mode execution plans, SQL Server may introduce a Bitmap operator as part of performing early semi join reduction before a parallel hash or merge join. This article is about batch mode bitmaps, which have a very different implementation. Background. Bitmap Choice.

Servers 75

Servers Engineering Efficiency Retail 75

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40

Smashing Magazine

JUNE 25, 2020

Today, we’ll address storing and serving files for both single-server and scalable deployments while considering factors like compression, caching, and availability. If you’re on the latter end of this scale, you probably need more specialized advice than this article is prepared to give. Option 1: Default Django.

Media 69

Media Cache Storage AWS 69

Smashing Magazine

JANUARY 7, 2019

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? 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

Dotcom-Montior

MARCH 6, 2022

It assists in identifying where important events happened during the loading process. Waterfall charts within the Dotcom-Monitor platform can help users identify where important events happened during the page load process. To boost the bandwidth availability, the user should keep the images on a cloud server. Waiting time.

Performance 52

Performance Cache Website Speed 52

Percona

MAY 1, 2023

Connection pooling: Minimizing connection overhead and improving response times for frequently accessed data by implementing mechanisms for connection pooling and caching strategies. PostgreSQL performance optimization is an ongoing process involving monitoring, benchmarking, and adjustments to maintain high-performing PostgreSQL databases.

Tuning 52

Tuning Efficiency Database Performance 52

Percona

NOVEMBER 1, 2023

Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. I wrote this article based on the Docker-maintained repository. Docker quickly deploys standalone MongoDB containers.

Scalability 58

Scalability Best Practices Servers Database 58

CSS - Tricks

JUNE 5, 2020

This article is about my experience using Brotli at production scale. It took a few months for major CDN players to support Brotli, but meanwhile it was seeing widespread adoption in tools, services, browsers and servers. The only problem was the fear that Brotli could kill all our processing resources.

Cache 79

Cache Website Servers Open Source 79

SQL Performance

SEPTEMBER 25, 2019

An example plan shape showing a lazy table performance spool is below: The questions I set out to answer in this article are why, how, and when the query optimizer introduces each type of performance spool. For more details, please see my linked article. When a spool is able to replay cached results, this is known as a rewind.

Performance 104

Performance Cache Servers Education 104

Smashing Magazine

JULY 6, 2021

Moving to a headless CMS is not an easy decision and the selection process should not be taken lightly. In this article, I will highlight a few core features that every headless CMS should provide. The process of defining this sound, logical taxonomy structure for the content items you create and publish is known as content modeling.

Cache 143

Cache Website Mobile Google 143

Smashing Magazine

SEPTEMBER 6, 2021

Next, we’ll look at how to set up servers and clients (that’s the hard part unless you’re using a content delivery network (CDN)). Practical HTTP/3 deployment options ( current article ). You would, however, be hard-pressed even today to find a good article that details the nuanced best practices. HTTP/3 performance features.

Network 105

Network Servers Cache Traffic 105