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

SQL Shack

NOVEMBER 23, 2020

In this article, we will talk about the query tuning features that were announced with SQL Server 2019. Introduction Sometimes, tuning the queries can be a tough task for database developers or administrators.

Tuning 76

Tuning Servers Database Development 76

SQL Shack

APRIL 21, 2020

This article will cover some essential techniques for SQL query tuning. Query tuning is a very wide topic to talk about, but some essential techniques never change in order to tune queries in SQL Server. Particularly, it is a difficult issue for those who are a newbie to SQL query tuning or who are thinking […].

Tuning 92

Tuning Servers Performance 92

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?

Tuning 52

Tuning Database Efficiency Performance 52

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. 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 67

Tuning Servers Database Best Practices 67

InfoQ

JANUARY 26, 2024

Discord optimized its platform to serve over one million online users in a single server while maintaining a responsive user experience. By Rafal Gancarz

Servers 106

Servers Tuning Scalability Performance 106

SQL Performance

APRIL 13, 2020

In my last post , I started to outline the process I go through when tuning queries – specifically when I discover that I need to add a new index, or modify an existing one. This is where index tuning becomes an art. If performance improves, you're good to go! Step 6: Testing. It's rarely that simple.

Tuning 137

Tuning Cache Metrics Testing 137

SQL Shack

JUNE 25, 2021

In this article, we will focus on one major SQL Server performance issue that we may experience during heavy data insertion in a table. Introduction SQL Server allocates some memory from the operating system, and this is because it is designed to do all read and modification operations in memory instead of on disk.

Servers 64

Servers Tuning Performance Operating System 64

SQL Shack

DECEMBER 8, 2020

Gaining experience in SQL query tuning can be very difficult and complicated for database developers or administrators. For this reason, in this article, we will work on a case study and we are going to learn how we can tune its performance step by step. In this fashion, we will understand well how to approach […].

Tuning 91

Tuning Servers Database Performance 91

SQL Shack

MAY 8, 2020

In this article, we will continue to learn essential techniques of the SQL Server query tuning with practical examples. Query tuning is a bit complicated issue and if any database programmer wants to be successful on this topic, they can start with learning these basic methods to improve their skill.

Tuning 86

Tuning Servers Database Performance 86

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

DZone

AUGUST 4, 2022

For the longest time, hosting static files on CDNs was the de facto standard for performance tuning website pages. The host offered browser caching advantages, better stability, and storage on fast edge servers across strategic geolocations. Not only did it have performance benefits, but it was also convenient for developers.

Cache 305

Cache Tuning Storage Website 305

The Netflix TechBlog

SEPTEMBER 18, 2024

Firstly, developers struggled to reason about consistency, durability and performance in this complex global deployment across multiple stores. This flexibility allows our Data Platform to route different use cases to the most suitable storage system based on performance, durability, and consistency needs.

Latency 248

Latency Storage Cache Efficiency 248

Percona

OCTOBER 10, 2023

Why choose Percona Server for MongoDB? The difference between Percona Server for MongoDB and MongoDB CE is that we strive to provide a gap-closing set of features for users who want to use MongoDB in production. Why release Percona Server for MongoDB 7 now? which was released as Percona Server for MongoDB RC 7.0.2-1.

Availability 103

Availability Servers Database Open Source 103

Percona

MARCH 1, 2023

EXPLAIN ANALYSE is a big boon to query tuning. EXPLAIN without the ANALYSE gives you the server’s estimated analysis of the performance of your query. Adding ANALYSE causes the query to execute, and the numbers returned to report the real numbers of the query’s performance. Why Percona Server for MySQL?

Servers 121

Servers Open Source Tuning C++ 121

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

Dynatrace

JULY 2, 2019

For instance, alert me when an error 999 is detected in application server logs or any HTTP 500 error from the web server access log. If the code triggers an unexpected “connectionTimeOutException”, there is no “catch” so the application server will catch it and return an HTTP error. How to fine-tune failure detection.

Tuning 116

Tuning Artificial Intelligence Code Java 116

SQL Server Performance

JANUARY 27, 2019

In this installament of the TSQL Performance Tuning series we turn our attention to Views Views Used Within Joins or Where Conditions As a generic concept, an inner join with an object which has insufficient indexing will result in index scanning or perhaps a table scan which also applies for Views Impacts: • Much CPU […].

Tuning 40

Tuning Performance Servers Development 40

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 is important to pay attention to performance when writing database queries. shared_buffer.

Tuning 57

Tuning Database Performance Benchmarking 57

SQL Shack

MARCH 4, 2021

Introduction Sometimes, query tuning operations can get very challenging and complicated in SQL Server. With the SQL Server 2016, a new feature Query Store has been introduced and this feature […].

Tuning 71

Tuning Servers Performance 71

DZone

SEPTEMBER 25, 2019

The application was running on a GNU/Linux OS, Java 8, Tomcat 8 application server. Proxy Error The proxy server received an invalid response from an upstream server. Proxy Error The proxy server received an invalid response from an upstream server. The proxy server could not handle the request GET /.

Tuning 159

Tuning Java Traffic AWS 159

The Netflix TechBlog

OCTOBER 8, 2024

DistinctAggregation) , this endpoint performs the given aggregation within a given time interval. It also allows Netflix to archive, compress, or delete older data efficiently, optimizing both storage and query performance. This approach enables efficient querying of specific time ranges without the need to scan the entire dataset.

Latency 236

Latency Storage Traffic Tuning 236

Dynatrace

FEBRUARY 11, 2020

OneAgent knows where to connect for further runtime configuration and where to send data because the installer itself is pre-configured to connect to the exact tenant and server that it’s downloaded from. But what if your environment grows and you decide to distribute data between two Dynatrace servers?

Servers 157

Servers Tuning Systems Availability 157

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? Sysbench ran on a third server, which I’ll refer to as the application server (APP).

Tuning 137

Tuning Cache Servers Benchmarking 137

Dynatrace

AUGUST 29, 2023

Dynatrace has announced that it has successfully achieved the Google Cloud Ready – Cloud SQL designation for Cloud SQL, Google Cloud’s fully-managed, relational database service for MySQL, PostgreSQL, and SQL Server.

Google 214

Google Cloud Design Programming 214

The Netflix TechBlog

NOVEMBER 12, 2024

This counting service, built on top of the TimeSeries Abstraction, enables distributed counting at scale while maintaining similar low latency performance. Implementing idempotency would likely require using an external system for such keys, which can further degrade performance or cause race conditions.

Latency 224

Latency Cache Infrastructure Strategy 224

The Netflix TechBlog

JUNE 14, 2023

This blog post will share broadly-applicable techniques (beyond GraphQL) we used to perform this migration. Before GraphQL: Monolithic Falcor API implemented and maintained by the API Team Before moving to GraphQL, our API layer consisted of a monolithic server built with Falcor. To launch Phase 1 safely, we used AB Testing.

Traffic 356

Traffic Latency Cache Metrics 356

The Netflix TechBlog

MARCH 5, 2024

That’s particularly true of our GRPC clients and servers, where request cancellations due to timeouts interact with reliability features such as retries, hedging and fallbacks. Operational simplicity Service owners often reach out to us with questions about excessive pause times and for help with tuning.

Latency 234

Latency Java Tuning Efficiency 234

DZone

JANUARY 14, 2020

Find out more about client-side performance! Client-Side Performance Testing Importance and Introduction. If you're worried about the performance of your web application, you need to test and analyze not only with what happens on the server but also with what happens in the browser.

Performance Testing 130

Performance Testing Performance Testing Open Source 130

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. Therefore, it is imperative that these parameters are configured according to the database server and its workload.

Tuning 57

Tuning Database Servers Processing 57

SQL Server Performance

JANUARY 3, 2019

In this article series we will focus on the primary points of T-SQL performance tuning. In this first installment I will lopok at tuning temp tables, table variables and the Union command.

Tuning 40

Tuning Servers Database Code 40

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

Dynatrace

JUNE 16, 2022

A centralized approach to WAF uses a single firewall to protect many application servers against large-scale distributed attacks. Conversely, a decentralized approach protects application servers using multiple firewalls to protect against attacks that may have penetrated the network. More time for vulnerability management.

Tuning 232

Tuning Cloud Open Source Network 232

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. Are you running containerized applications on IBM Z?

Operating System 216

Operating System Energy Architecture Infrastructure 216

The Netflix TechBlog

SEPTEMBER 10, 2024

By Karthik Yagna , Baskar Odayarkoil , and Alex Ellis Pushy is Netflix’s WebSocket server that maintains persistent WebSocket connections with devices running the Netflix application. Finally, the device receives the message, and the action, such as “Show me Stranger Things on Netflix”, is performed.

Latency 228

Latency Cache Tuning Efficiency 228

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. Syslog is a protocol with clear specifications that require a dedicated syslog server.

Open Source 211

Open Source Infrastructure Network Government 211

Dynatrace

APRIL 25, 2023

It helps developers and operators identify and troubleshoot issues, optimize performance and improve user experience. However, serverless applications have unique characteristics that make observability more difficult than in traditional server-based applications. Scale automatically based on the demand and traffic patterns.

Serverless 218

Serverless Lambda Azure AWS 218