BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 27 of 50
Architecture Digest
Architecture Digest
Apr 11, 2023 · Databases

Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications

This article explains MySQL replication’s background, binlog formats, event types, positioning methods, asynchronous and semi‑synchronous workflows, parallel replication techniques, and real‑world deployment strategies such as HA components, middleware, remote binlog copying, and data‑transfer services, providing a comprehensive guide for building highly available and scalable MySQL infrastructures.

BinlogMySQLReplication
0 likes · 26 min read
Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications
IT Architects Alliance
IT Architects Alliance
Apr 11, 2023 · Databases

MySQL Execution Process and Comprehensive Optimization Best Practices

This article explains MySQL's query execution flow and provides extensive best‑practice guidelines—including naming conventions, storage engine choices, primary‑key design, character set settings, query writing tips, indexing strategies, batch operations, and performance‑enhancing techniques—to help developers write efficient and maintainable SQL code.

MySQLQuery TuningSQL optimization
0 likes · 24 min read
MySQL Execution Process and Comprehensive Optimization Best Practices
php Courses
php Courses
Apr 10, 2023 · Backend Development

A PHP Web Crawler: Design, Implementation, and Challenges

This article describes a PHP‑based web crawler that extracts links and images using regular expressions, stores URLs in MySQL, handles duplicate detection via MD5, discusses performance limitations, and provides the full source code and usage instructions.

Backend DevelopmentMySQLPHP
0 likes · 8 min read
A PHP Web Crawler: Design, Implementation, and Challenges
ITPUB
ITPUB
Apr 8, 2023 · Databases

Master MySQL Performance: 13 Essential SQL Optimization Techniques

This comprehensive guide walks you through practical MySQL optimization strategies—including slow‑query analysis, deep‑pagination fixes, explain plan interpretation, index tuning, large‑table design, and common pitfalls—so you can dramatically improve query speed and overall database performance.

MySQLSQL optimization
0 likes · 22 min read
Master MySQL Performance: 13 Essential SQL Optimization Techniques
Top Architect
Top Architect
Apr 7, 2023 · Databases

MySQL Performance Optimization Guidelines from a Senior Architect

This article presents a senior architect’s comprehensive MySQL optimization guide, covering execution process, naming conventions, storage engine choices, indexing strategies, query writing best practices, transaction handling, partitioning, and other performance‑tuning techniques to improve database efficiency and reliability.

DatabaseOptimizationMySQLPerformance
0 likes · 24 min read
MySQL Performance Optimization Guidelines from a Senior Architect
Meituan Technology Team
Meituan Technology Team
Apr 6, 2023 · Databases

AI-Driven Index Recommendation for Slow Queries at Meituan

This article details a joint research effort between Meituan and East China Normal University that combines cost‑based methods with AI‑driven, data‑centric models to automatically generate and evaluate missing indexes for billions of daily slow queries, improving recommendation accuracy and query performance.

AICost ModelIndex Recommendation
0 likes · 16 min read
AI-Driven Index Recommendation for Slow Queries at Meituan
vivo Internet Technology
vivo Internet Technology
Apr 5, 2023 · Databases

Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications

MySQL replication copies data changes from a primary server to one or more replicas using binlog events—supporting statement, row, or mixed formats and GTID positioning—to provide real‑time backup, read‑write separation, high‑availability failover, and integration pipelines via asynchronous, semi‑synchronous, or centralized binlog services.

BinlogData ReliabilityGTID
0 likes · 30 min read
Understanding MySQL Replication: Principles, Mechanisms, and Practical Applications
21CTO
21CTO
Apr 4, 2023 · Databases

How to Keep MySQL and Redis In Sync: Two Practical Solutions Explained

This article compares two methods for synchronizing MySQL data with Redis cache—using MySQL triggers combined with a UDF function, and parsing MySQL binlog via tools like Canal—detailing their workflows, advantages, limitations, and implementation considerations.

BinlogCanalDatabase Replication
0 likes · 6 min read
How to Keep MySQL and Redis In Sync: Two Practical Solutions Explained
ITPUB
ITPUB
Apr 4, 2023 · Databases

Mastering MySQL Replication: Principles, Lag Fixes, and Failover Strategies

This article explains MySQL master‑slave replication fundamentals, the binlog‑based data flow, common consistency and latency problems, practical solutions such as row or mixed binlog formats, caching and query routing, and the trade‑offs of one‑master‑one‑slave versus one‑master‑many‑slaves architectures.

Master‑SlaveMySQLReplication
0 likes · 11 min read
Mastering MySQL Replication: Principles, Lag Fixes, and Failover Strategies
Su San Talks Tech
Su San Talks Tech
Apr 4, 2023 · Databases

9 Proven MySQL Query Optimizations to Slash Execution Time

This article walks through nine common MySQL performance pitfalls—from inefficient LIMIT clauses and implicit type conversions to sub‑query updates, mixed sorting, EXISTS usage, condition pushdown, early range reduction, and intermediate result pushdown—showing how to rewrite each pattern for dramatically faster execution.

Database IndexingLIMIT clauseMySQL
0 likes · 15 min read
9 Proven MySQL Query Optimizations to Slash Execution Time
Top Architect
Top Architect
Apr 2, 2023 · Databases

Optimizing Large-Scale Pagination Queries in MySQL: Data Generation and Index Strategies

This article demonstrates how to generate millions of test rows in MySQL, analyzes the performance impact of deep pagination using LIMIT, explains why non‑clustered index lookups cause costly table scans, and presents two optimization approaches—sub‑query ID filtering and key‑set pagination—to dramatically reduce query latency.

Index OptimizationMySQLPerformance
0 likes · 8 min read
Optimizing Large-Scale Pagination Queries in MySQL: Data Generation and Index Strategies
IT Services Circle
IT Services Circle
Apr 2, 2023 · Databases

Understanding MySQL Master‑Slave Replication: Principles, Lag, and Failover

This article explains MySQL master‑slave replication, covering its architecture, binlog‑based replication process, causes and mitigation of replication lag, and strategies for master‑slave failover, helping readers grasp why and how to use replication for read/write separation, high availability, and backup.

Master‑SlaveMySQLReplication
0 likes · 12 min read
Understanding MySQL Master‑Slave Replication: Principles, Lag, and Failover
Tencent Database Technology
Tencent Database Technology
Mar 30, 2023 · Databases

TXSQL Parallel DDL: Design, Implementation, and Performance

This article explains the challenges of slow DDL operations in MySQL, introduces TXSQL’s Parallel DDL framework—including Copy, Inplace, and Instant algorithms—details their design, implementation, code examples, and performance evaluations, and compares them with other database solutions.

DDLMySQLParallel DDL
0 likes · 22 min read
TXSQL Parallel DDL: Design, Implementation, and Performance
Top Architect
Top Architect
Mar 29, 2023 · Databases

MySQL Query Optimization and Index Tuning: From Subqueries to Joins and Composite Indexes

This article demonstrates MySQL query performance issues with large tables, shows how a subquery without indexes can take hours, and walks through step‑by‑step optimizations including adding single‑column indexes, converting to EXISTS and JOIN queries, creating composite indexes, covering indexes, and sorting improvements, achieving speedups of thousands of times.

Composite IndexCovering IndexMySQL
0 likes · 12 min read
MySQL Query Optimization and Index Tuning: From Subqueries to Joins and Composite Indexes
政采云技术
政采云技术
Mar 28, 2023 · Databases

Understanding MVCC and Lock Mechanisms in MySQL

This article explains why MySQL uses MVCC, how undo‑log version chains and read views implement multi‑version concurrency control, and details the various lock types—including global, table, metadata, intention, row, gap, and next‑key locks—under different isolation levels with practical code examples.

InnoDBLocksMVCC
0 likes · 11 min read
Understanding MVCC and Lock Mechanisms in MySQL
Selected Java Interview Questions
Selected Java Interview Questions
Mar 27, 2023 · Databases

Optimizing Deep Pagination in MySQL: Data Generation, Index Behavior, and Fast Query Strategies

This article demonstrates how to generate two million MySQL rows, examines the performance impact of large OFFSET values in LIMIT clauses, explains why non‑clustered indexes cause back‑table lookups, and presents two optimization strategies—using sub‑queries to fetch IDs and employing key‑based pagination—to dramatically speed up deep page queries.

Index OptimizationMySQLSQL
0 likes · 10 min read
Optimizing Deep Pagination in MySQL: Data Generation, Index Behavior, and Fast Query Strategies
Shepherd Advanced Notes
Shepherd Advanced Notes
Mar 27, 2023 · Databases

Why MySQL Uses B+ Trees for Indexing

The article explains the fundamentals of tree data structures, compares B, B+, B*, and red‑black trees, and shows how B+ trees reduce disk I/O and improve range query performance, which is why MySQL adopts B+ trees for its indexes.

B+ TreeData StructuresMySQL
0 likes · 15 min read
Why MySQL Uses B+ Trees for Indexing
ITPUB
ITPUB
Mar 26, 2023 · Databases

Why a Missing mysql-bin.index Crashed MySQL HA and How to Recover It

A detailed post‑mortem of a MySQL dual‑master cluster failure caused by a missing mysql-bin.index file, showing step‑by‑step diagnostics, container logs, replication position fixes, and preventive measures for high‑availability deployments.

Binary LogKeepalivedMySQL
0 likes · 8 min read
Why a Missing mysql-bin.index Crashed MySQL HA and How to Recover It
Su San Talks Tech
Su San Talks Tech
Mar 26, 2023 · Backend Development

Unlock Real-Time MySQL Data Sync with Alibaba Canal: A Hands‑On Guide

This article introduces Alibaba's open‑source Canal middleware, explains its architecture and high‑availability design, walks through MySQL binlog configuration, Canal setup, and provides a complete Java client example for real‑time data synchronization, cache refresh, and task dispatch scenarios.

BackendBinlogCanal
0 likes · 18 min read
Unlock Real-Time MySQL Data Sync with Alibaba Canal: A Hands‑On Guide
Java High-Performance Architecture
Java High-Performance Architecture
Mar 24, 2023 · Backend Development

Explore Echo: Open-Source Java Community Platform & Deployment Guide

Echo is a full‑stack open‑source Java community system built with Spring Boot, MyBatis, MySQL, Redis, Kafka and Elasticsearch, offering modules like posts, comments and notifications, and the article provides its core tech stack, development environment, local setup steps, deployment architecture, demo screenshots and source code access.

ElasticsearchJavaKafka
0 likes · 5 min read
Explore Echo: Open-Source Java Community Platform & Deployment Guide
360 Quality & Efficiency
360 Quality & Efficiency
Mar 24, 2023 · Operations

Performance Testing and Optimization of a Web Application Using JMeter and BlazeMeter

This article details a comprehensive performance testing workflow—including requirement analysis, script recording with BlazeMeter, data construction, iterative optimization, and final results—targeting a web application that must handle over 5,000 TPS with 2 million database records, highlighting bottlenecks in Redis, MySQL, and code logic.

BlazeMeterJMeterMySQL
0 likes · 7 min read
Performance Testing and Optimization of a Web Application Using JMeter and BlazeMeter
ITPUB
ITPUB
Mar 23, 2023 · Databases

How MySQL InnoDB Implements ACID: Deep Dive into Transactions, Locks, and Isolation

This article explains how MySQL InnoDB achieves the ACID properties—Atomicity, Consistency, Isolation, Durability—by detailing the roles of undo logs, redo logs, buffer pool, lock mechanisms, and MVCC, and outlines transaction lifecycle commands, isolation levels, and consistency guarantees.

ACIDInnoDBMySQL
0 likes · 10 min read
How MySQL InnoDB Implements ACID: Deep Dive into Transactions, Locks, and Isolation
Top Architect
Top Architect
Mar 23, 2023 · Backend Development

Ensuring Consistency Between Cache and Database During Dual Writes

The article examines how to maintain data consistency between caches and databases during dual-write operations, categorizes data into three levels, evaluates four update strategies, and proposes solutions such as delayed double deletion, message‑queue compensation, and binlog‑driven cache synchronization.

MySQLdatabase consistency
0 likes · 8 min read
Ensuring Consistency Between Cache and Database During Dual Writes
dbaplus Community
dbaplus Community
Mar 22, 2023 · Databases

Scaling an Airline Ticket Order Database: From Monolith to 64‑Shard Sharding

The article details how a rapidly growing airline ticket order system was re‑architected by identifying performance bottlenecks, applying vertical and horizontal sharding, optimizing cache layers, implementing dual‑write mechanisms, and planning a phased migration to achieve ten‑fold QPS growth while reducing resource usage and operational risk.

MySQLcache optimizationdatabase sharding
0 likes · 38 min read
Scaling an Airline Ticket Order Database: From Monolith to 64‑Shard Sharding
Efficient Ops
Efficient Ops
Mar 22, 2023 · Databases

8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries

This article reveals frequent SQL mistakes—such as misuse of LIMIT, implicit type conversion, sub‑query updates, mixed ordering, EXISTS, condition push‑down, premature filtering, and intermediate result push‑down—and provides concrete rewrite techniques that dramatically improve MySQL query performance.

MySQLOptimizationPerformance
0 likes · 14 min read
8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 22, 2023 · Databases

Understanding and Optimizing BUFFER (Queuing) Tables in OceanBase

The article explains what OceanBase BUFFER (Queuing) tables are, why frequent bulk updates cause performance degradation, and provides three optimization methods—including binding execution plans, manual data transfer, and setting table_mode='queuing'—with concrete MySQL and Oracle examples and query scripts to monitor merges.

BUFFER tableMySQLOceanBase
0 likes · 7 min read
Understanding and Optimizing BUFFER (Queuing) Tables in OceanBase
Shepherd Advanced Notes
Shepherd Advanced Notes
Mar 22, 2023 · Databases

Mastering MySQL Indexes: Advanced Concepts and Practical Tips

This article provides a comprehensive deep‑dive into MySQL indexing, covering the definition, pros and cons, differences between clustered and non‑clustered indexes, InnoDB vs MyISAM implementations, B+Tree structure, capacity calculations, adaptive hash indexes, index pushdown optimization, and how to interpret EXPLAIN output to verify index usage.

Adaptive Hash IndexB+ TreeIndex Pushdown
0 likes · 18 min read
Mastering MySQL Indexes: Advanced Concepts and Practical Tips
php Courses
php Courses
Mar 21, 2023 · Databases

Introduction to MySQL sql_mode and Its 10 Modes

This article explains the MySQL sql_mode setting, details each of its ten modes—including STRICT_TRANS_TABLES, STRICT_ALL_TABLES, and ONLY_FULL_GROUP_BY—provides a command to view the current mode, and also includes a brief promotion for a PHP training class.

Database ConfigurationDatabase SettingsMySQL
0 likes · 4 min read
Introduction to MySQL sql_mode and Its 10 Modes
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 21, 2023 · Databases

MySQL 8.0 New Features: Performance, Security, Optimizer, and Other Enhancements

This article provides a comprehensive overview of MySQL 8.0 enhancements, covering performance improvements such as contention‑aware scheduling and hash joins, security upgrades including authentication plugins and password policies, optimizer refinements, and various other features like persistent variables, GIS support, and binlog expiration handling.

Hash JoinJSONMySQL
0 likes · 16 min read
MySQL 8.0 New Features: Performance, Security, Optimizer, and Other Enhancements
Top Architect
Top Architect
Mar 20, 2023 · Databases

Two Approaches to Synchronize MySQL Data with Redis Cache

This article explains two methods for keeping MySQL data in sync with a Redis cache—using MySQL triggers with a UDF function and parsing MySQL binlog streams—detailing their processes, advantages, limitations, and related open‑source tools like Canal.

CanalDatabase ReplicationMySQL
0 likes · 7 min read
Two Approaches to Synchronize MySQL Data with Redis Cache
IT Services Circle
IT Services Circle
Mar 20, 2023 · Fundamentals

Comprehensive Interview Review: Networking, TCP/IP, Epoll, Redis, MySQL MVCC, and C++ Concepts

This article compiles a detailed interview guide covering TCP/UDP differences, three‑way handshake and four‑way termination, flow and congestion control, select/poll/epoll mechanisms, zero‑copy techniques, Redis advantages and persistence, MySQL MVCC and repeatable‑read semantics, as well as core C++ topics and common algorithm questions.

C++MySQLNetworking
0 likes · 19 min read
Comprehensive Interview Review: Networking, TCP/IP, Epoll, Redis, MySQL MVCC, and C++ Concepts
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 20, 2023 · Databases

New Features and Enhancements in MySQL 8.0

MySQL 8.0 introduces numerous enhancements including InnoDB engine defaults, atomic DDL, instant column addition, CTE support, UTF8MB4 default charset, Clone plugin, resource groups, role management, multi-valued and functional indexes, invisible indexes, descending indexes, SET_VAR syntax, persistent parameters, window functions, online DDL, and improved backup and binlog capabilities.

8.0InnoDBMySQL
0 likes · 23 min read
New Features and Enhancements in MySQL 8.0
Laravel Tech Community
Laravel Tech Community
Mar 19, 2023 · Databases

How to Diagnose and Resolve MySQL Process CPU Usage Spiking to 900%

This article explains common scenarios that cause MySQL (and related services) to consume 900% CPU, outlines step‑by‑step diagnosis using tools like top and show processlist, and provides practical remediation such as killing offending threads, adding missing indexes, disabling slow‑log, and leveraging Redis caching to bring CPU usage down to acceptable levels.

CPUMySQLSQL
0 likes · 6 min read
How to Diagnose and Resolve MySQL Process CPU Usage Spiking to 900%
dbaplus Community
dbaplus Community
Mar 19, 2023 · Databases

Should MySQL Run in Docker? Risks and Strategies Explained

While containers and Docker dominate modern infrastructure, this article critically examines whether MySQL should be containerized, highlighting data safety, performance, statefulness, and resource isolation concerns, and offering practical strategies such as separating data from the program, using lightweight or distributed databases, and appropriate deployment choices.

Cloud NativeData SafetyDocker
0 likes · 7 min read
Should MySQL Run in Docker? Risks and Strategies Explained
ITPUB
ITPUB
Mar 19, 2023 · Databases

Why MySQL 8’s Default utf8mb4 Breaks Legacy utf8 Tables – A Deep Dive

Upgrading MySQL 5.6/5.7 databases to 8.0 can introduce charset mismatches between existing utf8 (utf8mb3) tables and newly created utf8mb4 tables, causing index loss and performance degradation that can be resolved by unifying the character set across all tables.

MySQLPerformanceSQL
0 likes · 7 min read
Why MySQL 8’s Default utf8mb4 Breaks Legacy utf8 Tables – A Deep Dive
ITPUB
ITPUB
Mar 18, 2023 · Databases

How to Keep MySQL Slave Nodes Alive with Keepalived and Read/Write Splitting

This guide walks through the background of MySQL read/write splitting, records troubleshooting steps for an unexpected slave crash, explains the two splitting models, and provides detailed commands and configuration examples for using Keepalived to ensure high availability of the slave node.

DockerKeepalivedMySQL
0 likes · 9 min read
How to Keep MySQL Slave Nodes Alive with Keepalived and Read/Write Splitting
Top Architect
Top Architect
Mar 14, 2023 · Databases

Handling Large MySQL Tables: Partitioning, Sharding, and Archiving Strategies

This article explains how to assess MySQL table size, identify performance issues caused by massive data volumes, and presents three practical solutions—table partitioning, database sharding, and hot‑cold data archiving—along with detailed SQL examples and considerations for implementation.

Data ArchivingMySQLPerformance Optimization
0 likes · 16 min read
Handling Large MySQL Tables: Partitioning, Sharding, and Archiving Strategies
Su San Talks Tech
Su San Talks Tech
Mar 14, 2023 · Databases

How to Solve Read‑Amplification in MySQL Sharding: Strategies & Tips

This article explains the concepts of database sharding, compares vertical and horizontal partitioning, discusses ID‑range and modulo sharding methods, analyzes the read‑amplification problem caused by non‑sharding keys, and presents practical solutions such as auxiliary index tables, Elasticsearch integration, and TiDB adoption.

Database ScalingElasticsearchHorizontal Partitioning
0 likes · 14 min read
How to Solve Read‑Amplification in MySQL Sharding: Strategies & Tips
Java Architect Essentials
Java Architect Essentials
Mar 13, 2023 · Databases

Two Approaches to Synchronize MySQL Data with Redis Cache

This article explains two technical solutions for keeping MySQL data in sync with Redis cache—using a MySQL trigger with a UDF function and parsing MySQL binlog events—while also reviewing the Canal open‑source tool and discussing their trade‑offs and implementation details.

BinlogCanalDatabase Replication
0 likes · 6 min read
Two Approaches to Synchronize MySQL Data with Redis Cache
Liangxu Linux
Liangxu Linux
Mar 13, 2023 · Databases

Why Docker Struggles with MySQL: 5 Key Reasons and Workarounds

The article examines why running MySQL in Docker containers often leads to data‑security, performance, state, and resource‑isolation problems, outlines practical mitigation strategies, and identifies scenarios where containerizing MySQL can still be viable.

DockerMySQLPerformance
0 likes · 7 min read
Why Docker Struggles with MySQL: 5 Key Reasons and Workarounds
Code Ape Tech Column
Code Ape Tech Column
Mar 13, 2023 · Backend Development

Diagnosing and Resolving 900% CPU Spikes in MySQL and Java Processes

This article explains common scenarios that cause CPU usage to soar above 200% in production, outlines step‑by‑step diagnosis and remediation for MySQL and Java processes, and shares real‑world case studies with command‑line tools, indexing, caching, and code adjustments to bring CPU load back to normal levels.

CPUJavaMySQL
0 likes · 11 min read
Diagnosing and Resolving 900% CPU Spikes in MySQL and Java Processes
Laravel Tech Community
Laravel Tech Community
Mar 12, 2023 · Databases

Why COUNT(*) May Be Slower Than COUNT(1) in MySQL InnoDB

This article analyses how MySQL 5.7 InnoDB processes COUNT(*) versus COUNT(1), COUNT(id) and COUNT on indexed or non‑indexed columns, showing execution‑plan differences across various index configurations, explaining why count(*) can be unexpectedly slower and offering practical guidance for query optimization.

COUNTInnoDBMySQL
0 likes · 10 min read
Why COUNT(*) May Be Slower Than COUNT(1) in MySQL InnoDB
dbaplus Community
dbaplus Community
Mar 12, 2023 · Databases

Why MySQL 8.0 Queries Fail After Upgrading from 5.7: Charset & Collation Pitfalls

When upgrading MySQL 5.7 tables that use utf8 or utf8mb3 to MySQL 8.0, mismatched character sets and collations can cause index loss and inefficient joins, but converting all tables to utf8mb4 and adjusting the driver table can restore optimal query performance, as demonstrated with detailed examples and profiling results.

CharsetMySQLQuery Optimization
0 likes · 7 min read
Why MySQL 8.0 Queries Fail After Upgrading from 5.7: Charset & Collation Pitfalls
21CTO
21CTO
Mar 12, 2023 · Databases

Why and How to Implement Database Sharding: Strategies, Middleware, and Best Practices

Database sharding—splitting data across multiple databases and tables—is essential as applications scale, and this article explains the motivations, differences between sharding and partitioning, horizontal and vertical splits, common middleware options like Cobar, TDDL, Atlas, ShardingSphere, and Mycat, and how to choose the right solution.

Horizontal PartitioningMySQLdatabase sharding
0 likes · 12 min read
Why and How to Implement Database Sharding: Strategies, Middleware, and Best Practices
ITPUB
ITPUB
Mar 12, 2023 · Databases

Why MySQL Defaults to Repeatable Read – Inside Transaction Isolation

This article explains what a database transaction is, details the ACID properties, compares MySQL's four isolation levels, clarifies why Repeatable Read is the default due to binlog formats and consistency, examines concurrency anomalies of each level, and provides practical guidance on handling large transactions, optimizing performance, and understanding InnoDB's MVCC implementation.

InnoDBMVCCMySQL
0 likes · 22 min read
Why MySQL Defaults to Repeatable Read – Inside Transaction Isolation
ITPUB
ITPUB
Mar 12, 2023 · Databases

Master Real-World SQL Optimization: From Identifying Slow Queries to 20× Speed Boost

This article walks through a practical SQL optimization workflow, showing how to detect problematic queries via system metrics and execution plans, analyze table structures and indexes, apply concrete ALTER statements and index changes, and iteratively verify performance improvements, illustrated with a detailed MySQL case study that achieved a twenty‑fold speed increase.

Index OptimizationMySQLSQL
0 likes · 10 min read
Master Real-World SQL Optimization: From Identifying Slow Queries to 20× Speed Boost
Code Ape Tech Column
Code Ape Tech Column
Mar 12, 2023 · Databases

Optimizing Batch Insert Performance in MyBatis‑Plus with a Custom SQL Injector

This article analyzes why MyBatis‑Plus's default saveBatch method does not achieve true batch insertion, explains how to enable JDBC batch mode with rewriteBatchedStatements, and demonstrates creating a custom SQL injector (InsertBatchSomeColumn) to perform real batch inserts, including performance test results showing significant speed improvements.

Batch InsertJavaMyBatis-Plus
0 likes · 10 min read
Optimizing Batch Insert Performance in MyBatis‑Plus with a Custom SQL Injector
ITPUB
ITPUB
Mar 11, 2023 · Databases

What Happens When You Press Ctrl+C in MySQL? Inside the KILL QUERY Mechanism

This article explains how pressing Ctrl+C in the MySQL client triggers a KILL QUERY command, details the server's multi‑step handling—including thread coordination, flag setting, and transaction rollback—and clarifies differences when autocommit is on or off.

KILL QUERYMySQLThread Management
0 likes · 10 min read
What Happens When You Press Ctrl+C in MySQL? Inside the KILL QUERY Mechanism
ITPUB
ITPUB
Mar 10, 2023 · Databases

How ICBC Secures MySQL at Scale: Insights from a Senior Database Architect

In this interview, ICBC senior manager Wei Yadong shares the bank's challenges with massive data, the five‑point criteria for database selection, the DevOps‑driven MySQL governance framework, evolving security demands, future database trends for finance, and practical advice for database professionals.

Database ManagementDevOpsFinancial Industry
0 likes · 16 min read
How ICBC Secures MySQL at Scale: Insights from a Senior Database Architect
Shepherd Advanced Notes
Shepherd Advanced Notes
Mar 9, 2023 · Databases

Understanding MySQL’s SQL Execution Flow and Transaction Mechanics

This article explains MySQL’s internal architecture, walks through how a SELECT query and an UPDATE statement are processed—including the connector, parser, optimizer, executor, redo log, binlog, and two‑phase commit—and details transaction properties, isolation levels, MVCC, and related configuration parameters.

ACIDBinlogInnoDB
0 likes · 19 min read
Understanding MySQL’s SQL Execution Flow and Transaction Mechanics
JD Cloud Developers
JD Cloud Developers
Mar 8, 2023 · Backend Development

Mastering Web Pagination: Database, Backend, and Frontend Techniques

This article explores web pagination across database, backend, and frontend layers, detailing MySQL LIMIT syntax, Java pagination implementations with PageHelper and Spring Data JDBC, and UI approaches using Thymeleaf and Element UI, providing code examples and comparative insights for developers.

Element UIJavaMySQL
0 likes · 9 min read
Mastering Web Pagination: Database, Backend, and Frontend Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 8, 2023 · Databases

OceanBase Tenant Deletion Methods and Syntax

This article explains OceanBase's three tenant deletion approaches—normal, delayed, and immediate—detailing the DROP TENANT syntax, recycle‑bin behavior, and providing step‑by‑step SQL examples for creating, dropping, restoring, and permanently removing tenants.

MySQLOceanBaseSQL
0 likes · 7 min read
OceanBase Tenant Deletion Methods and Syntax
Architecture Digest
Architecture Digest
Mar 8, 2023 · Backend Development

Cache Consistency Strategies Between MySQL and Redis

The article explains the classic cache consistency problem between MySQL and Redis, analyzes how inconsistencies arise, and details four cache‑update design patterns—delete‑then‑update, cache‑aside, read/write‑through, and write‑behind—highlighting their workflows, advantages, and drawbacks.

Backend DevelopmentDesign PatternsMySQL
0 likes · 8 min read
Cache Consistency Strategies Between MySQL and Redis
Laravel Tech Community
Laravel Tech Community
Mar 6, 2023 · Databases

SQL Optimization Best Practices: Avoid SELECT *, Use Specific Fields, Index Strategies, and Other Performance Tips

This article presents a comprehensive set of MySQL performance guidelines, including avoiding SELECT *, preferring specific columns, eliminating OR in WHERE clauses, using numeric types, choosing VARCHAR over CHAR, applying proper JOINs, leveraging LIMIT, UNION ALL, composite indexes, and other practical tips to improve query efficiency and resource usage.

MySQLPerformanceQuery Optimization
0 likes · 17 min read
SQL Optimization Best Practices: Avoid SELECT *, Use Specific Fields, Index Strategies, and Other Performance Tips
Sanyou's Java Diary
Sanyou's Java Diary
Mar 6, 2023 · Databases

15 Common MySQL Index Pitfalls and How to Avoid Them

This article compiles fifteen typical scenarios where MySQL indexes become ineffective—covering composite index left‑most matching, SELECT *, arithmetic on indexed columns, functions, LIKE patterns, type conversion, OR/AND logic, range queries, ORDER BY, and optimizer decisions—providing example SQL, EXPLAIN output, and practical tips to help developers prevent costly full‑table scans.

MySQLPerformanceSQL
0 likes · 24 min read
15 Common MySQL Index Pitfalls and How to Avoid Them
ITPUB
ITPUB
Mar 6, 2023 · Backend Development

Why Did MySQL Return Stale Data? A SkyWalking Tracing Case Study

This article walks through a real‑world incident where an update to a MySQL row was not visible to a subsequent read, explains how SkyWalking tracing revealed the exact timing of binlog writing, MQ delivery, and query execution, and offers practical mitigation strategies.

CanalMySQLSkyWalking
0 likes · 13 min read
Why Did MySQL Return Stale Data? A SkyWalking Tracing Case Study
dbaplus Community
dbaplus Community
Mar 5, 2023 · Backend Development

How to Achieve Fast and Stable MySQL Data Center Migration at Scale

This article details the background, migration options, and step‑by‑step automated procedures used by a large‑scale e‑commerce platform to safely move over 400 MySQL clusters, comparing expansion‑plus‑master‑slave switching with cascading replication and explaining the chosen fast, reliable solution.

Cascading ReplicationMySQLautomation
0 likes · 9 min read
How to Achieve Fast and Stable MySQL Data Center Migration at Scale
Top Architect
Top Architect
Mar 4, 2023 · Databases

How to Handle Large MySQL Tables: Partitioning, Sharding, and Archiving Strategies

This article explains why large MySQL tables cause slow queries, analyzes table size, disk usage, and instance capacity, and presents three practical solutions—table partitioning, database sharding (horizontal/vertical), and hot‑cold data archiving—helping developers choose the appropriate strategy for their workloads.

Data ArchivingMySQLPerformance Optimization
0 likes · 18 min read
How to Handle Large MySQL Tables: Partitioning, Sharding, and Archiving Strategies
Architect's Guide
Architect's Guide
Mar 3, 2023 · Databases

SQL Optimization: Common Steps, Index Types, and Practical Case Analyses

This article explains how to identify slow SQL statements, analyze execution plans with EXPLAIN, use profiling and optimizer trace, and apply practical solutions such as index optimization, query rewriting, and alternative storage, illustrated with ten real‑world MySQL case studies.

MySQLOptimizationPerformance
0 likes · 11 min read
SQL Optimization: Common Steps, Index Types, and Practical Case Analyses
ITPUB
ITPUB
Feb 28, 2023 · Databases

Master MySQL Query Performance: A Step‑by‑Step SQL Optimization Guide

This article explains how to prepare and tune MySQL SQL statements before execution, covering logical and physical optimization, table and view analysis, join‑key checks, query rewriting, and execution‑plan evaluation to achieve faster, more efficient database queries.

MySQLQuery TuningSQL optimization
0 likes · 9 min read
Master MySQL Query Performance: A Step‑by‑Step SQL Optimization Guide
Tencent Database Technology
Tencent Database Technology
Feb 28, 2023 · Databases

Understanding InnoDB Undo Segment States and MySQL XA Transaction Crash Recovery (MySQL 8.0.30)

This article explains how InnoDB uses undo segment states for crash‑safe recovery, details the XA transaction protocol, describes bugs in earlier MySQL versions, and shows how MySQL 8.0.30 introduces a new undo state and revised prepare order to make external XA transactions crash‑safe, including code examples and recovery steps.

Crash RecoveryInnoDBMySQL
0 likes · 11 min read
Understanding InnoDB Undo Segment States and MySQL XA Transaction Crash Recovery (MySQL 8.0.30)
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 28, 2023 · Databases

Using sync-diff-inspector for MySQL/TiDB Data Validation and Repair

This article introduces the open‑source sync‑diff‑inspector tool, explains how to download and install it, and provides detailed configuration and command‑line examples for schema‑level, table‑level, and range‑based data validation between MySQL instances, including automatic SQL repair generation and common troubleshooting tips.

ConfigurationDatabase ToolsMySQL
0 likes · 15 min read
Using sync-diff-inspector for MySQL/TiDB Data Validation and Repair
ITPUB
ITPUB
Feb 26, 2023 · Databases

Why InnoDB Stores Primary Keys in Secondary Index Leaves – A Deep Dive

This article explains InnoDB’s clustered and secondary index structures, why secondary index leaf nodes store primary key values, how lookups trigger “row‑lookup” (回表) operations, and how covering indexes can eliminate those extra scans, illustrated with MySQL examples.

Covering IndexInnoDBMySQL
0 likes · 7 min read
Why InnoDB Stores Primary Keys in Secondary Index Leaves – A Deep Dive
ITPUB
ITPUB
Feb 24, 2023 · Databases

How Ctrip Migrated MySQL to OceanBase: Tools, Process, and Lessons Learned

Ctrip evaluated and extended OceanBase Migration Assessment tools, built a one‑click migration workflow, implemented comprehensive monitoring and automatic fault‑diagnosis pipelines, and addressed compatibility challenges such as .NET charset issues and Druid parser errors, ultimately achieving a smooth MySQL‑to‑OceanBase transition.

MySQLOceanBasePerformance Diagnosis
0 likes · 18 min read
How Ctrip Migrated MySQL to OceanBase: Tools, Process, and Lessons Learned
Big Data Technology & Architecture
Big Data Technology & Architecture
Feb 24, 2023 · Big Data

Common Flink Task Submission Issues and Solutions on YARN

This article compiles frequent Flink job submission problems on YARN—including WordCount jar errors, HBase dependency conflicts, MySQL timeout, checkpoint restoration failures, parallelism limits, and unexpected container termination—provides root‑cause analysis and step‑by‑step remediation instructions.

CheckpointFlinkHBase
0 likes · 21 min read
Common Flink Task Submission Issues and Solutions on YARN
政采云技术
政采云技术
Feb 23, 2023 · Databases

Understanding Next-Key Lock Deadlocks in MySQL: Analysis and Solutions

This article examines how common business operations using SELECT ... FOR UPDATE and INSERT can cause MySQL Next‑Key lock deadlocks, explains the underlying gap‑lock and row‑lock mechanisms, demonstrates practical experiments, and proposes strategies such as postponing locks or using primary‑key updates to avoid such deadlocks.

MySQLNext-Key LockSQL
0 likes · 14 min read
Understanding Next-Key Lock Deadlocks in MySQL: Analysis and Solutions
Top Architect
Top Architect
Feb 22, 2023 · Backend Development

High‑Availability Architecture for a Billion‑User Membership System: ES Dual‑Center Clusters, Traffic Isolation, Redis Caching, and MySQL Migration

The article describes how a large‑scale membership system serving over a billion users achieves high performance and availability through dual‑center Elasticsearch clusters, traffic‑isolated three‑cluster designs, Redis caching with distributed locks, and a seamless migration from SQL Server to sharded MySQL, while also detailing operational safeguards and fine‑grained flow‑control strategies.

ElasticsearchMySQLsystem architecture
0 likes · 20 min read
High‑Availability Architecture for a Billion‑User Membership System: ES Dual‑Center Clusters, Traffic Isolation, Redis Caching, and MySQL Migration
ITPUB
ITPUB
Feb 21, 2023 · Databases

How MySQL Implements File Sorting: Internals, Modes, and Optimizations

This article explains MySQL's file‑sort mechanism in depth, covering the sort buffer, handling of long sort keys, three sort modes, priority‑queue and read‑rnd‑buffer optimizations, internal vs. external sorting, descending sort implementation, and how to inspect details with optimizer trace.

FilesortMySQLexternal sorting
0 likes · 32 min read
How MySQL Implements File Sorting: Internals, Modes, and Optimizations
Zhuanzhuan Tech
Zhuanzhuan Tech
Feb 21, 2023 · Databases

Fast and Stable MySQL Data Center Migration: Choosing and Implementing the Optimal Strategy

This article details the background, migration plan selection, and step‑by‑step procedures—including pre‑building cascades, service pause, automated batch operations, cluster tiering, pre‑ and post‑checks, and gray‑scale validation—to achieve a fast, stable MySQL data‑center migration for a large‑scale production environment.

MySQLOperationsautomation
0 likes · 11 min read
Fast and Stable MySQL Data Center Migration: Choosing and Implementing the Optimal Strategy