Database Optimization – ITFROMZERO

A Guide to Using mysqlcheck for MySQL Database Maintenance, Optimization, and Table Repair

By admin June 13, 2026

A detailed guide on using mysqlcheck to check for table corruption, repair broken tables, and optimize MySQL database performance — with practical tips from real production incidents.

MySQL

MySQL Thread Pool: The ‘Lifesaver’ for Handling Thousands of Database Connections

By admin June 10, 2026

Don't let MySQL collapse under connection overload. A detailed guide on configuring Thread Pool to optimize CPU, reduce context switching, and keep your database stable under heavy pressure.

MySQL

Add Columns to a 200 Million Record Table in 0.1 Seconds: The Power of ALGORITHM=INSTANT in MySQL 8.0

By admin June 8, 2026

Discover how to use ALGORITHM=INSTANT in MySQL 8.0 to add or drop columns on tables with hundreds of millions of records in milliseconds, completely eliminating downtime.

MySQL

MySQL Histograms: The Secret to Speeding Up Queries Without Adding Indexes

By admin June 7, 2026

Don't let the MySQL Optimizer guess! Learn how to use Histogram Statistics to speed up queries, optimize data distribution, and reduce index overhead on large tables.

MySQL

Cleaning Up Million-Row MySQL Tables: Don’t Let DELETE Commands Crash Your System

By admin June 7, 2026

Don't let a DELETE command crash your server! Discover 3 safe techniques for cleaning up million-row MySQL tables: Batching, Partitioning, and pt-archiver based on real-world 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.

Database

Optimizing PostgreSQL with pgpool-II: Real-world Pooling, Load Balancing, and Caching Solutions

By admin May 28, 2026

Is your PostgreSQL system overloaded with connections? Discover how pgpool-II solves connection pooling, load balancing, and query acceleration in this practical guide.

Database

Optimizing PostgreSQL Dashboards: Speed up Queries 100x with Materialized Views

By admin May 27, 2026

Discover the power of Materialized Views in PostgreSQL. An optimal solution to make dashboards load instantly by storing pre-calculated query results.

MySQL

MySQL 8 Resource Groups: Don’t Let a “Heavy” Query Crash Your Entire Production System

By admin May 27, 2026

Learn how to use Resource Groups in MySQL 8 to isolate CPU for heavy queries, protecting your production system from server hangs and optimizing user latency.

MySQL

MySQL Query Rewrite Plugin: Optimize and Fix SQL Queries Without Touching Your Application Code

By admin May 21, 2026

MySQL Query Rewrite Plugin lets you intercept and modify SQL statements at the database layer without changing any application source code. This guide covers installation, configuration, and practical use cases for production environments.