BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 3 of 50
Black & White Path
Black & White Path
Apr 16, 2026 · Information Security

Bypassing Alibaba Cloud WAF on a Financial Site via MySQL Chain Comparison

During an authorized penetration test of a financial institution’s website protected by Alibaba Cloud WAF, the author discovered a SQL injection point, used MySQL’s chain‑comparison feature to close the injection, identified the database type, and crafted boolean‑based payloads—including POSITION and binary tricks—to extract the current user name character by character.

Alibaba Cloud WAFBoolean blind injectionMySQL
0 likes · 7 min read
Bypassing Alibaba Cloud WAF on a Financial Site via MySQL Chain Comparison
Architecture & Thinking
Architecture & Thinking
Apr 16, 2026 · Databases

Mastering Database Performance: From Slow Queries to Deadlock Resolution

This guide presents a systematic, end-to-end diagnostic workflow for high-concurrency database environments, covering slow-SQL detection, execution-plan analysis, lock-conflict monitoring, deadlock investigation, and practical optimization techniques, illustrated with real-world cases, commands, and tool integrations to swiftly resolve performance bottlenecks.

Database DiagnosticsDeadlockLock Monitoring
0 likes · 18 min read
Mastering Database Performance: From Slow Queries to Deadlock Resolution
MaGe Linux Operations
MaGe Linux Operations
Apr 15, 2026 · Databases

Why MySQL Binary Logs Fill Up Disk Space and How to Fix It

This article explains how MySQL binary logs can rapidly consume disk space, analyzes the root causes such as log format and workload, provides step‑by‑step diagnostics, and offers practical cleanup, configuration, replication, monitoring, and recovery strategies to prevent and resolve the issue.

Binary LogMySQLPerformance
0 likes · 21 min read
Why MySQL Binary Logs Fill Up Disk Space and How to Fix It
Architect's Guide
Architect's Guide
Apr 14, 2026 · Databases

What Happens When MySQL Auto‑Increment IDs Reach Their Limits?

This article explains how MySQL handles auto‑increment primary keys, InnoDB internal row_id, Xid, trx_id, and thread_id when their numeric limits are reached, illustrating the resulting errors, data overwrites, and potential consistency bugs with practical SQL examples and verification steps.

InnoDBMySQLXid
0 likes · 13 min read
What Happens When MySQL Auto‑Increment IDs Reach Their Limits?
Coder Trainee
Coder Trainee
Apr 14, 2026 · Operations

5 Production Nightmares in an Education Mini‑Program and How to Avoid Them

The author recounts five critical production incidents that crippleed an education mini‑program—Redis connection‑pool exhaustion, duplicate bookings, double refunds, mis‑firing no‑show jobs, and inventory oversell—detailing root causes, concrete fixes, and hard‑won lessons for building resilient backend services.

MySQLRedisSpring Boot
0 likes · 10 min read
5 Production Nightmares in an Education Mini‑Program and How to Avoid Them
MaGe Linux Operations
MaGe Linux Operations
Apr 11, 2026 · Databases

How to Diagnose and Fix MySQL “Too Many Connections” Errors

This guide explains why MySQL reports “Too many connections”, walks through emergency assessment steps, provides practical commands and scripts to stop the bleeding, analyzes root causes such as slow queries, connection leaks, short‑lived connections or low max_connections settings, and offers long‑term remediation and monitoring solutions for production environments.

MySQLToo many connectionslinux
0 likes · 40 min read
How to Diagnose and Fix MySQL “Too Many Connections” Errors
Ops Community
Ops Community
Apr 10, 2026 · Databases

How to Diagnose and Fix MySQL Too Many Connections Errors in Production

When MySQL reports 'Too many connections', this guide walks you through emergency assessment, step‑by‑step diagnostics, quick mitigation scripts, root‑cause analysis of slow queries, connection leaks, short‑connection spikes, and long‑term solutions including parameter tuning, connection‑pool configuration, and Prometheus‑based monitoring to prevent future outages.

AlertmanagerMySQLSlow Query
0 likes · 40 min read
How to Diagnose and Fix MySQL Too Many Connections Errors in Production
Cloud Architecture
Cloud Architecture
Apr 7, 2026 · Databases

MySQL Read‑Write Splitting: From Replication Basics to Production‑Ready Architecture

The article explains why simple SQL routing is insufficient for MySQL read‑write separation, details replication mechanisms, consistency challenges, and presents a comprehensive upgrade path—including static, dynamic, middleware, and hybrid routing strategies, configuration guidelines, monitoring, and high‑availability practices—to build a production‑grade, high‑concurrency architecture.

MySQLReplicationShardingSphere
0 likes · 44 min read
MySQL Read‑Write Splitting: From Replication Basics to Production‑Ready Architecture
Cloud Architecture
Cloud Architecture
Apr 7, 2026 · Databases

Practical Guide to Safely Adding a Column to a Ten‑Million‑Row Order Table: Principles, Architecture, and Production Rollout

This article presents a production‑grade solution for adding a new promotion_type column to a tens‑of‑millions‑row order table, covering MySQL DDL risks, multiple migration strategies, a step‑by‑step implementation using a new table, CDC‑based incremental sync, back‑fill, verification, gray rollout, and rollback procedures.

BackfillCDCGray Deployment
0 likes · 38 min read
Practical Guide to Safely Adding a Column to a Ten‑Million‑Row Order Table: Principles, Architecture, and Production Rollout
Java Architect Handbook
Java Architect Handbook
Apr 7, 2026 · Databases

Master MySQL’s Redo, Undo, and Binlog: Deep Dive for Interview Success

This article provides a comprehensive interview guide on MySQL’s three core logs—redo log, undo log, and binlog—covering their architecture, roles in crash recovery, MVCC, replication, configuration commands, two‑phase commit workflow, and frequent follow‑up questions to help candidates ace database interview questions.

Database InterviewMySQLRedo Log
0 likes · 13 min read
Master MySQL’s Redo, Undo, and Binlog: Deep Dive for Interview Success
java1234
java1234
Apr 7, 2026 · Databases

Why Choose PostgreSQL Over MySQL? A Technical Comparison of Their Strengths

The article analyzes why many Chinese cloud providers and enterprises prefer PostgreSQL to MySQL, detailing PostgreSQL's richer data types, native sequence support, extensible ecosystem, advanced monitoring, robust replication, open licensing, and MVCC implementation, while acknowledging MySQL's remaining advantages in specific scenarios.

Database ComparisonLicensingMVCC
0 likes · 10 min read
Why Choose PostgreSQL Over MySQL? A Technical Comparison of Their Strengths
Java Architect Handbook
Java Architect Handbook
Apr 6, 2026 · Databases

Why MySQL Indexes Still Slow Queries and How to Fix Them

This guide explains the six common reasons why MySQL indexes may fail to improve query speed, shows how interviewers evaluate index knowledge, and provides concrete SQL examples, EXPLAIN analysis, and practical optimization techniques such as redesigning indexes, using covering indexes, avoiding implicit type conversion, and tuning database configuration.

Covering IndexData SkewDatabase Interview
0 likes · 15 min read
Why MySQL Indexes Still Slow Queries and How to Fix Them
MaGe Linux Operations
MaGe Linux Operations
Apr 5, 2026 · Databases

Master MySQL Slow Query Optimization: From Logs to Indexes

This comprehensive guide explains how to detect, analyze, and optimize MySQL slow queries by configuring the slow‑query log, using pt‑query‑digest, interpreting EXPLAIN output, designing effective B+Tree indexes, avoiding common index pitfalls, optimizing count(*) operations, improving deep pagination, rewriting inefficient SQL patterns, and applying advanced table design techniques such as partitioning and sharding.

EXPLAINMySQLPerformance Tuning
0 likes · 40 min read
Master MySQL Slow Query Optimization: From Logs to Indexes
Top Architect
Top Architect
Apr 5, 2026 · Backend Development

Designing a Robust Asynchronous Processing SDK with Spring, Kafka and MySQL

This article explains the design, principles, components, database schema, configuration, and usage of a generic asynchronous processing SDK that leverages Spring AOP, transactional events, Kafka, and a Vue UI to achieve reliable async execution and eventual consistency in Java backend systems.

AsynchronousDesign PatternsMySQL
0 likes · 11 min read
Designing a Robust Asynchronous Processing SDK with Spring, Kafka and MySQL
Top Architect
Top Architect
Apr 3, 2026 · Backend Development

Why Did My Payment Service Lose Data? Uncovering Hidden Transaction Bugs in Spring

A mysterious payment failure where orders appeared successful but were never persisted was traced to a missing transaction commit in a special code path, leading to polluted connections that silently broke subsequent transactions, and the article explains the root cause, debugging steps, fix, and preventive measures.

DatabaseDebuggingMySQL
0 likes · 11 min read
Why Did My Payment Service Lose Data? Uncovering Hidden Transaction Bugs in Spring
Architect's Guide
Architect's Guide
Apr 3, 2026 · Databases

How to Diagnose and Solve MySQL Table Size Bottlenecks

This article explains how to assess MySQL table size using table capacity, disk usage, and instance limits, reveals why large tables slow down due to B+‑tree overhead, and presents three practical solutions—partitioning, sharding, and hot‑cold archiving—to restore query performance.

B+TreeHot Cold ArchivingMySQL
0 likes · 17 min read
How to Diagnose and Solve MySQL Table Size Bottlenecks
Spring Full-Stack Practical Cases
Spring Full-Stack Practical Cases
Apr 3, 2026 · Databases

10 Must‑Know MySQL Advanced Techniques to Supercharge Performance

This article presents ten practical MySQL advanced techniques—including EXPLAIN analysis, composite and covering indexes, index condition push‑down, prefix indexes, window functions, CTEs, JSON handling, partition tables, join optimizations, variables, online DDL, and generated columns—each illustrated with real‑world SQL examples and execution‑plan screenshots to boost efficiency in high‑volume, high‑concurrency environments.

Advanced SQLCTEIndex Optimization
0 likes · 16 min read
10 Must‑Know MySQL Advanced Techniques to Supercharge Performance
MaGe Linux Operations
MaGe Linux Operations
Apr 2, 2026 · Databases

Mastering MySQL 9.0 Replication: Deep Dive into GTID, Semi‑Sync, and Troubleshooting

This comprehensive guide explores MySQL 9.0's replication architecture, covering core principles, GTID and semi‑synchronous modes, various replication topologies, detailed troubleshooting steps, monitoring scripts, and best‑practice configurations, providing hands‑on examples and scripts to help engineers build and maintain robust, high‑availability database systems.

GTIDMySQLPerformance
0 likes · 34 min read
Mastering MySQL 9.0 Replication: Deep Dive into GTID, Semi‑Sync, and Troubleshooting
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.

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

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

MySQLPerformance TuningSQL optimization
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.

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

AIAliSQLDatabase
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 TABLEDatabase PerformanceIndex Selection
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 DiagnosisAliSQLDatabase
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.

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

BigIntDatabase MigrationMySQL
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.

Database PerformanceInnoDB ReplicaSetMySQL
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.

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

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

DatabaseIndexMySQL
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 PaginationIndexingMySQL
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.

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

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

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

MySQLPerformance TuningReplication
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.

DockerGoInterview Questions
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 ComparisonDatabase InterviewMySQL
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 PerformanceEXPLAINIndex Optimization
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 OptimizationMySQLSlow Query
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.

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

InnoDB ReplicaSetMySQLdatabase configuration
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.

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

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

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

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

Cache DesignMemory 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.

MySQLProxySQLhigh availability
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.

Connection ManagementInnoDBMySQL
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.

DBSyncerData synchronizationDocker
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.

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

IndexingMySQLOptimization
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