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

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. Websites and apps that are allowed to be used in China can be accessed at a very fast speed, up to the recent 5G (20Gbps) upgrade.

Monitoring 52

Monitoring Performance Artificial Intelligence Internet 52

SQL Server According to Bob

JULY 13, 2016

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 desktop machine (I won’t tell you the hardware details. There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use.

Servers 40

Servers Media Engineering Virtualization 40

Dotcom-Montior

NOVEMBER 27, 2018

Additionally, end users can access your site or applications from anywhere in the world using different browsers, operating systems, and mobile devices, all with varying connection speeds. LoadView – Best Practices and Process. Analyzing server performance (CPU, memory, bandwidth, disk I/O) and database response times.

Performance Testing 40

Performance Testing Strategy Testing Performance 40

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()? But I'm not completely sure.

Speed 126

Speed Java AWS Virtualization 126

Percona

SEPTEMBER 1, 2023

Sharding in MongoDB is a technique used to distribute a database horizontally across multiple nodes or servers, known as “shards.” Sharding enables horizontal scaling, where more servers or nodes are added to the cluster to handle increasing data and user demands. Learn more: View our webinar on How to Scale with MongoDB.

Best Practices 74

Best Practices Traffic Database Servers 74

All Things Distributed

APRIL 5, 2012

Troy: We moved our service from internal servers to AWS. In addition to using Edmodo to engage students in classroom activities, teachers all over the world build profile pages on Edmodo, which they use to discover and share content, meet and stay in contact with other educators, and best practices and top resources.

Innovation 146

Innovation AWS Education Network 146

Dynatrace

AUGUST 11, 2022

Effective application development requires speed and specificity. Cloud providers then manage physical hardware, virtual machines, and web server software management. This code is then executed on remote servers in response to an event, such as users interacting with functional web elements. Dynatrace news.

Development 250

Development Serverless Best Practices Lambda 250

Percona

AUGUST 30, 2023

In general terms, here are potential trouble spots: Hardware failure: Manufacturing defects, wear and tear, physical damage, and other factors can cause hardware to fail. heat) can damage hardware components and prompt data loss. Human mistakes: Incorrect configuration is an all-too-common cause of hardware and software failure.

Database 92

Database Hardware Open Source Strategy 92

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()?

Speed 52

Speed Java AWS Virtualization 52

Dynatrace

AUGUST 30, 2019

Reducing CPU Utilization to now only consume 15% of initially provisioned hardware. Impacting Server-Side Requests: Dynatrace allows you to drill into your server-side requests to understand why your business logic is executing slow or fails. Impressive results I have to say!

Cache 198

Cache Architecture Database Government 198

HammerDB

OCTOBER 8, 2018

This limitation is at the database level rather than the hardware level, nevertheless with up to date hardware (from mid-2018) PostgreSQL on a 2 socket system can be expected to deliver more than 2M PostgreSQL TPM and 1M NOPM with the HammerDB TPC-C test. . CPUs which run at the same hardware frequency: 0. timezone = 'GB'.

Best Practices 40

Best Practices Scalability Performance Hardware 40

Brendan Gregg

SEPTEMBER 25, 2021

This server is spending about a third of its CPU cycles just checking the time! As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI. Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()? But I'm not completely sure.

Speed 40

Speed Java AWS Virtualization 40

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level.

Best Practices 40

Best Practices Scalability Performance C++ 40

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. Statistics.

Servers 49

Servers Azure Hardware Database 49

Percona

JULY 26, 2023

When you have multiple copies of your data on different database servers — or even better, in different data centers worldwide — replication provides a high level of fault tolerance in case of a disaster. It is best practice to have an odd number of replica set members to maintain voting quorum.

Database 83

Database Servers Storage Strategy 83

Percona

AUGUST 5, 2023

Each partition holds data that falls within a specific range, optimizing data handling and query speed. KEY partitioning KEY partitioning is similar to HASH partitioning, except that only one or more columns to be evaluated are specified, and the MySQL server provides its own hashing function. Additionally, MySQL 8.0

Strategy 40

Strategy Storage Database Best Practices 40

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

CSS - Tricks

AUGUST 18, 2020

Even if you render components on the server and hydrate them on the client, it still churns because component hydration is computationally expensive. When even a bit of React can be a problem on devices slow and fast alike, using it is an intentional choice that effectively excludes people with low-end hardware. I think JSX is great.

Performance 101

Performance Mobile Servers Code 101

Smashing Magazine

MAY 20, 2020

This metric shows how much time it takes for the server to respond with something. This metric is important, but quite vague because it can include anything — starting from server rendering time and ending up with latency problems. There are performance score, a11y score, best practices score, SEO score.

Performance 98

Performance Metrics Best Practices Code 98

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”. 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). and prior (a)).

Performance 105

Performance Network Latency Servers 105

Smashing Magazine

APRIL 29, 2021

From Speed at Scale with Katie Hempenius and I at Google I/O. The sizes attribute specifies a set of conditions, such as screen widths, and what image size is best to select when those conditions are met. Device Pixel Ratio (DPR) represents how a CSS pixel is translated to physical pixels on a hardware screen. Large preview ).

Media 145

Media Network Metrics Mobile 145

Smashing Magazine

JANUARY 11, 2021

You need a business stakeholder buy-in, and to get it, you need to establish a case study, or a proof of concept using the Performance API on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about. Note : If you use Page Speed Insights or Page Speed Insights API (no, it isn’t deprecated!),

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? Is it expensive JavaScript, slow web font delivery, heavy images, or sluggish rendering? Large preview ).

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? Start Render time, Speed Index ). Rendering metrics provide an estimate of how fast content renders (e.g.

Performance 103

Performance Cache Metrics Network 103