Disk I/O | BestHub

Cognitive Technology Team

Mar 29, 2025 · Databases

MySQL Multi-Range Read (MRR) Optimization: Advantages, Limitations, Use Cases, and Configuration

MySQL's Multi-Range Read (MRR) optimization reduces random disk I/O by scanning indexes, sorting keys, and retrieving rows sequentially, offering advantages like sequential data access and batch key processing, while outlining its limitations, applicable scenarios, usage conditions, and configuration via optimizer_switch variables and buffer settings.

Disk I/OIndex OptimizationMRR

0 likes · 5 min read

MySQL Multi-Range Read (MRR) Optimization: Advantages, Limitations, Use Cases, and Configuration

Tencent Cloud Developer

Aug 1, 2024 · Backend Development

Linux Performance Analysis Tools and Troubleshooting Methods for Backend Development

The article presents a concise mind‑map of essential Linux performance tools and a flexible troubleshooting workflow, guiding backend developers through CPU, memory, disk, and network issues by using utilities such as top, oprofile, slabtop, iotop, netstat, and strace to quickly pinpoint and resolve bottlenecks.

Backend DevelopmentDisk I/OTroubleshooting

0 likes · 11 min read

Linux Performance Analysis Tools and Troubleshooting Methods for Backend Development

Ops Development Stories

Aug 24, 2023 · Operations

Master Linux Disk I/O: Key Metrics, Tools, and Real-World Troubleshooting

This article explains Linux disk I/O performance metrics, benchmark methods, observation tools like iostat, pidstat, and iotop, and walks through a practical case of diagnosing and resolving an I/O spike caused by the jbd2 journaling process.

Disk I/Ofioiostat

0 likes · 14 min read

Master Linux Disk I/O: Key Metrics, Tools, and Real-World Troubleshooting

Aikesheng Open Source Community

Aug 8, 2023 · Databases

Root Cause Analysis of MySQL Insert Latency Using blktrace and Disk I/O Monitoring

This article details a systematic investigation of MySQL insert slowdown caused by disk I/O anomalies, describing log analysis, blktrace data collection, RAID controller firmware bugs, and the final resolution through firmware upgrade, providing practical guidance for database performance troubleshooting.

Database TroubleshootingDisk I/OMySQL

0 likes · 11 min read

Root Cause Analysis of MySQL Insert Latency Using blktrace and Disk I/O Monitoring

Aikesheng Open Source Community

Sep 20, 2022 · Databases

Analyzing MySQL Slow Log: Identifying Disk I/O and Semi‑Sync Replication Bottlenecks

This article walks through a systematic analysis of MySQL slow‑log entries, correlating them with error‑log flush events, disk‑I/O monitoring, and semi‑synchronous replication traces to pinpoint performance bottlenecks and provide practical troubleshooting steps.

Database MonitoringDisk I/OMySQL

0 likes · 20 min read

Analyzing MySQL Slow Log: Identifying Disk I/O and Semi‑Sync Replication Bottlenecks

Aikesheng Open Source Community

Apr 27, 2022 · Databases

Diagnosing MySQL Disk I/O Pressure with Linux System Tools

This article walks through generating a heavy‑load MySQL workload, using top, iostat, and iotop to pinpoint high disk I/O, mapping OS thread IDs back to MySQL sessions, and safely killing the offending query to relieve pressure.

Disk I/OMySQLPerformance Tuning

0 likes · 20 min read

Diagnosing MySQL Disk I/O Pressure with Linux System Tools

政采云技术

Feb 15, 2022 · Big Data

Performance Investigation and Optimization of an Elasticsearch Search Service

This article describes a performance bottleneck in a high‑traffic search service, details the investigation of hardware limits, long‑tail query impact, load‑testing methodology, and the subsequent optimizations—including SSD upgrade, data‑structure reduction, and Elasticsearch segment tuning—that reduced disk I/O and improved throughput.

Big DataDisk I/OElasticsearch

0 likes · 11 min read

Performance Investigation and Optimization of an Elasticsearch Search Service

360 Tech Engineering

Jan 21, 2022 · Fundamentals

Understanding Disk I/O: Read, Write, DMA, Page Cache, mmap and Performance Optimizations

This article explains the principles of disk I/O, covering read/write workflows, DMA acceleration, page cache, memory‑mapped files, buffering techniques, Linux kernel parameters and practical Java code examples to illustrate how to reduce CPU involvement and improve overall system performance.

BufferingDMADisk I/O

0 likes · 12 min read

Understanding Disk I/O: Read, Write, DMA, Page Cache, mmap and Performance Optimizations

360 Quality & Efficiency

Jan 21, 2022 · Fundamentals

Understanding Disk I/O: Read, Write, DMA, Page Cache, mmap and Performance Optimizations

The article explains the fundamentals of disk I/O, covering read/write processes, IO interrupts, DMA, page cache, mmap, buffered versus unbuffered file operations, ByteBuffer usage, Linux dirty‑page parameters, and how these mechanisms affect application performance and reliability.

DMADisk I/OMMAP

0 likes · 12 min read

Qunhe Technology Quality Tech

Sep 22, 2021 · Operations

Uncover Hidden Performance Bottlenecks with Deep CPU, Memory, Disk & Network Analysis

This article outlines systematic methods for diagnosing subtle performance issues by leveraging detailed data analysis of CPU, memory, disk I/O, and network metrics, and presents real-world case studies that demonstrate how targeted profiling and optimization can reveal and resolve hidden bottlenecks in complex systems.

CPU analysisDisk I/OPerformance Testing

0 likes · 11 min read

Uncover Hidden Performance Bottlenecks with Deep CPU, Memory, Disk & Network Analysis

360 Tech Engineering

Mar 22, 2021 · Databases

Analyzing and Optimizing High Memory and Disk I/O Consumption of InfluxDB 1.8 on a Production Server

This article investigates why an InfluxDB 1.8 instance on a 32‑core, 64 GB server consumes over 58 GB of resident memory and generates heavy disk I/O, examines Go runtime memory accounting, uses system tools such as top, pmap, pprof and iostat for diagnosis, and presents configuration and runtime tweaks that reduce memory pressure and I/O load.

Disk I/OGo RuntimeInfluxDB

0 likes · 13 min read

Analyzing and Optimizing High Memory and Disk I/O Consumption of InfluxDB 1.8 on a Production Server

Full-Stack Internet Architecture

Mar 22, 2021 · Big Data

Kafka Performance Optimization: Sequential Writes, Zero‑Copy, PageCache, and Network Model

This article provides a comprehensive overview of Kafka performance optimization, covering network, disk, and complexity challenges, sequential write techniques, zero‑copy data transfer, page‑cache usage, reactor‑based networking, batch processing, compression, partition concurrency, and file‑structure design to help developers build high‑throughput, low‑latency streaming systems.

Disk I/OJava NIOKafka

0 likes · 17 min read

Kafka Performance Optimization: Sequential Writes, Zero‑Copy, PageCache, and Network Model

360 Smart Cloud

Mar 19, 2021 · Databases

Root Cause Analysis and Performance Optimization of InfluxDB 1.8 Memory and Disk I/O on a Production Server

The article investigates why an InfluxDB 1.8 instance on a 32‑core, 64 GB production server consumes over 95% memory and generates heavy disk I/O, analyzes runtime statistics, pprof data, and Go memory‑release behavior, and presents configuration and runtime tweaks that reduce memory usage to ~55% and I/O load to acceptable levels.

Database OptimizationDisk I/OGo Runtime

0 likes · 12 min read

Root Cause Analysis and Performance Optimization of InfluxDB 1.8 Memory and Disk I/O on a Production Server

Aikesheng Open Source Community

Dec 17, 2020 · Operations

Root Cause Analysis of MySQL "Opening tables" Stalls Caused by Poor Disk Write Performance and InnoDB Redo Log Flush

The article investigates why a MySQL instance experiences frequent "Opening tables" states, analyzing stack traces, identifying a data dictionary lock held by the dict_stats_thread, and concluding that slow disk writes trigger InnoDB's synchronous dirty‑page flush, blocking many operations.

Disk I/OInnoDBMySQL

0 likes · 14 min read

Root Cause Analysis of MySQL "Opening tables" Stalls Caused by Poor Disk Write Performance and InnoDB Redo Log Flush

Full-Stack Internet Architecture

Nov 21, 2020 · Databases

Understanding B+ Tree Indexes: Disk vs Memory, Structure, and Operations

The article explains how B+ trees serve as efficient disk-based indexes, contrasting disk and memory I/O, describing node and leaf structures, retrieval methods, and dynamic insertion and deletion operations, highlighting their advantages for large-scale data storage and query performance.

B-TreeData StructuresDisk I/O

0 likes · 11 min read

Understanding B+ Tree Indexes: Disk vs Memory, Structure, and Operations

Refining Core Development Skills

Jun 13, 2020 · Fundamentals

Sequential vs Random I/O Performance on a 7‑Disk RAID5 Array: Benchmarks and Insights

This article presents a detailed fio benchmark comparing sequential and random I/O on a 7‑disk RAID5 array, revealing how I/O size, RAID strip size, and caching affect bandwidth, latency, and IOPS, and explains the implications for database transactions, file copying, and B+‑tree indexing.

B-TreeDatabaseDisk I/O

0 likes · 10 min read

Sequential vs Random I/O Performance on a 7‑Disk RAID5 Array: Benchmarks and Insights

Architects' Tech Alliance

Apr 9, 2020 · Fundamentals

Understanding Linux Disk I/O, Page Cache, and File Operation Mechanisms

This article explains the hierarchical storage pyramid, Linux kernel I/O stack, page‑cache synchronization policies, the atomicity of write operations, the role of mmap and Direct I/O, and how disk characteristics influence multithreaded read/write performance and design decisions.

Direct I/ODisk I/OFile System

0 likes · 15 min read

Understanding Linux Disk I/O, Page Cache, and File Operation Mechanisms

Aikesheng Open Source Community

Mar 13, 2020 · Databases

Identifying Slow Disk I/O in MySQL Using performance_schema and sys.x$latest_file_io

This article demonstrates how to reproduce disk‑IO saturation in MySQL, enable performance_schema instruments and consumers, apply load, and use sys.x$latest_file_io together with events_waits_history_long to pinpoint whether binlog, redo log, or specific tables are causing the slowdown.

Disk I/OMySQLPerformance Schema

0 likes · 3 min read

Identifying Slow Disk I/O in MySQL Using performance_schema and sys.x$latest_file_io

Aikesheng Open Source Community

Mar 6, 2020 · Databases

How to Simulate Slow Disk I/O for MySQL Experiments

This guide explains how to create a delayed‑disk device on Linux, place MySQL binlog files on it, and use tools like mysqlslap and pt‑ioprofile to observe the impact of artificially slow I/O on MySQL performance.

Database BenchmarkDisk I/OMySQL

0 likes · 3 min read

How to Simulate Slow Disk I/O for MySQL Experiments

Architects' Tech Alliance

Aug 23, 2019 · Operations

IO Performance Evaluation, Monitoring, and Optimization Guide

This article explains how to assess, monitor, and tune system I/O performance by defining I/O models, selecting appropriate evaluation tools, tracking key metrics for disk and network I/O, and applying practical optimization strategies for both storage and network bottlenecks.

Capacity PlanningDisk I/OIO performance

0 likes · 15 min read

IO Performance Evaluation, Monitoring, and Optimization Guide