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

CSS Wizardry

AUGUST 24, 2022

Improving each of these should hopefully chip away at the timings of more granular events that precede the LCP milestone, but whenever we’re making these kinds of indirect optimisation, we need to think much more carefully about how we measure and benchmark ourselves as we work. one can’t just whack async on a and hope for the best).

Benchmarking 212

Benchmarking Metrics Cache Network 212

Scalegrid

JULY 29, 2020

However, these must be set up outside the PostgreSQL system, while PgBouncer can offload this to the PostgreSQL server. So, we pitted the two connection poolers head-to-head, using the standard pgbench tool, to see which one provides better transactions per second throughput through a benchmark test. Throughput Benchmark.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

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 54

Benchmarking Latency Cache Network 54

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark. Results for Percona Server for MySQL 5.7

Cache 107

Cache Hardware Servers Benchmarking 107

Percona

JULY 25, 2023

The data is internally inconsistent because the server concurrently modifies the data files while they are being copied. The changes done by an uncommitted transaction can be flushed or written to the redo log by the server. Initializing a DD engine and the cache adds complexity and other server dependencies.

Cache 89

Cache Benchmarking Servers Design 89

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

Smashing Magazine

SEPTEMBER 28, 2022

The resource loading waterfall is a cascade of files downloaded from the network server to the client to load your website from start to finish. On your first try, you can use it as a benchmark for optimizations later. Client Side Rendering, Server Side Rendering And Jamstack. On design systems, UX, web performance and CSS/JS.

Performance 125

Performance Cache Servers Social Media 125

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. Back-end servers. Don't blame the straw, in this case, don't blame the frame pointers.

Java 145

Java Cache Google Hardware 145

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

SQL Performance

DECEMBER 17, 2019

One initial, easy step to moving your SQL Server on-premises workloads to the cloud is using Azure VMs to run your SQL Server workloads in an infrastructure as a service (IaaS) scenario. You will still have to maintain your operating system, SQL Server and databases just like you would in an on-premises scenario.

Azure 72

Azure Virtualization Servers Storage 72

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. However, simply deploying a monitoring tool is not enough; you need to know which Key Performance Indicators (KPIs) to monitor to gain insights into your MySQL server’s health and performance.

Performance 108

Performance Monitoring Traffic Database 108

Percona

MARCH 17, 2023

Planning for resources of a PMM Server host instance can be tricky because the numbers can change depending on the DB instances being monitored by PMM. VictoriaMetrics maintains an in-memory cache for mapping active time series into internal series IDs. The CPU usage averaged 24% utilization, as you can see in the above picture.

Monitoring 105

Monitoring Scalability Cache Database 105

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 54

Performance Benchmarking Cache Storage 54

Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Some servers may need a few GBs of RAM, while others may need hundreds of GBs or even terabytes of RAM. Benchmark before you decide.

Performance 129

Performance Hardware Tuning Storage 129

Percona

SEPTEMBER 1, 2023

MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. Testing and Benchmarking : Thoroughly test triggers in a staging environment to evaluate their impact on performance.

Cache 63

Cache Database Games Healthcare 63

Percona

MAY 1, 2023

Connection pooling: Minimizing connection overhead and improving response times for frequently accessed data by implementing mechanisms for connection pooling and caching strategies. PostgreSQL performance optimization is an ongoing process involving monitoring, benchmarking, and adjustments to maintain high-performing PostgreSQL databases.

Tuning 52

Tuning Efficiency Database Performance 52

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

SQL Performance

NOVEMBER 18, 2019

Migrating an on-premises SQL Server instance to an Azure Virtual Machine (VM) is a common method to migrate to Azure. Compute optimized – High CPU-to-memory ration, medium traffic web servers and application servers. Certain sizes also support premium storage, which should be a requirement for a production SQL Server.

Azure 76

Azure Benchmarking Storage Virtualization 76

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

I suggest it’s long past time to move beyond C and SPEC benchmarks and our exclusive focus on “metal” languages. There are already standard benchmark suites for JavaScript performance in the browser, and we can include applications written in node.js (server-side JavaScript), Python web servers, and more.

C++ 108

C++ Benchmarking Hardware Architecture 108

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. Leverage Browser Caching Files We are now receiving a warning about leveraging browser caching.

Google 103

Google Cache Speed Analytics 103

Percona

SEPTEMBER 1, 2023

Reduced Resource Usage Optimizing resource-intensive queries and configurations can lead to a reduced burden on your server. An improperly configured server may not allocate sufficient resources or be optimized for the specific workload. Detecting and optimizing slow queries is an important step in enhancing database performance.

Tuning 52

Tuning Database Performance Hardware 52

KeyCDN

DECEMBER 8, 2022

A WordPress website comprises many parts, including web servers and their settings, different plugins, and themes. Many factors affect the speed of your WordPress website; some of them are: Your web host Server-side optimizations (PHP version, compression, caching, etc.) Traditionally, most WordPress hosts manage the caching.

Cache 52

Cache Website Speed Website Performance 52

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

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 56

Storage Cache C++ Virtualization 56

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: ​​ Bob Dorr, Microsoft SQL Server Escalation Published: ​​ December, 2004 SUMMARY: ​​ Learn the I/O requirements for Microsoft SQL Server database file operations. This will help you increase system performance and avoid I/O environment errors.

Servers 40

Servers Cache Media Hardware 40

SQL Server According to Bob

AUGUST 23, 2021

HOW IT WORKS: SQL Server Scheduler Affinity SQL Server uses 3 types of affinity to control where the SQL Server worker threads execute. Node Types SQL Server makes a specific distinction between scheduling and memory nodes. Online vs Offline Schedulers The SQL Server schedulers can be online or offline.

Servers 40

Servers Azure Operating System Database 40

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. It begins with retrieving the HTML from the server and converting this into the Document Object Model (DOM). Compressing, minifying and caching assets. The final thing we can check is caching.

Cache 92

Cache Social Media Media Website 92

SQL Performance

JULY 16, 2019

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. Despite all of this, Intel is not going to lose their entire server processor business any time soon. So, what has changed my mind?

Servers 46

Servers Hardware Architecture Retail 46

Smashing Magazine

AUGUST 9, 2022

PageSpeed Compare is a page speed evaluation and benchmarking tool. It also lists cached resources and identifies unused Javascript. It graphs server, network, CSS, Javascript, critical content, and image optimizations to show the potential savings you could gain by incorporating fixes into your site. PageSpeed Compare.

Performance 130

Performance Benchmarking Website Metrics 130

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 Server DELAYED_DURABILITY. Logging Waits.

Benchmarking 40

Benchmarking Database C++ Virtualization 40

MachMetrics

DECEMBER 14, 2019

How fast is the average time to first byte (server delay)? How long is the average server delay? It is typically reduced via server-side optimizations, such as enabling caching and database indexes. However, we really want to strive to be under the benchmarks that Google sets as a best practice.

Best Practices 105

Best Practices Speed Mobile Google 105

CSS - Tricks

JUNE 5, 2020

It took a few months for major CDN players to support Brotli, but meanwhile it was seeing widespread adoption in tools, services, browsers and servers. The service categorized all the optimizations in three groups consisting of several “Content,” “Delivery,” and “Cache” optimizations. This was really disappointing for me.

Cache 79

Cache Website Servers Open Source 79

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, ​​ Windows, ​​ Windows NT, ​​ and Windows Server ​​ are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers 40

Servers Cache Database Media 40

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. It used to provide an insight into how quickly the server outputs any data.

Performance 145

Performance Cache Media Metrics 145

Percona

JUNE 22, 2023

Load balancing : Requests are evenly distributed across multiple database servers, ensuring the system remains operational even if one server fails. Automated failover : To keep the database operational and minimize downtime, it automatically switches to a backup server if the primary server fails.

Availability 112

Availability Database Open Source Hardware 112