article thumbnail

Poor Disk Performance

Brendan Gregg

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

article thumbnail

Poor Disk Performance

Brendan Gregg

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.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Poor Disk Performance

Brendan Gregg

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

article thumbnail

Tune Linux Kernel Parameters For PostgreSQL Optimization

Percona

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 54
article thumbnail

Transparent Data Encryption (TDE)

Percona

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.

article thumbnail

Percona Toolkit – A Quick Introduction to Summary

Percona

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 97
article thumbnail

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

SQL Server According to Bob

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 40