BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 4 of 50
Top Architect
Top Architect
Mar 30, 2026 · Backend Development

Why Upgrading to MyBatis‑Plus Breaks LocalDateTime Mapping and How to Fix It

A newcomer replaced MyBatis with MyBatis‑Plus in an old MySQL‑based project, triggering a "Conversion not supported for type java.time.LocalDateTime" error, which was traced to MyBatis 3.5.1 dropping built‑in type handling and an outdated mysql‑connector‑java, and resolved by upgrading the connector and adjusting validation logic.

ConnectorJavaLocalDateTime
0 likes · 10 min read
Why Upgrading to MyBatis‑Plus Breaks LocalDateTime Mapping and How to Fix It
Golang Shines
Golang Shines
Mar 30, 2026 · Operations

Docker + MySQL: Why They Clash and How to Avoid Hair‑Pulling Pitfalls

This article analyzes common pitfalls when running MySQL inside Docker containers—such as data loss, resource exhaustion, insecure defaults, networking mishaps, and missing backups—and provides concrete, step‑by‑step remedies including volume persistence, resource limits, custom configs, security hardening, and automated backup strategies.

DockerMySQLResource Limits
0 likes · 11 min read
Docker + MySQL: Why They Clash and How to Avoid Hair‑Pulling Pitfalls
dbaplus Community
dbaplus Community
Mar 29, 2026 · Databases

Why MySQL’s ibtmp1 Swells to 192 GB and How to Stop It

A sudden disk‑usage alarm reveals MySQL’s ibtmp1 temporary tablespace ballooning to 192 GB, and the article walks through why it happens, how to safely clear it, set size limits, and pinpoint the inefficient SQL that caused the explosion.

MySQLSQL optimizationdisk usage
0 likes · 7 min read
Why MySQL’s ibtmp1 Swells to 192 GB and How to Stop It
Architect's Guide
Architect's Guide
Mar 29, 2026 · Databases

Why Top Chinese Tech Giants Choose PostgreSQL Over MySQL

Amid China's push for independent, cloud‑native databases, leading firms like Tencent, Alibaba, Huawei and others have built PostgreSQL‑based solutions, and this article analyzes why PostgreSQL’s richer data types, true sequence objects, extensible ecosystem, advanced replication and licensing advantages make it a preferred choice over MySQL.

MySQLPostgreSQLReplication
0 likes · 9 min read
Why Top Chinese Tech Giants Choose PostgreSQL Over MySQL
ITPUB
ITPUB
Mar 27, 2026 · Databases

AI’s Impact on Open‑Source Databases: MySQL, PostgreSQL, and AliSQL DuckDB

In 2026 the database ecosystem faces fierce competition between MySQL and PostgreSQL, while AI emerges as a new driver prompting open‑source projects like AliSQL to release DuckDB, vector engines and intelligent CLI, reshaping how relational databases serve both transactional and analytical workloads.

AIAliSQLDuckDB
0 likes · 15 min read
AI’s Impact on Open‑Source Databases: MySQL, PostgreSQL, and AliSQL DuckDB
dbaplus Community
dbaplus Community
Mar 26, 2026 · Databases

Six Fatal MySQL Index Traps and How to Avoid Them

A real‑world incident of soaring QPS reveals six common MySQL indexing pitfalls—type mismatches, function usage, left‑most prefix violations, implicit charset conversion, range query side effects, and optimizer mis‑selection—and provides concrete SQL fixes and verification tools to keep queries fast and reliable.

Index OptimizationMySQLQuery Pitfalls
0 likes · 6 min read
Six Fatal MySQL Index Traps and How to Avoid Them
Senior Tony
Senior Tony
Mar 26, 2026 · Databases

Why MySQL Optimizer Picks the Wrong Index and How to Fix It

The MySQL optimizer can select an inappropriate index due to inaccurate statistics or sampling errors, but you can correct this by refreshing statistics with ANALYZE TABLE, increasing sample pages, or explicitly forcing the right index using the FORCE INDEX hint.

ANALYZE TABLEIndex SelectionMySQL
0 likes · 4 min read
Why MySQL Optimizer Picks the Wrong Index and How to Fix It
Alibaba Cloud Developer
Alibaba Cloud Developer
Mar 25, 2026 · Databases

How AliSQL AI Diagnoses and Eliminates MySQL Replication Lag

This article analyzes the severe replication‑delay issues in MySQL master‑slave setups, identifies four typical workload patterns that cause lag, demonstrates how AliSQL's AI assistant pinpoints the root causes, and explains the kernel‑level optimizations that completely remove the delay.

AI diagnosisAliSQLMySQL
0 likes · 13 min read
How AliSQL AI Diagnoses and Eliminates MySQL Replication Lag
Top Architect
Top Architect
Mar 24, 2026 · Databases

How MySQL Router 8.2 Enables Seamless Read/Write Splitting with InnoDB ReplicaSet

MySQL Router 8.2 now supports automatic read/write splitting for InnoDB ReplicaSet clusters, allowing reads to be routed to replicas and writes to the primary without any changes to application code, as demonstrated through configuration steps, connection examples, and practical observations.

ConfigurationDatabase ScalingInnoDB ReplicaSet
0 likes · 5 min read
How MySQL Router 8.2 Enables Seamless Read/Write Splitting with InnoDB ReplicaSet
Code Wrench
Code Wrench
Mar 23, 2026 · Databases

Why Your MySQL Queries Slow Down in Production and How to Fix Them

The article explains why locally fast MySQL queries can become painfully slow in production, identifies three common pitfalls such as ineffective indexes, oversized Go connection pools, and hidden type conversions, and provides concrete optimization techniques spanning index design, query planning, Go‑MySQL integration, and systematic self‑checks.

GoMySQLindexing
0 likes · 9 min read
Why Your MySQL Queries Slow Down in Production and How to Fix Them
Java Architect Essentials
Java Architect Essentials
Mar 23, 2026 · Databases

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

A backend engineer discovers that a massive MySQL table’s auto‑increment INT primary key reached its maximum value, causing insert failures, and walks through detailed analysis, three remediation options—including switching to BIGINT, redesigning IDs, and sharding—plus practical scripts, performance measurements, and lessons learned about concurrency and schema design.

BIGINTMySQLPerformance
0 likes · 10 min read
When MySQL Auto‑Increment Hits Its Limit: Diagnosis and Fixes
Top Architect
Top Architect
Mar 22, 2026 · Databases

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

Discover how to set up MySQL InnoDB ReplicaSet and configure MySQL Router 8.2 for automatic read/write splitting, enabling reads to be routed to replicas and writes to the primary without code changes, complete with step-by-step commands, configuration snippets, and visual verification.

InnoDB ReplicaSetMySQLRead-Write Splitting
0 likes · 6 min read
How to Enable Read/Write Splitting with MySQL Router 8.2 and InnoDB ReplicaSet
JD Tech Talk
JD Tech Talk
Mar 18, 2026 · Databases

Mastering Dynamic JSON Fields in MySQL: Real‑World Cases and Pitfalls

This article explains how to store and query extensible JSON columns in a MySQL‑based system, lists the most useful JSON functions, walks through several real‑world scenarios—including dynamic extension queries and weight‑management cases—identifies subtle bugs caused by null values, and presents step‑by‑step SQL and MyBatis fixes to ensure reliable batch updates.

DynamicFieldsJSONMySQL
0 likes · 15 min read
Mastering Dynamic JSON Fields in MySQL: Real‑World Cases and Pitfalls
Coder Trainee
Coder Trainee
Mar 18, 2026 · Operations

How to Persist Zipkin Traces to MySQL or Elasticsearch

This guide explains why Zipkin loses trace data after a restart when using the default in‑memory storage and provides step‑by‑step instructions to configure persistent storage with MySQL or Elasticsearch, including database setup, SQL schema, startup commands, and verification.

ElasticsearchMySQLPersistence
0 likes · 7 min read
How to Persist Zipkin Traces to MySQL or Elasticsearch
Architecture & Thinking
Architecture & Thinking
Mar 18, 2026 · Databases

10 Common MySQL Index Failure Scenarios and How to Fix Them

Even well‑designed indexes can become ineffective in production, leading to full‑table scans; this article systematically examines ten typical MySQL index‑failure cases—ranging from functions on indexed columns to low selectivity—and provides concrete SQL rewrites, performance comparisons, and diagnostic tools to help developers avoid and resolve these issues.

MySQLOptimizationPerformance
0 likes · 17 min read
10 Common MySQL Index Failure Scenarios and How to Fix Them
dbaplus Community
dbaplus Community
Mar 15, 2026 · Databases

Why MySQL Is Falling Behind PostgreSQL: Commit Trends and Oracle’s Role

The article examines the sharp decline in MySQL’s commit activity since its 2006‑2007 peak, compares recent DB‑Engines rankings that show PostgreSQL overtaking MySQL, and attributes the downturn to Oracle’s management practices, technical setbacks, reduced open‑source community engagement, and a shift toward proprietary alternatives.

Database trendsMySQLOracle
0 likes · 7 min read
Why MySQL Is Falling Behind PostgreSQL: Commit Trends and Oracle’s Role
Java Tech Enthusiast
Java Tech Enthusiast
Mar 13, 2026 · Databases

When Does SELECT * Break Your MySQL Index? A Deep Dive into Index Invalidation

This article explains why using SELECT * does not automatically invalidate MySQL indexes, explores common scenarios that cause index loss such as left‑most prefix violations, function calls, implicit type conversions, wildcard LIKE patterns, OR/IN/NOT IN misuse, and ORDER BY pitfalls, and provides practical optimization recommendations with concrete SQL examples and verification methods.

MySQLOptimizationQuery Tuning
0 likes · 14 min read
When Does SELECT * Break Your MySQL Index? A Deep Dive into Index Invalidation
Architecture & Thinking
Architecture & Thinking
Mar 13, 2026 · Databases

Why MySQL Deep Pagination Slows Down Your E‑commerce Site and How to Fix It

The article explains how deep pagination on massive MySQL tables causes full‑table scans, massive I/O, and memory pressure, then presents six concrete optimization techniques—including delayed join, cursor pagination, covering indexes, ID‑range pagination, caching, and partitioning—backed by a real‑world e‑commerce case study and detailed execution‑plan analysis.

Deep PaginationMySQLPerformance Optimization
0 likes · 18 min read
Why MySQL Deep Pagination Slows Down Your E‑commerce Site and How to Fix It
macrozheng
macrozheng
Mar 12, 2026 · Operations

How to Deploy Apps Visually with Dockge – A Docker Compose GUI Guide

This guide introduces Dockge, a sleek Docker Compose visual manager, and walks through installing it via Docker, creating stacks, and deploying a Spring Boot and MySQL application with one‑click operations, including logs, terminal access, and API testing.

Container ManagementDevOpsDocker
0 likes · 5 min read
How to Deploy Apps Visually with Dockge – A Docker Compose GUI Guide
Black & White Path
Black & White Path
Mar 11, 2026 · Information Security

ByPassTamperPlus: Enhanced SQLMap Tamper Scripts for Advanced WAF Bypass

ByPassTamperPlus is a Python‑based collection of SQLMap tamper scripts tailored for MSSQL, MySQL and Oracle across multiple versions, employing version‑specific syntax, functions and obfuscation techniques to improve payload survivability against modern Web Application Firewalls, while acknowledging inherent limitations.

MSSQLMySQLOracle
0 likes · 6 min read
ByPassTamperPlus: Enhanced SQLMap Tamper Scripts for Advanced WAF Bypass
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.

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

Index OptimizationMySQLSQL
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.

MySQLReplicationbackup
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 DevelopmentDockerGo
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.

EXPLAINIndex OptimizationMySQL
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.

Index OptimizationMySQLdatabase tuning
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.

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

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

BinlogLogical BackupMySQL
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.

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

AuditMySQLTLS
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 SELECTMySQLSQL
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.

Memory TableMySQLQuery Cache
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.

Master-Slave ReplicationMySQLProxySQL
0 likes · 12 min read
MySQL Practical Guide #17: Building a High‑Availability Service with Master‑Slave Replication, Read‑Write Splitting, and Load Balancing
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 TechniquesMySQLPerformance
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.

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

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

Materialized ViewsMySQLOptimization
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.

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

Index OptimizationInnoDBMySQL
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+ 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 DorisMySQLOLAP
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.

MySQLPerformancedatabase-optimization
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.

InnoDB ReplicaSetMySQLRead-Write Splitting
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.

Data TypesMySQLcharacter set
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.

JOIN optimizationMySQLSQL
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.

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