BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 9 of 50
Cognitive Technology Team
Cognitive Technology Team
Aug 24, 2025 · Databases

When Auto‑Increment IDs Exhaust: Risks and Scalable Solutions for MySQL & PostgreSQL

This article examines how auto‑increment primary keys work, the limits of common integer types, the failures that occur when those limits are reached, and practical strategies—including type upgrades, distributed ID generators, sharding, and sequence cycling—to prevent and mitigate ID exhaustion in high‑traffic MySQL and PostgreSQL deployments.

Database ScalingMySQLPostgreSQL
0 likes · 9 min read
When Auto‑Increment IDs Exhaust: Risks and Scalable Solutions for MySQL & PostgreSQL
macrozheng
macrozheng
Aug 23, 2025 · Backend Development

Backend Essentials: TCP/UDP, HTTP, Linux, MySQL Indexes & C++ Basics

This article compiles essential backend knowledge, covering TCP vs UDP differences, why HTTP uses TCP, HTTP/2 and HTTP/3 improvements, status codes, long vs short connections, key Linux process commands, MySQL B+Tree indexing, C++ struct/class nuances, STL container types, map thread‑safety, and queue versus stack distinctions.

Backend DevelopmentC++HTTP
0 likes · 19 min read
Backend Essentials: TCP/UDP, HTTP, Linux, MySQL Indexes & C++ Basics
MaGe Linux Operations
MaGe Linux Operations
Aug 22, 2025 · Databases

How to Turn Slow MySQL Queries into Millisecond Responses: Real‑World Optimization Case Study

This article walks through a real e‑commerce incident where order queries took 15‑30 seconds, identifies bottlenecks via system metrics and slow‑query logs, analyzes execution plans, adds composite indexes, rewrites SQL, applies partitioning, read‑write splitting and caching, and ultimately achieves up to a 230‑fold performance boost.

Database MonitoringMySQLperformance tuning
0 likes · 15 min read
How to Turn Slow MySQL Queries into Millisecond Responses: Real‑World Optimization Case Study
Selected Java Interview Questions
Selected Java Interview Questions
Aug 22, 2025 · Databases

How to Recover Accidentally Deleted MySQL Data Using Binlog

This guide explains how to restore mistakenly deleted MySQL rows by leveraging binary logs, covering binlog activation, mode configuration, locating relevant log files, extracting the original INSERT statements or generating reverse DELETE statements, and using open‑source tools to automate the recovery process.

BinlogMySQLSQL
0 likes · 17 min read
How to Recover Accidentally Deleted MySQL Data Using Binlog
Architect's Guide
Architect's Guide
Aug 22, 2025 · Backend Development

Can JDBC Batch Insertion Speed Up MySQL? 100M Row Performance Test

This article evaluates the efficiency of inserting massive data into MySQL using Java, comparing three strategies—MyBatis without transactions, plain JDBC with and without transactions, and JDBC batch processing—showing that batch processing combined with transactions yields the fastest insertion speed for hundreds of millions of rows.

Batch ProcessingJDBCJava
0 likes · 13 min read
Can JDBC Batch Insertion Speed Up MySQL? 100M Row Performance Test
dbaplus Community
dbaplus Community
Aug 21, 2025 · Databases

Mastering MySQL Deep Pagination: 6 Proven Optimization Techniques

When a massive e‑commerce order table suffers from MySQL’s deep pagination slowdown, this article dissects the root causes and presents six battle‑tested solutions—including cursor pagination, deferred joins, covering indexes, partitioning, precomputed pages, and Elasticsearch integration—to dramatically improve query performance.

MySQLdatabase optimizationindexing
0 likes · 9 min read
Mastering MySQL Deep Pagination: 6 Proven Optimization Techniques
Laravel Tech Community
Laravel Tech Community
Aug 20, 2025 · Databases

Three Powerful Ways to Perform Cumulative Queries in SQL

This article explains three techniques for performing cumulative queries in SQL—using a subquery, a Cartesian product with grouping, and a window function—detailing when each method is appropriate, especially for MySQL versions lacking native window support.

MySQLSQLcartesian join
0 likes · 2 min read
Three Powerful Ways to Perform Cumulative Queries in SQL
Ops Community
Ops Community
Aug 20, 2025 · Databases

How MySQL Master‑Slave Replication and Read‑Write Splitting Turn a Single Server into a High‑Availability Architecture

This article walks through why a single MySQL instance often fails under load, explains the fundamentals of asynchronous master‑slave replication and read‑write splitting, provides step‑by‑step configuration scripts, highlights common pitfalls with solutions, and shows advanced optimization and monitoring techniques for building a scalable, high‑availability MySQL architecture.

MySQLProxySQLRead-Write Splitting
0 likes · 16 min read
How MySQL Master‑Slave Replication and Read‑Write Splitting Turn a Single Server into a High‑Availability Architecture
ITPUB
ITPUB
Aug 18, 2025 · Databases

Generating Ultra‑Short Numeric IDs in MySQL: From Snowflake to Custom Schemes

This article explores how to replace long Snowflake IDs with concise numeric account IDs by leveraging MySQL auto‑increment tables, addressing deadlock pitfalls of REPLACE INTO, and evaluating alternative batch‑allocation and sharding strategies before presenting a final free‑ID table design.

MySQLauto-incrementdatabase design
0 likes · 15 min read
Generating Ultra‑Short Numeric IDs in MySQL: From Snowflake to Custom Schemes
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 18, 2025 · Databases

Unlocking LeetCode’s Hardest SQL Problem with Window Functions

This article examines LeetCode problem 185 – the hardest SQL challenge – by preparing the Employee and Department tables, presenting two solution approaches (a subquery and a window‑function version), benchmarking their performance on large test data, and explaining why window functions are the superior choice in MySQL 8+.

LeetCodeMySQLPerformance
0 likes · 10 min read
Unlocking LeetCode’s Hardest SQL Problem with Window Functions
Liangxu Linux
Liangxu Linux
Aug 16, 2025 · Fundamentals

Essential CentOS, Database, and Networking Interview Topics

A comprehensive guide covering essential Linux CentOS commands, MySQL installation and configuration, and detailed networking concepts from link layer to application layer, complete with command examples, interview questions, and practical tips for system administrators.

CommandLineInterviewPrepMySQL
0 likes · 23 min read
Essential CentOS, Database, and Networking Interview Topics
Sanyou's Java Diary
Sanyou's Java Diary
Aug 14, 2025 · Databases

Deep Dive into MySQL InnoDB Tablespaces, Undo Logs, and Doublewrite Buffer

This article explores MySQL InnoDB's memory and on‑disk architecture, detailing tablespace types, table and row formats, primary key strategies, index structures, the doublewrite buffer, redo log, undo log, and temporary tablespaces, complete with diagrams and code examples for practical understanding.

Doublewrite BufferInnoDBMySQL
0 likes · 25 min read
Deep Dive into MySQL InnoDB Tablespaces, Undo Logs, and Doublewrite Buffer
Sohu Smart Platform Tech Team
Sohu Smart Platform Tech Team
Aug 14, 2025 · Backend Development

How to Build a Strictly Incremental Distributed ID System with Redis, MySQL, and Nacos

This article examines the limitations of traditional database‑based ID generation, compares common distributed ID solutions such as UUID, Snowflake, Baidu uid‑generator and Meituan Leaf, and presents a custom strictly incremental ID scheme that combines database segment allocation, Redis caching, and Nacos‑controlled mode switching.

MySQLNacosRedis
0 likes · 11 min read
How to Build a Strictly Incremental Distributed ID System with Redis, MySQL, and Nacos
Liangxu Linux
Liangxu Linux
Aug 13, 2025 · Databases

Unlock MySQL Mastery: A Complete Theory & Hands‑On Guide

This comprehensive guide walks you through MySQL fundamentals and advanced features, covering database architecture, storage engines, data types, CRUD operations, complex queries, transactions, indexing, performance tuning, replication, JSON handling, full‑text search, and best practices for security and backup.

CRUDMySQLSQL
0 likes · 27 min read
Unlock MySQL Mastery: A Complete Theory & Hands‑On Guide
JD Cloud Developers
JD Cloud Developers
Aug 13, 2025 · Backend Development

Why Do MySQL PhantomReferences Cause Long GC Pauses and How to Fix Them?

This article analyzes frequent timeout alerts caused by the getUiToken API, investigates JVM garbage‑collection pauses linked to excessive PhantomReference objects from MySQL connections, and presents configuration, code, and scheduling solutions that dramatically reduce GC latency and improve service stability.

ConnectionPoolGCJVM
0 likes · 12 min read
Why Do MySQL PhantomReferences Cause Long GC Pauses and How to Fix Them?
JD Tech Talk
JD Tech Talk
Aug 13, 2025 · Backend Development

Why MySQL getUiToken Times Out: PhantomReference GC Bottleneck & Fix

The article investigates frequent timeout alerts on the getUiToken API, tracing the issue to excessive PhantomReference objects causing long GC pauses, explains how MySQL’s AbandonedConnectionCleanupThread and default Druid pool settings generate these references, and presents configuration tweaks, JVM flags, and cleanup tasks that reduced GC pause times from 1.25 s to 0.1 s.

DruidGCJava
0 likes · 11 min read
Why MySQL getUiToken Times Out: PhantomReference GC Bottleneck & Fix
macrozheng
macrozheng
Aug 12, 2025 · Backend Development

Sync MySQL to Elasticsearch in Minutes with DBSyncer and Docker

This guide introduces the open‑source DBSyncer tool, explains its key features, shows how to install it via Docker, and provides a step‑by‑step example of synchronizing a MySQL product table to an Elasticsearch index, including configuration, field mapping, and verification.

BackendDBSyncerDocker
0 likes · 6 min read
Sync MySQL to Elasticsearch in Minutes with DBSyncer and Docker
macrozheng
macrozheng
Aug 11, 2025 · Databases

Why MySQL Auto‑Increment IDs Hit Their Limit and How to Fix It

This article recounts a real‑world MySQL incident where the auto‑increment INT overflowed after billions of rows, explores why the ID limit was reached, evaluates three remediation strategies—including switching to BIGINT, distributed IDs, and sharding—and shares practical SQL scripts and performance insights.

BIGINTMySQLStored Procedure
0 likes · 9 min read
Why MySQL Auto‑Increment IDs Hit Their Limit and How to Fix It
Liangxu Linux
Liangxu Linux
Aug 10, 2025 · Databases

Master MySQL Backup & Recovery: Complete Guide for Reliable Data Protection

This comprehensive guide explains MySQL data backup and recovery strategies, covering backup types, planning principles, built‑in tools like mysqldump and mysqlpump, third‑party solutions such as Percona XtraBackup, scripting for automated schedules, storage options, encryption, monitoring, troubleshooting, and best‑practice recommendations to ensure data safety and business continuity.

MySQLRecoveryautomation
0 likes · 22 min read
Master MySQL Backup & Recovery: Complete Guide for Reliable Data Protection
Xiaohongshu Tech REDtech
Xiaohongshu Tech REDtech
Aug 7, 2025 · Databases

Achieving RPO=0: How XiaoHongShu’s Binlog Server Boosts MySQL Replication Speed and Data Consistency

This article explains how XiaoHongShu’s database team built a lightweight Binlog Server to accelerate semi‑synchronous MySQL replication beyond 300 MB/s, achieve RPO=0 data‑loss‑free failover, and improve high‑availability without manual intervention, backed by performance tests and detailed architecture diagrams.

Binlog ServerMySQLRPO=0
0 likes · 15 min read
Achieving RPO=0: How XiaoHongShu’s Binlog Server Boosts MySQL Replication Speed and Data Consistency
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 7, 2025 · Databases

Unlock MySQL REST Service: Step‑by‑Step Installation and API Guide

This tutorial walks you through installing MySQL REST Service on Oracle Linux, configuring the metadata schema, using MySQL Shell in VS Code, loading the component, managing variables, handling X‑protocol settings, creating services, and authenticating via MRS, MySQL Internal, cookie or JWT, with full command‑line examples and code snippets.

AuthenticationJSONMySQL
0 likes · 17 min read
Unlock MySQL REST Service: Step‑by‑Step Installation and API Guide
macrozheng
macrozheng
Aug 7, 2025 · Databases

Boost MySQL Performance: 8 Proven SQL Optimization Techniques

This article explores eight common MySQL performance pitfalls—from inefficient LIMIT clauses and implicit type conversions to suboptimal JOIN updates, mixed sorting, EXISTS usage, condition pushdown, early result limiting, and intermediate result set handling—offering rewritten queries and execution plan analyses that dramatically improve execution times.

Database IndexesMySQLQuery Rewrite
0 likes · 13 min read
Boost MySQL Performance: 8 Proven SQL Optimization Techniques
Lobster Programming
Lobster Programming
Aug 6, 2025 · Databases

Understanding MySQL Row Overflow and InnoDB Row Formats

This article explains why MySQL row overflow occurs, compares the four InnoDB row formats, shows how overflow data is stored, discusses performance and space impacts, and offers practical tips to prevent overflow by optimizing schema and page size settings.

InnoDBMySQLRow Overflow
0 likes · 4 min read
Understanding MySQL Row Overflow and InnoDB Row Formats
ITPUB
ITPUB
Aug 5, 2025 · Databases

Recovering Accidentally Deleted MySQL Metadata on CDH Without Downtime

This guide details how to restore a CDH cluster after MySQL metadata loss caused by an accidental deletion of the MySQL data directory, covering database locking, locating deleted file handles, reconstructing shared and independent tablespaces, and verifying consistency to bring the platform back online quickly.

CDHInnoDBLinux
0 likes · 6 min read
Recovering Accidentally Deleted MySQL Metadata on CDH Without Downtime
macrozheng
macrozheng
Aug 5, 2025 · Databases

Migrate SpringBoot MyBatis from MySQL to PostgreSQL: A Complete Guide

This guide walks you through converting a SpringBoot + MyBatisPlus project from MySQL to PostgreSQL, covering driver setup, JDBC configuration changes, common SQL syntax pitfalls, and provides helper scripts for bulk column adjustments and default value settings.

JDBCMySQLPostgreSQL
0 likes · 12 min read
Migrate SpringBoot MyBatis from MySQL to PostgreSQL: A Complete Guide
Senior Tony
Senior Tony
Aug 4, 2025 · Databases

Understanding MySQL Master‑Slave Replication: Core Principles, Modes, and Latency Mitigation

This article provides a comprehensive overview of MySQL master‑slave replication, explaining its core mechanisms, the push‑pull hybrid model, replication modes (asynchronous, full‑sync, semi‑sync), binlog formats, and practical strategies to reduce replication lag caused by large transactions, server load, and network constraints.

BinlogMySQLPerformance
0 likes · 9 min read
Understanding MySQL Master‑Slave Replication: Core Principles, Modes, and Latency Mitigation
MaGe Linux Operations
MaGe Linux Operations
Aug 3, 2025 · Databases

Why MySQL Replication Lag Can Crash Your System – Binlog, Semi‑Sync & GTID Explained

An experienced DBA recounts a midnight MySQL replication disaster where slave lag exceeded 60 seconds, then dissects the root causes—binlog formats, semi‑synchronous replication, and GTID—offering detailed configurations, performance tweaks, monitoring scripts, and best‑practice recommendations to prevent and resolve such failures.

GTIDMySQLReplication
0 likes · 15 min read
Why MySQL Replication Lag Can Crash Your System – Binlog, Semi‑Sync & GTID Explained
MaGe Linux Operations
MaGe Linux Operations
Aug 1, 2025 · Databases

Master MySQL Slow Query Fixes: From Index Tuning to Distributed Sharding

This comprehensive guide walks MySQL administrators through diagnosing slow queries, configuring the slow‑query log, leveraging EXPLAIN, optimizing indexes, rewriting joins, implementing pagination tricks, and scaling with read‑write splitting, master‑slave replication, and horizontal sharding to dramatically improve performance in high‑traffic production environments.

Index OptimizationMySQLsharding
0 likes · 21 min read
Master MySQL Slow Query Fixes: From Index Tuning to Distributed Sharding
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Jul 30, 2025 · Databases

Seamless Multi-DataCenter Database Migration: Strategies and Domain Scheduling

Learn how to execute a zero‑downtime, risk‑controlled database migration across data centers using pre‑expansion, cross‑room master switch, intelligent domain scheduling, and step‑by‑step operational guides—including VIP handling, global vs. zone‑specific domains, and post‑migration validation—to ensure continuous service and optimal resource elasticity.

Domain SchedulingMySQLdatabase migration
0 likes · 13 min read
Seamless Multi-DataCenter Database Migration: Strategies and Domain Scheduling
macrozheng
macrozheng
Jul 30, 2025 · Backend Development

Why Replacing MyBatis with MyBatis‑Plus Can Break LocalDateTime Handling (and How to Fix It)

A developer upgraded an old Spring Boot project by swapping MyBatis for MyBatis‑Plus, ran into a Conversion not supported for java.time.LocalDateTime error, traced the root cause to MyBatis 3.5.1 delegating type conversion to an outdated mysql‑connector‑java, and resolved it by upgrading the connector and adjusting validation logic, illustrating the ripple effects of component upgrades.

JavaMyBatis-PlusMySQL
0 likes · 9 min read
Why Replacing MyBatis with MyBatis‑Plus Can Break LocalDateTime Handling (and How to Fix It)
Programmer XiaoFu
Programmer XiaoFu
Jul 29, 2025 · Backend Development

How to Gracefully Implement Consistent Compensation Across Multiple Systems

The article examines the challenges of achieving distributed consistency when a business operation writes to MySQL and external systems, analyzes failure scenarios, and presents a step‑by‑step solution that splits the large transaction into small, retryable tasks with Spring afterCommit optimization.

BPMJavaMySQL
0 likes · 9 min read
How to Gracefully Implement Consistent Compensation Across Multiple Systems
macrozheng
macrozheng
Jul 28, 2025 · Databases

Why MySQL Pagination Slows Down at Scale and How to Speed It Up

This article examines how MySQL pagination performance degrades as table size grows, presents benchmark results for various offsets, defines slow SQL thresholds, and offers three optimization strategies—including selecting only primary keys, ID‑based filtering, and leveraging Elasticsearch—to dramatically improve query speed.

ElasticsearchMySQLdatabase
0 likes · 10 min read
Why MySQL Pagination Slows Down at Scale and How to Speed It Up
Lobster Programming
Lobster Programming
Jul 28, 2025 · Databases

How MySQL’s Double Write Buffer Prevents Partial Write Failures

This article explains why MySQL data pages can suffer partial write failures during crashes, how the mismatch between InnoDB and OS page sizes contributes to the problem, and how the Double Write Buffer mechanism safeguards data integrity by providing a recoverable copy of each page.

Double Write BufferInnoDBMySQL
0 likes · 7 min read
How MySQL’s Double Write Buffer Prevents Partial Write Failures
MaGe Linux Operations
MaGe Linux Operations
Jul 27, 2025 · Databases

Master MySQL Performance Tuning & Troubleshooting on Linux: A Complete Guide

This comprehensive guide walks you through why MySQL performance matters, how to benchmark and establish baselines, apply Linux system and MySQL configuration optimizations, fine‑tune SQL queries, diagnose common failures, set up robust monitoring, and implement high‑availability architectures for production environments.

MySQLdatabase optimizationhigh availability
0 likes · 18 min read
Master MySQL Performance Tuning & Troubleshooting on Linux: A Complete Guide
MaGe Linux Operations
MaGe Linux Operations
Jul 25, 2025 · Databases

Master MySQL Ops: From Config Tuning to Query Performance Boost

This comprehensive guide walks you through a real production incident and then details MySQL configuration tuning, memory and thread settings, InnoDB core parameters, index design, query optimization cases, slow‑query analysis, read‑write splitting, monitoring scripts, sharding strategies, fault diagnosis, backup and recovery best practices, and high‑availability deployment, providing actionable tips and code examples for robust database performance.

MySQLReplicationperformance tuning
0 likes · 12 min read
Master MySQL Ops: From Config Tuning to Query Performance Boost
Top Architect
Top Architect
Jul 24, 2025 · Databases

How to Efficiently Shard Billion‑Row Tables with ShardingSphere and Spring Boot

This article walks through the end‑to‑end design, configuration, and implementation of splitting massive loan and repayment tables into 50 sharded MySQL tables using ShardingSphere, Spring Boot, and a custom suffix algorithm, while covering data migration, DBA coordination, dynamic switches, and scheduled consistency checks.

MySQLShardingSphereSpring Boot
0 likes · 19 min read
How to Efficiently Shard Billion‑Row Tables with ShardingSphere and Spring Boot
dbaplus Community
dbaplus Community
Jul 23, 2025 · Databases

What’s New in MySQL 9.4.0? Key Features, Fixes, and Improvements

MySQL 9.4.0 introduces extensive updates including charset handling fixes, macOS compilation options, component behavior changes, new system variables, deprecations, InnoDB memory and indexing enhancements, revised installation procedures, JavaScript stored‑procedure improvements, performance‑mode tweaks, vector function fixes, numerous new features, and a long list of resolved bugs across the server, client, and replication subsystems.

InnoDBMySQLbug fixes
0 likes · 26 min read
What’s New in MySQL 9.4.0? Key Features, Fixes, and Improvements
Architect
Architect
Jul 23, 2025 · Backend Development

How to Break Down Distributed Transactions for Reliable Microservices

This article explains the challenges of distributed consistency when a business operation writes to both MySQL and third‑party systems, presents a financial reimbursement case study, analyzes failure risks, and offers a practical solution that splits large transactions into small, retryable units using Spring and a task table.

Distributed TransactionsMicroservicesMySQL
0 likes · 10 min read
How to Break Down Distributed Transactions for Reliable Microservices
Architecture Digest
Architecture Digest
Jul 21, 2025 · Databases

When MySQL Auto‑Increment IDs Hit Their Limit: Diagnosis and Fixes

A massive MySQL table reached the INT auto‑increment ceiling, causing insert failures; the article details how the issue was identified, explores three remediation strategies—including converting the column to BIGINT, redesigning IDs, and sharding—shows stored‑procedure scripts, performance monitoring, and practical lessons on schema design and multithreaded batch processing.

BIGINTMySQLauto-increment
0 likes · 8 min read
When MySQL Auto‑Increment IDs Hit Their Limit: Diagnosis and Fixes
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 21, 2025 · Artificial Intelligence

Can Gemini AI Directly Query MySQL? A FastMCP Walkthrough

This article demonstrates how to set up a FastMCP server for MySQL, load the Sakila sample database, expose query tools to Gemini, experiment with different model versions and temperature settings, and observe the generated SQL queries and results, providing a practical guide for AI‑driven database access.

AI IntegrationFastMCPGemini
0 likes · 16 min read
Can Gemini AI Directly Query MySQL? A FastMCP Walkthrough
Su San Talks Tech
Su San Talks Tech
Jul 21, 2025 · Databases

Master MySQL Table Lookups and Index Condition Pushdown

The article explains MySQL’s table lookup (回表) and index condition pushdown (索引下推), illustrating their mechanisms with sample tables, SQL statements, execution plans, performance drawbacks, and practical techniques such as covering indexes to reduce I/O and improve query efficiency.

MySQLSQLTable Lookup
0 likes · 9 min read
Master MySQL Table Lookups and Index Condition Pushdown
Top Architect
Top Architect
Jul 20, 2025 · Databases

When MySQL Auto‑Increment IDs Hit Their Limit – Diagnosis and Fixes

A senior architect investigates a missing device error caused by MySQL auto‑increment IDs reaching the 32‑bit integer limit, analyzes the overflow issue, evaluates three remediation strategies—including converting the column to BIGINT, adopting distributed IDs, or sharding the database—and shares practical code snippets and performance insights for large‑scale data migrations.

BIGINTMySQLauto-increment
0 likes · 11 min read
When MySQL Auto‑Increment IDs Hit Their Limit – Diagnosis and Fixes
dbaplus Community
dbaplus Community
Jul 20, 2025 · Databases

Recovering Deleted MySQL Data Files in CDH: A Step‑by‑Step Guide

This guide walks through diagnosing a MySQL metadata loss in a CDH cluster, locking the database, locating deleted file handles, restoring shared and independent tablespace files, fixing table structures, verifying consistency, and explains the underlying Linux and MySQL mechanisms.

CDHInnoDBMySQL
0 likes · 6 min read
Recovering Deleted MySQL Data Files in CDH: A Step‑by‑Step Guide
Ops Community
Ops Community
Jul 19, 2025 · Operations

Mastering Linux Enterprise Data Synchronization: From Basics to Production Best Practices

This comprehensive guide explores Linux‑based enterprise data synchronization, covering core concepts, architecture patterns, tools like rsync, MySQL and PostgreSQL replication, distributed file systems, cloud‑native solutions, monitoring, security, and production‑grade best practices to help engineers build reliable, scalable sync systems.

KubernetesLinuxMySQL
0 likes · 18 min read
Mastering Linux Enterprise Data Synchronization: From Basics to Production Best Practices
MaGe Linux Operations
MaGe Linux Operations
Jul 19, 2025 · Databases

Master MySQL 8.0 Performance: 20+ Proven Optimization Tips

This guide presents more than twenty practical MySQL 8.0 optimization recommendations—including hardware tuning, InnoDB configuration, index design, query rewriting, security hardening, monitoring, backup strategies, and benchmarking—to help engineers dramatically improve database throughput, latency, and stability.

InnoDBMySQLSQL
0 likes · 15 min read
Master MySQL 8.0 Performance: 20+ Proven Optimization Tips
Senior Tony
Senior Tony
Jul 19, 2025 · Databases

Why Your MySQL Index Fails: 8 Common Pitfalls and How to Fix Them

This article examines eight typical situations that cause MySQL indexes to become ineffective—such as violating the leftmost‑prefix rule, leading‑wildcard LIKE patterns, OR conditions, functions, calculations, implicit type conversions, large result sets, and mismatched ORDER BY directions—providing SQL examples, execution‑plan screenshots, and practical explanations.

Index OptimizationMySQLSQL
0 likes · 11 min read
Why Your MySQL Index Fails: 8 Common Pitfalls and How to Fix Them
Top Architect
Top Architect
Jul 18, 2025 · Databases

Mastering MySQL‑Elasticsearch Synchronization: Strategies, Pros, and Implementation

This article explains why MySQL alone struggles with large‑scale, complex queries, introduces Elasticsearch as a complementary search engine, and compares five practical synchronization approaches—synchronous double‑write, asynchronous double‑write, Logstash, Binlog, and Canal/DTS—detailing their mechanisms, advantages, disadvantages, and typical use cases.

BinlogCanalDTS
0 likes · 17 min read
Mastering MySQL‑Elasticsearch Synchronization: Strategies, Pros, and Implementation
macrozheng
macrozheng
Jul 18, 2025 · Databases

MySQL vs Elasticsearch: Which Data Store Fits Your Needs?

This article compares MySQL and Elasticsearch across data models, query languages, indexing, distributed architecture, performance, scalability, and typical use cases, helping readers decide which system best fits their application requirements in modern software development.

ElasticsearchMySQLdata modeling
0 likes · 12 min read
MySQL vs Elasticsearch: Which Data Store Fits Your Needs?
IT Services Circle
IT Services Circle
Jul 17, 2025 · Databases

Understanding MySQL Table Lookups and Index Condition Pushdown

This article explains the concepts of table lookups (回表) and index condition pushdown (索引下推) in MySQL, demonstrates how they work with example tables and queries, discusses their performance impact, and provides practical techniques such as covering indexes and selective column queries to minimize costly table lookups.

MySQLSQLTable Lookup
0 likes · 8 min read
Understanding MySQL Table Lookups and Index Condition Pushdown
macrozheng
macrozheng
Jul 17, 2025 · Backend Development

How We Resolved Repeated Kafka Message Backlogs in a High‑Traffic Restaurant System

This article recounts a series of Kafka message backlog incidents in a restaurant ordering system and explains how targeted optimizations—batch database queries, index tuning, data archiving, and thread‑pool scaling—eliminated the delays and restored reliable kitchen display performance.

Backend DevelopmentKafkaMySQL
0 likes · 12 min read
How We Resolved Repeated Kafka Message Backlogs in a High‑Traffic Restaurant System
macrozheng
macrozheng
Jul 16, 2025 · Databases

Why Auto‑Increment Beats UUID in MySQL: Performance Tests and Deep Dive

An in‑depth MySQL study compares auto‑increment, UUID, and random Snowflake keys by building three identical tables, running insert‑performance tests with Spring Boot/JdbcTemplate, and analyzing index structures, revealing why auto‑increment keys outperform UUIDs despite the latter’s uniqueness.

Database IndexingMySQLPerformance
0 likes · 11 min read
Why Auto‑Increment Beats UUID in MySQL: Performance Tests and Deep Dive
Liangxu Linux
Liangxu Linux
Jul 15, 2025 · Databases

InnoDB vs MyISAM vs Memory: Which MySQL Storage Engine Fits Your Needs?

This article compares MySQL's three common storage engines—InnoDB, MyISAM, and Memory—by examining their core features, locking mechanisms, transaction support, durability, foreign‑key capabilities, typical use cases, and provides concrete CREATE TABLE examples and a side‑by‑side feature matrix to help developers choose the right engine.

InnoDBMemoryMyISAM
0 likes · 7 min read
InnoDB vs MyISAM vs Memory: Which MySQL Storage Engine Fits Your Needs?
Tech Freedom Circle
Tech Freedom Circle
Jul 15, 2025 · Databases

One‑Order Four‑Split: Solving MySQL Deadlocks in Million‑Row Imports

During massive daily imports of up to one million reconciliation records, MySQL deadlocks can cripple performance; this article dissects the four classic deadlock conditions, then presents a systematic “One‑Order Four‑Split” strategy—ordered writes, transaction splitting, index management, partitioning, and gap‑lock removal—backed by benchmarks, code samples, and configuration tweaks that cut lock rates by up to 90% and reduce batch times to under ten minutes.

Batch InsertIndex OptimizationJava
0 likes · 27 min read
One‑Order Four‑Split: Solving MySQL Deadlocks in Million‑Row Imports
Su San Talks Tech
Su San Talks Tech
Jul 15, 2025 · Databases

Unlock MySQL Performance: 8 Lock Types, Deadlock Solutions, and Optimization Tips

This article explains MySQL's eight lock mechanisms, their purposes and classifications, demonstrates row‑level, gap, next‑key, table and metadata locks with code examples, discusses deadlock scenarios and detection, and provides practical monitoring and optimization strategies to improve concurrency and reliability.

MySQLconcurrencydatabase optimization
0 likes · 10 min read
Unlock MySQL Performance: 8 Lock Types, Deadlock Solutions, and Optimization Tips
dbaplus Community
dbaplus Community
Jul 14, 2025 · Databases

Why Full Table Scans Won’t Exhaust MySQL Server Memory

Even when scanning a 200 GB InnoDB table on a server with only 100 GB of RAM, MySQL does not consume all memory because it streams results using a limited net_buffer, employs socket send buffers, and InnoDB’s optimized LRU algorithm manages the buffer pool to prevent memory blow‑up.

Buffer PoolInnoDBLRU
0 likes · 12 min read
Why Full Table Scans Won’t Exhaust MySQL Server Memory
IT Xianyu
IT Xianyu
Jul 14, 2025 · Databases

Master MySQL Performance: Essential my.cnf Tweaks with Docker Compose

This guide walks you through setting up a MySQL instance on AlmaLinux using Docker Compose and explains the most impactful my.cnf parameters—innodb_buffer_pool_size, max_connections, innodb_flush_log_at_trx_commit, and sync_binlog—so you can safely boost database performance.

AlmaLinuxConfigurationDocker Compose
0 likes · 12 min read
Master MySQL Performance: Essential my.cnf Tweaks with Docker Compose
MaGe Linux Operations
MaGe Linux Operations
Jul 13, 2025 · Databases

Unlock MySQL Mastery: Deep Dive into Architecture, SQL & Performance

Explore the comprehensive structure of MySQL, from its layered architecture and storage engines to detailed SQL language components, while learning essential DDL, DML, DQL, and DCL commands, performance tuning techniques, security best practices, and advanced features such as window functions, CTEs, and role-based access control.

MySQLPerformanceSQL
0 likes · 26 min read
Unlock MySQL Mastery: Deep Dive into Architecture, SQL & Performance
Java Tech Enthusiast
Java Tech Enthusiast
Jul 12, 2025 · Databases

Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety

Learn how MySQL’s three essential logs—Redo Log for durability, Undo Log for transaction rollback, and Binlog for replication—work together, understand their configurations, performance trade‑offs, and practical monitoring and recovery techniques to ensure data integrity in production environments.

BinlogMySQLdata recovery
0 likes · 9 min read
Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety
Su San Talks Tech
Su San Talks Tech
Jul 12, 2025 · Databases

Why the 3‑Table JOIN Ban Exists and How to Overcome It

This article explores the origins of the "no more than three‑table JOIN" rule, explains MySQL's join algorithm limitations, shows real‑world performance pain points in distributed architectures, and presents practical solutions such as step‑wise queries, denormalization, and materialized views to safely break the restriction.

DenormalizationJOIN optimizationMySQL
0 likes · 11 min read
Why the 3‑Table JOIN Ban Exists and How to Overcome It
MaGe Linux Operations
MaGe Linux Operations
Jul 10, 2025 · Databases

Master MySQL Backup & Recovery: Complete Guide for Reliable Data Protection

This comprehensive guide explains MySQL backup strategies, compares full, incremental, and differential backups, details built‑in tools like mysqldump, mysqlpump, and third‑party solutions such as Percona XtraBackup, and provides scripts, scheduling tips, verification methods, and best‑practice recommendations for secure data protection and recovery.

MySQLRecoverydatabase administration
0 likes · 23 min read
Master MySQL Backup & Recovery: Complete Guide for Reliable Data Protection
Shepherd Advanced Notes
Shepherd Advanced Notes
Jul 9, 2025 · Databases

Comprehensive Guide to Fastest Batch Update Techniques in MyBatis

This article systematically compares six MyBatis batch‑update approaches—including simple for‑loop, foreach XML, CASE WHEN, ON DUPLICATE KEY UPDATE, REPLACE INTO, and MyBatis‑Plus—by presenting concrete code, execution‑time measurements on 10 000 rows, and analysis of I/O, SQL parsing, scalability, and database compatibility, ultimately recommending the most performant and maintainable method for different scenarios.

Batch UpdateCASE WHENMySQL
0 likes · 13 min read
Comprehensive Guide to Fastest Batch Update Techniques in MyBatis
Su San Talks Tech
Su San Talks Tech
Jul 9, 2025 · Databases

Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety

This article explains how MySQL’s three essential logs—redo, undo, and binlog—work together to guarantee data durability, enable crash recovery, support transaction rollback, and power master‑slave replication, while providing practical configuration tips, monitoring queries, and recovery procedures for production environments.

BinlogMySQLdatabase reliability
0 likes · 10 min read
Master MySQL’s Three Logs: Redo, Undo, and Binlog for Data Safety
Selected Java Interview Questions
Selected Java Interview Questions
Jul 8, 2025 · Databases

How to Scale 1 Billion Orders with MySQL Sharding: Strategies, Gene IDs, and Migration

This article explores the performance bottlenecks of a 700‑million‑row MySQL orders table and presents a comprehensive sharding solution—including vertical and horizontal partitioning, gene‑based shard keys, routing logic, global secondary indexes, data migration strategies, and common pitfalls—demonstrating how query latency can drop from seconds to milliseconds while supporting billions of records.

Database ScalingMySQLPartitioning
0 likes · 9 min read
How to Scale 1 Billion Orders with MySQL Sharding: Strategies, Gene IDs, and Migration
IT Services Circle
IT Services Circle
Jul 8, 2025 · Backend Development

What Can You Earn at REDstar? Plus Essential MySQL, Redis, and Java Interview Secrets

The article reveals REDstar algorithm and developer salary packages, explains why Xiaohongshu’s work schedule changed, and then provides detailed Java interview questions covering MySQL indexes, composite indexes, Java primitive types, boxing/unboxing, ReentrantLock vs synchronized, Redis usage, common commands, distributed locking, and the benefits of RocketMQ, all illustrated with code snippets and diagrams.

MySQLREDstarRedis
0 likes · 16 min read
What Can You Earn at REDstar? Plus Essential MySQL, Redis, and Java Interview Secrets
Architect's Tech Stack
Architect's Tech Stack
Jul 8, 2025 · Databases

Master MySQL Full-Text Search: Indexes, Queries, and Advanced Techniques

This article explains MySQL's InnoDB full‑text search, covering the theory of inverted indexes, how to create and use full‑text indexes with various MATCH…AGAINST modes, Boolean operators, query expansion, relevance calculation, and index removal, illustrated with practical SQL examples and diagrams.

MySQLQuery ExpansionSQL
0 likes · 12 min read
Master MySQL Full-Text Search: Indexes, Queries, and Advanced Techniques
Java Baker
Java Baker
Jul 7, 2025 · Databases

Choosing the Right Database Schema for Dynamic Business Field Expansion

This article compares five common database extension strategies—from simple MySQL column additions to a hybrid MySQL‑HBase solution—detailing their implementation, advantages, drawbacks, and ideal scenarios, helping architects select the most scalable and maintainable design for evolving business data requirements.

Dynamic FieldsHBaseMySQL
0 likes · 8 min read
Choosing the Right Database Schema for Dynamic Business Field Expansion
IT Services Circle
IT Services Circle
Jul 6, 2025 · Backend Development

Must‑Know Spring & Java Interview Questions from Xiaomi Car Hiring

The article first marvels at the record‑breaking sales of Xiaomi's YU7 electric SUV, then provides a comprehensive set of Java and Spring interview questions—including B‑tree differences, MySQL hash indexes, ReentrantLock internals, Spring's circular‑dependency resolution, AOP principles, and Spring Cloud components—to help candidates prepare for Xiaomi's upcoming campus recruitment.

AOPJavaMySQL
0 likes · 24 min read
Must‑Know Spring & Java Interview Questions from Xiaomi Car Hiring
MaGe Linux Operations
MaGe Linux Operations
Jul 5, 2025 · Databases

Essential DBA Guide: Mastering Enterprise MySQL Management & Optimization

This comprehensive guide walks DBAs through enterprise‑level MySQL architecture, master‑slave replication, high‑availability clustering, performance tuning, index optimization, backup and recovery strategies, monitoring, security hardening, fault diagnosis, and best‑practice checklists to build a stable, efficient, and secure database environment.

MySQLbackup and recoverydatabase administration
0 likes · 15 min read
Essential DBA Guide: Mastering Enterprise MySQL Management & Optimization
Top Architect
Top Architect
Jul 5, 2025 · Databases

How I Cut XML‑to‑MySQL Import Time from 300 s to 4 s with Batch, RewriteBatchedStatements, and Multithreading

This article walks through optimizing a 60,000‑row XML‑to‑MySQL import by profiling the environment, measuring baseline performance, and applying JDBC batch rewriting, write aggregation, and asynchronous writes with LMAX Disruptor, ultimately reducing execution time from 300 seconds to about four seconds while keeping memory usage reasonable.

Batch ProcessingDisruptorJDBC
0 likes · 15 min read
How I Cut XML‑to‑MySQL Import Time from 300 s to 4 s with Batch, RewriteBatchedStatements, and Multithreading
Java Architect Essentials
Java Architect Essentials
Jul 4, 2025 · Backend Development

5 Common Spring Transaction Pitfalls and How to Fix Them

This article explains five frequent scenarios where Spring @Transactional fails—such as internal method calls, non‑public methods, swallowed exceptions, final/static methods, and unsupported MySQL engines—and provides concrete solutions and best‑practice rules for reliable transaction management.

AOPBackendJava
0 likes · 9 min read
5 Common Spring Transaction Pitfalls and How to Fix Them
IT Services Circle
IT Services Circle
Jul 4, 2025 · Databases

Mastering MySQL Deep Pagination: 6 Proven Optimization Techniques

This article examines the performance pitfalls of MySQL deep pagination and presents six practical optimization methods—including cursor‑based pagination, deferred joins, covering indexes, table partitioning, precomputed pages, and Elasticsearch integration—to dramatically speed up large‑scale order queries.

Cursor PaginationDatabase IndexingMySQL
0 likes · 8 min read
Mastering MySQL Deep Pagination: 6 Proven Optimization Techniques