BestHub
Sign in
Tagged articles

mysql

5000 articles · Page 1 of 50
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 ChatbotJWTSpring AI
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.

mysqlmysqltunerpercona-toolkit
0 likes · 8 min read
Four MySQL Scripts for Diagnosing and Optimizing Your Queries
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 Workbench
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.

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

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

GitIDE performanceIntelliJ IDEA
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 PoolEXPLAINIndex Optimization
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.

Execution PlanQuery OptimizationSQL
0 likes · 12 min read
Are You Still Using These 8 Inefficient SQL Patterns?
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 consistencyRedis
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 ManagementGoRedis
0 likes · 8 min read
Explore the Open-Source Go-Vue-Admin Backend Management System
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 ProcessingJavaPerformance Tuning
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.

InnoDBLockingforce index
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.

DatabasesOperationsRecovery
0 likes · 44 min read
Backup and Recovery: mysqldump / xtrabackup with Point‑In‑Time Recovery
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.

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

Database PerformanceHardwareQPS
0 likes · 3 min read
How Much Concurrency Can MySQL Handle? A Practical Breakdown
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.

Batch InsertJDBCJava
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.

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

DeadlockIndex OptimizationTransaction
0 likes · 5 min read
How to Prevent MySQL Deadlocks in High‑Concurrency Apps: 5 Proven Solutions
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.

AutomationDockerHigh Availability
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.

DBADatabase AdministrationIndexes
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.

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

Automatic FailoverHigh AvailabilityRead‑Write Splitting
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.

JavaRocketMQasynchronous messaging
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 ModeFull-Text SearchInnoDB
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
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.

IndexingJSONBJava Integration
0 likes · 24 min read
Why PostgreSQL Beats MySQL in the AI Era
Architect Chen
Architect Chen
Jun 4, 2026 · Databases

Comprehensive Guide to MySQL Master‑Slave Replication (Principles, Architecture, Implementation)

This article explains MySQL master‑slave replication in detail, covering its role in high‑availability and read/write separation, the core binlog mechanism, typical one‑master‑multiple‑slaves architecture, and the step‑by‑step data flow from write operations on the master to replay on the replicas.

BinlogDatabase ArchitectureMaster‑Slave
0 likes · 4 min read
Comprehensive Guide to MySQL Master‑Slave Replication (Principles, Architecture, Implementation)
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.

Binary StorageIndex PerformanceOrdered UUID
0 likes · 8 min read
Why Using UUID as a Primary Key Can Hurt MySQL Performance
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.

Database deploymentGUI clientPostgreSQL
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
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.

OR queryQuery OptimizationSQL
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.

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

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

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

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

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

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

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

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

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

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

Execution PlanIndexingJOIN
0 likes · 13 min read
SQL Optimization: Cutting Query Time from 30,248 s to 0.001 s
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.

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

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

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

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

Database TuningEXPLAINIndex Optimization
0 likes · 32 min read
10 Common MySQL Index Failure Scenarios – Which Ones Affect You?
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.

Database DesignIndex OptimizationNULL
0 likes · 11 min read
Why Leading Companies Avoid NULL Values in MySQL
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.

Database operationsDynamic data maskingHypergraph Optimizer
0 likes · 8 min read
MySQL 9.7 LTS Launch: First Major Release Since 8.4 Brings Enterprise Features to the Community
Architect's Guide
Architect's Guide
May 14, 2026 · Databases

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

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

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

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

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

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

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

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

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

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

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

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

Designing a Logistics Prepaid Deduction System: Architecture & Core Implementation

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

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

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

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

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

Why UUID Falls Short and How Snowflake Solves Distributed ID Generation

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

Distributed IDJavaRedis
0 likes · 14 min read
Why UUID Falls Short and How Snowflake Solves Distributed ID Generation
Architect's Guide
Architect's Guide
May 9, 2026 · Databases

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

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

Data synchronizationDataXETL
0 likes · 15 min read
Alibaba’s Open‑Source DataX: Fast, Easy Offline Data Synchronization
Golang Shines
Golang Shines
May 7, 2026 · Databases

160 Must‑Know MySQL Interview Questions to Test Your Skills

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Why Choose MySQL Over PostgreSQL? Key Technical Drawbacks Explained

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

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

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

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

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

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

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

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

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

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

CPUIndex OptimizationPerformance Tuning
0 likes · 44 min read
How to Completely Resolve MySQL CPU Spikes: Real‑World Fault Replay and Optimization Guide
Woodpecker Software Testing
Woodpecker Software Testing
Apr 30, 2026 · Databases

Datafaker: A Powerful Tool for Bulk Test Data Generation

Datafaker is a Python‑compatible utility that creates large volumes of synthetic test data for databases, streams, files, and messaging systems, offering flexible metadata rules, multi‑backend support, and command‑line options for quick data provisioning.

ElasticsearchMetadataPython
0 likes · 14 min read
Datafaker: A Powerful Tool for Bulk Test Data Generation
Coder Trainee
Coder Trainee
Apr 29, 2026 · Backend Development

Mastering Distributed Transactions with Seata in Spring Cloud Microservices

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

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

Production MySQL Deadlocks: Diagnosis Strategies and Permanent Fixes

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

DeadlockInnoDBPerformance Schema
0 likes · 22 min read
Production MySQL Deadlocks: Diagnosis Strategies and Permanent Fixes
Raymond Ops
Raymond Ops
Apr 25, 2026 · Databases

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

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

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

Three Free Tools That Can Replace Navicat for MySQL

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

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

Why Choose PostgreSQL Over MySQL Despite MySQL’s Popularity?

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

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

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

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

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

How to Diagnose and Optimize MySQL Slow Queries Beyond Adding Indexes

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

EXPLAINIndex OptimizationPerformance Tuning
0 likes · 34 min read
How to Diagnose and Optimize MySQL Slow Queries Beyond Adding Indexes
Ray's Galactic Tech
Ray's Galactic Tech
Apr 22, 2026 · Cloud Native

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Horizontal PartitioningMyBatisSharding-JDBC
0 likes · 33 min read
Getting Started with Sharding-JDBC in SpringBoot: A Practical Guide to Database Sharding
Ops Community
Ops Community
Apr 19, 2026 · Databases

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

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

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

Mastering SpringBoot Concurrency: Pessimistic vs Optimistic Locks Explained

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

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

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

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

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

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

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

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

How to Import 1 Billion Records into MySQL at Lightning Speed

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

Bulk InsertPerformance TuningRedis
0 likes · 21 min read
How to Import 1 Billion Records into MySQL at Lightning Speed
Java Companion
Java Companion
Apr 17, 2026 · Backend Development

Resolving ID Conflicts After Sharding: 5 Practical Solutions

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

ID GenerationMeituan LeafSegment
0 likes · 14 min read
Resolving ID Conflicts After Sharding: 5 Practical Solutions