Percona

MAY 1, 2023

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. What is PostgreSQL performance tuning? Why is PostgreSQL performance tuning important?

Tuning 52

Tuning Efficiency Database Performance 52

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? A finely tuned database processes queries more efficiently, leading to swifter results.

Tuning 52

Tuning Database Performance Hardware 52

The Netflix TechBlog

MARCH 14, 2023

We must quickly surface the most stand-out highlights from the titles available on our service in the form of images and videos in the member experience. We implemented a batch processing system for users to submit their requests and wait for the system to generate the output. Processing took several hours to complete.

Media 291

Media Innovation Energy Architecture 291

Scalegrid

JANUARY 8, 2019

In Part I , we introduced a High Availability (HA) framework for MySQL hosting and discussed various components and their functionality. Semisynchronous replication, which is natively available in MySQL, helps the HA framework to ensure data consistency and redundancy for committed transactions. slave_preserve_commit_order = 1.

Availability 113

Availability Tuning Speed Network 113

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. Compare PostgreSQL vs. Oracle functionality across available tools, capabilities and services. Not available. Not available.

Open Source 244

Open Source Tuning C++ Database 244

The Netflix TechBlog

JUNE 13, 2023

This is where large-scale system migrations come into play. Replay traffic testing gives us the initial foundation of validation, but as our migration process unfolds, we are met with the need for a carefully controlled migration process.

Traffic 279

Traffic Metrics Systems Strategy 279

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. The ReportServer and ReportServerTempDB databases are SQL Server databases and should be part of a regular backup process, just like other user databases. Tuning Options.

Tuning 67

Tuning Servers Database Best Practices 67

The Netflix TechBlog

FEBRUARY 13, 2024

Safe software deployment, canary testing, and play-delay Software engineering readers of this blog are likely familiar with unit, integration and load testing, as well as other testing practices that aim to prevent bugs from reaching production systems. Rationale : This system is part of a semi-automated process for all client deployments.

Testing 239

Testing Software Software Metrics 239

Dynatrace

DECEMBER 18, 2023

For busy site reliability engineers, ensuring system reliability, scalability, and overall health is an imperative that’s getting harder to achieve in ever-expanding, cloud-native, container-based environments. This covers the infrastructure, processes, and the application stack, including tracing, profiling, and logs.

Metrics 186

Metrics Engineering Energy Tuning 186

Percona

AUGUST 31, 2018

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. It’s low because certain machines and operating systems do not support higher values.

Tuning 56

Tuning Database Performance Benchmarking 56

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? MySQL comes pre-configured to be conservative instead of making the most of the resources available in the server. Why is that?

Tuning 136

Tuning Cache Servers Benchmarking 136

Percona

AUGUST 29, 2018

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. In this post, we will discuss some important kernel parameters that can affect database server performance and how these should be tuned. PostgreSQL uses System V (SysV) that requires SHMMAX setting.

Tuning 56

Tuning Database Servers Processing 56

The Netflix TechBlog

JUNE 7, 2021

Network Availability: The expected continued growth of our ecosystem makes it difficult to understand our network bottlenecks and potential limits we may be reaching. After several iterations of the architecture and some tuning, the solution has proven to be able to scale. What is BPF?

Network 325

Network Transportation AWS Cloud 325

Dynatrace

MAY 17, 2023

For that, we focused on OpenTelemetry as the underlying technology and showed how you can use the available SDKs and libraries to instrument applications across different languages and platforms. We’d like to get deeper insight into the host, the underlying operating system, and any third-party services used by our application.

Metrics 179

Metrics Monitoring Database Network 179

Dynatrace

SEPTEMBER 28, 2021

As we look at today’s applications, microservices, and DevOps teams, we see leaders are tasked with supporting complex distributed applications using new technologies spread across systems in multiple locations. Your next challenge is ensuring your DevOps processes, pipelines, and tooling meet the intended goal.

DevOps 209

DevOps Metrics Traffic Efficiency 209

Dynatrace

JULY 6, 2022

Weaving DevOps and the related disciplines of DevSecOps and AIOps tightly into the development process can also accelerate the process. These reduce the need to hire specialists while providing a unified view of processes and infrastructure that make SRE more focused and effective. Design, implement, and tune effective SLOs.

Best Practices 196

Best Practices Open Source Tuning Infrastructure 196

The Netflix TechBlog

OCTOBER 15, 2019

Another thread or process is constantly polling events from the log table and writes them to one or multiple datastores, optionally removing events from the log table after acknowledged by all datastores. Another issue exists for the capture of schema changes, where some systems, like MySQL, don’t support transactional schema changes [1][2].

Transportation 192

Transportation Architecture Processing Storage 192

Brendan Gregg

DECEMBER 31, 2017

My last talk for 2017 was at AWS re:Invent, on "How Netflix Tunes EC2 Instances for Performance," an updated version of my [2014] talk. A video of the talk is on youtube : The slides are on slideshare : I love this talk as I get to share more about what the Performance and Operating Systems team at Netflix does, rather than just my work.

Tuning 61

Tuning AWS Best Practices Network 61

The Netflix TechBlog

AUGUST 13, 2020

You’re half awake and wondering, “Is there really a problem or is this just an alert that needs tuning? Our streaming teams need a monitoring system that enables them to quickly diagnose and remediate problems; seconds count! Our Node team needs a system that empowers a small group to operate a large fleet. By Andrei U.,

Monitoring 210

Monitoring Tuning Traffic Metrics 210

Percona

OCTOBER 12, 2023

An example of a flame graph can be found below: Each box is a function in the stack, and wider boxes mean more time the system was busy on CPU on these functions. Kubernetes limitations In Linux, by default, performance system events can’t be collected by unprivileged users. ✔ Launching profiler. ✔ Profiling.

Code 110

Code Tuning C++ Benchmarking 110

Scalegrid

JANUARY 11, 2024

Key Takeaways Cloud security monitoring is a comprehensive approach involving both manual and automated processes to oversee servers, applications, platforms, and websites, using tools that are customized to fit unique cloud architectures. Get ready for actionable insights that balance technical depth with practical advice.

Best Practices 130

Best Practices Cloud Monitoring Strategy 130

Brendan Gregg

DECEMBER 30, 2017

My last talk for 2017 was at AWS re:Invent, on "How Netflix Tunes EC2 Instances for Performance," an updated version of my [2014] talk. A video of the talk is on youtube : The slides are on slideshare : I love this talk as I get to share more about what the Performance and Operating Systems team at Netflix does, rather than just my work.

Tuning 52

Tuning AWS Best Practices Network 52

Scalegrid

JANUARY 25, 2024

Effective management of memory stores with policies like LRU/LFU proactive monitoring of the replication process and advanced metrics such as cache hit ratio and persistence indicators are crucial for ensuring data integrity and optimizing Redis’s performance. All these contribute significantly towards ensuring smooth functioning.

Metrics 130

Metrics Monitoring Latency Cache 130

Percona

MARCH 23, 2023

As datasets continue to grow in size, the amount of RAM required to store and process these datasets also increases. Operating system Linux is the most common operating system for high-performance MySQL servers. Typically a good value is 70%-80% of available memory. Static) – Requires MySQL restart for change.

Performance 125

Performance Hardware Tuning Storage 125

Percona

APRIL 13, 2023

PostgreSQL is a popular open source relational database management system that is widely used for storing and managing data. Replication lag can have serious consequences in high-availability systems where standby databases are used for failover. One of the common issues that can be encountered in PostgreSQL is replication lag.

Latency 81

Latency Tuning Open Source Network 81

Dynatrace

MARCH 11, 2021

I wanted to understand how I could tune Dynatrace’s problem detection, but to do that I needed to understand the situation first. If during the ticket handling another alert is raised this process repeats – but maybe with a different set of people who are working in parallel. As you know by now, I’m working with large-scale setups.

Tuning 264

Tuning Architecture Monitoring Big Data 264

Dynatrace

FEBRUARY 9, 2022

Modern infrastructure needs to be elastic and GitOps approaches are used to automate the provisioning of infrastructure and applications using Git, an open-source control system that provides the change processes including reviews and approvals. Observability is required for effective collaboration and automation. How to get started.

Code 225

Code Software Software DevOps 225

Dynatrace

JANUARY 26, 2021

Traditional computing models rely on virtual or physical machines, where each instance includes a complete operating system, CPU cycles, and memory. REST APIs, authentication, databases, email, and video processing all have a home on serverless platforms. The provider is essentially your system administrator.

Serverless 245

Serverless Efficiency Lambda Azure 245

Dynatrace

OCTOBER 7, 2020

Stay tuned for an upcoming blog series where we’ll give you a more hands-on walkthrough of how to ingest any kind of data from StatsD, Telegraf, Prometheus, scripting languages, or our integrated REST API. Once you send metrics via the OneAgent REST API, the relevant hosts are automatically enriched with all available monitoring dimensions.

Open Source 259

Open Source Metrics Analytics Tuning 259

Dynatrace

NOVEMBER 15, 2021

A log is a detailed, timestamped record of an event generated by an operating system, computing environment, application, server, or network device. Logs can include data about user inputs, system processes, and hardware states. However, the process of log analysis can become complicated without the proper tools.

Analytics 218

Analytics Monitoring Artificial Intelligence DevOps 218

The Netflix TechBlog

OCTOBER 18, 2022

Due to its popularity, the number of workflows managed by the system has grown exponentially. The scheduler on-call has to closely monitor the system during non-business hours. Meson was based on a single leader architecture with high availability. With the high growth of workflows in the past few years?—?increasing

Java 202

Java Scalability Traffic Architecture 202

Scalegrid

DECEMBER 14, 2023

Having too high of a value here could lead to your application not performing optimally because you are having the system wastefully wait for an unsuccessful attempt at establishing contact again and again which is why testing different values until arriving at one suitable for what your app requires is strongly suggested. x+ in Java).

Java 130

Java Network Servers Database 130

Dynatrace

JUNE 8, 2021

Observability is a topic at the top of mind for all architects, Site Reliability Engineers (SREs), and more – each wanting to use observability to proactively detect issues and guarantee the best experience and availability to users. Usual exceptions raised by our system that is now considered to be normal by Davis. Slow degradations.

Metrics 173

Metrics Tuning Programming Systems 173

Scalegrid

MARCH 22, 2024

Crafting Your Multi-Cloud Blueprint Formulating a comprehensive multi-cloud framework is an intricate process that requires a business’s specific requirements, choosing suitable cloud services, and optimizing for performance and affordability. Elevate your cloud strategy today with ScaleGrid!

Strategy 130

Strategy Cloud Government Innovation 130

Dynatrace

DECEMBER 2, 2021

And why have SLOs and SLIs become so important as teams automate processes to consistently meet SLAs and error budgets? As defined by Gartner , service-level objectives are an agreed-upon target within an SLA that must be achieved for each activity, function, and process to provide the best opportunity for customer success.

Metrics 200

Metrics Best Practices DevOps Infrastructure 200

Dynatrace

NOVEMBER 23, 2020

Today’s highly dynamic, heterogeneous, and complex software systems require organizations to establish observability for all provided cloud-native services. Gathering performance metrics like memory usage from systems where an agent can’t be installed. Dynatrace news. What’s next.

Metrics 151

Metrics Open Source Tuning Analytics 151

The Netflix TechBlog

AUGUST 29, 2023

Since there were no existing solutions available, we needed to build them ourselves. For Inter-Process Communication (IPC) between services, we needed the rich feature set that a mid-tier load balancer typically provides. Today we have a wealth of tools, both OSS and commercial, all designed for cloud-native environments.

Traffic 220

Traffic Latency Cloud C++ 220