John McCalpin

APRIL 25, 2023

For most high-end processors these values have remained in the range of 75% to 85% of the peak DRAM bandwidth of the system over the past 15-20 years — an amazing accomplishment given the increase in core count (with its associated cache coherence issues), number of DRAM channels, and ever-increasing pipelining of the DRAMs themselves.

Benchmarking 97

Benchmarking Cache Latency Tuning 97

The Morning Paper

SEPTEMBER 24, 2020

Static analysis of Java enterprise applications: frameworks and caches, the elephants in the room , Antoniadis et al., This means for example that it can be applied to analyse source code repositories and pull requests, be used as an additional test in CI pipelines, and even give assistance in your IDE if it’s fast enough.

Java 80

Java Cache Benchmarking Programming 80

Abhishek Tiwari

SEPTEMBER 26, 2014

Setting up Varnish for Statamic was quite easy and my website performance improved drastically ( you can see load and performance testing benchmarks here ). One of the biggest challenges was Varnish cache invalidation on content update.

Cache 52

Cache Benchmarking Website Performance Website 52

Brendan Gregg

JUNE 30, 2018

These have inspired me to summarize another performance activity: evaluating benchmark accuracy. Accurate benchmarking rewards engineering investment that actually improves performance, but, unfortunately, inaccurate benchmarking is more common. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec?

Benchmarking 47

Benchmarking Latency Cache Network 47

Brendan Gregg

MARCH 16, 2024

Only in extreme circumstances does the cost (in processor time and I-cache footprint) translate to a tangible benefit - circumstances which usually resort to hand-coded assembly anyway. It shouldn't be 10%, unless it's cache effects. And for leaf routines (which never establish a frame), this is a non-issue.

Java 137

Java Cache Google Hardware 137

Percona

JUNE 22, 2023

This includes metrics such as query execution time, the number of queries executed per second, and the utilization of query cache and adaptive hash index. query cache: Disable (query_cache_size: 0, query_cache_type:OFF) innodb_adaptive_hash_index: Check adaptive hash index usage to determine its efficiency.

Performance 135

Performance Monitoring Traffic Database 135

Percona

MARCH 17, 2023

We have tested PMM version 2.33.0 Please note that the focus of these tests was around standard metrics gathering and display, we’ll use a future blog post to benchmark some of the more intensive query analytics (QAN) performance numbers. The CPU usage averaged 24% utilization, as you can see in the above picture.

Monitoring 117

Monitoring Scalability Database Cache 117

Percona

JULY 25, 2023

After the “data dictionary” (DD) engine and DD cache are initialized on a server, the Storage Engines can ask for a table definition. Initializing a DD engine and the cache adds complexity and other server dependencies. ibd in the test directory. For example, mysql datadir/test/t1.ibd. ibd2sdi data/test/t1.ibd

Cache 98

Cache Servers Benchmarking Design 98

Brendan Gregg

JUNE 29, 2018

These have inspired me to summarize another performance activity: evaluating benchmark accuracy. Accurate benchmarking rewards engineering investment that actually improves performance, but, unfortunately, inaccurate benchmarking is more common. If the benchmark reported 20k ops/sec, you should ask: why not 40k ops/sec?

Benchmarking 40

Benchmarking Latency Cache Network 40

SQL Performance

NOVEMBER 18, 2019

Memory optimized – High memory-to-CPU ratio, relational database servers, medium to large caches, and in-memory analytics. The common trend is to choose a VM based exclusively on vCPU, memory, and storage capacity without benchmarking the current IO and throughput requirements. I put each of these VMs to a test using CrystalDiskMark.

Azure 76

Azure Benchmarking Storage Virtualization 76

Dotcom-Montior

AUGUST 5, 2020

Running a website speed test can help to determine what factors may be slowing your pages down. There are tools available such as Dotcom-Monitor’s free speed test that you can utilize to gauge performance. The tool gives you the option to run a speed test from 25 locations around the world. Optimize Your Pages.

Website 92

Website Speed Cache Traffic 92

MachMetrics

DECEMBER 14, 2019

It is typically reduced via server-side optimizations, such as enabling caching and database indexes. How do you test your site against the best practices? Now that we know where the average website falls, it’s time for you to test your own site. Even better if you’re under Google’s best practice benchmark.

Best Practices 105

Best Practices Speed Mobile Google 105

Percona

MARCH 20, 2023

When deciding what to pick, there are many things to consider, like where the proxy needs to be, if it “just” needs to redirect the connections, or if more features need to be in, like caching and filtering, or if it needs to be integrated with some MySQL embedded automation. micro) The tests We will have very simple test cases.

Games 141

Games Latency Traffic Cache 141

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. The Transaction Processing Performance Council (TPC) was founded to bring standards to database benchmarking, and the history of the TPC can be found here.

Benchmarking 63

Benchmarking Open Source C++ Cache 63

The Morning Paper

AUGUST 29, 2019

use the TPC-H benchmark to assess Redshift, Redshift Spectrum, Athena, Presto, Hive, and Vertica to find out what works best and the trade-offs involved. As it is infeasible to test every OLAP system runnable on AWS, we chose widely-used systems that represented a variety of architectures and cost models. Key findings.

Architecture 76

Architecture Cloud Storage Serverless 76

ScaleOut Software

MAY 15, 2014

Given all this, we thought it would be a good opportunity to see how we are doing relative to the competition, and in particular, relative to Microsoft’s AppFabric caching for Windows on-premise servers. Testing Scale-Up Performance. So our comments will be confined to what testing we felt was valuable and how well SOSS performed.

Cache 40

Cache Servers Network Design 40

Percona

AUGUST 31, 2018

This parameter sets how much dedicated memory will be used by PostgreSQL for cache. If your working set of data can easily fit into your RAM, then you might want to increase the shared_buffer value to contain your entire database, so that the whole working set of data can reside in cache. wal_buffers. effective_cache_size.

Tuning 79

Tuning Database Performance Benchmarking 79

n0derunner

JULY 23, 2019

In this video I migrate a Postgres DB running PGbench benchmark. The variation in the transaction rate is due to the benchmark itself, the transaction rate is not expected to be uniform. Many different queries are executing in parallel, some hitting RAM cache, some hitting storage.

Benchmarking 76

Benchmarking Storage Cache Tuning 76

Percona

MARCH 23, 2023

By caching hot datasets, indexes, and ongoing changes, InnoDB can provide faster response times and utilize disk IO in a much more optimal way. Benchmark before you decide. The optimal value can be decided after testing multiple settings, starting from eight is a good choice. Transparent huge pages (THP) disabled.

Performance 144

Performance Hardware Tuning Storage 144

John McCalpin

SEPTEMBER 11, 2014

The High Performance LINPACK (HPL) benchmark is well known for delivering a high fraction of peak floating-point performance. A colleague here at TACC ran into this while testing on a 2-socket Haswell EP system. But this does not mean that memory bandwidth will *never* be a performance limiter.

Benchmarking 40

Benchmarking Cache Performance Systems 40

Percona

SEPTEMBER 1, 2023

Testing and Validation : Thorough testing and validation are essential when working with triggers, especially in a production environment. Changes to triggers should be carefully reviewed and tested to ensure they do not introduce unintended consequences. for i in `seq 1 1 16`; do mysql test -e "SELECT * FROM tc_test"; done.

Cache 75

Cache Database Games Healthcare 75

Brendan Gregg

FEBRUARY 9, 2018

Much of my testing was on Linux 4.14.11 This overhead can be reduced by A) pcid, fully available in Linux 4.14, and B) Huge pages. - **Cache access pattern**: the overheads are exacerbated by certain access patterns that switch from caching well to caching a little less well. and 4.14.12 In more detail: ## 1. DTLB and 4.4%

Performance 72

Performance Benchmarking Cache Tuning 72

John McCalpin

APRIL 2, 2020

To show that I can criticize my own work as well, here I show that sustained memory bandwidth (using an approximation to the STREAM Benchmark ) is also inadequate as a single figure of metric. (It Here I assumed a particular analytical function for the amount of memory traffic as a function of cache size to scale the bandwidth time.

Benchmarking 59

Benchmarking Performance Latency Architecture 59

Alex Russell

APRIL 29, 2021

As an engineer on a browser team, I'm privy to the blow-by-blow of various performance projects, benchmark fire drills, and the ways performance marketing (deeply) impacts engineering priorities. With each team, benchmarks lost are understood as bugs. All modern browsers are fast, Chromium and Safari/WebKit included. Lower is better.

Media 145

Media Games Education Engineering 145

HammerDB

APRIL 19, 2023

Therefore, before we attempt to measure our database performance, we should know the system or cloud instance to be tested in detail. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench. This allows us to know our operating environment and its capability. 4.22 %usr 38.40

Performance 55

Performance Benchmarking Cache Storage 55

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.

Performance 127

Performance Network Mobile Metrics 127

Smashing Magazine

JUNE 26, 2019

Instead, I suggest that web designers use another Google testing tool called Test My Site. Test My Site is a mobile page speed testing tool from Think with Google. Source: Test My Site ) ( Large preview ). All you need to do is enter your domain name into the field and let the test run. Minification.

Website 111

Website Speed Mobile Design 111

Smashing Magazine

JUNE 1, 2022

You’ve tested and retested the site for errors. You can adjust what browser is used, the kind of network connection to employ, the locations to test from, whether or not the browser’s cache is empty or full, how frequently to take the measurements, and more. Testing The Impact Of Specific Requests. Large preview ).

Website 138

Website Design Network Testing 138

Percona

JANUARY 9, 2023

NOTE : All tests were applied for MySQL version 8.0.30, and in the background, I ran every query three to five times to make sure that all of them were fully cached in the buffer pool (for InnoDB) or by the filesystem (for MyISAM). But why we can’t just cache the actual number of the rows? sec) What flash speed we saw there!

Cache 107

Cache Engineering Storage Speed 107

Speed Curve

DECEMBER 13, 2023

Background For this performance audit, I looked at this synthetic test for the LEGO.com home page. (We We track LEGO.com, along with a handful of other leading ecommerce sites, in our public-facing Retail Benchmarks dashboard , which I encourage you to check out. Are you compressing and caching the right things?

Performance 78

Performance Retail Benchmarking Ecommerce 78

CSS - Tricks

JUNE 5, 2020

The service categorized all the optimizations in three groups consisting of several “Content,” “Delivery,” and “Cache” optimizations. In my benchmarks, Brotli:11 takes several hundred milliseconds to compress a single minified jQuery file. We only cache hot files in memory at edge servers. Luckily we already had that in place.

Cache 83

Cache Website Servers Open Source 83

n0derunner

SEPTEMBER 17, 2018

Creating a HCI benchmark to simulate multi-tennent workloads. We supply a pre-configured scenario which we call the DB Colocation test. The DB Colocation test utilizes two properties of X-Ray not found in other benchmarking tools. Time based benchmark actions. Distinct per-VM workload patterns.

Performance Testing 40

Performance Testing Benchmarking Testing Performance 40

n0derunner

MAY 6, 2019

A 2007 paper, that still has lots to say on the subject of benchmarking storage and filesystems. Primarily aimed at researchers and developers, but is relevant to anyone about to embark on a benchmarking effort. A Nine year study of filesystem and storage benchmarking Download. The post New (Old) Paper.

Benchmarking 40

Benchmarking Storage Cache Testing 40

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. SQL> alter system flush buffer_cache; System altered.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

Percona

JUNE 22, 2023

” Here are additional metrics used to determine the reliability of a database, make adjustments that minimize downtime, and set benchmarks for meeting business continuity requirements. Each node has its own cache buffer.) E2E testing verifies that components meet performance, security, and usability requirements.

Availability 132

Availability Database Open Source Hardware 132

KeyCDN

DECEMBER 8, 2022

Many factors affect the speed of your WordPress website; some of them are: Your web host Server-side optimizations (PHP version, compression, caching, etc.) Page loading speed test Before conducting any further tests, a website owner must determine at what speed his website loads. So let's discuss the process one step at a time.

Cache 52

Cache Website Speed Website Performance 52

Alex Russell

OCTOBER 22, 2017

Budgets are scaled to a benchmark network & device. Automating testing against an objective baseline. Deciding what benchmark to use for a performance budget is crucial. Simulated packet loss and variable latency, however, can make benchmarking extremely difficult and slow. What’s going on here?

Performance 74

Performance Network Benchmarking Mobile 74