performance tuning Archives - ITFROMZERO

A Guide to Using Multi-Valued Indexes in MySQL 8: Optimizing JSON Array Queries

By IT From Zero October 17, 2026

Real-world experience optimizing JSON array queries in MySQL 8 using Multi-Valued Indexes, slashing query times from 1.8s down to 2ms across tables with over 10 million rows.

Linux

Linux ZRAM Guide: Optimize Memory and Speed Up Your System with Compressed Swap

By IT From Zero October 13, 2026

ZRAM sets up a compressed swap partition directly in physical memory, helping Linux servers relieve memory exhaustion and fend off the OOM Killer without disk I/O bottlenecks.

Network

Configuring SR-IOV on Linux: Achieving Near Bare-Metal Network Performance for KVM Virtual Machines

By IT From Zero October 9, 2026

SR-IOV enables KVM virtual machines to communicate directly with physical network adapters, bypassing the hypervisor to achieve maximum throughput and microsecond latency. Here is a complete guide to setup and troubleshooting peak-hour packet drops in production.

MySQL

MySQL on Windows Server 2022: Don’t Let ‘Next -> Next’ Compromise Your System

By IT From Zero September 17, 2026

Don't just click 'Next' when installing MySQL. Learn how to configure Windows Authentication, optimize RAM for 15M+ records, and secure your firewall for production.

VMware

vNUMA Configuration: The Secret to Fixing Slow ‘Beast’ VMs on VMware vSphere

By IT From Zero September 16, 2026

Large VMs running slow are often due to vNUMA misalignment. Learn how to align Virtual NUMA with physical CPUs on vSphere to reduce RAM latency and boost app performance by 20-30%.

Python

Python 3.13: Unshackling the GIL with JIT and Free-threading

By IT From Zero August 28, 2026

Python 3.13 marks a major turning point with the JIT Compiler and the option to completely remove the GIL. Let's analyze real-world performance and thread-safety considerations when upgrading.

MySQL

Is MySQL Sluggish After a Restart? How to Keep Your Buffer Pool “Hot”

By IT From Zero August 26, 2026

Don't let MySQL fall into a 'Cold Cache' state after every restart. Detailed guide on how to configure InnoDB Buffer Pool Dump/Load to keep database performance at its peak.

MySQL

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

By IT From Zero 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 IT From Zero 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 IT From Zero 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.