Posted inLinux
Boosting Linux Server I/O Performance: noatime and tuned profile Tips
A quick guide to optimizing Linux I/O performance by configuring noatime and using tuned profiles to reduce system latency.
Posted inDatabase
PostgreSQL Indexing: Don’t Just Use B-Tree for Millions of Rows
Stop overusing B-Tree for everything. This article shares practical experience on using GIN for JSONB, BRIN for Big Data, and how to create indexes without locking your production database.
Posted inVirtualization
Optimizing KVM/Proxmox Resources: Stop VMs from Draining Your Hardware
Managing KVM/Proxmox resources effectively is easy when you know how. Guide on optimizing CPU Type, configuring VirtIO SCSI, and RAM Ballooning tips to prevent bottlenecks.
Posted inDatabase
Database Schema Design: Don’t Let Technical Debt Sink Your System
Learn how to design standard database schemas from 1NF to 3NF, the secrets of applying Denormalization to boost performance, and pitfalls to avoid.
Posted inPython
Python Profiling: Pro Tips for Troubleshooting Slow Code with cProfile and Py-Spy
Stop guessing why your Python code is slow. This guide shows you how to use cProfile and Py-Spy to pinpoint bottlenecks and optimize performance based on real-world experience.
Posted inDocker
Monitor Docker Container Resources with `docker stats` and cAdvisor: Identify CPU, RAM Hogs
Optimizing Docker application performance is an essential skill. This article provides detailed guidance on using `docker stats` and cAdvisor to monitor container CPU and RAM, helping you effectively identify and resolve performance issues.
Posted inMySQL
MySQL Full-Text Search: The Secret to Super-Fast and Accurate Search for Your Applications
Search functionality is vital for many applications, but `LIKE` often leads to poor performance. This article guides you on using MySQL Full-Text Search to build super-fast, effective search with relevance ranking directly within your database.
Posted inDatabase
Optimizing PostgreSQL Queries with EXPLAIN ANALYZE: Analyzing and Improving Query Performance
Learn how to use EXPLAIN ANALYZE in PostgreSQL to read execution plans, analyze slow queries, and optimize performance with the right indexes. This guide goes from a 5-minute quick start to advanced techniques like covering indexes, composite indexes, and auto_explain.
Posted inVMware
VMware VM Performance Optimization: A Real-World Checklist from Production
Six months managing an 8-host ESXi VMware cluster: choosing the right disk adapter (PVSCSI), network adapter (VMXNET3), controlling the balloon driver, handling long snapshot chains, and monitoring with esxtop. A practical checklist that brought CPU ready time down from 8% to under 2%.
Posted inNetwork
Measuring Network Speed and Performance with iperf3 on Linux Server
A guide to using iperf3 to measure real-world bandwidth between two Linux servers, detect packet loss and jitter with UDP mode, and write time-based monitoring scripts to catch intermittent issues. Includes comparisons with speedtest-cli and netperf to help you pick the right tool for each scenario.