Percona

MARCH 23, 2023

As datasets continue to grow in size, the amount of RAM required to store and process these datasets also increases. Storage The type of storage and disk used for database servers can have a significant impact on performance and reliability. Benchmark before you decide. Transparent huge pages (THP) disabled.

Performance 124

Performance Hardware Tuning Storage 124

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. The Transaction Processing Performance Council (TPC) was founded to bring standards to database benchmarking, and the history of the TPC can be found here.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

The Netflix TechBlog

NOVEMBER 22, 2019

This entertaining romp through the tech stack serves as an introduction to how we think about and design systems, the Netflix approach to operational challenges, and how other organizations can apply our thought processes and technologies. In order to maintain performance, benchmarking is a vital part of our system’s lifecycle.

AWS 100

AWS Entertainment Open Source Benchmarking 100

The Netflix TechBlog

NOVEMBER 22, 2019

This entertaining romp through the tech stack serves as an introduction to how we think about and design systems, the Netflix approach to operational challenges, and how other organizations can apply our thought processes and technologies. In order to maintain performance, benchmarking is a vital part of our system’s lifecycle.

AWS 100

AWS Entertainment Open Source Benchmarking 100

Percona

JULY 1, 2023

These may be performance, high availability, operational cost, management, capacity planning, scalability, security, monitoring, etc. Aurora Features High Performance and Scalability Amazon Aurora has gained widespread recognition for its exceptional performance and scalability, making it an ideal solution for handling demanding workloads.

AWS 52

AWS Database Serverless Storage 52

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. My key takeaways as a TL;DR: Store your data in S3 Use portable data format that gives you future flexibility to process it with multiple different systems (e.g. Key findings.

Architecture 76

Architecture Cloud Storage Serverless 76

Scalegrid

JULY 13, 2020

of PostgreSQL users are currently in the process of migrating to the RDBMS, according to the 2019 PostgreSQL Trends Report , an astounding percentage considering this is the 4th most popular database in the world. Scalability. PostgreSQL offers free scalability, and can scale up to millions of transactions per seconds.

Open Source 244

Open Source Tuning C++ Database 244

The Netflix TechBlog

MAY 21, 2019

Partners across the globe leverage Netflix device certification process on a continual basis to ensure that quality products and experiences are delivered to their customers. The certification process involves the verification of partner’s implementation of features provided by the Netflix SDK. We also provide an API client in Python.

Testing 163

Testing AWS Lambda Network 163

Percona

SEPTEMBER 1, 2023

A finely tuned database processes queries more efficiently, leading to swifter results. Scalability As your data volume and user base expand, a finely tuned database can seamlessly accommodate increased workloads without compromising performance. This can significantly elevate user satisfaction and engagement.

Tuning 52

Tuning Database Performance Hardware 52

Percona

JUNE 22, 2023

It also supports the flexibility and scalability of the database infrastructure. ” 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. Networking equipment (switches, routers, etc.)

Availability 106

Availability Database Open Source Hardware 106

Percona

MAY 1, 2023

Hardware optimization : You need to ensure that the CPU, memory, and storage components meet the performance requirements of the database workload. PostgreSQL performance optimization is an ongoing process involving monitoring, benchmarking, and adjustments to maintain high-performing PostgreSQL databases.

Tuning 52

Tuning Efficiency Database Performance 52

HammerDB

OCTOBER 12, 2018

As is also the case this limitation is at the database level (especially the storage engine) rather than the hardware level. InnoDB is the storage engine that will deliver the best OLTP throughput and should be chosen for this test. . Fortunately HammerDB allows all of this process to be automated.

Best Practices 40

Best Practices Scalability Performance C++ 40

HammerDB

DECEMBER 5, 2020

The HammerDB TPROC-C workload by design intended as CPU and memory intensive workload derived from TPC-C – so that we get to benchmark at maximum CPU performance at a much smaller database footprint. more transactions than system B in the fully audited benchmark then the HammerDB result was also 1.5X I.e. if system A generated 1.5X

C++ 40

C++ Benchmarking Virtualization Open Source 40

Abhishek Tiwari

DECEMBER 27, 2017

In 2018, a widespread adaptation of Kubernetes for big data processing is anitcipated. faster access to external storage and data locality (I/O, bandwidth). Under the hood, the BlueData used several enhancements to boosts the I/O performance and scalability of container-based clusters. Performance. Native frameworks.

Big Data 63

Big Data Storage Benchmarking Hardware 63

Percona

AUGUST 5, 2023

Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. This method distributes data evenly across partitions to achieve balanced storage and optimal query performance. You want to ensure that table lookups go to the correct partition or group of partitions.

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. Paul Reithmuller was yet another imported Australian engineer who did amazing work.

Tuning 52

Tuning Benchmarking Engineering C++ 52

Smashing Magazine

SEPTEMBER 28, 2022

Every unnecessary bit of JavaScript code you bundle and serve will be more code the client has to load and process. On your first try, you can use it as a benchmark for optimizations later. Caching partially stores your data and is not used as permanent storage. Using the cache as permanent storage is an anti-pattern.

Cache 126

Cache Performance Servers Social Media 126

The Netflix TechBlog

NOVEMBER 22, 2019

This entertaining romp through the tech stack serves as an introduction to how we think about and design systems, the Netflix approach to operational challenges, and how other organizations can apply our thought processes and technologies. In order to maintain performance, benchmarking is a vital part of our system’s lifecycle.

AWS 37

AWS Entertainment Open Source Benchmarking 37

High Scalability

NOVEMBER 25, 2019

Your Laptop has a filesystem used by hundreds of processes. It is limited by the disk space; it can’t expand storage elastically; it chokes if you run few I/O intensive processes or try collaborating with 100 other users. On prem data processing. Optimize on prem cold storage cost. Video Transcoding.

Architecture 52

Architecture Cache Azure Storage 52

SQL Server According to Bob

JANUARY 11, 2020

DBCC Page Auditing DBCC page auditing is the process of executing common DBCC consistency checks as pages are read from disk. Streams ​​ NTFS volumes ​​ enable ​​ data files to have one or more secondary storage streams.

Servers 40

Servers Cache Database Media 40

Smashing Magazine

JANUARY 6, 2020

So, if we created an overview of all the things we have to keep in mind when improving performance — from the very start of the process until the final release of the website — what would that list look like? Also, as Patrick Meenan suggested, it’s worth to plan out a loading sequence and trade-offs during the design process.

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 11, 2021

Micro-optimizations are great for keeping performance on track, but it’s critical to have clearly defined targets in mind — measurable goals that would influence any decisions made throughout the process. Also, as Patrick Meenan suggested, it’s worth to plan out a loading sequence and trade-offs during the design process.

Performance 145

Performance Cache Media Metrics 145