2048, Performance and Systems - Technology Performance Pulse

Poor Disk Performance

Brendan Gregg

MAY 8, 2021

People often tell me they don't understand performance tool output because they can't tell what's "good" or "bad." It can be hard as performance is subjective. I recently encountered terrible disk performance and thought it'd be useful to collect Linux tool screenshots and share them for reference. Linux 4.15.0-66-generic

Performance

Performance Latency Speed Systems

Tune Linux Kernel Parameters For PostgreSQL Optimization

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. PostgreSQL uses System V (SysV) that requires SHMMAX setting. SHMMAX / SHMALL. Until version 9.2,

Tuning

Tuning Database Servers Processing

How to analyze PostgreSQL benchmark performance with HammerDB

HammerDB

SEPTEMBER 24, 2024

We will provide a brief summary of the article and its conclusions, and demonstrate a better way to analyze PostgreSQL performance with HammerDB itself. During a copy operation, the data is transferred from the client’s file system to the Aurora PostgreSQL DB cluster. and start the build running.

Benchmarking

Benchmarking Performance Metrics Database

Percona Toolkit – A Quick Introduction to Summary

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. pt-summary --user=root [?2004l#

Cache

Cache Database Virtualization Servers

Transparent Data Encryption (TDE)

Percona

DECEMBER 27, 2022

Encrypting data at rest in a database management system (DBMS) refers to securing data by encrypting it when it is not being used or accessed. Several database management systems support cluster-level encryption, including Oracle, MySQL, Microsoft SQL Server, MongoDB, and Cassandra. Database-level encryption. Table-level encryption.

Database

Database Storage Servers Strategy

Poor Disk Performance

Brendan Gregg

MAY 8, 2021

People often tell me they don't understand performance tool output because they can't tell what's "good" or "bad." It can be hard as performance is subjective. I recently encountered terrible disk performance and thought it'd be useful to collect Linux tool screenshots and share them for reference.

Performance

Performance Latency Speed Systems

Poor Disk Performance

Brendan Gregg

MAY 8, 2021

People often tell me they don't understand performance tool output because they can't tell what's "good" or "bad." It can be hard as performance is subjective. I recently encountered terrible disk performance and thought it'd be useful to collect Linux tool screenshots and share them for reference. Linux 4.15.0-66-generic

Performance

Performance Latency Speed Systems

SQL Server on Linux: Scatter/Gather == Vectored I/O

SQL Server According to Bob

JANUARY 31, 2017

Scatter/gather capabilities allow more efficient memory to disk transfers reducing redundant memory copies, sorting and other activities applications may require to gain improved I/O performance. On Linux the total number of buffers that can be read or written, in a single ABI request, is capped at 2048.

Servers

Servers Software Engineering Operating System Database

Configuring PostgreSQL and LDAP Using StartTLS

Percona

AUGUST 21, 2023

Even though there is an encrypted session between psql and the Postgres server, there is no encrypted session between Postgres and LDAP as authentication is performed: SSL connection (protocol: TLSv1.3,

C++

C++ Servers Open Source Testing

What are the best multi-browser testing tools?

Testsigma

MAY 5, 2021

To ensure the features run uniformly across various browsers and OS versions that our users have, we should perform multi-browser testing. Plus, there are multiple versions of operating systems and screen resolutions that our users browse content on. . Let us understand the importance of multi-browser testing before we proceed.

Testing Tools

Testing Tools Testing Internet Internet

Data Redundancy With the PostgreSQL Citus Extension

Percona

AUGUST 29, 2023

Reference tables can be replicated to all nodes for joins and foreign keys from distributed tables and for maximum read performance. Depending on the configuration, one can tune a hardware RAID for either performance or redundancy. The same can be said for Citus data sharding. The colors indicate duplicated shards of the table.

C++

C++ Database Storage Testing

A thorough introduction to bpftrace

Brendan Gregg

AUGUST 18, 2019

bpftrace is a new open source tracer for Linux for analyzing production performance problems and troubleshooting software. Linux already has many performance tools, but these are often counter-based and have limited visibility. system(".") Originally posted at https:/opensource.com/article/19/8/introduction-bpftrace.

Latency

Latency C++ Cache Programming

Chrome's NOSCRIPT Intervention

Tim Kadlec

SEPTEMBER 6, 2018

Web fonts fallback very easily to system fonts so disabling web fonts is not a huge deal to most. The two results that jump out right away as oddities are The Atlantic and The Verge which managed to get a whopping 293% and 2048% heavier without JavaScript. But disabling JavaScript is a much more controversial move, it appears.

Network

Network Testing Cache Google

SQL Server I/O Basics Chapter #2

SQL Server According to Bob

JANUARY 11, 2020

Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written permission of Microsoft Corporation.

Servers

Servers Cache Database Media

Technology Performance Pulse

Poor Disk Performance

Tune Linux Kernel Parameters For PostgreSQL Optimization

Trending Sources

How to analyze PostgreSQL benchmark performance with HammerDB

Percona Toolkit – A Quick Introduction to Summary

Transparent Data Encryption (TDE)

Poor Disk Performance

Poor Disk Performance

SQL Server on Linux: Scatter/Gather == Vectored I/O

Configuring PostgreSQL and LDAP Using StartTLS

What are the best multi-browser testing tools?

Data Redundancy With the PostgreSQL Citus Extension

A thorough introduction to bpftrace

Chrome's NOSCRIPT Intervention

SQL Server I/O Basics Chapter #2

Stay Connected