Percona

MARCH 23, 2023

This blog is in reference to our previous ones for ‘Innodb Performance Optimizations Basics’ 2007 and 2013. Although there have been many blogs about adjusting MySQL variables for better performance since then, I think this topic deserves a blog update since the last update was a decade ago, and MySQL 5.7

Performance 124

Performance Hardware Tuning Storage 124

Smashing Magazine

SEPTEMBER 28, 2022

Five Data-Loading Patterns To Improve Frontend Performance. Five Data-Loading Patterns To Improve Frontend Performance. When it comes to performance, you shouldn’t be stingy. Every unnecessary bit of JavaScript code you bundle and serve will be more code the client has to load and process. Active Memory Caching.

Performance 127

Performance Cache Servers Social Media 127

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. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 102

Performance Monitoring Traffic Database 102

Dynatrace

DECEMBER 21, 2023

Level 2: Hosts and containers You might run thousands of hosts and containers, many of which have been sized by prioritizing performance over energy consumption. Reduce the volume of data volumes requested from databases (for example, request all, filter in memory). Reduce inter-process communications overhead.

Cloud 198

Cloud Energy Best Practices Cache 198

Dynatrace

JANUARY 16, 2023

The study analyzes factual Kubernetes production data from thousands of organizations worldwide that are using the Dynatrace Software Intelligence Platform to keep their Kubernetes clusters secure, healthy, and high performing. The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Java, Go, and Node.js

Open Source 333

Open Source Java Operating System Programming 333

High Scalability

JANUARY 11, 2022

from a client it performs two parallel operations: i) persisting the action in the data store ii) publish the action in a streaming data store for a pub-sub model. User Feed Service, Media Counter Service) read the actions from the streaming data store and performs their specific tasks. After that, the various services (e.g.

Design 334

Design Media Storage Logistics 334

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. HA is sometimes confused with “fault tolerance.”

Availability 105

Availability Database Open Source Hardware 105

Scalegrid

DECEMBER 21, 2023

Buckle up as we delve into the world of Redis® monitoring, exploring the most important Redis® metrics, discussing essential tools, and even peering into the future of Redis® performance management. Key Takeaways Redis® monitoring is essential for safeguarding performance, reliability, and security.

Strategy 130

Strategy Monitoring Latency DevOps 130

ScaleOut Software

APRIL 22, 2020

Maintaining rapidly changing data in back-end databases creates bottlenecks that impact responsiveness. In addition, repeatedly accessing back-end databases to serve up popular items, such as product descriptions and news stories, also adds to the bottleneck. The Solution: Distributed Caching.

Cache 52

Cache Storage Servers Database 52

ScaleOut Software

APRIL 22, 2020

Maintaining rapidly changing data in back-end databases creates bottlenecks that impact responsiveness. In addition, repeatedly accessing back-end databases to serve up popular items, such as product descriptions and news stories, also adds to the bottleneck. The Solution: Distributed Caching.

Cache 52

Cache Storage Servers Database 52

Dynatrace

MAY 13, 2022

This extension provides fully app-centric Cassandra performance monitoring for Azure Managed Instance for Apache Cassandra. Apache Cassandra is an open-source, distributed, NoSQL database. Microsoft Azure offers multiple ways to manage Apache Cassandra databases. You can also analyze table metrics, such as cache hits and misses.

Azure 229

Azure Latency Metrics Infrastructure 229

DZone

DECEMBER 28, 2020

In this post, we will mostly be talking about a few things that we should keep in mind while writing web APIs to get the best possible performance out of them. Most organizations work with large amounts of data that need to be processed every second. This process may take some time. Virtual Tables. Let's look at an example.

Performance 189

Performance Virtualization Database Processing 189

Scalegrid

DECEMBER 19, 2019

It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. When PgBouncer receives a client connection, it first performs authentication on behalf of the PostgreSQL server. How Does PgBouncer Work?

Cache 246

Cache Architecture Database Servers 246

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. Are these results good enough?

Tuning 135

Tuning Cache Servers Benchmarking 135

Scalegrid

JANUARY 5, 2024

If you’re considering a database management system, understanding these benefits is crucial. DBMS enhances data security with encryption, implements various access controls, and enables improved data sharing and concurrent access, thus facilitating quick response to changes and maintaining consistent database accuracy.

Efficiency 147

Efficiency Storage Database Scalability 147

Percona

AUGUST 31, 2018

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. It is important to pay attention to performance when writing database queries. PostgreSQL’s Tuneable Parameters.

Tuning 55

Tuning Database Performance Benchmarking 55

HammerDB

APRIL 19, 2023

Predicting application performance is a difficult art, but an important one when choosing the target deployment environment. Among the different components of modern software solutions, the database is one of the most critical. Benchmarking the target Two of the more popular database benchmarks for MySQL are HammerDB and sysbench.

Performance 54

Performance Benchmarking Cache Storage 54

Smashing Magazine

AUGUST 3, 2023

How We Optimized Performance To Serve A Global Audience How We Optimized Performance To Serve A Global Audience Liran Cohen 2023-08-03T10:00:00+00:00 2023-08-03T13:06:00+00:00 I work for Bookaway , a digital travel brand. Large preview ) We’ve known for a long time that fast page performance influences search engine rankings.

Performance 75

Performance Cache Traffic Metrics 75

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

Percona

MAY 10, 2023

I have seen many Linux Performance engineers looking at the “IOWait” portion of CPU usage as something to indicate whenever the system is I/O-bound. ” If, however, it got idle because a process is waiting on disk, I/O time is counted towards “IOWait.”

Cache 142

Cache Monitoring Open Source Processing 142

The Morning Paper

FEBRUARY 20, 2020

Extending relational query processing with ML inference , Karanasos, CIDR’10. The motivation is not that inference will perform better inside the database, but that the database is the best place to take advantage of enterprise features (transactions, security, auditing, HA, and so on). An INSERT INTO model.

Processing 72

Processing Hardware Database Azure 72

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. Caches | 12.4G Caches | 12.4G

Cache 96

Cache Database Virtualization Servers 96

Scalegrid

JULY 29, 2020

In our final post, we will put them head-to-head in a detailed feature comparison and compare the results of PgBouncer vs. Pgpool-II performance for your PostgreSQL hosting ! Part 4 – PgBouncer vs. It uses only one process which makes it very lightweight. If we require N parallel connections, this forks N child processes.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

Dynatrace

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Using a low-code visual workflow approach, organizations can orchestrate key services, automate critical processes, and create new serverless applications. Data Store.

Serverless 269

Serverless AWS Lambda Storage 269

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

SEPTEMBER 1, 2023

MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. A Trigger in MySQL is a database object that plays a pivotal role in database management. What is a Trigger in MySQL?

Cache 60

Cache Database Games Healthcare 60

Highly Scalable

AUGUST 20, 2013

The shortcomings and drawbacks of batch-oriented data processing were widely recognized by the Big Data community quite a long time ago. It became clear that real-time query processing and in-stream processing is the immediate need in many practical applications. Fault-tolerance.

Big Data 154

Big Data Processing Lambda Database 154

Percona

AUGUST 8, 2023

Or worse yet, sometimes I get questions about regaining normal operations after a traffic increase caused performance destabilization. Unfortunately, this topic is more of an art than a science, given that there is really no foolproof algorithm or approach that can tell you exactly where you might hit a bottleneck with server performance.

Traffic 88

Traffic Cache Monitoring Database 88

Dynatrace

AUGUST 30, 2019

Digital Performance: 99% reduction in Response Time, from 18.2s Infrastructure Optimization: 100% improvement in Database Connectivity. Dynatrace Real User Monitoring (RUM) captures very detailed user behavior, as well as experience and performance information, about every user on your applications.

Cache 190

Cache Architecture Database Government 190

Scalegrid

FEBRUARY 8, 2024

At its core, a distributed storage system comprises three main components: a controller for managing the system’s operations, an internal datastore where information is held, and databases geared towards ensuring scalability, partitioning capabilities, and high availability for all types of data.

Storage 130

Storage Systems Big Data Azure 130

IO River

NOVEMBER 2, 2023

Do continue reading to gain a deep dive into static and dynamic content, its differences, pros, and cons while focusing on the best ways to optimize performance on websites that use such content.‍What These are unchanging entities, served straight off the server, pre-generated, and devoid of server-side processing.

Cache 52

Cache Social Media Website Performance Website 52

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. Isolated parts of the database can serve read/write requests in case of network partition.

Database 213

Database Latency C++ Scalability 213

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 88

Storage Scalability Strategy Performance 88

Speed Curve

FEBRUARY 5, 2024

That performance golden rule still holds true today. desc="Time to process request at origin" NOTE: This is not a new API. Charlie Vazac introduced server timing in a Performance Calendar post circa 2018. Caching the base page/HTML is common, and it should have a positive impact on backend times.

Servers 57

Servers Cache Retail Benchmarking 57

Percona

JULY 25, 2023

When a new node joins the cluster, SST is performed to receive the data from DONOR to the JOINER. Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again. The redo apply phase wouldn’t make the database consistent with respect to a transaction. ibd2sdi data/test/t1.ibd

Cache 85

Cache Benchmarking Servers Design 85

Dynatrace

OCTOBER 21, 2020

If that’s the case, the update process continues to the next set of clusters and that process continues until all clusters are updated to the new version. The method was reading custom geographical locations for Dynatrace’s RUM geo-mapping capability and then validated against the Geographical Database Service.

Code 238

Code Cloud Engineering Java 238

Jos

JUNE 2, 2018

Web Performance is not only about understanding what makes a site fast. Performance is a feature and needs to be prioritized as such. Performance is a topic that has interested me for a long time. Moving over to web, the performance problems are different. This is not a post explaining why web performance is important.

Performance 237

Performance Speed Google Media 237