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. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 102

Performance Monitoring Traffic Database 102

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

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

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

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

Randon ASCII

JANUARY 12, 2022

The Xbox 360 CPU had three PowerPC cores and a 1 MB L2 cache and these features are clearly visible on the wafer. In the die picture to the right (which looks to be about 14 mm by 12 mm) you can see the regular pattern of small black rectangles in the bottom right corner – that’s the L2 cache. I wrote a lot of benchmarks.

Cache 126

Cache Latency Benchmarking Hardware 126

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 98

Cache Hardware Servers Benchmarking 98

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. JOINER must prepare the backup before using it.

Cache 83

Cache Benchmarking Servers Design 83

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 95

Monitoring Scalability Cache Database 95

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 54

Tuning Database Performance Benchmarking 54

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. Now, how does this workload perform on InnoDB?

Storage 55

Storage Cache C++ Virtualization 55

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. Benchmark Test. CrystalDiskMark is an open source disk drive benchmark tool for Windows, and it's based-on Microsoft's Diskspd tool.

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

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

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

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. InS does now offer an NVMe variant too, and the authors perform limited testing on that as well. in the TPC-H Benchmark Standard for details of the queries). Query performance.

Architecture 76

Architecture Cloud Storage Serverless 76

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

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 74

Cache Engineering Storage Speed 74

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

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. Choosing between Redis and Memcached hinges on specific application requirements.

Cache 130

Cache Storage Scalability Architecture 130

The Morning Paper

JUNE 16, 2019

For good query performance we’d like to pre-compute these per-user universes. A space- and compute-efficient multiverse database clearly cannot materialize all user universes in their entirety, and must support high-performance incremental updates to the user universes. Recent research has provided this missing key primitive.

Database 90

Database Cache Benchmarking Efficiency 90

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

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 123

Performance Hardware Tuning Storage 123

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

Abhishek Tiwari

DECEMBER 13, 2017

More importantly, if this works out well, this could lead to a radical improvement in performance by leveraging hardware trends such as GPUs and TPUs. 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. Learned indexes.

Artificial Intelligence 40

Artificial Intelligence Hardware Google Benchmarking 40

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

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

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

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 111

Cache Open Source Benchmarking Database 111

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

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 133

Tuning Cache Servers Benchmarking 133

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

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

Cache 59

Cache Database Games Healthcare 59