SQL Performance

MARCH 26, 2020

A performance tuning engagement can end up taking many turns as you work through it – it all depends on what is showing up as the problem and what the data tells you. I think of index tuning as an art and a science. For this example, the indexes in red are those with no seeks, scans, or lookups… only updates.

Tuning 130

Tuning Cache Database Strategy 130

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 123

Performance Hardware Tuning Storage 123

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 210

Tuning Efficiency Big Data Engineering 210

Dynatrace

JULY 2, 2019

How to fine-tune failure detection. Here is an example where a service constantly reports many failures with the out of the box settings. In this example, there was a genuine issue at 4:00 AM but it is buried in the noise. The post How to fine tune failure detection appeared first on Dynatrace blog.

Tuning 115

Tuning Artificial Intelligence Code Java 115

Dynatrace

AUGUST 14, 2019

At Dynatrace, we’re constantly striving to come up with solutions that can help modernize your performance and user experience monitoring strategies. Fine-tune Session Replay for your business purposes—examples. In this example, your application makes the following Session Replay API call: .

Traffic 216

Traffic Tuning Strategy Website 216

Dynatrace

MAY 28, 2024

For example, OneAgent helps you monitor the logs from a Kubernetes environment with automatic enrichment that identifies the right cluster, namespace, container, and pod ID. Jump directly into log insights by selecting a recommended query, for example, to see the errors related to a problem detected by Davis® AI during the selected timeframe.

Analytics 176

Analytics Infrastructure Database Monitoring 176

Dynatrace

FEBRUARY 14, 2022

As a guest keynote speaker at Dynatrace Perform 2022 , Tegmark set the stage for AI as the ultimate technology for game-changers. For example, one way to look at the extinction of the West African black rhino is that humans’ goals weren’t aligned with the rhinos’ goals. Be proactive.

Artificial Intelligence 221

Artificial Intelligence Games Technology Technology 221

Dynatrace

SEPTEMBER 15, 2020

In my recent Performance Clinic with Stefano Doni , CTO & Co-Founder of Akamas , I made the statement, “Application development and release cycles today are measured in days, instead of months. Increase in environment complexity and increased frequency in delivery requires a novel approach to performance optimization.

Performance 189

Performance Java Metrics Cloud 189

DZone

MARCH 7, 2023

In addition, pySpark applications can be tuned to optimize performance and achieve better execution time, scalability, and resource utilization. In this article, we will discuss some tips and techniques for tuning PySpark applications. This can significantly reduce network overhead and improve performance.

Big Data 161

Big Data Code Tuning Open Source 161

Dynatrace

APRIL 5, 2024

For a more proactive approach and to gain further visibility, other SLOs focusing on performance can be implemented. For instance, consider how fine-tuned failure rate detection can provide insights for comprehensive understanding. Please refer to How to fine-tune failure detection (dynatrace.com) for further information.

Efficiency 230

Efficiency Traffic Tuning Metrics 230

Percona

FEBRUARY 24, 2023

For example, the QA team would only have access to data from the QA environment rather than having access to the production environment. This approach, known as least privilege access, ensures that each team only has access to the data they need to perform their duties, while limiting the risk of unauthorized access to sensitive information.

Metrics 104

Metrics Monitoring Database Engineering 104

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. For example, if some fields in the responses are timestamps, those will differ.

Traffic 339

Traffic Latency Tuning Systems 339

The Netflix TechBlog

MARCH 5, 2024

Operational simplicity Service owners often reach out to us with questions about excessive pause times and for help with tuning. No explicit tuning has been required to achieve these results. Reference processing is also only performed in major collections with ZGC.

Latency 228

Latency Java Tuning Efficiency 228

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. Dynatrace news. below 500ms) and error rates (e.g. lower than 2%.).

Latency 210

Latency Tuning Efficiency AWS 210

Dynatrace

AUGUST 5, 2020

Synthetic monitors are also the perfect tool to monitor performance baselines. This clean-room, lab-like environment allows you to react to slight changes in performance. It also gives you the first indication of whether a new deployment of your application or API leads to a performance improvement or, perhaps, a regression.

Metrics 220

Metrics Monitoring Performance Benchmarking 220

Dynatrace

APRIL 17, 2024

Mainframe is a strong choice for hybrid cloud, but it brings observability challenges IBM Z is a mainframe computing platform chosen by many organizations with a hybrid cloud strategy because of its security, resiliency, performance, scalability, and sustainability. Next you can start using logs in your troubleshooting and analysis tasks.

Operating System 211

Operating System Energy Infrastructure Architecture 211

Dynatrace

DECEMBER 5, 2023

This growth was spurred by mobile ecosystems with Android and iOS operating systems, where ARM has a unique advantage in energy efficiency while offering high performance. Huge performance leaps in recent years The top priority is often performance, where ARM resources have improved significantly.

Efficiency 271

Efficiency Architecture Energy Monitoring 271

Dynatrace

MARCH 15, 2024

Syslog is the go-to protocol that delivers infrastructure administrators, network engineers, and security team logs that tell them all they need to know about their systems’ delivery, performance, availability, and security. Take a look at this example for configuration. Point your syslog sources to the collector and you’re done!

Open Source 206

Open Source Infrastructure Network Government 206

Brendan Gregg

JULY 15, 2020

Eight years ago I wrote _Systems Performance: Enterprise and the Cloud_ (aka the "sysperf" book) on the performance of computing systems, and this year I'm excited to be releasing the second edition. A year ago I announced [BPF Performance Tools: Linux System and Application Observability]. Thanks to everyone for their support.

Systems 145

Systems Cloud Performance Tuning 145

Dynatrace

DECEMBER 18, 2023

This challenge has given rise to the discipline of observability engineering, which concentrates on the details of telemetry data to fine-tune observability use cases. The Collector’s principal developer is the OpenTelemetry team, but it also sees contributions of custom components by third parties (for example, Dynatrace).

Metrics 183

Metrics Engineering Energy Tuning 183

HammerDB

APRIL 19, 2023

Predicting application performance is a difficult art, but an important one when choosing the target deployment environment. In this blog, we aim to call out some key considerations when trying to assess MySQL performance for your application. We will not concern ourselves with the raw throughput of workload.

Performance 54

Performance Benchmarking Cache Storage 54

Dynatrace

JANUARY 18, 2024

Automation and analysis features, in particular, have boosted operational efficiency and performance by tracking and responding to complex or information-dense situations. In a perfect world, a robust AI model can perform complex tasks while users observe the decision process and audit any errors or concerns.

Artificial Intelligence 217

Artificial Intelligence Healthcare Government Technology 217

Percona

AUGUST 29, 2018

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. This results in improved performance. You may get good performance by setting lower values. SHMMAX / SHMALL.

Tuning 54

Tuning Database Servers Processing 54

The Netflix TechBlog

FEBRUARY 13, 2024

An example data stream for an A/B test where each observation represents play-delay for the control (left) and treatment (right). Netflix also performs canary tests — software A/B tests between current and newer software versions. The key idea is to switch from a “fixed time horizon” to an “any-time valid” framing of the problem.

Testing 239

Testing Software Software Metrics 239

HammerDB

JULY 14, 2021

adds full support for MariaDB in both the GUI as shown: And in the CLI as a separate database from MySQL, this post describes a setup and test for MariaDB using the CLI on Linux as an example running the TPROC-C workload. A future blog post on performance profiles will explain why this is a good first test on which to baseline other changes).

Testing 57

Testing C++ Virtualization Tuning 57

Percona

APRIL 24, 2023

Indexes are generally considered to be the panacea when it comes to SQL performance tuning, and PostgreSQL supports different types of indexes catering to different use cases. I keep seeing many articles and talks on “tuning” discussing how creating new indexes speeds up SQL but rarely ones discussing removing them.

Tuning 124

Tuning Cache Storage Database 124

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 134

Tuning Cache Servers Benchmarking 134

MachMetrics

NOVEMBER 21, 2019

The documentation for WPT’s scripting functionality is far from user friendly, and only gives a couple of examples. For this example, we’re going to run a script that loads machmetrics.com, and logs into the user dashboard. Now for the bad news. To start, here is where the scripting option is located on WebPageTest.

Speed 57

Speed Testing Google Tuning 57

The Morning Paper

NOVEMBER 3, 2019

An analysis of performance evolution of Linux’s core operations Ren et al., Perhaps the most interesting lesson/reminder is this: it takes a lot of effort to tune a Linux kernel. Google’s data center kernel is carefully performance tuned for their workloads. 14, and after that performance starts to degrade noticeably.

Performance 108

Performance Benchmarking Tuning Hardware 108

Percona

FEBRUARY 15, 2023

This post will illustrate through a simple example how bloom filters work in MyRocks. Tuning In terms of tuning, two parameters can be tuned, the size of the bitmap and the number of bits set by every value. Bloom filter is an important feature improving performance of LSM storage engines.

Storage 125

Storage Tuning Cache Engineering 125

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 44

Tuning Cache Database Storage 44

Dynatrace

JUNE 16, 2022

Microsoft, for example, reported that only a few days after the Log4Shell vulnerability had been discovered, exploiters launched more than 1.8 An ideal RASP technology does not need training or fine-tuning to learn what bad application behavior looks like. These limitations include the following: High tuning and monitoring overhead.

Tuning 228

Tuning Cloud Open Source Network 228

Dynatrace

JANUARY 4, 2024

The endpoints] might have different SLAs (service level agreements) or completely different performance characteristics.” For example, one endpoint might be more heavily used than others, and therefore more likely to experience failure. To learn more about unified services, see Unified services in the Dynatrace documentation.

Metrics 171

Metrics Open Source Tuning Infrastructure 171

Scalegrid

DECEMBER 14, 2023

How the MongoDB timeout is set up can significantly affect your application’s performance, no matter if you are an experienced MongoDB user or just starting with NoSQL databases. For example, your payment history might be on one database cluster and your analytics records on another cluster.

Java 130

Java Network Servers Database 130

The Netflix TechBlog

NOVEMBER 6, 2023

We have built an internal system that allows someone to perform in-video search across the entire Netflix video catalog, and we’d like to share our experience in building this system. During GPU computation, we stream mp4 video shots from S3 directly to the GPUs using a data loader that performs prefetching and preprocessing.

Media 225

Media Social Media Tuning Efficiency 225

The Netflix TechBlog

MARCH 14, 2023

An example of using Machine Learning to find shots of Eleven in Stranger Things and surfacing the results in studio application for the consumption of Netflix video editors. Here is an example of the desired output when the user searches for “red race car” across the entire content library. a close-up shot).

Media 291

Media Innovation Energy Architecture 291

The Netflix TechBlog

NOVEMBER 14, 2023

Several audits, such as verifying source and target counts, are performed on this batch of data. The Setup: Automated end-to-end catchup Let’s go back to our customer lifecycle example. The Data Engineer does not need to perform any manual intervention in this case and can thus focus on more important things!

Tuning 244

Tuning Processing C++ Efficiency 244