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 40

Database Tuning Performance AWS 40

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 81

Cache Engineering Storage Speed 81

Scalegrid

MARCH 28, 2024

Introduction Caching serves a dual purpose in web development – speeding up client requests and reducing server load. This article will explore how they handle data storage and scalability, perform in different scenarios, and, most importantly, how these factors influence your choice.

Cache 130

Cache Storage Scalability Architecture 130

Percona

MARCH 23, 2023

Storage The type of storage and disk used for database servers can have a significant impact on performance and reliability. Benchmark before you decide. Cloud Different cloud providers offer a range of instance types and sizes, each with varying amounts of CPU, memory, and storage. Transparent huge pages (THP) disabled.

Performance 129

Performance Hardware Tuning Storage 129

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

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

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

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 62

Benchmarking Open Source C++ Cache 62

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 296

Latency Transportation Engineering Traffic 296

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 120

Database Benchmarking Open Source Latency 120

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

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

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

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

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

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

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 124

Performance Network Cache Metrics 124

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 79

Cache Website Servers Open Source 79

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

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 68

Performance Benchmarking Network Mobile 68

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

Percona

NOVEMBER 3, 2023

xlarge 4vCPU 8GB-RAM Storage: EBS volume (root) 80GB gp2 (IOPS 240/3000) As well, high availability will be integrated, guaranteeing cluster viability in the case that one worker node goes down. And now, execute the benchmark: -- execute the following on the coordinator node pgbench -c 20 -j 3 -T 60 -P 3 pgbench The results are not pretty.

Database 109

Database Benchmarking Latency C++ 109

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

​​ 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

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

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 145

Performance Cache Network Metrics 145