Scalegrid

JANUARY 12, 2024

Storage is a critical aspect to consider when working with cloud workloads. High availability storage options within the context of cloud computing involve highly adaptable storage solutions specifically designed for storing vast amounts of data while providing easy access to it. This also aids scalability down the line.

Cloud 130

Cloud Virtualization Storage Efficiency 130

Scalegrid

JANUARY 25, 2024

Key metrics like throughput, request latency, and memory utilization are essential for assessing Redis health, with tools like the MONITOR command and Redis-benchmark for latency and throughput analysis and MEMORY USAGE/STATS commands for evaluating memory. In addition, distributed data is a key factor in high availability.

Metrics 130

Metrics Monitoring Latency Cache 130

Particular Software

SEPTEMBER 20, 2021

Sometimes developers only care about speed. Why RPC is “faster” It’s tempting to simply write a micro-benchmark test where we issue 1000 requests to a server over HTTP and then repeat the same test with asynchronous messages. But that’s just a micro-benchmark and doesn’t tell you the whole story. Messaging doesn’t do that.

Benchmarking 97

Benchmarking Latency Servers Systems 97

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

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. But this comes with a considerable performance implication.

Database 142

Database Benchmarking Open Source Latency 142

n0derunner

OCTOBER 5, 2020

How to speed up your X-ray benchmark development cycle by re-using/re-cycling benchmark VMs and more importantly data-sets. Assuming we have enough storage bandwidth, the throughput. Problem: For large datasets, creating the data on-disk can be time consuming.

Benchmarking 52

Benchmarking Storage Speed Development 52

SQL Performance

DECEMBER 17, 2019

This removes the burden of purchasing and maintaining your hardware, storage and networking infrastructure, while still giving you a very familiar experience with Windows and SQL Server itself. There are also large differences in storage capacity and throughput between these extremes.

Azure 72

Azure Virtualization Servers Storage 72

HammerDB

APRIL 19, 2023

As database performance is heavily influenced by the performance of storage, network, memory, and processors, we must understand the upper limit of these key components. For storage, FIO is generally used. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench. 0.42 %sys 9.52

Performance 55

Performance Benchmarking Cache Storage 55

HammerDB

JUNE 27, 2022

This post is targeted towards the questions most often asked by non-technical management who want to get up to speed on what HammerDB is (what it isn’t) and how it can benefit their organization. HammerDB is a software application for database benchmarking. What is HammerDB? Derived Workloads. The NOPM Metric.

Benchmarking 63

Benchmarking Open Source C++ Cache 63

Percona

JANUARY 9, 2023

You might want to use columns that already have an index to speed up the query for huge tables. sec) What flash speed we saw there! Please, pay attention to the difference between engines: InnoDB is a transaction engine, and MyISAM is a non-transactional storage engine. Will we have any surprises with COUNT(val_with_nulls)?

Cache 106

Cache Engineering Storage Speed 106

SQL Performance

APRIL 8, 2019

Back on December 5, 2017, Microsoft announced that they were using AMD EPYC 7551 processors in their storage-optimized Lv2-Series virtual machines. This processor has a base clock speed of 2.0GHz, with an all-core boost speed of 2.55GHz, and a max boost clock speed of 3.0GHz. Figure 1: CPU-Z Benchmark Results for LS16v2.

Azure 42

Azure Virtualization Storage Benchmarking 42

Percona

DECEMBER 20, 2018

As the MyRocks storage engine (based on the RocksDB key-value store [link] ) is now available as part of Percona Server for MySQL 5.7 , I wanted to take a look at how it performs on a relatively high-end server and SSD storage. How to Restore MySQL Logical Backup at Maximum Speed. How to Speed Up Pattern Matching Queries.

Database 46

Database Tuning Performance AWS 46

SQL Performance

AUGUST 27, 2019

The initial reviews and benchmarks for these processors have been very impressive: AMD EPYC 7002 Series Rome Delivers a Knockout. AMD Rome Second Generation EPYC Review: 2x 64-core Benchmarked. TPC-H Benchmark Results with SQL Server 2017. TPC-E Benchmark Results with SQL Server 2017. Higher memory speed and bandwidth.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Alex Russell

OCTOBER 22, 2017

Budgets are scaled to a benchmark network & device. JavaScript is the single most expensive part of any page in ways that are a function of both network capacity and device speed. Deciding what benchmark to use for a performance budget is crucial. Performance budgets are set early in the life of the project.

Performance 74

Performance Network Benchmarking Mobile 74

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. Why is PostgreSQL performance tuning important?

Tuning 52

Tuning Database Efficiency Performance 52

CSS - Tricks

JUNE 5, 2020

The HBO sitcom Silicon Valley hilariously followed Pied Piper, a team of developers with startup dreams to create a compression algorithm so powerful that high-quality streaming and file storage concerns would become a thing of the past. I had several tricks that could significantly speed up websites. Taking matters into my own hands.

Cache 83

Cache Website Servers Open Source 83

SQL Server According to Bob

SEPTEMBER 26, 2016

When we released Always On Availability Groups in SQL Server 2012 as a new and powerful way to achieve high availability, hardware environments included NUMA machines with low-end multi-core processors and SATA and SAN drives for storage (some SSDs). This chart shows our scaled results using a OLTP workload derived from TPC benchmarks.

Availability 40

Availability Servers Hardware Benchmarking 40

Percona

SEPTEMBER 1, 2023

Enhanced User Experience Whether you operate an e-commerce platform, a content management system, or any other application reliant on MySQL, users will notice and appreciate the improved speed and responsiveness. By analyzing disk I/O metrics, you can optimize queries to reduce disk reads or upgrade to faster storage solutions.

Tuning 52

Tuning Database Performance Hardware 52

Percona

AUGUST 5, 2023

Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. Each partition holds data that falls within a specific range, optimizing data handling and query speed. This method distributes data evenly across partitions to achieve balanced storage and optimal query performance.

Strategy 40

Strategy Storage Database Best Practices 40

n0derunner

MARCH 30, 2020

Installing Disk-Speed (diskspd). Get diskpd binary from Microsft : [link] Manual is here: [link] Agree to License Extract Zip file (DocumentsDiskspd-2.0.21a) open Terminal/Command Prompt cd to the Extracted directory cd to AMD64 Overview diskspd operates on windows filesystems, and will read / write to one or more files concurrently.

Testing 52

Testing Speed Storage Benchmarking 52

n0derunner

MARCH 30, 2020

Installing Disk-Speed (diskspd). Get diskpd binary from Microsft : [link] Manual is here: [link] Agree to License Extract Zip file open Terminal/Command Prompt cd to the Extracted directory cd to AMD64 Overview diskspd operates on windows filesystems, and will read / write to one or more files concurrently.

Testing 52

Testing Speed Storage Benchmarking 52

HammerDB

OCTOBER 12, 2018

As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. InnoDB is the storage engine that will deliver the best OLTP throughput and should be chosen for this test. . This is to be expected and is due to the limitations of the scalability of the storage engine.

Best Practices 40

Best Practices Scalability Performance C++ 40

n0derunner

NOVEMBER 9, 2018

We see often see this sort of test in bake-offs, and such a test does answer an important question – “what’s the lowest possible response time I can expect from the storage” However, this test only gives a single data point. The single VM test is using only a fraction of the cluster capacity.

Performance Testing 40

Performance Testing Testing Performance Storage 40

SQL Server According to Bob

JANUARY 11, 2020

Stable Media Stable media is often confused with physical storage. SQL Server defines stable media as storage that can survive system restart or common failure. Stable media is commonly physical disk storage, but other devices and certain caching facilities qualify as well. See the article for more details. SQL Server 7.0

Servers 40

Servers Cache Media Hardware 40

The Netflix TechBlog

SEPTEMBER 2, 2020

This difference has substantial technological implications, from the classification of what’s interesting to transport to cost-effective storage (keep an eye out for later Netflix Tech Blog posts addressing these topics). As you can imagine, this comes with very real storage costs. Is this an anomaly or are we dealing with a pattern?

Latency 298

Latency Transportation Engineering Traffic 298

Smashing Magazine

SEPTEMBER 28, 2022

On your first try, you can use it as a benchmark for optimizations later. Caching partially stores your data and is not used as permanent storage. Using the cache as permanent storage is an anti-pattern. Data-loading patterns are one way you can optimize your applications’ speed.

Cache 141

Cache Performance Servers Architecture 141

Alex Russell

MARCH 6, 2021

A then-representative $200USD device had 4-8 slow (in-order, low-cache) cores, ~2GiB of RAM, and relatively slow MLC NAND flash storage. Using a global ASP as a benchmark can further mislead thanks to the distorting effect of ultra-high-end prices rising while shipment volumes stagnate. The Moto G4 , for example. How bad is it?

Performance 127

Performance Network Mobile Metrics 127

SQL Server According to Bob

JANUARY 11, 2020

​​ The storage ​​ space that is required ​​ for the sparse file is only that of the actual bytes written to the file and not the ​​ maximum ​​ file ​​ size.

Servers 40

Servers Cache Database Media 40

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

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. Start Render time, Speed Index ). Treo Sites provides competitive analysis based on real-world data.

Performance 112

Performance Cache Servers Network 112

High Scalability

NOVEMBER 25, 2019

It is limited by the disk space; it can’t expand storage elastically; it chokes if you run few I/O intensive processes or try collaborating with 100 other users. Over time, costs for S3 and GCS became reasonable and with Egnyte’s storage plugin architecture, our customers can now bring in any storage backend of their choice.

Architecture 52

Architecture Cache Azure Storage 52