performance tuning – Page 3 – ITFROMZERO

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.

VMware

The Ultimate Fix for I/O Lag: Converting VMware Thin to Thick Provisioning

By admin April 15, 2026

Is your VMware system lagging due to I/O latency? Learn how to convert from Thin to Thick Provisioning using vSphere Client and vmkfstools to optimize performance for SQL Server and Databases.

Linux

Linux SWAP Configuration Guide: A “Spare Tire” for Low-RAM Servers

By admin April 1, 2026

Don't let your server crash due to RAM exhaustion. A detailed guide on creating a Linux Swap File, optimizing swappiness, and practical tips for maintaining system stability under heavy load.

Linux

Optimize Linux server performance for production: A detailed guide for beginners

By admin March 17, 2026

This article provides a detailed guide on how to optimize Linux server performance for a production environment. From resource monitoring to fine-tuning CPU, RAM, Disk I/O, and Network, it's aimed at beginners.