performance tuning Archives - ITFROMZERO

Guide to Views and Updatable Views in MySQL: Data Abstraction and Performance Optimization

By IT From Zero October 29, 2026

Master creating Views and Updatable Views in MySQL: mask sensitive columns, optimize the MERGE algorithm, and avoid production performance pitfalls.

Database

Diagnosing and Resolving Deadlocks in PostgreSQL: Inspecting Lock Trees and Configuring Proper Timeouts

By IT From Zero October 26, 2026

An in-depth look at the root causes of PostgreSQL deadlocks, step-by-step reproduction, Lock Tree query techniques to locate root blockers, and timeout tuning to safeguard your system.

Virtualization

Optimizing KVM Networking with virtio-net Multiqueue and vhost-net: Hitting Full 10GbE Without CPU Bottlenecks

By IT From Zero October 23, 2026

KVM virtual machine stuck at 2 Gbps on a 10GbE network? A single-queue virtio setup is usually to blame. Learn how to configure virtio Multiqueue and vhost-net to unlock full 9.4 Gbps throughput without overloading your vCPUs.

MySQL

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.