Speed Curve

FEBRUARY 5, 2024

That performance golden rule still holds true today. Looking at the industry benchmarks for US retailers , four well-known sites have backend times that are approaching – or well beyond – that threshold. Charlie Vazac introduced server timing in a Performance Calendar post circa 2018.

Servers 57

Servers Cache Retail Benchmarking 57

Percona

SEPTEMBER 1, 2023

While there is no magic bullet for MySQL performance tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. What are the Benefits of MySQL Performance Tuning? Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

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

Percona

MAY 1, 2023

In this blog post, we will delve into the world of PostgreSQL performance tuning and establish some basic guidelines for setting database parameters to enhance the performance of your PostgreSQL database, based on the workload. What is PostgreSQL performance tuning? Why is PostgreSQL performance tuning important?

Tuning 52

Tuning Efficiency Database Performance 52

The Morning Paper

MAY 23, 2019

Compress objects, not cache lines: an object-based compressed memory hierarchy Tsai & Sanchez, ASPLOS’19. Today’s paper introduces Zippads , which compared to a state of the art compressed memory hierarchy is able to achieve a 1.63x higher compression ratio and improve performance by 17%. ” The big idea.

Cache 61

Cache Benchmarking Hardware Java 61

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. performance degradation. That is (46320 – 38472) * 100 / 46320 = 16.9%

Cache 104

Cache Hardware Servers Benchmarking 104

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

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 performs crash recovery on the files to make a consistent, usable database again.

Cache 87

Cache Benchmarking Servers Design 87

Percona

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 101

Monitoring Scalability Cache Database 101

Percona

AUGUST 31, 2018

In this blog, we will establish basic guidelines for setting PostgreSQL database parameters to improve database performance according to workload. Bear in mind that while optimizing PostgreSQL server configuration improves performance, a database developer must also be diligent when writing queries for the application. shared_buffer.

Tuning 57

Tuning Database Performance Benchmarking 57

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. The storage device has performance characteristics pretty similar to an AWS gp2 EBS volume of about 330 GB in size. . <iotune> Long term stability.

Storage 56

Storage Cache C++ Virtualization 56

SQL Performance

NOVEMBER 18, 2019

Memory optimized – High memory-to-CPU ratio, relational database servers, medium to large caches, and in-memory analytics. High performance compute – Fastest and most powerful CPU virtual machines. The sizes offer you options for the number of vCPUs, RAM, and data disks. Benchmark Test. VM Image Options.

Azure 76

Azure Benchmarking Storage Virtualization 76

The Morning Paper

MAY 14, 2019

Seer: leveraging big data to navigate the complexity of performance debugging in cloud microservices Gan et al., Finally, we show that Seer can identify application level design bugs, and provide insights on how to better architect microservices to achieve predictable performance. ASPLOS’19. Seer in action.

Big Data 45

Big Data Cloud Performance Hardware 45

Dotcom-Montior

AUGUST 5, 2020

Page speed has been a key factor in Google’s ranking algorithm since 2010 , so it is essential to understand the various ways you can optimize your pages and why implementing synthetic monitoring can ensure your pages perform flawlessly and revenue isn’t lost. Find Your Performance Baseline. Optimize Your Pages.

Website 92

Website Speed Cache Traffic 92

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

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

KeyCDN

DECEMBER 8, 2022

Unoptimized content could also be one of the reasons why your WordPress website is not performing as per your expectations. Many factors affect the speed of your WordPress website; some of them are: Your web host Server-side optimizations (PHP version, compression, caching, etc.) So let's discuss the process one step at a time.

Cache 52

Cache Website Speed Website Performance 52

Percona

JANUARY 9, 2023

Looking at how people are using COUNT(*) and COUNT(col), it looks like most of them think they are synonyms and just use what they happen to like, while there is a substantial difference in performance and even query results. But why we can’t just cache the actual number of the rows? Extra: Using where 1 row in set, 1 warning (0.00

Cache 78

Cache Engineering Storage Speed 78

MachMetrics

DECEMBER 14, 2019

With another year winding down, it’s time for us to take stock of how our site performance compares to the average page load times for 2020. 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. seconds on mobile.

Best Practices 105

Best Practices Speed Mobile Google 105

Abhishek Tiwari

DECEMBER 13, 2017

Can machine learning-based data structures i.e. learned data structures replace traditional data structures? The initial results show that learned data structures can outperform existing data structures. This has far-reaching implications how future data systems and algorithms will be designed. p = F(Key) ?

Artificial Intelligence 40

Artificial Intelligence Hardware Google Benchmarking 40

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

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 and Memcached both provide high performance with sub-millisecond response times. Managed DBaaS solutions like ScaleGrid.io

Cache 130

Cache Storage Scalability Architecture 130

Rigor

DECEMBER 19, 2019

Reading time 4 min It’s important for both technical and business teams to understand the different web performance monitoring options that are available as well as their various use cases and the benefits of each. Understanding Web Performance Monitoring Methodologies. AB Test the Performance Impact of Third Parties.

Monitoring 40

Monitoring Benchmarking Website Traffic 40

Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7

Performance 127

Performance Hardware Tuning Storage 127

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 145

Java Cache Google Hardware 145

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. Derived Workloads.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

APRIL 6, 2023

PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. One of the key benefits of using PostgreSQL is its reliability, scalability, and performance. However, as the size of your database grows, it can become challenging to manage and optimize its performance.

Cache 116

Cache Open Source Benchmarking Database 116

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 on CentOS 7, both of them spec’d with four vCPUs but with the second one (server B) having a tad over twice as much memory than the reference one (server A). Why is that?

Tuning 137

Tuning Cache Servers Benchmarking 137

Brendan Gregg

JUNE 30, 2018

A co-worker introduced me to Craig Hanson and Pat Crain's performance mantras, which neatly summarize much of what we do in performance analysis and tuning. They are: **Performance mantras**. These have inspired me to summarize another performance activity: evaluating benchmark accuracy. Don't do it. Do it less.

Benchmarking 54

Benchmarking Latency Cache Network 54

Brendan Gregg

FEBRUARY 9, 2018

The recently revealed [Meltdown and Spectre] bugs are not just extraordinary issues of security, but also performance. The patches that workaround Meltdown introduce the largest kernel performance regressions I've ever seen. Some older kernels have the KAISER patches for Meltdown, and so far the performance overheads look similar.

Performance 75

Performance Benchmarking Cache Tuning 75

Scalegrid

JULY 29, 2020

In our final post, we will put them head-to-head in a detailed feature comparison and compare the results of PgBouncer vs. Pgpool-II performance for your PostgreSQL hosting ! Performance Testing. All of the PostgreSQL benchmark tests were run under the following conditions: Initialized pgbench using a scale factor of 100.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

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. The significance of triggers lies in their ability to enforce data integrity and automate various database-related tasks.

Cache 62

Cache Database Games Healthcare 62

Brendan Gregg

JUNE 29, 2018

A co-worker introduced me to Craig Hanson and Pat Crain's performance mantras, which neatly summarize much of what we do in performance analysis and tuning. They are: **Performance mantras**. These have inspired me to summarize another performance activity: evaluating benchmark accuracy. Don't do it. Do it less.

Benchmarking 40

Benchmarking Latency Cache Network 40

John McCalpin

APRIL 2, 2020

This was a keynote presentation at the “2nd International Workshop on Performance Modeling: Methods and Applications” (PMMA16), June 23, 2016, Frankfurt, Germany (in conjunction with ISC16 ). This data is from the 2007 presentation.

Benchmarking 59

Benchmarking Performance Latency Architecture 59

CSS - Tricks

APRIL 1, 2021

Site performance is potentially the most important metric. The better the performance, the better chance that users stay on a page, read content, make purchases, or just about whatever they need to do. Google’s industry benchmarks from 2018 also provide a striking breakdown of how each second of loading affects bounce rates.

Cache 92

Cache Social Media Media Website 92

Brendan Gregg

FEBRUARY 8, 2018

The recently revealed [Meltdown and Spectre] bugs are not just extraordinary issues of security, but also performance. The patches that workaround Meltdown introduce the largest kernel performance regressions I've ever seen. Some older kernels have the KAISER patches for Meltdown, and so far the performance overheads look similar.

Performance 40

Performance Benchmarking Cache Tuning 40

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. Poor performance has a compound effect on user expectations at an ecosystem level. Live by the link, die by the link.

Performance 124

Performance Network Cache Metrics 124