BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 4 of 50
Senior Xiao Ying
Senior Xiao Ying
Feb 13, 2026 · Databases

Master MySQL Indexes: Deep Dive into B+ Tree Structure and Optimization Strategies

This guide explains MySQL’s B+‑tree index architecture, compares clustered and secondary indexes, demonstrates covering and prefix indexes, outlines design principles such as high‑selectivity columns and the left‑most prefix rule, and shows how to use EXPLAIN and real‑world examples to diagnose and improve query performance.

B+TreeCovering IndexEXPLAIN
0 likes · 12 min read
Master MySQL Indexes: Deep Dive into B+ Tree Structure and Optimization Strategies
Tech Musings
Tech Musings
Feb 12, 2026 · Databases

From MySQL to Apache Doris: Key Design Shifts for OLAP Migration

This article explains how backend engineers should rethink table design, indexing, partitioning, and key strategies when migrating attendance data from MySQL's OLTP model to Apache Doris 2.1.7's OLAP architecture, providing concrete DDL examples and practical tips.

Apache DorisDatabase MigrationIndexing
0 likes · 12 min read
From MySQL to Apache Doris: Key Design Shifts for OLAP Migration
Efficient Ops
Efficient Ops
Feb 11, 2026 · Databases

How Merged Seckill Boosts MySQL Write Throughput by 5× for High‑Concurrency Flash Sales

The article explains a MySQL kernel‑level merged seckill optimization that replaces traditional queue‑based flash‑sale handling, achieving up to 5‑fold throughput gains (up to 1.5 W/s) without requiring SQL changes, detailing background, performance results, bottleneck analysis, design of cache visibility, leader‑follower coordination, row‑lock refinements, binlog parallelism, and crash‑recovery considerations.

MySQLPerformanceSeckill
0 likes · 12 min read
How Merged Seckill Boosts MySQL Write Throughput by 5× for High‑Concurrency Flash Sales
macrozheng
macrozheng
Feb 11, 2026 · Databases

Enable MySQL Router 8.2 Read/Write Splitting with InnoDB ReplicaSet

This guide demonstrates how MySQL Router 8.2 can automatically route read and write traffic using an InnoDB ReplicaSet, showing the minimal architecture, configuration steps, command examples, and the resulting read‑write split behavior without requiring application changes.

Database PerformanceInnoDB ReplicaSetMySQL
0 likes · 4 min read
Enable MySQL Router 8.2 Read/Write Splitting with InnoDB ReplicaSet
Senior Xiao Ying
Senior Xiao Ying
Feb 10, 2026 · Databases

Choosing MySQL Data Types and Constraints for Integrity and Performance

The article explains MySQL’s full range of data types—from integers and floating‑point numbers to strings, binary and temporal types—along with constraint options such as NOT NULL, UNIQUE, CHECK, primary keys and AUTO_INCREMENT, and offers practical guidelines on character sets, collations, and best‑practice selection to ensure data integrity, consistency, and optimal storage and query performance.

Character SetCollationData Types
0 likes · 11 min read
Choosing MySQL Data Types and Constraints for Integrity and Performance
Su San Talks Tech
Su San Talks Tech
Feb 10, 2026 · Databases

10 Must‑Know MySQL Advanced Techniques to Supercharge Performance

This article presents eleven practical MySQL advanced techniques—including EXPLAIN analysis, sophisticated indexing, window functions, CTEs, JSON handling, partitioning, join optimizations, user variables, online DDL, and generated columns—to help developers dramatically improve query performance and scalability in high‑load environments.

Advanced QueriesIndexingMySQL
0 likes · 18 min read
10 Must‑Know MySQL Advanced Techniques to Supercharge Performance
Raymond Ops
Raymond Ops
Feb 8, 2026 · Operations

MySQL Ops Nightmares: Lessons from a 3 AM Production Crash

A seasoned DBA recounts a 3 AM MySQL outage caused by an unindexed query, then shares practical strategies for indexing, connection‑pool sizing, slow‑query tuning, replication lag handling, monitoring, automation, performance tuning, security hardening, and future‑proofing MySQL deployments.

MySQLdatabase operations
0 likes · 14 min read
MySQL Ops Nightmares: Lessons from a 3 AM Production Crash
ITPUB
ITPUB
Feb 7, 2026 · Databases

Why MySQL Excels at Transactions but Falters in Analytics – DuckDB to the Rescue

The article examines why MySQL’s transaction layer remains robust while its analytical capabilities lag, outlines enterprise demands for simultaneous OLTP and OLAP workloads, introduces DuckDB’s lightweight yet powerful engine, describes AliSQL’s integration of DuckDB for full MySQL compatibility, and presents TPCH benchmark results showing a dramatic performance boost for analytical queries.

AliSQLDuckDBMySQL
0 likes · 23 min read
Why MySQL Excels at Transactions but Falters in Analytics – DuckDB to the Rescue
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 6, 2026 · Databases

Rebuilding a MySQL Replica Fast with MyDumper and MyLoader

This guide explains how to use MyDumper for logical backups and MyLoader for fast, parallel replica reconstruction, covering backup parameters, metadata configuration, replication setup, handling faulty replicas, and final restoration steps to ensure data consistency and minimal downtime.

Logical BackupMyDumperMyLoader
0 likes · 11 min read
Rebuilding a MySQL Replica Fast with MyDumper and MyLoader
Xiaohongshu Tech REDtech
Xiaohongshu Tech REDtech
Feb 5, 2026 · Databases

How RedSQL Supercharged MySQL Performance and Achieved Zero‑Data‑Loss Replication

This article details Xiaohongshu's RedSQL MySQL kernel project, describing three major solutions—high‑throughput seckill optimization, a Binlog Server‑based zero‑data‑loss replication scheme, and second‑level DDL column addition—along with additional kernel enhancements that together delivered multi‑fold performance gains and improved stability.

DDLData ConsistencyMySQL
0 likes · 12 min read
How RedSQL Supercharged MySQL Performance and Achieved Zero‑Data‑Loss Replication
IT Services Circle
IT Services Circle
Feb 4, 2026 · Databases

How to Optimize Multi‑Table Joins in MySQL: Practical Strategies

This article explains why excessive MySQL joins—often inherited from legacy or Oracle‑migration code—cause performance and maintenance problems, and presents nine concrete optimization techniques including SQL splitting, temporary tables, redundant fields, index tuning, query rewriting, result‑set reduction, configuration tweaks, big‑data tools, and materialized summary tables.

Database PerformanceMySQLSQL
0 likes · 11 min read
How to Optimize Multi‑Table Joins in MySQL: Practical Strategies
Raymond Ops
Raymond Ops
Feb 3, 2026 · Databases

Master MySQL Performance: From Slow Queries to Billion‑Row Scaling

This guide walks you through diagnosing MySQL bottlenecks, enabling slow‑query logging, using pt‑query‑digest, optimizing indexes, tuning parameters, handling pagination, sharding, and troubleshooting deadlocks, providing concrete commands, scripts, and real‑world examples to boost query speed from seconds to fractions of a second on massive datasets.

IndexingMySQLmonitoring
0 likes · 24 min read
Master MySQL Performance: From Slow Queries to Billion‑Row Scaling
Architect's Guide
Architect's Guide
Feb 3, 2026 · Databases

Why Top Chinese Tech Giants Choose PostgreSQL Over MySQL – Key Benefits

Amid rising demand for open‑source, self‑controlled databases in China, major firms such as Tencent, Alibaba, and Huawei have built PostgreSQL‑based distributed, cloud‑native solutions, citing PostgreSQL’s richer data types, native sequence support, extensible ecosystem, advanced monitoring, robust replication, and true open‑source licensing as decisive advantages over MySQL.

Database ComparisonMySQLPostgreSQL
0 likes · 10 min read
Why Top Chinese Tech Giants Choose PostgreSQL Over MySQL – Key Benefits
21CTO
21CTO
Feb 2, 2026 · Databases

Is Oracle’s Promise a New Era for MySQL? Community Reactions and Risks

Oracle claims a new era for MySQL by moving commercial‑only features to the community edition and adding AI‑focused vector functions, but developers question whether these promises are timely or sufficient, fearing continued neglect of the open‑source community.

AI workloadsDatabase CommunityMySQL
0 likes · 5 min read
Is Oracle’s Promise a New Era for MySQL? Community Reactions and Risks
Java Companion
Java Companion
Feb 1, 2026 · Databases

How I Completed a 100+ Table Migration in One Month Using Navicat Tricks

In under a month the author migrated more than 100 heterogeneous tables from MySQL and MongoDB to PostgreSQL across isolated networks by automating Navicat's import/export logic, streaming data, handling special characters, configuring flexible sync strategies, and using OSS as a bridge to avoid OOM and lock‑contention.

Data MigrationMongoDBMySQL
0 likes · 20 min read
How I Completed a 100+ Table Migration in One Month Using Navicat Tricks
java1234
java1234
Jan 30, 2026 · Backend Development

How to Reduce MyBatis Batch Insert from 5 Minutes to 3 Seconds? Three Key Optimizations

The article walks through three concrete optimizations—batch SQL, JDBC batch mode with rewriteBatchedStatements, and multithreaded parallel inserts—that shrink a 100,000‑row MyBatis insertion from five minutes to three seconds, while highlighting configuration details, performance gains, and common pitfalls.

Batch InsertJDBCJava
0 likes · 10 min read
How to Reduce MyBatis Batch Insert from 5 Minutes to 3 Seconds? Three Key Optimizations
Java Companion
Java Companion
Jan 29, 2026 · Backend Development

How to Cut MyBatis Batch Insert Time from 5 Minutes to 3 Seconds: Three Key Optimizations

The article walks through turning a naïve MyBatis loop that took five minutes to insert 100,000 rows into a high‑performance solution that finishes in three seconds by applying batch SQL, JDBC batch mode with rewriteBatchedStatements, and multithreaded parallel execution, while highlighting pitfalls and best‑practice configurations.

Batch InsertExecutorType.BATCHJDBC
0 likes · 9 min read
How to Cut MyBatis Batch Insert Time from 5 Minutes to 3 Seconds: Three Key Optimizations
ITPUB
ITPUB
Jan 22, 2026 · Backend Development

Sync New MySQL Tables to Doris in Real‑Time with Flink CDC and CdcTools

This article explains how to use Flink CDC together with the CdcTools utility to automatically capture newly created MySQL tables and synchronize both their schema and data to a Doris database in real time, covering the required code, side‑output handling, async execution, and a special delete‑sign field.

Async IOCDCDoris
0 likes · 10 min read
Sync New MySQL Tables to Doris in Real‑Time with Flink CDC and CdcTools
Programmer XiaoFu
Programmer XiaoFu
Jan 21, 2026 · Databases

How to Add a Column to a Tens‑Million‑Row Order Table Without Locking It

When a tens‑million‑row order table needs a new business column, directly running ALTER TABLE can lock the table and disrupt services, so the article explores master‑slave promotion, online DDL tools, schema‑less JSON extensions, and a clever use of an existing redundant column to achieve the change safely.

DDLMySQLjson
0 likes · 7 min read
How to Add a Column to a Tens‑Million‑Row Order Table Without Locking It
FunTester
FunTester
Jan 21, 2026 · Databases

Mastering MySQL Upserts: INSERT IGNORE, REPLACE INTO, and ON DUPLICATE KEY UPDATE Explained

This article explains three MySQL INSERT variants—INSERT IGNORE, REPLACE INTO, and INSERT ... ON DUPLICATE KEY UPDATE—detailing their syntax, execution behavior, advantages, drawbacks, typical use cases, and practical comparison to help developers choose the most suitable method for handling duplicate or bulk data operations.

Duplicate KeyINSERTMySQL
0 likes · 12 min read
Mastering MySQL Upserts: INSERT IGNORE, REPLACE INTO, and ON DUPLICATE KEY UPDATE Explained
java1234
java1234
Jan 20, 2026 · Databases

Why Do Some Projects Still Choose MySQL Over PostgreSQL?

The article compares PostgreSQL and MySQL, detailing PostgreSQL’s richer data types, true sequence support, extensible ecosystem, advanced monitoring and replication features, while also acknowledging MySQL’s simplicity and strong points, to help readers decide which database fits their workload best.

Database ComparisonMVCCMySQL
0 likes · 9 min read
Why Do Some Projects Still Choose MySQL Over PostgreSQL?
Alibaba Cloud Native
Alibaba Cloud Native
Jan 19, 2026 · Artificial Intelligence

Build a Multi‑Agent Boba Tea Shop with AgentScope Java: A Hands‑On Guide

This article introduces AgentScope Java 1.0.7, showcases its new features such as Ollama integration, Agent Skill support, and Nacos‑based A2A architecture, and walks through a complete boba‑tea‑shop example that demonstrates a Supervisor‑Worker multi‑agent system, ReActAgent configuration, dynamic MCP registration, MySQL session persistence, Mem0 long‑term memory, and AutoContextMemory compression, plus quick deployment options for local, Kubernetes, and Docker environments.

AgentScopeAutoContextMemoryJava
0 likes · 12 min read
Build a Multi‑Agent Boba Tea Shop with AgentScope Java: A Hands‑On Guide
Xiaohongshu Tech REDtech
Xiaohongshu Tech REDtech
Jan 19, 2026 · Databases

How Merged Seckill Boosts MySQL Write Throughput 5× for High‑Traffic E‑Commerce

The article details a MySQL kernel‑level merged‑seckill optimization that replaces traditional queue‑based flash‑sale handling, achieving up to 5.5× higher TPS (up to 23,543 TPS on 128 threads) and sustaining 1.5W+ orders per second, while remaining transparent to applications and preserving compatibility with existing SQL.

CacheDatabaseLock
0 likes · 11 min read
How Merged Seckill Boosts MySQL Write Throughput 5× for High‑Traffic E‑Commerce
Architect's Tech Stack
Architect's Tech Stack
Jan 19, 2026 · Databases

Why Leading Tech Giants Prefer PostgreSQL Over MySQL: A Deep Technical Comparison

The article examines why major Chinese cloud providers and enterprises are building PostgreSQL‑based distributed, cloud‑native databases instead of MySQL, detailing PostgreSQL's richer data types, native sequence support, extensible ecosystem, advanced replication, licensing advantages, and MVCC implementation, while also noting MySQL's remaining strengths.

Data TypesDatabase ComparisonMySQL
0 likes · 10 min read
Why Leading Tech Giants Prefer PostgreSQL Over MySQL: A Deep Technical Comparison
dbaplus Community
dbaplus Community
Jan 18, 2026 · Databases

Avoid These Common SQL Performance Pitfalls for Faster Queries

This guide enumerates frequent misconceptions in SQL performance—from over‑indexing and SELECT * misuse to improper transaction handling and outdated monitoring practices—explains why they hurt efficiency, and provides concrete, version‑aware solutions to optimize queries, schema design, and database operations.

DatabaseMySQLOptimization
0 likes · 26 min read
Avoid These Common SQL Performance Pitfalls for Faster Queries
Raymond Ops
Raymond Ops
Jan 18, 2026 · Databases

How I Cut a 20‑Second MySQL Query to 200 ms: A Step‑by‑Step Optimization Journey

When a critical e‑commerce report took over 20 seconds and triggered a flood of user complaints, a systematic investigation using EXPLAIN, slow‑query logs, and profiling revealed missing indexes, costly joins, and temporary tables, leading to a four‑stage rewrite that reduced execution time to sub‑second performance.

MySQLSQL TuningSlow Query
0 likes · 21 min read
How I Cut a 20‑Second MySQL Query to 200 ms: A Step‑by‑Step Optimization Journey
Java Companion
Java Companion
Jan 18, 2026 · Databases

Why Choose MySQL When PostgreSQL Offers So Many Advantages?

The article compares PostgreSQL and MySQL, highlighting PostgreSQL's richer data types, true sequence support, powerful extensions, built‑in monitoring, advanced replication, open‑source licensing, and MVCC implementation, while acknowledging MySQL's strengths in quick deployment and read‑heavy workloads.

Database ComparisonMVCCMySQL
0 likes · 10 min read
Why Choose MySQL When PostgreSQL Offers So Many Advantages?
Ray's Galactic Tech
Ray's Galactic Tech
Jan 17, 2026 · Databases

Master MySQL Index Execution: From Index Key to Table Filter

This guide explains how MySQL processes queries in three index‑related stages—Index Key, Index Filter, and Table Filter—showing why keeping operations in the index layer dramatically improves performance and how to design and diagnose indexes effectively.

Covering IndexDatabase PerformanceIndex Optimization
0 likes · 9 min read
Master MySQL Index Execution: From Index Key to Table Filter
ITPUB
ITPUB
Jan 16, 2026 · Databases

How Meituan Built a Real‑Time Database Capacity Assessment System

Meituan's database team created a sandbox‑based capacity assessment platform that replays live traffic, uses accelerated replay to discover performance bottlenecks, and closes the loop with capacity monitoring and automated operations, dramatically improving stability and resource utilization.

AutomationDatabase CapacityMySQL
0 likes · 16 min read
How Meituan Built a Real‑Time Database Capacity Assessment System
Architect's Guide
Architect's Guide
Jan 16, 2026 · Databases

How to Safely Update Billions of MySQL Rows Without Overloading Binlog

This article explains why a naïve full‑table UPDATE on massive MySQL tables can cripple replication, explores deep‑pagination and IN‑clause inefficiencies, and presents a batch‑processing strategy using NO_CACHE, FORCE INDEX, and rate‑controlled scripts to perform safe, high‑performance updates.

Batch ProcessingFull Table UpdateMySQL
0 likes · 8 min read
How to Safely Update Billions of MySQL Rows Without Overloading Binlog
macrozheng
macrozheng
Jan 15, 2026 · Databases

Master MySQL Full-Text Search: Inverted Index, Queries, and Best Practices

This guide explains why InnoDB fuzzy queries lose indexes, introduces MySQL full‑text search with inverted indexes, shows how to create and use full‑text indexes via CREATE TABLE and ALTER statements, and demonstrates natural language, boolean, and query‑expansion modes with practical SQL examples.

Boolean ModeDatabaseFull-text Search
0 likes · 12 min read
Master MySQL Full-Text Search: Inverted Index, Queries, and Best Practices
Ray's Galactic Tech
Ray's Galactic Tech
Jan 14, 2026 · Databases

Why MySQL’s B+Tree Indexes Power High‑Performance Queries

This article explains how MySQL implements indexes with B+Tree structures, why they outperform full table scans, the internal layout of leaf and internal nodes, insertion and split mechanics, range‑query processing, and practical optimization tips for clustered and secondary indexes.

B+TreeDatabaseIndex
0 likes · 11 min read
Why MySQL’s B+Tree Indexes Power High‑Performance Queries
Coder Trainee
Coder Trainee
Jan 14, 2026 · Backend Development

How to Build a Simple ERP System in Just a Few Hours

This article walks through creating a lightweight material‑management ERP system—including login, dashboard, inventory, inbound and outbound modules—using Vue 3 for the front end and Spring Boot 3, Java 17, MySQL, and MyBatis‑Plus for the back end, highlighting the architecture and development efficiency tricks employed.

ERPJavaMySQL
0 likes · 7 min read
How to Build a Simple ERP System in Just a Few Hours
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 13, 2026 · Databases

Enforcing Client IP‑Based Access Control in MySQL InnoDB Cluster via Router

This article explains how to overcome MySQL InnoDB Cluster’s IP‑address loss and lack of Proxy Protocol by injecting real client IPs through MySQL Router connection attributes, configuring init_connect, creating a monitoring database and stored procedure, and testing access control for specific user‑IP ranges.

Database SecurityInnoDB ClusterMySQL
0 likes · 8 min read
Enforcing Client IP‑Based Access Control in MySQL InnoDB Cluster via Router
Ray's Galactic Tech
Ray's Galactic Tech
Jan 12, 2026 · Databases

Master MySQL: Production-Ready Database Design & Operations Handbook

An experienced MySQL practitioner shares a comprehensive production‑grade design and operations guide, covering primary key selection, normalization, indexing, data types, sharding, foreign key trade‑offs, naming conventions, transaction handling, NULL usage, type safety, read/write splitting, caching, triggers, logging, monitoring, partitioning, security, and a three‑layer summary.

MySQLSecuritydatabase-design
0 likes · 9 min read
Master MySQL: Production-Ready Database Design & Operations Handbook
Ray's Galactic Tech
Ray's Galactic Tech
Jan 12, 2026 · Databases

How to Safely Add Columns to Billion‑Row MySQL Tables Without Downtime

This guide explains why using a plain ALTER TABLE on massive MySQL tables can lock the table and halt services, and presents tool‑based online DDL, native INPLACE options, phased migration strategies, cloud‑DB features, best‑practice checks, monitoring, and rollback techniques to add new columns safely.

Database MigrationMySQLOnline DDL
0 likes · 8 min read
How to Safely Add Columns to Billion‑Row MySQL Tables Without Downtime
Top Architect
Top Architect
Jan 11, 2026 · Databases

How to Add a Column to a Billion‑Row Order Table Without Locking Production

When a core order table with tens of millions of rows needs a new business field, the article explores why a direct ALTER TABLE can lock the table, evaluates master‑slave switching, online DDL tools, extension tables, JSON fields, and a clever reuse of an existing redundant column, providing practical steps and performance insights.

DDLJSON fieldMySQL
0 likes · 9 min read
How to Add a Column to a Billion‑Row Order Table Without Locking Production
ITPUB
ITPUB
Jan 11, 2026 · Databases

6 Proven Strategies to Add Columns to Billion‑Row MySQL Tables Without Downtime

This article examines why adding a column to a MySQL table with tens of millions of rows can lock the table, then presents six practical solutions—including native online DDL, PT‑OSC, gh‑ost, dual‑write migration, maintenance downtime, and partition sliding‑window—detailing their procedures, trade‑offs, and suitable scenarios.

MySQLOnline DDLdatabase operations
0 likes · 12 min read
6 Proven Strategies to Add Columns to Billion‑Row MySQL Tables Without Downtime
LuTiao Programming
LuTiao Programming
Jan 10, 2026 · Backend Development

How Spring Boot 3 + Apache Calcite Eliminates Cross‑Database Chaos with a Unified Query Layer

This article explains why multi‑source data fragmentation hurts service code, introduces Apache Calcite as a query‑abstraction layer that decouples data location from query logic, and provides step‑by‑step Spring Boot 3 integration, practical code samples, common pitfalls, performance tips, and real‑world scenarios.

Apache CalciteMongoDBMulti-DataSource
0 likes · 11 min read
How Spring Boot 3 + Apache Calcite Eliminates Cross‑Database Chaos with a Unified Query Layer
java1234
java1234
Jan 10, 2026 · Databases

MySQL 8.2 Finally Supports Read/Write Splitting

MySQL 8.2 introduces native read/write splitting via MySQL Router, allowing automatic routing of reads to replicas and writes to the primary in an InnoDB ReplicaSet without any application changes.

Database ScalingInnoDB ReplicaSetMySQL
0 likes · 4 min read
MySQL 8.2 Finally Supports Read/Write Splitting
Java Companion
Java Companion
Jan 9, 2026 · Backend Development

Why Many Large Companies Discourage Using @Transactional in Spring

The article explains common pitfalls that cause Spring @Transactional to fail or not roll back, such as incorrect method visibility, final or static modifiers, internal method calls, beans not managed by Spring, multithreading, unsupported database engines, misconfigured propagation, swallowed exceptions, and improper rollback settings, and offers practical solutions for each case.

AOPJavaMyISAM
0 likes · 18 min read
Why Many Large Companies Discourage Using @Transactional in Spring
Top Architect
Top Architect
Jan 8, 2026 · Backend Development

Why MyBatis‑Plus Migration Fails: LocalDateTime Conversion and Connector Version Issues

A legacy project using MySQL 5.7, MyBatis 3.5.0 and mysql‑connector‑java 5.1.26 encounters a "Conversion not supported for type java.time.LocalDateTime" error after switching to MyBatis‑Plus 3.1.1, which is traced to MyBatis 3.5.1 dropping built‑in LocalDateTime handling and the old connector not supporting the type, requiring an upgrade to mysql‑connector‑java 5.1.37 or later.

JDBC driverLocalDateTimeMyBatis
0 likes · 9 min read
Why MyBatis‑Plus Migration Fails: LocalDateTime Conversion and Connector Version Issues
Smart Sea Tide
Smart Sea Tide
Jan 8, 2026 · Databases

How count(1), count(*) and count(column) Differ in Execution

The article explains that count(1) and count(*) produce identical results and similar execution plans, while count(column) skips NULL values; it also compares their performance under various table schemas and provides a MySQL example demonstrating these differences.

COUNTDatabaseMySQL
0 likes · 4 min read
How count(1), count(*) and count(column) Differ in Execution
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jan 8, 2026 · Databases

Understanding MySQL Transaction Isolation Levels with Practical Examples

This article explains MySQL's four transaction isolation levels—Read Uncommitted, Read Committed, Repeatable Read, and Serializable—by creating a simple table, running paired transactions, and showing how each level affects data visibility, concurrency, and potential anomalies such as dirty reads, non‑repeatable reads, and phantom reads.

Database ConcurrencyInnoDBMySQL
0 likes · 10 min read
Understanding MySQL Transaction Isolation Levels with Practical Examples
IT Services Circle
IT Services Circle
Jan 7, 2026 · Backend Development

What Tencent Backend Engineers Earn and How to Nail Their Interview

This article shares a collected list of 2023 Tencent backend developer compensation packages—showing total first‑year offers starting above 40 W RMB—followed by detailed explanations of interview questions covering Redis caching, MySQL transactions, hot‑key detection, SQL injection, HTTP/HTTPS differences, API timeout troubleshooting, and microservice migration strategies.

Backend SalaryInterview QuestionsMySQL
0 likes · 24 min read
What Tencent Backend Engineers Earn and How to Nail Their Interview
Su San Talks Tech
Su San Talks Tech
Jan 7, 2026 · Databases

Why MySQL NULL Values Can Cause P0 Outages and How to Avoid Them

This article explains how improper use of NULL in MySQL columns can lead to serious production incidents, outlines official recommendations against NULL, demonstrates its impact on queries, indexes, and storage, and provides practical guidelines for when to use or avoid NULL values.

IndexingMySQLNULL
0 likes · 13 min read
Why MySQL NULL Values Can Cause P0 Outages and How to Avoid Them
Efficient Ops
Efficient Ops
Jan 6, 2026 · Databases

Why PostgreSQL Beats MySQL: 10 Technical Advantages Explained

This article compiles a detailed comparison of PostgreSQL and MySQL, highlighting PostgreSQL's lack of text‑size limits, better NULL handling, native array and JSON support, built‑in optimistic locking, superior GIS types, MVCC, flexible indexing, robust replication, and overall stability, while also noting the few areas where MySQL still holds an edge.

Database ComparisonGISJSONB
0 likes · 9 min read
Why PostgreSQL Beats MySQL: 10 Technical Advantages Explained
dbaplus Community
dbaplus Community
Jan 3, 2026 · Databases

When MySQL Auto‑Increment Hits INT Limit: Diagnosis and Fixes

The article recounts a MySQL production incident where an INT auto‑increment column reached its maximum value, causing insert failures, and walks through analysis, three remediation options, a stored‑procedure cleanup, a conversion to BIGINT, performance monitoring, and lessons on concurrency and schema design.

BigIntDatabase PerformanceINT overflow
0 likes · 9 min read
When MySQL Auto‑Increment Hits INT Limit: Diagnosis and Fixes
Tech Freedom Circle
Tech Freedom Circle
Jan 3, 2026 · Databases

How Many Values Can MySQL IN Handle? 100K‑10M IDs and the Ultimate Solution

An interview scenario reveals that using a massive IN list (hundreds of thousands of IDs) in MySQL quickly exceeds packet limits, forces full‑table scans, and overloads CPU, while batch IN queries cause network storms; the article dissects these pitfalls and presents three progressive strategies—splitting IN, temporary tables with JOIN, and sharding with stream‑merge—to safely query massive ID sets.

IN ClauseMySQLQuery Optimization
0 likes · 32 min read
How Many Values Can MySQL IN Handle? 100K‑10M IDs and the Ultimate Solution
Top Architect
Top Architect
Jan 3, 2026 · Databases

How to Safely Add a Column to a Billion‑Row Order Table Without Downtime

When a core order table with tens of millions of rows needs a new business field, executing a plain ALTER TABLE can lock the table and disrupt services, so the article explores master‑slave switching, online schema‑change tools, extension tables, JSON fields, and a clever reuse of an existing redundant column to achieve the change with minimal risk.

DDLMaster‑SlaveMySQL
0 likes · 9 min read
How to Safely Add a Column to a Billion‑Row Order Table Without Downtime
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Jan 3, 2026 · Databases

Essential MySQL Commands Every DBA Should Know

This guide presents a comprehensive collection of essential MySQL commands, covering connection management, database creation and selection, table definition and alteration, CRUD operations, query optimization techniques, performance monitoring, and user permission handling, providing clear examples for each command.

AdministrationDatabaseMySQL
0 likes · 7 min read
Essential MySQL Commands Every DBA Should Know
Ray's Galactic Tech
Ray's Galactic Tech
Jan 2, 2026 · Databases

Is Containerized MySQL Ready for Production? A Deep Comparison with Traditional Deployments

This article provides a comprehensive, production‑grade comparison between containerized MySQL on Kubernetes and traditional on‑premises deployments, clarifying core concepts, evaluating elasticity, availability, performance, and operational overhead, and offering concrete best‑practice recommendations, risk considerations, and future trends.

Database OpsMySQLbest practices
0 likes · 8 min read
Is Containerized MySQL Ready for Production? A Deep Comparison with Traditional Deployments
Top Architect
Top Architect
Jan 2, 2026 · Databases

Boost MySQL Performance: Master Pagination, Indexes, JOINs, and Query Rewrite Techniques

This article walks through common MySQL performance pitfalls such as inefficient pagination, implicit type conversion, costly UPDATE/DELETE subqueries, mixed sorting, and EXISTS clauses, and demonstrates practical rewrites—including index usage, JOIN conversion, condition push‑down, early LIMIT, and WITH‑clauses—to transform slow queries into millisecond‑level executions.

IndexJOINMySQL
0 likes · 13 min read
Boost MySQL Performance: Master Pagination, Indexes, JOINs, and Query Rewrite Techniques
dbaplus Community
dbaplus Community
Jan 2, 2026 · Information Security

How We Built a High‑Performance, Low‑Cost Content Moderation System with Trie + Aho‑Corasick

Faced with minutes‑long posting delays and exploding review costs in a fast‑growing social app, the team introduced 24‑hour shift staffing, a local blacklist stored in MySQL, an in‑memory Trie + Aho‑Corasick matcher, Redis‑driven hot updates and a machine‑audit fallback with a feedback loop, dramatically cutting latency, cost and false‑positives.

Aho-CorasickGoMySQL
0 likes · 33 min read
How We Built a High‑Performance, Low‑Cost Content Moderation System with Trie + Aho‑Corasick
Java Architect Handbook
Java Architect Handbook
Jan 1, 2026 · Databases

COUNT(*), COUNT(1) or COUNT(column) in MySQL? Deep Interview Guide

This article explains the semantic differences, performance characteristics, and optimal usage scenarios of COUNT(*), COUNT(1), and COUNT(column) in MySQL 8.0+, covering engine behavior, indexing effects, common misconceptions, and practical best‑practice recommendations for interview preparation and real‑world development.

COUNTInterviewMySQL
0 likes · 10 min read
COUNT(*), COUNT(1) or COUNT(column) in MySQL? Deep Interview Guide
Ray's Galactic Tech
Ray's Galactic Tech
Dec 30, 2025 · Databases

Why MySQL Indexes Fail and 14 Proven Fixes for Faster Queries

This article explains how MySQL indexes work, enumerates eight common reasons they become ineffective, adds six advanced pitfalls, and provides concrete diagnostic steps and production‑grade optimization techniques to keep queries fast and reliable.

Index OptimizationMySQLQuery Planning
0 likes · 9 min read
Why MySQL Indexes Fail and 14 Proven Fixes for Faster Queries
Top Architect
Top Architect
Dec 29, 2025 · Databases

Why Top Companies Prefer PostgreSQL Over MySQL: A Deep Technical Comparison

The article examines why leading Chinese tech firms are increasingly adopting PostgreSQL instead of MySQL, detailing PostgreSQL‑based products, comparing data‑type support, sequence handling, extensions, monitoring tools, replication mechanisms, licensing, community openness, and MVCC implementation, while also outlining MySQL's limitations.

Database ComparisonMySQLPostgreSQL
0 likes · 11 min read
Why Top Companies Prefer PostgreSQL Over MySQL: A Deep Technical Comparison
Raymond Ops
Raymond Ops
Dec 27, 2025 · Databases

How to Cut MySQL Master‑Slave Lag to 0.2 seconds with Parallel Binlog Replication

This guide explains how to reduce MySQL master‑slave replication delay from seconds to sub‑second levels by configuring LOGICAL_CLOCK parallelism, binlog group‑commit tuning, and slave‑side optimizations, presenting concrete parameter settings, performance test results, monitoring scripts, advanced tips, and common pitfalls.

MySQLParallel ReplicationPerformance Tuning
0 likes · 7 min read
How to Cut MySQL Master‑Slave Lag to 0.2 seconds with Parallel Binlog Replication
Java Backend Technology
Java Backend Technology
Dec 24, 2025 · Databases

Why UUID Primary Keys Slow Down MySQL and How to Optimize Them

Using UUIDs as primary keys in MySQL can dramatically degrade performance on large tables due to larger index size, random inserts causing index splits, slower comparisons, and costly index refreshes on updates, but the impact can be mitigated with ordered UUIDs, binary storage, hybrid keys, or table partitioning.

IndexMySQLprimary key
0 likes · 8 min read
Why UUID Primary Keys Slow Down MySQL and How to Optimize Them
Raymond Ops
Raymond Ops
Dec 23, 2025 · Databases

Master MySQL in Production: From Configuration Tuning to SQL Performance Optimization

This comprehensive guide walks you through a real‑world MySQL outage, then details step‑by‑step configuration tweaks, InnoDB parameter tuning, connection and thread settings, index design, query rewrites, monitoring scripts, backup strategies, high‑availability replication, and essential tooling to keep your database fast and reliable.

MySQLdatabase configurationhigh availability
0 likes · 13 min read
Master MySQL in Production: From Configuration Tuning to SQL Performance Optimization
Architect Chen
Architect Chen
Dec 23, 2025 · Databases

Boost MySQL to 10k QPS: Multi‑Layer Optimization Strategies

When MySQL QPS reaches 10,000, common bottlenecks include CPU saturation, low buffer pool hit rate, connection limits, and lock contention, which can be mitigated through internal tuning, cache interception, read‑write splitting, and horizontal sharding.

MySQLOptimizationPerformance
0 likes · 4 min read
Boost MySQL to 10k QPS: Multi‑Layer Optimization Strategies