Percona

SEPTEMBER 1, 2023

This results in expedited query execution, reduced resource utilization, and more efficient exploitation of the available hardware resources. This reduction in latency ensures that applications and websites provide a more rapid and responsive user experience. To maximize indexing benefits, be sure to follow best practices.

Tuning 52

Tuning Database Performance Hardware 52

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 exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance. current CPU frequency: 1.99

Best Practices 40

Best Practices Scalability Performance C++ 40

Percona

JUNE 22, 2023

There are multiple tables MySQL internal system manages that come in handy, identifying the inefficient indexes, to name a few: sys.schema_unused_indexes, and information_schema.index_statistics. It is advisable to have a dedicated production MySQL Server that can independently claim the system resources as needed.

Performance 106

Performance Monitoring Traffic Database 106

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI.

Speed 126

Speed Java AWS Virtualization 126

HammerDB

OCTOBER 18, 2019

Nevertheless in this blog sometimes we do publish performance data to highlight best practices or potential configuration pitfalls and although we’ve mentioned this one before it is worth dedicating an entire post to it as this issue seems to appear numerous times running database workloads on Linux. uname -a Linux ubuntu19 5.3.0-rc3-custom

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI.

Speed 52

Speed Java AWS Virtualization 52

Abhishek Tiwari

JULY 12, 2018

In a nutshell, a data pipeline is a distributed system. A data pipeline is a software which runs on hardware. The software is error-prone and hardware failures are inevitable. Your best shot is proactive capacity planning and better resources utilisation by removing inefficiencies.

Latency 63

Latency Analytics Scalability Engineering 63

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. CLI tools The Cassandra systems were EC2 virtual machine (Xen) instances. As a Xen guest, this profile was gathered using perf(1) and the kernel's software cpu-clock soft interrupts, not the hardware NMI.

Speed 40

Speed Java AWS Virtualization 40

Testsigma

JANUARY 30, 2021

As mobile phones are readily available, users try to open that particular application on a mobile web browser, instead of signing into their systems and hitting the URL. Each smartphone comes with various screen sizes and resolutions, operates on different network speeds, and has different hardware capabilities.

Mobile 52

Mobile Testing Website Internet 52

Smashing Magazine

MAY 20, 2020

This metric is important, but quite vague because it can include anything — starting from server rendering time and ending up with latency problems. Let’s write a script that allows us to measure performance, a11y, best practices, and provide us with an SEO score. title, value: report.categories['best-practices'].score,

Performance 98

Performance Metrics Best Practices Code 98

SQL Server According to Bob

JANUARY 11, 2020

​​ Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Servers 40

Servers Cache Database Media 40

Smashing Magazine

JANUARY 7, 2019

Estimated Input Latency tells us if we are hitting that threshold, and ideally, it should be below 50ms. For high-pressure points like animation, it’s best to do nothing else where you can and the absolute minimum where you can't. From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19).

Performance 103

Performance Cache Metrics Network 103

Smashing Magazine

JANUARY 6, 2020

Estimated Input Latency tells us if we are hitting that threshold, and ideally, it should be below 50ms. For high-pressure points like animation, it’s best to do nothing else where you can and the absolute minimum where you can't. From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19).

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 11, 2021

Estimated Input Latency tells us if we are hitting that threshold, and ideally, it should be below 50ms. For high-pressure points like animation, it’s best to do nothing else where you can and the absolute minimum where you can't. From Fast By Default: Modern loading best practices by Addy Osmani (Slide 19).

Performance 145

Performance Cache Media Metrics 145

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