database performance Archives - ITFROMZERO

Monitoring tutorial - IT technology blog

A Practical Guide to Monitoring PgBouncer Connection Pooler with Prometheus and Grafana

By IT From Zero October 14, 2026

Hands-on experience monitoring PgBouncer with Prometheus and Grafana. Learn how to track waiting queries, measure pool saturation, and craft alert rules that eliminate alert fatigue in production.

Database

Manticore Search: The Lifesaver Alternative to Elasticsearch When Server RAM Runs Out

By IT From Zero September 12, 2026

Manticore Search is the perfect Elasticsearch alternative for low-spec servers. This guide covers installation, optimization, and real-world big data tips on Linux.

MySQL

How to Find and Remove Unused Indexes in MySQL: Reclaim Disk Space and Speed Up Writes

By IT From Zero September 4, 2026

Unused indexes in MySQL don't just waste disk space — they slow down every write operation. This guide walks through how to safely identify and remove them using performance_schema and the sys schema, complete with a pre-drop checklist and an automated monitoring script.

MySQL

mysqlslap: How I “Torture” MySQL to Find Real-World Load Limits

By IT From Zero September 2, 2026

Don't wait for a crash to optimize. Learn how to use mysqlslap to simulate hundreds of users, test MySQL load limits, and optimize indexes based on real-world data.

MySQL

Is MySQL Choking Under Heavy Write Loads? Optimization Secrets for Write-Heavy Systems

By IT From Zero August 8, 2026

Is your MySQL system slowing down during heavy write operations? Discover how to optimize Redo Log, Doublewrite Buffer, and Batch Insert techniques to boost write speeds by 10x.

Database

pg_stat_statements in PostgreSQL: Find and Optimize Resource-Hungry SQL Queries

By IT From Zero June 16, 2026

pg_stat_statements is a PostgreSQL extension that runs in the background and continuously accumulates execution statistics for every SQL statement, letting you pinpoint exactly which queries are consuming the most CPU, I/O, and time. This guide walks through installation, configuration, and practical analysis queries to track down performance bottlenecks in PostgreSQL.

Database

ScyllaDB: Revolutionizing Write-Heavy System Performance as a Cassandra Alternative

By IT From Zero May 10, 2026

Tired of Cassandra's latency? ScyllaDB is a high-speed C++ rewrite that eliminates Garbage Collection overhead to achieve maximum write performance. Explore our setup and optimization guide.

MySQL

Optimizing MySQL 8 with EXPLAIN ANALYZE: Don’t Let the Optimizer Mislead You

By IT From Zero May 9, 2026

Don't let the MySQL Optimizer mislead you with predicted numbers. Learn how to use EXPLAIN ANALYZE to accurately measure every millisecond of execution and optimize queries effectively.

MySQL

Practical Experience: Optimizing MySQL Query Performance with Index and EXPLAIN

By IT From Zero March 22, 2026

This article shares practical experience on how to optimize MySQL query performance using Indexes and the EXPLAIN tool. Learn about different Index types, how to analyze query execution plans, and important considerations when applying them to make your system run faster and more stable.