HammerDB

APRIL 19, 2023

In this blog, we aim to call out some key considerations when trying to assess MySQL performance for your application. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench.

Performance 54

Performance Benchmarking Cache Storage 54

Dynatrace

AUGUST 3, 2022

Spring4Shell is a critical vulnerability that emerged in March of 2022 that affects the Spring Java framework, an open-source platform for Java-based application development. The post Protect your organization against zero-day vulnerabilities appeared first on Dynatrace blog.

Java 187

Java Traffic Benchmarking Strategy 187

Percona

JUNE 22, 2023

A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance. In this blog, we will explore various MySQL KPIs that are basic and essential to track using monitoring tools like PMM.

Performance 102

Performance Monitoring Traffic Database 102

Scalegrid

OCTOBER 24, 2019

AWS is the #1 cloud provider for open-source database hosting, and the go-to cloud for MySQL deployments. MySQL Performance Benchmark Configuration. This technique is referred to as ‘slowing down the master to speed up the slaves’ and is explained in J-F Gagne’s blog. community edition. innodb_buffer_pool_size.

AWS 183

AWS Latency Performance Benchmarking 183

The Netflix TechBlog

OCTOBER 19, 2020

In our previous blog post we introduced Edgar, our troubleshooting tool for streaming sessions. 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. —?which is difficult when troubleshooting distributed systems.

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

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. The percentage in degradation will vary depending on many factors {hardware, workload, number of tables, configuration, etc.}. While you are on 5.7, Try Percona Distribution for MySQL today!

Cache 98

Cache Hardware Servers Benchmarking 98

Percona

JANUARY 19, 2023

16 years ago, our founder Peter Zaitsev covered this topic and some of the points described there are still valid, and we will cover more on this blog. In this blog post, we will review key topics to consider for managing large datasets more efficiently in MySQL. 1 mysql mysql 704M Dec 30 02:28 employees.ibd -rw-r --.

Open Source 85

Open Source Storage Database Big Data 85

Percona

JULY 25, 2023

In this blog post, we will describe the improvements to Percona XtraBackup 8.0.33-28 Benchmarks xtrabackup –prepare on backup directory of other sizes like 10K, 50K, 100K, and 250K tables. 28 (PXB), which significantly reduces the time to prepare the backups before the restore operation.

Cache 83

Cache Benchmarking Servers Design 83

Percona

OCTOBER 12, 2023

In this blog post, we’ll review how to run Linux profilers such as perf and produce flame graphs on Kubernetes environments. 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

Percona

JULY 19, 2023

In this blog post, you’ll learn how to set up a build environment for compiling your own MySQL plugin to be loaded into MySQL as a function. Look for part two, where we benchmark ULID in MySQL! How would you integrate some new fancy processing library into MySQL without having to recreate the complexities in pure SQL?

C++ 78

C++ Servers Benchmarking Best Practices 78

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 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.

Tuning 52

Tuning Efficiency Database Performance 52

Testsigma

MARCH 23, 2021

It is open source and its development can be ported across devices with relative ease. Unlike iOS development, Android development requires proper standards and varying benchmarks for performance and optimization. We’ve written a detailed blog post on the strategy and tools required for testing a mobile application.

Testing 52

Testing Mobile Testing Tools Strategy 52

Rigor

SEPTEMBER 11, 2019

Jake is a developer advocate at Google working with the Chrome team to develop and promote web standards and developer tools, as well as a contributor to the Chromium blog. He tweets about Chrome initiatives, open source tools, and performance news @ paul_irish. Jake Archibald. Paul Irish. Paul Irish. Scott Jehl. Scott Jehl.

Performance 89

Performance Education Google Website 89

Dynatrace

SEPTEMBER 23, 2021

Application developers commonly leverage open-source software when building containerized applications. In fact, the market research firm Forrester says that the average container image is comprised of 70% open-source software.[1] 1] And unfortunately, open-source software is often fraught with security vulnerabilities.

Open Source 250

Open Source Benchmarking Best Practices Network 250

Smashing Magazine

FEBRUARY 15, 2021

To figure out what exactly is the problem, we can use FFMPEG , which is open source and free, and proves to be one of the most reliable tools to optimize videos. In FFMPEG, the principal quality/size benchmark is the Constant Rate Factor (CRF) compression, with values ranging from 0 (no compression) to 50 (high compression).

Network 143

Network Speed Website Mobile 143

Percona

AUGUST 31, 2018

In this blog, we will establish basic guidelines for setting PostgreSQL database parameters to improve database performance according to workload. In production environments, it is observed that a large value for shared_buffer gives really good performance, though you should always benchmark to find the right balance. wal_buffers.

Tuning 54

Tuning Database Performance Benchmarking 54

Percona

DECEMBER 11, 2023

We performed a standard benchmarking test using the sysbench tool to compare the performance of a DLV instance vs a standard RDS MySQL instance, as shared in the following section. Benchmarking AWS RDS DLV setup Setup 2 RDS Single DB instances 1 EC2 Instance Regular DLV Enabled Sysbench db.m6i.2xlarge 2xlarge c5.2xlarge MySQL 8.0.31

AWS 93

AWS Benchmarking Performance Traffic 93

Percona

APRIL 6, 2023

PostgreSQL is a popular open source relational database management system many organizations use to store and manage their data. In this blog post, we will explore the benefits of using pgpool-II for PostgreSQL. Two benchmarks from users can be found here: [1] [2] 4. Pgpool-II This is where the pgpool-II comes in.

Cache 111

Cache Open Source Benchmarking Database 111

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

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

Percona

JUNE 22, 2023

” Here are additional metrics used to determine the reliability of a database, make adjustments that minimize downtime, and set benchmarks for meeting business continuity requirements. The transparency of open code enhances security as potential vulnerabilities can be identified and patched more quickly by the community.

Availability 104

Availability Database Open Source Hardware 104

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 If you want to learn more about it, Jay Janssen wrote a nice blog post ( innodb_buffer_pool_size – Is 80% of RAM the right amount? dissecting it a few years ago.

Tuning 133

Tuning Cache Servers Benchmarking 133

Testsigma

MAY 19, 2020

Several open source and paid test automation tools are available today but selecting the right tool for your needs isn’t easy. It’s not about open source vs paid, it’s more about how much it solves your problem. Selecting the Wrong Automation Tool. Check the article here on how to choose the right test automation tool.

Software 85

Software Software Testing Open Source 85

Percona

AUGUST 22, 2023

This blog article will examine shared attributes of high availability (HA) and fault tolerance (FT). We’ll wrap it up by suggesting high availability open source solutions, and we’ll introduce you to support options for ensuring continuous high performance from your systems. What does high availability mean?

Availability 77

Availability Hardware Open Source Database 77

Alex Russell

APRIL 29, 2021

Apple Corporate is at fault, not Open Source engineers or the line managers who support them. 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. So is speedy resolution and agreement.

Media 145

Media Games Education Engineering 145

O'Reilly

JULY 25, 2023

So far I’ve read a gazillion blog posts about people’s experiences with these AI coding assistance tools. 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.

Programming 98

Programming Code Design Benchmarking 98

Percona

JULY 1, 2023

In this blog, we will answer all of these important questions and provide a general overview comparing the two database services, Aurora vs RDS. Doing extensive benchmarks will be the subject of a future blog post. In any case, you should benchmark both RDS MySQL and Aurora before taking the decision to migrate.

AWS 52

AWS Database Serverless Storage 52

Speed Curve

OCTOBER 19, 2015

The practice of using budgets to track performance took off with Tim Kadlec's blog post Setting a Performance Budget. Benchmark a variety of metrics and choose a target of 20% faster or less resources. SpeedCurve's Benchmark dashboard is a great way to see how you compare to your competitors for setting budgets. Speed Index.

Performance 45

Performance Benchmarking Metrics Media 45

CSS - Tricks

JUNE 5, 2020

In 2015, Google published a blog post announcing Brotli and released its source code on GitHub. In my benchmarks, Brotli:11 takes several hundred milliseconds to compress a single minified jQuery file. Brotli’s beginning…. The pair of developers who created Brotli also created Google’s Zopfli compression two years earlier.

Cache 79

Cache Website Servers Open Source 79

Enprowess

SEPTEMBER 20, 2021

is a structural, open-source progressive JavaScript framework used to build complex UIs and single-page applications (SPAs). It is an open-source front-end library based on JavaScript used in web development for creating interactive components and User Interfaces. appeared first on EnProwess Blog. link] Rendering.

Open Source 52

Open Source Mobile Scalability Google 52

Percona

SEPTEMBER 1, 2023

This blog was originally published in November 2021 and was updated in September 2023. Testing and Benchmarking : Thoroughly test triggers in a staging environment to evaluate their impact on performance. Benchmark different trigger implementations to identify the most efficient option. Looking for Comprehensive MySQL Support?

Cache 59

Cache Database Games Healthcare 59

Percona

NOVEMBER 3, 2023

Leveraging pgbench , which is a benchmarking utility that comes bundled with PostgreSQL, I will put the cluster through its paces by executing a series of DML operations. 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

Smashing Magazine

JUNE 2, 2021

The project consisted of upgrading the shop software to our own open-source system and redoing the shop’s front end from scratch. Today, the website is much faster and ranks highly in various showcases and benchmarks. Some Performance Blog Posts I’ve Bookmarked And Read Lately ,” Chris Coyier, CSS-Tricks. “

Performance 115

Performance Cache Website Mobile 115

Smashing Magazine

JANUARY 11, 2021

dashboard (open source), SpeedCurve and Calibre are just a few of them, and you can find more tools on perf.rocks. So, if your year-over-year web performance metrics stay stable, that's usually a warning sign as you're actually regressing as the environment keeps improving ( details in a blog post by Gilles Dubuc ).

Performance 145

Performance Cache Media Metrics 145