BestHub
Sign in
Tagged articles
5000 articles
Page 27 of 50
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 31, 2022 · Databases

Resolving MySQL 8.0.21 Client Segmentation Fault Caused by Missing ncurses and Implicit Function Declarations

This article details the investigation and resolution of a MySQL 8.0.21 client segmentation fault on CentOS 8.4, covering missing ncurses libraries, implicit function declaration warnings, pointer truncation on 64‑bit systems, core‑file generation, gdb analysis, and the steps required to rebuild the client without crashes.

Linuxc++client
0 likes · 13 min read
Resolving MySQL 8.0.21 Client Segmentation Fault Caused by Missing ncurses and Implicit Function Declarations
ITPUB
ITPUB
Oct 29, 2022 · Databases

When and How to Implement Master‑Slave Read/Write Splitting in MySQL

This article explains when read/write splitting is needed, details MySQL master‑slave replication mechanics, outlines middleware design choices, and provides practical monitoring and mitigation strategies for replication lag, helping developers decide and implement effective database scaling.

master-slave replicationmysqlread/write splitting
0 likes · 13 min read
When and How to Implement Master‑Slave Read/Write Splitting in MySQL
FunTester
FunTester
Oct 28, 2022 · Databases

Understanding MySQL’s Logical Architecture and Transaction Isolation Levels

This article explains MySQL’s three‑tier logical architecture—from client services to core query processing and storage engines—and details the four ANSI SQL transaction isolation levels, highlighting their behavior, advantages, and trade‑offs in MySQL.

Database ArchitectureStorage Enginemysql
0 likes · 7 min read
Understanding MySQL’s Logical Architecture and Transaction Isolation Levels
Tencent Database Technology
Tencent Database Technology
Oct 27, 2022 · Databases

Analysis of Unexpected InnoDB Lock Waits Caused by Missing End‑Range Push‑Down and Semi‑Consistent Reads

The article explains why a seemingly non‑conflicting UPDATE on a secondary index can cause lock‑wait alerts under RC isolation, detailing the missing end‑range condition push‑down, the InnoDB row‑search flow, semi‑consistent read behavior, and differences between primary‑key and secondary‑index locking.

InnoDBLock WaitSemi‑consistent Read
0 likes · 12 min read
Analysis of Unexpected InnoDB Lock Waits Caused by Missing End‑Range Push‑Down and Semi‑Consistent Reads
Shopee Tech Team
Shopee Tech Team
Oct 27, 2022 · Backend Development

Design and Implementation of a Scalable Fund Routing Decision Engine at Shopee

Shopee’s scalable fund‑routing decision engine combines a configurable Go‑based rule engine with Redis‑backed, Lua‑driven quota control to dynamically match loan orders to external capital providers, enforce multi‑dimensional volume limits, achieve tens of thousands TPS, and provide extensible risk‑management capabilities across markets.

GoPerformance Testingbackend-development
0 likes · 17 min read
Design and Implementation of a Scalable Fund Routing Decision Engine at Shopee
IT Services Circle
IT Services Circle
Oct 27, 2022 · Databases

Understanding MVCC (Multiversion Concurrency Control) in MySQL InnoDB

MVCC (Multiversion Concurrency Control) in MySQL InnoDB uses undo logs and read views to provide non‑locking snapshot reads, managing read‑write, write‑write, and read‑read concurrency, with implicit row fields and transaction IDs determining visibility across isolation levels.

InnoDBMVCCRead View
0 likes · 9 min read
Understanding MVCC (Multiversion Concurrency Control) in MySQL InnoDB
Top Architect
Top Architect
Oct 26, 2022 · Backend Development

Implementing Database Read‑Write Splitting with Spring Boot and Dynamic DataSource Routing

This article explains how to achieve database read‑write separation in high‑concurrency Java applications by configuring master and slave data sources, implementing a routing DataSource, managing context with ThreadLocal, defining a custom @DataSourceSwitcher annotation, and applying AOP to switch between read and write operations.

DataSource RoutingSpring Bootaop
0 likes · 11 min read
Implementing Database Read‑Write Splitting with Spring Boot and Dynamic DataSource Routing
IT Services Circle
IT Services Circle
Oct 26, 2022 · Databases

Debezium: Open‑Source Change Data Capture Platform – Overview, Architecture, Use Cases, and Installation Guide

This article introduces Debezium, an open‑source low‑latency change data capture platform that streams database row changes via Kafka, explains its architecture and common scenarios such as cache invalidation and CQRS, and provides step‑by‑step Docker commands to install ZooKeeper, Kafka, MySQL and the Debezium connector.

CDCData IntegrationDebezium
0 likes · 15 min read
Debezium: Open‑Source Change Data Capture Platform – Overview, Architecture, Use Cases, and Installation Guide
Programmer DD
Programmer DD
Oct 26, 2022 · Databases

Boost MySQL Performance: 20 Proven SQL Optimization Tips

This article presents a comprehensive set of MySQL optimization techniques, covering everything from avoiding SELECT * and OR conditions to proper index usage, join strategies, batch operations, and query planning, all aimed at reducing resource consumption, improving execution speed, and ensuring reliable database design.

Database PerformanceQuery TuningSQL Optimization
0 likes · 19 min read
Boost MySQL Performance: 20 Proven SQL Optimization Tips
dbaplus Community
dbaplus Community
Oct 24, 2022 · Databases

Mastering MySQL Slow Query Optimization: Practical Strategies from Ctrip

Facing a surge in MySQL slow queries, Ctrip’s senior database engineers detail a comprehensive approach—including refined SQL release processes, deep execution‑plan analysis, index tuning, query rewriting, and resource management—to systematically identify, diagnose, and eliminate performance bottlenecks in large‑scale hotel services.

Database TuningIndex OptimizationSQL Performance
0 likes · 14 min read
Mastering MySQL Slow Query Optimization: Practical Strategies from Ctrip
ITPUB
ITPUB
Oct 23, 2022 · Databases

Why Your Read Returns Stale Data After a Write in MySQL Replication and How to Fix It

After a write to the MySQL master, reads from a slave can return old or missing data due to replication lag, and this article explains the underlying asynchronous replication mechanisms, the involved threads, and presents practical solutions such as forcing master reads, delay detection, semi‑sync mode, GTID waiting, and middleware implementations like Sharding‑JDBC, MyCat, and MaxScale.

GTIDLagRead-Write Split
0 likes · 11 min read
Why Your Read Returns Stale Data After a Write in MySQL Replication and How to Fix It
Java Backend Technology
Java Backend Technology
Oct 22, 2022 · Databases

Why MySQL Unique Indexes Fail with NULL and How to Fix Them

This article explains why a unique index in MySQL can still allow duplicate rows when indexed columns contain NULL, explores the challenges of adding unique indexes to logically deleted tables, and presents practical solutions such as incremental delete status, timestamps, extra IDs, hash fields, and proper batch insertion techniques.

Database designLogical DeleteUnique Index
0 likes · 13 min read
Why MySQL Unique Indexes Fail with NULL and How to Fix Them
Architect
Architect
Oct 21, 2022 · Databases

Designing Efficient POI Proximity Search with MySQL, GeoHash, and Redis

This article explains how to implement fast nearby POI queries by calculating distances with the Haversine formula, designing MySQL tables and indexes, applying GeoHash for dimensionality reduction, and leveraging Redis Geo for high‑concurrency scenarios, while also providing Go code examples for each step.

GeoHashGoPOI
0 likes · 29 min read
Designing Efficient POI Proximity Search with MySQL, GeoHash, and Redis
Top Architect
Top Architect
Oct 20, 2022 · Databases

Performance Evaluation of Inserting Billion‑Scale Data into MySQL Using Java: MyBatis vs JDBC vs Batch Processing

This article presents a detailed performance test of inserting massive data into MySQL with Java, comparing three strategies—MyBatis lightweight insertion without transactions, direct JDBC handling with and without transactions, and JDBC batch processing—showing timing results for millions of rows and offering practical recommendations for high‑throughput data loading.

Batch ProcessingDatabase OptimizationJDBC
0 likes · 14 min read
Performance Evaluation of Inserting Billion‑Scale Data into MySQL Using Java: MyBatis vs JDBC vs Batch Processing
Ctrip Technology
Ctrip Technology
Oct 20, 2022 · Databases

Practical Slow Query Optimization for MySQL at Ctrip

This article describes Ctrip's practical approach to identifying and optimizing MySQL slow queries, covering background, improved SQL review workflow, execution plan analysis, common index problems, query rewriting, pagination issues, resource contention, and best‑practice recommendations for long‑term performance.

Database OptimizationQuery PlanningSQL Performance
0 likes · 10 min read
Practical Slow Query Optimization for MySQL at Ctrip
Top Architect
Top Architect
Oct 19, 2022 · Databases

MySQL Replication, High Availability, and Sharding: Concepts and Solutions

This article explains the evolution from single‑node MySQL databases to master‑slave replication, various replication modes, high‑availability strategies, and both vertical and horizontal sharding techniques, while discussing the associated challenges such as distributed transactions, routing, and operational complexity.

Distributed TransactionsReplicationdatabase scaling
0 likes · 11 min read
MySQL Replication, High Availability, and Sharding: Concepts and Solutions
Architect's Guide
Architect's Guide
Oct 19, 2022 · Databases

Database Scaling, Replication, High Availability, and Sharding Overview

This article explains why single‑node databases cannot keep up with rapid business growth and describes MySQL replication methods, high‑availability solutions such as MHA and MGR, and the challenges and techniques of vertical and horizontal sharding for large‑scale systems.

Replicationdatabase scalinghigh availability
0 likes · 11 min read
Database Scaling, Replication, High Availability, and Sharding Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 18, 2022 · Databases

Why MySQL Remains Popular and Its Logical Architecture

The article explains MySQL's continued dominance in the database market, presents recent developer survey statistics, describes its three‑layer logical architecture, and introduces the new edition of the "High Performance MySQL" book as a guide for modern database professionals.

Database Architecturedeveloper surveyhigh availability
0 likes · 7 min read
Why MySQL Remains Popular and Its Logical Architecture
MaGe Linux Operations
MaGe Linux Operations
Oct 15, 2022 · Databases

20 Essential MySQL Optimization Tips to Boost Query Performance

This article presents a comprehensive set of MySQL best‑practice guidelines—including avoiding SELECT *, steering clear of OR in WHERE clauses, preferring numeric over string types, using VARCHAR instead of CHAR, limiting DELETE/UPDATE, leveraging proper JOIN types, and many other indexing and query‑execution tricks—to dramatically improve query speed, reduce resource consumption, and maintain healthy database design.

Database designQuery PerformanceSQL Optimization
0 likes · 18 min read
20 Essential MySQL Optimization Tips to Boost Query Performance
21CTO
21CTO
Oct 14, 2022 · Databases

What Drives China’s Database Boom? Insights from MariaDB’s Founder

In an exclusive interview, MariaDB founder Michael "Monty" Widenius discusses the rapid growth of China’s database industry, the rise of open‑source adoption, competition with cloud providers, and strategic plans for expanding MariaDB’s presence in the Chinese market.

ChinaDatabase MarketMariaDB
0 likes · 15 min read
What Drives China’s Database Boom? Insights from MariaDB’s Founder
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 14, 2022 · Databases

SQLE 1.2210.0-pre1 Release Notes: New MySQL Audit Rules, Enhanced Scanning Filters, and UI Improvements

The SQLE 1.2210.0-pre1 preview release introduces new MySQL audit rules prohibiting rename/change operations and requiring LIMIT clauses, adds filter options to the intelligent scan task list, refines work‑order progress styling, and provides a detailed list of features, optimizations, and bug fixes.

Database AuditingRelease NotesSQLE
0 likes · 5 min read
SQLE 1.2210.0-pre1 Release Notes: New MySQL Audit Rules, Enhanced Scanning Filters, and UI Improvements
Top Architect
Top Architect
Oct 13, 2022 · Databases

Understanding Transaction Isolation Levels and Concurrency Issues in MySQL

The article explains why transaction isolation is needed, describes common concurrency problems such as lost updates, dirty reads, non‑repeatable reads and phantom reads, outlines the ACID properties of a transaction, and details MySQL's four isolation levels with their effects and default settings.

ACIDLost Updateconcurrency
0 likes · 8 min read
Understanding Transaction Isolation Levels and Concurrency Issues in MySQL
Java Backend Technology
Java Backend Technology
Oct 13, 2022 · Databases

Choosing Between Driver‑Level and Proxy‑Level Database Middleware for Sharding

This article explains the different layers—encoding, framework, driver, proxy, and implementation—through which database sharding can be introduced, compares driver‑level and proxy‑level middleware, outlines their characteristics, common constraints, and provides a step‑by‑step process for planning, preparing, and executing a sharding project.

Database Middlewaredriver layerjava
0 likes · 13 min read
Choosing Between Driver‑Level and Proxy‑Level Database Middleware for Sharding
IT Architects Alliance
IT Architects Alliance
Oct 12, 2022 · Databases

Master MySQL Execution Order: 8 Proven Techniques to Supercharge Query Performance

This article explains MySQL's execution order and presents eight practical optimizations—including smarter LIMIT usage, implicit conversion handling, join‑based updates, mixed sorting, EXISTS rewriting, condition push‑down, early range reduction, and intermediate result push‑down—each illustrated with SQL examples and performance measurements.

Query PerformanceSQL Optimizationdatabase
0 likes · 14 min read
Master MySQL Execution Order: 8 Proven Techniques to Supercharge Query Performance
Top Architect
Top Architect
Oct 12, 2022 · Databases

SQL Execution Order and Performance Optimization Techniques

This article explains the logical execution order of SQL statements, highlights common performance pitfalls such as inefficient LIMIT usage, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, and demonstrates how to rewrite queries with JOINs, early range reduction, CTEs, and other optimizations to achieve dramatically faster execution times.

mysqloptimizationquery
0 likes · 15 min read
SQL Execution Order and Performance Optimization Techniques
Laravel Tech Community
Laravel Tech Community
Oct 10, 2022 · Databases

Optimizing MySQL Pagination for Large Datasets

The article analyzes why MySQL LIMIT pagination becomes slower as the offset grows, demonstrates the performance impact with sample queries on a 500,000‑row table, and presents three optimization strategies—using ordered primary keys, subqueries, and join‑based pagination—to reduce full‑table scans and improve query speed.

indexmysqlpagination
0 likes · 8 min read
Optimizing MySQL Pagination for Large Datasets
dbaplus Community
dbaplus Community
Oct 10, 2022 · Databases

How to Collect Comprehensive MySQL Metrics Using Only Built‑In SHOW Commands

This guide explains how to gather extensive MySQL monitoring data—including connections, buffer cache, locks, SQL activity, statement counts, throughput, server variables, and slow‑query analysis—solely with MySQL's native SHOW statements, providing low‑overhead, real‑time insight for database administrators.

SHOW commandsdatabase metricsmonitoring
0 likes · 10 min read
How to Collect Comprehensive MySQL Metrics Using Only Built‑In SHOW Commands
ITPUB
ITPUB
Oct 10, 2022 · Databases

Inside MySQL Record Buffer: How Server and Storage Engine Exchange Data

This article explains MySQL's two‑layer storage engine architecture, details how the server layer prepares record metadata, and walks through a concrete InnoDB table example to show the exact memory layout and data‑exchange process between the server and storage engine.

InnoDBmysqlrecord buffer
0 likes · 14 min read
Inside MySQL Record Buffer: How Server and Storage Engine Exchange Data
Top Architect
Top Architect
Oct 8, 2022 · Databases

Optimizing MySQL Pagination for Large Datasets: Techniques and Examples

This article analyzes why MySQL LIMIT pagination becomes slower on large tables, demonstrates the performance impact with real query timings, explains the underlying full‑table scan behavior, and presents three practical optimization strategies—including ordered primary‑key scans, sub‑queries, and join‑based approaches—to improve query speed.

Database Optimizationindexingmysql
0 likes · 7 min read
Optimizing MySQL Pagination for Large Datasets: Techniques and Examples
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 8, 2022 · Databases

Handling Special Characters in MySQL Passwords: Issues with $ and #

The article explains why MySQL users created with passwords containing special characters like "$" or "#" may fail to log in, analyzes how shell quoting affects the stored password, demonstrates the problem with scripts and login‑path, and provides practical work‑arounds and version notes.

Special Charactersauthentication_stringlogin-path bug
0 likes · 8 min read
Handling Special Characters in MySQL Passwords: Issues with $ and #
Liangxu Linux
Liangxu Linux
Oct 7, 2022 · Databases

Why MyISAM’s Table Locks Can Outperform InnoDB in High‑Concurrency Scenarios

This article provides a systematic deep‑dive into MySQL table‑lock mechanics, comparing storage engines, explaining the advantages of table locks, detailing lock acquisition and release rules, showing how to monitor lock statistics, and revealing why MyISAM can deliver superior performance for heavy concurrent insert and select workloads despite using only table‑level locking.

Database PerformanceLock MechanismMyISAM
0 likes · 7 min read
Why MyISAM’s Table Locks Can Outperform InnoDB in High‑Concurrency Scenarios
Java High-Performance Architecture
Java High-Performance Architecture
Oct 5, 2022 · Databases

How to Optimize Massive MySQL Tables: Index Tuning, Online DDL, and Batch Deletion Strategies

This article analyzes a large MySQL table with frequent SLA alerts, demonstrates how to identify slow queries using pt‑query‑digest, proposes index redesign and online DDL versus pt‑osc methods, and shows testing, implementation, and batch‑delete techniques to dramatically reduce query time and maintenance overhead.

Batch DeletionDatabase MaintenanceIndex Optimization
0 likes · 17 min read
How to Optimize Massive MySQL Tables: Index Tuning, Online DDL, and Batch Deletion Strategies
dbaplus Community
dbaplus Community
Oct 3, 2022 · Databases

Why MySQL Unique Indexes Still Allow Duplicates and How to Fix Them

This article explains why a MySQL InnoDB table with a unique index can still contain duplicate rows—especially when indexed columns contain NULL values or when logical deletion is used—and presents several practical strategies, including schema changes and alternative locking mechanisms, to enforce true uniqueness.

Database designLogical DeleteUnique Index
0 likes · 13 min read
Why MySQL Unique Indexes Still Allow Duplicates and How to Fix Them
Top Architect
Top Architect
Oct 1, 2022 · Databases

How to Locate and Optimize Slow SQL Queries in MySQL

This article explains how to enable and configure MySQL's slow query log, set appropriate thresholds, use EXPLAIN to analyze execution plans, and apply index optimizations to dramatically reduce query execution time for large tables.

explainindexesmysql
0 likes · 10 min read
How to Locate and Optimize Slow SQL Queries in MySQL
ITPUB
ITPUB
Sep 30, 2022 · Databases

21 Essential MySQL Table Design Rules Every Backend Engineer Should Follow

This guide presents 21 practical MySQL table design guidelines covering naming conventions, field types, primary key strategies, indexing, logical deletion, common columns, storage engines, character sets, time types, relationship modeling, sharding considerations, and SQL optimization tips for robust backend development.

best practicesmysqlschema
0 likes · 19 min read
21 Essential MySQL Table Design Rules Every Backend Engineer Should Follow
Bilibili Tech
Bilibili Tech
Sep 30, 2022 · Databases

Database Failure Management: Types, Mitigation Strategies, and Bilibili’s Practices

The article outlines common database and cache failures—such as instance outages, replication lag, data corruption, and cache avalanches—while detailing Bilibili’s mitigation strategies including high‑availability architectures, scaling, multi‑active designs, proxy controls, slow‑query alerts, fault‑injection drills, and ongoing resilience improvements.

BilibiliCachedatabase
0 likes · 17 min read
Database Failure Management: Types, Mitigation Strategies, and Bilibili’s Practices
macrozheng
macrozheng
Sep 30, 2022 · Databases

Why MySQL count(*) Slows Down on Large Tables and How to Optimize It

This article explains how MySQL's count() works across different storage engines, compares the performance of various count() forms, and offers practical strategies—such as using EXPLAIN rows, auxiliary count tables, and batch processing—to obtain accurate or approximate row counts efficiently even on massive tables.

InnoDBMyISAMSQL Optimization
0 likes · 13 min read
Why MySQL count(*) Slows Down on Large Tables and How to Optimize It
Tencent Database Technology
Tencent Database Technology
Sep 29, 2022 · Databases

MySQL Memory Monitoring Improvements in InnoDB 8.0.28

The article details the refactoring of memory monitoring in MySQL 8.0.28, introducing a new PFS metadata structure for precise tracking of memory allocations and deallocations across various components like Buffer Pool and user variables.

Database OptimizationInnoDBMemory Monitoring
0 likes · 9 min read
MySQL Memory Monitoring Improvements in InnoDB 8.0.28
21CTO
21CTO
Sep 28, 2022 · Databases

How to Optimize Large MySQL Tables: Index Tuning, Online DDL, and Batch Deletion

This article walks through diagnosing slow‑query problems on a massive MySQL table, reveals index misuse, proposes dropping the old composite index, adding targeted indexes, using online DDL or pt‑osc for schema changes, and applying batch‑delete techniques to reduce latency and storage fragmentation.

Batch DeletionIndex OptimizationLarge Tables
0 likes · 14 min read
How to Optimize Large MySQL Tables: Index Tuning, Online DDL, and Batch Deletion
Top Architect
Top Architect
Sep 28, 2022 · Databases

Optimizing Large MySQL Tables: Slow‑Query Analysis, Index Tuning, and Efficient Deletion

This article details a comprehensive performance investigation of a massive MySQL table, using pt‑query‑digest to analyze slow queries, exposing index inefficiencies, proposing index redesign, demonstrating backup/restore with mydumper, comparing online DDL and pt‑osc for index rebuilding, and recommending small‑batch deletions to reduce latency and maintenance overhead.

BackupDDLIndex Optimization
0 likes · 15 min read
Optimizing Large MySQL Tables: Slow‑Query Analysis, Index Tuning, and Efficient Deletion
Su San Talks Tech
Su San Talks Tech
Sep 28, 2022 · Databases

Why MySQL Queries Slow Down and How to Speed Them Up

This article explains the common reasons MySQL queries become sluggish—beyond missing indexes—including connection limits, buffer pool size, and query cache, and provides practical solutions such as profiling, adjusting connection pools, tuning InnoDB settings, and using force index.

Connection Poolbuffer poolindexing
0 likes · 16 min read
Why MySQL Queries Slow Down and How to Speed Them Up
Wukong Talks Architecture
Wukong Talks Architecture
Sep 27, 2022 · Databases

MySQL Large Table Index Optimization and Delete Performance Tuning

This article analyzes a MySQL large‑table performance issue caused by slow queries and full‑table scans, demonstrates using pt‑query‑digest, explains execution plans, proposes index redesign, shows backup and restore with mydumper, compares online DDL and pt‑osc, and presents batch delete strategies to reduce latency.

Batch DeleteDDLDatabase Performance
0 likes · 13 min read
MySQL Large Table Index Optimization and Delete Performance Tuning
JD Cloud Developers
JD Cloud Developers
Sep 27, 2022 · Databases

Unveiling MySQL’s Inner Workings: From SQL Query to InnoDB Storage Engine

This article demystifies MySQL’s processing pipeline by tracing a simple UPDATE statement through the application, service, and storage engine layers, detailing connection handling, SQL parsing, optimization, execution, buffer pool management, and the roles of undo and redo logs in ensuring data integrity.

Database ArchitectureInnoDBSQL Execution
0 likes · 18 min read
Unveiling MySQL’s Inner Workings: From SQL Query to InnoDB Storage Engine
Java Backend Technology
Java Backend Technology
Sep 27, 2022 · Databases

Optimizing Massive MySQL Tables: Index Tuning, Online DDL & Batch Deletion

Facing SLA alerts due to slow queries on a billion‑row MySQL table, the article analyzes slow‑query logs, reveals index misuse, and demonstrates how removing a poor composite index, adding targeted indexes, employing online DDL or pt‑osc, and using batch deletions dramatically reduce query times and maintenance overhead.

Batch DeletionLarge TablesOnline DDL
0 likes · 16 min read
Optimizing Massive MySQL Tables: Index Tuning, Online DDL & Batch Deletion
Code Ape Tech Column
Code Ape Tech Column
Sep 27, 2022 · Databases

How to Quickly Locate and Optimize Slow Query SQL in MySQL

This guide explains how to enable MySQL slow query logging, set appropriate thresholds, locate inefficient SQL statements via logs and EXPLAIN, and optimize queries by using indexes and analyzing execution plans, with practical examples and code snippets.

SQL Optimizationexplainindex
0 likes · 11 min read
How to Quickly Locate and Optimize Slow Query SQL in MySQL
dbaplus Community
dbaplus Community
Sep 25, 2022 · Databases

How to Speed Up MySQL Deep Pagination on Millions of Rows

This article explains why using LIMIT with large offsets slows MySQL queries, analyzes the execution flow, and presents four practical optimization techniques—including subqueries, INNER JOIN, bookmark (tag‑record) method, and BETWEEN range scans—backed by real‑world performance data and code examples.

B+Treemysqloptimization
0 likes · 10 min read
How to Speed Up MySQL Deep Pagination on Millions of Rows
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 24, 2022 · Databases

Weekly Database and Big Data Article Highlights

This weekly roundup presents a curated selection of high‑quality technical articles and resources on MySQL, database error‑log analysis, big‑data task optimization, SQL injection case studies, and upcoming SQLE development plans, offering readers up‑to‑date insights into database engineering and performance best practices.

Big DataSQL AuditingTech Newsletter
0 likes · 4 min read
Weekly Database and Big Data Article Highlights
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 23, 2022 · Databases

SQLE 1.2209.0-pre3 Release Notes: Project Overview, New Features, and Full Release Information

The SQLE 1.2209.0-pre3 preview release introduces CloudBeaver integration, unified login, automated SQL compliance checks, and several bug fixes, while providing project background, detailed feature demonstrations, full release notes, and links to documentation, demos, and community resources.

CloudBeaverDatabase AuditingRelease Notes
0 likes · 4 min read
SQLE 1.2209.0-pre3 Release Notes: Project Overview, New Features, and Full Release Information
dbaplus Community
dbaplus Community
Sep 22, 2022 · Databases

Why MySQL IN Subqueries Turn Into Slow Full Scans—and How to Fix Them

A large‑scale user‑push system suffers from minutes‑long MySQL queries because the IN subquery materializes a temporary table and triggers a semi‑join that forces full table scans, but disabling the semi‑join optimizer or rewriting the query restores sub‑second performance.

SQL OptimizationSemi-Joinexecution plan
0 likes · 8 min read
Why MySQL IN Subqueries Turn Into Slow Full Scans—and How to Fix Them
Liangxu Linux
Liangxu Linux
Sep 21, 2022 · Databases

Essential MySQL Performance Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor & pt-query-digest

This guide explains why regular MySQL health checks are crucial and introduces four open‑source performance tools—mysqltuner.pl, tuning-primer.sh, pt‑variable‑advisor, and pt‑query‑digest—detailing how to download, run, and interpret their reports to optimize configuration, detect bottlenecks, and improve security.

PerconaTuningmysql
0 likes · 9 min read
Essential MySQL Performance Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor & pt-query-digest
Alibaba Cloud Developer
Alibaba Cloud Developer
Sep 21, 2022 · Databases

How Elastic Multi‑Node Parallel Query Supercharges PolarDB MySQL Performance

This article explains the background, concept, advantages, applicable scenarios, technical implementation, and performance evaluation of Elastic Parallel Query (ePQ) in PolarDB MySQL, showing how multi‑node parallelism leverages idle CPU resources, adaptive scheduling, and cloud‑native architecture to accelerate large‑scale analytical workloads while maintaining HTAP capabilities.

Distributed ExecutionElastic Parallel QueryPolardb
0 likes · 29 min read
How Elastic Multi‑Node Parallel Query Supercharges PolarDB MySQL Performance
Practical DevOps Architecture
Practical DevOps Architecture
Sep 21, 2022 · Databases

Understanding MySQL Transaction Isolation Levels: Dirty Read, Non-Repeatable Read, and Phantom Read

This article explains MySQL's four transaction isolation levels, illustrating how concurrent transactions can cause dirty reads, non‑repeatable reads, and phantom reads through detailed examples of two transactions interacting via SELECT, UPDATE, and INSERT operations, and summarizes the consistency issues each scenario creates.

databasesdirty readmysql
0 likes · 4 min read
Understanding MySQL Transaction Isolation Levels: Dirty Read, Non-Repeatable Read, and Phantom Read
Java Backend Technology
Java Backend Technology
Sep 20, 2022 · Databases

Does SELECT FOR UPDATE Lock Rows or the Whole Table in MySQL?

This article explains how MySQL's SELECT … FOR UPDATE adds a pessimistic lock, and demonstrates that using an indexed column or primary key results in a row lock, while lacking an index causes a table lock, with step‑by‑step verification using multiple transaction examples.

SELECT FOR UPDATEmysqlrow lock
0 likes · 4 min read
Does SELECT FOR UPDATE Lock Rows or the Whole Table in MySQL?
Su San Talks Tech
Su San Talks Tech
Sep 19, 2022 · Databases

How InnoDB Locates the First Record in a B‑Tree Scan Range

This article explains why locating a record in a B‑Tree index is crucial for MySQL InnoDB operations, describes scan intervals, index page structures, and details the step‑by‑step binary and sequential search process used to find the first matching record, including performance optimizations.

B-TreeBinary SearchIndex Scan
0 likes · 28 min read
How InnoDB Locates the First Record in a B‑Tree Scan Range
Top Architect
Top Architect
Sep 17, 2022 · Databases

Optimizing Large MySQL Tables: Index Tuning, Slow Query Analysis, and Efficient Deletion Strategies

This article details a comprehensive analysis of a large MySQL table's performance issues, including slow query diagnostics with pt‑query‑digest, index evaluation, backup and restore procedures, online DDL versus pt‑osc, and practical strategies for index redesign and batch deletions to reduce latency and maintenance overhead.

DDLDatabase MaintenanceIndex Optimization
0 likes · 14 min read
Optimizing Large MySQL Tables: Index Tuning, Slow Query Analysis, and Efficient Deletion Strategies
DaTaobao Tech
DaTaobao Tech
Sep 16, 2022 · Databases

Investigation of Hanging Transactions and Lock Wait Timeout in MySQL InnoDB

The article investigates MySQL InnoDB lock‑wait timeouts caused by hanging transactions that lack proper commit or rollback, explains ACID and lock mechanisms, shows how stale ThreadLocal bindings let pooled threads reuse unfinished transactions, and recommends using @Transactional with robust try‑catch handling to prevent such deadlocks.

HangingTransactionInnoDBLock
0 likes · 14 min read
Investigation of Hanging Transactions and Lock Wait Timeout in MySQL InnoDB
FunTester
FunTester
Sep 16, 2022 · Industry Insights

Future‑Proof Your Software Testing Career: A Complete Skill Roadmap

Amid the current tech hiring slowdown, this guide outlines a comprehensive learning roadmap for software testers, covering fundamentals, Linux, shell scripting, web fundamentals, databases, packet‑capture tools, API testing, automation frameworks, mobile testing, TestOps, and performance and security testing to help engineers stay competitive and advance their careers.

AppiumJMeterLinux
0 likes · 17 min read
Future‑Proof Your Software Testing Career: A Complete Skill Roadmap
Architecture Digest
Architecture Digest
Sep 15, 2022 · Databases

Case Study: Resolving Deep Pagination Slow Queries in MySQL

This article walks through a real‑world incident caused by deep pagination in a MySQL‑based system, detailing the timeline of symptoms, root‑cause analysis, and a series of optimizations—including ID‑based queries, range scans, and rolling cursor techniques—that ultimately restored stable performance.

Database PerformanceIndex Optimizationdeep pagination
0 likes · 10 min read
Case Study: Resolving Deep Pagination Slow Queries in MySQL
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Sep 14, 2022 · Databases

Master MySQL: 3 Normal Forms, Engine Differences, Indexing, Transactions & More

This comprehensive guide covers MySQL fundamentals such as the three normal forms, differences between MyISAM and InnoDB, redo log versus binlog, when queries bypass indexes, join types, various index structures, covering indexes, back‑row lookups, transaction properties and isolation levels, common performance bottlenecks, replication mechanics, lag mitigation, storage behavior after deletes, VARCHAR limits, lock types, systematic SQL tuning steps, the purpose and trade‑offs of indexes, B+‑tree advantages, MVCC internals, and the Snowflake distributed ID algorithm.

ReplicationTransactionsindexing
0 likes · 24 min read
Master MySQL: 3 Normal Forms, Engine Differences, Indexing, Transactions & More
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 14, 2022 · Databases

DTLE 4.22.07.2 Release Notes – New Features, Fixes and Resources

The DTLE 4.22.07.2 release introduces performance‑boosting pipeline enhancements for large transactions, continuous insert optimizations, data chunking for massive loads, a new DumpEntryLimit setting, and bug fixes, while providing repository links, documentation, and recommended articles for further exploration.

DTLEData TransferRelease Notes
0 likes · 4 min read
DTLE 4.22.07.2 Release Notes – New Features, Fixes and Resources
Liangxu Linux
Liangxu Linux
Sep 13, 2022 · Databases

How to Find and Remove Duplicate Rows in SQL

This guide explains how to identify duplicate rows in a MySQL table using GROUP BY and HAVING, how to delete the extra rows while keeping the earliest entry, and how to handle duplicate detection across multiple columns with correct query patterns and common pitfalls.

DELETEGROUP BYHAVING
0 likes · 11 min read
How to Find and Remove Duplicate Rows in SQL
Java Backend Technology
Java Backend Technology
Sep 13, 2022 · Databases

Master‑Slave MySQL Replication & Read‑Write Splitting with ShardingJDBC: A Step‑by‑Step Guide

This article explains why a single MySQL instance can become a bottleneck, introduces asynchronous master‑slave replication using binary logs, provides detailed configuration commands for both master and slave servers, and shows how to achieve read‑write splitting in Java projects with ShardingJDBC, including dependency setup, YAML configuration, and testing procedures.

ReplicationShardingJDBCdatabase
0 likes · 11 min read
Master‑Slave MySQL Replication & Read‑Write Splitting with ShardingJDBC: A Step‑by‑Step Guide
Su San Talks Tech
Su San Talks Tech
Sep 13, 2022 · Databases

Top 20 MySQL Query Optimization Tips to Boost Performance

This article presents a comprehensive list of MySQL optimization best practices, covering SELECT field selection, WHERE clause design, data type choices, index usage, join strategies, batch operations, UNION handling, and many other techniques to reduce resource consumption, improve query speed, and ensure efficient database management.

Query Performanceindexesmysql
0 likes · 17 min read
Top 20 MySQL Query Optimization Tips to Boost Performance
dbaplus Community
dbaplus Community
Sep 12, 2022 · Databases

How to Resolve Deep Pagination Performance Problems in MySQL

This article walks through a real‑world incident caused by MySQL deep pagination, explains how the slow queries and CPU spikes were diagnosed, and presents several concrete optimization techniques—including ID‑based queries, range scans, sub‑queries and cursor‑based pagination—culminating in a stable production fix.

SQL Optimizationdatabasedeep pagination
0 likes · 10 min read
How to Resolve Deep Pagination Performance Problems in MySQL
MaGe Linux Operations
MaGe Linux Operations
Sep 12, 2022 · Databases

Master MySQL Monitoring with Built‑in SHOW Commands: A Complete Guide

This article explains how to collect comprehensive MySQL performance metrics using only native SHOW commands, covering connections, buffer pool, locks, SQL statements, throughput, server variables, and slow‑query analysis, while also offering practical tips for interpreting and optimizing the results.

monitoringmysqlslow-query
0 likes · 10 min read
Master MySQL Monitoring with Built‑in SHOW Commands: A Complete Guide
Java Architect Essentials
Java Architect Essentials
Sep 12, 2022 · Databases

Why MySQL Discourages UUIDs as Primary Keys: Performance Comparison with Auto‑Increment and Random Keys

This article investigates MySQL's recommendation against using UUIDs as primary keys by creating three tables (auto‑increment, UUID, and random snowflake IDs), benchmarking insert speeds with Spring Boot/JdbcTemplate, analyzing index structures, and discussing the advantages and drawbacks of each key strategy.

auto_incrementmysqlperformance
0 likes · 10 min read
Why MySQL Discourages UUIDs as Primary Keys: Performance Comparison with Auto‑Increment and Random Keys
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 9, 2022 · Databases

SQLE 1.2209.0-pre1 Release Notes and Feature Overview

The preview release SQLE 1.2209.0-pre1 introduces OceanBase TopSQL auditing, Alibaba Cloud RDS MySQL audit‑log support, and a sub‑query nesting rule, while providing project background, download links, demo environments, and a detailed list of new features and release notes for database professionals.

Database ToolsOceanBaseRDS
0 likes · 5 min read
SQLE 1.2209.0-pre1 Release Notes and Feature Overview
Architecture Digest
Architecture Digest
Sep 9, 2022 · Databases

MySQL Replication, High Availability, and Sharding Strategies

This article explains the evolution from single‑node MySQL to master‑slave replication, various replication modes, high‑availability solutions such as MHA and MGR, and the challenges and techniques of vertical and horizontal sharding for scaling large‑scale internet applications.

Distributed TransactionsReplicationdatabase scaling
0 likes · 12 min read
MySQL Replication, High Availability, and Sharding Strategies
ITPUB
ITPUB
Sep 8, 2022 · Databases

Master MySQL Performance: 5 Key Optimization Strategies You Must Know

This guide explores five essential dimensions of MySQL performance tuning—including connection configuration, architectural choices such as caching and read‑write splitting, optimizer settings, storage engine selection, and schema design—providing concrete commands, formulas, and best‑practice recommendations to accelerate query execution and reduce load.

Database Architecturemysqlperformance tuning
0 likes · 20 min read
Master MySQL Performance: 5 Key Optimization Strategies You Must Know
Top Architect
Top Architect
Sep 8, 2022 · Databases

When to Use MySQL Multi‑Table Joins vs. Service‑Layer Joins: Performance and Architectural Trade‑offs

The article compares MySQL's limited join capabilities with PostgreSQL's richer options, explains why multi‑table joins can be slower than separate single‑table queries performed in the service layer, and outlines how decomposing joins improves caching, scalability, and overall system performance.

Database ArchitectureJOINService Layer
0 likes · 8 min read
When to Use MySQL Multi‑Table Joins vs. Service‑Layer Joins: Performance and Architectural Trade‑offs