Skip to content
Tagged articles

MySQL

500 articles · Page 3 of 5
ITPUB
ITPUB
Jul 15, 2026 · Databases

Is count(*) Really the Slowest? MySQL Count Performance Explained

The article analyzes how MySQL executes different COUNT() forms—count(*), count(1), count(primary‑key), and count(column)—showing that count(*) and count(1) have identical performance, count(column) is the slowest, and offers indexing and approximation tips for large tables.

COUNTIndexInnoDB
0 likes · 10 min read
Is count(*) Really the Slowest? MySQL Count Performance Explained
Java Tech Workshop
Java Tech Workshop
Jul 15, 2026 · Backend Development

Generating Trillions of Unique Order IDs Without Collisions

The article analyzes why simple auto‑increment or timestamp‑based IDs fail at massive scales, compares common distributed ID schemes, and presents an improved Snowflake‑plus‑segment hybrid solution with clock‑rollback protection, automatic machine/room allocation, and production‑grade safeguards for trillion‑level order processing.

JavaMySQLSnowflake
0 likes · 19 min read
Generating Trillions of Unique Order IDs Without Collisions
Xiaolin Talks Programming
Xiaolin Talks Programming
Jul 15, 2026 · Backend Development

HikariCP Deep Tuning: Leak Detection, Parameter Optimization & Slow SQL Defense in Spring Boot

A production incident where core API latency spiked from 50ms to 30s+ due to connection leaks and exhausted MySQL max_connections is dissected, revealing how default HikariCP settings become time bombs under load and how to build a defense system with leak detection, parameter tuning, slow SQL interception, and kill mechanisms.

Connection PoolHikariCPMySQL
0 likes · 18 min read
HikariCP Deep Tuning: Leak Detection, Parameter Optimization & Slow SQL Defense in Spring Boot
MaGe Linux Operations
MaGe Linux Operations
Jul 14, 2026 · Databases

Common MySQL Connection Errors and Step‑by‑Step Troubleshooting Guide

MySQL connection failures are among the most frequent issues for developers and operators; this article systematically walks through typical error messages, explains how to collect relevant information, runs layered command checks, analyzes evidence, identifies root causes such as socket problems, bind‑address limits, host whitelist mismatches, authentication failures, connection‑limit exhaustion, and packet timeouts, and provides concrete fix and verification procedures for on‑premise, Docker, and Kubernetes deployments.

DockerKubernetesLinux
0 likes · 25 min read
Common MySQL Connection Errors and Step‑by‑Step Troubleshooting Guide
21CTO
21CTO
Jul 13, 2026 · Databases

How to Disable MySQL Binary Logging to Free Disk Space

The article explains why excessive MySQL binary logs filled a CentOS server’s disk, walks through cleaning unrelated logs, shows how to inspect and purge the binlog files, and provides the exact my.cnf changes needed to permanently disable binary logging.

CentOSLaravelMySQL
0 likes · 7 min read
How to Disable MySQL Binary Logging to Free Disk Space
Cloud Architecture
Cloud Architecture
Jul 12, 2026 · Databases

Database Performance Optimization: 100× Speed Gains Without Changing SQL

Even without rewriting any SQL, database performance can improve up to a hundredfold by first diagnosing bottlenecks, reducing unnecessary traffic, layering read paths, optimizing indexes, tuning connection pools, and progressively evolving from a single‑node setup to read‑write separation, sharding, and distributed read models.

Connection PoolMySQLPerformance Optimization
0 likes · 38 min read
Database Performance Optimization: 100× Speed Gains Without Changing SQL
Ops Community
Ops Community
Jul 12, 2026 · Databases

Which MySQL Files Can Be Safely Deleted When Disk Space Is Low?

When MySQL runs out of disk space, the safest approach is to identify the full filesystem, examine data, binlog, temporary and log directories, and use SQL‑based cleanup commands like PURGE BINARY LOGS while never manually removing critical files such as ibdata1, ib_logfile* or active binlogs.

InnoDBMySQLbackup
0 likes · 16 min read
Which MySQL Files Can Be Safely Deleted When Disk Space Is Low?
Cloud Architecture
Cloud Architecture
Jul 8, 2026 · Backend Development

High‑Concurrency Order System Architecture: How Redis, MySQL, and Elasticsearch Collaborate Without Overstepping

This article presents a production‑grade, high‑concurrency order system design that separates responsibilities among Redis for traffic control, MySQL as the single source of truth, Kafka for event propagation, and Elasticsearch for search, while detailing state‑machine modeling, outbox patterns, seckill flow, and comprehensive observability and deployment practices.

ElasticsearchMySQLOutbox
0 likes · 31 min read
High‑Concurrency Order System Architecture: How Redis, MySQL, and Elasticsearch Collaborate Without Overstepping
ITPUB
ITPUB
Jul 8, 2026 · Databases

MySQL 26.7 EA Arrives: Calendar Versioning Jumps to 26 and Community Edition Evolves

MySQL 26.7.0 Early Access introduces calendar versioning that jumps the version number to 26, adds post‑quantum TLS support, a new Change Stream Applier, InnoDB refactoring, and moves the thread‑pool plugin to the community edition, while Oracle expands governance with a steering committee, a public roadmap, and a detailed release schedule for 2026‑2027.

Calendar VersioningChange Stream ApplierDatabase Governance
0 likes · 16 min read
MySQL 26.7 EA Arrives: Calendar Versioning Jumps to 26 and Community Edition Evolves
YiSu Grain
YiSu Grain
Jul 8, 2026 · Databases

Why a Transfer Can’t Just Deduct Money – A Simple Guide to ACID Transactions

The article uses a simple money‑transfer scenario to introduce database transactions, explains the four ACID properties, illustrates common concurrency anomalies such as dirty reads, non‑repeatable reads and phantom reads, and outlines the four isolation levels with their trade‑offs and default settings in MySQL and Oracle.

ACIDMySQLconcurrency control
0 likes · 8 min read
Why a Transfer Can’t Just Deduct Money – A Simple Guide to ACID Transactions
YiSu Grain
YiSu Grain
Jul 7, 2026 · Databases

Why Databases Skip the First Page: How Indexes Speed Up Queries

The article explains how database indexes act like a book's table of contents, reducing full‑table scans and disk I/O by using B+Tree structures, and compares clustered, non‑clustered, and covering indexes while highlighting their benefits and trade‑offs.

B* treeDatabase PerformanceIndex
0 likes · 11 min read
Why Databases Skip the First Page: How Indexes Speed Up Queries
Cloud Architecture
Cloud Architecture
Jul 7, 2026 · Databases

MySQL User & Permission Management: From Grant Statements to Production-Grade Security Architecture

This comprehensive guide explains why MySQL permission mistakes happen, walks through the authentication and authorization process, shows how to design multi‑layered user models, role hierarchies, declarative GitOps workflows, Kubernetes integration, and production‑ready automation for secure, auditable, and scalable database access.

GitOpsKubernetesMySQL
0 likes · 42 min read
MySQL User & Permission Management: From Grant Statements to Production-Grade Security Architecture
Cloud Architecture
Cloud Architecture
Jul 6, 2026 · Backend Development

Designing a High‑Concurrency Coupon Expiration System with Task Tables and Batch Processing

The article explains why coupon expiration cannot be handled by a simple scheduled scan and presents a production‑grade architecture that uses a task‑table, four‑plane design, fine‑grained splitting, lease‑based worker coordination, idempotent updates, and observability to reliably expire billions of coupons under peak load.

Batch ProcessingConcurrencyMySQL
0 likes · 37 min read
Designing a High‑Concurrency Coupon Expiration System with Task Tables and Batch Processing

Midnight Deployment Crash? One-Click Backup & Rollback Scripts for Code and Database

This article provides ready-to-use Bash scripts for automated backup and interactive rollback of application code and MySQL databases on traditional servers, featuring timestamped versions, automatic cleanup, pre-rollback safety snapshots, and a real-world case study achieving rollback in under three minutes.

DevOpsMySQLOperations
0 likes · 15 min read
Midnight Deployment Crash? One-Click Backup & Rollback Scripts for Code and Database
MaGe Linux Operations
MaGe Linux Operations
Jul 5, 2026 · Databases

Why MySQL Connections Spike: When Traffic Isn’t the Real Culprit

This article walks through a systematic, step‑by‑step troubleshooting guide for MySQL "Too many connections" errors, showing how to verify the symptom, inspect server variables, analyze connection status, identify common root causes such as connection‑pool misconfiguration, leaked connections, and long‑running queries, and apply safe fixes and preventive measures.

Connection PoolMySQLdatabase
0 likes · 35 min read
Why MySQL Connections Spike: When Traffic Isn’t the Real Culprit
java1234
java1234
Jul 4, 2026 · Mobile Development

Building a WeChat Mini‑Program Health Management System with AI in 20 Minutes (Spring AI 2.0 + Spring Boot 4 + Vue 3)

In just 20 minutes, the author uses Cursor AI to generate a full‑stack WeChat mini‑program for personal health management, featuring an AI‑driven health consultant, a Spring Boot 4 backend with JWT security, MySQL storage, and a Vue 3 admin console, and explains the architecture, routing, and deployment details.

AI chatbotJWTMySQL
0 likes · 10 min read
Building a WeChat Mini‑Program Health Management System with AI in 20 Minutes (Spring AI 2.0 + Spring Boot 4 + Vue 3)
Linux Tech Enthusiast
Linux Tech Enthusiast
Jul 4, 2026 · Databases

Four MySQL Scripts for Diagnosing and Optimizing Your Queries

This article introduces four command‑line tools—MySQLTuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explaining how to download, run them, and interpret their reports to assess MySQL performance, configuration, and query efficiency.

MySQLSQL optimizationmysqltuner
0 likes · 8 min read
Four MySQL Scripts for Diagnosing and Optimizing Your Queries
samdeepthink
samdeepthink
Jul 3, 2026 · Databases

MySQL Index Interview Guide: From B+ Trees to Index Design

This article explains MySQL index fundamentals—from the B+‑tree storage engine and InnoDB’s clustered and secondary indexes to query execution, common index‑failure scenarios, and practical design principles for building effective indexes in interview settings.

B* treeEXPLAINIndex
0 likes · 25 min read
MySQL Index Interview Guide: From B+ Trees to Index Design
Cloud Architecture
Cloud Architecture
Jul 2, 2026 · Databases

MySQL Containerization vs Host Installation: Production‑Grade Selection Framework

The article explains that the real challenge is not merely running MySQL but placing it in the right resource model, and it provides a four‑dimensional decision framework—performance ceiling, stability floor, automation level, and organizational maturity—to guide when to use host‑installed MySQL, single‑node containers, or full Kubernetes deployment, illustrated with concrete resource analyses, architecture diagrams, configuration examples, pitfalls, checklists, and an evolution roadmap.

Best PracticesContainerizationHigh Availability
0 likes · 35 min read
MySQL Containerization vs Host Installation: Production‑Grade Selection Framework
Xiaolin Talks Programming
Xiaolin Talks Programming
Jun 30, 2026 · Databases

Zero-Downtime Database Evolution: Flyway + Spring Boot Expand/Migrate/Contract Pattern

This article details a production-verified zero-downtime database migration strategy using Spring Boot and Flyway, covering why DDL causes outages, Flyway configuration best practices, the expand-migrate-contract pattern for smooth schema changes, script writing and rollback techniques, Kubernetes deployment coordination, monitoring with circuit breakers, and a post-mortem checklist.

DDLDatabase MigrationFlyway
0 likes · 18 min read
Zero-Downtime Database Evolution: Flyway + Spring Boot Expand/Migrate/Contract Pattern
Cloud Architecture
Cloud Architecture
Jun 29, 2026 · Databases

Deep Guide to MySQL Index Failure: From Core Mechanics to High‑Concurrency Production Practices

This comprehensive guide explains why seemingly indexed MySQL queries can still cause severe latency spikes in high‑traffic systems, explores the underlying InnoDB structures and optimizer cost model, enumerates twelve common failure patterns with concrete SQL examples, and provides a production‑grade methodology for diagnosing, engineering, and automating index governance.

InnoDBMySQLhigh concurrency
0 likes · 39 min read
Deep Guide to MySQL Index Failure: From Core Mechanics to High‑Concurrency Production Practices
Java Architect Handbook
Java Architect Handbook
Jun 29, 2026 · Databases

Three Free Tools That Seamlessly Replace Navicat

If you need a cost‑free replacement for Navicat, this article compares three MySQL client tools—DBeaver, MySQL Workbench, and HeidiSQL—detailing their installation steps, supported databases, key features such as monitoring and ER diagrams, and practical usage tips.

DBeaverHeidiSQLMySQL
0 likes · 6 min read
Three Free Tools That Seamlessly Replace Navicat
Raymond Ops
Raymond Ops
Jun 28, 2026 · Databases

Comprehensive MySQL Replication Lag Troubleshooting Beyond Seconds_Behind_Master

This guide walks through a complete MySQL master‑slave lag diagnosis process, explaining why relying solely on Seconds_Behind_Master is insufficient and showing how to separate IO and SQL thread issues, examine relay logs, detect long transactions, DDL locks, and apply best‑practice configurations and monitoring.

LAGMySQLbackup
0 likes · 17 min read
Comprehensive MySQL Replication Lag Troubleshooting Beyond Seconds_Behind_Master
Ops Community
Ops Community
Jun 27, 2026 · Databases

MySQL Replication Lag Too High? 3 Quick Solutions to Restore Sync

The article explains why MySQL master‑slave replication lag occurs, lists common causes, provides a five‑level troubleshooting framework, and offers three concrete recovery methods—from emergency error skipping to multi‑threaded replication and long‑term architecture improvements—plus commands, configurations, and monitoring tips.

GTIDMTSMySQL
0 likes · 27 min read
MySQL Replication Lag Too High? 3 Quick Solutions to Restore Sync
macrozheng
macrozheng
Jun 27, 2026 · Backend Development

Boost IntelliJ IDEA Performance: 10 Simple Tweaks to Eliminate Lag

This article lists ten common IntelliJ IDEA pitfalls—slow performance, Lombok errors, broken breakpoints, encoding issues, unwanted Git files, Maven download slowness, class‑not‑found errors, broken shortcuts, MySQL timezone problems, and automatic reformatting—plus step‑by‑step solutions to make the IDE run smoothly for Java developers.

DebuggingGitIDE performance
0 likes · 25 min read
Boost IntelliJ IDEA Performance: 10 Simple Tweaks to Eliminate Lag
Raymond Ops
Raymond Ops
Jun 26, 2026 · Databases

Master MySQL Performance: Full Process for Slow Query Analysis and Index Tuning

This guide walks through MySQL performance troubleshooting—from enabling and analyzing slow‑query logs with pt‑query‑digest, interpreting EXPLAIN plans, designing covering and composite indexes, tuning InnoDB buffer pool and connection settings, to best‑practice recommendations and real‑world case validation.

Buffer PoolEXPLAINMySQL
0 likes · 27 min read
Master MySQL Performance: Full Process for Slow Query Analysis and Index Tuning
IoT Full-Stack Technology
IoT Full-Stack Technology
Jun 26, 2026 · Databases

Are You Still Using These 8 Inefficient SQL Patterns?

This article examines eight common SQL pitfalls—including misuse of LIMIT offsets, implicit type conversion, sub‑query updates, mixed ordering, EXISTS clauses, condition push‑down, early limiting, and intermediate result set handling—showing how each can degrade performance and providing rewritten queries with execution‑plan evidence that dramatically improve speed.

MySQLSQLexecution plan
0 likes · 12 min read
Are You Still Using These 8 Inefficient SQL Patterns?
samdeepthink
samdeepthink
Jun 25, 2026 · Databases

How Many Locks Does a Single UPDATE Acquire in MySQL 8.0?

An UPDATE in MySQL 8.0 acquires three distinct locks—a server‑level metadata lock, an InnoDB intention exclusive lock (IX), and a row‑level exclusive lock—so understanding the three‑layer lock architecture (metadata, intention, row) helps both interview preparation and troubleshooting.

InnoDBIntention LockLocks
0 likes · 14 min read
How Many Locks Does a Single UPDATE Acquire in MySQL 8.0?
samdeepthink
samdeepthink
Jun 25, 2026 · Databases

How Much SQL Do You Really Need to Master for Real‑World Development?

The author argues that in most companies you only need to write simple, single‑table or limited‑join queries and focus on index tuning and basic MySQL concepts such as InnoDB, locks, and execution flow, while complex SQL work often signals a poorly organized team.

Database PerformanceMySQLSQL
0 likes · 3 min read
How Much SQL Do You Really Need to Master for Real‑World Development?
Programmer XiaoFu
Programmer XiaoFu
Jun 25, 2026 · Backend Development

Why Delayed Double Delete Fails to Ensure Cache Consistency Under High Concurrency

The article dissects the delayed double‑delete pattern for Redis‑MySQL consistency, exposing its hidden pitfalls—unreliable delay timing, thread‑blocking sleeps, fragile second‑delete retries, and concurrent‑write anomalies—then recommends cache‑aside and stronger alternatives for production systems.

Cache AsideCache ConsistencyConcurrency
0 likes · 7 min read
Why Delayed Double Delete Fails to Ensure Cache Consistency Under High Concurrency
Golang Shines
Golang Shines
Jun 24, 2026 · Backend Development

Explore the Open-Source Go-Vue-Admin Backend Management System

The article introduces go-vue-admin, an open-source Go-based backend management system with a Vue3 front‑end, outlines its built‑in modules such as user, role, and monitoring, lists environment requirements and repository links, provides step‑by‑step setup commands, and offers a curated collection of free Go books and video tutorials.

Backend ManagementGoMySQL
0 likes · 8 min read
Explore the Open-Source Go-Vue-Admin Backend Management System
Code Farming
Code Farming
Jun 24, 2026 · Databases

MySQL Indexes: Master B+Tree Fundamentals to Nail Interview Questions

The article breaks down MySQL index mechanics into four visual sections, explaining B+Tree structure, why it outperforms B‑tree, hash and binary trees, common index‑failure scenarios, and three practical optimization techniques, giving interviewees a clear framework to answer index‑related questions confidently.

B* treeDatabase PerformanceMySQL
0 likes · 7 min read
MySQL Indexes: Master B+Tree Fundamentals to Nail Interview Questions
Shepherd Advanced Notes
Shepherd Advanced Notes
Jun 24, 2026 · Backend Development

Boosting Throughput 10×: Architecture Evolution and Tuning for High‑Concurrency Batch Processing

The article details how a sluggish batch‑processing system handling millions of records was redesigned with XXL‑JOB sharding, Redis‑based dynamic task distribution, cursor pagination, and selective transaction scopes, achieving nearly ten‑fold throughput improvement while addressing resource contention, load‑balancing, and reliable result reconciliation.

Batch ProcessingJavaMySQL
0 likes · 19 min read
Boosting Throughput 10×: Architecture Evolution and Tuning for High‑Concurrency Batch Processing
ITPUB
ITPUB
Jun 22, 2026 · Databases

How an Unindexed UPDATE Can Lock Your Whole MySQL Table and Crash Production

The article explains how an UPDATE without an indexed WHERE clause triggers InnoDB’s next‑key locks, effectively locking the entire table, shows transaction examples that cause blocking, and recommends enabling sql_safe_updates or using FORCE INDEX to ensure the statement uses an index scan.

InnoDBMySQLUpdate
0 likes · 8 min read
How an Unindexed UPDATE Can Lock Your Whole MySQL Table and Crash Production
Ops Community
Ops Community
Jun 22, 2026 · Databases

Backup and Recovery: mysqldump / xtrabackup with Point‑In‑Time Recovery

This guide walks through practical MySQL backup and point‑in‑time recovery strategies using logical dumps with mysqldump and physical copies with Percona XtraBackup, covering configuration, command‑line examples, binlog handling, GTID/LSN concepts, incremental backups, restoration scripts, verification steps and common pitfalls for DBAs and DevOps engineers.

MySQLOperationsRecovery
0 likes · 44 min read
Backup and Recovery: mysqldump / xtrabackup with Point‑In‑Time Recovery
samdeepthink
samdeepthink
Jun 22, 2026 · Databases

How to Handle 30,000 Writes per Second with Oracle, Java, and Spring

The article analyzes the write bottleneck of processing 30,000 payment orders per second on an Oracle‑Java‑Spring stack, explains why sharding was used historically, why MQ‑based peak‑shaving is discouraged, and compares self‑built sharding with modern distributed databases such as PolarDB‑X, TiDB and OceanBase, while summarizing public practices from major Chinese tech firms.

MySQLOceanBaseOracle
0 likes · 13 min read
How to Handle 30,000 Writes per Second with Oracle, Java, and Spring
Code Farming
Code Farming
Jun 22, 2026 · Backend Development

Why Your Distributed Lock Keeps Failing in Production (And How to Fix It)

This article explains the three fundamental challenges of distributed locks—availability, deadlock, and split‑brain—compares database and Redis implementations, walks through the five evolutionary steps of Redis locking, and provides a structured interview answer framework to demonstrate deep understanding.

ConcurrencyMySQLRedis
0 likes · 8 min read
Why Your Distributed Lock Keeps Failing in Production (And How to Fix It)
AI Agent Super App
AI Agent Super App
Jun 20, 2026 · Operations

Complete LNMP Guide: Deploy WordPress and Forums Step‑by‑Step

This guide walks you through installing a full LNMP stack on CentOS or Ubuntu, configuring Nginx, MySQL, and PHP, deploying WordPress with essential plugins and security hardening, and setting up popular forums such as phpBB, Flarum, and Discourse, followed by performance tuning tips.

ForumLNMPMySQL
0 likes · 21 min read
Complete LNMP Guide: Deploy WordPress and Forums Step‑by‑Step
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Jun 18, 2026 · Databases

How Much Concurrency Can MySQL Handle? A Practical Breakdown

MySQL’s concurrency capacity isn’t a single number; it’s measured by QPS and TPS and varies with query complexity, indexing, transaction design, and hardware, with simple indexed reads reaching several thousand QPS on a well‑tuned server, while mixed or complex workloads often cap around one to two thousand QPS.

ConcurrencyDatabase PerformanceMySQL
0 likes · 3 min read
How Much Concurrency Can MySQL Handle? A Practical Breakdown
liandk
liandk
Jun 17, 2026 · Databases

How to Deploy MySQL 8.0 in Docker on veLinux2 – Step‑by‑Step Guide

This guide walks through deploying MySQL 8.0 in a Docker container on veLinux 2, covering environment requirements, configuring a domestic Docker mirror, pulling the image, running the container with persistence and remote‑access settings, opening firewall ports, granting remote root privileges, and verifying the service.

DockerLinuxMySQL
0 likes · 5 min read
How to Deploy MySQL 8.0 in Docker on veLinux2 – Step‑by‑Step Guide
Architect's Guide
Architect's Guide
Jun 16, 2026 · Backend Development

How to Insert 300,000 Records in 13 Seconds with MyBatis and JDBC

The article compares several ways of inserting 300,000 MySQL rows—single‑row loops, an un‑batched MyBatis attempt that hits the max_allowed_packet limit, and a tuned batch strategy that commits every 1,000 rows—showing how the optimized batch reduces the runtime from hours to just 13 seconds and summarizing best‑practice tips.

JDBCJavaMyBatis
0 likes · 13 min read
How to Insert 300,000 Records in 13 Seconds with MyBatis and JDBC
Architect's Guide
Architect's Guide
Jun 15, 2026 · Databases

Chat2DB Review: Alibaba’s Open‑Source Multi‑Database Client with AI‑Driven SQL Features

Chat2DB is a free open‑source multi‑database client that adds AI capabilities such as natural‑language‑to‑SQL, SQL‑to‑natural‑language, and performance suggestions; this guide walks through downloading, installing, configuring OpenAI keys, using its four main menus, and evaluating its SQL generation, explanation, and optimization functions.

AIChat2DBMySQL
0 likes · 11 min read
Chat2DB Review: Alibaba’s Open‑Source Multi‑Database Client with AI‑Driven SQL Features
Architect Chen
Architect Chen
Jun 12, 2026 · Databases

How to Prevent MySQL Deadlocks in High‑Concurrency Apps: 5 Proven Solutions

The article defines MySQL deadlocks, illustrates how circular lock waits between transactions cause them, and presents five practical mitigation techniques—consistent lock ordering, shortening transactions, optimizing indexes, breaking large SQL statements into smaller batches, and implementing application‑level retry logic—to reduce deadlock occurrences in high‑concurrency environments.

ConcurrencyDeadlockMySQL
0 likes · 5 min read
How to Prevent MySQL Deadlocks in High‑Concurrency Apps: 5 Proven Solutions
Cloud Architecture
Cloud Architecture
Jun 11, 2026 · Databases

MySQL Deadlock Elimination: 9 Golden Rules and Production‑Ready Defense

Deadlocks in MySQL are not random glitches but the inevitable result of uncontrolled concurrency, lock granularity, transaction boundaries, and resource ordering; this article explains the underlying lock mechanisms, common deadlock scenarios, and presents nine practical, production‑grade rules for architecture design, lock management, and observability to keep deadlocks within acceptable SLA limits.

DeadlockInnoDBMySQL
0 likes · 31 min read
MySQL Deadlock Elimination: 9 Golden Rules and Production‑Ready Defense
Top Architect
Top Architect
Jun 11, 2026 · Backend Development

How to Speed Up Large-Scale Queries with MyBatisPlus

The article analyzes why conventional MyBatisPlus queries become slow and memory‑intensive when handling millions of rows, then demonstrates three alternatives—regular pagination, stream query, and cursor query—showing their implementation, trade‑offs, and practical tips for avoiding OOM and improving performance.

CursorJavaLarge Data
0 likes · 10 min read
How to Speed Up Large-Scale Queries with MyBatisPlus
Xiao Liu Lab
Xiao Liu Lab
Jun 11, 2026 · Operations

Ops Engineer Core Skills: From Basic Commands to High‑Availability Architecture

This article provides a comprehensive roadmap for operations engineers, covering essential Linux commands, core system concepts, service principles, fault‑diagnosis methods, high‑availability architecture designs, data security, backup strategies, performance tuning, and automation scripts to handle both single‑machine and large‑scale cluster environments.

DockerHigh AvailabilityKubernetes
0 likes · 13 min read
Ops Engineer Core Skills: From Basic Commands to High‑Availability Architecture
Architect Chen
Architect Chen
Jun 10, 2026 · Databases

12 Essential MySQL Online Commands Every DBA Should Know

This guide lists the most frequently used MySQL commands for checking version, connections, process lists, killing queries, global status, configuration variables, lock waits, slow‑query settings, table sizes, index information, execution plans, and replication status, each with practical usage scenarios.

DBAMySQLPerformance Monitoring
0 likes · 5 min read
12 Essential MySQL Online Commands Every DBA Should Know
Ops Community
Ops Community
Jun 8, 2026 · Databases

Comparing MySQL Backup Solutions: From Tool Mechanics to Production-Ready Engineering Guide

This article analyzes common MySQL backup pitfalls, explains the three backup dimensions and five types, compares major tools such as mysqldump, mysqlpump, mydumper, XtraBackup and cloud snapshots, and provides practical scripts, sizing recommendations, scheduling, monitoring, recovery procedures, and failure case studies for reliable production backup engineering.

MyDumperMySQLRecovery
0 likes · 52 min read
Comparing MySQL Backup Solutions: From Tool Mechanics to Production-Ready Engineering Guide
Java Tech Workshop
Java Tech Workshop
Jun 8, 2026 · Databases

Advanced SpringBoot Read‑Write Splitting: Master‑Slave Switching and Automatic Failover

In high‑concurrency internet architectures, a MySQL master‑slave setup with read‑write splitting is the baseline for high availability, but static routing suffers from node failures and lag; this article explains how ShardingSphere provides health checks, auto‑failover, load‑balancing, and degradation to achieve resilient read‑write separation.

High AvailabilityMySQLShardingSphere
0 likes · 14 min read
Advanced SpringBoot Read‑Write Splitting: Master‑Slave Switching and Automatic Failover
The Dominant Programmer
The Dominant Programmer
Jun 6, 2026 · Backend Development

Business Trace Logging Design Pattern: From Theory to Practice

The article explains a structured business‑trace logging pattern that records each critical step of a workflow as a node, stores logs in a dedicated MySQL database, aggregates them by a business number, and presents them in a sortable, color‑coded front‑end for both developers and business users.

Asynchronous MessagingJavaMySQL
0 likes · 15 min read
Business Trace Logging Design Pattern: From Theory to Practice
Top Architect
Top Architect
Jun 5, 2026 · Databases

Eliminate LIKE% in MySQL: Use Full‑Text Search for Efficient Fuzzy Queries

This article explains why using LIKE% for fuzzy searches in MySQL is inefficient, introduces InnoDB full‑text search (available since MySQL 5.6), describes inverted indexes, shows how to create and query full‑text indexes with natural language, boolean, and query‑expansion modes, discusses relevance calculation, stopwords, token‑size parameters, and provides the syntax for dropping full‑text indexes.

Boolean ModeInnoDBInverted Index
0 likes · 12 min read
Eliminate LIKE% in MySQL: Use Full‑Text Search for Efficient Fuzzy Queries
Architect Chen
Architect Chen
Jun 5, 2026 · Databases

Complete 2026 Guide to MySQL Commands: Syntax, Usage, and Best Practices

This article provides a comprehensive, step‑by‑step reference of essential MySQL commands—including connection, database and table creation, data manipulation, schema alteration, and query optimization with EXPLAIN—complete with code examples, parameter explanations, and performance warnings for safe production use.

CRUDDDLDML
0 likes · 6 min read
Complete 2026 Guide to MySQL Commands: Syntax, Usage, and Best Practices
Cloud Architecture
Cloud Architecture
Jun 4, 2026 · Databases

PostgreSQL vs MySQL: The Ultimate Engineering Guide to Database Selection

This comprehensive guide compares PostgreSQL and MySQL from an engineering perspective, covering business models, transaction semantics, concurrency, replication, scalability, operational costs, real‑world case studies, and a decision matrix to help teams choose the database that minimizes long‑term complexity and cost.

MySQLOutbox PatternPostgreSQL
0 likes · 38 min read
PostgreSQL vs MySQL: The Ultimate Engineering Guide to Database Selection
Java Tech Enthusiast
Java Tech Enthusiast
Jun 4, 2026 · Databases

Why PostgreSQL Beats MySQL in the AI Era

The article explains why developers should move beyond MySQL to PostgreSQL, illustrating the productivity gains of native window functions, MVCC concurrency, rich indexing, JSONB support, and extensive extensions through detailed examples, installation guides, performance comparisons, and real‑world use cases.

Database MigrationJSONBJava integration
0 likes · 24 min read
Why PostgreSQL Beats MySQL in the AI Era
Top Architect
Top Architect
Jun 3, 2026 · Databases

Why Using UUID as a Primary Key Can Hurt MySQL Performance

Using UUID as a primary key in MySQL inflates index size, causes random inserts that trigger frequent index and page splits, slows both insert and query operations, and makes updates costly, but techniques such as ordered UUIDs, binary storage, hybrid auto‑increment keys, and table partitioning can mitigate these issues.

Index PerformanceMySQLOrdered UUID
0 likes · 8 min read
Why Using UUID as a Primary Key Can Hurt MySQL Performance
Cloud Architecture
Cloud Architecture
Jun 2, 2026 · Databases

Advanced MySQL Production Practices: From Kernel Principles to High‑Concurrency Implementation

This guide presents a production‑grade MySQL playbook for senior developers, architects, and DB engineers, covering kernel internals, architecture governance, connection‑pool sizing, InnoDB tuning, index design, transaction and lock handling, replication, sharding, distributed transactions, change management, observability, security, cloud‑native deployment, and a complete best‑practice checklist.

Connection PoolInnoDBMySQL
0 likes · 42 min read
Advanced MySQL Production Practices: From Kernel Principles to High‑Concurrency Implementation
Engineer Tang's Implementation Study Notes
Engineer Tang's Implementation Study Notes
Jun 2, 2026 · Backend Development

Primary Key Conflicts & ClassNotFound: 1-Minute Debugging Guide to Save Hours

This article provides a systematic troubleshooting guide for two common production errors—primary key conflicts and class-not-found exceptions—covering error identification, one-minute root cause localization steps, practical fixes like ON DUPLICATE KEY UPDATE and dependency scope checks, and real-world prevention tips.

ClassNotFoundExceptionDebuggingMaven
0 likes · 14 min read
Primary Key Conflicts & ClassNotFound: 1-Minute Debugging Guide to Save Hours
Ubuntu
Ubuntu
Jun 2, 2026 · Databases

One‑Click Deployment of MySQL, Redis, and PostgreSQL on WSL

This guide shows how to install, configure, and manage MySQL/MariaDB, Redis, and PostgreSQL inside Windows Subsystem for Linux, including remote access setup, common command‑line operations, GUI client recommendations, and scripts for one‑click start/stop and backup.

GUI clientMySQLPostgreSQL
0 likes · 14 min read
One‑Click Deployment of MySQL, Redis, and PostgreSQL on WSL
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Jun 2, 2026 · Big Data

Millisecond‑Level Real‑Time Sync from MySQL to Elasticsearch with Flink CDC

This guide walks through setting up a Spring Boot 3.5 environment, configuring Flink 1.20 and Flink CDC 3.5, preparing MySQL tables, and using both the Flink CDC CLI and SQL client to achieve near‑millisecond synchronization of data from MySQL to Elasticsearch, including custom sink programming and real‑time monitoring via the Flink Web UI.

Apache FlinkElasticsearchFlink CDC
0 likes · 14 min read
Millisecond‑Level Real‑Time Sync from MySQL to Elasticsearch with Flink CDC
Random Bulletin
Random Bulletin
Jun 1, 2026 · Databases

Why 10 Million QPS Systems Must Upgrade Auto‑Increment IDs from INT to BIGINT

An INT auto‑increment primary key can exhaust its 2‑31‑1 limit in just 80 days under 10 M QPS, so the article explains how ID consumption is amplified, the high cost of migrating to BIGINT, the single‑point bottleneck of auto‑increment, and compares Snowflake, segment, UUIDv7, and Redis distributed ID solutions.

BIGINTMySQLRedis
0 likes · 18 min read
Why 10 Million QPS Systems Must Upgrade Auto‑Increment IDs from INT to BIGINT
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.

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

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

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

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

MySQLSQL optimizationexecution plan
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.

COUNTIndexInnoDB
0 likes · 9 min read
Is count(*) Really the Slowest? MySQL COUNT Performance Debunked
Engineer Tang's Implementation Study Notes
Engineer Tang's Implementation Study Notes
May 21, 2026 · Backend Development

Spring Boot Config Files Explained: yml vs yaml, Load Order, Production Logging & SQL

This article clarifies Spring Boot configuration file differences (yml vs yaml), loading priority (bootstrap before application), environment-specific overrides, common pitfalls like config center precedence and wrong profile activation, and provides production-ready logging and SQL configurations to avoid GC issues and enable slow-query detection.

LoggingMySQLSQL
0 likes · 8 min read
Spring Boot Config Files Explained: yml vs yaml, Load Order, Production Logging & SQL
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.

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

EXPLAINMySQLSQL performance
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.

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

CursorElasticsearchIndex
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