BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 3 of 50
Programmer XiaoFu
Programmer XiaoFu
Jun 1, 2026 · Databases

Why Does an OR Between Two Indexed Columns Still Trigger a Full Table Scan?

Even though the phone and email columns each have a single‑column index, an OR condition forces MySQL's cost‑based optimizer to choose a full table scan because the estimated cost of index merge (random I/O and possible sort‑union) exceeds the cost of a sequential scan, and the article explains the underlying mechanics and practical workarounds.

MySQLOR querySQL
0 likes · 10 min read
Why Does an OR Between Two Indexed Columns Still Trigger a Full Table Scan?
MaGe Linux Operations
MaGe Linux Operations
May 30, 2026 · Databases

How Ops Engineers Fix MySQL Slow Queries: A Step‑by‑Step Guide

This article walks through the entire MySQL performance troubleshooting workflow from an operations perspective, covering architecture basics, slow‑query‑log configuration, analysis with mysqldumpslow and pt‑query‑digest, EXPLAIN interpretation, index design and optimization, configuration tuning, replication monitoring, real‑time diagnostic commands, risk mitigation, rollback procedures, and backup strategies.

ConfigurationMySQLPerformance
0 likes · 40 min read
How Ops Engineers Fix MySQL Slow Queries: A Step‑by‑Step Guide
Su San Talks Tech
Su San Talks Tech
May 30, 2026 · Databases

Why PostgreSQL Beats MySQL for AI‑Driven Applications

The article explains why many developers stuck with MySQL should consider PostgreSQL, highlighting its superior SQL standards support, MVCC concurrency, rich indexing, JSONB performance, full‑text search, extensive extensions, and practical installation and Java integration steps, while also comparing pros, cons, and ideal use cases.

JSONBJavaMVCC
0 likes · 24 min read
Why PostgreSQL Beats MySQL for AI‑Driven Applications
Wukong Talks Architecture
Wukong Talks Architecture
May 28, 2026 · Databases

Understanding MySQL InnoDB Locks: Types, Queries, and Common Pitfalls

This article explains InnoDB's lock mechanisms—including table, intention, row, GAP, next‑key, and auto‑increment locks—shows how to inspect them via performance_schema tables, demonstrates lock behavior under different isolation levels with concrete SQL examples, and clarifies lock compatibility rules.

Gap LockInnoDBLocks
0 likes · 20 min read
Understanding MySQL InnoDB Locks: Types, Queries, and Common Pitfalls
Ops Community
Ops Community
May 26, 2026 · Databases

How to Safely Clean Up MySQL Binlog When Disk Space Is Critical

This guide walks through why MySQL binlog can fill disks, explains its structure and formats, and provides a step‑by‑step, risk‑aware process—including preparation, safe PURGE commands, automatic expiration settings, verification, and monitoring—to clean binlog without breaking replication or losing data.

BinlogMySQLReplication
0 likes · 34 min read
How to Safely Clean Up MySQL Binlog When Disk Space Is Critical
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
May 25, 2026 · Databases

11 Golden Rules for SQL Performance Optimization

This article explains why inefficient SQL queries cause most database bottlenecks and presents eleven concrete rules—covering indexes, SELECT *, LIMIT, WHERE clause tuning, join strategies, execution‑plan analysis, subqueries, DISTINCT, ORDER BY/GROUP BY, UNION vs UNION ALL, and query decomposition with materialized views—to help developers systematically improve SQL execution speed on MySQL and Oracle.

MySQLOptimizationOracle
0 likes · 16 min read
11 Golden Rules for SQL Performance Optimization
MaGe Linux Operations
MaGe Linux Operations
May 23, 2026 · Databases

Why MySQL Replication Lag Isn’t Just a Network Issue

The article explains MySQL master‑slave replication fundamentals, shows how to monitor replication status, enumerates common delay causes such as network latency, master write pressure, SQL thread bottlenecks, large transactions, missing primary keys, slave overload, replication conflicts and GTID quirks, and provides scripts, configuration tips, and real‑world case studies for troubleshooting and prevention.

ConfigurationLagMySQL
0 likes · 28 min read
Why MySQL Replication Lag Isn’t Just a Network Issue
Architect's Guide
Architect's Guide
May 23, 2026 · Databases

SQL Optimization: Cutting Query Time from 30,248 s to 0.001 s

This article walks through a MySQL 5.6 case study where a sub‑query that originally took over eight hours is accelerated to a few milliseconds by analyzing the execution plan, adding single‑column and composite indexes, rewriting the query as EXISTS or JOIN, and applying best‑practice indexing techniques.

JOINMySQLSQL optimization
0 likes · 13 min read
SQL Optimization: Cutting Query Time from 30,248 s to 0.001 s
Smart Sea Tide
Smart Sea Tide
May 22, 2026 · Databases

SQL Query Optimization: Cutting a 9M‑Row Scan from 17 s to 300 ms

The article analyzes why a MySQL LIMIT OFFSET query on a 9.5 million‑row table takes 16 seconds, demonstrates how moving the filter into a sub‑query that returns only primary‑key IDs and joining back reduces execution to 0.35 seconds, and validates the theory by measuring InnoDB buffer‑pool page accesses.

Buffer PoolInnoDBLIMIT OFFSET
0 likes · 9 min read
SQL Query Optimization: Cutting a 9M‑Row Scan from 17 s to 300 ms
dbaplus Community
dbaplus Community
May 21, 2026 · Databases

Is count(*) Really the Slowest? MySQL COUNT Performance Debunked

The article explains how MySQL implements COUNT(1), COUNT(*), COUNT(primary_key) and COUNT(column), showing that COUNT(*) and COUNT(1) have identical performance, COUNT(column) is the slowest, and provides indexing and approximation tips for large InnoDB tables.

COUNTInnoDBMySQL
0 likes · 9 min read
Is count(*) Really the Slowest? MySQL COUNT Performance Debunked
MaGe Linux Operations
MaGe Linux Operations
May 19, 2026 · Databases

How I Reduced a MySQL Slow Query from 3 seconds to 10 milliseconds

This article walks through a real‑world MySQL slow‑query case, showing how to identify the bottleneck with EXPLAIN, design covering and composite indexes, rewrite the SQL, tune InnoDB parameters, and safely deploy the changes, ultimately shrinking execution time from seconds to a few milliseconds.

EXPLAINMySQLOptimization
0 likes · 32 min read
How I Reduced a MySQL Slow Query from 3 seconds to 10 milliseconds
Ops Community
Ops Community
May 19, 2026 · Databases

10 Common MySQL Index Failure Scenarios – Which Ones Affect You?

This article examines ten typical situations where MySQL indexes become ineffective, explains the underlying reasons such as function usage, implicit type conversion, wildcard LIKE patterns, OR conditions, left‑most prefix violations, small tables, stale statistics, NULL handling, GROUP BY/DISTINCT, and ORDER BY, and provides concrete SQL examples and step‑by‑step remediation techniques to restore optimal query performance.

EXPLAINIndex OptimizationMySQL
0 likes · 32 min read
10 Common MySQL Index Failure Scenarios – Which Ones Affect You?
Cloud Architecture
Cloud Architecture
May 18, 2026 · Databases

Building a High‑Concurrency, Recoverable, Scalable MySQL Backup Platform with MyDumper

The article explains why many teams only have backup files without true recovery capability and walks through designing a production‑grade MySQL backup system using MyDumper, covering consistency snapshots, parallel export, metadata, Kubernetes integration, storage, monitoring, and step‑by‑step scripts for reliable, scalable data protection.

KubernetesMyDumperMySQL
0 likes · 48 min read
Building a High‑Concurrency, Recoverable, Scalable MySQL Backup Platform with MyDumper
Su San Talks Tech
Su San Talks Tech
May 17, 2026 · Databases

Why Leading Companies Avoid NULL Values in MySQL

The article explains why major tech companies discourage using NULL in MySQL, covering its meaning as an unknown state, three-valued logic pitfalls such as NOT IN subqueries, index inefficiencies, aggregate function quirks, storage overhead, Java handling issues, and offers practical alternatives like NOT NULL constraints with sensible defaults.

Index OptimizationMySQLNULL
0 likes · 11 min read
Why Leading Companies Avoid NULL Values in MySQL
Cloud Architecture
Cloud Architecture
May 16, 2026 · Databases

MySQL 8.x Large Pagination Guide: From OFFSET Performance Pitfalls to Production‑Ready Cursor Pagination

This article explains why deep OFFSET pagination in MySQL 8.x forces the database to scan, sort and discard massive rows, outlines four categories of pagination bottlenecks, and presents a step‑by‑step engineering roadmap—including covering indexes, delayed joins, cursor pagination, Elasticsearch integration, API contracts, and production‑grade Spring Boot/MyBatis code—to eliminate the performance black‑hole and build a scalable pagination architecture.

CursorElasticsearchMySQL
0 likes · 35 min read
MySQL 8.x Large Pagination Guide: From OFFSET Performance Pitfalls to Production‑Ready Cursor Pagination
ITPUB
ITPUB
May 14, 2026 · Databases

MySQL 8.0 Reaches End‑of‑Life – What 8.4.9 LTS and 9.7.0 Bring to the Next Era

On April 21, 2026 MySQL 8.0 officially ends its eight‑year run as Oracle releases 8.4.9 LTS and 9.7.0 LTS, introducing long‑term support, new security plugins, Hypergraph Optimizer, JSON Duality Views, cgroup enhancements, and detailed upgrade paths, while warning of severe risks for unpatched 8.0 deployments.

8.4.99.7.0Hypergraph Optimizer
0 likes · 22 min read
MySQL 8.0 Reaches End‑of‑Life – What 8.4.9 LTS and 9.7.0 Bring to the Next Era
21CTO
21CTO
May 14, 2026 · Databases

MySQL 9.7 LTS Launch: First Major Release Since 8.4 Brings Enterprise Features to the Community

Oracle announced MySQL 9.7.0 LTS, the first major LTS since 8.4, introducing community‑available enterprise features such as the Hypergraph optimizer, dynamic data masking, enhanced replication observability, and new operational tools, while addressing community concerns about Oracle’s commitment and recent development slowdown.

Dynamic data maskingHypergraph OptimizerLTS
0 likes · 8 min read
MySQL 9.7 LTS Launch: First Major Release Since 8.4 Brings Enterprise Features to the Community
samdeepthink
samdeepthink
May 14, 2026 · Backend Development

Designing a Group Order Module: Unified Payment and Post‑Payment Cost Splitting

This article details a production‑grade group‑order system where a single initiator pays the total order, then uses WeChat's group‑collection API to split costs among participants, covering the full workflow, data model, Redis caching strategy, payment callbacks, cost‑allocation formulas, state machine, and operational constraints.

BackendMySQLRedis
0 likes · 19 min read
Designing a Group Order Module: Unified Payment and Post‑Payment Cost Splitting
Architect's Guide
Architect's Guide
May 14, 2026 · Databases

8 SQL Pitfalls That Can Slow Your Queries 100‑Fold – How to Avoid Them

The article enumerates eight common MySQL query patterns—such as large‑offset LIMIT, implicit type conversion, sub‑query updates, mixed ordering, unnecessary EXISTS, poor condition push‑down, early range reduction, and inefficient intermediate result handling—and shows rewritten SQL that reduces execution time from seconds to milliseconds.

JOINMySQLPerformance
0 likes · 15 min read
8 SQL Pitfalls That Can Slow Your Queries 100‑Fold – How to Avoid Them
Wukong Talks Architecture
Wukong Talks Architecture
May 14, 2026 · Databases

How to Cut a Production MySQL 8.0 LATERAL Query from 3 s to 0.8 s

The article walks through diagnosing a slow MySQL 8.0 query that scans 77,724 rows and performs a costly filesort, then rewrites it with a LATERAL join and a new index, reducing execution time to about 0.75 seconds on 30 k rows while explaining the differences between ordinary subqueries and LATERAL, and highlighting the need for deterministic ordering when timestamps duplicate.

LATERALMySQLexecution plan
0 likes · 8 min read
How to Cut a Production MySQL 8.0 LATERAL Query from 3 s to 0.8 s
JD Tech
JD Tech
May 13, 2026 · Databases

Deep Dive into Using JSON Fields in Databases: Practical Lessons and Pitfalls

This article walks through the rationale, common functions, and real‑world case studies of storing and querying JSON columns in a relational database, exposing issues with null handling, batch updates, and dynamic SQL generation, and presents step‑by‑step debugging and robust solutions.

Batch UpdateDynamic QueriesJSON
0 likes · 11 min read
Deep Dive into Using JSON Fields in Databases: Practical Lessons and Pitfalls
IT Services Circle
IT Services Circle
May 12, 2026 · Databases

How to Diagnose and Resolve Online Slow SQL That Causes CPU Spikes

When a MySQL‑driven application shows sudden CPU spikes, this guide walks through a step‑by‑step process—using top/htop, SHOW PROCESSLIST, enabling slow‑query logs, analyzing EXPLAIN output, killing offending queries, adding appropriate indexes, rewriting joins, and establishing preventive monitoring—to quickly identify and fix the root cause.

CPU spikeMySQLSQL optimization
0 likes · 12 min read
How to Diagnose and Resolve Online Slow SQL That Causes CPU Spikes
Coder Trainee
Coder Trainee
May 12, 2026 · Backend Development

Designing a Logistics Prepaid Deduction System: Architecture & Core Implementation

This article details a logistics‑focused prepaid deduction platform built with a Spring Boot backend and Vue 3 frontend, covering precise cent‑to‑yuan handling, role‑based view isolation, VO‑based pagination, automatic deduction workflow, and an Apple‑style responsive UI using Tailwind CSS.

Money PrecisionMySQLRole-Based Access
0 likes · 6 min read
Designing a Logistics Prepaid Deduction System: Architecture & Core Implementation
dbaplus Community
dbaplus Community
May 11, 2026 · Databases

Why an Unindexed UPDATE Can Crash Your Business—and How to Prevent It

The article explains how running an UPDATE without an indexed WHERE clause in InnoDB under repeatable‑read can trigger full‑table next‑key locks that block other statements, halt the service, and how using indexed predicates, checking execution plans, enabling sql_safe_updates, or forcing an index can avoid the disaster.

InnoDBMySQLUpdate
0 likes · 8 min read
Why an Unindexed UPDATE Can Crash Your Business—and How to Prevent It
Architect's Guide
Architect's Guide
May 11, 2026 · Backend Development

Why UUID Falls Short and How Snowflake Solves Distributed ID Generation

The article examines the limitations of UUIDs for distributed systems, outlines the strict requirements for global unique IDs, compares common approaches such as database auto‑increment and Redis, and provides a detailed analysis of Twitter's Snowflake algorithm with its structure, Java implementation, advantages, drawbacks, and mitigation strategies.

BackendJavaMySQL
0 likes · 14 min read
Why UUID Falls Short and How Snowflake Solves Distributed ID Generation
Cloud Architecture
Cloud Architecture
May 10, 2026 · Databases

Building an Automated End-to-End Loop for Full-Stack SQL Performance Optimization

The article walks through a real-world e-commerce incident, explains why a seemingly simple slow order-query SQL can cripple an entire high-traffic system, and presents a complete automated workflow—from detection and analysis to optimization, deployment, verification, and regression monitoring—to achieve sustainable full-stack SQL performance.

MySQLObservabilityPerformance Optimization
0 likes · 28 min read
Building an Automated End-to-End Loop for Full-Stack SQL Performance Optimization
Cloud Architecture
Cloud Architecture
May 8, 2026 · Databases

Slow Queries Causing Outages? Build a Cloud‑Native Distributed MySQL Slow‑Log Platform from Scratch

This article walks through the design and implementation of a production‑grade, cloud‑native MySQL slow‑log collection and analysis platform, covering everything from MySQL slow‑log fundamentals and multi‑node ingestion to Kafka buffering, Go‑based parsing, SQL fingerprinting, Elasticsearch and ClickHouse storage, alerting, APM integration, and a phased rollout roadmap.

Cloud NativeKafkaKubernetes
0 likes · 35 min read
Slow Queries Causing Outages? Build a Cloud‑Native Distributed MySQL Slow‑Log Platform from Scratch
Golang Shines
Golang Shines
May 7, 2026 · Databases

160 Must‑Know MySQL Interview Questions to Test Your Skills

This article presents 160 high‑frequency MySQL interview questions, covering fundamentals such as SQL basics, MySQL vs. Oracle vs. SQL Service, normalization rules, permission tables, and more, with a free PDF of the full list for interview preparation.

MySQLSQLdatabase design
0 likes · 5 min read
160 Must‑Know MySQL Interview Questions to Test Your Skills
ITPUB
ITPUB
May 6, 2026 · Databases

The Hidden MySQL File That Grows on Its Own—Why 90% of DBAs Miss It

A sudden disk‑usage alarm reveals MySQL's ibtmp1 file ballooning to 192 GB, prompting a step‑by‑step investigation that explains the file’s purpose, shows how to clear and cap its size, and demonstrates how inefficient SQL queries can trigger such runaway growth.

MySQLSQL optimizationTemporary tables
0 likes · 8 min read
The Hidden MySQL File That Grows on Its Own—Why 90% of DBAs Miss It
Ops Community
Ops Community
May 6, 2026 · Operations

Step‑by‑Step Debugging of a Slow Website: From Nginx to the Database

When a website’s response time jumped from 200 ms to over 10 seconds, this guide walks through a layered investigation—from confirming the scope, checking Nginx and upstream health, analyzing application logs, inspecting MySQL processes, slow queries, and locks, to examining server CPU, memory, disk I/O, and network—providing concrete commands, expected outputs, and root‑cause patterns for effective troubleshooting and preventive monitoring.

LinuxMySQLNginx
0 likes · 34 min read
Step‑by‑Step Debugging of a Slow Website: From Nginx to the Database
Su San Talks Tech
Su San Talks Tech
May 5, 2026 · Databases

Alibaba Interview: Key Considerations for Indexing Tens‑Millions‑Row Tables

The article explains how to safely add indexes to a tens‑of‑millions‑row MySQL table, covering lock duration, disk‑space impact, write‑performance degradation, and six practical principles—selective columns, proper order, covering indexes, avoiding redundancy, short‑lock tools, and ongoing monitoring—plus pros, cons, and suitable use cases.

MySQLOnline DDLPerformance Monitoring
0 likes · 10 min read
Alibaba Interview: Key Considerations for Indexing Tens‑Millions‑Row Tables
Architect Chen
Architect Chen
May 4, 2026 · Databases

What’s the Difference Between MySQL Redo Log and Binlog? (Interview Insight)

The article explains that MySQL redo log operates at the InnoDB engine layer to ensure transaction durability and crash recovery, while binlog works at the server layer to record logical changes for replication, archiving, and point‑in‑time recovery, highlighting their distinct layers, purposes, content, and write mechanisms.

BinlogCrash RecoveryInnoDB
0 likes · 4 min read
What’s the Difference Between MySQL Redo Log and Binlog? (Interview Insight)
SpringMeng
SpringMeng
May 3, 2026 · Databases

Why Choose MySQL Over PostgreSQL? Key Technical Drawbacks Explained

The article compares PostgreSQL and MySQL, highlighting PostgreSQL's richer data types, extensible ecosystem, advanced replication and monitoring features, while exposing MySQL's limitations in data modeling, sequence support, tooling, and replication, and concludes that the best choice depends on specific workload requirements.

Data TypesMVCCMySQL
0 likes · 8 min read
Why Choose MySQL Over PostgreSQL? Key Technical Drawbacks Explained
Su San Talks Tech
Su San Talks Tech
May 3, 2026 · Databases

How to Speed Up a 10‑Table JOIN Query in MySQL (JD Interview Scenario)

When a production MySQL query joins ten tables and exceeds 30 seconds, a systematic approach—starting with EXPLAIN analysis, profiling, and configuration checks—combined with layered optimizations such as indexing, join order adjustment, query splitting, temporary tables, materialized views, OLAP engines, and vertical partitioning—can dramatically improve performance.

JOINMySQLOLAP
0 likes · 17 min read
How to Speed Up a 10‑Table JOIN Query in MySQL (JD Interview Scenario)
java1234
java1234
May 3, 2026 · Mobile Development

Building a WeChat Mini‑Program Dormitory Management System in 20 Minutes with Cursor AI

The author demonstrates how Cursor AI and Opus 4.7 can generate a complete campus dormitory management solution—including a Spring Boot backend, Vue 3 admin portal, and a WeChat mini‑program front‑end—within twenty minutes, and provides the source code, video tutorial, and deployment details.

Cursor AIDormitory ManagementMySQL
0 likes · 7 min read
Building a WeChat Mini‑Program Dormitory Management System in 20 Minutes with Cursor AI
Ops Community
Ops Community
May 2, 2026 · Databases

How to Completely Resolve MySQL CPU Spikes: Real‑World Fault Replay and Optimization Guide

This article walks you through a systematic, step‑by‑step process for diagnosing and fixing MySQL CPU usage spikes—from identifying the symptoms and gathering system metrics, to pinpointing problematic queries, analyzing locks and buffers, applying index and configuration tweaks, and validating the performance gains with real‑world examples and command‑line tools.

CPUIndex OptimizationMySQL
0 likes · 44 min read
How to Completely Resolve MySQL CPU Spikes: Real‑World Fault Replay and Optimization Guide
Cloud Architecture
Cloud Architecture
Apr 29, 2026 · Databases

ORM Type Mismatch Causes MySQL Index Failure and Outage – Investigation & Fix

An ORM parameter type mismatch caused MySQL to perform implicit conversion on a VARCHAR index column, turning an indexed query into a full table scan that saturated connection pools, thread pools, Kafka consumers, and upstream services during a high‑traffic promotion, illustrating the full‑stack impact and remediation steps.

Index OptimizationMySQLORM
0 likes · 29 min read
ORM Type Mismatch Causes MySQL Index Failure and Outage – Investigation & Fix
Coder Trainee
Coder Trainee
Apr 29, 2026 · Backend Development

Mastering Distributed Transactions with Seata in Spring Cloud Microservices

This article explains why distributed transactions are essential in microservice architectures, introduces Alibaba's open‑source Seata solution, compares its AT, TCC and Saga modes, shows step‑by‑step Docker deployment, provides full Spring Cloud code examples, and lists common pitfalls and debugging tips.

AT ModeDocker ComposeMySQL
0 likes · 12 min read
Mastering Distributed Transactions with Seata in Spring Cloud Microservices
MaGe Linux Operations
MaGe Linux Operations
Apr 27, 2026 · Databases

Production MySQL Deadlocks: Diagnosis Strategies and Permanent Fixes

The article explains how MySQL InnoDB deadlocks occur, details the four necessary conditions, shows how to enable full deadlock logging, demonstrates queries against information_schema and performance_schema, and provides concrete scenarios with code‑level solutions to prevent and resolve deadlocks in production environments.

InnoDBMySQLTroubleshooting
0 likes · 22 min read
Production MySQL Deadlocks: Diagnosis Strategies and Permanent Fixes
Cloud Architecture
Cloud Architecture
Apr 25, 2026 · Databases

How a Phone Number Field Can Crash a 2B‑User Database – Architect’s Design Guide

A mis‑designed phone number column can silently degrade index performance, overload CPU, and cause a cascade of timeouts in a 2‑billion‑user system, but by treating the phone as a domain value object, using a normalized VARCHAR, aligning indexing rules, and applying consistent sharding and migration strategies, you can prevent the database from collapsing under high concurrency.

MySQLValue Objectdatabase design
0 likes · 31 min read
How a Phone Number Field Can Crash a 2B‑User Database – Architect’s Design Guide
Raymond Ops
Raymond Ops
Apr 25, 2026 · Databases

How to Reduce MySQL Master‑Slave Replication Lag from 30 seconds to Milliseconds

This article walks through the root causes of MySQL master‑slave replication delay, demonstrates step‑by‑step diagnostics using SHOW SLAVE STATUS, pt‑heartbeat, and binlog comparisons, and provides concrete configuration changes, query rewrites, hardware upgrades, and monitoring scripts that can shrink lag from dozens of seconds to sub‑millisecond levels.

MySQLParallel ReplicationReplication
0 likes · 23 min read
How to Reduce MySQL Master‑Slave Replication Lag from 30 seconds to Milliseconds
Architect's Guide
Architect's Guide
Apr 25, 2026 · Databases

Three Free Tools That Can Replace Navicat for MySQL

The article reviews three free MySQL client alternatives—DBeaver, MySQL Workbench, and HeidiSQL—detailing their installation steps, supported databases, key features such as monitoring and ER diagrams, and why they can serve as practical replacements for the paid Navicat tool.

DBeaverDatabase clientHeidiSQL
0 likes · 5 min read
Three Free Tools That Can Replace Navicat for MySQL
IoT Full-Stack Technology
IoT Full-Stack Technology
Apr 24, 2026 · Databases

Why Choose PostgreSQL Over MySQL Despite MySQL’s Popularity?

The article compares PostgreSQL and MySQL across data types, native sequences, extensions, monitoring tools, replication mechanisms, licensing, community governance, and MVCC implementation, showing why many Chinese tech giants favor PostgreSQL for complex, high‑consistency workloads while acknowledging MySQL’s strengths in simple web scenarios.

MVCCMySQLPostgreSQL
0 likes · 9 min read
Why Choose PostgreSQL Over MySQL Despite MySQL’s Popularity?
Architecture & Thinking
Architecture & Thinking
Apr 24, 2026 · Databases

SQL Index Failure Scenarios: Essential Pitfalls and Fixes Every Developer Must Know

This article systematically examines why MySQL indexes can become ineffective—covering function calls, implicit casts, LIKE patterns, OR conditions, composite‑index left‑most rules, data distribution, and ORDER/GROUP mismatches—while providing concrete code examples, production case studies, and actionable optimization techniques.

B+ TreeIndex OptimizationMySQL
0 likes · 26 min read
SQL Index Failure Scenarios: Essential Pitfalls and Fixes Every Developer Must Know
MaGe Linux Operations
MaGe Linux Operations
Apr 23, 2026 · Databases

How to Diagnose and Optimize MySQL Slow Queries Beyond Adding Indexes

This guide walks through a systematic approach to identify, analyze, and fix MySQL slow queries by enabling the slow‑query log, interpreting its format, using tools like mysqldumpslow and pt‑query‑digest, examining execution plans with EXPLAIN, designing proper indexes, rewriting SQL, tuning server parameters, and establishing continuous monitoring to prevent regressions.

EXPLAINIndex OptimizationMySQL
0 likes · 34 min read
How to Diagnose and Optimize MySQL Slow Queries Beyond Adding Indexes
Architect's Guide
Architect's Guide
Apr 23, 2026 · Databases

Is JOIN Faster Than IN in MySQL Queries? A Practical Performance Test

The article experimentally compares MySQL JOIN and IN queries across small, medium, and large data sets, showing that JOIN is generally faster for modest volumes while IN can become impractically long and error‑prone with massive lists, leaving neither approach ideal for all scenarios.

JOINMySQLPHP
0 likes · 8 min read
Is JOIN Faster Than IN in MySQL Queries? A Practical Performance Test
Ray's Galactic Tech
Ray's Galactic Tech
Apr 22, 2026 · Cloud Native

Solving K8s Stateful App Storage Pain: Production-Ready Longhorn + MySQL StatefulSet

This article dissects the challenges of running MySQL as a stateful workload on Kubernetes, explains why storage, consistency, and fail‑over are the real pain points, and provides a production‑grade solution that combines Longhorn distributed block storage with a carefully engineered MySQL 8.0 StatefulSet, complete with YAML manifests, performance tuning, backup strategies, and disaster‑recovery playbooks.

KubernetesLonghornMySQL
0 likes · 50 min read
Solving K8s Stateful App Storage Pain: Production-Ready Longhorn + MySQL StatefulSet
Ops Community
Ops Community
Apr 22, 2026 · Databases

Is MySQL CPU Spike a Database Issue or an Application Issue? Troubleshooting Guide

When MySQL CPU usage spikes above 80% or hits 100%, this guide walks you through a systematic investigation—from confirming the MySQL process consumes CPU, checking system and MySQL status, analyzing connection counts, slow queries, lock waits, and configuration settings, to applying short‑term mitigations and long‑term architectural fixes.

CPUMySQLTroubleshooting
0 likes · 17 min read
Is MySQL CPU Spike a Database Issue or an Application Issue? Troubleshooting Guide
Architecture & Thinking
Architecture & Thinking
Apr 22, 2026 · Backend Development

Why Traditional Limit‑Offset Fails on Billion‑Row Tables and How to Fix It

This article dissects the performance collapse of classic LIMIT‑OFFSET pagination on tables with hundreds of millions of rows, explains the underlying execution steps, presents benchmark data, and walks through a progressive set of solutions—including index tuning, Seek pagination, Cursor pagination, and sharding—complete with Go code examples and practical trade‑offs.

Cursor PaginationMySQLPerformance
0 likes · 30 min read
Why Traditional Limit‑Offset Fails on Billion‑Row Tables and How to Fix It
Java Tech Workshop
Java Tech Workshop
Apr 21, 2026 · Databases

Optimizing SpringBoot MySQL Indexes: From Slow Query Logs to InnoDB Explain Analysis

This guide walks through why caching alone can't solve performance bottlene bottlenecks, shows how to enable MySQL slow‑query logging in SpringBoot, analyzes slow SQL with tools like mysqldumpslow and pt‑query‑digest, explains the full EXPLAIN output, and dives into InnoDB B‑tree, clustered vs secondary indexes, covering indexes, and common causes of index loss.

Covering IndexEXPLAINIndex Optimization
0 likes · 31 min read
Optimizing SpringBoot MySQL Indexes: From Slow Query Logs to InnoDB Explain Analysis
Java Tech Workshop
Java Tech Workshop
Apr 19, 2026 · Backend Development

Getting Started with Sharding-JDBC in SpringBoot: A Practical Guide to Database Sharding

When a single database table grows to millions of rows, query performance and storage become bottlenecks, and this article explains why sharding is needed, introduces Sharding-JDBC as a lightweight solution, and walks through the complete setup, configuration, code implementation, testing, and advanced concepts such as sharding strategies, key generation, binding tables, and broadcast tables for SpringBoot projects.

Horizontal PartitioningMySQLSharding-JDBC
0 likes · 33 min read
Getting Started with Sharding-JDBC in SpringBoot: A Practical Guide to Database Sharding
Tech Ocean
Tech Ocean
Apr 19, 2026 · Cloud Native

Docker Day 7: Persist Data with Volumes So It Survives Container Deletion

This guide explains why container file systems are transient, compares three Docker storage methods, and demonstrates how to use named volumes—both via the CLI and docker‑compose—to ensure data remains intact after removing containers, with a MySQL persistence example.

DockerDocker ComposeMySQL
0 likes · 5 min read
Docker Day 7: Persist Data with Volumes So It Survives Container Deletion
Ops Community
Ops Community
Apr 19, 2026 · Databases

How to Diagnose and Resolve MySQL CPU Spikes: A Complete Step‑by‑Step Guide

This guide walks you through identifying why MySQL CPU usage jumps, from confirming the MySQL process consumes CPU to checking connection counts, slow queries, lock waits, configuration settings, and business‑level traffic, and then provides short‑term mitigations and long‑term solutions such as read‑write splitting, sharding, and caching.

CPUMySQLOptimization
0 likes · 17 min read
How to Diagnose and Resolve MySQL CPU Spikes: A Complete Step‑by‑Step Guide
Java Tech Workshop
Java Tech Workshop
Apr 19, 2026 · Backend Development

Mastering SpringBoot Concurrency: Pessimistic vs Optimistic Locks Explained

SpringBoot’s @Transactional ensures single‑transaction atomicity, but under high concurrency multiple transactions can still corrupt data; this article dissects why, demonstrates overselling scenarios, and provides detailed implementations of pessimistic (row/table locks) and optimistic (version/timestamp) locking with code, performance tests, and a comprehensive comparison guide.

MySQLOptimisticLockPessimisticLock
0 likes · 24 min read
Mastering SpringBoot Concurrency: Pessimistic vs Optimistic Locks Explained
Selected Java Interview Questions
Selected Java Interview Questions
Apr 18, 2026 · Backend Development

Efficient Hierarchical Menu Storage in MySQL: Adjacency List vs Closure Table

The article examines common pitfalls of using a simple parent_id column for menu hierarchies, compares three storage models—adjacency list, path enumeration, and closure table—shows their trade‑offs, and provides a SpringBoot/MyBatis‑Plus implementation that combines adjacency and closure tables for optimal read‑write performance.

Adjacency ListBackendClosure Table
0 likes · 14 min read
Efficient Hierarchical Menu Storage in MySQL: Adjacency List vs Closure Table
MaGe Linux Operations
MaGe Linux Operations
Apr 18, 2026 · Databases

Master MySQL 8.0 Backup & Recovery: Full Guide with Scripts, Strategies and Best Practices

This comprehensive guide explains why MySQL backup is essential, defines RPO/RTO, compares logical and physical tools, provides ready‑to‑run scripts for full, incremental, binlog, encryption and compression backups, details step‑by‑step recovery procedures, troubleshooting tips and monitoring recommendations for reliable database protection.

MySQLRecoveryXtraBackup
0 likes · 35 min read
Master MySQL 8.0 Backup & Recovery: Full Guide with Scripts, Strategies and Best Practices
Architect's Guide
Architect's Guide
Apr 18, 2026 · Databases

How to Import 1 Billion Records into MySQL at Lightning Speed

This article analyzes the constraints of loading a billion 1‑KB log records from HDFS/S3 into MySQL, evaluates single‑table limits, proposes batch inserts, sharding, file‑reading techniques, task coordination with Redis, Redisson, and Zookeeper, and offers practical performance‑tuning recommendations.

Bulk InsertMySQLRedis
0 likes · 21 min read
How to Import 1 Billion Records into MySQL at Lightning Speed
Cloud Architecture
Cloud Architecture
Apr 17, 2026 · Databases

From Crashing Databases to Zero Data Loss: MySQL Replication Evolution

The article examines common MySQL replication failures, explains why traditional position‑based replication is insufficient, and walks through a step‑by‑step evolution from file/position to GTID, asynchronous to semi‑synchronous, single‑threaded to parallel apply, culminating in a production‑grade architecture that achieves near‑zero data loss.

GTIDMySQLParallel Replication
0 likes · 35 min read
From Crashing Databases to Zero Data Loss: MySQL Replication Evolution
Java Companion
Java Companion
Apr 17, 2026 · Backend Development

Resolving ID Conflicts After Sharding: 5 Practical Solutions

When sharding databases, independent auto‑increment IDs can collide; this article explains why the conflict occurs and evaluates five concrete solutions—UUID, MySQL auto‑increment step, segment allocation, Snowflake algorithm, and Meituan Leaf—detailing their mechanisms, trade‑offs, performance, and suitability.

Meituan LeafMySQLSnowflake
0 likes · 14 min read
Resolving ID Conflicts After Sharding: 5 Practical Solutions
Java Companion
Java Companion
Apr 16, 2026 · Databases

Is Running MySQL in Docker Really a Bad Idea?

This article dissects the common claim that MySQL should not be run in Docker by explaining the underlying design mismatch, measuring I/O overhead, examining persistence and resource‑isolation pitfalls, reviewing replication challenges, and presenting real‑world cases from JD and Tongcheng to show when containerization is safe and when it isn’t.

DockerMySQLPerformance
0 likes · 12 min read
Is Running MySQL in Docker Really a Bad Idea?
Black & White Path
Black & White Path
Apr 16, 2026 · Information Security

Bypassing Alibaba Cloud WAF on a Financial Site via MySQL Chain Comparison

During an authorized penetration test of a financial institution’s website protected by Alibaba Cloud WAF, the author discovered a SQL injection point, used MySQL’s chain‑comparison feature to close the injection, identified the database type, and crafted boolean‑based payloads—including POSITION and binary tricks—to extract the current user name character by character.

Alibaba Cloud WAFBoolean blind injectionMySQL
0 likes · 7 min read
Bypassing Alibaba Cloud WAF on a Financial Site via MySQL Chain Comparison
Architecture & Thinking
Architecture & Thinking
Apr 16, 2026 · Databases

Mastering Database Performance: From Slow Queries to Deadlock Resolution

This guide presents a systematic, end-to-end diagnostic workflow for high-concurrency database environments, covering slow-SQL detection, execution-plan analysis, lock-conflict monitoring, deadlock investigation, and practical optimization techniques, illustrated with real-world cases, commands, and tool integrations to swiftly resolve performance bottlenecks.

Database DiagnosticsLock MonitoringMySQL
0 likes · 18 min read
Mastering Database Performance: From Slow Queries to Deadlock Resolution
MaGe Linux Operations
MaGe Linux Operations
Apr 15, 2026 · Databases

Why MySQL Binary Logs Fill Up Disk Space and How to Fix It

This article explains how MySQL binary logs can rapidly consume disk space, analyzes the root causes such as log format and workload, provides step‑by‑step diagnostics, and offers practical cleanup, configuration, replication, monitoring, and recovery strategies to prevent and resolve the issue.

Binary LogMySQLPerformance
0 likes · 21 min read
Why MySQL Binary Logs Fill Up Disk Space and How to Fix It
Architect's Guide
Architect's Guide
Apr 14, 2026 · Databases

What Happens When MySQL Auto‑Increment IDs Reach Their Limits?

This article explains how MySQL handles auto‑increment primary keys, InnoDB internal row_id, Xid, trx_id, and thread_id when their numeric limits are reached, illustrating the resulting errors, data overwrites, and potential consistency bugs with practical SQL examples and verification steps.

InnoDBMySQLXid
0 likes · 13 min read
What Happens When MySQL Auto‑Increment IDs Reach Their Limits?
Coder Trainee
Coder Trainee
Apr 14, 2026 · Operations

5 Production Nightmares in an Education Mini‑Program and How to Avoid Them

The author recounts five critical production incidents that crippleed an education mini‑program—Redis connection‑pool exhaustion, duplicate bookings, double refunds, mis‑firing no‑show jobs, and inventory oversell—detailing root causes, concrete fixes, and hard‑won lessons for building resilient backend services.

MySQLOptimistic LockRedis
0 likes · 10 min read
5 Production Nightmares in an Education Mini‑Program and How to Avoid Them
MaGe Linux Operations
MaGe Linux Operations
Apr 11, 2026 · Databases

How to Diagnose and Fix MySQL “Too Many Connections” Errors

This guide explains why MySQL reports “Too many connections”, walks through emergency assessment steps, provides practical commands and scripts to stop the bleeding, analyzes root causes such as slow queries, connection leaks, short‑lived connections or low max_connections settings, and offers long‑term remediation and monitoring solutions for production environments.

LinuxMySQLToo many connections
0 likes · 40 min read
How to Diagnose and Fix MySQL “Too Many Connections” Errors
Ops Community
Ops Community
Apr 10, 2026 · Databases

How to Diagnose and Fix MySQL Too Many Connections Errors in Production

When MySQL reports 'Too many connections', this guide walks you through emergency assessment, step‑by‑step diagnostics, quick mitigation scripts, root‑cause analysis of slow queries, connection leaks, short‑connection spikes, and long‑term solutions including parameter tuning, connection‑pool configuration, and Prometheus‑based monitoring to prevent future outages.

AlertmanagerMySQLPrometheus
0 likes · 40 min read
How to Diagnose and Fix MySQL Too Many Connections Errors in Production
Cloud Architecture
Cloud Architecture
Apr 7, 2026 · Databases

MySQL Read‑Write Splitting: From Replication Basics to Production‑Ready Architecture

The article explains why simple SQL routing is insufficient for MySQL read‑write separation, details replication mechanisms, consistency challenges, and presents a comprehensive upgrade path—including static, dynamic, middleware, and hybrid routing strategies, configuration guidelines, monitoring, and high‑availability practices—to build a production‑grade, high‑concurrency architecture.

ArchitectureMySQLRead-Write Splitting
0 likes · 44 min read
MySQL Read‑Write Splitting: From Replication Basics to Production‑Ready Architecture
Cloud Architecture
Cloud Architecture
Apr 7, 2026 · Databases

Practical Guide to Safely Adding a Column to a Ten‑Million‑Row Order Table: Principles, Architecture, and Production Rollout

This article presents a production‑grade solution for adding a new promotion_type column to a tens‑of‑millions‑row order table, covering MySQL DDL risks, multiple migration strategies, a step‑by‑step implementation using a new table, CDC‑based incremental sync, back‑fill, verification, gray rollout, and rollback procedures.

BackfillCDCGray Deployment
0 likes · 38 min read
Practical Guide to Safely Adding a Column to a Ten‑Million‑Row Order Table: Principles, Architecture, and Production Rollout
Java Architect Handbook
Java Architect Handbook
Apr 7, 2026 · Databases

Master MySQL’s Redo, Undo, and Binlog: Deep Dive for Interview Success

This article provides a comprehensive interview guide on MySQL’s three core logs—redo log, undo log, and binlog—covering their architecture, roles in crash recovery, MVCC, replication, configuration commands, two‑phase commit workflow, and frequent follow‑up questions to help candidates ace database interview questions.

BinlogDatabase InterviewMySQL
0 likes · 13 min read
Master MySQL’s Redo, Undo, and Binlog: Deep Dive for Interview Success
java1234
java1234
Apr 7, 2026 · Databases

Why Choose PostgreSQL Over MySQL? A Technical Comparison of Their Strengths

The article analyzes why many Chinese cloud providers and enterprises prefer PostgreSQL to MySQL, detailing PostgreSQL's richer data types, native sequence support, extensible ecosystem, advanced monitoring, robust replication, open licensing, and MVCC implementation, while acknowledging MySQL's remaining advantages in specific scenarios.

LicensingMVCCMySQL
0 likes · 10 min read
Why Choose PostgreSQL Over MySQL? A Technical Comparison of Their Strengths
Java Architect Handbook
Java Architect Handbook
Apr 6, 2026 · Databases

Why MySQL Indexes Still Slow Queries and How to Fix Them

This guide explains the six common reasons why MySQL indexes may fail to improve query speed, shows how interviewers evaluate index knowledge, and provides concrete SQL examples, EXPLAIN analysis, and practical optimization techniques such as redesigning indexes, using covering indexes, avoiding implicit type conversion, and tuning database configuration.

Covering IndexData SkewDatabase Interview
0 likes · 15 min read
Why MySQL Indexes Still Slow Queries and How to Fix Them
MaGe Linux Operations
MaGe Linux Operations
Apr 5, 2026 · Databases

Master MySQL Slow Query Optimization: From Logs to Indexes

This comprehensive guide explains how to detect, analyze, and optimize MySQL slow queries by configuring the slow‑query log, using pt‑query‑digest, interpreting EXPLAIN output, designing effective B+Tree indexes, avoiding common index pitfalls, optimizing count(*) operations, improving deep pagination, rewriting inefficient SQL patterns, and applying advanced table design techniques such as partitioning and sharding.

EXPLAINMySQLSQL
0 likes · 40 min read
Master MySQL Slow Query Optimization: From Logs to Indexes
Top Architect
Top Architect
Apr 5, 2026 · Backend Development

Designing a Robust Asynchronous Processing SDK with Spring, Kafka and MySQL

This article explains the design, principles, components, database schema, configuration, and usage of a generic asynchronous processing SDK that leverages Spring AOP, transactional events, Kafka, and a Vue UI to achieve reliable async execution and eventual consistency in Java backend systems.

Design PatternsMySQLSDK
0 likes · 11 min read
Designing a Robust Asynchronous Processing SDK with Spring, Kafka and MySQL
Top Architect
Top Architect
Apr 3, 2026 · Backend Development

Why Did My Payment Service Lose Data? Uncovering Hidden Transaction Bugs in Spring

A mysterious payment failure where orders appeared successful but were never persisted was traced to a missing transaction commit in a special code path, leading to polluted connections that silently broke subsequent transactions, and the article explains the root cause, debugging steps, fix, and preventive measures.

MySQLSpringconnection pool
0 likes · 11 min read
Why Did My Payment Service Lose Data? Uncovering Hidden Transaction Bugs in Spring
Architect's Guide
Architect's Guide
Apr 3, 2026 · Databases

How to Diagnose and Solve MySQL Table Size Bottlenecks

This article explains how to assess MySQL table size using table capacity, disk usage, and instance limits, reveals why large tables slow down due to B+‑tree overhead, and presents three practical solutions—partitioning, sharding, and hot‑cold archiving—to restore query performance.

B+ TreeHot Cold ArchivingMySQL
0 likes · 17 min read
How to Diagnose and Solve MySQL Table Size Bottlenecks
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Apr 3, 2026 · Databases

10 Must‑Know MySQL Advanced Techniques to Supercharge Performance

This article presents ten practical MySQL advanced techniques—including EXPLAIN analysis, composite and covering indexes, index condition push‑down, prefix indexes, window functions, CTEs, JSON handling, partition tables, join optimizations, variables, online DDL, and generated columns—each illustrated with real‑world SQL examples and execution‑plan screenshots to boost efficiency in high‑volume, high‑concurrency environments.

Advanced SQLCTEIndex Optimization
0 likes · 16 min read
10 Must‑Know MySQL Advanced Techniques to Supercharge Performance
MaGe Linux Operations
MaGe Linux Operations
Apr 2, 2026 · Databases

Mastering MySQL 9.0 Replication: Deep Dive into GTID, Semi‑Sync, and Troubleshooting

This comprehensive guide explores MySQL 9.0's replication architecture, covering core principles, GTID and semi‑synchronous modes, various replication topologies, detailed troubleshooting steps, monitoring scripts, and best‑practice configurations, providing hands‑on examples and scripts to help engineers build and maintain robust, high‑availability database systems.

GTIDMySQLPerformance
0 likes · 34 min read
Mastering MySQL 9.0 Replication: Deep Dive into GTID, Semi‑Sync, and Troubleshooting