performance tuning – Page 2 – ITFROMZERO

Deploying Redis ‘The Right Way’ on CentOS Stream 9: SELinux Security and Real-World Performance Optimization

By admin May 27, 2026

Avoid 'quick-and-dirty' Redis setups. This guide helps you deploy Redis on CentOS Stream 9 for production, optimizing SELinux and eliminating THP-related latency.

MySQL

MySQL 8 Resource Groups: Don’t Let a “Heavy” Query Crash Your Entire Production System

By admin May 27, 2026

Learn how to use Resource Groups in MySQL 8 to isolate CPU for heavy queries, protecting your production system from server hangs and optimizing user latency.

Virtualization

CPU Pinning and NUMA Topology on Proxmox VE: Optimizing Virtual Machine Performance for Low Latency

By admin May 22, 2026

CPU pinning and NUMA topology are two VM performance optimization techniques that are often overlooked on Proxmox VE. This guide walks through the configuration step by step — from inspecting the host topology to pinning vCPUs and isolating cores — to reduce latency for workloads that demand low-latency performance, such as databases and real-time processing.

MySQL

MySQL Query Rewrite Plugin: Optimize and Fix SQL Queries Without Touching Your Application Code

By admin May 21, 2026

MySQL Query Rewrite Plugin lets you intercept and modify SQL statements at the database layer without changing any application source code. This guide covers installation, configuration, and practical use cases for production environments.

Centos

Optimizing PHP 8.x on CentOS Stream 9: Real-World PHP-FPM and OPcache Tuning Tips

By admin May 9, 2026

A guide to optimizing PHP 8.x on CentOS Stream 9 based on real-world experience. Learn how to fine-tune PHP-FPM and OPcache for peak performance, lower CPU load, and reduced RAM usage.

Linux

Debug Linux like a “Wizard” with eBPF and BCC Tools: Peer into the Kernel Without Code Changes

By admin May 9, 2026

Learn how to use eBPF and BCC Tools on Linux to debug complex performance issues at the kernel level without modifying or restarting your applications.

Monitoring

Elastic APM: Deep-Diving into Code and Diagnosing Systems Without the Guesswork

By admin April 29, 2026

Stop running your systems in the dark. A detailed guide on using Elastic APM to deep-dive into code, detect slow queries, and optimize real-world application performance.

Linux

Controlling Process Resources with cgroups v2 on Linux: Limiting CPU, RAM, and I/O Without Docker

By admin April 27, 2026

Learn how to master Linux system resources with cgroups v2. Detailed instructions on limiting CPU, RAM, and I/O for applications running directly on the OS without Docker.

Database

Is Your PostgreSQL Disk Bloating? Pro Tips to Fix Bloat and Optimize Autovacuum

By admin April 21, 2026

PostgreSQL disk full due to Database Bloat? Learn how to optimize Autovacuum, use pg_repack, and REINDEX CONCURRENTLY to free up space without downtime.

MySQL

MySQL Performance Tuning: Boosting Speed with Buffer Pool and Thread Pool in Practice

By admin April 15, 2026

Expert secrets for practical MySQL optimization: Configuring Buffer Pool, Thread Pool, and Redo Log to speed up queries, reduce Disk I/O, and stabilize systems during high traffic.