Tagged articles
12 articles
Page 1 of 1
MaGe Linux Operations
MaGe Linux Operations
Nov 25, 2025 · Databases

10 Common MySQL Index Failure Scenarios and How to Fix Them

This comprehensive guide explains why MySQL indexes often become ineffective, outlines ten typical failure scenarios with concrete EXPLAIN examples, and provides practical solutions, scripts, best‑practice recommendations, and monitoring techniques to dramatically improve slow‑query performance.

Database PerformanceIndex OptimizationSQL Tuning
0 likes · 35 min read
10 Common MySQL Index Failure Scenarios and How to Fix Them
ITPUB
ITPUB
Oct 15, 2024 · Databases

8 Essential MongoDB Admin Scripts to Master Database Management

This guide presents eight practical MongoDB shell scripts—covering database size analysis, connection monitoring, long‑running query termination, table‑scan detection, replica‑set health checks, and slow‑query profiling—plus usage tips and cautions for reliable administration.

Database AdministrationMongoDBPerformance Monitoring
0 likes · 15 min read
8 Essential MongoDB Admin Scripts to Master Database Management
Wukong Talks Architecture
Wukong Talks Architecture
Sep 27, 2022 · Databases

MySQL Large Table Index Optimization and Delete Performance Tuning

This article analyzes a MySQL large‑table performance issue caused by slow queries and full‑table scans, demonstrates using pt‑query‑digest, explains execution plans, proposes index redesign, shows backup and restore with mydumper, compares online DDL and pt‑osc, and presents batch delete strategies to reduce latency.

Batch DeleteDDLDatabase Performance
0 likes · 13 min read
MySQL Large Table Index Optimization and Delete Performance Tuning
Programmer DD
Programmer DD
Aug 16, 2022 · Databases

Master MySQL Monitoring with Built‑in SHOW Commands: A Complete Guide

This article explains how to collect comprehensive MySQL performance metrics—including connections, buffer cache, locks, statement counts, throughput, server variables, and slow‑query analysis—using only MySQL's native SHOW commands, providing a fast, low‑overhead monitoring solution.

Database MonitoringMetricsSQL
0 likes · 11 min read
Master MySQL Monitoring with Built‑in SHOW Commands: A Complete Guide
Laravel Tech Community
Laravel Tech Community
Dec 17, 2020 · Databases

Understanding Index Usage and Slow Queries in MySQL

This article explains why using indexes in MySQL does not always prevent slow queries, analyzes full‑index scans, index selectivity, back‑table lookups, virtual columns, and provides practical optimization techniques to reduce scanned rows and improve performance.

Database PerformanceSlow QueriesVirtual Columns
0 likes · 11 min read
Understanding Index Usage and Slow Queries in MySQL
Java Captain
Java Captain
Dec 22, 2018 · Databases

MySQL Database Design, Slow Query Issues, and Handling Mistakes

This article discusses MySQL table design choices, partitioning methods, index best practices, common causes of slow queries with optimization tips, useful diagnostic tools, and recommended actions when accidental operations or bugs affect data.

Data RecoveryIndex OptimizationSlow Queries
0 likes · 10 min read
MySQL Database Design, Slow Query Issues, and Handling Mistakes
Java Backend Technology
Java Backend Technology
Apr 8, 2018 · Databases

Master MySQL: Table Design, Slow Query Fixes, and Recovery Strategies

This article reviews common MySQL pitfalls—including engine choice, table partitioning, index design, slow‑query causes and optimizations, diagnostic tools, and how to recover from accidental data loss—offering practical guidance for developers to improve performance and reliability.

Database designIndex OptimizationPartitioning
0 likes · 10 min read
Master MySQL: Table Design, Slow Query Fixes, and Recovery Strategies
dbaplus Community
dbaplus Community
Aug 20, 2017 · Databases

How We Cut 98% of Slow MySQL Queries by Tuning Thread‑Pool Settings

This article walks through a real‑world MySQL performance case at Meituan‑Dianping, showing how systematic monitoring, packet capture, and step‑by‑step analysis identified the Thread‑Pool as the bottleneck and how disabling and fine‑tuning its parameters reduced slow queries from thousands to just a few dozen.

Database OptimizationSlow QueriesThread-Pool
0 likes · 16 min read
How We Cut 98% of Slow MySQL Queries by Tuning Thread‑Pool Settings