0 views collected around this technical thread.
This article explains the core principles of I/O read/write operations, detailing the data preparation and copying stages, the roles of kernel and user buffers, synchronization models, and performance optimizations such as double buffering, circular buffers, zero‑copy, read‑ahead, and delayed write.
This article explains MySQL InnoDB's various buffers—including the buffer pool, change buffer, log buffer, and doublewrite buffer—detailing their purposes, internal mechanisms such as LRU variants, configuration options, and how they improve performance and ensure data integrity.
This article explains the purpose, recommended settings, and tuning tips for MyISAM‑related MySQL variables such as key_buffer_size, read_buffer_size, read_rnd_buffer_size, bulk_insert_buffer_size, myisam_sort_buffer_size, myisam_max_sort_file_size, myisam_repair_threads, and myisam_recover, helping DBAs optimize indexing and query performance.
This article walks through common interview questions on Linux memory inspection and cache clearing, explains the fields shown by the free command, and then delves into SQL join types, performance bottlenecks, buffer settings, and practical optimization techniques for MySQL databases.
This article explains the core differences between Java NIO and traditional IO, introduces the concepts of channels and buffers, describes buffer state management, provides a complete NIO selector code example, and compares the NIO workflow with Netty's model.
The article compares Java native arrays and Buffer types such as IntBuffer, showing through benchmarks that native arrays are typically over four times faster than Buffers, and discusses the memory management, performance trade‑offs, and practical implications of using each abstraction.
This article provides a comprehensive guide to Java I/O, covering traditional BIO streams, the differences between BIO, NIO and AIO, detailed explanations of byte and character streams, buffers, channels, selectors, and practical examples such as file copying and a simple client‑server chat implementation.
This article provides a comprehensive overview of Java IO, explaining the traditional blocking BIO model, the modern non‑blocking NIO architecture, the role of streams, buffers, channels, zero‑copy techniques, and selectors, and includes practical code examples for file copying and simple client‑server communication.
This article explains the core differences between Java NIO and traditional IO, introduces the concepts of channels and buffers, details buffer state management, and provides sample NIO code along with a comparison to Netty's processing model.
This guide outlines comprehensive MySQL performance tuning techniques, covering architectural replication, system‑level hardware adjustments, MySQL configuration parameters, and application‑level query optimizations with specific recommended values for buffers, caches, and connection limits.