Percona

NOVEMBER 3, 2023

Sure, database migration is complex, particularly when you’re looking to migrate from a proprietary database to an open source one. Have you tuned your environment? This is particularly true when you’re migrating to an open source database that those on your staff may or may not be intimately familiar with.

Database 87

Database Open Source Benchmarking Strategy 87

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. The effective_cache_size provides an estimate of the memory available for disk caching. Conclusion.

Tuning 58

Tuning Database Performance Benchmarking 58

Scalegrid

MARCH 22, 2024

This process thoroughly assesses factors like cost-effectiveness, security measures, control levels, scalability options, customization possibilities, performance standards, and availability expectations. The challenges in integration come from varying APIs, data structures, and unique deployment schemes specific to each cloud platform.

Strategy 130

Strategy Cloud Government Innovation 130

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

Benchmark before you decide. Typically a good value is 70%-80% of available memory. If you see concurrency issues, you can tune this variable. Application tuning for InnoDB Make sure your application is prepared to handle deadlocks that may happen. Transparent huge pages (THP) disabled. I hope this helps!

Performance 130

Performance Hardware Tuning Storage 130

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. MySQL Performance Benchmark Configuration. For some of the tests on the ScaleGrid deployment, MySQL configuration binlog_group_commit_sync_delay is tuned so that the slave replication lag does not go beyond 30s.

AWS 183

AWS Latency Performance Benchmarking 183

HammerDB

OCTOBER 18, 2018

Before introducing how this works it is important to acknowledge the ASHMON tool from which this functionality was adopted and more importantly its author Kyle Hailey for giving permission to add it as open source. In this example a test with 2 minute rampup and 5 minute test time can be seen.

Benchmarking 40

Benchmarking Monitoring Performance C++ 40

Percona

OCTOBER 12, 2023

That said, your application may not be in the list of supported languages, but if it’s compatible with any of the available profilers, you can still produce flame graphs. In case the application is in Go, the selected profiler will be eBPF. ✔ Launching profiler. ✔ Profiling. Try Percona Distribution for MySQL today!

Code 114

Code Tuning C++ Benchmarking 114

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.}. Setup The setup consists of creating 10K tables with sysbench and adding 20 FKs to 20 tables.

Cache 106

Cache Hardware Servers Benchmarking 106

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 41

Database Tuning Performance AWS 41

Percona

JANUARY 19, 2023

There are a couple of blog posts from Yves that describe and benchmark MySQL compression: Compression Options in MySQL (Part 1) Compression Options in MySQL (Part 2) Archive or purge old or non-used data: Some companies have to retain data for multiple years either for compliance or for business requirements. It supports native sharding.

Open Source 92

Open Source Storage Database Big Data 92

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. However, it is crucial that the benchmarking application does not have inherent bottlenecks that artificially limits the scalability of the database. Basic Benchmarking Concepts. To benchmark a database we introduce the concept of a Virtual User.

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. Google Lighthouse Google Lighthouse is a free and open source tool that is part of the Google Chrome DevTools family. What is Performance Testing?

Testing Tools 55

Testing Tools Best Practices Performance Testing Testing 55

Smashing Magazine

JUNE 3, 2022

There are many typefaces, and many of them are very similar or are nearly identical to previous or contemporary versions available. We want to allow accessibility via OpenType or stylistic options with the typeface, so they are available to use if needed. Stay tuned! These points could be extended to language support as well.

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. Right now, widely-used benchmarks for AI code generation (e.g., Right now, widely-used benchmarks for AI code generation (e.g.,

Programming 98

Programming Code Design Benchmarking 98