Percona

JANUARY 19, 2023

In this blog post, we will review key topics to consider for managing large datasets more efficiently in MySQL. Redundant indexes: It is known that accessing rows by fetching an index is more efficient than through a table scan in most cases. It can help us to save costs on storage and backup times.

Open Source 90

Open Source Storage Database Big Data 90

Percona

SEPTEMBER 1, 2023

Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. This results in expedited query execution, reduced resource utilization, and more efficient exploitation of the available hardware resources. Let’s explore these benefits in more detail.

Tuning 52

Tuning Database Performance Hardware 52

The Netflix TechBlog

MAY 21, 2019

The device ecosystem is rich with partners ranging from Silicon-on-Chip (SoC) manufacturers, Original Design Manufacturer (ODM) and Original Equipment Manufacturer (OEM) vendors. Solving the above problems could help Netflix and our Partners save time and money during the entire lifecycle of device design, build, test, and certification.

Testing 163

Testing AWS Lambda Network 163

Smashing Magazine

SEPTEMBER 28, 2022

On your first try, you can use it as a benchmark for optimizations later. On design systems, UX, web performance and CSS/JS. Caching partially stores your data and is not used as permanent storage. Using the cache as permanent storage is an anti-pattern. It is important to note how much data the client needs to download.

Cache 125

Cache Performance Servers Social Media 125

The Morning Paper

JUNE 16, 2019

Such a design rules out an entire class of application errors, protecting private data from accidentally leaking. Although state-of-the-are databases have security features designed for exactly this purpose, such as row-level access policies and grants of views, these features are too limiting for many web applications.

Database 90

Database Cache Benchmarking Efficiency 90

Scalegrid

MARCH 28, 2024

This article will explore how they handle data storage and scalability, perform in different scenarios, and, most importantly, how these factors influence your choice. Redis Data Types and Structures The design of Redis’s data structures emphasizes versatility. Memcached’s primary strength lies in its simplicity.

Cache 130

Cache Storage Scalability Architecture 130

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

Percona

DECEMBER 11, 2023

A Dedicated Log Volume (DLV) is a specialized storage volume designed to house database transaction logs separately from the volume containing the database tables. This separation aims to streamline transaction write logging, improving efficiency and consistency. Who can benefit from DLV? and later v10 versions MySQL: 8.0.28

AWS 99

AWS Benchmarking Performance Traffic 99

Scalegrid

JANUARY 12, 2024

This article analyzes cloud workloads, delving into their forms, functions, and how they influence the cost and efficiency of your cloud infrastructure. Storage is a critical aspect to consider when working with cloud workloads. This opens up possibilities not only difficult but almost impossible to attain conventionally!

Cloud 130

Cloud Virtualization Storage Efficiency 130

Dynatrace

NOVEMBER 11, 2020

Dynatrace OneAgent deployment and life-cycle management are already widely considered to be industry benchmarks for reliability and efficiency. Note that most of the changes we’ve introduced so far and those that are detailed below are all designed to be invisible to you, taking place entirely automatically in the background.

Best Practices 193

Best Practices Storage Java Benchmarking 193

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. However, although these results are the gold standard of database benchmarking to do so, requires time, expertise and not insignificant cost.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

JULY 1, 2023

With its support for MySQL and PostgreSQL, and its automated replication and backup capabilities, it’s designed to deliver high performance, scalability, and availability to meet the needs of mission-critical applications. This eliminates the need for complex or scripted backup procedures and designated backup windows.

AWS 52

AWS Database Serverless Storage 52

Percona

AUGUST 5, 2023

Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. If you don’t have well-designed and small columns for this composite primary key, it could enlarge all of your secondary indexes. ensures that only relevant partitions are accessed, further enhancing query efficiency.

Strategy 40

Strategy Storage Database Best Practices 40

Percona

JANUARY 24, 2023

This will be clearly visible in PostgreSQL performance benchmarks as a “ Sawtooth wave ” pattern observed by Vadim in his tests: As we can see, the throughput suddenly drops after every checkpoint due to heavy WAL writing and gradually picks up until the next checkpoint. But this comes with a considerable performance implication.

Database 118

Database Benchmarking Open Source Latency 118

Particular Software

SEPTEMBER 20, 2021

Why RPC is “faster” It’s tempting to simply write a micro-benchmark test where we issue 1000 requests to a server over HTTP and then repeat the same test with asynchronous messages. If you did such a benchmark, here’s an incomplete picture you might end up with: Graph of microbenchmark showing RPC is faster than messaging.

Benchmarking 97

Benchmarking Latency Servers Systems 97

Alex Russell

APRIL 29, 2021

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. With each team, benchmarks lost are understood as bugs. Chrome has missed several APIs for 3+ years: Storage Access API.

Media 145

Media Games Education Engineering 145

Percona

JUNE 22, 2023

Typically, the servers are configured in a primary/replica configuration, with one server designated as the primary server that handles all incoming requests and the others designated as replica servers that monitor the primary and take over its workload if it fails. This flexibility can be crucial in designing a scalable architecture.

Availability 110

Availability Database Open Source Hardware 110

Alex Russell

OCTOBER 22, 2017

Budgets are scaled to a benchmark network & device. Deciding what benchmark to use for a performance budget is crucial. Contended, over-subscribed cells can make “fast” networks brutally slow, transport variance can make TCP much less efficient , and the bursty nature of web traffic works against us.

Performance 68

Performance Benchmarking Network Mobile 68

ScaleOut Software

MAY 15, 2014

For example, the IMDG must be able to efficiently create millions of objects in each server to make use of its huge storage capacity. A Few Words on Design Philosophy: Keep It Simple. Use Fully Peer-to-Peer Design for Simplicity and High Availability. Testing Scale-Up Performance. Distributed Cache or In-Memory Data Grid?

Cache 40

Cache Servers Network Design 40

SQL Server According to Bob

JANUARY 11, 2020

Stable Media Stable media is often confused with physical storage. SQL Server defines stable media as storage that can survive system restart or common failure. Stable media is commonly physical disk storage, but other devices and certain caching facilities qualify as well. See the article for more details. SQL Server 7.0

Servers 40

Servers Cache Media Hardware 40

SQL Server According to Bob

JANUARY 11, 2020

​​ With new ​​ innovations ​​ come ​​ new terms, designs, ​​ and ​​ algorithms. This is different from ​​ the reference count design ​​ that was ​​ used in SQL Server 7.0 and ​​ 2000.

Servers 40

Servers Cache Database Media 40

High Scalability

NOVEMBER 25, 2019

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. Over time, costs for S3 and GCS became reasonable and with Egnyte’s storage plugin architecture, our customers can now bring in any storage backend of their choice.

Architecture 52

Architecture Cache Azure Storage 52

Smashing Magazine

JANUARY 6, 2020

Performance isn’t just a technical concern: it affects everything from accessibility to usability to search engine optimization, and when baking it into the workflow, design decisions have to be informed by their performance implications. Map design decisions against performance budget and the priorities defined early on.

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

JANUARY 11, 2021

Performance isn’t just a technical concern: it affects everything from accessibility to usability to search engine optimization, and when baking it into the workflow, design decisions have to be informed by their performance implications. It’s designed to capture delays that result from the main thread being busy, especially during page load.

Performance 145

Performance Cache Media Metrics 145