performance tuning – ITFROMZERO

Handling MySQL Hangs Due to Metadata Locking: Don’t Let an ALTER Command Crash Your System

By admin August 16, 2026

Is ALTER TABLE hanging your MySQL? Explore the Metadata Locking (MDL) mechanism, how to use Performance Schema to find blocking threads, and tips for safe migrations on large databases.

MySQL

High-Speed MySQL Backup & Restore: Reducing Time from 15 Hours to 2 Hours with Mydumper

By admin August 1, 2026

Large MySQL database running slow with mysqldump? Discover how to use mydumper and myloader for multi-threaded backups, cutting recovery time by up to 80%.

Development

NATS: A Lifesaver for Microservices When Kafka and RabbitMQ Are Too Heavy

By admin August 1, 2026

Forget the high RAM usage of Kafka or the complexity of RabbitMQ. This article guides you through deploying NATS—a lightweight, high-speed message broker for modern Microservices.

Database

Redis Insight: The Visual Lifesaver for Debugging and Optimizing Redis from A-Z

By admin July 30, 2026

Discover how to use Redis Insight to monitor performance, analyze RAM, and visually debug data. The ultimate CLI alternative for developers.

Git

Supercharge Git Performance with Scalar: A Solution for Multi-Gigabyte Repositories

By admin July 29, 2026

Is your multi-gigabyte repository making Git crawl like a snail? Discover how to use Scalar—a tool from Microsoft—to optimize clone, status, and fetch speeds for massive projects.

VMware

Eliminate ‘Noisy Neighbor’ Issues with VMware SIOC: Protecting Bandwidth for Critical VMs

By admin July 25, 2026

No more Noisy Neighbor headaches! A detailed guide on configuring VMware vSphere SIOC to protect IOPS for critical VMs like SQL and ERP, based on real-world experience.

Network

ethtool Linux: Check NIC Status, Configure Speed, and Optimize Network Interface Performance from the Command Line

By admin July 20, 2026

ethtool is the Linux command that shows you everything about your NIC that ip link can't — from actual speed/duplex and error counters to ring buffer and offloading. Includes a full-server NIC health check script and how to persist settings across reboots.

Linux

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.