Percona

NOVEMBER 3, 2023

When it comes to Citus, successfully building out and scaling a PostgreSQL cluster across multiple nodes and even across data centers can feel, at times, to be an art form because there are so many ways of building it out. The following invocation generates almost 4GB of data.

Database 104

Database Benchmarking Latency C++ 104

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

AUGUST 31, 2018

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. That means data is stored in memory twice, first in PostgreSQL buffer and then kernel buffer.

Tuning 55

Tuning Database Performance Benchmarking 55

Scalegrid

MARCH 22, 2024

This covers everything from tech specs and what you expect from the service to security, how you’ll handle data, and how services will be managed. Hosting either on-premises or with third-party data center providers and deciding whether management services should be conducted internally or outsourced.

Strategy 130

Strategy Cloud Government Innovation 130

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

The Netflix TechBlog

OCTOBER 19, 2020

Troubleshooting a session in Edgar When we started building Edgar four years ago, there were very few open-source distributed tracing systems that satisfied our needs. Our tactical approach was to use Netflix-specific libraries for collecting traces from Java-based streaming services until open source tracer libraries matured.

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. So over at Phoronix some database benchmarks were published showing PostgreSQL 12 Performance With AMD EPYC 7742 vs. Intel Xeon Platinum 8280 Benchmarks .

Benchmarking 63

Benchmarking Performance Hardware C++ 63

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

Scalegrid

OCTOBER 24, 2019

AWS is the #1 cloud provider for open-source database hosting, and the go-to cloud for MySQL deployments. Slave-2 uses an EBS data disk, and you can configure the amount of IOPS required for your cluster. This configuration provides complete safety for your data, even in the event you lose the local SSD disks.

AWS 183

AWS Latency Performance Benchmarking 183

Percona

MARCH 23, 2023

While NVMe or SSDs are generally more expensive than HDDs, the increased performance and reliability that they offer make them a cost-effective choice for database servers that require fast access to data and minimal downtime. Benchmark before you decide. If you see concurrency issues, you can tune this variable.

Performance 125

Performance Hardware Tuning Storage 125

HammerDB

OCTOBER 18, 2018

With this feature Oracle generates a wealth of performance data that can be reviewed once the test is complete. However what if you want to review performance data in real time as the test is running? With HammerDB 3.1 you can now do that with Oracle Metrics. .

Benchmarking 40

Benchmarking Monitoring Performance C++ 40

Percona

OCTOBER 12, 2023

Manual flame graphs collection Although the tool is excellent and automatically provides flame graphs, we don’t have much control over tuning the selected profiler. 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 109

Code Tuning C++ Benchmarking 109

Percona

MARCH 27, 2023

Disclaimer : This blog post is meant to show a less-known problem but is not meant to be a serious benchmark. I_S relies on opening.frm files from disk to retrieve table information, which can cause a performance drop when the amount of opened tables does not fit in the table_cache. Results for Percona Server for MySQL 8.0

Cache 101

Cache Hardware Servers Benchmarking 101

Percona

JANUARY 19, 2023

With disks being faster nowadays and CPU and memory resources being cheaper, we could easily say MySQL can handle TBs of data with good performance. For instance, in Percona Managed Services , we have many clients with TBs worth of data that are well performant. There are many compression tools and algorithms for data out there.

Open Source 87

Open Source Storage Database Big Data 87

Percona

DECEMBER 20, 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. Linux OS Tuning for MySQL Database Performance. Tuning InnoDB Primary Keys.

Database 40

Database Tuning Performance AWS 40

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. This helps to minimise locking allowing multiple sessions to access the same data at the same time. However, it is crucial that the benchmarking application does not have inherent bottlenecks that artificially limits the scalability of the database.

Programming 67

Programming Benchmarking Virtualization C++ 67

KeyCDN

AUGUST 15, 2019

Before you begin tuning your website or application, you must first figure out which metrics matter most to your users and establish some achievable benchmarks. An interruption in data flow due to limited capacity is called a bottleneck. What is Performance Testing? Which Web Performance Metrics Matter?

Testing Tools 55

Testing Tools Best Practices Performance Testing Testing 55

Percona

AUGUST 30, 2018

Let’s examine the TPC-C Benchmark from this point of view, or more specifically its implementation in Sysbench. The illustrations below are taken from Percona Monitoring and Management (PMM) while running this benchmark. We can see the amount of data written to the disk is 2x more than the amount of data being read from the disk.

Benchmarking 47

Benchmarking Database Operating System Architecture 47

Rigor

SEPTEMBER 11, 2019

Sergey is an open source developer, tireless educator on performance topics, and author of many web performance-related tools, including ShowSlow , SVN Assets , drop-in.htaccess and more. He tweets about Chrome initiatives, open source tools, and performance news @ paul_irish. Scott Jehl. Scott Jehl.

Performance 89

Performance Education Google Website 89

Smashing Magazine

JUNE 3, 2022

Since many new typefaces are not supplied with any objective concrete testing data, how do we determine how well they work and where they succeed or fail? Measuring Typefaces And The Resulting Performance Data. Diagram outlining the difficulties of testing and then cross comparing typeface testing data. Large preview ).

Performance 110

Performance Design Best Practices Testing 110

O'Reilly

JULY 25, 2023

I guessed that maybe ChatGPT only knew about v2 since it was trained on open-source code from before September 2021 (its knowledge cutoff date) and v2 was the dominant format before that date. To my surprise, it knew about v3 from its training data and generated a v3 manifest file for me in response.

Programming 98

Programming Code Design Benchmarking 98