Percona

JULY 25, 2023

When a new node joins the cluster, SST is performed to receive the data from DONOR to the JOINER. Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again. This search tuple (key) is used to find the record to perform the undo operation. ibd in the test directory. ibd > t1.sdi

Cache 89

Cache Benchmarking Servers Design 89

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 103

Monitoring Scalability Cache Database 103

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 58

Tuning Database Performance Benchmarking 58

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. I put each of these VMs to a test using CrystalDiskMark. Benchmark Test. supports up to a 64 GiB file.

Azure 76

Azure Benchmarking Storage Virtualization 76

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

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

The Morning Paper

AUGUST 29, 2019

use the TPC-H benchmark to assess Redshift, Redshift Spectrum, Athena, Presto, Hive, and Vertica to find out what works best and the trade-offs involved. As it is infeasible to test every OLAP system runnable on AWS, we chose widely-used systems that represented a variety of architectures and cost models. Query performance.

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

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

n0derunner

JULY 23, 2019

In this video I migrate a Postgres DB running PGbench benchmark. The variation in the transaction rate is due to the benchmark itself, the transaction rate is not expected to be uniform. Many different queries are executing in parallel, some hitting RAM cache, some hitting storage.

Benchmarking 76

Benchmarking Storage Tuning Cache 76

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 80

Cache Engineering Storage Speed 80

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.

Big Data 45

Big Data Cloud Performance Hardware 45

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. Test at Every Stage of Development.

Monitoring 40

Monitoring Benchmarking Website Traffic 40

Brendan Gregg

MARCH 16, 2024

I'm sure this delivered large performance improvements and I wouldn't try arguing against it. 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.

Java 145

Java Cache Google Hardware 145

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 129

Performance Hardware Tuning Storage 129

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

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. For good measure, we ran the same tests without a connection pooler too. Testing Conditions. Throughput Benchmark.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

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. HammerDB development.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

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).

Tuning 138

Tuning Cache Servers Benchmarking 138

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. This is a sanity test.

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. Much of my testing was on Linux 4.14.11 and 4.14.12 a month ago, before we deployed in production.

Performance 75

Performance Benchmarking Cache Tuning 75

Percona

APRIL 6, 2023

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. Pgpool-II is a powerful tool that can help you manage and optimize the performance of your PostgreSQL database cluster.

Cache 118

Cache Open Source Benchmarking Database 118

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. This can affect the overall performance of your database system, potentially leading to slower response times. What is a Trigger in MySQL?

Cache 63

Cache Database Games Healthcare 63

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. This is a sanity test.

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 ). Here I assumed a particular analytical function for the amount of memory traffic as a function of cache size to scale the bandwidth time.

Benchmarking 59

Benchmarking Performance Latency Architecture 59

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. Much of my testing was on Linux 4.14.11 and 4.14.12 a month ago, before we deployed in production.

Performance 40

Performance Benchmarking Cache Tuning 40

n0derunner

SEPTEMBER 17, 2018

Creating a HCI benchmark to simulate multi-tennent workloads. It is the shared storage that often causes performance issues for data bases which are otherwise separated across nodes. We supply a pre-configured scenario which we call the DB Colocation test. Time based benchmark actions. X-Ray Workload specification.

Performance Testing 40

Performance Testing Benchmarking Testing Performance 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

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. Logging Waits. so what are your options?

Benchmarking 40

Benchmarking Database C++ Virtualization 40

Alex Russell

APRIL 29, 2021

Classics of the genre include: Apple's just focused on performance! The Performance Argument. 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. This is as it should be.

Media 145

Media Games Education Engineering 145

ScaleOut Software

MAY 15, 2014

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. Testing Scale-Up Performance. We invite you to test AppFabric’s performance; contact us if you need a test application.).

Cache 40

Cache Servers Network Design 40

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. micro) The tests We will have very simple test cases.

Games 125

Games Latency Traffic Cache 125

Alex Russell

OCTOBER 22, 2017

TL;DR: performance budgets are an essential but under-appreciated part of product success and team health. Nobody is trying to do a poor job, and yet the results of a “completed” PWA project often require weeks or months of painstaking rework to deliver minimally acceptable performance. What’s going on here?

Performance 68

Performance Benchmarking Network Mobile 68

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

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. Your goal here isn’t to score 100/100 just for the sake of having 100/100, the goal is to improve your site’s overall performance.

Google 103

Google Cache Speed Analytics 103

CSS - Tricks

JUNE 5, 2020

At that time, I was working as a freelance website performance consultant. I started building my own performance optimization service for my clients. The service categorized all the optimizations in three groups consisting of several “Content,” “Delivery,” and “Cache” optimizations. Taking matters into my own hands.

Cache 79

Cache Website Servers Open Source 79

Smashing Magazine

JUNE 1, 2022

You’ve tested and retested the site for errors. You may have a lean, agile, responsive site design only to find it gradually loaded down with more and more “extras” that are often put onto the site by marketing departments or business leaders who are not always thinking about website performance. Measuring Performance Impact.

Website 131

Website Design Network Best Practices 131