Skip to content
Tagged articles

MySQL

500 articles · Page 5 of 5
MaGe Linux Operations
MaGe Linux Operations
Mar 9, 2026 · Databases

How to Diagnose and Fix MySQL Replication Lag in Production

This guide explains why MySQL replication lag spikes, how to distinguish IO‑thread pull problems from SQL‑thread apply bottlenecks, provides step‑by‑step commands, configuration examples, real‑world case studies, best‑practice recommendations, and monitoring setups to reliably troubleshoot and prevent replication delays.

LAGMySQLdatabase
0 likes · 16 min read
How to Diagnose and Fix MySQL Replication Lag in Production
JavaGuide
JavaGuide
Mar 9, 2026 · Databases

Does SELECT * Always Invalidate Indexes? Why Some Teams Ban It

While many believe that using SELECT * inevitably disables indexes, MySQL’s optimizer only skips indexes when a full table scan is cheaper, and patterns such as violating the left‑most prefix, applying functions or implicit casts, leading‑wildcard LIKE, OR/IN misuse, and mismatched ORDER BY can cause index invalidation, prompting some companies to forbid SELECT * in production.

MySQLSQLdatabase
0 likes · 14 min read
Does SELECT * Always Invalidate Indexes? Why Some Teams Ban It
SpringMeng
SpringMeng
Mar 9, 2026 · Databases

10 Advanced MySQL Techniques to Supercharge Query Performance

This article walks through ten high‑level MySQL tricks—including EXPLAIN analysis, advanced indexing, window functions, CTEs, JSON handling, partitioning, join optimizations, user‑defined variables, online DDL, and generated columns—showing concrete examples, performance trade‑offs, and step‑by‑step guidance for turning slow queries into lightning‑fast operations.

CTEMySQLPartitioning
0 likes · 15 min read
10 Advanced MySQL Techniques to Supercharge Query Performance
Ops Community
Ops Community
Mar 8, 2026 · Databases

How to Diagnose and Fix MySQL Production Performance Drops

This comprehensive guide walks you through identifying the root causes of MySQL performance degradation in production, from gathering baseline metrics and analyzing slow‑query logs to examining execution plans, tuning parameters, applying configuration changes, and verifying improvements with concrete monitoring and backup strategies.

MySQLbackupdatabase optimization
0 likes · 30 min read
How to Diagnose and Fix MySQL Production Performance Drops
Golang Shines
Golang Shines
Mar 8, 2026 · Backend Development

240 Go Interview Questions with Answers – Master Them in 3 Passes to Land the Job

This article compiles a comprehensive set of 240 Go interview questions—including fundamentals, concurrency, runtime, and related topics such as containers, Redis, and MySQL—each paired with answers, offering candidates a structured study guide to repeatedly practice and improve their chances of securing a Go development position.

Backend DevelopmentConcurrencyDocker
0 likes · 15 min read
240 Go Interview Questions with Answers – Master Them in 3 Passes to Land the Job
Golang Shines
Golang Shines
Mar 7, 2026 · Databases

160 Must‑Know MySQL Interview Questions to Test Your Skills

This article compiles 160 high‑frequency MySQL interview questions, covering fundamentals such as SQL basics, MySQL vs. Oracle vs. Sql Service, the three normal forms, and MySQL permission tables, helping readers prepare thoroughly for database interview challenges.

Database InterviewMySQLSQL
0 likes · 4 min read
160 Must‑Know MySQL Interview Questions to Test Your Skills
Ops Community
Ops Community
Mar 6, 2026 · Databases

Master MySQL Index Optimization: Deep Dive into EXPLAIN Execution Plans

This article provides a hands‑on guide to MySQL index optimization, deeply exploring EXPLAIN execution plans, new features in MySQL 8/8.4, practical index design principles, step‑by‑step SQL examples, common pitfalls, advanced techniques like functional and descending indexes, and comprehensive monitoring and troubleshooting strategies.

Database PerformanceEXPLAINMySQL
0 likes · 28 min read
Master MySQL Index Optimization: Deep Dive into EXPLAIN Execution Plans
Architect-Kip
Architect-Kip
Mar 4, 2026 · Databases

Master MySQL Naming, Field, and Index Standards for Scalable Databases

This guide presents a comprehensive set of mandatory and recommended conventions for MySQL database objects—including table, column, and index naming, field design rules, index selection principles, and best‑practice development tips—to help engineers build maintainable, high‑performance schemas.

MySQLdatabase best practicesindex design
0 likes · 22 min read
Master MySQL Naming, Field, and Index Standards for Scalable Databases
MaGe Linux Operations
MaGe Linux Operations
Mar 4, 2026 · Databases

Master MySQL Performance: From Slow Query Analysis to Index Tuning

This guide walks through the full MySQL performance optimization workflow, covering slow‑query logging, pt‑query‑digest analysis, EXPLAIN interpretation, index design (including covering indexes and index‑condition pushdown), InnoDB buffer‑pool tuning, connection‑pool settings, real‑time diagnostics, monitoring metrics, and best‑practice recommendations for large‑scale production databases.

MySQLdatabase tuningindex optimization
0 likes · 22 min read
Master MySQL Performance: From Slow Query Analysis to Index Tuning
Java Backend Technology
Java Backend Technology
Mar 4, 2026 · Databases

Is MySQL Dying? Why MariaDB and PostgreSQL Offer Safer, Faster Alternatives

The article analyzes MySQL's dwindling open‑source credibility, mounting security vulnerabilities, performance regressions, and Oracle's commercial lock‑in, contrasting it with MariaDB's transparent development and the growing migration of applications to MariaDB or PostgreSQL for better security and performance.

Database SecurityMariaDBMySQL
0 likes · 8 min read
Is MySQL Dying? Why MariaDB and PostgreSQL Offer Safer, Faster Alternatives
dbaplus Community
dbaplus Community
Feb 27, 2026 · Databases

Understanding MySQL Locks: From Global to Row‑Level and Deadlock Prevention

The article explains why concurrent transactions cause data inconsistencies, describes MySQL’s lock hierarchy—including global, table, and row locks—covers AUTO_INCREMENT locking, illustrates lock compatibility tables, details common deadlock scenarios, and offers practical strategies such as fixed access order, optimistic locking, short transactions, proper indexing, and isolation‑level tuning to prevent deadlocks.

ConcurrencyDeadlockInnoDB
0 likes · 18 min read
Understanding MySQL Locks: From Global to Row‑Level and Deadlock Prevention
Alibaba Cloud Developer
Alibaba Cloud Developer
Feb 27, 2026 · Databases

How DuckDB Compression Supercharges AliSQL Storage and Cuts MySQL Costs

AliSQL integrates DuckDB as its storage engine to achieve high‑density columnar compression and fast analytical scans, detailing DuckDB’s multi‑layer storage format, adaptive compression algorithm selection, performance benchmarks versus InnoDB, HBase, ClickHouse, OceanBase, and the engineering optimizations AliSQL adds for throughput and cost reduction.

AliSQLData CompressionDuckDB
0 likes · 12 min read
How DuckDB Compression Supercharges AliSQL Storage and Cuts MySQL Costs
Java Architect Handbook
Java Architect Handbook
Feb 27, 2026 · Databases

Enable MySQL Read/Write Splitting with Router 8.2 and InnoDB ReplicaSet

MySQL 8.2 introduces native read/write splitting via MySQL Router, allowing automatic routing of reads to replicas and writes to the primary source; this guide shows how to set up a simple InnoDB ReplicaSet, configure Router, verify traffic flow, and leverage access mode commands for fine‑grained control.

Database ConfigurationInnoDB ReplicaSetMySQL
0 likes · 6 min read
Enable MySQL Read/Write Splitting with Router 8.2 and InnoDB ReplicaSet
Senior Xiao Ying
Senior Xiao Ying
Feb 27, 2026 · Databases

How to Recover Lost MySQL Data: Physical, Logical, and PITR Backup Guide

This article provides a comprehensive MySQL data‑loss recovery guide, covering logical and physical backup methods, their advantages and drawbacks, detailed command‑line examples, XtraBackup installation, full and incremental backups, compression and streaming, and point‑in‑time recovery using binary logs, along with core backup best‑practice principles.

Logical BackupMySQLPITR
0 likes · 12 min read
How to Recover Lost MySQL Data: Physical, Logical, and PITR Backup Guide
Senior Xiao Ying
Senior Xiao Ying
Feb 26, 2026 · Databases

Vertical vs Horizontal Sharding in MySQL: Strategy Selection and Middleware Guide

The article explains vertical and horizontal sharding concepts, compares their advantages and drawbacks, evaluates popular sharding middleware such as ShardingSphere, details distributed ID generation with Snowflake, offers cross‑database query solutions, and provides practical guidance on when and how to apply sharding in MySQL.

Cross-Database QueriesHorizontal ShardingMySQL
0 likes · 13 min read
Vertical vs Horizontal Sharding in MySQL: Strategy Selection and Middleware Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 26, 2026 · Databases

Essential MySQL Replication Best Practices to Keep Your Replicas Stable

This guide presents practical, DBA‑tested MySQL replication best practices—including GTID, row‑based replication, mandatory primary keys, schema consistency, binlog tuning, read‑only protection, dedicated replication users, latency monitoring, parallel workers, and SSL encryption—to ensure reliable, predictable replica behavior.

GTIDMySQLRow-Based Replication
0 likes · 9 min read
Essential MySQL Replication Best Practices to Keep Your Replicas Stable
SpringMeng
SpringMeng
Feb 26, 2026 · Databases

Why Choose MySQL When PostgreSQL Offers So Many Advantages?

The article analyzes why many leading Chinese tech firms adopt PostgreSQL despite MySQL’s popularity, detailing PostgreSQL’s richer data types, native sequence support, extensible ecosystem, advanced monitoring tools, robust replication, open‑source licensing, and MVCC implementation, while also acknowledging MySQL’s strengths in simple deployment and read‑heavy workloads.

MVCCMySQLPostgreSQL
0 likes · 9 min read
Why Choose MySQL When PostgreSQL Offers So Many Advantages?
Ops Community
Ops Community
Feb 25, 2026 · Databases

Hardening MySQL 8.4: Permissions, SSL, Auditing & Compliance Guide

This guide provides a step‑by‑step, production‑ready hardening plan for MySQL 8.4, covering permission hierarchy design, strong password policies, audit‑log configuration, TLS encryption, network access controls, firewall rules, backup scripts, monitoring metrics, and best‑practice recommendations to meet PCI‑DSS and Chinese GB/T 22239 compliance.

ComplianceHardeningMySQL
0 likes · 27 min read
Hardening MySQL 8.4: Permissions, SSL, Auditing & Compliance Guide
php Courses
php Courses
Feb 25, 2026 · Backend Development

Why Choose PDO Over mysqli? A Complete Guide to PHP Database Connections

This guide explains the advantages of using PDO instead of mysqli for PHP database connections, walks through MySQL and PostgreSQL setup with detailed code examples, recommended configuration options, and a checklist for troubleshooting common connection errors.

BackendMySQLPDO
0 likes · 7 min read
Why Choose PDO Over mysqli? A Complete Guide to PHP Database Connections
ITPUB
ITPUB
Feb 24, 2026 · Databases

Why INSERT … SELECT Can Lock Your Table and How an Index Saves the Day

A real‑world MySQL incident shows that using INSERT … SELECT without proper indexing can cause full‑table scans and progressive row locks, leading to massive payment failures, but adding an index on the filter column prevents the lock and restores safe batch migration.

INSERT SELECTIndexMySQL
0 likes · 8 min read
Why INSERT … SELECT Can Lock Your Table and How an Index Saves the Day
Senior Xiao Ying
Senior Xiao Ying
Feb 24, 2026 · Databases

Mastering MySQL Performance: Connection Pool Tuning, Built‑in Cache, and Application‑Level Caching

This guide walks through three defensive layers for MySQL performance—optimizing the connection pool, configuring the query cache and memory tables, and designing multi‑level application caches (including Cache‑Aside, Write‑Through, and Redis integration) with concrete code examples and best‑practice recommendations.

Connection PoolMemory TableMySQL
0 likes · 13 min read
Mastering MySQL Performance: Connection Pool Tuning, Built‑in Cache, and Application‑Level Caching
dbaplus Community
dbaplus Community
Feb 23, 2026 · Databases

How to Diagnose and Optimize a Minute‑Long MySQL Join Query

This article walks through a real‑world MySQL slow‑query case, explains the inner workings of Join and Order by algorithms, shows how to interpret EXPLAIN and Optimizer_trace output, and demonstrates how adding an index can transform a costly Block Nested‑Loop Join into a fast Index Nested‑Loop Join, dramatically improving performance.

EXPLAINJoin AlgorithmsMySQL
0 likes · 13 min read
How to Diagnose and Optimize a Minute‑Long MySQL Join Query
Senior Xiao Ying
Senior Xiao Ying
Feb 23, 2026 · Databases

MySQL Practical Guide #17: Building a High‑Availability Service with Master‑Slave Replication, Read‑Write Splitting, and Load Balancing

By configuring master‑slave replication, implementing read‑write splitting with ProxySQL, and selecting appropriate load‑balancing strategies, you can significantly improve MySQL’s scalability and availability while addressing replication lag through parallel or semi‑synchronous replication, hardware tuning, and monitoring.

High AvailabilityMaster-Slave ReplicationMySQL
0 likes · 12 min read
MySQL Practical Guide #17: Building a High‑Availability Service with Master‑Slave Replication, Read‑Write Splitting, and Load Balancing
Senior Xiao Ying
Senior Xiao Ying
Feb 22, 2026 · Databases

Why Is Your SQL Slow? Deep Dive into Common MySQL Slow Query Patterns and Optimizations

This guide explains how to configure MySQL's slow query log, use pt‑query‑digest to analyze logs, identifies common slow‑query patterns such as full table scans, large sorts, N+1 queries, implicit type conversion and bad joins, and provides concrete rewrite and indexing techniques to optimize each case.

MySQLUNION Optimizationindex optimization
0 likes · 12 min read
Why Is Your SQL Slow? Deep Dive into Common MySQL Slow Query Patterns and Optimizations
IT Services Circle
IT Services Circle
Feb 21, 2026 · Databases

10 MySQL Advanced Techniques to Supercharge Performance

This article presents ten practical MySQL advanced tricks—including execution‑plan analysis, sophisticated indexing, window functions, CTEs, JSON handling, partitioning, join optimizations, user variables, online DDL, and generated columns—to help developers tackle high‑concurrency, large‑scale workloads and dramatically boost database performance.

Advanced TechniquesMySQLdatabase optimization
0 likes · 17 min read
10 MySQL Advanced Techniques to Supercharge Performance
Senior Xiao Ying
Senior Xiao Ying
Feb 21, 2026 · Databases

Boost MySQL Performance: Deep Parameter Tuning to Eliminate Slowness

This guide walks through MySQL’s core memory, I/O, connection, and system variable settings—explaining each parameter’s role, recommended values, and example commands—so you can systematically adjust the configuration, monitor key metrics, and achieve up to three‑fold performance gains.

Connection ManagementDatabase ConfigurationInnoDB
0 likes · 9 min read
Boost MySQL Performance: Deep Parameter Tuning to Eliminate Slowness
Su San Talks Tech
Su San Talks Tech
Feb 20, 2026 · Backend Development

How to Sync MySQL to Elasticsearch with DBSyncer: A Step‑by‑Step Guide

This guide introduces the open‑source DBSyncer tool, explains its key features, shows how to install it via Docker, and provides detailed step‑by‑step examples of synchronizing MySQL tables to another MySQL instance and to Elasticsearch, including configuration, field mapping, and verification.

DBSyncerDockerElasticsearch
0 likes · 6 min read
How to Sync MySQL to Elasticsearch with DBSyncer: A Step‑by‑Step Guide
Senior Xiao Ying
Senior Xiao Ying
Feb 19, 2026 · Databases

Designing MySQL Partition Strategies for Billion‑Row Tables: A Complete Guide

This article explains MySQL partition types (RANGE, LIST, HASH, KEY), demonstrates partition pruning, details maintenance commands, presents real‑world use cases such as time‑series and massive tables, and offers best‑practice recommendations for key selection, partition count, automation, and query optimization.

MySQLPartitioningSQL
0 likes · 12 min read
Designing MySQL Partition Strategies for Billion‑Row Tables: A Complete Guide
Senior Xiao Ying
Senior Xiao Ying
Feb 18, 2026 · Databases

Beyond SELECT: Creating, Optimizing, and Securing MySQL Views and Materialized Views

This article explains MySQL view fundamentals, outlines update limitations, demonstrates INSTEAD OF triggers and stored procedures as workarounds, details two methods for simulating materialized views—including scheduled table refreshes and trigger‑based real‑time updates—covers optimization techniques, and shows role‑based permission management for both regular and materialized views.

MySQLmaterialized viewsoptimization
0 likes · 13 min read
Beyond SELECT: Creating, Optimizing, and Securing MySQL Views and Materialized Views
Java Tech Enthusiast
Java Tech Enthusiast
Feb 16, 2026 · Databases

10 Must‑Know MySQL Advanced Techniques to Supercharge Performance

This article presents eleven practical MySQL advanced techniques—including execution‑plan analysis, sophisticated indexing, window functions, CTEs, JSON handling, partitioning, join optimizations, user variables, online DDL, and generated columns—each explained with real‑world examples, code snippets, and performance caveats to help developers move from basic usage to mastery.

MySQLSQLadvanced
0 likes · 20 min read
10 Must‑Know MySQL Advanced Techniques to Supercharge Performance
Senior Xiao Ying
Senior Xiao Ying
Feb 14, 2026 · Databases

Deep Dive into MySQL Query Optimizer: From Writing SQL to Controlling Performance

This article explains MySQL’s query execution pipeline—from parsing to the storage engine—details the cost‑based optimizer’s model, shows how it evaluates index choices versus full‑table scans, demonstrates using optimizer hints and FORCE INDEX, and provides monitoring commands and best‑practice recommendations for effective query tuning.

Cost-Based OptimizationIndex SelectionMySQL
0 likes · 9 min read
Deep Dive into MySQL Query Optimizer: From Writing SQL to Controlling Performance
Architect Chen
Architect Chen
Feb 13, 2026 · Databases

Boost MySQL Performance: Proven Tuning, Indexing, and Scaling Strategies

This guide presents practical MySQL optimization techniques—including SQL and index refinement, InnoDB and connection parameter tuning, cache layer integration, and architectural scaling with read‑write splitting and sharding—to dramatically increase query throughput and reduce latency.

InnoDBMySQLScaling
0 likes · 6 min read
Boost MySQL Performance: Proven Tuning, Indexing, and Scaling Strategies
ITPUB
ITPUB
Feb 13, 2026 · Big Data

Real‑Time Sync of New MySQL Tables to Doris Using Flink CDC

This article explains how to extend a Flink CDC job that already syncs an entire MySQL database to Doris so that newly created tables are automatically created in Doris in real time, using the CdcTools utility, side‑output streams, and asynchronous I/O.

CDCCdcToolsDoris
0 likes · 9 min read
Real‑Time Sync of New MySQL Tables to Doris Using Flink CDC
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* treeEXPLAINMySQL
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 MigrationMySQL
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.

MySQLdatabase-optimizationhigh-concurrency
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.

MySQLcharacter-setcollation
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 QueriesJSONMySQL
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.

DDLMySQLPerformance Optimization
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.

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

MySQLPostgreSQLdatabase comparison
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.

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

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

ExecutorType.BATCHJDBCJava
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.

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

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

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

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

MySQLPostgreSQLdata types
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.

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

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

Database PerformanceMySQLSQL
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.

Database CapacityMySQLTraffic Replay
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 ModeInverted IndexMySQL
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* treeIndexInnoDB
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.

ERPJavaMyBatis Plus
0 likes · 7 min read
How to Build a Simple ERP System in Just a Few Hours