BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 28 of 50
Java High-Performance Architecture
Java High-Performance Architecture
Jan 5, 2023 · Databases

Scaling Billions of Orders: MySQL Sharding, ES & Hive Strategies

This article explains how to handle massive order volumes by classifying data into hot and cold tiers, storing them in MySQL, Elasticsearch, and Hive, and implementing sharding and partitioning strategies—including shard keys, modulo routing, and combined database‑table distribution—to achieve high throughput and low cost.

Database ScalingElasticsearchHive
0 likes · 8 min read
Scaling Billions of Orders: MySQL Sharding, ES & Hive Strategies
Top Architect
Top Architect
Jan 5, 2023 · Backend Development

Resolving Overselling in High‑Concurrency Flash Sale: Seven Locking and Queue Strategies in SpringBoot

This article analyzes why simple @Transactional and lock annotations still cause overselling in flash‑sale scenarios, then presents seven backend solutions—including improved controller locking, AOP locking, pessimistic and optimistic database locks, and queue‑based approaches with BlockingQueue and Disruptor—along with code samples and JMeter test results.

ConcurrencyDistributedSystemsJMeter
0 likes · 20 min read
Resolving Overselling in High‑Concurrency Flash Sale: Seven Locking and Queue Strategies in SpringBoot
dbaplus Community
dbaplus Community
Jan 4, 2023 · Databases

Mastering MySQL Indexes: Costs, Pitfalls, and Best Practices

This article walks through practical MySQL index usage, illustrating space and time costs, back‑table overhead, covering indexes and index condition pushdown, common scenarios where indexes fail, and concrete best‑practice guidelines, all demonstrated with a 5‑million‑row InnoDB table and real SQL examples.

InnoDBMySQLSQL
0 likes · 15 min read
Mastering MySQL Indexes: Costs, Pitfalls, and Best Practices
Laravel Tech Community
Laravel Tech Community
Jan 3, 2023 · Information Security

MySQL Injection Techniques: Detecting Vulnerabilities, Determining Field Count, Using UNION SELECT, and Exploiting load_file()

This article explains how to identify MySQL injection points, determine the number of columns with ORDER BY, enumerate fields via UNION SELECT, leverage common MySQL functions, and exploit the load_file() function—including char() encoding, replace, substring, and INTO OUTFILE—to read or write files on the target system.

MySQLSQL injectionUNION SELECT
0 likes · 11 min read
MySQL Injection Techniques: Detecting Vulnerabilities, Determining Field Count, Using UNION SELECT, and Exploiting load_file()
Liangxu Linux
Liangxu Linux
Jan 2, 2023 · Databases

13 Must‑Know MySQL Functions and Tricks for Everyday Development

This guide walks through a collection of practical MySQL functions and commands—including GROUP_CONCAT, CHAR_LENGTH, LOCATE, REPLACE, NOW, INSERT…SELECT, INSERT…IGNORE, SELECT FOR UPDATE, ON DUPLICATE KEY UPDATE, SHOW CREATE TABLE, CREATE TABLE … SELECT, EXPLAIN, SHOW PROCESSLIST and mysqldump—providing clear syntax, example queries, result screenshots and key usage notes to help developers write more efficient and reliable SQL.

Data MigrationDatabaseMySQL
0 likes · 14 min read
13 Must‑Know MySQL Functions and Tricks for Everyday Development
Laravel Tech Community
Laravel Tech Community
Jan 2, 2023 · Databases

Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Rewrite, and More

This article presents a series of practical MySQL performance‑tuning methods—including smarter LIMIT usage, handling implicit type conversion, rewriting UPDATE/DELETE with JOIN, mixed‑order optimization, EXISTS replacement, condition push‑down, early result filtering, and CTE usage—to dramatically reduce query execution time across common scenarios.

CTEJOINLIMIT
0 likes · 13 min read
Advanced MySQL Query Optimization Techniques: LIMIT, Implicit Conversion, Join Rewrite, and More
ITPUB
ITPUB
Jan 2, 2023 · Databases

Mastering MySQL Sharding: When and How to Split Databases and Tables

Facing massive user and order data growth, this article examines storage options, compares relational, NoSQL, and NewSQL databases, and provides a detailed guide to implementing MySQL‑based sharding with proxy and client modes, key selection, partition strategies, migration steps, and future scaling considerations.

Data MigrationMySQLdatabase partitioning
0 likes · 12 min read
Mastering MySQL Sharding: When and How to Split Databases and Tables
ITPUB
ITPUB
Jan 1, 2023 · Databases

Why Single-Node MySQL Fails and Distributed Databases Are the Future

Even non-programmers notice MySQL’s growing pains—large tables, oversized databases, and read-heavy workloads—prompting a shift toward distributed databases, where sharding, read/write separation, and cloud-native solutions like TiDB or Aurora replace traditional middleware, marking the end of single-node MySQL dominance.

Database ScalingMiddlewareMySQL
0 likes · 7 min read
Why Single-Node MySQL Fails and Distributed Databases Are the Future
ITPUB
ITPUB
Dec 31, 2022 · Databases

15 Must‑Know Interview Questions on Database Sharding and Partitioning

This article explains why and when to split databases and tables, how to choose sharding keys, various sharding strategies such as range, hash and consistent hash, handling cross‑node joins, pagination, distributed IDs, middleware choices, and step‑by‑step zero‑downtime migration techniques.

MySQLscalabilitysharding
0 likes · 17 min read
15 Must‑Know Interview Questions on Database Sharding and Partitioning
Architect
Architect
Dec 30, 2022 · Databases

Database Sharding and Partitioning Strategy for High‑Volume Order Systems

The article explains how to handle billions of daily orders by classifying data into hot and cold segments, storing them in MySQL, Elasticsearch, and Hive, and applying sharding and partitioning techniques at both table and database levels to achieve scalable performance.

Data PartitioningElasticsearchHive
0 likes · 9 min read
Database Sharding and Partitioning Strategy for High‑Volume Order Systems
Java Backend Technology
Java Backend Technology
Dec 29, 2022 · Databases

Why MySQL Must Evolve: From Single‑Node Limits to Distributed Databases

The article explains how traditional single‑node MySQL faces scalability challenges such as massive tables, resource exhaustion, and read‑heavy workloads, and argues that adopting sharding, middleware, or modern distributed databases like TiDB, OceanBase, Aurora, and PolarDB is the inevitable path forward for robust data management.

Cloud DatabaseDatabase ScalingMySQL
0 likes · 6 min read
Why MySQL Must Evolve: From Single‑Node Limits to Distributed Databases
macrozheng
macrozheng
Dec 28, 2022 · Databases

Why Single‑Node MySQL Won’t Scale and How to Move to Distributed Databases

The article explains the limitations of standalone MySQL, outlines common scaling problems such as oversized tables and high read traffic, and compares middleware‑based sharding solutions with modern distributed databases, highlighting why the latter are becoming the preferred choice for growing applications.

Database ScalingMiddlewareMySQL
0 likes · 6 min read
Why Single‑Node MySQL Won’t Scale and How to Move to Distributed Databases
Java Architect Essentials
Java Architect Essentials
Dec 27, 2022 · Backend Development

Building a Scalable Follow Service with MySQL, Redis Sets, and Spring Boot

This article walks through the design and implementation of a friend‑follow microservice using MySQL for persistence, Redis Sets for fast set operations, and Spring Boot, covering requirement analysis, data modeling, dependency setup, configuration, service logic, and testing with concrete code examples and performance insights.

Follow ServiceJavaMicroservices
0 likes · 19 min read
Building a Scalable Follow Service with MySQL, Redis Sets, and Spring Boot
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 27, 2022 · Databases

Understanding How MySQL Converts Uncorrelated Subqueries to Correlated Subqueries and Their Execution Plans

This article explains the process by which MySQL transforms uncorrelated IN subqueries into correlated subqueries, details the differences in EXPLAIN output columns, explores optimizer trace information, compares materialization versus correlated execution costs, and provides best‑practice recommendations for writing efficient queries.

Database PerformanceMySQLSubquery
0 likes · 15 min read
Understanding How MySQL Converts Uncorrelated Subqueries to Correlated Subqueries and Their Execution Plans
政采云技术
政采云技术
Dec 27, 2022 · Databases

Comprehensive Guide to MySQL Backup Types, Tools, and Procedures

This article provides an in‑depth overview of MySQL backup classifications—including hot, warm, and cold backups—explains physical versus logical backup methods, compares built‑in and third‑party tools such as mysqldump, mysqlhotcopy, LVM snapshots, XtraBackup, and presents step‑by‑step command examples for each approach.

Data RecoveryLVMMySQL
0 likes · 14 min read
Comprehensive Guide to MySQL Backup Types, Tools, and Procedures
Top Architect
Top Architect
Dec 26, 2022 · Databases

Understanding Transaction Isolation and Concurrency Issues in MySQL

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

ACIDIsolationMySQL
0 likes · 8 min read
Understanding Transaction Isolation and Concurrency Issues in MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 26, 2022 · Databases

MySQL Replication Delay Analysis and Troubleshooting for Large Transactions

The article describes a MySQL 5.7.31 replication delay where Seconds_Behind_Master fluctuates between 0 and over 10,000 seconds, analyzes root causes such as single‑threaded replication, large or long‑running transactions, and provides preventive, diagnostic, and remediation steps including enabling parallel replication and using the infobin tool.

DatabaseLarge TransactionsMySQL
0 likes · 10 min read
MySQL Replication Delay Analysis and Troubleshooting for Large Transactions
ITPUB
ITPUB
Dec 24, 2022 · Databases

Master MySQL: 13 Essential Functions and Commands Every Developer Should Know

This guide walks you through 13 practical MySQL techniques—from aggregating values with GROUP_CONCAT and measuring string length with CHAR_LENGTH, to locating substrings, replacing text, retrieving timestamps, bulk inserting data, handling duplicate keys, inspecting table structures, and using diagnostic commands like EXPLAIN and SHOW PROCESSLIST—complete with ready‑to‑run SQL examples and visual results.

DatabaseEXPLAINGROUP_CONCAT
0 likes · 13 min read
Master MySQL: 13 Essential Functions and Commands Every Developer Should Know
ITPUB
ITPUB
Dec 23, 2022 · Databases

Understanding Database Transaction Isolation: From ACID Basics to TDSQL Implementation

This article explains the ACID properties of database transactions, clarifies the often‑confused concepts of consistency and isolation, details the four SQL standard isolation levels, compares lock‑based and MVCC concurrency controls, and examines concrete implementations in MySQL, PostgreSQL, and the distributed TDSQL system.

ACIDMVCCMySQL
0 likes · 28 min read
Understanding Database Transaction Isolation: From ACID Basics to TDSQL Implementation
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 23, 2022 · Databases

SQLE 2.2212.0-pre3 Release Notes and New Features

The SQLE 2.2212.0-pre3 pre‑release introduces DingTalk‑integrated workflow approvals, adds phone‑number based user binding, and includes several feature enhancements, optimizations, and bug fixes, with full release details, download links, and references to prior versions and related resources.

Database AuditingDingTalk IntegrationMySQL
0 likes · 4 min read
SQLE 2.2212.0-pre3 Release Notes and New Features
MaGe Linux Operations
MaGe Linux Operations
Dec 22, 2022 · Databases

MySQL 5.7 Parallel Replication: Architecture, Config & Performance Gains

This article explains MySQL 5.7’s enhanced multi‑threaded slave (MTS) parallel replication, contrasting it with the schema‑based approach of MySQL 5.6, detailing its group‑commit mechanism, configuration parameters, GTID handling, performance testing, and practical tuning tips for optimal replication throughput.

ConfigurationDatabase PerformanceGTID
0 likes · 14 min read
MySQL 5.7 Parallel Replication: Architecture, Config & Performance Gains
Top Architect
Top Architect
Dec 22, 2022 · Databases

Understanding MySQL utf8 Limitations and Why You Should Use utf8mb4

This article explains why MySQL's traditional utf8 charset cannot store 4‑byte characters such as emojis, demonstrates the resulting insert errors, and shows how switching the database, system, and column collations to utf8mb4 resolves the issue while also providing a brief history of MySQL's charset implementation.

MySQLSQLcharacter encoding
0 likes · 9 min read
Understanding MySQL utf8 Limitations and Why You Should Use utf8mb4
DeWu Technology
DeWu Technology
Dec 21, 2022 · Databases

InnoDB Storage Architecture and Transaction Persistence Mechanisms

The article explains MySQL InnoDB’s internal storage hierarchy—from tablespaces, segments, and extents to pages and rows—its physical components such as buffer pool, change buffer, adaptive hash index, redo and binary logs, persistence techniques like double‑write buffering and log‑flushing policies, and how two‑phase commit and SQL execution interact, helping developers write correct, high‑performance applications.

InnoDBMySQLPersistence
0 likes · 33 min read
InnoDB Storage Architecture and Transaction Persistence Mechanisms
Selected Java Interview Questions
Selected Java Interview Questions
Dec 21, 2022 · Databases

13 Popular MySQL Graphical Management Tools

This article introduces thirteen widely used MySQL graphical management tools, describing each tool's main features, platform support, and official download links to help developers choose the most suitable database client for their workflow.

Beekeeper StudioDBeaverDataGrip
0 likes · 9 min read
13 Popular MySQL Graphical Management Tools
Java Backend Technology
Java Backend Technology
Dec 21, 2022 · Databases

Master MySQL: 14 Essential Functions & Commands Every Developer Should Know

This guide walks through fourteen practical MySQL techniques—from aggregating rows with group_concat and measuring string length with char_length, to locating substrings, replacing text, retrieving timestamps, bulk inserting, handling duplicates, using pessimistic locks, inspecting tables, explaining queries, monitoring processes, and exporting data with mysqldump.

MySQLQuery OptimizationSQL Functions
0 likes · 13 min read
Master MySQL: 14 Essential Functions & Commands Every Developer Should Know
NiuNiu MaTe
NiuNiu MaTe
Dec 21, 2022 · Databases

Why Is MySQL OFFSET Slow? B+ Tree Index Insights & K‑th Largest Query Optimization

This article examines how MySQL uses secondary indexes to find the K‑th largest value, analyzes the O(N) time complexity caused by offset pagination, explains the underlying B+‑tree double‑linked list behavior, and presents three optimization strategies—including index covering, pagination redesign, and boundary prediction—to dramatically improve performance.

B+TreeMySQLPagination
0 likes · 10 min read
Why Is MySQL OFFSET Slow? B+ Tree Index Insights & K‑th Largest Query Optimization
Top Architect
Top Architect
Dec 19, 2022 · Databases

Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL

This article investigates MySQL's recommendation against using UUID or non‑sequential keys, builds three tables with auto‑increment, UUID, and random (snowflake) primary keys, runs insertion and query benchmarks using Spring Boot and JdbcTemplate, analyzes index structures, and discusses the advantages and drawbacks of each approach.

MySQLPerformancedatabase-index
0 likes · 11 min read
Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL
Su San Talks Tech
Su San Talks Tech
Dec 19, 2022 · Databases

Master MySQL: 14 Essential Functions and Commands Every Developer Should Know

This article walks through a collection of practical MySQL techniques—including group_concat, char_length, locate, replace, now, insert‑select variations, pessimistic locking, on duplicate key update, show create table, explain, processlist, and mysqldump—illustrated with SQL examples and screenshots to help developers efficiently query, manipulate, and maintain their databases.

Data manipulationDatabase FunctionsMySQL
0 likes · 13 min read
Master MySQL: 14 Essential Functions and Commands Every Developer Should Know
dbaplus Community
dbaplus Community
Dec 18, 2022 · Backend Development

Mastering Cache Consistency: Strategies to Keep Redis and MySQL in Sync

This article explores the challenges of cache‑database consistency under the cache‑aside pattern, compares four cache‑update strategies, and provides practical techniques—including delayed double delete, MQ‑driven invalidation, and binlog subscription—to achieve near‑real‑time consistency while maintaining high read performance.

Cache AsideCache ConsistencyMySQL
0 likes · 17 min read
Mastering Cache Consistency: Strategies to Keep Redis and MySQL in Sync
iQIYI Technical Product Team
iQIYI Technical Product Team
Dec 16, 2022 · Databases

Database Mesh 2.0 and Pisanix: Cloud‑Native Database Governance at iQIYI

iQIYI adopts SphereEx’s Database Mesh 2.0 by extending ShardingSphere‑JDBC and integrating the cloud‑native Pisanix proxy, creating a unified, encrypted configuration center that enables dynamic sharding, load‑balancing, read‑write separation, hot‑updates and observability, dramatically simplifying database governance and cloud migration.

Database MeshMySQLPisanix
0 likes · 14 min read
Database Mesh 2.0 and Pisanix: Cloud‑Native Database Governance at iQIYI
Java High-Performance Architecture
Java High-Performance Architecture
Dec 15, 2022 · Backend Development

How to Build a High‑Performance Follow Service with MySQL, Redis, and Spring Boot

This article explains how to design and implement a friend/follow microservice using MySQL for persistence and Redis sets for efficient set operations, covering database schema, Spring Boot configuration, Redis template setup, service and controller logic, and testing of follow, unfollow, and mutual‑follow features.

Follow ServiceJavaMySQL
0 likes · 19 min read
How to Build a High‑Performance Follow Service with MySQL, Redis, and Spring Boot
JavaEdge
JavaEdge
Dec 14, 2022 · Backend Development

Designing Scalable Shopping Cart Storage: Principles and Choices

This article explains how to design the storage layer for an e‑commerce shopping cart, covering core functionalities, required attributes, client‑side temporary storage, server‑side persistence options with MySQL and Redis, and the trade‑offs between reliability, performance, and complexity.

Data synchronizationMySQLRedis
0 likes · 12 min read
Designing Scalable Shopping Cart Storage: Principles and Choices
Efficient Ops
Efficient Ops
Dec 13, 2022 · Databases

How ClickHouse Replicates MySQL in Real-Time: A Step-by-Step Guide

This article explains how to configure ClickHouse as a MySQL replica using the MaterializeMySQL engine, covering code acquisition, MySQL master setup, ClickHouse slave configuration, handling of delete and update operations, and the underlying replication mechanism with practical code examples.

ClickHouseDatabase SyncMaterializeMySQL
0 likes · 10 min read
How ClickHouse Replicates MySQL in Real-Time: A Step-by-Step Guide
Open Source Linux
Open Source Linux
Dec 13, 2022 · Databases

Boost MySQL Performance: 20 Proven SQL Optimization Techniques

This article presents a comprehensive collection of MySQL optimization tips, covering everything from avoiding SELECT * and OR conditions to proper use of indexes, joins, UNION, batch operations, and query planning, each illustrated with clear examples and practical reasons for better performance.

MySQLPerformance Tuningquery best practices
0 likes · 19 min read
Boost MySQL Performance: 20 Proven SQL Optimization Techniques
ITPUB
ITPUB
Dec 9, 2022 · Databases

Mastering Sharding: When and How to Split Databases and Tables with ShardingSphere

This article explains the fundamentals of database sharding, why and when to apply it, various vertical and horizontal splitting strategies, routing algorithms, common pitfalls such as pagination and distributed transactions, and compares client‑side and proxy‑based ShardingSphere deployment patterns.

MySQLShardingSpheredatabase partitioning
0 likes · 19 min read
Mastering Sharding: When and How to Split Databases and Tables with ShardingSphere
Zhuanzhuan Tech
Zhuanzhuan Tech
Dec 9, 2022 · Databases

Implementing a MySQL Data Consistency Check Tool Based on pt-table-checksum

This article describes the design, implementation, and usage of a custom MySQL data consistency checking tool that extends pt-table-checksum, handling composite primary keys, network throttling, scheduled execution, and detailed logging for both successful and failed verification scenarios.

Data ConsistencyMySQLScripting
0 likes · 21 min read
Implementing a MySQL Data Consistency Check Tool Based on pt-table-checksum
Java Captain
Java Captain
Dec 8, 2022 · Backend Development

Design and Implementation of a Friend Follow Microservice Using MySQL and Redis

This article explains how to design and implement a friend follow microservice by combining MySQL for persistent storage with Redis sets for efficient follow/unfollow operations and mutual follow queries, covering database schema, Maven dependencies, Spring Boot configuration, RedisTemplate setup, service and controller logic, and testing procedures.

Follow FeatureJavaMySQL
0 likes · 15 min read
Design and Implementation of a Friend Follow Microservice Using MySQL and Redis
vivo Internet Technology
vivo Internet Technology
Dec 7, 2022 · Databases

vivo's Database Operations Platform: Challenges and Solutions in the Cloud-Native Era

Vivo’s Database‑as‑a‑Service platform tackles cloud‑native challenges by automating massive instance management with self‑service work orders and self‑healing, enabling elastic scaling through mixed‑deployment and multi‑threaded Redis tools, optimizing costs via automatic package shrinkage, and safeguarding personal data with full‑chain encryption, while outlining a roadmap toward AI‑driven fault handling, container‑based resources, and advanced privacy governance.

DaaSDatabaseEncryption
0 likes · 14 min read
vivo's Database Operations Platform: Challenges and Solutions in the Cloud-Native Era
Zhuanzhuan Tech
Zhuanzhuan Tech
Dec 6, 2022 · Databases

Migrating MySQL Monitoring from Zabbix to Prometheus Using mysqld_exporter: Multi‑Instance Setup and Troubleshooting

This article explains how to replace Zabbix with Prometheus for MySQL monitoring by configuring mysqld_exporter to collect metrics from multiple MySQL instances, details the required user accounts, shows common errors, and provides step‑by‑step solutions including building a newer exporter, adjusting configuration files, and using auth_module for password management.

ConfigurationExporterMulti-Instance
0 likes · 14 min read
Migrating MySQL Monitoring from Zabbix to Prometheus Using mysqld_exporter: Multi‑Instance Setup and Troubleshooting
Liangxu Linux
Liangxu Linux
Dec 5, 2022 · Databases

How Does MySQL Store a Row? Inside InnoDB Files, Pages, and Row Formats

This article explains where MySQL keeps its data files, how InnoDB organizes tablespaces into segments, extents, pages and rows, details the Compact row format—including variable‑length field length lists, NULL‑value lists, and hidden fields—and clarifies the limits of VARCHAR and row‑overflow handling.

Database StorageExtentInnoDB
0 likes · 22 min read
How Does MySQL Store a Row? Inside InnoDB Files, Pages, and Row Formats
Laravel Tech Community
Laravel Tech Community
Dec 5, 2022 · Databases

Using MySQL Built‑in Commands for Comprehensive Database Monitoring

This article explains how to collect extensive MySQL performance metrics—including connections, buffer cache, locks, SQL status, statement counts, throughput, server configuration, and slow‑query logs—using only MySQL's native SHOW commands and the performance_schema, providing practical code snippets and optimization tips.

DatabaseMySQLPerformance
0 likes · 10 min read
Using MySQL Built‑in Commands for Comprehensive Database Monitoring
Top Architect
Top Architect
Dec 5, 2022 · Backend Development

Integrating Spring Batch with Spring Boot: Full Tutorial and Example

This article provides a comprehensive step‑by‑step guide on integrating Spring Batch with Spring Boot, covering configuration, entity and mapper definitions, job, step, reader, processor, writer implementations, database setup, error handling, and execution via a REST controller, complete with code examples.

Batch ProcessingJavaMyBatis
0 likes · 22 min read
Integrating Spring Batch with Spring Boot: Full Tutorial and Example
Java High-Performance Architecture
Java High-Performance Architecture
Dec 5, 2022 · Backend Development

How to Build a High‑Performance, Highly Available Membership System with ES, Redis, and MySQL

This article explains how a large‑scale membership system achieves high performance and high availability by using a dual‑center Elasticsearch cluster, traffic‑isolated three‑cluster architecture, Redis caching with dual‑center clusters, and a MySQL partitioned dual‑center setup, while also detailing optimization, migration, and fine‑grained flow‑control strategies.

ElasticsearchMySQLRedis
0 likes · 21 min read
How to Build a High‑Performance, Highly Available Membership System with ES, Redis, and MySQL
macrozheng
macrozheng
Dec 3, 2022 · Databases

Top 11 MySQL GUI Tools Every Developer Should Know

This article introduces eleven popular MySQL graphical management tools—including DBeaver, DataGrip, phpMyAdmin, MySQLDumper, Navicat, MySQL GUI Tools, MySQL ODBC Connector, MySQL Workbench, SQLyog, MySQL‑Front, and dbForge Studio—detailing their features, platform support, and official download links to help developers choose the right solution.

DBeaverDataGripMySQL
0 likes · 9 min read
Top 11 MySQL GUI Tools Every Developer Should Know
IT Xianyu
IT Xianyu
Dec 2, 2022 · Databases

How MySQL InnoDB Implements ACID: Locks, MVCC, and Logging

This article explains how MySQL's InnoDB engine guarantees ACID properties by describing the four components of ACID, the four isolation levels, lock granularity and types, the MVCC mechanism with version chains and read views, and the roles of undo, redo, and bin logs in ensuring atomicity, consistency, isolation, and durability.

ACIDInnoDBLock
0 likes · 14 min read
How MySQL InnoDB Implements ACID: Locks, MVCC, and Logging
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 30, 2022 · Databases

Understanding Index Condition Pushdown (ICP) in MySQL and Its Impact on Query Cost

Index Condition Pushdown (ICP) in MySQL pushes filter conditions to the storage engine to reduce row lookups, but this article demonstrates through experiments that while ICP lowers runtime by decreasing back‑table accesses, the optimizer’s cost model often ignores its benefits, leading to suboptimal plan choices.

Cost ModelDatabaseMySQL
0 likes · 10 min read
Understanding Index Condition Pushdown (ICP) in MySQL and Its Impact on Query Cost
ITPUB
ITPUB
Nov 29, 2022 · Databases

When MySQL Hits Its Limits: Scaling with Horizontal and Vertical Sharding

This article explains MySQL's theoretical row limits, why performance degrades long before reaching them, and how horizontal and vertical database sharding can distribute massive datasets across multiple instances to improve load handling and enable seamless scaling.

Horizontal PartitioningMySQLVertical Partitioning
0 likes · 7 min read
When MySQL Hits Its Limits: Scaling with Horizontal and Vertical Sharding
Architecture Digest
Architecture Digest
Nov 29, 2022 · Databases

MySQL InnoDB Deadlock Analysis and Resolution for a Video‑Conference Service

The article details a step‑by‑step investigation of an intermittent deadlock occurring during session creation in a video‑conference system, explains how InnoDB lock types caused the conflict between DELETE and INSERT statements on the session and session_endpoint tables, reproduces the issue, debugs MySQL source code, and presents a simple code‑order fix to eliminate the deadlock.

DatabaseDeadlockDebugging
0 likes · 21 min read
MySQL InnoDB Deadlock Analysis and Resolution for a Video‑Conference Service
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Nov 28, 2022 · Backend Development

Design and Implementation of the Service Backend Architecture for Editor, Component Platform, and C‑End Application

This article details the overall backend architecture, module relationships, RESTful API design, database schemas, authentication flow, activity creation process, JSON schema validation, component platform APIs, and server‑side rendering considerations for a Node.js‑based service supporting editors, components, and end‑user pages.

JWTMongoDBMySQL
0 likes · 22 min read
Design and Implementation of the Service Backend Architecture for Editor, Component Platform, and C‑End Application
dbaplus Community
dbaplus Community
Nov 27, 2022 · Databases

Unraveling MySQL InnoDB Deadlocks in Video Conference Sessions

A detailed investigation of intermittent MySQL InnoDB deadlocks occurring during video‑conference session creation, covering log extraction, lock analysis, source‑code debugging, reproducible test cases, and a simple code change that eliminates the deadlock while explaining the underlying locking mechanisms.

DatabaseDeadlockInnoDB
0 likes · 22 min read
Unraveling MySQL InnoDB Deadlocks in Video Conference Sessions
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 26, 2022 · Databases

Weekly Tech Community Digest – Database and SQL Updates

This weekly digest curates top industry technical shares, featuring articles on database cloud migration, MySQL hash join evolution, OceanBase distributed query performance, MySQL subquery execution, and the latest SQLE SQL audit tool release, along with community development progress and upcoming plans.

MySQLOceanBaseSQL audit
0 likes · 3 min read
Weekly Tech Community Digest – Database and SQL Updates
Selected Java Interview Questions
Selected Java Interview Questions
Nov 24, 2022 · Databases

Common MySQL Index Failure Scenarios and Optimization Techniques

This article explains why many MySQL queries cause index inefficiency, details the leftmost prefix rule for composite indexes, illustrates common index‑breaking patterns such as SELECT *, functions, range queries, LIKE, OR, IN, ORDER BY, and introduces Index Condition Pushdown (ICP) as an optimization to reduce row lookups.

DatabaseLeftmost PrefixMySQL
0 likes · 19 min read
Common MySQL Index Failure Scenarios and Optimization Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 24, 2022 · Databases

Understanding Orchestrator's RegroupReplicasGTID and Candidate Replica Selection in MySQL Failover

This article explains how Orchestrator selects a candidate replica during MySQL master failover, detailing the GetCandidateReplica and RegroupReplicasGTID functions, their sorting logic, promotion rules, GTID-based regrouping, and differences from MHA, while highlighting potential data loss issues and related bugs.

FailoverGTIDMySQL
0 likes · 22 min read
Understanding Orchestrator's RegroupReplicasGTID and Candidate Replica Selection in MySQL Failover
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 23, 2022 · Databases

Migrating MySQL Monitoring to Prometheus with mysqld_exporter: Multi‑Instance Support and Troubleshooting

This article describes how to replace Zabbix with Prometheus for MySQL monitoring by configuring mysqld_exporter to collect metrics from multiple MySQL instances, including environment setup, user creation, exporter configuration, troubleshooting common errors, and Prometheus job adjustments, providing step‑by‑step commands and code examples.

ConfigurationExporterMySQL
0 likes · 15 min read
Migrating MySQL Monitoring to Prometheus with mysqld_exporter: Multi‑Instance Support and Troubleshooting
Architecture Digest
Architecture Digest
Nov 23, 2022 · Databases

Using MySQL Built‑in SHOW Commands for Comprehensive Database Monitoring

This article explains how to collect a wide range of MySQL performance metrics—including connections, buffer pool usage, locks, SQL statistics, statement counts, throughput, server variables, and slow‑query logs—using only MySQL's native SHOW commands and performance_schema tables, while also offering practical tuning tips and analysis tools.

Database MonitoringMySQLPerformance Schema
0 likes · 11 min read
Using MySQL Built‑in SHOW Commands for Comprehensive Database Monitoring
Java Architect Essentials
Java Architect Essentials
Nov 21, 2022 · Databases

MySQL Query Optimization Best Practices: Avoid SELECT *, Use Specific Fields, Index Strategies, Joins, and Other Performance Tips

This article presents a comprehensive set of MySQL optimization guidelines, covering the avoidance of SELECT *, proper use of specific columns, eliminating OR and != in WHERE clauses, preferring numeric types, choosing VARCHAR over CHAR, using TRUNCATE, batch operations, index design, join selection, GROUP BY efficiency, and other practical tips to improve query performance.

MySQLSQL optimizationdatabase indexing
0 likes · 18 min read
MySQL Query Optimization Best Practices: Avoid SELECT *, Use Specific Fields, Index Strategies, Joins, and Other Performance Tips
Laravel Tech Community
Laravel Tech Community
Nov 20, 2022 · Databases

11 Popular MySQL Graphical Management Tools

This article introduces eleven widely used graphical tools for MySQL administration, describing each tool's features, platform support, and official download links, helping developers and DBAs choose the most suitable solution for managing MySQL databases efficiently.

Administration ToolsDatabase GUIMySQL
0 likes · 8 min read
11 Popular MySQL Graphical Management Tools
dbaplus Community
dbaplus Community
Nov 20, 2022 · Databases

Master MySQL Performance: From Tuning Pyramid to Explain Plans

This guide walks through MySQL performance tuning, covering the architectural tuning pyramid, query optimization techniques, slow‑query logging, detailed EXPLAIN execution‑plan analysis, and high‑performance indexing strategies to help you diagnose and accelerate database workloads.

EXPLAINMySQLQuery Optimization
0 likes · 43 min read
Master MySQL Performance: From Tuning Pyramid to Explain Plans
dbaplus Community
dbaplus Community
Nov 19, 2022 · Databases

How to Speed Up MySQL Queries: Indexing and Execution Plan Optimization

This article walks through a MySQL performance case study, showing how nested subqueries on large tables can take hours, and demonstrates step‑by‑step how creating single‑column, composite, and covering indexes, as well as rewriting queries as joins, reduces execution time from tens of thousands of seconds to milliseconds.

Execution PlanIndexingMySQL
0 likes · 12 min read
How to Speed Up MySQL Queries: Indexing and Execution Plan Optimization
Tencent Cloud Developer
Tencent Cloud Developer
Nov 18, 2022 · Backend Development

Cache Consistency Strategies and Best Practices

The article explains how using a Redis cache can boost read performance but introduces consistency challenges, compares four cache‑aside write strategies, and recommends the reliable “update database then delete cache” approach combined with short expiration times and asynchronous message‑queue invalidation to keep data fresh.

Cache AsideMySQLRedis
0 likes · 20 min read
Cache Consistency Strategies and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 17, 2022 · Databases

DeadMaster Recovery Process in Orchestrator

This article explains the complete DeadMaster recovery workflow of Orchestrator, detailing how the system selects the appropriate check‑and‑recover function, handles emergency grace periods, reads topology information, registers recovery attempts, validates promotion constraints, executes the actual failover, and runs post‑recovery hooks, with extensive Go code examples.

FailoverGoMySQL
0 likes · 18 min read
DeadMaster Recovery Process in Orchestrator