Cache, Hardware, Performance 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? Experiencing database performance issues?

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 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

Tuning Efficiency Database Performance

InnoDB Performance Optimization Basics

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

Performance Hardware Tuning Storage

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

Metrics

Metrics Monitoring Latency Cache

How to Assess MySQL Performance

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

Performance Benchmarking Cache Storage

Impact of Querying Table Information From information_schema

Percona

MARCH 27, 2023

A lot of useful information can be retrieved from this schema, for example, table metadata and foreign key relations, but trying to query I_S can induce performance degradation if your server is under heavy load, as shown in the following example test. ” under heavy load + I_S queries” to check for performance degradation.

Cache

Cache Hardware Servers Benchmarking

The evolution of single-core bandwidth in multicore processors

John McCalpin

APRIL 25, 2023

The primary metric for memory bandwidth in multicore processors is that maximum sustained performance when using many cores. This post is about a secondary performance characteristic — sustained memory bandwidth for a single thread running on a single core. Stay tuned! At a single-core frequency of 3.0

Benchmarking

Benchmarking Cache Latency Tuning

HTTP/3: Performance Improvements (Part 2)

Smashing Magazine

AUGUST 22, 2021

HTTP/3: Performance Improvements (Part 2). HTTP/3: Performance Improvements (Part 2). In this second part, we will zoom in on the performance improvements that QUIC and HTTP/3 bring to the table for web-page loading. HTTP/3 performance features ( current article ). Robin Marx. 2021-08-23T06:20:00+00:00.

Performance

Performance Network Latency Servers

Updated Azure SQL Database Tier Options

SQL Performance

APRIL 27, 2020

Gen 5 is the primary hardware option now for most regions since Gen 4 is aging out. The business-critical tier has local SSD which provide much better IO performance with max data IOPS ranging from 8000 for a 2 vCore database up to 204,800 for an 80 vCore database. New Hardware Configuration for Provisioned Compute 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. For bare metals, any algorithm among deadline or noop (the performance difference between them is imperceptible) will be better than CFQ.

Best Practices

Best Practices Design Tuning Database

An empirical guide to the behavior and use of scalable persistent memory

The Morning Paper

MARCH 17, 2020

Based on these findings, the authors present four guidelines to get the best performance out of this memory today. The data we have collected demonstrate that many of the assumptions that researchers have made about how NVDIMMs would behave and perform are incorrect. Understanding Optane DIMM performance. Optane DIMMs are here!

Scalability

Scalability Latency Cache Media

Application Scalability — How To Do Efficient Scaling

DZone

AUGUST 16, 2019

If we are not prepared for this, the application performance will start degrading, and you will lose your audience and business. It’s not just a simple tweak you can turn on/off; it’s a long-time process that touches almost every single item in your stack, including both hardware and software sides of the system.

Scalability

Scalability Efficiency Hardware Software

SQL Server I/O Basics Chapter #1

SQL Server According to Bob

JANUARY 11, 2020

This will help you increase system performance and avoid I/O environment errors. Atomicity A transaction must be an atomic unit of work; either all of its data modifications are performed or none of them are performed. This cache is often supported by a battery-powered backup facility.

Servers

Servers Cache Media Hardware

Common SQL Server Mishaps

SQL Performance

JUNE 21, 2019

What I find is very similar to backups: No DBCC CHECKDBs performed at all DBCC CHECKDBs being performed only on select databases DBCC CHECKDBs last performed months or years ago. Performing index maintenance by removing fragmentation from your indexes is still important. Index Maintenance. SQL Server Agent Alerts.

Servers

Servers Azure Hardware Database

Understanding Execution Plan Operator Timings

SQL Performance

MARCH 8, 2021

This can make it difficult to draw sound performance-tuning conclusions. This uses hardware, typically a crystal oscillator, that produces ticks at a very high constant rate regardless of processor speed, power settings, or anything of that nature. Total elapsed time is 933ms with 6,673ms of CPU time with a warm cache.

Servers

Servers Tuning Architecture Processing

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. Nginx for disk based caching. We use different types of caching techniques depending on the problem statements. Disk based caching. Hybrid Sync. On prem data processing. Offline access.

Architecture

Architecture Cache Azure Storage

Using Parallel Query with Amazon Aurora for MySQL

Percona

JANUARY 17, 2019

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. In this article, we will look at how this can improve the reporting/analytical query performance in MySQL. The second and third run used the cached data. With faster disks (i.e. MySQL on ec2.

Cache

Cache C++ AWS Airlines