Scalegrid

DECEMBER 14, 2023

How the MongoDB timeout is set up can significantly affect your application’s performance, no matter if you are an experienced MongoDB user or just starting with NoSQL databases. Typical applications are interacting with different database servers based on the business logic. Modifying this setting does affect performance.

Java 130

Java Network Servers Database 130

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()? This will slow this test a little.)

Speed 52

Speed Java AWS Virtualization 52

Percona

MARCH 29, 2023

Compression in any database is necessary as it has many advantages, like storage reduction, data transmission time, etc. So, it becomes very important to test for the optimal required use case before implementing it in production. Here, we are going to test snappy and zstd compression with the following configurations.

Storage 106

Storage Network Open Source Latency 106

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()? This will slow this test a little.)

Speed 40

Speed Java AWS Virtualization 40

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. Query performance Query performance is a key performance indicator (KPI) in MySQL, as it measures the efficiency and speed of query execution.

Performance 102

Performance Monitoring Traffic Database 102

Dynatrace

JANUARY 31, 2024

In the age of AI, data observability has become foundational and complementary to AI observability, data quality being essential for training and testing AI models. An erroneous change in the database system leads to a subset of the data being categorized incorrectly.

DevOps 188

DevOps Analytics Airlines Metrics 188

IO River

NOVEMBER 2, 2023

But remember, static content trades off real-time personalization for speed and consistency, lacking in dynamic interactivity.Static content and CDNs are a power duo, delivering your site's unvarying elements at unparalleled speed.Pros and Cons of Static ContentPros of Static Content:Caching Benefits: Static content is highly cacheable.

Cache 52

Cache Social Media Website Performance Website 52

Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Storage The type of storage and disk used for database servers can have a significant impact on performance and reliability. Benchmark before you decide.

Performance 124

Performance Hardware Tuning Storage 124

Percona

JANUARY 24, 2023

There will be a considerable gain if we combine this with other sets of great improvements in WAL archiving in PostgreSQL 15, as discussed in previous posts New WAL Archive Module/Library in PostgreSQL 15 and Speed Up of the WAL Archiving in PostgreSQL 15. Such “torn pages” are corruptions from the database point of view.

Database 115

Database Benchmarking Open Source Latency 115

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. So to test I took a system with Skylake CPUs and all storage on a P4800X SSD. In the recent MySQL 8.0.16

Testing 48

Testing Tuning Latency Storage 48

IO River

NOVEMBER 2, 2023

But remember, static content trades off real-time personalization for speed and consistency, lacking in dynamic interactivity.Static content and CDNs are a power duo, delivering your site's unvarying elements at unparalleled speed.Pros and Cons of Static ContentPros of Static Content:Caching Benefits: Static content is highly cacheable.

Cache 52

Cache Social Media Website Performance Website 52

The Morning Paper

FEBRUARY 6, 2020

On the Cloudburst design teams’ wish list: A running function’s ‘hot’ data should be kept physically nearby for low-latency access. Cross-function communication should work at wire speed. Only now the database is itself a distributed KVS, and the slices of application functionality are much finer-grained.

Serverless 98

Serverless Lambda Cache Latency 98

Dotcom-Montior

MAY 12, 2020

Web monitoring is a comprehensive term that describes the activity of testing a website or web application for its availability and performance. HTTP monitoring allows you to test availability and performance from around the world. To overcome those intimidating errors, frequent automated and real-time tests should be made.

Monitoring 63

Monitoring Entertainment Hardware Latency 63

Particular Software

SEPTEMBER 20, 2021

Sometimes developers only care about speed. Some will claim that any type of RPC communication ends up being faster (meaning it has lower latency) than any equivalent invocation using asynchronous messaging. There are more steps, so the increased latency is easily explained. But the answer isn’t that simple.

Benchmarking 97

Benchmarking Latency Servers Systems 97

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. So lets take an Ubuntu system with Platinum 8280 CPUs with the following Ubuntu OS, reboot and check the CPU configuration before running any tests. uname -a Linux ubuntu19 5.3.0-rc3-custom

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Alex Russell

MAY 9, 2022

This is a complex topic, but to borrow from a recent post , web performance expands access to information and services by reducing latency and variance across interactions in a session, with a particular focus on the tail of the distribution (P75+). Consistent performance matters just as much as low average latency.

Performance 86

Performance Latency Metrics Engineering 86

Particular Software

JUNE 3, 2019

We become annoyed when we run a speed test on our broadband provider only to find that, on a good day, we are getting maybe half of the rated download speed we are paying for, and the upload speed is likely much worse. Disks, including those used by our databases, have bandwidth limitations as well.

Latency 40

Latency Speed Network Strategy 40

HammerDB

OCTOBER 8, 2018

This post gives a HOWTO guide on system configuration for achieving top levels of performance with the HammerDB PostgreSQL TPC-C test. maximum transition latency: Cannot determine or is not supported. Latency: 0. T his creates your database with the username of the OS user you are using as the superuser. Usage: 10736.

Best Practices 40

Best Practices Scalability Performance Hardware 40

Alex Russell

MARCH 6, 2021

Recall that single-core performance most directly translates into speed on the web. OpenSignal's global report on connection speeds ( pdf ) suggest that WebPageTest's default 4G configuration (9Mbps w/ 170ms RTT) is a reasonable stand-in for the P75 network link. Updated Geekbench 4 single-core scores for each mobile price-point."

Performance 124

Performance Network Cache Metrics 124

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. Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. HammerDB difference from Sysbench. 10 rows in set (0.02

Best Practices 40

Best Practices Scalability Performance C++ 40

Smashing Magazine

JANUARY 6, 2020

Testing And Monitoring. 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. You can then mimic the 90th percentile’s experience for testing. Quick Wins.

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 7, 2019

Testing And Monitoring. You need a business stakeholder buy-in, and to get it, you need to establish a case study on how speed benefits metrics and Key Performance Indicators ( KPIs ) they care about. You can then mimic the 90th percentile’s experience for testing. Now you have something measurable to test against.

Performance 104

Performance Cache Metrics Network 104

SQL Server According to Bob

SEPTEMBER 26, 2016

Performance issues surrounding Availability Groups typically were related to disk I/O or network speeds. Our customers who deployed Availability Groups were now using servers for primary and secondary replicas with 12+ core sockets and flash storage SSD arrays providing microsecond to low millisecond latencies. one without a replica).

Availability 40

Availability Servers Hardware Benchmarking 40

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40

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

All Things Distributed

JUNE 21, 2017

Today, I'm excited to announce the general availability of Amazon DynamoDB Accelerator (DAX) , a fully managed, highly available, in-memory cache that can speed up DynamoDB response times from milliseconds to microseconds, even at millions of requests per second. DynamoDB was the first service at AWS to use SSD storage.

Speed 121

Speed Cache Latency AWS 121

The Netflix TechBlog

MARCH 6, 2019

In addition to improving download speed, this is useful for cutting down on cross-region transfer costs when many workers will be processing the same data?—?we in Atlas , Netflix’s in-memory dimensional time series database. While large buffer sizes speed up sequential data access, they can slow down “sparse” data access?—?that

Media 214

Media Storage Processing Cache 214