Skip to content
Tagged articles

MySQL

500 articles · Page 1 of 5
Su San Talks Tech
Su San Talks Tech
Nov 20, 2026 · Information Security

MySQL Critical Vulnerability CVE-2026-114952: CVSS 9.1 Unauthenticated Remote Attack

Oracle's November 2026 security alert reveals CVE-2026-114952, a critical MySQL client vulnerability scoring CVSS 9.1 that allows unauthenticated remote attackers to read, create, modify, and delete database data without user interaction, affecting MySQL Server 8.4.0–8.4.13, 9.7.0–9.7.4, 26.10 and MySQL Cluster 8.0.0–8.0.50, 8.4.0–8.4.13, 9.7.0–9.7.4, 26.10.

CVE-2026-114952CVSS 9.1Database Security
0 likes · 6 min read
MySQL Critical Vulnerability CVE-2026-114952: CVSS 9.1 Unauthenticated Remote Attack
Linyb Geek Road
Linyb Geek Road
Nov 20, 2026 · Databases

30 MySQL SQL Query Optimization Techniques: Practical Guide with Examples

This comprehensive guide covers 30 practical MySQL SQL query optimization techniques, including indexing strategies, join optimization, subquery rewrites, pagination, sorting, wildcard handling, and table design best practices, each illustrated with concrete SQL examples to improve database performance and query efficiency.

MySQLSQL optimizationdatabase design
0 likes · 16 min read
30 MySQL SQL Query Optimization Techniques: Practical Guide with Examples
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Nov 19, 2026 · Databases

TaurusDB AI Slow SQL Diagnosis: LLM-Assisted Tuning Cuts Query 90% in TPC-H Test

TaurusDB's AI_ANALYZE_SLOW_SQL function automatically collects execution plans, optimizer traces, and schema statistics, sends them to a large language model via MaaS, and returns a diagnostic report with index recommendations; a TPC-H Q14 test on TaurusDB MySQL 2.0.81 showed a covering index reduced query latency from 2.2s to 0.2s (90% improvement).

AI_ANALYZE_SLOW_SQLMySQLTPC-H
0 likes · 14 min read
TaurusDB AI Slow SQL Diagnosis: LLM-Assisted Tuning Cuts Query 90% in TPC-H Test
Java Tech Workshop
Java Tech Workshop
Nov 19, 2026 · Databases

MySQL COUNT(*) Optimization: Debunking Myths & Real Solutions for Large Tables

This article debunks common MySQL COUNT(*) optimization myths, explains why InnoDB's MVCC architecture requires full index scans for exact counts, and presents layered strategies including estimation via information_schema, redundant counters with Redis, data archiving, partitioning, covering indexes, and offloading analytics to ClickHouse or Elasticsearch.

COUNT optimizationInnoDBMVCC
0 likes · 18 min read
MySQL COUNT(*) Optimization: Debunking Myths & Real Solutions for Large Tables
Xiaohongshu Tech REDtech
Xiaohongshu Tech REDtech
Nov 19, 2026 · Databases

Xiaohongshu's MySQL Kernel Optimizations: Merge Seckill, Thread Pool & Nonblocking DDL

Xiaohongshu details four MySQL kernel optimizations—merge seckill for hotspot row updates, thread pool for resource isolation, DDL improvements including second-level column addition and nonblocking DDL, and flashback for historical data recovery—addressing high concurrency, reliability, agile schema changes, and burst traffic stability.

DDL OptimizationFlashbackHotspot Updates
0 likes · 18 min read
Xiaohongshu's MySQL Kernel Optimizations: Merge Seckill, Thread Pool & Nonblocking DDL
Architect's Guide
Architect's Guide
Nov 18, 2026 · Backend Development

E-Commerce Inventory Deduction: From MySQL Row Locks to Redis Lua Scripts

This article analyzes three approaches to e-commerce inventory deduction—single-row MySQL, sharded MySQL, and Redis with Lua scripts—detailing why database row locks fail under high concurrency and providing a complete Redis-based implementation with distributed locking for cache initialization and atomic stock decrement.

MySQLRedisdistributed-lock
0 likes · 12 min read
E-Commerce Inventory Deduction: From MySQL Row Locks to Redis Lua Scripts
Raymond Ops
Raymond Ops
Nov 15, 2026 · Operations

Who Crashed First? Troubleshooting 502 Errors Across Nginx, Thread Pools & DB Connection Pools

This comprehensive guide walks through a systematic troubleshooting process for 502 Bad Gateway errors, detailing how to investigate Nginx upstream failures, application thread pool exhaustion, database connection pool saturation, slow queries, lock contention, and system resource bottlenecks with concrete commands and configuration examples.

502 troubleshootingConnection PoolMySQL
0 likes · 47 min read
Who Crashed First? Troubleshooting 502 Errors Across Nginx, Thread Pools & DB Connection Pools
Xiaolin Talks Programming
Xiaolin Talks Programming
Nov 9, 2026 · Backend Development

Building a Production-Ready Online Exam System with Spring Boot 3: Paper Assembly, Anti-Cheating & Auto-Grading

This article details a production-grade Spring Boot 3 online exam system covering domain modeling, constraint-based paper assembly algorithms, anti-cheating measures with behavior logging and risk scoring, auto-grading strategies for objective and subjective questions, high-concurrency handling for exam start/submit, and score analysis with streaming exports.

Anti-CheatingAuto-GradingMySQL
0 likes · 37 min read
Building a Production-Ready Online Exam System with Spring Boot 3: Paper Assembly, Anti-Cheating & Auto-Grading
LuTiao Programming
LuTiao Programming
Nov 7, 2026 · Databases

Logical Delete vs Unique Index: The Duplicate Entry Trap and the Generated Column Fix

The article explains how logical deletion conflicts with unique indexes in MySQL, shows why a composite index on (code, deleted) only supports one delete-create cycle, and presents a robust solution using a generated column that becomes NULL when deleted, leveraging MySQL's allowance of multiple NULLs in unique indexes to enforce uniqueness only on active records.

Multi-tenancyMySQLUnique Index
0 likes · 15 min read
Logical Delete vs Unique Index: The Duplicate Entry Trap and the Generated Column Fix
Xiaolin Talks Programming
Xiaolin Talks Programming
Nov 4, 2026 · Backend Development

Building Financial-Grade Double-Entry Bookkeeping with Spring Boot 3: From Domain Model to End-of-Day Reconciliation

This article walks through implementing a financial-grade double-entry bookkeeping system using Spring Boot 3, MyBatis, and MySQL, covering domain modeling with immutable entries and derived balances, a posting engine with idempotency and debit-credit validation, balance calculation via snapshots and incremental deltas, end-of-day trial balance verification, cross-system reconciliation, and production concerns like precision handling, sharding strategies, and hot-account mitigation.

IdempotencyMyBatisMySQL
0 likes · 36 min read
Building Financial-Grade Double-Entry Bookkeeping with Spring Boot 3: From Domain Model to End-of-Day Reconciliation
IT Services Circle
IT Services Circle
Nov 3, 2026 · Databases

MySQL Top 10 from 50M Rows: SQL Pitfalls, Pre-aggregation & Space-Saving Algorithm

This article walks through a big-tech interview question about finding top 10 hot items from 50M MySQL rows, revealing why naive SQL fails, how to clarify time windows and real-time needs, and explores solutions from pre-aggregated snapshots and partitioned parallel queries to the Space-Saving algorithm for approximate top-K with bounded memory.

Approximate AlgorithmsMySQLSpace-Saving Algorithm
0 likes · 14 min read
MySQL Top 10 from 50M Rows: SQL Pitfalls, Pre-aggregation & Space-Saving Algorithm
Cilantro Loves Linux
Cilantro Loves Linux
Nov 2, 2026 · Databases

MySQL Configuration Deep Dive: Character Sets, Collations, Time Zones & SQL Modes with Hands-On Experiments

This tutorial demonstrates MySQL 8.0 configuration of character sets, collations, time zones, and SQL modes through reproducible experiments, showing how connection settings differ from server defaults, how utf8mb4 handles emojis, why TIMESTAMP converts across time zones while DATETIME does not, and how strict SQL mode rejects out-of-range values.

MySQLcharacter-setcollation
0 likes · 20 min read
MySQL Configuration Deep Dive: Character Sets, Collations, Time Zones & SQL Modes with Hands-On Experiments
IoT Full-Stack Technology
IoT Full-Stack Technology
Nov 2, 2026 · Databases

MySQL's utf8 Is Not True UTF-8: Why You Need utf8mb4

This article explains why MySQL's utf8 character set only supports up to three bytes per character, causing failures with emoji and complex characters, and details the historical reasons behind this limitation, recommending utf8mb4 for full UTF-8 support.

MySQLRFC 3629UTF-8
0 likes · 10 min read
MySQL's utf8 Is Not True UTF-8: Why You Need utf8mb4
Java Captain
Java Captain
Nov 2, 2026 · Databases

MySQL Indexes and Locking Mechanisms: Types, Principles, and Practical Examples

This article provides a comprehensive summary of MySQL indexing strategies including B+Tree and Hash structures, composite index leftmost prefix principles, and locking mechanisms covering transaction isolation levels, row/table locks, pessimistic/optimistic locking with practical SQL examples for InnoDB and MyISAM engines.

B* treeIndexInnoDB
0 likes · 24 min read
MySQL Indexes and Locking Mechanisms: Types, Principles, and Practical Examples
IoT Full-Stack Technology
IoT Full-Stack Technology
Nov 1, 2026 · Databases

MySQL's utf8 Isn't Real UTF-8: Why You Must Use utf8mb4

MySQL's utf8 character set only supports up to three bytes per character, causing errors when storing emoji or complex characters that require four bytes; the article explains the historical reason for this limitation and demonstrates that utf8mb4 is the true UTF-8 implementation introduced in 2010.

MariaDBMySQLUTF-8
0 likes · 9 min read
MySQL's utf8 Isn't Real UTF-8: Why You Must Use utf8mb4
Java Tech Workshop
Java Tech Workshop
Nov 1, 2026 · Databases

MySQL Unique Indexes Allow Multiple NULLs: Why It Happens and How to Enforce True Uniqueness

This article explains why MySQL unique indexes permit multiple NULL values due to SQL's three-valued logic, demonstrates how this breaks upsert statements and causes silent duplicates, compares behavior across databases, and presents solutions using NOT NULL constraints, generated columns, and functional indexes to enforce true uniqueness.

InnoDBMySQLNULL handling
0 likes · 16 min read
MySQL Unique Indexes Allow Multiple NULLs: Why It Happens and How to Enforce True Uniqueness
Architect's Guide
Architect's Guide
Oct 31, 2026 · Databases

4 Patterns for MySQL-Redis Cache Consistency: Trade-offs Explained

This article explains why cache inconsistency occurs between MySQL and Redis, then analyzes four update patterns—delete-then-update, update-then-invalidate, read/write-through, and write-behind—detailing their execution flows, consistency guarantees, and trade-offs to help choose the best fit for your scenario.

Cache ConsistencyCache-Aside PatternMySQL
0 likes · 9 min read
4 Patterns for MySQL-Redis Cache Consistency: Trade-offs Explained
Java Architect Handbook
Java Architect Handbook
Oct 31, 2026 · Databases

MySQL Auto-Increment ID Exhaustion: Table IDs, row_id, Xid, trx_id, thread_id Limits Explained

This article analyzes what happens when various MySQL auto-increment identifiers reach their maximum values, covering table auto_increment IDs (2^32-1), InnoDB row_id (2^48-1 wraparound causing data overwrites), Xid (2^64-1, resets on restart), trx_id (persistent max_trx_id, potential dirty reads at 2^48), and thread_id (2^32-1 with uniqueness enforcement).

InnoDBMySQLXid
0 likes · 17 min read
MySQL Auto-Increment ID Exhaustion: Table IDs, row_id, Xid, trx_id, thread_id Limits Explained
macrozheng
macrozheng
Oct 29, 2026 · Databases

MySQL 8.0.22 Timezone Bug: Why Your Timestamps Are Off by 8 Hours and How to Fix It

This article explains the MySQL 8.0.22 timezone bug that causes timestamp discrepancies up to 13 hours, details JDBC driver parameters like serverTimezone, connectionTimeZone, preserveInstants, and forceConnectionTimeZoneToSession, and provides seven best practices for correct timezone configuration in Java applications.

Best PracticesConnector/JDATETIME
0 likes · 16 min read
MySQL 8.0.22 Timezone Bug: Why Your Timestamps Are Off by 8 Hours and How to Fix It
Java Tech Workshop
Java Tech Workshop
Oct 29, 2026 · Databases

MySQL Deep Pagination: Why OFFSET 99980 Takes 4.68s and How to Cut It to 6ms

This article analyzes why MySQL LIMIT with large offsets causes severe performance degradation, explaining the server-layer mechanics of OFFSET, comparing index-scan vs full-table-scan execution paths, and demonstrating two optimization techniques — delayed join (covering index subquery) and cursor-based pagination — with benchmark results showing 4.68s reduced to 0.21s and 0.006s respectively on a 1.28M-row table.

Cursor PaginationDeep PaginationDelayed Join
0 likes · 17 min read
MySQL Deep Pagination: Why OFFSET 99980 Takes 4.68s and How to Cut It to 6ms
Cilantro Loves Linux
Cilantro Loves Linux
Oct 29, 2026 · Databases

MySQL 8.0.46 Lab Setup: Verifying x86_64 Linux Baseline & Directory Layout

This tutorial establishes a verifiable baseline for installing MySQL 8.0.46 on Kylin Linux V11 (x86_64), covering system checks (glibc 2.38, architecture), resource validation (3.3 GiB RAM, 21 GiB disk), port 3307 availability, and a structured directory layout separating downloads, config, data, logs, runtime, and SQL scripts.

Kylin OSLinuxMySQL
0 likes · 15 min read
MySQL 8.0.46 Lab Setup: Verifying x86_64 Linux Baseline & Directory Layout
Architect's Guide
Architect's Guide
Oct 27, 2026 · Databases

Goodbye Navicat: 3 Free MySQL Client Alternatives Compared

This article reviews three free MySQL client tools—DBeaver, MySQL Workbench, and HeidiSQL—as alternatives to the paid Navicat, highlighting their supported databases, installation, language support, and unique features like built-in monitoring and ER diagrams in MySQL Workbench, which the author recommends for performance testing.

DBeaverER diagramHeidiSQL
0 likes · 6 min read
Goodbye Navicat: 3 Free MySQL Client Alternatives Compared
Java Tech Workshop
Java Tech Workshop
Oct 27, 2026 · Databases

MySQL Index Failure Causes: EXPLAIN Analysis & Real-World Fixes

This article explains common MySQL index invalidation causes—implicit type conversion, functions on indexed columns, composite index ordering, and optimizer cost decisions—using EXPLAIN output analysis, and demonstrates a full slow query troubleshooting process from log to fix.

Composite IndexDatabase PerformanceEXPLAIN Plan
0 likes · 23 min read
MySQL Index Failure Causes: EXPLAIN Analysis & Real-World Fixes
Rain's Path to Java Mastery
Rain's Path to Java Mastery
Oct 25, 2026 · Databases

10B Rows into MySQL: From 231 Days to 3.5 Hours — The 6-Step Bulk Insert Playbook

This article details a six-step engineering playbook to bulk-insert 10 billion rows into MySQL, reducing time from 231 days to under 3.5 hours by combining sharding, true JDBC batching with rewriteBatchedStatements, LOAD DATA INFILE, temporary parameter tuning, parallel shard loading, idempotent checkpointing, and shadow-table swapping, while explaining B+ tree capacity math and common pitfalls.

B* treeBulk InsertIdempotency
0 likes · 42 min read
10B Rows into MySQL: From 231 Days to 3.5 Hours — The 6-Step Bulk Insert Playbook
Su San Talks Tech
Su San Talks Tech
Oct 24, 2026 · Databases

MySQL 9.0+ Goes Full AI: Native Vectors, RAG & AutoML in One Database

MySQL 9.0+ introduces native VECTOR type, built-in semantic search with RAG, and AutoML via SQL, enabling AI workloads without external services; the article details three core capabilities, two deployment modes (local enterprise edition and cloud HeatWave), complete query logic, and three runnable code examples for vector storage, similarity search, and document-based RAG.

AI IntegrationAutoMLDatabase AI
0 likes · 14 min read
MySQL 9.0+ Goes Full AI: Native Vectors, RAG & AutoML in One Database
Java Captain
Java Captain
Oct 23, 2026 · Backend Development

Druid Connection Pool: Complete Java Setup Guide with Helper Class & Tests

This tutorial demonstrates configuring and using Alibaba's Druid connection pool in Java applications, covering Maven dependencies, properties configuration, basic connection retrieval, a reusable helper class with query and execute methods, and JUnit test cases for CRUD operations.

Backend DevelopmentConnection PoolDruid
0 likes · 12 min read
Druid Connection Pool: Complete Java Setup Guide with Helper Class & Tests
Rain's Path to Java Mastery
Rain's Path to Java Mastery
Oct 22, 2026 · Databases

MySQL High-Concurrency Optimization: From Diagnosis to Sharding with Seckill Case Study

A layered MySQL optimization guide for high-concurrency scenarios covering bottleneck diagnosis, SQL/index tuning, transaction/lock optimization, a three-layer seckill inventory implementation (Redis Lua, MQ async, sharded buckets), caching patterns, read-write separation, connection pooling, InnoDB tuning, and sharding trade-offs, with real production metrics showing P99 latency dropping from 1.2s to 85ms.

Connection PoolInnoDBMySQL
0 likes · 64 min read
MySQL High-Concurrency Optimization: From Diagnosis to Sharding with Seckill Case Study
JD Tech
JD Tech
Oct 22, 2026 · Databases

Five Layers of Database High Availability: From WAL to Orchestrator Auto-Failover

This article systematically breaks down database high availability into five layers — single-node durability via WAL and two-phase commit, master-slave replication with async and semi-sync modes, GTID-based global transaction identification, consistent failover with fencing, and automated failover using Orchestrator and probe-agent — illustrating each with real-world failure cases and configuration details.

Crash RecoveryFailoverGTID
0 likes · 25 min read
Five Layers of Database High Availability: From WAL to Orchestrator Auto-Failover
Raymond Ops
Raymond Ops
Oct 22, 2026 · Operations

MySQL Replication Lag Spikes: A 10-Minute Diagnostic Framework

This guide provides a structured 10-minute triage process for sudden MySQL replication lag, covering IO/SQL thread diagnosis, GTID gap analysis, source write-rate checks, replica resource contention, and safe mitigation actions with ready-to-run evidence-collection scripts.

GTIDLAGMySQL
0 likes · 41 min read
MySQL Replication Lag Spikes: A 10-Minute Diagnostic Framework
JD Tech Talk
JD Tech Talk
Oct 22, 2026 · Databases

Database High Availability: 5-Layer Architecture from WAL to Automated Failover

This article details a five-layer database high availability architecture: single-node crash recovery via WAL and two-phase commit, asynchronous and semi-synchronous replication trade-offs, GTID-based global transaction identification for seamless failover, fencing mechanisms to prevent split-brain, and Orchestrator with probe-agent for automated failure detection and failover execution.

Crash RecoveryFailoverFencing
0 likes · 26 min read
Database High Availability: 5-Layer Architecture from WAL to Automated Failover
JD Cloud Developers
JD Cloud Developers
Oct 22, 2026 · Databases

Database HA Deep Dive: Five Layers from WAL to Automated Failover

This article systematically explains database high availability through five layers: single-node crash recovery via WAL and two-phase commit, replication modes (async vs semi-sync) and RPO trade-offs, GTID-based global transaction identification for safe failover, fencing and PRS/ERS switching protocols to prevent split-brain, and Orchestrator's cross-check failure detection with probe-agent for automated failover.

Crash RecoveryFailoverGTID
0 likes · 28 min read
Database HA Deep Dive: Five Layers from WAL to Automated Failover
Ops Community
Ops Community
Oct 21, 2026 · Databases

MySQL Performance Optimization: Diagnosing Gradual Query Slowdown with EXPLAIN, Composite Indexes & Online DDL Safety

This comprehensive guide walks through a complete MySQL performance optimization cycle: classifying three types of gradual slowdown, setting up slow logs and digest metrics, using EXPLAIN ANALYZE and optimizer trace to pinpoint a full-table scan on a 62M-row orders table, adding a composite index (user_id, status, created_at) via safe online DDL with three safety barriers, and establishing monitoring to prevent regression.

Composite IndexEXPLAINMySQL
0 likes · 47 min read
MySQL Performance Optimization: Diagnosing Gradual Query Slowdown with EXPLAIN, Composite Indexes & Online DDL Safety
Ops Community
Ops Community
Oct 20, 2026 · Databases

MySQL Replication Lag Troubleshooting: 7-Step Diagnostic Guide for 5.7/8.0

A comprehensive guide to diagnosing and resolving MySQL master-slave replication delay, covering root causes like large transactions, parallel replication misconfiguration, hardware bottlenecks, lock contention, missing indexes, network issues, and semi-sync replication, with practical tools, monitoring setup, and real-world case studies.

GTIDLAGMySQL
0 likes · 88 min read
MySQL Replication Lag Troubleshooting: 7-Step Diagnostic Guide for 5.7/8.0
Programmer XiaoFu
Programmer XiaoFu
Oct 19, 2026 · Databases

Why GROUP BY + ORDER BY Crawls on 100M-Row MySQL Tables Despite Index Usage

This article explains why MySQL GROUP BY + ORDER BY queries become extremely slow on hundred-million-row tables even when EXPLAIN shows index usage, covering temporary tables, filesort, loose index scan limitations, scanning overhead, and solutions like pre-aggregated summary tables, partitioning, columnar engines, and query scope reduction.

ClickHouseMySQLORDER BY
0 likes · 12 min read
Why GROUP BY + ORDER BY Crawls on 100M-Row MySQL Tables Despite Index Usage
Architect's Tech Stack
Architect's Tech Stack
Oct 19, 2026 · Databases

MySQL 9.7 LTS: OpenTelemetry, JSON Duality Writes & Hypergraph Optimizer Now in Community

MySQL 9.7.0 LTS brings enterprise-grade OpenTelemetry tracing, writable JSON Duality Views, and the Hypergraph optimizer to the community edition, while changing versioning to year-month format; the article details configuration steps, upgrade caveats, and default changes affecting replication and InnoDB logging.

Hypergraph optimizerJSON Duality ViewLTS
0 likes · 11 min read
MySQL 9.7 LTS: OpenTelemetry, JSON Duality Writes & Hypergraph Optimizer Now in Community
Raymond Ops
Raymond Ops
Oct 18, 2026 · Databases

MySQL Index Optimization: Confirm Slow Queries, Prove Access Paths, Add Indexes Safely

This guide details a systematic approach to MySQL index optimization: verify slow queries using performance_schema and system metrics, prove access paths with EXPLAIN ANALYZE, create indexes with rollback strategies using ALGORITHM=INPLACE and LOCK=NONE, address deep pagination with keyset pagination and N+1 queries with batch loading, and validate improvements with latency percentiles and lock metrics.

EXPLAIN ANALYZEInnoDBMySQL
0 likes · 12 min read
MySQL Index Optimization: Confirm Slow Queries, Prove Access Paths, Add Indexes Safely
Lakehouse Research Base
Lakehouse Research Base
Oct 18, 2026 · Big Data

Ziroom's One-Click Lake Ingestion: StreamPark + Paimon for 4400+ MySQL Tables

Ziroom migrated 4,400+ MySQL tables to a real-time lakehouse using Apache StreamPark and Paimon, replacing a complex Canal/Kafka/Flink/Airflow pipeline with standardized CDC ingestion, automated job deployment via StreamPark API, and Paimon's snapshot management to reduce source database load and operational overhead.

Apache FlinkApache PaimonApache StreamPark
0 likes · 35 min read
Ziroom's One-Click Lake Ingestion: StreamPark + Paimon for 4400+ MySQL Tables
Architect's Guide
Architect's Guide
Oct 18, 2026 · Backend Development

Insert 300K Records in 13 Seconds: The Right Way to Batch Insert

The article benchmarks multiple approaches for inserting 300,000 records into MySQL, showing that naive single inserts take over 4 hours, while optimized batched inserts using MyBatis or JDBC with proper batch sizes (1000–5000) and transaction management achieve 13–24 seconds, and summarizes key optimization strategies.

Bulk InsertJDBCJava
0 likes · 14 min read
Insert 300K Records in 13 Seconds: The Right Way to Batch Insert
SpringMeng
SpringMeng
Oct 18, 2026 · Interview Experience

China Merchants Bank Java Backend Interview: 20 Technical Questions & Answers

A developer shares their successful China Merchants Bank Java backend interview experience, detailing 20 technical questions covering HashMap, ConcurrentHashMap, synchronization, thread pools, Redis cache penetration, MySQL indexing, Spring Boot auto-configuration, Agent memory, RAG, multi-agent orchestration, and more, with answers and preparation tips.

AgentAuto-ConfigurationBackend
0 likes · 35 min read
China Merchants Bank Java Backend Interview: 20 Technical Questions & Answers
Raymond Ops
Raymond Ops
Oct 17, 2026 · Databases

MySQL Replication Lag Spikes to 10s? 3 Key Parallel Replication Optimizations

This article details a systematic approach to diagnose and resolve MySQL 8.0 replication lag by enabling WRITESET on the source, configuring LOGICAL_CLOCK with optimal worker count on the replica, and preserving commit order, complete with diagnostic queries, configuration steps, and validation metrics.

GTIDLOGICAL_CLOCKMySQL
0 likes · 31 min read
MySQL Replication Lag Spikes to 10s? 3 Key Parallel Replication Optimizations
Raymond Ops
Raymond Ops
Oct 14, 2026 · Databases

MySQL Replication Lag Spikes to 10 Min: Topology Optimization Rescue Guide

This guide provides a systematic methodology to diagnose and resolve MySQL replication lag spikes, covering evidence collection, replication status analysis, parallel replication tuning, large transaction mitigation, topology isolation, safe configuration changes, replica rebuild procedures, and proactive monitoring setup.

GTIDLAGMySQL
0 likes · 43 min read
MySQL Replication Lag Spikes to 10 Min: Topology Optimization Rescue Guide
Niu Liu
Niu Liu
Oct 14, 2026 · Backend Development

One Click, A Full Stack Journey: Tracing an HTTP Request from Browser to Database

This comic-style guide follows an HTTP request's complete journey through DNS resolution, TCP/TLS handshakes, Socket connections, Nginx reverse proxy, gRPC service calls, Redis caching, MySQL queries, and connection pools, revealing how each layer contributes to latency and why observability matters.

HTTPMySQLRedis
0 likes · 17 min read
One Click, A Full Stack Journey: Tracing an HTTP Request from Browser to Database
Java Captain
Java Captain
Oct 13, 2026 · Backend Development

Spring JdbcTemplate vs NamedParameterJdbcTemplate: Complete Guide with Code Examples

This tutorial demonstrates Spring's JdbcTemplate and NamedParameterJdbcTemplate for database CRUD operations, covering Maven setup, Druid connection pooling, configuration classes, DAO implementations with both positional and named parameters, service layer, and JUnit tests, recommending NamedParameterJdbcTemplate for production use.

BeanPropertyRowMapperDruidJDBC
0 likes · 21 min read
Spring JdbcTemplate vs NamedParameterJdbcTemplate: Complete Guide with Code Examples
Raymond Ops
Raymond Ops
Oct 13, 2026 · Databases

MySQL 8.0 Upgrade Guide: 20 Critical Migration Pitfalls from 5.7

This comprehensive guide details 20 critical technical checks for migrating from MySQL 5.7 to 8.0, covering authentication plugins, character sets, reserved words, strict SQL modes, replication setup, backup validation, and cutover procedures with executable SQL and bash examples.

Database MigrationDatabase UpgradeMySQL
0 likes · 23 min read
MySQL 8.0 Upgrade Guide: 20 Critical Migration Pitfalls from 5.7
Top Architect
Top Architect
Oct 12, 2026 · Backend Development

Universal Async Processing SDK: Spring Transaction Events + Kafka + XXL-Job for Guaranteed Execution

The article presents fc-async, an open-source universal asynchronous processing SDK that uses Spring's @TransactionalEventListener with fallbackExecution to decouple async tasks from business transactions, persists requests in MySQL, retries via XXL-Job, and consumes via Kafka, achieving eventual consistency without invading core code.

KafkaMySQLSpring
0 likes · 12 min read
Universal Async Processing SDK: Spring Transaction Events + Kafka + XXL-Job for Guaranteed Execution
Architect's Guide
Architect's Guide
Oct 11, 2026 · Databases

Why Database Indexes Speed Up Queries: Binary Search & Clustered Indexes Explained

This article explains how database indexes accelerate queries by leveraging sorted data structures and binary search, detailing disk I/O mechanics, clustered vs. non-clustered indexes, index trade-offs on write performance, and common SQL optimization pitfalls like OR conditions and leading wildcards that cause index invalidation.

MySQLSQL optimizationbinary search
0 likes · 13 min read
Why Database Indexes Speed Up Queries: Binary Search & Clustered Indexes Explained
Architect's Guide
Architect's Guide
Oct 10, 2026 · Databases

MySQL Full-Text Search: Beyond LIKE % for Fuzzy Queries

This article explains MySQL full-text search using inverted indexes as an alternative to LIKE % queries, covering index creation, natural language, boolean, and query expansion modes with syntax examples and performance considerations.

InnoDBInverted IndexMySQL
0 likes · 14 min read
MySQL Full-Text Search: Beyond LIKE % for Fuzzy Queries
Architect's Guide
Architect's Guide
Oct 9, 2026 · Databases

SQL Optimization: From 30,248s to 0.001s

A step-by-step MySQL query optimization case study showing how indexing, join rewriting, composite indexes, and covering indexes reduced execution time from 30,248 seconds to 0.001 seconds with execution plan analysis.

Composite IndexMySQLQuery Execution Plan
0 likes · 12 min read
SQL Optimization: From 30,248s to 0.001s
Lobster Programming
Lobster Programming
Oct 8, 2026 · Backend Development

MCP for Java Development and Testing: MySQL & Browser Automation Guide

This article explains the Model Context Protocol (MCP), its architecture and communication methods, then demonstrates how to build and configure a MySQL-MCP server in Python, integrate it with AI tools like Workbuddy, and use browser automation via MCP for automated testing of web applications.

AI toolsJava developmentMCP
0 likes · 10 min read
MCP for Java Development and Testing: MySQL & Browser Automation Guide
Java Captain
Java Captain
Oct 5, 2026 · Backend Development

Deploy a 3-Node Seata 1.8.0 Cluster with Docker Compose, Nacos & MySQL

This tutorial details deploying a three-node Seata 1.8.0 cluster using Docker Compose, Nacos for service registration and configuration, and MySQL for persistent transaction storage, covering directory layout, node-specific configs, database schema, and verification steps.

Cluster DeploymentMySQLNacos
0 likes · 12 min read
Deploy a 3-Node Seata 1.8.0 Cluster with Docker Compose, Nacos & MySQL
Java Tech Enthusiast
Java Tech Enthusiast
Oct 4, 2026 · Databases

Why SQL NULL Can't Use Equals: Three-Valued Logic & Hidden Pitfalls

This article explains why SQL NULL represents an unknown state rather than a value, how three-valued logic (TRUE, FALSE, UNKNOWN) breaks equality comparisons, and demonstrates practical pitfalls with WHERE clauses, NOT IN subqueries, aggregate functions, and MySQL's NULL-safe operator.

MySQLNOT IN pitfallNULL
0 likes · 9 min read
Why SQL NULL Can't Use Equals: Three-Valued Logic & Hidden Pitfalls
Code Farmer Manor Chronicle
Code Farmer Manor Chronicle
Oct 1, 2026 · Databases

Database Selection Guide: Decision Framework for New Projects with Xinchuang Options

This article provides a structured decision framework for choosing databases in new projects, covering four key questions, relational and NoSQL comparisons, Xinchuang (domestic) database options, distributed NewSQL systems, a practical decision tree, typical technology stacks, and guidance on writing selection documents with POC validation.

MySQLNewSQLPostgreSQL
0 likes · 9 min read
Database Selection Guide: Decision Framework for New Projects with Xinchuang Options
ITPUB
ITPUB
Oct 1, 2026 · Databases

Why SELECT * 20M Rows Won't OOM MySQL: Streaming Protocol & LRU Protection

The article explains why a MySQL SELECT * query scanning 20 million rows won't cause server-side OOM due to its streaming protocol using a 16KB net_buffer, but warns that full table scans can pollute the Buffer Pool, though InnoDB's midpoint insertion strategy and innodb_old_blocks_time (default 1s) protect hot data from eviction.

Buffer PoolInnoDBInterview
0 likes · 13 min read
Why SELECT * 20M Rows Won't OOM MySQL: Streaming Protocol & LRU Protection
Code Farmer Manor Chronicle
Code Farmer Manor Chronicle
Oct 1, 2026 · Databases

Xinchuang Database Migration: MySQL→Kingbase & Oracle→Dameng 5-Phase Guide

This article details a five-phase migration process for China's Xinchuang database replacements, covering Oracle-to-Dameng and MySQL-to-Kingbase routes, compatibility mode selection, schema conversion, data migration, application refactoring, regression verification, and critical dialect pitfalls like auto-increment, upsert, date functions, and empty-string handling.

DamengDatabase MigrationKingbase
0 likes · 10 min read
Xinchuang Database Migration: MySQL→Kingbase & Oracle→Dameng 5-Phase Guide
Java Captain
Java Captain
Sep 30, 2026 · Interview Experience

WXG First-Round Interview: 60 Questions from Algorithms to Agent Design

A shared WXG first-round interview experience lists 60 questions covering self-introduction, algorithms (IP-to-uint64, linked-list folding, uniform sampling), system design, AI tools, large-model hallucinations, RAG, vector search, collaborative filtering, 12306 ticketing architecture, Redis internals, MySQL B+ trees, concurrency locks, and design patterns.

AlgorithmsB* treeConcurrency
0 likes · 7 min read
WXG First-Round Interview: 60 Questions from Algorithms to Agent Design
Java Architect Handbook
Java Architect Handbook
Sep 29, 2026 · Backend Development

DiDi Interview Deep-Dive: Solving Elasticsearch-MySQL Data Consistency

This article analyzes four patterns for keeping Elasticsearch synchronized with MySQL — synchronous dual-write, message-queue async, CDC via Canal/binlog, and scheduled reconciliation — explaining why CDC with version-based deduplication and periodic checksums is the production-grade choice for eventual consistency at scale.

CDCCanalElasticsearch
0 likes · 16 min read
DiDi Interview Deep-Dive: Solving Elasticsearch-MySQL Data Consistency
Linux Tech Enthusiast
Linux Tech Enthusiast
Sep 28, 2026 · Databases

8 SQL Anti-Patterns That Kill Performance (and How to Fix Them)

This article details eight common SQL anti-patterns — including OFFSET pagination, implicit type conversion, correlated subqueries in updates, mixed sorting, EXISTS clauses, blocked condition pushdown, late filtering, and unoptimized intermediate results — with execution plans and rewrites that reduce query times from seconds to milliseconds.

CTEMySQLSQL optimization
0 likes · 16 min read
8 SQL Anti-Patterns That Kill Performance (and How to Fix Them)
Golang Shines
Golang Shines
Sep 26, 2026 · Operations

Complete Disk I/O Alert Troubleshooting: From Alert to Root Cause with 5 Real Cases

This article details a complete disk I/O alert investigation in production, covering core concepts like IOPS vs throughput, iostat/iotop analysis, and five real-world cases including MySQL missing indexes, log misconfiguration, backup conflicts, Redis persistence, and filesystem mount options, providing a reusable troubleshooting methodology.

AnsibleMySQLOperations
0 likes · 65 min read
Complete Disk I/O Alert Troubleshooting: From Alert to Root Cause with 5 Real Cases
LuTiao Programming
LuTiao Programming
Sep 25, 2026 · Backend Development

How One SQL Statement Solves the Order Closure vs Payment Callback Race

This article demonstrates how to prevent race conditions between order timeout closure and payment callbacks using atomic conditional UPDATE statements and SELECT FOR UPDATE with a refund outbox pattern, ensuring either payment wins and order becomes PAID, or closure wins and late payments trigger automatic refund compensation.

InnoDBMySQLSpring Boot
0 likes · 11 min read
How One SQL Statement Solves the Order Closure vs Payment Callback Race
IT Services Circle
IT Services Circle
Sep 25, 2026 · Databases

Why MySQL Needs Four Isolation Levels Despite MVCC's Lock-Free Reads

This article explains how MySQL's MVCC uses version chains and ReadViews to enable lock-free snapshot reads, why isolation levels control ReadView creation timing (per-statement vs per-transaction), and why READ UNCOMMITTED and SERIALIZABLE bypass MVCC entirely, while writes still require row locks.

InnoDBMVCCMySQL
0 likes · 8 min read
Why MySQL Needs Four Isolation Levels Despite MVCC's Lock-Free Reads
21CTO
21CTO
Sep 25, 2026 · Databases

MariaDB Outperforms MySQL and PostgreSQL in Simple Query Benchmark

The author benchmarks MariaDB 10.3, MySQL 8.0, and PostgreSQL 12 using a real Turkish motorcycle classifieds app with many simple queries, finding MariaDB 5% faster on average and 7% faster at p95 with lower CPU usage, though MySQL handles tail latency better and memory differences stem from default performance_schema settings.

BenchmarkDatabase PerformanceMariaDB
0 likes · 10 min read
MariaDB Outperforms MySQL and PostgreSQL in Simple Query Benchmark
Java Captain
Java Captain
Sep 24, 2026 · Databases

7 Common MySQL Index Failure Scenarios and How to Fix Them

This article details seven common MySQL index failure scenarios—including leftmost prefix violations, function usage on indexed columns, implicit type conversion, leading wildcards in LIKE, OR with non-indexed columns, IS NOT NULL, and NOT IN/EXISTS—with concrete SQL examples showing both failing and optimized queries.

Composite IndexIS NULLLIKE Wildcard
0 likes · 6 min read
7 Common MySQL Index Failure Scenarios and How to Fix Them
IoT Full-Stack Technology
IoT Full-Stack Technology
Sep 24, 2026 · Databases

Automate MySQL Backups with mysqldump and Cron: Complete Guide

This guide details MySQL scheduled backup using mysqldump commands for full, structural, and data-only exports, a Bash script that retains 31 days of rotating backups with logging, and crontab configuration for automated execution, including restore procedures and practical scheduling examples.

Bash ScriptLinuxMySQL
0 likes · 13 min read
Automate MySQL Backups with mysqldump and Cron: Complete Guide
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 23, 2026 · Databases

MySQL Deadlock: Practical Example, Detection & Prevention

This article explains MySQL deadlocks with a concrete example of two transactions updating rows in opposite order, demonstrates deadlock detection via SHOW ENGINE INNODB STATUS, and lists prevention techniques including small transactions, proper isolation levels, lock wait timeouts, consistent operation order, and indexing.

DeadlockInnoDBMySQL
0 likes · 8 min read
MySQL Deadlock: Practical Example, Detection & Prevention
LuTiao Programming
LuTiao Programming
Sep 22, 2026 · Backend Development

Beyond Distributed Locks: Three-Layer Idempotency for Spring Boot Order APIs

The article demonstrates why distributed locks alone fail to guarantee idempotency in Spring Boot order APIs, and presents a three-layer solution combining Idempotency-Key with request fingerprinting, Redis SET NX for fast duplicate interception, and a database unique constraint as the ultimate safeguard against duplicate orders even after crashes or Redis failures.

API designDistributed LocksIdempotency
0 likes · 25 min read
Beyond Distributed Locks: Three-Layer Idempotency for Spring Boot Order APIs
Java Captain
Java Captain
Sep 22, 2026 · Databases

MySQL JOIN: Why ON vs WHERE Placement Changes LEFT JOIN Results

This article explains how placing filter conditions in ON versus WHERE clauses affects MySQL JOIN results, demonstrating with concrete examples that INNER JOIN behaves equivalently while LEFT JOIN preserves driving table rows only when conditions are in ON, with SQL code and result comparisons.

INNER JOINLEFT JOINMySQL
0 likes · 7 min read
MySQL JOIN: Why ON vs WHERE Placement Changes LEFT JOIN Results
IT Services Circle
IT Services Circle
Sep 20, 2026 · Databases

MySQL 8 Timezone Bug Exposed: Why Timestamps Shift Before 8.0.23

This article details MySQL Connector/J's timezone handling bug in versions 8.0.0-8.0.22, explains key JDBC parameters like serverTimezone and preserveInstants, and provides best-practice configurations to avoid timestamp shifts and zero-date errors when upgrading from MySQL 5.1.

Best PracticesConnector/JDATETIME
0 likes · 16 min read
MySQL 8 Timezone Bug Exposed: Why Timestamps Shift Before 8.0.23
Cloud Architecture
Cloud Architecture
Sep 19, 2026 · Databases

Beyond COUNT_STAR=0: Auditable MySQL Index Removal with performance_schema

This article presents a rigorous, production-ready framework for MySQL index governance that moves beyond simplistic zero-usage checks, using performance_schema observation windows, structural gatekeeping, invisible index canary testing, and quantified rollback metrics to safely identify and remove redundant indexes without risking query regressions.

MySQLObservabilitySQL Tuning
0 likes · 29 min read
Beyond COUNT_STAR=0: Auditable MySQL Index Removal with performance_schema
Cloud Architecture
Cloud Architecture
Sep 17, 2026 · Databases

Indexes Aren't Free: Production Index Governance for High-Write Order Systems

This article presents a comprehensive index governance methodology for high-write MySQL order systems, demonstrating through a real incident how a read-optimized index caused write latency, replica lag, and timeouts, and detailing a reusable process covering query-driven design, cost measurement, validation, change buffer limits, index convergence, safe deletion, read-write routing, sharding, transactional outbox, idempotent consumers, online DDL safeguards, gating, and long-term ownership.

Change BufferDescending IndexesHigh-Write Systems
0 likes · 29 min read
Indexes Aren't Free: Production Index Governance for High-Write Order Systems
Raymond Ops
Raymond Ops
Sep 17, 2026 · Databases

MySQL & PostgreSQL Monitoring: Critical Metrics & Alert Thresholds Explained

This comprehensive guide covers MySQL and PostgreSQL monitoring essentials, including key metrics (connections, throughput, InnoDB, replication), version-specific differences, alert thresholds, exporter deployment (mysqld_exporter, postgres_exporter), Grafana dashboards, Prometheus alerting rules, troubleshooting playbooks for common issues like connection exhaustion, replication lag, deadlocks, and disk growth, plus automation scripts for long-transaction killing and slow-query analysis.

AlertingExportersGrafana
0 likes · 74 min read
MySQL & PostgreSQL Monitoring: Critical Metrics & Alert Thresholds Explained
liandk
liandk
Sep 16, 2026 · Databases

Slow SQL Full-Chain Troubleshooting: Execution Plans, Index Failures & Lock Contention

This comprehensive guide covers the complete slow SQL troubleshooting lifecycle: enabling slow query logs, interpreting EXPLAIN plans, diagnosing nine common index failure patterns, resolving transaction lock contention, and applying architectural optimizations for large datasets, plus emergency mitigation and long-term governance practices.

Database PerformanceMySQLSQL Tuning
0 likes · 16 min read
Slow SQL Full-Chain Troubleshooting: Execution Plans, Index Failures & Lock Contention
liandk
liandk
Sep 15, 2026 · Databases

MySQL MGR Cluster: Paxos Consensus, Zero-Downtime HA & Brain-Split Proof Architecture

This article explains MySQL Group Replication (MGR), a native high-availability cluster based on Paxos consensus, covering its architecture, single-primary vs multi-primary modes, automatic failover, brain-split prevention via majority voting, production deployment rules, and common pitfalls to avoid for zero-data-loss transactional systems.

Brain SplitDatabase ClusteringGroup Replication
0 likes · 12 min read
MySQL MGR Cluster: Paxos Consensus, Zero-Downtime HA & Brain-Split Proof Architecture
Rain's Path to Java Mastery
Rain's Path to Java Mastery
Sep 13, 2026 · Databases

MySQL Interview Panorama: Architecture, Indexes, Transactions, Locks & Sharding Guide

This comprehensive guide covers MySQL core internals for interview preparation: four-layer architecture, SQL execution flow, InnoDB vs MyISAM, B+Tree/Hash/Fulltext indexes, clustered vs non-clustered indexes, leftmost prefix principle, covering indexes, index condition pushdown, ACID with redo/undo logs, MVCC and ReadView, isolation levels, row/gap/next-key locks, two-phase commit, SQL optimization with EXPLAIN and slow query logs, sharding strategies with ShardingSphere, master-slave replication and GTID, and deep pagination solutions.

IndexInnoDBLock
0 likes · 76 min read
MySQL Interview Panorama: Architecture, Indexes, Transactions, Locks & Sharding Guide
java1234
java1234
Sep 12, 2026 · Artificial Intelligence

YOLO26 Crop Disease Detection: Full-Stack System with FastAPI & Vue3

This article details a full-stack crop disease detection system using YOLO26 for object detection, FastAPI for backend services, and Vue3 for the frontend, covering architecture, database design, API endpoints, business logic, and deployment configuration.

Computer VisionCrop Disease DetectionFastAPI
0 likes · 27 min read
YOLO26 Crop Disease Detection: Full-Stack System with FastAPI & Vue3
MaGe Linux Operations
MaGe Linux Operations
Sep 11, 2026 · Databases

MySQL Slow Query Mastery: From Log Analysis to Index Optimization

This comprehensive guide walks through the complete MySQL slow query troubleshooting loop: enabling slow query logs, analyzing with mysqldumpslow and pt-query-digest, using EXPLAIN to identify missing indexes or inefficient plans, designing composite indexes following leftmost prefix principles, validating in test environments, and safely deploying changes in production with rollback plans.

EXPLAINInnoDBMySQL
0 likes · 52 min read
MySQL Slow Query Mastery: From Log Analysis to Index Optimization
liandk
liandk
Sep 11, 2026 · Databases

MySQL Master-Slave Replication: Sync Principles, Delay Fixes, Read-Write Splitting & Failover

This article provides a comprehensive practical guide to MySQL master-slave replication, covering synchronization principles, three replication modes, delay causes and troubleshooting, read-write splitting implementation with common pitfalls, failover strategies, and five production pitfalls to avoid.

Database High AvailabilityDatabase ReplicationFailover
0 likes · 12 min read
MySQL Master-Slave Replication: Sync Principles, Delay Fixes, Read-Write Splitting & Failover
Cloud Architecture
Cloud Architecture
Sep 10, 2026 · Operations

From Firefighting to Fire Prevention: Production-Grade Database Monitoring with Prometheus & Grafana

This comprehensive guide details building a production-grade database monitoring system using Prometheus and Grafana, covering SLI/SLO design, alerting strategies, architecture, metric selection, security, Prometheus configuration, Alertmanager routing, Grafana dashboards, scaling, incident response runbooks, anti-patterns, and operational processes to shift from reactive firefighting to proactive prevention.

AlertingAlertmanagerGrafana
0 likes · 42 min read
From Firefighting to Fire Prevention: Production-Grade Database Monitoring with Prometheus & Grafana
Programmer XiaoFu
Programmer XiaoFu
Sep 8, 2026 · Databases

Why MySQL Still Needs Four Isolation Levels Despite MVCC's Lock-Free Reads

This article explains how MySQL's MVCC mechanism uses version chains and ReadViews to enable lock-free snapshot reads, and why four isolation levels (READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SERIALIZABLE) are still necessary: they define when ReadViews are created, controlling which version a transaction sees, while MVCC only handles reads—writes still require row locks.

InnoDBMVCCMySQL
0 likes · 9 min read
Why MySQL Still Needs Four Isolation Levels Despite MVCC's Lock-Free Reads
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 8, 2026 · Databases

10 Essential MySQL Configuration Settings for Performance Optimization

This article outlines ten critical MySQL configuration parameters administrators should prioritize after installation, covering InnoDB buffer pool sizing, log file configuration, connection limits, flush methods, query cache disabling, binary logging, and DNS resolution skipping, with practical guidance on safe modification practices and version-specific considerations.

Database ConfigurationInnoDBMySQL
0 likes · 10 min read
10 Essential MySQL Configuration Settings for Performance Optimization