Smashing Magazine

SEPTEMBER 28, 2022

Five Data-Loading Patterns To Improve Frontend Performance. Five Data-Loading Patterns To Improve Frontend Performance. Data loading patterns are an essential part of your application as they will determine which parts of your application are directly usable by visitors. But isn’t waiting for the data the point?

Performance 125

Performance Cache Servers Social Media 125

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. Redis returns a big list of database metrics when you run the info command on the Redis shell. This blog post lists the important database metrics to monitor.

Metrics 130

Metrics Monitoring Latency Cache 130

Dynatrace

AUGUST 1, 2022

Kubernetes was initially designed with a strong focus on stateless workloads, meaning these workloads do not need to store any persistent data. Interestingly, our partner RedHat reported in 2021 that around 80% of deployed workloads are databases or data caches, storing data in persistent volume claims (PVCs).

Storage 187

Storage Database Network Tuning 187

Percona

FEBRUARY 1, 2023

PostgreSQL is a fantastic database, but if you’re storing images, video, audio files, or other large data objects, you need to “toast” them to get optimal performance. This post will look at using The Oversized-Attribute Storage Technique (TOAST) to improve performance and scalability.

Storage 94

Storage Scalability Strategy Performance 94

Percona

SEPTEMBER 1, 2023

MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

Dynatrace

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Speed is next; serverless solutions are quick to spin up or down as needed, and there are no delays due to limited storage or resource access. Data Store. Reliability.

Serverless 280

Serverless AWS Lambda Storage 280

Scalegrid

DECEMBER 21, 2023

In today’s data-driven world, the ability to effectively monitor and manage data is of paramount importance. Redis®, a powerful in-memory data store, is no exception. Redis® Monitoring Essentials Ensuring the performance, reliability, and safety of a Redis® database requires active monitoring.

Strategy 130

Strategy Monitoring Latency DevOps 130

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. More in the following sub-section.)

Availability 111

Availability Database Open Source Hardware 111

ScaleOut Software

APRIL 22, 2020

In this time of extremely high online usage, web sites and services have quickly become overloaded, clogged trying to manage high volumes of fast-changing data. Maintaining rapidly changing data in back-end databases creates bottlenecks that impact responsiveness. The Solution: Distributed Caching.

Cache 52

Cache Storage Servers Database 52

ScaleOut Software

APRIL 22, 2020

In this time of extremely high online usage, web sites and services have quickly become overloaded, clogged trying to manage high volumes of fast-changing data. Maintaining rapidly changing data in back-end databases creates bottlenecks that impact responsiveness. The Solution: Distributed Caching.

Cache 52

Cache Storage Servers Database 52

Percona

MAY 1, 2023

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. The performance of a PostgreSQL database has a significant impact on the overall effectiveness of an application.

Tuning 52

Tuning Efficiency Database Performance 52

Percona

MAY 2, 2023

In today’s data-driven world, losing critical data can be catastrophic for any organization. As a MongoDB user, it’s crucial to ensure that your data is safe and secure in the event of a disaster or system failure. Why are MongoDB database backups important? Why are MongoDB database backups important?

Best Practices 52

Best Practices Database Storage Servers 52

Percona

APRIL 24, 2023

This post is about PostgreSQL, but most of the problems also apply to other database systems. The more indexes, the more the requirement of memory for effective caching. Indexes need more cache than tables Due to random writes and reads, indexes need more pages to be in the cache.

Tuning 129

Tuning Cache Storage Database 129

The Netflix TechBlog

OCTOBER 15, 2019

Part I: Overview Andreas Andreakis , Falguni Jhaveri , Ioannis Papapanagiotou , Mark Cho , Poorna Reddy , Tongliang Liu Overview It is a commonly observed pattern for applications to utilize multiple datastores where each is used to serve a specific need such as storing the canonical form of data (MySQL etc.), caching (Memcached etc.),

Transportation 192

Transportation Architecture Processing Storage 192

Percona

FEBRUARY 15, 2023

Bloom filters are an essential component of an LSM-based database engine like MyRocks. With MyRocks/RocksDB, data is stored in a set of large SST files. For good performance, the filter blocks are cached in the RocksDB block cache and normally stay there since they are accessed frequently.

Storage 130

Storage Tuning Cache Engineering 130

Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. By caching hot datasets, indexes, and ongoing changes, InnoDB can provide faster response times and utilize disk IO in a much more optimal way.

Performance 129

Performance Hardware Tuning Storage 129

Percona

APRIL 7, 2023

I’ve used a fourth instance to host a PMM server to monitor servers A and B and used the data collected by the PMM agents installed on the database servers to compare performance. That’s a heritage of the LAMP model when the same server would host both the database and the web server.

Tuning 138

Tuning Cache Servers Benchmarking 138

Scalegrid

NOVEMBER 23, 2023

Imagine a world where your PostgreSQL® database connections are seamless and secure. Key Takeaways Understanding PostgreSQL hostname is essential for successful database connections. Configure the PostgreSQL hostname by editing configuration files and restarting the server, with secure storage of connection details to enhance security.

Database 130

Database Servers Storage Network 130

The Morning Paper

JUNE 16, 2019

Towards multiverse databases Marzoev et al., A typical backing store for a web application contains data for many users. The application makes queries on behalf of an authenticated user, but it is up to the application itself to make sure that the user only sees data they are entitled to see. HotOS’19.

Database 90

Database Cache Benchmarking Efficiency 90

Percona

APRIL 17, 2023

We’ll also go over some best practices for MongoDB security as well as MongoDB data modeling. Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. Spoiler alert: This post focuses on MongoDB 3.6.X

Best Practices 52

Best Practices Design Tuning Database 52

SQL Performance

APRIL 27, 2020

Azure SQL Database is Microsoft's database-as-a-service offering that provides a tremendous amount of flexibility. Microsoft is continually working on improving their products and Azure SQL Database is no different. The basic tier provides up to 5 DTUs with standard storage. HyperScale Database. DTU Pricing Tier.

Azure 55

Azure Database Serverless Hardware 55

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. This includes metrics such as query execution time, the number of queries executed per second, and the utilization of query cache and adaptive hash index.

Performance 107

Performance Monitoring Traffic Database 107

n0derunner

JULY 23, 2019

Effect of removing CPU constraints and maintaining data locality on a running DB instance. As the DB continues to run on the new host – the Nutanix storage detects the access patterns and “localizes” the data that the DB is accessing. The post Impact of Data locality on DB workloads.

Benchmarking 76

Benchmarking Storage Tuning Cache 76

Percona

APRIL 3, 2023

SET WITHOUT OIDS; A list of tables with the problem is in the file: tables_with_oids.txt Failure, exiting postgres@xx.xx.xx.xx:~$ more tables_with_oids.txt In database: abs_test public.craft public.ports In database: postgres public.oid_test We can use the below SQL to find tables with OID, and it also generates the DDL to remove.

C++ 105

C++ Database Cache Storage 105

Percona

MARCH 28, 2023

Every database system has to ensure durability and reliability. It’s to ensure that our data is durable after each write operation and to make it persistent and consistent without compromising the performance. In terms of MongoDB, it achieves WAL and data durability using a combination of both Journaling and Checkpoints.

Hardware 91

Hardware C++ Storage Cache 91

Percona

JULY 25, 2023

When a new node joins the cluster, SST is performed to receive the data from DONOR to the JOINER. JOINER uses PXB to stream the data directory from DONOR. Percona XtraBackup copies the InnoDB data files. Percona XtraBackup copies the InnoDB data files. ibd2sdi data/test/t1.ibd ibd > t1.sdi

Cache 89

Cache Benchmarking Servers Design 89

Percona

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 102

Monitoring Scalability Cache Database 102

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. There are many times we get asked why some cloud instance performed poorly for their database application and almost always turned out to be some configuration error. For storage, FIO is generally used. Database: MySQL 8.0.31

Performance 54

Performance Benchmarking Cache Storage 54

All Things Distributed

SEPTEMBER 20, 2013

Traditionally records in a database were stored as such: the data in a row was stored together for easy and fast retrieval. Combined with the rise of data warehouse workloads, where there is often significant redundancy in the values stored in columns, and database models based on column oriented storage took off.

Storage 87

Storage Hardware Cache C++ 87

O'Reilly Software

JUNE 12, 2018

The benefits of modeling data as events as a mechanism to evolve our software systems. For as long as we’ve been talking about microservices, we’ve been talking about data. Data is all-important—vital for the continued success of our businesses—but has also been seen as a massive constraint in how we design and evolve our systems.

Database 72

Database Cache Architecture Latency 72

The Morning Paper

SEPTEMBER 10, 2019

Procella: unifying serving and analytical data at YouTube Chattopadhyay et al., Anchored in the primary use case of supporting Google’s YouTube business, what we’re looking at here could well be the future of data processing at Google. Because they had too many data processing systems! ;). VLDB’19. are divided.

Analytics 75

Analytics Latency Cache Google 75

Highly Scalable

SEPTEMBER 18, 2012

Although it can hardly be said that NoSQL movement brought fundamentally new techniques into distributed data processing, it triggered an avalanche of practical studies and real-life trials of different combinations of protocols and algorithms. Data Placement. Data Consistency. This fact is often referred to as the CAP theorem.

Database 213

Database Latency C++ Scalability 213

The Morning Paper

FEBRUARY 6, 2020

Last week we looked at a function shipping solution to the problem; Cloudburst uses the more common data shipping to bring data to caches next to function runtimes (though you could also make a case that the scheduling algorithm placing function execution in locations where the data is cached a flavour of function-shipping too).

Lambda 98

Lambda Serverless Cache Latency 98

Smashing Magazine

MAY 25, 2022

Properties of a data structure are considered reachable while the data structure is in memory, and they are usually kept in memory. WeakMap can be used in two areas of web development: caching and additional data storage. With caching, a copy of the result from a request is saved locally. Additional Data.

Cache 116

Cache Programming Storage Code 116

Percona

JULY 17, 2023

MongoDB Community Edition software might set the stage for achieving your high-volume database goals, but you quickly learn that its features fall short of your enterprise needs. The popularity of MongoDB MongoDB has emerged as a popular database platform. 5 among all database management systems and No. It ranks No.

Open Source 79

Open Source Database Scalability Software 79

Percona

JULY 5, 2023

Fragmentation is a common concern in some database systems. In databases, we can experiment with different types of fragmentation: Segment Fragmentation : segments are fragmented; they are stored not following the order of data, or there are empty pages gaps between the data pages. What is fragmentation?

Open Source 128

Open Source Database Efficiency Testing 128

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. In short, any data that is written must be consistent with the data present. The alternative is to split a consistent set of data into fragments.

Traffic 127

Traffic Scalability Database Servers 127