Brendan Gregg

MAY 22, 2021

- What observability does that database have? For example, benchmarks. As an analogy, a car's dashboard is a collection of observability tools that let you understand how the car is operating (speed, rpm, temperature). Means: What metrics and logs does it have?) - Let me try some observability first.

Benchmarking 117

Benchmarking Metrics Speed Database 117

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. Query performance Query performance is a key performance indicator (KPI) in MySQL, as it measures the efficiency and speed of query execution.

Performance 102

Performance Monitoring Traffic Database 102

MachMetrics

DECEMBER 14, 2019

As you know, there are many metrics that determine a website’s page speed, and we can’t look at just one of them to determine how performant our site is. 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?

Best Practices 105

Best Practices Speed Mobile Google 105

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

Speed Curve

SEPTEMBER 4, 2013

Why speed matters, examples of the impact saving a few seconds of load time has had on revenue and engagement. Bandwidth, latency and it's fundamental impact on the speed of the web. An overview of tools for measuring performance, uptime monitoring, real user monitoring and performance benchmarking. Muti-device challenges.

Speed 40

Speed Benchmarking Latency Mobile 40

HammerDB

APRIL 27, 2021

As the workflow in the CLI and GUI are the same we will show equivalent commands side by side to help you quickly get up to speed on using the CLI in both interactive and scripted scenarios. One of the first things you will want to do is make sure that we can access the 3rd party driver libraries for the database that we want to use.

Virtualization 73

Virtualization Benchmarking Database Operating System 73

Rigor

JUNE 14, 2019

Whether you’re new to web performance or you’re an expert working with the business side of your organization to gain buy-in on performance culture, we suggest starting with six specific metrics: Time to Interactive , First Contentful Paint , Visually Complete , Speed Index , Time to First Byte , and Total Content Size. Speed Index.

Metrics 101

Metrics Performance Speed Ecommerce 101

Percona

OCTOBER 12, 2023

The idea behind this is to speed up cluster resources such as garbage collection, reduce image transfer over the network, and accelerate the application launch. A simple sysbench benchmark on MySQL shows an overhead between six and 10 percent on CPU-bound systems when running perf with the default sampling frequency of 4000 Hz.

Code 106

Code Tuning C++ Benchmarking 106

n0derunner

JUNE 14, 2022

tl;dr In a recent experiment using Amazon RDS instance and a VM running in an on-prem Nutanix cluster, both using Skylake class processors with similar clock speeds and vCPU count. The SQLServer database on Nutanix delivered almost 2X the transaction rate as the same workload running on Amazon RDS.

Performance 52

Performance Speed Database Benchmarking 52

Smashing Magazine

SEPTEMBER 28, 2022

On your first try, you can use it as a benchmark for optimizations later. Server caches help lower the latency between a Frontend and Backend; since key-value databases are faster than traditional relational SQL databases, it will significantly increase an API’s response time. Caching Schemes. Large preview ). Large preview ).

Cache 125

Cache Performance Servers Social Media 125

Brendan Gregg

MAY 22, 2021

Means: What tools exist that only read state?) - What observability does that database have? For example, benchmarks. As an analogy, a car's dashboard is a collection of observability tools that let you understand how the car is operating (speed, rpm, temperature). Wait, aren't all performance tools observability tools?

Benchmarking 40

Benchmarking Metrics Speed Database 40

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()? What on Earth is Ubuntu doing that results in 30% higher CPU time!?

Speed 126

Speed Java AWS Virtualization 126

Scalegrid

MARCH 28, 2024

Introduction Caching serves a dual purpose in web development – speeding up client requests and reducing server load. Benchmarking Cache Speed Memcached is optimized for high read and write loads, making it highly efficient for rapid data access in a basic key-value store. Data transfer technology.

Cache 130

Cache Storage Scalability Architecture 130

Abhishek Tiwari

DECEMBER 13, 2017

This is a question recently asked and explored by a team of Google researchers led by Jeff Dean with a major focus on database indexes. They demonstrated that neural nets based learned index outperforms cache-optimized B-Tree index by up to 70% in speed while saving an order-of-magnitude in memory.

Artificial Intelligence 40

Artificial Intelligence Hardware Google Benchmarking 40

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

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()? What on Earth is Ubuntu doing that results in 30% higher CPU time!?

Speed 52

Speed Java AWS Virtualization 52

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Measuring the speed of time Is there already a microbenchmark for os::javaTimeMillis()? What on Earth is Ubuntu doing that results in 30% higher CPU time!?

Speed 40

Speed Java AWS Virtualization 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? Why HammerDB was developed. The HammerDB name.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

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. Storage The type of storage and disk used for database servers can have a significant impact on performance and reliability. Benchmark before you decide.

Performance 123

Performance Hardware Tuning Storage 123

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. The governor "powersave" may decide which speed to use within this range. The governor "performance" may decide which speed to use within this range.

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Dynatrace

SEPTEMBER 23, 2021

Many good security tools provide that function, and benchmarks from the Center for Internet Security (CIS) are clear and prescriptive. In fact, in our recent CISO research, 28% of CISOs told us that application teams sometimes bypass these types of tests to speed up delivery. Why is container security tricky? Remove privileges.

Open Source 255

Open Source Benchmarking Best Practices Network 255

Scalegrid

JANUARY 12, 2024

Simply put, it’s the set of computational tasks that cloud systems perform, such as hosting databases, enabling collaboration tools, or running compute-intensive algorithms. Memory Allocation: Allocating sufficient memory linked directly to the assigned CPU ensures effective utilization resulting in better system speed.

Cloud 130

Cloud Virtualization Storage Efficiency 130

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. Such “torn pages” are corruptions from the database point of view.

Database 114

Database Benchmarking Open Source Latency 114

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

Percona

AUGUST 5, 2023

Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. Each partition holds data that falls within a specific range, optimizing data handling and query speed. So, What is MySQL Partitioning? Additionally, MySQL 8.0

Strategy 40

Strategy Storage Database Best Practices 40

SQL Performance

DECEMBER 17, 2019

You will still have to maintain your operating system, SQL Server and databases just like you would in an on-premises scenario. In exchange for this, your databases and applications will work just the same as they would in an on-premises installation, which makes this an easy way to start using Azure. Esv3-series.

Azure 72

Azure Virtualization Servers Storage 72

KeyCDN

AUGUST 29, 2019

Running speed tests with tools like Google PageSpeed Insights , WebPageTest , or KeyCDN’s Website Speed Test are always a good way to help gauge your website’s performance. Why Care About Page Speed? There are a multitude of reasons why you should care about page speed.

Google 103

Google Cache Speed Analytics 103

SQL Performance

APRIL 8, 2019

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. Both of these Intel processors are special bespoke models that are not in the Intel ARK database. Figure 1: CPU-Z Benchmark Results for LS16v2. The L3 cache size is 64MB.

Azure 42

Azure Virtualization Storage Benchmarking 42

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. 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 102

Database Benchmarking Latency C++ 102

SQL Performance

AUGUST 27, 2019

Single-Socket Database Servers. 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.

Servers 52

Servers Benchmarking Virtualization Architecture 52

Alex Russell

MARCH 6, 2021

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. Recall that single-core performance most directly translates into speed on the web. Today, either method returns a similar answer. Tap for a larger version. How bad is it?

Performance 124

Performance Network Cache Metrics 124

Particular Software

NOVEMBER 6, 2017

Do you want speed or reliability? A simple algorithm or the fastest speed? Perhaps you're building a runtime procedure from steps stored in config files or a database. Message signing/encryption, compression, validation, and database session management are all easy to implement with an NServiceBus behavior.

Lambda 40

Lambda Speed Efficiency Infrastructure 40

HammerDB

OCTOBER 12, 2018

Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. As is exactly the same with PostgreSQL for system choice a 2 socket system is optimal for MySQL OLTP performance.

Best Practices 40

Best Practices Scalability Performance C++ 40

SQL Performance

JULY 16, 2019

This made it easier for database professionals to make the case for a hardware upgrade, and made the typical upgrade more worthwhile. So far, we don't know the official base and turbo clock speeds, but there was a recent leak of partial specifications and pricing by a European retailer that listed max boost clock speeds of up to 3.4

Servers 46

Servers Hardware Architecture Retail 46

SQL Server According to Bob

SEPTEMBER 26, 2016

Performance issues surrounding Availability Groups typically were related to disk I/O or network speeds. We needed to start thinking about how fast can we replicate to a synchronous secondary replica in terms of % of the speed of a standalone workload. Direct seeding of new database replicas. one without a replica).

Availability 40

Availability Servers Hardware Benchmarking 40

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? SQL Server 2005 introduces the snapshot database feature for point-in-time databases ​​ and online DBCC operations.

Servers 40

Servers Cache Database Media 40

Alex Russell

MAY 9, 2022

They routinely benchmark against their competition on important flows and can understand when a competitor has taken the initiative to catch up (it rarely happens through a single commit or launch). The speed of a client device isn't the limiting site speed factor in an HTML-first world.

Performance 86

Performance Latency Metrics Engineering 86