This guide walks through identifying MySQL CPU overload caused by excessive temporary tables and thread creation, then details configuration tweaks and SQL optimizations—including adjusting tmp_table_size, thread_cache_size, and join/sort buffers—to restore normal performance.
This article details a real‑world Nginx performance tuning case where long‑running client requests caused timeouts, describing how adjusting keepalive settings, TCP reuse parameters, and upstream proxy timeouts eliminated the delays and stabilized the service for millions of calls.
This article walks through the background of I/O issues in a MySQL project, explains SSD characteristics, and details step‑by‑step InnoDB parameter adjustments—including I/O scheduler changes, innodb_io_capacity, and adaptive flushing—both before and after a master‑slave switch, supported by performance data and diagrams.
This article explains how to optimize PHP by installing only needed modules, using an opcode cache like eAccelerator, configuring php.ini resource limits, and tuning Apache, providing practical steps and recommended settings for faster, more efficient web applications.
The article explains how kernel‑level load balancing works, why naïve thread‑pool wake‑up can cause CPU imbalance, and proposes using thread affinity, priority layers and a custom layered condition variable to achieve better performance in multithreaded server applications on Linux.
This guide explains how to enable MySQL’s Query Profiler, retrieve summary and detailed profiling data, and analyze CPU and I/O usage to pinpoint performance bottlenecks in your queries, including commands to list profiles, view specific query details, and interpret the results for optimization.
This article provides a conceptual summary of SQL Server performance tuning, explaining the goals of optimizing response time and throughput, the importance of baselines and costs, factors influencing performance, and a step‑by‑step DETECT methodology for systematic optimization.
This guide walks you through essential MySQL and MariaDB performance‑tuning techniques—including storage engine settings, disk placement, buffer pool sizing, swappiness, connection limits, thread cache, DNS lookup, query cache, temporary tables, slow‑query logging, idle connections, file‑system choices, packet size, and testing tools—to help you optimize and maintain a high‑speed, reliable database server.
This article analyzes common push‑service questions, presents a memory‑leak case from an IoT MQTT middleware, and provides detailed Netty design guidelines—including file‑handle limits, CLOSE_WAIT handling, thread and task management, heartbeat tuning, buffer allocation, memory‑pool usage, logging pitfalls, TCP and JVM optimizations—to help engineers build stable, high‑performance million‑connection push servers.
This guide provides detailed steps and registry tweaks to optimize Windows 7 performance on SSDs, covering BIOS settings, SSD usage principles, disabling unnecessary services, disk space management, and system configuration commands to improve speed and reduce resource consumption.
Learn how to fine‑tune Nginx by adjusting key global, events, and HTTP settings—such as worker processes, connection limits, gzip compression, and file caching—to maximize throughput and reduce latency under heavy client loads, with a complete example configuration and restart instructions.
In this technical interview, Yiche Group’s senior DBA Gao Jiwei shares how the company designs its database platform, leverages SQL Server’s in‑memory OLTP, implements high‑availability solutions, builds a private cloud with open‑source tools, and optimizes performance during massive traffic events.
This guide shows how to use vmstat to pinpoint whether high load averages on a Linux system are caused by CPU saturation, insufficient memory, or slow I/O, by interpreting each column of the vmstat output.
Drawing from a year and a half of Linux operations experience, this guide outlines practical standards for online actions, data handling, security, monitoring, performance tuning, and the right mindset to prevent costly incidents and maintain stable, secure systems.
This guide details essential Tomcat startup parameters for both Linux and Windows environments, explains the purpose of each JVM option, and provides practical steps to test and adjust memory settings, helping you optimize server performance and avoid common pitfalls.
The article outlines 27 C++ performance optimization techniques for ray tracing, emphasizing profiling hot paths, minimizing branches and memory accesses, using inline and reference passing, aligning data, loop unrolling, avoiding unnecessary temporaries, and simplifying math to exploit cache locality and modern CPU parallelism.
