Skip to content
Tagged articles

MySQL

500 articles · Page 4 of 5
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.

MySQLSQLindexes
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.

IndexLATERALMySQL
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.

IndexInnoDBMySQL
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
Architect's Guide
Architect's Guide
May 9, 2026 · Databases

Alibaba’s Open‑Source DataX: Fast, Easy Offline Data Synchronization

This article introduces Alibaba’s open‑source DataX tool, explains its framework‑plugin architecture for heterogeneous database sync, walks through Linux installation, job configuration, full‑ and incremental MySQL synchronization, and shares performance results and practical tips.

DataXDatabase MigrationETL
0 likes · 15 min read
Alibaba’s Open‑Source DataX: Fast, Easy Offline Data Synchronization
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.

KafkaKubernetesMySQL
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.

MySQLPerformance Monitoringgh-ost
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.

Crash RecoveryInnoDBMySQL
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.

MVCCMySQLPostgreSQL
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.

MySQLOLAPSQL optimization
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.

CPUMySQLdatabase
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.

MyBatisMySQLORM
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 modeMySQLSaga
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.

DeadlockInnoDBMySQL
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.

MySQLlatencymonitoring
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.

DBeaverHeidiSQLMySQL
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* treeMySQLQuery Planning
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.

EXPLAINMySQLindex optimization
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.

MySQLPHPin
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.

CPUMySQLdatabase operations
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 PaginationMySQLgolang
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.

EXPLAINInnoDBMySQL
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 PartitioningMyBatisMySQL
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.

DockerMySQLbind mounts
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.

CPUMySQLdatabase
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.

ConcurrencyMySQLOptimisticLock
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.

MySQLRecoveryautomation
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.

GTIDHigh AvailabilityMySQL
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.

MySQLSnowflakeid-generation
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.

ContainerizationDockerMySQL
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 DiagnosticsDeadlockLock Monitoring
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 LogMySQLbackup
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.

IdempotencyMySQLOptimistic Lock
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.

AlertmanagerConnection LeakConnection Pool
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.

MySQLShardingSphereSpring Boot
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.

CDCGray DeploymentMySQL
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.

Database InterviewMySQLTwo-Phase Commit
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.

MVCCMySQLPostgreSQL
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.

Data SkewDatabase InterviewEXPLAIN
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.

Connection PoolDebuggingMySQL
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 SQLCTEJSON
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
Top Architect
Top Architect
Mar 30, 2026 · Backend Development

Why Upgrading to MyBatis‑Plus Breaks LocalDateTime Mapping and How to Fix It

A newcomer replaced MyBatis with MyBatis‑Plus in an old MySQL‑based project, triggering a "Conversion not supported for type java.time.LocalDateTime" error, which was traced to MyBatis 3.5.1 dropping built‑in type handling and an outdated mysql‑connector‑java, and resolved by upgrading the connector and adjusting validation logic.

ConnectorDebuggingJava
0 likes · 10 min read
Why Upgrading to MyBatis‑Plus Breaks LocalDateTime Mapping and How to Fix It
Golang Shines
Golang Shines
Mar 30, 2026 · Operations

Docker + MySQL: Why They Clash and How to Avoid Hair‑Pulling Pitfalls

This article analyzes common pitfalls when running MySQL inside Docker containers—such as data loss, resource exhaustion, insecure defaults, networking mishaps, and missing backups—and provides concrete, step‑by‑step remedies including volume persistence, resource limits, custom configs, security hardening, and automated backup strategies.

DockerMySQLbackup
0 likes · 11 min read
Docker + MySQL: Why They Clash and How to Avoid Hair‑Pulling Pitfalls
dbaplus Community
dbaplus Community
Mar 29, 2026 · Databases

Why MySQL’s ibtmp1 Swells to 192 GB and How to Stop It

A sudden disk‑usage alarm reveals MySQL’s ibtmp1 temporary tablespace ballooning to 192 GB, and the article walks through why it happens, how to safely clear it, set size limits, and pinpoint the inefficient SQL that caused the explosion.

MySQLSQL optimizationdisk usage
0 likes · 7 min read
Why MySQL’s ibtmp1 Swells to 192 GB and How to Stop It
Architect's Guide
Architect's Guide
Mar 29, 2026 · Databases

Why Top Chinese Tech Giants Choose PostgreSQL Over MySQL

Amid China's push for independent, cloud‑native databases, leading firms like Tencent, Alibaba, Huawei and others have built PostgreSQL‑based solutions, and this article analyzes why PostgreSQL’s richer data types, true sequence objects, extensible ecosystem, advanced replication and licensing advantages make it a preferred choice over MySQL.

MySQLPostgreSQLdatabase comparison
0 likes · 9 min read
Why Top Chinese Tech Giants Choose PostgreSQL Over MySQL
ITPUB
ITPUB
Mar 27, 2026 · Databases

AI’s Impact on Open‑Source Databases: MySQL, PostgreSQL, and AliSQL DuckDB

In 2026 the database ecosystem faces fierce competition between MySQL and PostgreSQL, while AI emerges as a new driver prompting open‑source projects like AliSQL to release DuckDB, vector engines and intelligent CLI, reshaping how relational databases serve both transactional and analytical workloads.

AIAliSQLDuckDB
0 likes · 15 min read
AI’s Impact on Open‑Source Databases: MySQL, PostgreSQL, and AliSQL DuckDB
dbaplus Community
dbaplus Community
Mar 26, 2026 · Databases

Six Fatal MySQL Index Traps and How to Avoid Them

A real‑world incident of soaring QPS reveals six common MySQL indexing pitfalls—type mismatches, function usage, left‑most prefix violations, implicit charset conversion, range query side effects, and optimizer mis‑selection—and provides concrete SQL fixes and verification tools to keep queries fast and reliable.

MySQLQuery PitfallsSQL
0 likes · 6 min read
Six Fatal MySQL Index Traps and How to Avoid Them
Senior Tony
Senior Tony
Mar 26, 2026 · Databases

Why MySQL Optimizer Picks the Wrong Index and How to Fix It

The MySQL optimizer can select an inappropriate index due to inaccurate statistics or sampling errors, but you can correct this by refreshing statistics with ANALYZE TABLE, increasing sample pages, or explicitly forcing the right index using the FORCE INDEX hint.

ANALYZE TABLEDatabase PerformanceIndex Selection
0 likes · 4 min read
Why MySQL Optimizer Picks the Wrong Index and How to Fix It
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 25, 2026 · Databases

How AliSQL AI Diagnoses and Eliminates MySQL Replication Lag

This article analyzes the severe replication‑delay issues in MySQL master‑slave setups, identifies four typical workload patterns that cause lag, demonstrates how AliSQL's AI assistant pinpoints the root causes, and explains the kernel‑level optimizations that completely remove the delay.

AI diagnosisAliSQLMySQL
0 likes · 13 min read
How AliSQL AI Diagnoses and Eliminates MySQL Replication Lag
Code Wrench
Code Wrench
Mar 23, 2026 · Databases

Why Your MySQL Queries Slow Down in Production and How to Fix Them

The article explains why locally fast MySQL queries can become painfully slow in production, identifies three common pitfalls such as ineffective indexes, oversized Go connection pools, and hidden type conversions, and provides concrete optimization techniques spanning index design, query planning, Go‑MySQL integration, and systematic self‑checks.

GoMySQLindexing
0 likes · 9 min read
Why Your MySQL Queries Slow Down in Production and How to Fix Them
Java Architect Essentials
Java Architect Essentials
Mar 23, 2026 · Databases

When MySQL Auto‑Increment Hits Its Limit: Diagnosis and Fixes

A backend engineer discovers that a massive MySQL table’s auto‑increment INT primary key reached its maximum value, causing insert failures, and walks through detailed analysis, three remediation options—including switching to BIGINT, redesigning IDs, and sharding—plus practical scripts, performance measurements, and lessons learned about concurrency and schema design.

BIGINTConcurrencyDatabase Migration
0 likes · 10 min read
When MySQL Auto‑Increment Hits Its Limit: Diagnosis and Fixes
Top Architect
Top Architect
Mar 22, 2026 · Databases

How to Enable Read/Write Splitting with MySQL Router 8.2 and InnoDB ReplicaSet

Discover how to set up MySQL InnoDB ReplicaSet and configure MySQL Router 8.2 for automatic read/write splitting, enabling reads to be routed to replicas and writes to the primary without code changes, complete with step-by-step commands, configuration snippets, and visual verification.

Database PerformanceInnoDB ReplicaSetMySQL
0 likes · 6 min read
How to Enable Read/Write Splitting with MySQL Router 8.2 and InnoDB ReplicaSet
JD Tech Talk
JD Tech Talk
Mar 18, 2026 · Databases

Mastering Dynamic JSON Fields in MySQL: Real‑World Cases and Pitfalls

This article explains how to store and query extensible JSON columns in a MySQL‑based system, lists the most useful JSON functions, walks through several real‑world scenarios—including dynamic extension queries and weight‑management cases—identifies subtle bugs caused by null values, and presents step‑by‑step SQL and MyBatis fixes to ensure reliable batch updates.

DebuggingDynamicFieldsJSON
0 likes · 15 min read
Mastering Dynamic JSON Fields in MySQL: Real‑World Cases and Pitfalls
Coder Trainee
Coder Trainee
Mar 18, 2026 · Operations

How to Persist Zipkin Traces to MySQL or Elasticsearch

This guide explains why Zipkin loses trace data after a restart when using the default in‑memory storage and provides step‑by‑step instructions to configure persistent storage with MySQL or Elasticsearch, including database setup, SQL schema, startup commands, and verification.

ElasticsearchMySQLPersistence
0 likes · 7 min read
How to Persist Zipkin Traces to MySQL or Elasticsearch
Architecture & Thinking
Architecture & Thinking
Mar 18, 2026 · Databases

10 Common MySQL Index Failure Scenarios and How to Fix Them

Even well‑designed indexes can become ineffective in production, leading to full‑table scans; this article systematically examines ten typical MySQL index‑failure cases—ranging from functions on indexed columns to low selectivity—and provides concrete SQL rewrites, performance comparisons, and diagnostic tools to help developers avoid and resolve these issues.

IndexMySQLSQL
0 likes · 17 min read
10 Common MySQL Index Failure Scenarios and How to Fix Them
dbaplus Community
dbaplus Community
Mar 15, 2026 · Databases

Why MySQL Is Falling Behind PostgreSQL: Commit Trends and Oracle’s Role

The article examines the sharp decline in MySQL’s commit activity since its 2006‑2007 peak, compares recent DB‑Engines rankings that show PostgreSQL overtaking MySQL, and attributes the downturn to Oracle’s management practices, technical setbacks, reduced open‑source community engagement, and a shift toward proprietary alternatives.

Database TrendsMySQLOracle
0 likes · 7 min read
Why MySQL Is Falling Behind PostgreSQL: Commit Trends and Oracle’s Role
Java Tech Enthusiast
Java Tech Enthusiast
Mar 13, 2026 · Databases

When Does SELECT * Break Your MySQL Index? A Deep Dive into Index Invalidation

This article explains why using SELECT * does not automatically invalidate MySQL indexes, explores common scenarios that cause index loss such as left‑most prefix violations, function calls, implicit type conversions, wildcard LIKE patterns, OR/IN/NOT IN misuse, and ORDER BY pitfalls, and provides practical optimization recommendations with concrete SQL examples and verification methods.

IndexMySQLQuery Tuning
0 likes · 14 min read
When Does SELECT * Break Your MySQL Index? A Deep Dive into Index Invalidation
Architecture & Thinking
Architecture & Thinking
Mar 13, 2026 · Databases

Why MySQL Deep Pagination Slows Down Your E‑commerce Site and How to Fix It

The article explains how deep pagination on massive MySQL tables causes full‑table scans, massive I/O, and memory pressure, then presents six concrete optimization techniques—including delayed join, cursor pagination, covering indexes, ID‑range pagination, caching, and partitioning—backed by a real‑world e‑commerce case study and detailed execution‑plan analysis.

Deep PaginationMySQLPerformance Optimization
0 likes · 18 min read
Why MySQL Deep Pagination Slows Down Your E‑commerce Site and How to Fix It
macrozheng
macrozheng
Mar 12, 2026 · Operations

How to Deploy Apps Visually with Dockge – A Docker Compose GUI Guide

This guide introduces Dockge, a sleek Docker Compose visual manager, and walks through installing it via Docker, creating stacks, and deploying a Spring Boot and MySQL application with one‑click operations, including logs, terminal access, and API testing.

DevOpsDockerDockge
0 likes · 5 min read
How to Deploy Apps Visually with Dockge – A Docker Compose GUI Guide
Black & White Path
Black & White Path
Mar 11, 2026 · Information Security

ByPassTamperPlus: Enhanced SQLMap Tamper Scripts for Advanced WAF Bypass

ByPassTamperPlus is a Python‑based collection of SQLMap tamper scripts tailored for MSSQL, MySQL and Oracle across multiple versions, employing version‑specific syntax, functions and obfuscation techniques to improve payload survivability against modern Web Application Firewalls, while acknowledging inherent limitations.

MSSQLMySQLOracle
0 likes · 6 min read
ByPassTamperPlus: Enhanced SQLMap Tamper Scripts for Advanced WAF Bypass