Cache, Database, Servers and Tuning - Technology Performance Pulse

MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance

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

Tuning Database Performance Hardware

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

Percona

MAY 1, 2023

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. 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.

Tuning

Tuning Efficiency Database Performance

Crucial Redis Monitoring Metrics You Must Watch

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 will need to know which monitoring metrics for Redis to watch and a tool to monitor these critical server metrics to ensure its health.

Metrics

Metrics Monitoring Latency Cache

Tuning SQL Server Reporting Services

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. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server.

Tuning

Tuning Servers Database Best Practices

An approach to index tuning – Part 2

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. His version can be used for the plan cache – the only challenge there is the information is transient, so you may not capture every query that uses a particular index.

Tuning

Tuning Cache Metrics Testing

Tuning PostgreSQL Database Parameters to Optimize Performance

Percona

AUGUST 31, 2018

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. 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. This is called double buffering.

Tuning

Tuning Database Performance Benchmarking

PostgreSQL Connection Pooling: Part 3 – Pgpool-II

Scalegrid

MARCH 23, 2020

While its use and importance has decreased as the inbuilt replication options improved on PostgreSQL server side, this still remains a valuable option for older versions of PostgreSQL. Follow these steps to set up Pgpool-II, enable the connection pool services you need, and connect to your PostgreSQL server. At a glance. How it works.

Cache

Cache Servers Architecture Processing

Impact of Querying Table Information From information_schema

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. The same tests have been executed in Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7 Results for Percona Server for MySQL 5.7

Cache

Cache Hardware Servers Benchmarking

PostgreSQL Checkpoints, Buffers, and WAL Usage with Percona Monitoring and Management

Percona

NOVEMBER 9, 2023

With this data, we’ll be able to better understand and tune our Postgres servers. The main idea is to be able to easily detect what the server is doing at any point in time so we can better understand how it reacts to the workload and tune accordingly. You can search the blog for more information on this if needed.

Monitoring

Monitoring Tuning Metrics Servers

How to Assess MySQL Performance

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. There are many times we get asked why some cloud instance performed poorly for their database application and almost always turned out to be some configuration error. TB)) for storage of database tablespaces and logging.

Performance

Performance Benchmarking Cache Storage

A Quick Peek at MySQL 8.0.34 and MySQL 8.1.0

Percona

JULY 27, 2023

is an evolution of the MySQL server and related software. While this is a great idea for security reasons, there will be many more posts on websites like Stackoverflow bemoaning that their old code and connector can not connect to the new version of the database. This could be handy for tracking query tuning and performance auditing.

Servers

Servers Open Source Tuning Cache

A use case for sp_prepare / sp_prepexec

SQL Performance

JANUARY 11, 2021

So when their compiled application sends ad hoc queries to SQL Server, particularly as a prepared statement, and when we don't have the freedom to add or change indexes, several tuning opportunities are immediately off the table. You won't be able to check the plan cache for these results, because of the recompile.

Cache

Cache Tuning Database Performance

Characterizing, modeling, and benchmarking RocksDB key-value workloads at Facebook

The Morning Paper

MARCH 10, 2020

The paper examines three different uses of RocksDB at Facebook: UDB , the underlying storage engine for the MySQL databases storing the social graph data. All cache read misses and all writes go through UDB servers, with SQL queries being converted into RocksDB queries. For one representative UDB server, about 10.2

Benchmarking

Benchmarking Storage Cache Open Source

PostgreSQL Connection Pooling: Part 2 – PgBouncer

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

Cache Architecture Database Servers

The Most Important MySQL Setting

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

Tuning Cache Servers Benchmarking

InnoDB Performance Optimization Basics

Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Some servers may need a few GBs of RAM, while others may need hundreds of GBs or even terabytes of RAM. Benchmark before you decide.

Performance

Performance Hardware Tuning Storage

Updated Azure SQL Database Tier Options

SQL Performance

APRIL 27, 2020

Azure SQL Database is Microsoft's database-as-a-service offering that provides a tremendous amount of flexibility. Microsoft is continually working on improving their products and Azure SQL Database is no different. HyperScale Database. Hyperscale databases are provisioned using vCores. DTU Pricing Tier.

Azure

Azure Database Serverless Hardware

MongoDB Best Practices: Security, Data Modeling, & Schema Design

Percona

APRIL 17, 2023

The main objective of this post is to share my experience over the past years tuning MongoDB and centralize the diverse sources that I crossed in this journey in a unique place. The Linux default is usually 60 , which is not ideal for database usage. Spoiler alert: This post focuses on MongoDB 3.6.X

Best Practices

Best Practices Design Tuning Database

Common SQL Server Mishaps

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS.

Servers

Servers Azure Hardware Database

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

JANUARY 11, 2020

Microsoft SQL Server I/O Basics Author: Bob Dorr, Microsoft SQL Server Escalation Published: December, 2004 SUMMARY: Learn the I/O requirements for Microsoft SQL Server database file operations. Then follow the instructions to either download the BOL or browse online.

Servers

Servers Cache Media Hardware

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

JANUARY 11, 2020

Microsoft, Windows, Windows NT, and Windows Server are registered trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Servers

Servers Cache Database Media

DBLog: A Generic Change-Data-Capture Framework

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Designed with High Availability in mind.

Database

Database Traffic Transportation Open Source

DBLog: A Generic Change-Data-Capture Framework

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Designed with High Availability in mind.

Database

Database Traffic Transportation Open Source

KPTI/KAISER Meltdown Initial Performance Regressions

Brendan Gregg

FEBRUARY 9, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. Many thanks to the engineers working hard to develop workarounds to these processor bugs. Much of my testing was on Linux 4.14.11 and 4.14.12 a month ago, before we deployed in production.

Performance

Performance Benchmarking Cache Tuning

A Decade of Dynamo: Powering the next wave of high-performance, internet-scale applications

All Things Distributed

OCTOBER 2, 2017

Today marks the 10 year anniversary of Amazon's Dynamo whitepaper , a milestone that made me reflect on how much innovation has occurred in the area of databases over the last decade and a good reminder on why taking a customer obsessed approach to solving hard problems can have lasting impact beyond your original expectations.

Internet

Internet Internet AWS Performance

How to improve Redo, Transaction Log and WAL throughput for HammerDB benchmarks

HammerDB

NOVEMBER 5, 2018

If you are new to running Oracle, SQL Server, MySQL and PostgreSQL TPC-C workloads with HammerDB and have needed to investigate I/O performance the chances are that you have experienced waits on writing to the Redo, Transaction Log or WAL depending on the database you are testing. Logging Waits.

Benchmarking

Benchmarking Database C++ Virtualization

KPTI/KAISER Meltdown Initial Performance Regressions

Brendan Gregg

FEBRUARY 8, 2018

In this post I'll look at the Linux kernel page table isolation (KPTI) patches that workaround Meltdown: what overheads to expect, and ways to tune them. Many thanks to the engineers working hard to develop workarounds to these processor bugs. Much of my testing was on Linux 4.14.11 and 4.14.12 a month ago, before we deployed in production.

Performance

Performance Benchmarking Cache Tuning

Scale Your Liferay Application by Clustering

Enprowess

MARCH 4, 2018

And whenever one server isn’t sufficient to serve the high traffic needs of your portal, you can scale your Liferay portal by adding additional servers. Basically when group of servers and other resources act like a single system and enable high availability is termed as “Clustering”. Enable cluster link for cache replication.

Cache

Cache Transportation Media Traffic

Understanding Execution Plan Operator Timings

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). SQL Server makes some timing adjustments in parallel plans to promote consistency, but they are not perfectly implemented. TheYear , CA.

Servers

Servers Tuning Architecture Processing

Using Parallel Query with Amazon Aurora for MySQL

Percona

JANUARY 17, 2019

I will compare AWS Aurora with MySQL (Percona Server) 5.6 Aurora Parallel Query response time (for queries which can not use indexes) can be 5x-10x better compared to the non-parallel fully cached operations. 84.1 | | version_comment | Percona Server (GPL), Release 84.1, MySQL on ec2.

Cache

Cache C++ AWS Airlines

Egnyte Architecture: Lessons learned in building and scaling a multi petabyte content platform

High Scalability

NOVEMBER 25, 2019

Edge caching. In general, Egnyte connect architecture shards and caches data at different levels based on: Amount of data. Application Servers. Nginx for disk based caching. Apache FTP server. Native desktop and server hosted clients that allow both interactive as well as hybrid sync access to the entire namespace.

Architecture

Architecture Cache Azure Storage

Technology Performance Pulse

MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance

PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency

Trending Sources

Crucial Redis Monitoring Metrics You Must Watch

Tuning SQL Server Reporting Services

An approach to index tuning – Part 2

Tuning PostgreSQL Database Parameters to Optimize Performance

PostgreSQL Connection Pooling: Part 3 – Pgpool-II

Impact of Querying Table Information From information_schema

PostgreSQL Checkpoints, Buffers, and WAL Usage with Percona Monitoring and Management

How to Assess MySQL Performance

A Quick Peek at MySQL 8.0.34 and MySQL 8.1.0

A use case for sp_prepare / sp_prepexec

Characterizing, modeling, and benchmarking RocksDB key-value workloads at Facebook

PostgreSQL Connection Pooling: Part 2 – PgBouncer

The Most Important MySQL Setting

InnoDB Performance Optimization Basics

Updated Azure SQL Database Tier Options

MongoDB Best Practices: Security, Data Modeling, & Schema Design

Common SQL Server Mishaps

SQL Server I/O Basics Chapter #1

SQL Server I/O Basics Chapter #2

DBLog: A Generic Change-Data-Capture Framework

DBLog: A Generic Change-Data-Capture Framework

KPTI/KAISER Meltdown Initial Performance Regressions

A Decade of Dynamo: Powering the next wave of high-performance, internet-scale applications

How to improve Redo, Transaction Log and WAL throughput for HammerDB benchmarks

KPTI/KAISER Meltdown Initial Performance Regressions

Scale Your Liferay Application by Clustering

Understanding Execution Plan Operator Timings

Using Parallel Query with Amazon Aurora for MySQL

Egnyte Architecture: Lessons learned in building and scaling a multi petabyte content platform

Stay Connected