BestHub
Sign in
Tagged articles
5000 articles
Page 25 of 50
ITPUB
ITPUB
Feb 20, 2023 · Databases

18 Must‑Know MySQL 8.0 Management Features to Boost Your DBA Skills

Discover 18 essential MySQL 8.0 management enhancements—including persistent global variables, admin IP/port settings, minimal installation packages, resource groups, read‑only databases, improved SHOW PROCESSLIST, instant DDL, faster DROP/TRUNCATE, OS thread visibility, connection memory limits, enriched slow‑log details, backup options, Clone plugin, upgrade process, client defaults, and RESTART command usage.

8.0Database AdministrationMySQL
0 likes · 12 min read
18 Must‑Know MySQL 8.0 Management Features to Boost Your DBA Skills
Open Source Linux
Open Source Linux
Feb 20, 2023 · Databases

8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries

This article examines eight frequent SQL anti‑patterns—including misuse of LIMIT, implicit type conversion, sub‑query updates, mixed ordering, EXISTS clauses, condition push‑down, premature data reduction, and intermediate result handling—explaining why they degrade performance and providing concrete rewrite strategies and code examples to dramatically speed up queries.

DatabaseMySQLOptimization
0 likes · 14 min read
8 Common SQL Pitfalls and How to Optimize Them for Lightning‑Fast Queries
Liangxu Linux
Liangxu Linux
Feb 19, 2023 · Databases

Mastering Sequel Pro: A Complete Guide to Managing MySQL Databases

This guide introduces Sequel Pro, explains how to configure Standard, Socket, or SSH connections with required fields, describes the main interface modules for browsing schemas, tables, relationships, triggers, and running queries, and highlights useful shortcuts for efficient MySQL management.

Database GUIMySQLSequel Pro
0 likes · 3 min read
Mastering Sequel Pro: A Complete Guide to Managing MySQL Databases
dbaplus Community
dbaplus Community
Feb 19, 2023 · Databases

Essential MySQL Optimization Checklist: 46 Proven Practices to Boost Performance

This comprehensive guide outlines 46 practical MySQL optimization rules—from understanding the query execution flow and naming conventions to index design, join strategies, pagination techniques, and safe use of data types—providing concrete examples and code snippets that help developers dramatically improve database performance and reliability.

Best PracticesMySQLPerformance tuning
0 likes · 26 min read
Essential MySQL Optimization Checklist: 46 Proven Practices to Boost Performance
21CTO
21CTO
Feb 18, 2023 · Databases

MySQL vs PostgreSQL 2023: Which Database Should You Choose?

This 2023 comparison examines MySQL and PostgreSQL across history, features, performance, scalability, cost, and migration trends, helping developers decide which relational database best fits their specific application requirements.

2023MySQLPostgreSQL
0 likes · 13 min read
MySQL vs PostgreSQL 2023: Which Database Should You Choose?
ITPUB
ITPUB
Feb 18, 2023 · Databases

Why MySQL Unique Index Fails with unique_checks=0 and How to Resolve It

In MySQL 5.7 replication, disabling unique_checks can cause duplicate‑key errors on a unique index that is not a primary key, leading to replication stalls, and this guide explains the root cause, temporary and permanent fixes, and step‑by‑step reproduction instructions.

MySQLUnique Indexbug
0 likes · 7 min read
Why MySQL Unique Index Fails with unique_checks=0 and How to Resolve It
Liangxu Linux
Liangxu Linux
Feb 18, 2023 · Databases

Why Does One MySQL UPDATE Block While Another Doesn’t? Deep Dive into InnoDB Locks

The article explains why an UPDATE on the same row in MySQL can block in one transaction but not in another, by analyzing the types of row‑level locks (record, next‑key, gap) acquired during SELECT … FOR UPDATE, normal updates, and updates that modify primary‑key values, illustrating the lock behavior with B+‑tree examples.

B+TreeInnoDBMySQL
0 likes · 8 min read
Why Does One MySQL UPDATE Block While Another Doesn’t? Deep Dive into InnoDB Locks
ITPUB
ITPUB
Feb 17, 2023 · Databases

Master MySQL Locking: From Row Locks to Deadlocks and How to Prevent Them

This article explains why MySQL needs locking, details every InnoDB lock type—including shared, exclusive, intention, record, gap, next‑key, insert‑intention and auto‑increment locks—shows how they interact, and provides practical guidance for avoiding deadlocks and safely updating rows.

InnoDBIsolation LevelMySQL
0 likes · 22 min read
Master MySQL Locking: From Row Locks to Deadlocks and How to Prevent Them
Laravel Tech Community
Laravel Tech Community
Feb 16, 2023 · Databases

DISTINCT vs GROUP BY in MySQL: Performance and Usage Guide

This article explains the differences between DISTINCT and GROUP BY in MySQL, showing that with an index they have similar efficiency, while without an index DISTINCT is usually faster because GROUP BY may trigger sorting and temporary tables, and it provides syntax, examples, and recommendations.

DISTINCTGROUP BYMySQL
0 likes · 8 min read
DISTINCT vs GROUP BY in MySQL: Performance and Usage Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 15, 2023 · Databases

SQL Statement Optimization Practices for MySQL

This article explains how DBAs can improve MySQL query performance by applying logical and physical optimizations, analyzing table structures, indexes, and execution plans, and provides a step‑by‑step checklist for diagnosing and rewriting slow or poorly optimized SQL statements.

Database PerformanceMySQLQuery Tuning
0 likes · 8 min read
SQL Statement Optimization Practices for MySQL
Code Ape Tech Column
Code Ape Tech Column
Feb 14, 2023 · Backend Development

High‑Availability Architecture for a Billion‑Scale Membership System: Elasticsearch Dual‑Center Cluster, Redis Caching, and MySQL Migration

This article describes how a membership platform serving over ten billion users achieves high performance and fault tolerance through a dual‑center Elasticsearch cluster, traffic‑isolated three‑cluster ES design, Redis multi‑center caching, and a seamless migration from SQL Server to a partitioned MySQL architecture, while detailing operational safeguards and fine‑grained flow‑control strategies.

ElasticsearchMySQLOperations
0 likes · 23 min read
High‑Availability Architecture for a Billion‑Scale Membership System: Elasticsearch Dual‑Center Cluster, Redis Caching, and MySQL Migration
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 13, 2023 · Databases

Why the Same SQL Has Different Execution Plans in QA and DEV Environments and How to Optimize It

The article analyzes why an identical MySQL query runs faster in a QA environment than in DEV, examines execution‑plan differences caused by table driving choices, optimizer settings, and unnecessary conditions, and demonstrates how rewriting the SQL and adjusting hints can achieve a stable, efficient plan.

Database PerformanceMySQLSQL optimization
0 likes · 17 min read
Why the Same SQL Has Different Execution Plans in QA and DEV Environments and How to Optimize It
Efficient Ops
Efficient Ops
Feb 12, 2023 · Databases

Why Single‑Node MySQL Is No Longer Enough: Embrace Distributed Databases

The article explains the limitations of standalone MySQL for large‑scale workloads, explores sharding, read/write separation, and middleware approaches, and argues that modern distributed databases and cloud‑native solutions are the sustainable path forward for data‑intensive applications.

Cloud DatabasesMySQLSharding
0 likes · 6 min read
Why Single‑Node MySQL Is No Longer Enough: Embrace Distributed Databases
ITPUB
ITPUB
Feb 9, 2023 · Databases

Inside InnoDB: How MySQL Stores Data, Row Formats, and Indexes Explained

This article breaks down MySQL's InnoDB storage engine, detailing where data files reside, the different row formats (compact, redundant, dynamic, compressed), the internal 16 KB page layout, record header fields, overflow handling, and how B‑tree indexes (clustered and secondary) are built and searched.

B+TreeDatabase StorageInnoDB
0 likes · 24 min read
Inside InnoDB: How MySQL Stores Data, Row Formats, and Indexes Explained
JD Tech
JD Tech
Feb 9, 2023 · Databases

Understanding MySQL Master‑Slave Replication: Overview, Benefits, Mechanisms, and Consistency Solutions

This article explains MySQL master‑slave replication, covering its basic concepts, the advantages of read‑write separation, data backup and high availability, the underlying binlog‑based mechanism, the four replication modes (full, asynchronous, semi‑synchronous, enhanced semi‑synchronous), common consistency challenges, and practical ways to mitigate them.

Data ConsistencyMaster‑SlaveMySQL
0 likes · 18 min read
Understanding MySQL Master‑Slave Replication: Overview, Benefits, Mechanisms, and Consistency Solutions
The Dominant Programmer
The Dominant Programmer
Feb 9, 2023 · Cloud Native

Step-by-Step Docker‑Compose Guide to Deploy a SpringBoot‑Vue‑Redis‑MySQL Stack

This article walks through installing Docker and Docker‑Compose, creating a project directory, writing a docker‑compose.yml that defines Redis, MySQL, Nginx, Java, and a file‑preview service, configuring each container, and using docker‑compose commands to build, start, monitor, and manage the full SpringBoot‑Vue application stack.

MySQLRedisSpringBoot
0 likes · 12 min read
Step-by-Step Docker‑Compose Guide to Deploy a SpringBoot‑Vue‑Redis‑MySQL Stack
Open Source Linux
Open Source Linux
Feb 9, 2023 · Databases

Master MySQL Optimization: Indexes, Explain Plans, and Performance Tips

This comprehensive guide explores MySQL architecture, index types, query execution plans, and practical optimization techniques, offering detailed examples of creating, modifying, and analyzing indexes, avoiding common pitfalls, and improving query performance through proper use of EXPLAIN, composite indexes, and query rewriting.

Explain PlanIndexesMySQL
0 likes · 36 min read
Master MySQL Optimization: Indexes, Explain Plans, and Performance Tips
ITPUB
ITPUB
Feb 8, 2023 · Databases

Why Does One MySQL UPDATE Block While Another Doesn’t? A Deep Dive into Row‑Level Locks

This article explains why an UPDATE on a MySQL row that changes a regular column proceeds without blocking, while an UPDATE that modifies the primary‑key value gets blocked, by analyzing the locks set by preceding transactions, the B+‑tree index structure, and the delete‑plus‑insert rewrite performed by InnoDB.

B+TreeGap LockMySQL
0 likes · 9 min read
Why Does One MySQL UPDATE Block While Another Doesn’t? A Deep Dive into Row‑Level Locks
JD Tech
JD Tech
Feb 7, 2023 · Databases

MySQL Database Performance Optimization: Principles, Architecture, Indexing, and Real‑World Cases

This article explains common MySQL database performance optimization techniques, underlying storage architecture, index construction and usage guidelines, and presents several real‑world cases from an internet hospital project, helping developers understand optimization strategies, avoid hidden pitfalls, and improve query efficiency.

MySQLPerformance Optimizationcase study
0 likes · 15 min read
MySQL Database Performance Optimization: Principles, Architecture, Indexing, and Real‑World Cases
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 7, 2023 · Databases

Resolving Illegal Mix of Collations Errors in MySQL 8.0 Views

This article analyzes why MySQL 8.0 reports an illegal mix of collations when querying a view that joins tables with different character sets, demonstrates reproducing the issue, explains the role of the CONVERT function and default collation variables, and provides practical recommendations to avoid such errors.

Character SetConvert FunctionDatabase Administration
0 likes · 9 min read
Resolving Illegal Mix of Collations Errors in MySQL 8.0 Views
JD Cloud Developers
JD Cloud Developers
Feb 6, 2023 · Databases

Master MySQL Performance: Indexing, Execution Plans, and Real-World Cases

This article explains why database performance monitoring becomes critical as data grows, outlines common optimization techniques, dives into MySQL's storage architecture and index structures, and shares three real‑world cases that illustrate how proper indexing and execution‑plan analysis can prevent severe latency and CPU spikes.

Database PerformanceIndex OptimizationMySQL
0 likes · 15 min read
Master MySQL Performance: Indexing, Execution Plans, and Real-World Cases
Architecture Digest
Architecture Digest
Feb 3, 2023 · Databases

Comprehensive Guide to Using DataX for Data Synchronization

This article provides a step‑by‑step tutorial on installing, configuring, and using Alibaba's open‑source DataX tool to perform both full and incremental data synchronization between MySQL databases on Linux, covering framework design, job architecture, JSON job files, and practical command‑line examples.

DataXETLJSON
0 likes · 14 min read
Comprehensive Guide to Using DataX for Data Synchronization
Su San Talks Tech
Su San Talks Tech
Feb 3, 2023 · Backend Development

Efficiently Export Millions of Rows to Excel Using Async and EasyExcel

This article details a robust solution for exporting massive MySQL datasets—potentially millions of rows—to Excel by leveraging asynchronous processing with jobs or MQ, the memory‑efficient EasyExcel library, pagination, multi‑sheet handling, OSS storage, and WebSocket notifications, ensuring performance and usability.

Async ProcessingJavaMySQL
0 likes · 17 min read
Efficiently Export Millions of Rows to Excel Using Async and EasyExcel
IT Architects Alliance
IT Architects Alliance
Feb 3, 2023 · Backend Development

Preventing Overselling in High‑Concurrency Flash Sales: 7 Locking & Queue Strategies with SpringBoot

This article analyzes the overselling problem in high‑concurrency flash‑sale scenarios, demonstrates seven concrete solutions—including improved locks, AOP locks, pessimistic and optimistic database locks, and queue‑based approaches using BlockingQueue and Disruptor—provides full SpringBoot code, JMeter test results, and practical recommendations for reliable stock reduction.

BackendConcurrencyDisruptor
0 likes · 19 min read
Preventing Overselling in High‑Concurrency Flash Sales: 7 Locking & Queue Strategies with SpringBoot
php Courses
php Courses
Feb 2, 2023 · Backend Development

PHP+MySQL Website Programming Introductory Course (Cantonese)

This free Cantonese-language course introduces PHP7 fundamentals, MySQL database connection, and simple website development using professional tools, empowering learners to build their own web projects, with all materials available online via the provided link.

CantoneseMySQLPHP
0 likes · 1 min read
PHP+MySQL Website Programming Introductory Course (Cantonese)
Su San Talks Tech
Su San Talks Tech
Feb 1, 2023 · Backend Development

How to Sync MySQL Data to Elasticsearch: 4 Practical Strategies

This article explores four common approaches for synchronizing product data from MySQL to Elasticsearch in e‑commerce systems—synchronous dual write, asynchronous dual write with message queues, scheduled tasks, and binlog‑based data subscription—detailing their advantages, drawbacks, and implementation considerations.

CanalElasticsearchMessage queue
0 likes · 7 min read
How to Sync MySQL Data to Elasticsearch: 4 Practical Strategies
Tencent Database Technology
Tencent Database Technology
Jan 31, 2023 · Databases

Common MySQL OOM Scenarios and TDSQL‑C Memory Optimization Strategies

This article examines typical MySQL out‑of‑memory (OOM) situations in production, explains how to diagnose memory usage with Performance Schema and other tools, and presents a series of TDSQL‑C‑specific optimization techniques—including server‑parameter tuning, process‑list monitoring, cold‑page detection, buffer‑pool limits, and dynamic resizing—to mitigate OOM risks.

Database PerformanceMemory OptimizationMySQL
0 likes · 12 min read
Common MySQL OOM Scenarios and TDSQL‑C Memory Optimization Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 31, 2023 · Databases

Useful MySQL Functions and SQL Techniques for Data Manipulation

This article presents a collection of practical MySQL functions and SQL 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—explaining their purposes, usage patterns, and providing concrete example queries with results.

GROUP_CONCATMySQLON DUPLICATE KEY UPDATE
0 likes · 13 min read
Useful MySQL Functions and SQL Techniques for Data Manipulation
macrozheng
macrozheng
Jan 31, 2023 · Backend Development

How to Sync MySQL Data to Elasticsearch: 4 Practical Strategies

This article explores four common approaches for synchronizing product data from MySQL to Elasticsearch—including synchronous dual writes, asynchronous messaging, scheduled jobs, and binlog‑based data subscription—detailing their advantages, drawbacks, and implementation considerations for e‑commerce search systems.

ElasticsearchMessage queueMySQL
0 likes · 6 min read
How to Sync MySQL Data to Elasticsearch: 4 Practical Strategies
Java Architect Essentials
Java Architect Essentials
Jan 30, 2023 · Databases

Boost MySQL Performance: 9 Proven Query Optimization Techniques

This article presents nine practical MySQL optimization methods—including smarter LIMIT usage, avoiding implicit type conversion, rewriting subqueries as joins, handling mixed sorting, replacing EXISTS with joins, pushing conditions into subqueries, early range reduction, and using CTEs—to dramatically improve query execution time across common scenarios.

CTEDatabase IndexesJoin
0 likes · 14 min read
Boost MySQL Performance: 9 Proven Query Optimization Techniques
ITPUB
ITPUB
Jan 30, 2023 · Backend Development

How to Keep MySQL and Elasticsearch in Sync: 4 Practical Strategies

This article examines four common approaches for synchronizing product data from MySQL to Elasticsearch—synchronous dual write, asynchronous dual write with message queues, scheduled batch jobs, and binlog‑based data subscription—detailing their advantages, drawbacks, and implementation considerations.

Backend DevelopmentCanalElasticsearch
0 likes · 6 min read
How to Keep MySQL and Elasticsearch in Sync: 4 Practical Strategies
macrozheng
macrozheng
Jan 30, 2023 · Databases

Why Is MySQL count(*) So Slow and How to Supercharge It

This article explains why MySQL count(*) queries can become a performance bottleneck on InnoDB tables and presents practical optimization techniques such as Redis caching, secondary caches, multithreading, reducing joins, and even switching to ClickHouse for massive datasets.

DatabaseMySQLcount(*)
0 likes · 10 min read
Why Is MySQL count(*) So Slow and How to Supercharge It
dbaplus Community
dbaplus Community
Jan 29, 2023 · Databases

Why Single‑Node MySQL Is Dying and Distributed Databases Are the Future

The article explains how single‑instance MySQL struggles with huge tables, resource‑starved databases, and high read traffic, and argues that sharding middleware is being replaced by modern distributed databases such as TiDB, OceanBase, Aurora, and PolarDB as the sustainable scaling solution.

Database ArchitectureMySQLSharding
0 likes · 9 min read
Why Single‑Node MySQL Is Dying and Distributed Databases Are the Future
Code Ape Tech Column
Code Ape Tech Column
Jan 28, 2023 · Big Data

Using Alibaba DataX for Offline Data Synchronization and Incremental Sync

This article introduces Alibaba DataX, explains its architecture and role in offline heterogeneous data synchronization, provides step‑by‑step Linux installation, demonstrates full‑load and incremental MySQL‑to‑MySQL sync with JSON job templates, and shares practical tips for handling large data volumes.

Data IntegrationDataXETL
0 likes · 15 min read
Using Alibaba DataX for Offline Data Synchronization and Incremental Sync
ITPUB
ITPUB
Jan 26, 2023 · Databases

What Locks Does SELECT … FOR UPDATE Acquire Under Different Isolation Levels?

This article experimentally demonstrates how MySQL's SELECT … FOR UPDATE statement acquires various locks—IX, X, and gap locks—under RC (read‑committed) and RR (repeatable‑read) isolation levels with unique, primary, normal, and missing indexes, revealing when row‑level versus table‑level locking occurs.

Database ConcurrencyInnoDBIsolation Levels
0 likes · 16 min read
What Locks Does SELECT … FOR UPDATE Acquire Under Different Isolation Levels?
Tencent Database Technology
Tencent Database Technology
Jan 18, 2023 · Databases

In‑depth Analysis of MySQL InnoDB Buffer Pool Architecture and Performance Optimizations

This article provides a comprehensive technical walkthrough of MySQL‑8.0.22 InnoDB's buffer pool, detailing its physical and logical structures, page management algorithms, fast read/write optimizations, change buffer, adaptive hash index, and the complete page‑read call stack, complete with code excerpts and diagrams.

CachingDatabase PerformanceInnoDB
0 likes · 47 min read
In‑depth Analysis of MySQL InnoDB Buffer Pool Architecture and Performance Optimizations
ITPUB
ITPUB
Jan 17, 2023 · Databases

Simplify MySQL Replication: Why GTID Beats Position‑Based Sync and How to Monitor Lag

This article examines MySQL’s transition from dual‑master to master‑slave replication, highlights the complexities of position‑based syncing, introduces GTID as a more reliable alternative, and provides practical steps to enable GTID and accurately monitor replication lag using seconds_behind_master, binlog positions, and GTID sets.

GTIDLag MonitoringMaster‑Slave
0 likes · 12 min read
Simplify MySQL Replication: Why GTID Beats Position‑Based Sync and How to Monitor Lag
Architecture Digest
Architecture Digest
Jan 14, 2023 · Backend Development

Design and Implementation of a Follow/Unfollow Microservice Using MySQL and Redis

This article details the requirements analysis, design approach, database schema, and step‑by‑step implementation of a follow/unfollow microservice using MySQL for persistence and Redis Sets for efficient set operations, including Maven dependencies, Spring Boot configuration, RedisTemplate setup, service, controller, and testing of common‑follow queries.

Follow ServiceJavaMicroservice
0 likes · 17 min read
Design and Implementation of a Follow/Unfollow Microservice Using MySQL and Redis
Java Architect Essentials
Java Architect Essentials
Jan 13, 2023 · Backend Development

How to Build a Scalable Follow Service with MySQL, Redis, and Spring Cloud

This article walks through the complete design and implementation of a friend‑follow microservice, covering requirement analysis, MySQL table schema, Redis set operations, Spring Boot dependencies, configuration, service and controller code, gateway routing, and end‑to‑end testing with concrete examples and performance insights.

Backend DevelopmentFollow ServiceJava
0 likes · 12 min read
How to Build a Scalable Follow Service with MySQL, Redis, and Spring Cloud
Sanyou's Java Diary
Sanyou's Java Diary
Jan 12, 2023 · Databases

Master MySQL Transaction Isolation: From READ UNCOMMITTED to SERIALIZABLE

This article explains MySQL's transaction concepts, the four isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—detailing their effects on dirty reads, non‑repeatable reads and phantom reads, how they are implemented with locks and MVCC, and provides practical SQL examples and diagrams.

DatabaseInnoDBMVCC
0 likes · 20 min read
Master MySQL Transaction Isolation: From READ UNCOMMITTED to SERIALIZABLE
Top Architect
Top Architect
Jan 12, 2023 · Databases

MySQL Master‑Slave Replication, Binlog/Redo Log Basics, and Sharding‑JDBC Read‑Write Splitting & Sharding Implementation

This article provides a comprehensive tutorial on configuring MySQL master‑slave replication with Docker, explains the roles of binlog and redo log, describes two‑phase commit, and demonstrates how to use Sharding‑JDBC (ShardingSphere) for read‑write splitting and horizontal sharding in a Spring Boot application, complete with configuration files and code examples.

DatabaseJavaMySQL
0 likes · 24 min read
MySQL Master‑Slave Replication, Binlog/Redo Log Basics, and Sharding‑JDBC Read‑Write Splitting & Sharding Implementation
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 11, 2023 · Databases

Collecting MySQL Diagnostic Reports with MySQL Shell 8.0.31 util.debug

The article explains how MySQL Shell 8.0.31's util.debug component provides built‑in functions to gather comprehensive diagnostic data—including error logs, replica status, InnoDB metrics, and OS metrics—and demonstrates practical command‑line examples for generating and analyzing zip‑packed diagnostic reports.

Database AdministrationMySQLMySQL Shell
0 likes · 8 min read
Collecting MySQL Diagnostic Reports with MySQL Shell 8.0.31 util.debug
Open Source Linux
Open Source Linux
Jan 10, 2023 · Databases

Essential MySQL Scripts: Export, Import, and Manage Databases & Tables

This guide compiles a comprehensive set of MySQL command‑line scripts for exporting whole databases, individual tables or schemas, importing data, and performing common database and table operations such as creation, selection, alteration, deletion, granting privileges, and viewing structure, all illustrated with ready‑to‑use code examples.

DDLData ExportDatabase
0 likes · 11 min read
Essential MySQL Scripts: Export, Import, and Manage Databases & Tables
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 9, 2023 · Databases

MySQL mysqldump Failure Caused by lower_case_table_names and Missing .frm Files: Diagnosis, Simulation, and Remedies

The article analyzes a MySQL mysqldump failure where tables appear missing due to the lower_case_table_names setting, reproduces the issue through a controlled experiment, and provides practical solutions and operational recommendations for handling case‑sensitivity during database migrations.

MySQLlower_case_table_namesmysqldump
0 likes · 7 min read
MySQL mysqldump Failure Caused by lower_case_table_names and Missing .frm Files: Diagnosis, Simulation, and Remedies
dbaplus Community
dbaplus Community
Jan 8, 2023 · Databases

Mastering MySQL Row‑Level Locks: Rules, Types, and How to Inspect Them

This article explains how InnoDB implements row‑level locking in MySQL, detailing the lock types (record, gap, next‑key), the scenarios that trigger each lock, how unique and non‑unique indexes affect locking, and provides step‑by‑step commands and examples for analyzing locks with performance_schema.

Database ConcurrencyInnoDBLock Types
0 likes · 45 min read
Mastering MySQL Row‑Level Locks: Rules, Types, and How to Inspect Them
Liangxu Linux
Liangxu Linux
Jan 8, 2023 · Databases

Master MySQL: 13 Essential Functions and Commands for Efficient Data Handling

This comprehensive guide walks you through 13 practical MySQL techniques—including group_concat, char_length, locate, replace, now, insert‑select variations, on duplicate key update, show create table, explain, show processlist, and mysqldump—complete with clear examples, SQL snippets, and result screenshots to help you manage and optimize your data effectively.

DatabaseFunctionsMySQL
0 likes · 13 min read
Master MySQL: 13 Essential Functions and Commands for Efficient Data Handling
Architect's Guide
Architect's Guide
Jan 7, 2023 · Databases

MySQL Execution Process Overview

This article explains the complete MySQL execution flow, covering the connector, permission verification, caching, parser, optimizer, executor, process states, SQL execution order, and the impact of WHERE‑clause condition ordering on query performance.

CachingExecution ProcessMySQL
0 likes · 13 min read
MySQL Execution Process Overview
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 6, 2023 · Databases

SQLE 2.2302.0-pre1 Release Notes and Feature Overview

The preview release of SQLE 2.2302.0-pre1 introduces manual deployment support, UI enhancements, and several bug fixes, providing a detailed overview of the project's purpose, new functionalities, and complete release information for database users and administrators.

Database AuditingMySQLRelease Notes
0 likes · 5 min read
SQLE 2.2302.0-pre1 Release Notes and Feature Overview
Top Architect
Top Architect
Jan 6, 2023 · Databases

Why MySQL Discourages UUID Primary Keys and a Performance Comparison of Auto‑Increment, UUID, and Random Long IDs

This article investigates MySQL's recommendation against using UUIDs as primary keys by creating three tables with auto‑increment, UUID, and random (snowflake) keys, running insertion benchmarks with Spring Boot/JdbcTemplate, analyzing index structures, and discussing the advantages and drawbacks of each key strategy.

MySQLSnowflake IDauto_increment
0 likes · 11 min read
Why MySQL Discourages UUID Primary Keys and a Performance Comparison of Auto‑Increment, UUID, and Random Long IDs
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.

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

Database OptimizationIndexesInnoDB
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 MigrationDatabaseFunctions
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.

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

MySQLdatabase scalingdistributed databases
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.

MySQLShardingcloud database
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.

MySQLdatabase scalingdistributed database
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.

BackendFollow ServiceJava
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 PerformanceMySQLOptimizer_trace
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 RecoveryDatabasesLVM
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.

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

ACIDDatabasesMVCC
0 likes · 28 min read
Understanding Database Transaction Isolation: From ACID Basics to TDSQL Implementation