Percona

MARCH 23, 2023

Benchmark before you decide. Some cloud providers also offer specialized instances for database workloads, which may provide additional features and optimizations for performance and scalability. If you see concurrency issues, you can tune this variable. Transparent huge pages (THP) disabled. I hope this helps!

Performance 144

Performance Hardware Tuning Storage 144

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

MAY 1, 2023

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. What is PostgreSQL performance tuning? Why is PostgreSQL performance tuning important?

Tuning 52

Tuning Database Efficiency Performance 52

High Scalability

AUGUST 24, 2021

No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search. Learn to balance architecture trade-offs and design scalable enterprise-level software. Check out Educative.io 's 5-part learning path: Scalability and System Design for Developers. Generous free tier.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

OCTOBER 27, 2021

No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search. Learn to balance architecture trade-offs and design scalable enterprise-level software. Check out Educative.io 's 5-part learning path: Scalability and System Design for Developers. Generous free tier.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 29, 2021

No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search. Learn to balance architecture trade-offs and design scalable enterprise-level software. Check out Educative.io 's 5-part learning path: Scalability and System Design for Developers. Generous free tier.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 15, 2021

No more hassles of benchmarking and tuning algorithms or building and maintaining infrastructure for vector search. Learn to balance architecture trade-offs and design scalable enterprise-level software. Check out Educative.io 's 5-part learning path: Scalability and System Design for Developers. Generous free tier.

Education 100

Education DevOps Infrastructure Benchmarking 100

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? A finely tuned database processes queries more efficiently, leading to swifter results.

Tuning 52

Tuning Database Performance Hardware 52

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 124

Cache Hardware Servers Benchmarking 124

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

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 124

Code Tuning C++ Benchmarking 124

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. Choosing the Right Cloud Services Choosing the right cloud services is crucial in developing an efficient multi cloud strategy.

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 55

Performance Benchmarking Cache Storage 55

Percona

NOVEMBER 3, 2023

Have you tuned your environment? This means they can ensure that every possible scenario is tested, from data integrity checks to performance benchmarks. Look for firms with a proven track record, positive client testimonials, and those that offer scalable solutions. What’s your plan to mitigate or minimize downtime?

Database 107

Database Open Source Benchmarking Strategy 107

Percona

AUGUST 30, 2018

Because recognizing if the workload is read intensive or write intensive will impact your hardware choices, database configuration as well as what techniques you can apply for performance optimization and scalability. Let’s examine the TPC-C Benchmark from this point of view, or more specifically its implementation in Sysbench.

Benchmarking 72

Benchmarking Database Operating System Architecture 72

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. Database benchmarking in parallel.

Programming 68

Programming Benchmarking Virtualization C++ 68

Percona

APRIL 12, 2023

They came up with a horizontally scalable NoSQL database. Though still not “profitable” by many benchmarks, it’s a lot closer to being so, perhaps in a big way.) Some might say this marked the beginning of MongoDB’s “cloud push” escalation.) 2017: MongoDB goes public, trading as MDB.

Open Source 98

Open Source Programming Database Servers 98

Smashing Magazine

JANUARY 5, 2022

That’s right; I’ve parked day-to-day design work in favor of becoming someone very active in the design community, focusing on best practice design advice and scalable systems. Stay tuned! I now find myself working as a Designer Advocate at Figma. We’re All Faking It. No one really knows what they are doing. I’d be happy to help!

Design 132

Design Website Social Media Best Practices 132

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. Quantitative performance testing looks at metrics like response time while qualitative testing is concerned with scalability, stability, and interoperability.

Testing Tools 55

Testing Tools Best Practices Performance Testing Testing 55

HammerDB

OCTOBER 12, 2018

For anyone benchmarking MySQL with HammerDB it is important to understand the differences from sysbench workloads as HammerDB is targeted at a testing a different usage model from sysbench. This is to be expected and is due to the limitations of the scalability of the storage engine. HammerDB difference from Sysbench. perf special.

Best Practices 40

Best Practices Scalability Performance C++ 40

Percona

AUGUST 5, 2023

Enhanced Scalability : Partitioning enhances the database’s ability to scale, as data can be distributed across different storage devices. This helps identify potential issues and fine-tune the partitioning strategy. In summary, MySQL partitioning brings substantial advantages to both query performance and maintenance.

Strategy 40

Strategy Storage Database Best Practices 40

Adrian Cockcroft

JUNE 21, 2022

I became the Sun UK local specialist in performance and hardware, and as Sun transitioned from a desktop workstation company to sell high end multiprocessor servers I was helping customers find and fix scalability problems. This was followed by a greatly expanded second edition with some additional chapters by Rich Pettit.

Tuning 52

Tuning Benchmarking Engineering C++ 52

Rigor

SEPTEMBER 11, 2019

He has a keen interest in web technologies, performance tuning, security, and the practical use of technology. Doug is a freelance mobile performance expert, a popular speaker – particularly on the topic of web tuning and image optimization – and the author of High Performance Android Apps. Doug Sillars. Doug Sillars.

Performance 89

Performance Education Google Website 89

SQL Server According to Bob

JANUARY 11, 2020

​​ However, the ​​ algorithm ​​ has been ​​ tuned ​​ and the resulting ​​ affect ​​ is ​​ minimal. ​​ For example, ​​ the I/O speed of a snapshot database could limit certain query scalabilities.

Servers 40

Servers Cache Database Media 40

High Scalability

NOVEMBER 25, 2019

For highly scalable services, going outside of java process is costly, even to go to Memcache or Redis so we do in-memory cache with varying TTL for some highly used data structures like access control computation, feature flags, routing metadata etc. The dedicated Security team runs automated security benchmark tests before every release.

Architecture 52

Architecture Cache Azure Storage 52