Performance Optimization – ITFROMZERO

Fixing the “The table is full” Error in MySQL: When Hundreds of GBs are Still Free

By admin August 24, 2026

Don't panic when MySQL reports 'The table is full' despite having free disk space. This guide shows how to relax innodb_data_file_path limits and optimize tablespaces effectively.

Development

Signals in React: The ‘Weapon’ for Optimizing Re-renders in Large-Scale Apps

By admin August 20, 2026

Signals help React applications achieve peak performance by updating the DOM directly and eliminating redundant re-renders. A perfect solution for big data dashboards.

Network

Enabling HTTP/3 (QUIC) for Nginx: Speeding Up Websites in Poor Network Conditions

By admin August 17, 2026

Guide to upgrading Nginx to HTTP/3 (QUIC) to optimize website speed. This article shares how to fix HoL blocking, configure 0-RTT, and handle real-world firewall issues.

MySQL

Managing Hierarchical Data in MySQL: Don’t Let ‘Category Trees’ Crash Your Server

By admin August 16, 2026

An analysis of three hierarchical data management models in MySQL: Adjacency List, Nested Set, and Closure Table. Choose the right structure to avoid database overload during scaling.

Python

Pytest-xdist: Running Tests in Parallel in Python, Speed Up Your Test Suite by 4x

By admin July 21, 2026

A 300-test suite that takes 8 minutes on every push is something no developer wants to deal with. pytest-xdist targets the root cause: spawning multiple workers to run in parallel, putting all your CPU cores to work instead of waiting sequentially. This article covers installation, choosing the right --dist strategy, and practical tips to avoid common pitfalls when switching to parallel testing.

Centos

tuned-adm on CentOS Stream 9: Optimize Web Server, Database, and HPC Performance with the Right Profile

By admin July 19, 2026

tuned-adm lets you optimize CentOS Stream 9 performance with a single command — pick the right profile for Web Server, Database, or HPC instead of spending hours on manual tuning. This article compares the throughput-performance, network-throughput, latency-performance, and hpc-compute profiles, with a guide to creating custom profiles and benchmarking your results.

Linux

Speed Up Linux: Optimize I/O by Moving ‘Hot’ Data to RAM with tmpfs

By admin June 29, 2026

No matter how fast your disk is, RAM is hundreds of times faster. This guide walks you through using tmpfs to move temporary data into RAM, cut I/O Wait, and instantly speed up your Linux server.

Python

Polars vs Pandas: Speed Up DataFrame Processing 10x with the Power of Rust

By admin May 28, 2026

Accelerate DataFrame processing 10-100x with Polars. A detailed guide on migrating from Pandas to Polars, leveraging Lazy API and multi-core CPU power for Big Data.

Python

Python Performance: When to Use Multiprocessing vs. Threading?

By admin May 21, 2026

Struggling to choose between Multiprocessing and Threading? This article explains how to optimize Python performance for CPU-bound and I/O-bound tasks with real-world examples.

Ubuntu

Optimizing Ubuntu with XanMod Kernel: Reduce Latency and Boost System Speed

By admin May 17, 2026

A guide to installing and optimizing XanMod Kernel on Ubuntu based on real-world experience. Reduce system latency and boost processing speeds for both servers and personal computers effectively.