Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. However, simply deploying a monitoring tool is not enough; you need to know which Key Performance Indicators (KPIs) to monitor to gain insights into your MySQL server’s health and performance.

Performance 106

Performance Monitoring Traffic Database 106

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. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server. Installation and support of SSRS can be confusing.

Tuning 67

Tuning Servers Database Best Practices 67

Percona

SEPTEMBER 1, 2023

This reduction in latency ensures that applications and websites provide a more rapid and responsive user experience. Reduced Resource Usage Optimizing resource-intensive queries and configurations can lead to a reduced burden on your server. A finely tuned database processes queries more efficiently, leading to swifter results.

Tuning 52

Tuning Database Performance Hardware 52

CSS Wizardry

MAY 19, 2020

It’s widely accepted that self-hosted fonts are the fastest option: same origin means reduced network negotiation, predictable URLs mean we can preload , self-hosted means we can set our own cache-control. For each test, I captured the following metrics: First Paint (FP): To what extent is the critical path affected? Because harry.is

Google 364

Google Media Latency Metrics 364

Scalegrid

APRIL 16, 2020

Deploying your application and database on the same VPC also provides the lowest possible latency path. This becomes really important for cache solutions like Redis™. AWS Security Groups and Azure Network Security Groups allow you to lock down access to your servers through advanced virtual firewalls. Security Groups.

Cloud 242

Cloud Azure AWS Database 242

Scalegrid

DECEMBER 21, 2023

Buckle up as we delve into the world of Redis® monitoring, exploring the most important Redis® metrics, discussing essential tools, and even peering into the future of Redis® performance management. Identifying key Redis® metrics such as latency, CPU usage, and memory metrics is crucial for effective Redis monitoring.

Strategy 130

Strategy Monitoring Latency DevOps 130

The Netflix TechBlog

JUNE 14, 2023

Before GraphQL: Monolithic Falcor API implemented and maintained by the API Team Before moving to GraphQL, our API layer consisted of a monolithic server built with Falcor. A single API team maintained both the Java implementation of the Falcor framework and the API Server. To launch Phase 1 safely, we used AB Testing.

Traffic 353

Traffic Latency Cache Metrics 353

The Morning Paper

FEBRUARY 23, 2020

Coordinators are servers that receive queries and return results (search engines). Caching of query results on the other hand, looks like a good business model, at large enough scale these might amount to pretty much the same thing). 10 minutes) with the bookkeeping metrics for each batch written to the blockchain. Periods (e.g.

Blockchain 94

Blockchain Internet Internet IoT 94

All Things Distributed

NOVEMBER 26, 2013

About 5 years ago, I introduced you to AWS Availability Zones, which are distinct locations within a Region that are engineered to be insulated from failures in other Availability Zones and provide inexpensive, low latency network connectivity to other Availability Zones in the same region.

Cloud 145

Cloud AWS Traffic Latency 145

Smashing Magazine

MAY 16, 2022

Rethinking Server-Timing As A Critical Monitoring Tool. Rethinking Server-Timing As A Critical Monitoring Tool. In the world of HTTP Headers, there is one header that I believe deserves more air-time and that is the Server-Timing header. Setting Server-Timing. Sean Roberts. 2022-05-16T10:00:00+00:00.

Servers 92

Servers Monitoring Cache Network 92

Smashing Magazine

AUGUST 3, 2023

Google’s Core Web Vitals is a set of performance metrics that site owners can use to evaluate performance and diagnose performance issues. These metrics provide a different perspective on user experience: Largest Contentful Paint (LCP) Measures the time it takes for the main content on a webpage to load. One of the key Next.js

Performance 74

Performance Cache Traffic Metrics 74

Smashing Magazine

OCTOBER 31, 2023

But do you know how Lighthouse calculates performance metrics like First Contentful Paint (FCP), Total Blocking Time (TBT), and Cumulative Layout Shift (CLS)? Still, there’s nothing in there to tell us about the data Lighthouse is using to evaluate metrics. But it comes with caveats. So why use lab data at all?

Speed 97

Speed Google Website Metrics 97

Percona

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? Sysbench ran on a third server, which I’ll refer to as the application server (APP). Are these results good enough?

Tuning 137

Tuning Cache Servers Benchmarking 137

Dynatrace

NOVEMBER 3, 2021

Monitoring focuses on watching specific metrics. Observability is the ability to understand a system’s internal state by analyzing the data it generates, such as logs, metrics, and traces. For example, we can actively watch a single metric for changes that indicate a problem — this is monitoring.

Monitoring 216

Monitoring Metrics DevOps Scalability 216

CSS - Tricks

APRIL 1, 2021

Site performance is potentially the most important metric. Having a slow site might leave you on page 452 of search results, regardless of any other metric. I’m going to update my referenced URL to the new site to help decrease latency that adds drag to the initial page load. Compressing, minifying and caching assets.

Cache 92

Cache Social Media Media Website 92

All Things Distributed

SEPTEMBER 3, 2013

Amazon RDS , with support for MySQL, SQL Server and Oracle databases, is for customers with apps where relational database features and support for a specific brand of database are critical. Amazon ElastiCache is a fully managed, in-memory caching service for customers to optimize the latency, performance and cost of their read workloads.

Cache 129

Cache Cloud Performance Retail 129

The Morning Paper

FEBRUARY 6, 2020

Last week we looked at a function shipping solution to the problem; Cloudburst uses the more common data shipping to bring data to caches next to function runtimes (though you could also make a case that the scheduling algorithm placing function execution in locations where the data is cached a flavour of function-shipping too).

Lambda 98

Lambda Serverless Cache Latency 98

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

The Morning Paper

SEPTEMBER 10, 2019

That’s hard for many reasons, including the differing trade-offs between throughput and latency that need to be made across the use cases. to understand YouTube video performance) drive tens of thousands of canned (known in advance) queries per second, that need to be served with latency in the tens of milliseconds.

Analytics 75

Analytics Latency Cache Google 75

IO River

NOVEMBER 2, 2023

A CDN (Content Delivery Network) is a network of geographically distributed servers that brings web content closer to where end users are located, to ensure high availability, optimized performance and low latency. What is Multi-CDN?A Multi-CDN is the practice of employing a number of CDN providers simultaneously.

Best Practices 52

Best Practices Strategy Traffic Virtualization 52

IO River

NOVEMBER 2, 2023

A CDN (Content Delivery Network) is a network of geographically distributed servers that brings web content closer to where end users are located, to ensure high availability, optimized performance and low latency. What is Multi-CDN?A Multi-CDN is the practice of employing a number of CDN providers simultaneously.

Best Practices 40

Best Practices Strategy Traffic Virtualization 40

Smashing Magazine

AUGUST 22, 2021

Because we are dealing with network protocols here, we will mainly look at network aspects, of which two are most important: latency and bandwidth. Latency can be roughly defined as the time it takes to send a packet from point A (say, the client) to point B (the server). Two-way latency is often called round-trip time (RTT).

Performance 105

Performance Network Latency Servers 105

Alex Russell

MARCH 6, 2021

The scale of the effect can be deeply situational or hard to suss out without solid metrics. A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. The Moto G4 , for example. Don't pay a lot for an Android-shaped muffler.

Performance 124

Performance Network Cache Metrics 124

Brendan Gregg

JANUARY 17, 2018

Here is a MySQL database server (mysqld), PID 423, and measuring its working set size for 0.1 Short durations can be useful for understanding how well a WSS will fit into the CPU caches (L1/L2/L3, TLB L1/L2, etc). This is the working set size metric. I just wrote [wss.pl] as a front-end to this feature. The main memory size. -

Cache 71

Cache Latency C++ Programming 71

CSS - Tricks

MAY 3, 2021

Linux; Android 6.0.1; Moto G (4)) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.85 Mobile Safari/537.36 PTST/210419.211328", "accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9", image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9",

Transportation 86

Transportation Cache Google Mobile 86

All Things Distributed

JANUARY 18, 2012

Behind the scenes, Amazon DynamoDB automatically spreads the data and traffic for a table over a sufficient number of servers to meet the request capacity specified by the customer. Amazon DynamoDB offers low, predictable latencies at any scale. s read latency, particularly as dataset sizes grow. Consistency. SimpleDBâ??s

Scalability 167

Scalability Database Ecommerce Latency 167

Highly Scalable

SEPTEMBER 18, 2012

Historically, NoSQL paid a lot of attention to tradeoffs between consistency, fault-tolerance and performance to serve geographically distributed systems, low-latency or highly available applications. Read/Write latency. Read/Write requests are processes with a minimal latency. Data Placement. Read/Write scalability.

Database 213

Database Latency C++ Scalability 213

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)). This difference by itself doesn’t do all that much (it mainly reduces the overhead on the server-side), but it leads to most of the following points. Server Sharding and Connection Coalescing.

Network 104

Network Servers Cache Traffic 104

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. SQL Server DELAYED_DURABILITY. Oracle Log File Sync.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

Alex Russell

OCTOBER 22, 2017

This helps support executive sponsors who then have meaningful metrics to point to in justifying the investments being made. Very rarely have we seen a team succeed that doesn’t set budgets, gather RUM metrics, and carry representative customer devices. Teams with budgets also find it easier to track and graph progress.

Performance 68

Performance Benchmarking Network Mobile 68

Brendan Gregg

JANUARY 16, 2018

Here is a MySQL database server (mysqld), PID 423, and measuring its working set size for 0.1 Short durations can be useful for understanding how well a WSS will fit into the CPU caches (L1/L2/L3, TLB L1/L2, etc). This is the working set size metric. I just wrote [wss.pl] as a front-end to this feature. The main memory size. -

Cache 40

Cache Latency C++ Programming 40

Smashing Magazine

AUGUST 9, 2021

You’ve probably heard things like: “HTTP/3 is much faster than HTTP/2 when there is packet loss”, or “HTTP/3 connections have less latency and take less time to set up”, and probably “HTTP/3 can send data more quickly and can send more resources in parallel”. Websites would magically become 50% faster with the flip of a switch!

Transportation 145

Transportation Internet Internet Network 145

Smashing Magazine

JANUARY 11, 2021

LogRocket tracks key metrics, incl. Getting Ready: Planning And Metrics Performance culture, Core Web Vitals, performance profiles, CrUX, Lighthouse, FID, TTI, CLS, devices. Getting Ready: Planning And Metrics. DOM complete, time to first byte, first input delay, client CPU and memory usage. Get a free trial of LogRocket today.

Performance 145

Performance Cache Media Metrics 145

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? Getting Ready: Planning And Metrics. Getting Ready: Planning And Metrics. Table Of Contents. Quick Wins.

Performance 145

Performance Cache Network Metrics 145

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? Getting Ready: Planning And Metrics. Getting Ready: Planning And Metrics. Table Of Contents. Quick Wins.

Performance 103

Performance Cache Metrics Network 103