n0derunner

JUNE 28, 2019

In this example we run pgbench with a scale factor of 1000 which equates to a database size of around 15GB. pgbench with DB size 50% of Linux buffer cache. pgbench with DB size 50% of Linux buffer cache. The post Benchmarking with Postgres PT2 appeared first on n0derunner.

Benchmarking 40

Benchmarking Tuning Cache Database 40

Brendan Gregg

MARCH 16, 2024

To explain this example in more detail: The profiler periodically interrupts software execution, and for those disconnected stacks it happens to be the execution of the kernel software ("vfs*", "ext*", etc.). These partial stacks get grouped together on the left. Click here for a longer explanation. You usually get an extra junk frame.

Java 145

Java Cache Google Hardware 145

The Morning Paper

MAY 23, 2019

Compress objects, not cache lines: an object-based compressed memory hierarchy Tsai & Sanchez, ASPLOS’19. So while you probably won’t be using Zippads in practice anytime soon, it’s a wonderful example of what’s possible when you’re prepared to take a fresh look at “the way we’ve always done things.”

Cache 61

Cache Benchmarking Hardware Java 61

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

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

APRIL 7, 2023

To illustrate this, I ran the Sysbench-TPCC synthetic benchmark against two different GCP instances running a freshly installed Percona Server for MySQL version 8.0.31 In MySQL, considering the standard storage engine, InnoDB , the data cache is called Buffer Pool. In PostgreSQL, it is called shared buffers.

Tuning 133

Tuning Cache Servers Benchmarking 133

Percona

MARCH 27, 2023

A lot of useful information can be retrieved from this schema, for example, table metadata and foreign key relations, but trying to query I_S can induce performance degradation if your server is under heavy load, as shown in the following example test. You can read some optimization examples in the official doc: [link].

Cache 98

Cache Hardware Servers Benchmarking 98

Percona

JULY 25, 2023

They are then applied (for example, writing old values back again) to the pages again and written to disk. After the “data dictionary” (DD) engine and DD cache are initialized on a server, the Storage Engines can ask for a table definition. Let’s take a look at the example table. CREATE TABLE test.t1(a

Cache 83

Cache Benchmarking Servers Design 83

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 62

Benchmarking Open Source C++ Cache 62

HammerDB

APRIL 19, 2023

For example, if you are buying the latest Amazon memory-optimized EC2 instance (R7iz), the AWS page ( [link] ) tells us the following: Up to 3.9 For example, if you are buying the latest Amazon memory-optimized EC2 instance (R7iz), the AWS page ( [link] ) tells us the following: Up to 3.9 For storage, FIO is generally used.

Performance 54

Performance Benchmarking Cache Storage 54

Percona

SEPTEMBER 1, 2023

For example, if an UPDATE statement modifies 100 rows, a statement-level trigger related to that statement will execute only once for the entire statement. Here are a few examples: Audit Logging : In compliance-driven industries like finance or healthcare, it’s crucial to maintain an audit trail of database changes.

Cache 59

Cache Database Games Healthcare 59

Smashing Magazine

SEPTEMBER 28, 2022

On your first try, you can use it as a benchmark for optimizations later. Jamstack files usually use Markdown before being compiled to HTML, for example: author: Agustinus Theodorus title: ‘Title’ description: Description. Active Memory Caching. Caching partially stores your data and is not used as permanent storage.

Cache 125

Cache Performance Servers Social Media 125

Percona

JUNE 22, 2023

Let’s dive in and learn how (and what) to effectively monitor MySQL performance, along with examples from PMM, by understanding the critical KPIs to watch for. 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.

Performance 102

Performance Monitoring Traffic Database 102

The Morning Paper

MAY 12, 2019

An open-source benchmark suite for microservices and their hardware-software implications for cloud & edge systems Gan et al., A typical architecture diagram for one of these services looks like this: Suitably armed with a set of benchmark microservices applications, the investigation can begin! ASPLOS’19.

Open Source 61

Open Source Hardware Benchmarking Systems 61

ACM Sigarch

OCTOBER 12, 2020

Programmers continue to write applications in them, and they continue to evolve: the just approved C++20 standard is the latest example. I suggest it’s long past time to move beyond C and SPEC benchmarks and our exclusive focus on “metal” languages. Are caches large enough for this code? MICRO 15 , Gope et al.,

C++ 108

C++ Benchmarking Hardware Architecture 108

ScaleOut Software

MAY 15, 2014

For example, the IMDG must be able to efficiently create millions of objects in each server to make use of its huge storage capacity. 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.

Cache 40

Cache Servers Network Design 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 95

Monitoring Scalability Cache Database 95

Percona

DECEMBER 23, 2022

The use case is the TPC-C benchmark but executed not on a high-end server but on a lower-spec virtual machine that is I/O limited like for example, with AWS EBS volumes. I wanted most of the memory to be available for the file cache, where the compressed SST files will be cached.

Storage 55

Storage Cache C++ Virtualization 55

Smashing Magazine

AUGUST 9, 2022

PageSpeed Compare is a page speed evaluation and benchmarking tool. It also lists cached resources and identifies unused Javascript. For example, it could recommend that you remove unused CSS and show you the savings this would give in a graph. With Treo Site Speed, you can also benchmark a website against competitors.

Performance 130

Performance Benchmarking Website Metrics 130

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. An example CSS file that wouldn’t block rendering would be: <link href="printing.css" rel="stylesheet" media="print">. Compressing, minifying and caching assets. View the full example ).

Cache 92

Cache Social Media Media Website 92

HammerDB

NOVEMBER 5, 2018

This post at an entry-level discusses the options you have to improve log throughput in your benchmark environment. . The first example shows a data load, the second a TPC-C based workload with 5 virtual users and the 2nd example with 10 virtual users. To illustrate the data reads on Oracle we can flush the buffer cache.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

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.) For example, a few themes have better optimization than others, while some plugins may add a huge number of scripts to your site. Optimus can be installed on any WordPress website.

Cache 52

Cache Website Speed Website Performance 52

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. Benchmark Test. Generation. Conclusion.

Azure 76

Azure Benchmarking Storage Virtualization 76

Dotcom-Montior

AUGUST 5, 2020

However, for example, if your site loads any external JavaScript or external CSS files, the DOM creation stops until those specific files are downloaded and parsed. Browser Caching: Although it may seem commonplace, caching is sometimes overlooked. These render-blocking elements can dramatically reduce page speed time.

Website 92

Website Speed Cache Traffic 92

KeyCDN

AUGUST 29, 2019

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. Take the example below for instance. A site which loads in 2.6 location ~*.(js|css|png|jpg|svg|jpeg|gif|ico)$

Google 103

Google Cache Speed Analytics 103

Percona

SEPTEMBER 1, 2023

High CPU usage, for example, can indicate that your server is under heavy processing load, possibly due to poorly optimized queries or increased user activity. Efficient memory management, including optimizing query caches and buffer pools, can help strike the right balance between memory consumption and query response times.

Tuning 52

Tuning Database Performance Hardware 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. Each of them has its own limits and advantages: for example, XFS is fast in deleting large files, while EXT4 can provide better performance on fast SSD drives, and ZFS on Linux has progressed a lot.

Performance 123

Performance Hardware Tuning Storage 123

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 115

Performance Cache Website Mobile 115

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 74

Cache Engineering Storage Speed 74

Brendan Gregg

FEBRUARY 9, 2018

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. For example, using my [perf-tools]: sudo./perf-tools/bin/funccount

Performance 75

Performance Benchmarking Cache Tuning 75

Smashing Magazine

JANUARY 11, 2021

Build Optimizations JavaScript modules, module/nomodule pattern, tree-shaking, code-splitting, scope-hoisting, Webpack, differential serving, web worker, WebAssembly, JavaScript bundles, React, SPA, partial hydration, import on interaction, 3rd-parties, cache. Adjust the argument depending on the group of stakeholders you are speaking to.

Performance 145

Performance Cache Media Metrics 145

SQL Performance

DECEMBER 17, 2019

For example: a regular Standard_E64s_v3 would have 64 vCPU cores, while a constrained Standard_E64-16s_v3 would have only 16 vCPU cores with otherwise identical specifications. Microsoft's Mine Tokus has a good article where she ran a series of scaled down TPC-E benchmarks against an E64s_v3 VM that was using the older Broadwell processor.

Azure 72

Azure Virtualization Servers Storage 72

The Morning Paper

JUNE 16, 2019

We’ll get to that, but first let’s look at some examples of privacy policies and how they can be expressed. For example: An aggregation policy could be used to rewrite any matching aggregation into a differentially-private version. The challenging thing of course, is efficiently maintaining all of these parallel universes.

Database 90

Database Cache Benchmarking Efficiency 90

n0derunner

SEPTEMBER 17, 2018

Creating a HCI benchmark to simulate multi-tennent workloads. The DB Colocation test utilizes two properties of X-Ray not found in other benchmarking tools. Time based benchmark actions. The “Data” disks are doing both reads (from DB cache misses) and writes committed transactions.

Performance Testing 40

Performance Testing Benchmarking Testing Performance 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. The Moto G4 , for example. 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.

Performance 124

Performance Network Cache Metrics 124

Smashing Magazine

JUNE 1, 2022

For example, users can install browser plugins to suggest coupon codes when they are shopping, to scan web pages for malware, to play games or message friends, or do any number of other things. With detailed code walkthroughs , hands-on examples and common gotchas — all broken down into short, manageable lessons. More after jump!

Website 131

Website Design Network Best Practices 131

Rigor

DECEMBER 19, 2019

For example, in a case study published by Gilt Groupe , Eric Shepherd, who was formerly Gilt’s principal front end engineer, noted that: Both RUM and synthetic monitoring give different views of our performance, and are useful for different things. Benchmark Against Competitors.

Monitoring 40

Monitoring Benchmarking Website Traffic 40