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? Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

Scalegrid

JUNE 22, 2020

Compare Latency. On average, ScaleGrid achieves almost 30% lower latency over DigitalOcean for the same deployment configurations. MySQL DigitalOcean Performance Benchmark. We are going to use a common, popular plan size using the below configurations for this performance benchmark: Comparison Overview. Compare Pricing.

Database 217

Database Benchmarking Latency Performance 217

InfoQ

DECEMBER 4, 2023

LinkedIn was able to dramatically improve the scalability and performance of its Espresso database by migrating it from HTTP1.1 to HTTP2, resulting in a reduction in the number of connections, latency, and garbage collection times. By Rafal Gancarz

Latency 101

Latency Scalability Database Performance 101

The Netflix TechBlog

MARCH 5, 2024

Reduced tail latencies In both our GRPC and DGS Framework services, GC pauses are a significant source of tail latencies. For a given CPU utilization target, ZGC improves both average and P99 latencies with equal or better CPU utilization when compared to G1. No explicit tuning has been required to achieve these results.

Latency 234

Latency Java Tuning Efficiency 234

Scalegrid

SEPTEMBER 10, 2024

Additionally, we’ve added the Philadelphia AWS Local Zone , helping to reduce latency for customers operating in the eastern U.S. This enables ScaleGrid users in Australia and nearby regions to access lower-latency services and improved performance. Stay tuned for more exciting updates in the months to come! <p>The

Latency 130

Latency AWS Storage Tuning 130

The Netflix TechBlog

MAY 4, 2023

Migrating Critical Traffic At Scale with No Downtime — Part 1 Shyam Gala , Javier Fernandez-Ivern , Anup Rokkam Pratap , Devang Shah Hundreds of millions of customers tune into Netflix every day, expecting an uninterrupted and immersive streaming experience. This approach has a handful of benefits.

Traffic 344

Traffic Latency Tuning Systems 344

The Netflix TechBlog

SEPTEMBER 10, 2024

Finally, the device receives the message, and the action, such as “Show me Stranger Things on Netflix”, is performed. Dynomite had great performance, but it required manual scaling as the system grew. In our case, we value low latency — the faster we can read from KeyValue, the faster these messages can get delivered.

Latency 228

Latency Cache Tuning Efficiency 228

The Netflix TechBlog

NOVEMBER 12, 2024

By: Rajiv Shringi , Oleksii Tkachuk , Kartik Sathyanarayanan Introduction In our previous blog post, we introduced Netflix’s TimeSeries Abstraction , a distributed service designed to store and query large volumes of temporal event data with low millisecond latencies. Today, we’re excited to present the Distributed Counter Abstraction.

Latency 224

Latency Cache Infrastructure Strategy 224

Scalegrid

OCTOBER 24, 2019

As organizations continue to migrate to the cloud, it’s important to get in front of performance issues, such as high latency, low throughput, and replication lag with higher distances between your users and cloud infrastructure. MySQL on AWS Performance Test. AWS High Performance XLarge (see system details below).

AWS 183

AWS Latency Performance Performance Testing 183

Scalegrid

NOVEMBER 4, 2024

Performance Benchmarking of PostgreSQL on ScaleGrid vs. AWS RDS Using Sysbench This article evaluates PostgreSQL’s performance on ScaleGrid and AWS RDS, focusing on versions 13, 14, and 15. PostgreSQL 14 : Focused on improving parallel query performance and increased functionality for JSON data types.

Benchmarking 130

Benchmarking AWS Tuning Metrics 130

Dynatrace

JANUARY 14, 2022

That is because Kubernetes provides several benefits from a performance perspective. However, setting the right parameters for Kubernetes clusters to ensure application availability, performance, and resilience while avoiding overspending isn’t a walk in the park. SREcon21 – Automating Performance Tuning with Machine Learning.

Latency 215

Latency Tuning Efficiency AWS 215

Dynatrace

JULY 22, 2024

Telemetry Telemetry involves collecting and analyzing data from distributed sources to provide insights into how a system is performing. Quantitative measurements that track the performance and health of systems over time. Traces are used for performance analysis, latency optimization, and root cause analysis.

Latency 244

Latency Best Practices Metrics Open Source 244

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 128

Performance Hardware Tuning Storage 128

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. You might already use ScaleGrid hosting for Redis hosting to power your performance-sensitive applications.

Metrics 130

Metrics Monitoring Latency Cache 130

The Netflix TechBlog

JUNE 14, 2023

This blog post will share broadly-applicable techniques (beyond GraphQL) we used to perform this migration. To determine customer impact, we could compare various metrics such as error rates, latencies, and time to render. We then collect and analyze the performance of the two clusters. Are users clicking play at the same rates?

Traffic 356

Traffic Latency Cache Metrics 356

Dynatrace

MARCH 29, 2024

During a breakout session at Dynatrace Perform 2024 , Alois Mayr, principal product manager at Dynatrace, and Stefano Doni, CTO at Akamas, broke down how Dynatrace and Akamas can help organizations enhance Kubernetes cluster management. Consider a sudden drop in performance. “Additionally, we are full-stack and goal-oriented.

Engineering 237

Engineering DevOps Operating System Open Source 237

SQL Performance

SEPTEMBER 17, 2019

This article will cover many areas that database administrators need to be aware of in order to properly license, recover, and tune a Reporting Services installation. Tuning Options. Tuning SSRS is much like any other application. Disk latency for ReportServer and ReportServerTempDB are very important. General Tuning.

Tuning 67

Tuning Servers Database Best Practices 67

Scalegrid

NOVEMBER 20, 2019

By having appropriate indexes on your MySQL tables, you can greatly enhance the performance of SELECT queries. During this time, you are also likely to experience a degraded performance of queries as your system resources are busy in index-creation work as well. Performance Benefits of Rolling Index Creation. EC2 instance m4.large

Best Practices 239

Best Practices Latency Tuning Database 239

Dynatrace

MAY 17, 2023

Validation tasks are then extended left to cover performance testing and release validation in a pre-production environment. More precisely, this team uses AWS Fault Injection Simulator (FIS) to run fault injection to improve the application’s performance and resiliency. The queries are depicted below (sensitive data has been removed).

DevOps 197

DevOps Traffic Latency Best Practices 197

The Netflix TechBlog

MARCH 4, 2024

Operational automation–including but not limited to, auto diagnosis, auto remediation, auto configuration, auto tuning, auto scaling, auto debugging, and auto testing–is key to the success of modern data platforms. Auto Remediation generates recommendations by considering both performance (i.e., Multi-objective optimizations.

Tuning 214

Tuning Efficiency Big Data Engineering 214

The Netflix TechBlog

JANUARY 10, 2024

This architecture shift greatly reduced the processing latency and increased system resiliency. We expanded pipeline support to serve our studio/content-development use cases, which had different latency and resiliency requirements as compared to the traditional streaming use case. divide the input video into small chunks 2.

Processing 234

Processing Media Latency Innovation 234

Percona

APRIL 13, 2023

In PostgreSQL, replication lag can occur due to various reasons such as network latency, slow disk I/O, long-running transactions, etc. Replication lag can occur due to various reasons, such as: Network latency: Network latency is the delay caused by the time it takes for data to travel between the primary and standby databases.

Latency 84

Latency Tuning Open Source Network 84

The Netflix TechBlog

MARCH 1, 2021

It supports both high throughput services that consume hundreds of thousands of CPUs at a time, and latency-sensitive workloads where humans are waiting for the results of a computation. The subsystems all communicate with each other asynchronously via Timestone, a high-scale, low-latency priority queuing system.

Serverless 233

Serverless Media Latency Social Media 233

Percona

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? To be fair, that is also true with PostgreSQL; it hasn’t been tuned either, and it, too, can also perform much better.

Tuning 137

Tuning Cache Servers Benchmarking 137

Dynatrace

APRIL 25, 2023

It helps developers and operators identify and troubleshoot issues, optimize performance and improve user experience. Higher latency and cold start issues due to the initialization time of the functions. Understanding cold-start behavior is essential to tune your cloud applications cost or performance to meet your operational needs.

Serverless 218

Serverless Lambda Azure AWS 218

Scalegrid

AUGUST 27, 2024

Key features of RabbitMQ, such as message acknowledgments, complex routing, and asynchronous processing, contribute to system reliability and performance. This decoupling allows for smoother and more efficient communication between different components of an application, boosting overall system performance and reliability.

Ecommerce 130

Ecommerce IoT Games Scalability 130

The Netflix TechBlog

OCTOBER 27, 2020

Iceberg is widely adopted in Netflix as a data warehouse table format that addresses many of the usability and performance problems with Hive tables. The data warehouse is not designed to serve point requests from microservices with low latency. The processed data is typically stored as data warehouse tables in AWS S3.

Latency 249

Latency Storage Big Data Tuning 249

InfoQ

JANUARY 26, 2024

The company evolved the guild component, which is responsible for fanning out billions of message notifications, in a series of performance and scalability improvements supported by system observability and performance tuning. By Rafal Gancarz

Servers 106

Servers Tuning Scalability Performance 106

DZone

JULY 10, 2019

In addition, compute and storage are increasingly being separated causing larger latencies for queries. Alluxio is leveraged as compute-side virtual storage to improve performance. But to get the best performance, like any technology stack, you need to follow the best practices. A Note on Data Locality.

Best Practices 127

Best Practices Latency Storage Tuning 127

The Netflix TechBlog

JUNE 13, 2023

A small percentage of production traffic is redirected to the two new clusters, allowing us to monitor the new version’s performance and compare it against the current version. Canaries also provide an opportunity to measure system performance under different load conditions, allowing us to identify and resolve any performance bottlenecks.

Traffic 282

Traffic Metrics Systems Strategy 282

The Netflix TechBlog

SEPTEMBER 24, 2021

The ProRes codec family provides great editing performance and image quality. Uploading and downloading data always come with a penalty, namely latency. Doing so has the added advantage of being able to design and tune the enhancement to suit the requirements of packager and our other encoding applications.

Cloud 240

Cloud Media Storage Cache 240

Dynatrace

JULY 18, 2023

While infrastructure has historically been treated as a bottleneck where proper scaling and compute power are applied to improve performance, these aspects are now typically addressed by hyperscalers that offer cloud-based infrastructure and infrastructure as a service. You can read all about it in our Configuration as Code documentation.

Best Practices 200

Best Practices Code Infrastructure Latency 200

Percona

AUGUST 10, 2018

The performance of a PostgreSQL database can be compromised by dead tuples, since they continue to occupy space and can lead to bloat. Now, though, it’s time to look at autovacuum for postgres, and the internals you to know to maintain a high performance PostgreSQL database needed by demanding applications.

Tuning 45

Tuning Cache Database Storage 45

Percona

NOVEMBER 3, 2023

Repeating the benchmark once again demonstrates that performance has degraded somewhat. And now, execute the benchmark: -- execute the following on the coordinator node pgbench -c 20 -j 3 -T 60 -P 3 pgbench The results are not pretty. NOTICE: Moving shard 102022 from citus1:5432 to citus2:5432.

Database 107

Database Benchmarking Latency C++ 107

KeyCDN

NOVEMBER 4, 2021

The POP is strategially located within the country and lowers latency overall. KeyCDN is always on the lookout for ways to minimize latency and accelerate asset delivery worldwide. With this new POP, our performance in Latin America has significantly improved and provides a better web experience.

Latency 111

Latency Cache Tuning Traffic 111

Dynatrace

JANUARY 26, 2021

When an application is triggered, it can cause latency as the application starts. Performing updates, installing software, and resolving hardware issues requires up to 17 hours of developer time every week. Services tend to run on warehouse-scale computers meant more for edge applications than high-performance computing.

Serverless 245

Serverless Efficiency Lambda AWS 245

Percona

NOVEMBER 2, 2023

MongoDB is a dynamic database system continually evolving to deliver optimized performance, robust security, and limitless scalability. Our new eBook, “ From Planning to Performance: MongoDB Upgrade Best Practices ,” guides you through the entire process to ensure your database’s long-term success. In MongoDB 6.x:

Best Practices 90

Best Practices Hardware Tuning Scalability 90