Brendan Gregg

MAY 8, 2021

It seemed to have several set speeds, and when pushing hard it would try a faster speed for a couple of seconds, then a faster one, until it found the fastest it could operate (presumably it tries faster speeds until it begins to get sector-ECC errors). avg-cpu: %user %nice %system %iowait %steal %idle 7.90 Linux 4.15.0-66-generic

Performance 133

Performance Latency Speed Systems 133

Percona

AUGUST 29, 2018

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. PostgreSQL uses System V (SysV) that requires SHMMAX setting. So now it requires fewer bytes of System V shared memory. DETAIL: Failed system call was shmget(key=1, size=2072576, 03600). Until version 9.2,

Tuning 79

Tuning Database Servers Processing 79

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# virtual = 2.2G

Cache 114

Cache Database Virtualization Servers 114

Percona

AUGUST 29, 2023

Columnar storage of tables can compress data, speeding up scans and supporting fast projections, both on regular and distributed tables. Can you think of a better system that can stay up without losing time initiating failovers when a node fails? citus_columnar | 11.1-1 1 citus | 11.1-1 citus_columnar | 11.1-1 1 citus | 11.1-1

C++ 98

C++ Database Storage Testing 98

Brendan Gregg

MAY 8, 2021

It seemed to have several set speeds, and when pushing hard it would try a faster speed for a couple of seconds, then a faster one, until it found the fastest it could operate (presumably it tries faster speeds until it begins to get sector-ECC errors). avg-cpu: %user %nice %system %iowait %steal %idle 7.90

Performance 40

Performance Latency Speed Systems 40

Brendan Gregg

MAY 8, 2021

It seemed to have several set speeds, and when pushing hard it would try a faster speed for a couple of seconds, then a faster one, until it found the fastest it could operate (presumably it tries faster speeds until it begins to get sector-ECC errors). avg-cpu: %user %nice %system %iowait %steal %idle 7.90 Linux 4.15.0-66-generic

Performance 40

Performance Latency Speed Systems 40

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 40

Servers Cache Database Media 40