n0derunner

JULY 23, 2019

Effect of removing CPU constraints and maintaining data locality on a running DB instance. In this video I migrate a Postgres DB running PGbench benchmark. As the DB continues to run on the new host – the Nutanix storage detects the access patterns and “localizes” the data that the DB is accessing.

Benchmarking 76

Benchmarking Storage Tuning Cache 76

Scalegrid

MARCH 28, 2024

In this comparison of Redis vs Memcached, we strip away the complexity, focusing on each in-memory data store’s performance, scalability, and unique features. Redis is better suited for complex data models, and Memcached is better suited for high-throughput, string-based caching scenarios.

Cache 130

Cache Storage Scalability Architecture 130

The Morning Paper

MAY 23, 2019

Compress objects, not cache lines: an object-based compressed memory hierarchy Tsai & Sanchez, ASPLOS’19. Existing cache and main memory compression techniques compress data in small fixed-size blocks, typically cache lines. ” The big idea. Implications. This is where Hotpads comes in.

Cache 61

Cache Benchmarking Hardware Java 61

The Morning Paper

MARCH 10, 2020

Characterizing, modeling, and benchmarking RocksDB key-value workloads at Facebook , Cao et al., Or in the case of key-value stores, what you benchmark. So if you want to design a system that will offer good real-world performance, it’s really useful to have benchmarks that accurately represent real-world workloads.

Benchmarking 59

Benchmarking Storage Cache Open Source 59

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

Percona

MARCH 27, 2023

Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark. having to open each table.frm (and in which my test runs, I have purposely read a very high number of tables compared to “Table-open-cache” variable). Results for Percona Server for MySQL 8.0 While you are on 5.7,

Cache 124

Cache Hardware Servers Benchmarking 124

The Morning Paper

SEPTEMBER 24, 2020

Static analysis of Java enterprise applications: frameworks and caches, the elephants in the room , Antoniadis et al., All that framework and configuration code makes for very heavy use of generic, heterogeneous data structures! PLDI’20. Static analysis is a key component of many quality and security analysis tools.

Java 80

Java Cache Benchmarking Programming 80

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

Percona

JUNE 22, 2023

Database uptime and availability Monitoring database uptime and availability is crucial as it directly impacts the availability of critical data and the performance of applications or websites that rely on the MySQL database. Disk space usage Monitor the disk space usage of MySQL data files, log files, and temporary files.

Performance 136

Performance Monitoring Traffic Database 136

Brendan Gregg

MARCH 16, 2024

It fails because of a compiler optimization where the frame pointer register is used to store data instead of the frame pointer, but it's just a number so the profiler is unaware this happened and tries to match that address to a function symbol and fails (it is therefore an unknown symbol). You usually get an extra junk frame.

Java 137

Java Cache Google Hardware 137

Smashing Magazine

AUGUST 9, 2022

It can be measured based on real data from users visiting your sites ( field metric ) or in a lab environment ( lab metric ). PageSpeed Compare is a page speed evaluation and benchmarking tool. PageSpeed Compare measures vitals like FCP, LCP, FID, CLS, and others using land and field data. PageSpeed Compare. Large preview ).

Performance 134

Performance Benchmarking Website Metrics 134

Percona

JULY 25, 2023

When a new node joins the cluster, SST is performed to receive the data from DONOR to the JOINER. JOINER uses PXB to stream the data directory from DONOR. Percona XtraBackup copies the InnoDB data files. Percona XtraBackup copies the InnoDB data files. ibd2sdi data/test/t1.ibd ibd2sdi data/test/t1.ibd

Cache 98

Cache Servers Benchmarking Design 98

Adrian Cockcroft

SEPTEMBER 23, 2024

Most publications have simply reported the benchmark improvement claims, but if you stop to think about them, the numbers dont make sense based on a simplistic view of the technology changes. So first thing to understand is that the benchmark skips a generation and compares product that differs over about a two year interval.

Benchmarking 52

Benchmarking Energy Architecture Latency 52

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. As datasets continue to grow in size, the amount of RAM required to store and process these datasets also increases. Transparent huge pages (THP) disabled.

Performance 144

Performance Hardware Tuning Storage 144

KeyCDN

AUGUST 29, 2019

While these metrics can be very helpful it is also important to keep this data in perspective. Take these statistics from Google’s industry benchmarks for mobile page speed guide: We’ve said it before but it’s worth reiterating that as web page load times increase, so does the likelihood of your visitors. location ~*.(js|css|png|jpg|svg|jpeg|gif|ico)$

Google 103

Google Cache Speed Analytics 103

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

Percona

MARCH 17, 2023

For example, a higher number of data samples ingested per second or a monitoring database with a huge number of tables (1000+) can affect performance; similarly, the configuration for exporters or a custom metric resolution can also have an impact on the performance of a PMM server host. Virtual Memory utilization was averaging 48 GB of RAM.

Monitoring 117

Monitoring Scalability Database Cache 117

Percona

AUGUST 31, 2018

That means data is stored in memory twice, first in PostgreSQL buffer and then kernel buffer. This parameter sets how much dedicated memory will be used by PostgreSQL for cache. The configuration really depends on your machine and the working data set. It is just a guideline, not the exact allocated memory or cache size.

Tuning 79

Tuning Database Performance Benchmarking 79

ScaleOut Software

MAY 15, 2014

We have spent a great deal of time at ScaleOut Software re-architecting our in-memory data grid (IMDG)’s code base to make best use of many cores and large memory. During load-balancing, the client gets the following exception when accessing the cache: ErrorCode<ERRCA0017>:SubStatus<ES0006>:There is a temporary failure.

Cache 40

Cache Servers Network Design 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 sizes offer you options for the number of vCPUs, RAM, and data disks. The number of data disks will determine maximum IOPS (IOPS stands for input/output operations per second.) Benchmark Test.

Azure 76

Azure Benchmarking Storage Virtualization 76

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

MachMetrics

DECEMBER 14, 2019

By analyzing the data from Backlinko.com and their Page Speed Stats article, we’ll look to answer these questions: What size should be a website be? Unfortunately, the data from Backlinko paints a bleak picture when it comes to mobile internet browsing. It’s still a drain on the visitor’s device battery and data plan.

Best Practices 105

Best Practices Speed Mobile Google 105

Speed Curve

FEBRUARY 5, 2024

Looking at the industry benchmarks for US retailers , four well-known sites have backend times that are approaching – or well beyond – that threshold. Pagespeed Benchmarks - US Retail - LCP When you examine a waterfall, it's pretty obvious that TTFB is the long pole in the tent, pushing out render times for the page.

Servers 64

Servers Cache Benchmarking Retail 64

The Morning Paper

AUGUST 29, 2019

There’s a broad set of choices including where you store the data, whether you run your own DBMS nodes or use a service, the kinds of instance types to go for if you do run your own, and so forth. We focused on OLAP-oriented parallel data warehouse products available for AWS and restricted our attention to commercially available systems.

Architecture 76

Architecture Cloud Storage Serverless 76

CSS - Tricks

APRIL 1, 2021

Google’s industry benchmarks from 2018 also provide a striking breakdown of how each second of loading affects bounce rates. You can even consider a large payload as an expense to the end user, as large downloads may require larger data plans that cost more money. Compressing, minifying and caching assets. Let’s trim that down.

Cache 94

Cache Social Media Media Website 94

John McCalpin

SEPTEMBER 11, 2014

The High Performance LINPACK (HPL) benchmark is well known for delivering a high fraction of peak floating-point performance. The (historically) excellent scaling of performance as the number of processors is increased and as the frequency is increased suggests that memory bandwidth has not been a performance limiter.

Benchmarking 40

Benchmarking Cache Performance Systems 40

Dotcom-Montior

AUGUST 5, 2020

Browser Caching: Although it may seem commonplace, caching is sometimes overlooked. Depending on how often you change content, you may want to set a long expiration time for your cache. Caching can ensure your browser doesn’t have to load all those elements if a visitor returns to your pages.

Website 92

Website Speed Cache Traffic 92

Percona

SEPTEMBER 1, 2023

MySQL triggers are a powerful tool for database administrators and developers, enabling them to automate tasks, enforce data consistency, and respond to events within the database seamlessly. The significance of triggers lies in their ability to enforce data integrity and automate various database-related tasks.

Cache 75

Cache Database Games Healthcare 75

Alex Russell

APRIL 29, 2021

This post mines publicly available data on the pace of compatibility fixes and feature additions to assess the claim. 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. Converging Views.

Media 145

Media Games Education Engineering 145

The Morning Paper

JUNE 16, 2019

A typical backing store for a web application contains data for many users. The application makes queries on behalf of an authenticated user, but it is up to the application itself to make sure that the user only sees data they are entitled to see. Towards multiverse databases Marzoev et al., HotOS’19.

Database 90

Database Cache Benchmarking Efficiency 90

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. Given that, there never was a single straight answer.

Games 141

Games Latency Traffic Cache 141

Brendan Gregg

FEBRUARY 9, 2018

. - **Page fault rate:** adds a little more overhead as well, for high rates. - **Working set size (hot data)**: more than 10 Mbytes will cost additional overhead due to TLB flushing. I then analyzed performance during the benchmark ([active benchmarking]), and used other benchmarks to confirm findings.

Performance 72

Performance Benchmarking Cache Tuning 72

John McCalpin

APRIL 2, 2020

This data is from the 2007 presentation. 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

Benchmarking 59

Benchmarking Performance Latency Architecture 59

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

Smashing Magazine

JUNE 2, 2021

Today, the website is much faster and ranks highly in various showcases and benchmarks. And while you can usually cache the full page of an article, the same is not true of many shop pages and elements. This way, the file can be cached on the server and in the browser, and no superfluous SVGs will need to be interpreted.

Performance 132

Performance Cache Website Mobile 132

HammerDB

APRIL 19, 2023

GHz 4th Generation Intel Xeon Scalable processors (code-named Sapphire Rapids) Up to 20% higher compute performance than z1d instances Up to 50 Gbps of networking speed Up to 40 Gbps of bandwidth to the Amazon Elastic Block Store (EBS) We can also verify these capabilities by running some simple benchmarks on the different subsystems.

Performance 55

Performance Benchmarking Cache Storage 55

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