performance tuning – ITFROMZERO

Expert Tricks for Using sysstat to Diagnose a Slow Linux Server

By admin July 7, 2026

Don't let your Linux server run slow without knowing why. Learn how to use iostat, vmstat, sar, and mpstat to track down performance bottlenecks and troubleshoot incidents like a pro.

Virtualization

KVM/Proxmox Benchmarking: Measure CPU, Disk, and Network Performance Like a Pro

By admin July 5, 2026

In-depth guide to KVM/Proxmox benchmarking. Use fio, sysbench, and iperf3 to measure IOPS, CPU, and Network performance to optimize VMs before going live.

Centos

Installing MySQL 8 on CentOS Stream 9: Official Repository, SELinux, and Performance Tuning

By admin July 3, 2026

Guide to installing MySQL 8 on CentOS Stream 9 from the official repository — avoiding the common pitfall of getting MariaDB instead. Covers SELinux configuration, firewalld access control, and InnoDB buffer pool tuning for production servers.

MySQL

Optimizing my.cnf for MySQL 8: Don’t Let Your Server ‘Choke’ on Default Settings

By admin June 28, 2026

MySQL 8's default configuration is often underpowered. This guide shows you how to optimize my.cnf to maximize RAM and CPU usage for better database load handling.

VMware

Speed Up VMware VMs: Switching to Virtual NVMe to Unleash SSD Performance

By admin June 21, 2026

Don't let legacy controllers slow down your SSD. A detailed guide on switching to Virtual NVMe on VMware to reduce latency and boost IOPS for Windows/Linux VMs.

MySQL

MySQL Thread Pool: The ‘Lifesaver’ for Handling Thousands of Database Connections

By admin June 10, 2026

Don't let MySQL collapse under connection overload. A detailed guide on configuring Thread Pool to optimize CPU, reduce context switching, and keep your database stable under heavy pressure.

MySQL

Add Columns to a 200 Million Record Table in 0.1 Seconds: The Power of ALGORITHM=INSTANT in MySQL 8.0

By admin June 8, 2026

Discover how to use ALGORITHM=INSTANT in MySQL 8.0 to add or drop columns on tables with hundreds of millions of records in milliseconds, completely eliminating downtime.

Database

KeyDB: The Multi-Threaded Fork That Supercharges Redis on Multi-Core Servers

By admin June 1, 2026

Is your Redis CPU-bound? Discover KeyDB—a multi-threaded fork that boosts performance 5x and offers powerful Active Replication for large-scale systems.

Linux

stress-ng: The “Heavyweight” Test for Linux Server Stability

By admin May 30, 2026

A comprehensive guide to using stress-ng for CPU, RAM, and Disk stress testing on Linux. Discover tips for verifying server stability and detecting hidden bugs before deployment.

Linux

Pinning Processes to CPU Cores: How to Use taskset and numactl to Maximize Linux Performance

By admin May 28, 2026

A guide on using taskset and numactl to pin processes to CPU cores on Linux. Reduce latency, optimize cache locality, and boost performance for heavy applications.