performance – ITFROMZERO – Share tobe shared!

Optimizing MySQL Storage: Choosing the Right Data Types to Speed Up I/O and Save RAM

By admin June 26, 2026

Choosing the wrong MySQL data types causes unnecessarily bloated databases, high I/O, and wasted RAM. This article shares real-world experience from a 50GB production database: how to choose correctly between INT/BIGINT, VARCHAR/TEXT, ENUM, and TIMESTAMP to optimize performance right from schema design.

Python

Accelerating Microservices: Why I Switched from REST to gRPC with Python

By admin June 21, 2026

gRPC helps reduce payload by 60% and optimizes Microservices latency compared to REST API. This article shares a practical guide with Python and hard-earned lessons from 6 months of production deployment.

Development

Virtual Threads in Java 21: Handling Millions of Concurrent Requests with Low Resource Usage

By admin June 15, 2026

Compare Platform Threads, Reactive Programming, and Virtual Threads (Project Loom) in Java 21. A hands-on implementation guide with Spring Boot 3.2 covering pinning pitfalls and I/O-bound optimization to handle millions of concurrent requests with minimal resources.

Development

Web Workers: The Secret to Handling Heavy Tasks Without Freezing the UI

By admin June 7, 2026

Is your website lagging when processing large datasets? Discover how to use Web Workers to move heavy tasks to the background, keeping the Main Thread smooth and optimizing the user experience.

MySQL

Optimizing Temporary Tables in MySQL: Preventing I/O Bottlenecks When Processing Complex Queries

By admin June 5, 2026

Temporary tables in MySQL spilling to disk are a silent culprit behind slow queries and disk I/O spikes. This article breaks down the root cause, how to diagnose it using SHOW STATUS and EXPLAIN, and practical solutions ranging from increasing tmp_table_size to rewriting queries and adding the right indexes.

Monitoring

Grafana Pyroscope: Hunting Down CPU and RAM “Hogs” Directly on Production

By admin June 3, 2026

A detailed guide on using Grafana Pyroscope for Continuous Profiling. Find the exact lines of code causing high CPU usage and memory leaks on production with minimal overhead.

Ubuntu

Varnish + Nginx: The Ultimate Lifesaver for High-Traffic Websites on Ubuntu

By admin June 3, 2026

Varnish Cache is a leading solution for boosting website speed and reducing server load. Learn how to configure Varnish with Nginx on Ubuntu based on real-world expert experience.

Git

Git Maintenance: Boosting Performance for Repositories with Thousands of Commits

By admin May 29, 2026

Is your Git repository slowing down? Use git maintenance to automatically optimize, reducing git status and fetch times for large projects effectively.

Linux

Mastering systemd-run: ‘Instant’ CPU and RAM Limits for Linux Scripts

By admin May 24, 2026

Don't let backup or crawling scripts crash your server. Learn how to use systemd-run to limit RAM, CPU, and I/O instantly—a must-have tool for SysAdmins.

Git

How to ‘Hack’ Git Clone Speed for Multi-GB Repositories

By admin May 23, 2026

Don't let multi-gigabyte repositories slow you down. A detailed guide on using Shallow Clone and Partial Clone to speed up Git, optimize CI/CD, and save disk space.