BestHub
Sign in
Tagged articles
5000 articles
Page 20 of 50
Efficient Ops
Efficient Ops
Oct 16, 2023 · Databases

Why Master‑Master MySQL Replication Is Risky and How to Avoid Its Pitfalls

This article explains why the dbops tool does not support MySQL master‑master architecture, describes the two common dual‑master patterns, outlines their drawbacks such as role‑confusion, dirty‑data risk, split‑brain, and update loss, and provides practical workarounds and step‑by‑step deployment instructions to safely implement or avoid dual‑master setups.

GTIDMaster-Master Replicationdbops
0 likes · 17 min read
Why Master‑Master MySQL Replication Is Risky and How to Avoid Its Pitfalls
php Courses
php Courses
Oct 16, 2023 · Backend Development

Techniques to Optimize PHP and MySQL Access Speed

This article presents practical methods—including indexing, query consolidation, field selection, PHP code refinements, and caching strategies with Redis and page caching—to significantly improve the performance of PHP‑MySQL applications, accompanied by concrete code examples.

PHPcachingdatabase
0 likes · 6 min read
Techniques to Optimize PHP and MySQL Access Speed
macrozheng
macrozheng
Oct 13, 2023 · Backend Development

Why MySQL Sometimes Chooses Full Table Scans Over Indexes—and How to Diagnose It

This article explains how MySQL's optimizer calculates execution costs for different indexes, why it may select a full table scan instead of an apparently better index, and shows how to use EXPLAIN and optimizer trace to reveal and improve the chosen execution plan.

Index OptimizationOptimizer_traceQuery Performance
0 likes · 11 min read
Why MySQL Sometimes Chooses Full Table Scans Over Indexes—and How to Diagnose It
dbaplus Community
dbaplus Community
Oct 12, 2023 · Databases

How to Achieve Zero‑Downtime MySQL Version Upgrades: Strategies, Risks, and Best Practices

This article presents a comprehensive guide to planning and executing MySQL version upgrades—including industry version statistics, performance benchmarks, migration challenges, stability guarantees, detailed upgrade strategies, compatibility testing, and post‑upgrade validation—to ensure zero‑downtime and minimal operational impact.

Version UpgradeZero Downtimecompatibility testing
0 likes · 18 min read
How to Achieve Zero‑Downtime MySQL Version Upgrades: Strategies, Risks, and Best Practices
JD Cloud Developers
JD Cloud Developers
Oct 12, 2023 · Databases

How to Handle MySQL Replication Lag in Read/Write Splitting Architectures

This article explains the reasons for read/write splitting, compares direct‑client and proxy‑based master‑slave setups, and presents five practical strategies—including forcing reads to the master, sleep delays, lag checks, master‑position waiting, and GTID waiting—to mitigate stale reads caused by MySQL replication lag.

Database ArchitectureLag MitigationMaster‑Slave
0 likes · 15 min read
How to Handle MySQL Replication Lag in Read/Write Splitting Architectures
Su San Talks Tech
Su San Talks Tech
Oct 12, 2023 · Information Security

How to Enable Fuzzy Search on Encrypted Phone Numbers in MySQL

This article explores practical methods for performing fuzzy searches on encrypted phone numbers, covering in‑memory caching, database decryption functions, segment‑based storage, and adding dedicated fuzzy‑search fields to balance security, performance, and scalability.

Database designencryptionfuzzy-search
0 likes · 10 min read
How to Enable Fuzzy Search on Encrypted Phone Numbers in MySQL
dbaplus Community
dbaplus Community
Oct 11, 2023 · Databases

Detect and Cure MySQL Replication Lag: Step‑by‑Step Guide

This article explains how to identify whether MySQL replication delay originates from the I/O thread or SQL thread, demonstrates diagnostic commands, and provides practical tips, configuration tweaks, and monitoring tools such as pt‑stalk to reduce lag and improve replication performance.

Replicationmysqlperformance
0 likes · 11 min read
Detect and Cure MySQL Replication Lag: Step‑by‑Step Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 11, 2023 · Databases

Implementing Auto‑Increment Primary Keys When Migrating MySQL to OB Oracle

This article demonstrates two practical approaches for handling MySQL auto‑increment columns during migration to OB Oracle—creating custom sequences with DBCAT and using the GENERATED BY DEFAULT AS IDENTITY attribute—provides step‑by‑step commands, scripts, and validation results to help DBA engineers achieve seamless primary‑key migration.

Auto-IncrementDataXOracle
0 likes · 16 min read
Implementing Auto‑Increment Primary Keys When Migrating MySQL to OB Oracle
Architect's Guide
Architect's Guide
Oct 10, 2023 · Databases

Advantages and Disadvantages of Application‑Layer Association vs JOIN in MySQL

The article examines why using application‑layer association instead of MySQL JOIN can improve cache efficiency, reduce lock contention, simplify scaling, and enhance query performance, while also outlining scenarios where JOIN is still beneficial and offering practical alternatives for large‑scale data retrieval.

Application LayerDatabase OptimizationJOIN
0 likes · 6 min read
Advantages and Disadvantages of Application‑Layer Association vs JOIN in MySQL
ITPUB
ITPUB
Oct 9, 2023 · Databases

Boost MySQL Performance on Large Tables: Proven Strategies and Tools

This article examines why MySQL can still handle massive tables and presents practical techniques—including proper primary keys, eliminating redundant indexes, choosing optimal data types, compression, archiving, partitioning, sharding, query optimization, and safe schema changes—to keep large‑table performance high.

Partitioningcompressionindexing
0 likes · 16 min read
Boost MySQL Performance on Large Tables: Proven Strategies and Tools
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 9, 2023 · Databases

Using MySQL Offline Mode to Disconnect Client Connections

This article explains how MySQL's offline_mode variable and the pt‑kill tool can be used by DBAs to place a server in maintenance mode, instantly dropping non‑privileged client connections, preventing new ones, and providing a safe way to perform maintenance or backups.

Database MaintenanceOFFLINE_MODEPT-kill
0 likes · 8 min read
Using MySQL Offline Mode to Disconnect Client Connections
dbaplus Community
dbaplus Community
Oct 8, 2023 · Databases

How to Optimize Pagination for Massive MySQL Tables with Sharding

When a single MySQL table grows to millions of rows, offset‑based pagination becomes painfully slow, so this article explains why, measures the performance impact, and presents three practical sharding‑aware pagination strategies—including global query, jump‑page prohibition, and a two‑step query method—along with concrete SQL rewrites and optimization tips.

mysqlpaginationperformance
0 likes · 16 min read
How to Optimize Pagination for Massive MySQL Tables with Sharding
ITPUB
ITPUB
Oct 8, 2023 · Databases

Unlocking MySQL GIPKs: How Generated Invisible Primary Keys Simplify Schema Design

Starting with MySQL 8.0.30, the Generated Invisible Primary Keys (GIPKs) feature automatically adds an invisible bigint auto‑increment column named my_row_id when a table lacks an explicit primary key, simplifying schema design, easing DBA‑developer conflicts, and offering flexible handling in MGR and replication environments, while noting its limitations and usage commands.

Database designGIPKsGenerated Invisible Primary Keys
0 likes · 8 min read
Unlocking MySQL GIPKs: How Generated Invisible Primary Keys Simplify Schema Design
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 8, 2023 · Databases

Why Adding foreign_key_checks to my.cnf Causes MySQL Startup Failure and How to Identify Non‑Configurable System Variables

This article investigates why inserting the foreign_key_checks system variable into MySQL's my.cnf prevents the server from starting, explains the underlying NO_CMD_LINE flag mechanism, and provides a simple command‑line method to distinguish variables that can or cannot be set via configuration files.

ConfigurationNO_CMD_LINEdebugging
0 likes · 6 min read
Why Adding foreign_key_checks to my.cnf Causes MySQL Startup Failure and How to Identify Non‑Configurable System Variables
macrozheng
macrozheng
Oct 7, 2023 · Databases

Deploy Apache Ignite and Compare Its Performance with MySQL

This guide walks through installing Apache Ignite via Docker, configuring it alongside MySQL in a Spring Boot project, setting up data sources and MyBatis, and performing benchmark tests to illustrate Ignite’s superior in‑memory SQL performance compared to traditional MySQL setups.

Apache IgniteDockerIn-Memory Database
0 likes · 11 min read
Deploy Apache Ignite and Compare Its Performance with MySQL
Architect's Guide
Architect's Guide
Oct 7, 2023 · Backend Development

Implementing Fuzzy Search on Encrypted Sensitive Fields in a Spring Boot Backend

This article explains how to enable fuzzy searches on encrypted sensitive fields such as names, phone numbers, and ID numbers in a Spring Boot backend by using a tokenized ciphertext mapping table, outlining four possible solutions, recommending the tokenized approach, and providing complete configuration and code examples.

Spring Bootbackend-developmentdatabase encryption
0 likes · 11 min read
Implementing Fuzzy Search on Encrypted Sensitive Fields in a Spring Boot Backend
Architect
Architect
Oct 6, 2023 · Backend Development

Design and Implementation of QQ Reminder Subscription Push System

This article details the architecture, technical requirements, and implementation techniques—including hybrid push‑pull, heterogeneous storage, distributed scheduling, task chunking, and at‑least‑once delivery—used to build a high‑concurrency, reliable reminder notification service for QQ.

Distributed SchedulingMessage Queuemysql
0 likes · 13 min read
Design and Implementation of QQ Reminder Subscription Push System
Su San Talks Tech
Su San Talks Tech
Oct 6, 2023 · Databases

How MySQL Executes SQL: From Connection Pools to Log Files Explained

This article walks through how a Java application interacts with MySQL, covering the driver, connection pooling, thread handling, query parsing, the optimizer, storage engine, buffer pool, undo/redo logs, binlog, and transaction commit, providing a complete end‑to‑end view of MySQL’s internal processing.

InnoDBdatabaselog
0 likes · 22 min read
How MySQL Executes SQL: From Connection Pools to Log Files Explained
JD Cloud Developers
JD Cloud Developers
Oct 4, 2023 · Databases

Master MySQL Slow Query Optimization: EXPLAIN and Index Strategies

This article explains how to use MySQL's EXPLAIN statement to analyze slow queries, detailing each output column, various select types, access methods, and common pitfalls, then provides practical optimization techniques such as proper indexing, query rewriting, index merging, handling COUNT, UNION, OFFSET, and table maintenance.

SQL Optimizationexplainmysql
0 likes · 22 min read
Master MySQL Slow Query Optimization: EXPLAIN and Index Strategies
Liangxu Linux
Liangxu Linux
Oct 2, 2023 · Databases

Essential MySQL Optimization Tips: From EXPLAIN to Index Strategies

This guide presents a comprehensive set of MySQL performance‑tuning techniques—including proper use of EXPLAIN, limiting IN lists, selecting specific columns, avoiding costly ORDER BY RAND(), choosing UNION ALL over UNION, distinguishing IN from EXISTS, employing full‑text indexes, respecting left‑most prefix rules, and leveraging FORCE INDEX or STRAIGHT_JOIN—to help developers write faster, more efficient queries.

indexingmysqloptimization
0 likes · 12 min read
Essential MySQL Optimization Tips: From EXPLAIN to Index Strategies
ITPUB
ITPUB
Sep 28, 2023 · Databases

Mastering MySQL Index Merge: How Three Algorithms Boost Query Performance

Learn how MySQL's index merge optimization works, explore its three algorithms—intersect, union, and sort_union—understand when each applies, see practical setup and sample queries, and discover configuration flags and best‑practice tips to improve query efficiency.

databaseindex mergemysql
0 likes · 9 min read
Mastering MySQL Index Merge: How Three Algorithms Boost Query Performance
macrozheng
macrozheng
Sep 28, 2023 · Databases

Top Free MySQL GUI Clients You Should Try in 2024

This guide reviews popular free MySQL graphical clients—including MySQL Workbench, phpMyAdmin, HeidiSQL, Sequel Pro, and DBeaver—detailing their key features, platform support, and download links, offering a cost‑free alternative to paid tools like Navicat.

DBeaverDatabase clientMySQL Workbench
0 likes · 8 min read
Top Free MySQL GUI Clients You Should Try in 2024
Java High-Performance Architecture
Java High-Performance Architecture
Sep 28, 2023 · Databases

How to Use Debezium for MySQL CDC in Spring Boot Without Adding Extra Middleware

Learn how to capture MySQL data changes using Debezium's CDC capabilities within a Spring Boot application, avoiding heavyweight message brokers by leveraging binlog monitoring, configuring connectors, handling snapshots, and processing change events for use cases like cache invalidation, data integration, and simplifying monolithic architectures.

CDCData IntegrationDebezium
0 likes · 24 min read
How to Use Debezium for MySQL CDC in Spring Boot Without Adding Extra Middleware
dbaplus Community
dbaplus Community
Sep 27, 2023 · Databases

Understanding MySQL Locks: Which Queries Actually Acquire Locks?

This article breaks down MySQL's complex locking mechanisms—global, table, and row locks—explaining how different SELECT statements, transaction isolation levels, and index types affect lock acquisition, and provides practical test scripts and visual examples to help developers master lock behavior.

InnoDBIsolationLevelLocks
0 likes · 14 min read
Understanding MySQL Locks: Which Queries Actually Acquire Locks?
JD Cloud Developers
JD Cloud Developers
Sep 27, 2023 · Databases

How to Design Effective MySQL Indexes for Service Log Queries

This article explains how to create optimal MySQL indexes for a service_log table based on various search conditions, covering single‑column, composite, full‑text, prefix, and covering indexes, along with best practices, index size considerations, and practical SQL examples.

Full‑Text Searchmysqlsql
0 likes · 19 min read
How to Design Effective MySQL Indexes for Service Log Queries
php Courses
php Courses
Sep 26, 2023 · Databases

Best Practices for MySQL Backup: Strategy, Tools, Automation, and Recovery

This guide outlines a comprehensive MySQL backup solution, covering backup strategy planning, choosing physical versus logical backups, using tools like mysqldump and Percona XtraBackup, automating backups with scripts and cron, storage and retention considerations, and regular recovery testing to ensure data integrity.

BackupPercona XtraBackupautomation
0 likes · 5 min read
Best Practices for MySQL Backup: Strategy, Tools, Automation, and Recovery
php Courses
php Courses
Sep 25, 2023 · Backend Development

Implementing Data Merging with PHP Backend and Vue Frontend

This article demonstrates how to implement a data merging feature by creating MySQL tables, building a PHP API that retrieves and combines records from two tables, and developing a Vue.js front‑end that fetches and displays the merged data, complete with full code examples.

APIBackendPHP
0 likes · 5 min read
Implementing Data Merging with PHP Backend and Vue Frontend
dbaplus Community
dbaplus Community
Sep 24, 2023 · Backend Development

How to Sync MySQL Binlog to Elasticsearch Using Canal and RocketMQ

Learn step‑by‑step how to configure Alibaba’s open‑source Canal to capture MySQL binlog changes, route them through RocketMQ, and index the data into Elasticsearch, covering cluster mode, MySQL and Elasticsearch setup, Canal properties, and consumer implementation details.

CDCCanalRocketMQ
0 likes · 9 min read
How to Sync MySQL Binlog to Elasticsearch Using Canal and RocketMQ
ITPUB
ITPUB
Sep 23, 2023 · Databases

Is PostgreSQL Really the Most Popular Database? A Deep Dive into Rankings, Architecture, and Performance

This article examines why PostgreSQL appears to outrank MySQL in recent popularity surveys, explains the DB‑Engines ranking methodology, compares architectural choices such as MVCC, multi‑process vs multi‑thread models, transaction rollback behavior, licensing, and real‑world performance benchmarks like TPC‑C, ultimately revealing that MySQL still dominates many high‑throughput OLTP scenarios.

MVCCdatabase comparisonmysql
0 likes · 17 min read
Is PostgreSQL Really the Most Popular Database? A Deep Dive into Rankings, Architecture, and Performance
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 22, 2023 · Databases

SQLE 2.2309.0-pre4 Release Notes – New Features, Rule Knowledge Base, and Full Release Information

The SQLE 2.2309.0-pre4 release introduces an enterprise‑level SQL lifecycle management panel, a rule knowledge base, new TDSQL audit rules, and intelligent metadata scanning tasks, while providing links to the repository, documentation, and demo environments for both community and enterprise editions.

Database AuditingRelease NotesRule Knowledge Base
0 likes · 8 min read
SQLE 2.2309.0-pre4 Release Notes – New Features, Rule Knowledge Base, and Full Release Information
Sohu Tech Products
Sohu Tech Products
Sep 20, 2023 · Big Data

Using Canal to Sync MySQL Incremental Data to Elasticsearch via RocketMQ

This tutorial walks through configuring Canal in cluster mode to capture MySQL row‑based binlog events, publish them to a RocketMQ topic, and consume the ordered messages to update an Elasticsearch index, covering MySQL, RocketMQ, Elasticsearch mappings, and the required Canal properties.

BinlogCanalElasticsearch
0 likes · 8 min read
Using Canal to Sync MySQL Incremental Data to Elasticsearch via RocketMQ
ITPUB
ITPUB
Sep 20, 2023 · Databases

UUID vs Auto‑Increment IDs in MySQL: Pros, Cons, and When to Choose

This article compares UUID and auto‑increment primary keys in MySQL, explaining how each is generated, their advantages and drawbacks, performance implications, and practical guidance on selecting the right key type for different business scenarios.

Database designauto_incrementmysql
0 likes · 7 min read
UUID vs Auto‑Increment IDs in MySQL: Pros, Cons, and When to Choose
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 19, 2023 · Databases

MySQL Deadlock Analysis and Index Optimization Using ICP

This article examines a MySQL deadlock case involving DELETE and UPDATE statements, explains why the primary key index is locked despite non‑key predicates, analyzes execution plans and optimizer trace, and proposes index restructuring and query hints to resolve the issue.

ICPIndex OptimizationQuery Planner
0 likes · 23 min read
MySQL Deadlock Analysis and Index Optimization Using ICP
Programmer DD
Programmer DD
Sep 19, 2023 · Backend Development

Spring Boot Virtual Threads vs WebFlux: Which Delivers Better Performance?

This article summarizes a performance comparison between Spring Boot applications using virtual threads and those built with Spring WebFlux, detailing the test scenario of JWT verification and MySQL queries, the environment, code implementations, benchmark results across various concurrency levels, and concluding that WebFlux outperforms virtual‑threaded Spring Boot.

JWTSpring BootVirtual Threads
0 likes · 9 min read
Spring Boot Virtual Threads vs WebFlux: Which Delivers Better Performance?
ITPUB
ITPUB
Sep 18, 2023 · Databases

Why Keep a MySQL Table Under 20 Million Rows? Primary Key & Data Page Insights

This article explains why a single MySQL table should stay below about twenty million rows by examining primary‑key limits, InnoDB data‑page structure, B+‑tree storage calculations, and provides a practical recommendation based on row size and fragmentation.

B+TreeData PageDatabase design
0 likes · 9 min read
Why Keep a MySQL Table Under 20 Million Rows? Primary Key & Data Page Insights
Tencent Cloud Developer
Tencent Cloud Developer
Sep 18, 2023 · Databases

Who Is the World's Most Successful Database? An In‑Depth Technical Comparison of PostgreSQL and MySQL

The article evaluates database success by comparing PostgreSQL and MySQL across popularity, features, licensing, transaction behavior, MVCC, concurrency models, and use cases, showing PostgreSQL leads in complex queries and feature richness while MySQL remains the most widely used OLTP system, especially in China.

DB-EnginesMVCCdatabase comparison
0 likes · 15 min read
Who Is the World's Most Successful Database? An In‑Depth Technical Comparison of PostgreSQL and MySQL
Architect's Guide
Architect's Guide
Sep 15, 2023 · Databases

Why You Should Never Use MySQL “utf8” and Switch to “utf8mb4”

The article explains that MySQL’s legacy “utf8” charset only supports three‑byte characters, causing errors with genuine four‑byte UTF‑8 symbols, and advises all MySQL/MariaDB users to migrate to the proper “utf8mb4” charset using available conversion guides.

MariaDBcharacter encodingmysql
0 likes · 7 min read
Why You Should Never Use MySQL “utf8” and Switch to “utf8mb4”
dbaplus Community
dbaplus Community
Sep 14, 2023 · Databases

Master MySQL InnoDB Locks: From Row Locks to Deadlock Prevention

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—covers lock compatibility, deadlock causes and prevention, compares optimistic and pessimistic locking, and shows how SELECT FOR UPDATE behaves under different isolation levels.

InnoDBconcurrencydeadlock
0 likes · 20 min read
Master MySQL InnoDB Locks: From Row Locks to Deadlock Prevention
Top Architect
Top Architect
Sep 14, 2023 · Backend Development

Using Nginx Stream Proxy to Securely Access MySQL

This article explains how to configure Nginx as a stream proxy to securely connect to MySQL servers, covering required modules, stream, server, listen directives, IP access restrictions, and provides complete configuration examples for both single‑instance and clustered environments.

ConfigurationNginxProxy
0 likes · 8 min read
Using Nginx Stream Proxy to Securely Access MySQL
JD Cloud Developers
JD Cloud Developers
Sep 14, 2023 · Databases

How to Optimize MySQL Table Design for High Performance

This article walks through the creation and step‑by‑step optimization of a MySQL service_log table, covering proper data‑type selection, index usage, NULL handling, DATETIME vs TIMESTAMP choices, and floating‑point considerations to achieve a lean, high‑performance schema.

Data TypesDatabase designmysql
0 likes · 17 min read
How to Optimize MySQL Table Design for High Performance
JD Retail Technology
JD Retail Technology
Sep 13, 2023 · Databases

Optimizing Pagination Queries for Billion‑Row MySQL Tables

The article analyzes the performance problems of deep pagination on massive MySQL tables storing billions of fan records and presents three progressive solutions—simple LIMIT, tag‑record (maxId) pagination, and range‑limited pagination with async and offline minId caching—along with general indexing best‑practices for high‑throughput queries.

Large Dataindexingmysql
0 likes · 10 min read
Optimizing Pagination Queries for Billion‑Row MySQL Tables
Top Architect
Top Architect
Sep 12, 2023 · Backend Development

Efficient Insertion of 300,000 Records Using MyBatis and JDBC

This article demonstrates how to insert 300,000 rows into a MySQL table efficiently by defining entity, mapper and configuration files, comparing direct batch insertion, row‑by‑row insertion, and optimized batch strategies with MyBatis and JDBC, and summarizing performance results and best‑practice tips.

JDBCMyBatisjava
0 likes · 15 min read
Efficient Insertion of 300,000 Records Using MyBatis and JDBC
ITPUB
ITPUB
Sep 12, 2023 · Databases

What Risks Does MySQL 5.7 End‑of‑Life Pose and How to Migrate to Domestic Open‑Source Forks?

MySQL 5.7 reaches its official End‑of‑Life in October 2023, exposing users to security, compliance, performance, and support risks, and the article outlines four migration paths—continuing with 5.7, upgrading to MySQL 8.0, switching to domestic open‑source forks like GreatSQL, or adopting commercial Chinese databases—while providing a detailed case study of GreatSQL’s suitability for Chinese enterprises.

ChinaEnd of LifeGreatSQL
0 likes · 13 min read
What Risks Does MySQL 5.7 End‑of‑Life Pose and How to Migrate to Domestic Open‑Source Forks?
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 12, 2023 · Databases

Understanding MySQL 8.0 Password Policy Options and Common Misunderstandings

This article analyzes MySQL 8.0 password‑related parameters, explains the meaning of NULL values in the mysql.user table, demonstrates how global settings interact with per‑user attributes, and clarifies the priority rules between password_history and password_reuse_interval through practical test scenarios.

ALTER USERCREATE USERDatabase Administration
0 likes · 9 min read
Understanding MySQL 8.0 Password Policy Options and Common Misunderstandings
Architect's Tech Stack
Architect's Tech Stack
Sep 11, 2023 · Databases

Performance Evaluation of Large-Scale Data Insertion into MySQL Using MyBatis, JDBC, and Batch Processing

This article presents a systematic performance test of inserting massive data into MySQL, comparing three strategies—MyBatis lightweight insertion, direct JDBC (with and without transactions), and JDBC batch processing—showing how transaction handling and batch execution dramatically affect insertion speed.

Batch ProcessingJDBCMyBatis
0 likes · 15 min read
Performance Evaluation of Large-Scale Data Insertion into MySQL Using MyBatis, JDBC, and Batch Processing
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 11, 2023 · Databases

Aikexing Open Source Community Weekly Newsletter – Database Articles, Community Updates, and Events

The Aikexing Open Source Community weekly newsletter shares curated database articles, technical insights on MySQL, OceanBase, and Redis, announces SQLE 2.2309.0‑pre2 release with Feishu integration, recaps recent events like QCon Beijing, and promotes upcoming meetups and open‑source projects.

OceanBaseOpenSourcecommunity
0 likes · 6 min read
Aikexing Open Source Community Weekly Newsletter – Database Articles, Community Updates, and Events
Liangxu Linux
Liangxu Linux
Sep 10, 2023 · Databases

Master MySQL Query Optimization: Architecture, Caching, and Index Strategies

This article explains MySQL's logical architecture, query execution flow, caching mechanisms, and detailed index design techniques, providing practical tips and examples so developers can understand the underlying principles and apply effective performance optimizations in real‑world applications.

Database Performanceindexesmysql
0 likes · 38 min read
Master MySQL Query Optimization: Architecture, Caching, and Index Strategies
JD Retail Technology
JD Retail Technology
Sep 10, 2023 · Databases

Understanding MySQL InnoDB MVCC and Transaction Isolation Levels

This article explains MySQL InnoDB's multi-version concurrency control (MVCC), detailing how transaction isolation levels such as read‑committed and repeatable‑read create snapshots, how undo logs and hidden columns form version chains, and walks through concrete examples to show which row values are visible to concurrent transactions.

InnoDBMVCCmysql
0 likes · 12 min read
Understanding MySQL InnoDB MVCC and Transaction Isolation Levels
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 9, 2023 · Databases

SQL Queries for Identifying High‑Salary, Low‑Performance Employees in Layoff Scenarios

This article demonstrates how to use MySQL to create employee and performance tables, populate them with sample data, and write SQL statements that first select employees whose salaries exceed their department's average and then filter out those with non‑A performance ratings, providing a complete layoff‑target list.

Employeedatabaselayoff
0 likes · 7 min read
SQL Queries for Identifying High‑Salary, Low‑Performance Employees in Layoff Scenarios
Su San Talks Tech
Su San Talks Tech
Sep 9, 2023 · Backend Development

How to Sync MySQL Binlog to Elasticsearch Using Canal and RocketMQ

This step‑by‑step tutorial shows how to configure Alibaba's Canal to capture MySQL binlog changes, route them through RocketMQ, and index the data into Elasticsearch, covering cluster mode, MySQL and Elasticsearch setup, RocketMQ topic creation, Canal properties, and consumer implementation.

CanalElasticsearchRocketMQ
0 likes · 8 min read
How to Sync MySQL Binlog to Elasticsearch Using Canal and RocketMQ
Java Interview Crash Guide
Java Interview Crash Guide
Sep 8, 2023 · Databases

Boost MySQL Performance: 9 Proven SQL Optimization Techniques

This article explains nine practical MySQL optimization methods—including smarter LIMIT usage, implicit conversion pitfalls, JOIN‑based updates, mixed ordering tricks, EXISTS rewrites, predicate pushdown, early range reduction, intermediate result pushdown, and a concise summary—showing how to transform slow queries into sub‑millisecond operations.

LIMIT clausePredicate PushdownQuery Performance
0 likes · 12 min read
Boost MySQL Performance: 9 Proven SQL Optimization Techniques
dbaplus Community
dbaplus Community
Sep 7, 2023 · Databases

How to Safely Migrate from MySQL 5.7 Before Its End‑of‑Life

With MySQL 5.7 reaching end‑of‑life in October 2023 and over half of installations still on that version, this guide explains the new features of MySQL 8.0, how to assess upgrade readiness, and the three main migration paths—including staying put, moving to a DBaaS, or switching to PostgreSQL.

DBaaSEOLmysql
0 likes · 8 min read
How to Safely Migrate from MySQL 5.7 Before Its End‑of‑Life
MaGe Linux Operations
MaGe Linux Operations
Sep 7, 2023 · Backend Development

Why Message Order Matters: Solving MQ Chaos in MySQL Binlog Sync

This article explains how ordering issues in message queues like RabbitMQ and Kafka can break MySQL binlog synchronization, illustrates common pitfalls, and offers practical solutions to guarantee correct processing order in high‑throughput backend systems.

KafkaMessage QueueRabbitMQ
0 likes · 5 min read
Why Message Order Matters: Solving MQ Chaos in MySQL Binlog Sync
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 6, 2023 · Databases

Resolving ERROR 1499: Too Many Partitions in OceanBase/MySQL

This article analyzes the MySQL ERROR 1499 caused by exceeding partition limits in OceanBase, examines server parameters, recycle‑bin settings, and tenant memory usage, and provides calculations and recommendations to expand memory or limit partition counts to prevent the error.

OceanBasedatabase troubleshootingmemory calculation
0 likes · 11 min read
Resolving ERROR 1499: Too Many Partitions in OceanBase/MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 4, 2023 · Databases

Observability of MySQL 8 Replication Using Performance Schema and Sys Schema Views

The article explains how MySQL 8 enhances replication observability by exposing detailed metrics through Performance Schema tables and sys schema views, providing DBAs with richer information such as per‑channel lag, worker thread states, and full replication status beyond the traditional SHOW REPLICA STATUS output.

InnoDB ClusterPerformance SchemaReplication
0 likes · 14 min read
Observability of MySQL 8 Replication Using Performance Schema and Sys Schema Views
Su San Talks Tech
Su San Talks Tech
Sep 4, 2023 · Databases

Master MySQL Interview Essentials: 43 Key Topics Explained

This comprehensive guide consolidates 43 essential MySQL interview topics—from normalization, storage engines, and indexing to transaction handling, logging, replication, and performance tuning—providing clear explanations, code examples, and diagrams to help candidates quickly master the core concepts.

Database InterviewReplicationTransactions
0 likes · 37 min read
Master MySQL Interview Essentials: 43 Key Topics Explained
Java Architect Essentials
Java Architect Essentials
Sep 3, 2023 · Databases

Why Avoid NULL Columns in MySQL: Reasons and Implications

This article examines why MySQL columns are often defined as NULL, debunks common myths, and presents several technical reasons—including storage overhead, index complications, query pitfalls, and timestamp issues—that justify using NOT NULL with meaningful default values for better performance and data integrity.

NULLmysqlperformance
0 likes · 9 min read
Why Avoid NULL Columns in MySQL: Reasons and Implications
macrozheng
macrozheng
Sep 3, 2023 · Databases

Why a Single UPDATE Can Crash Your MySQL Database and How to Prevent It

This article explains how an UPDATE without indexed WHERE conditions can trigger full‑table next‑key locks in InnoDB, causing business downtime, and provides practical safeguards such as enabling sql_safe_updates and using FORCE INDEX to ensure safe execution.

InnoDBUPDATEindexes
0 likes · 8 min read
Why a Single UPDATE Can Crash Your MySQL Database and How to Prevent It
ITPUB
ITPUB
Sep 3, 2023 · Databases

Migrating from MySQL 5.7 to 8.0: Steps, New Features, and Alternative Paths

With MySQL 5.7 reaching end‑of‑life, this guide explains why you should upgrade to MySQL 8.0, outlines the new SQL capabilities and tools, and compares migration options including DBaaS and switching to PostgreSQL, helping you choose the best path for your workloads.

DBaaSDatabase Upgrademigration
0 likes · 8 min read
Migrating from MySQL 5.7 to 8.0: Steps, New Features, and Alternative Paths
macrozheng
macrozheng
Aug 31, 2023 · Databases

15 Essential Tips for Designing Robust Database Tables

This guide walks backend developers through fifteen practical best‑practice tips covering table and column naming, data types, field lengths, primary keys, storage engines, null constraints, foreign keys, indexes, time and monetary fields, character sets, collations, and handling large columns to reduce maintenance costs and avoid common pitfalls.

indexesmysqlnaming conventions
0 likes · 20 min read
15 Essential Tips for Designing Robust Database Tables
JD Cloud Developers
JD Cloud Developers
Aug 29, 2023 · Backend Development

How a Lightweight Redis‑Based Inventory Architecture Boosts High‑Traffic E‑Commerce Systems

This article examines the challenges of scaling inventory pre‑allocation in fast‑growing logistics platforms, outlines architectural principles for a lightweight, Redis‑driven solution that replaces MySQL bottlenecks, details data structures, consistency mechanisms, and performance results, and provides a roadmap for future capacity growth.

System Architecturee‑commercehigh concurrency
0 likes · 10 min read
How a Lightweight Redis‑Based Inventory Architecture Boosts High‑Traffic E‑Commerce Systems
Top Architect
Top Architect
Aug 29, 2023 · Databases

Efficient Insertion of 300,000 Records Using MyBatis and JDBC

This article explains how to insert 300,000 rows into a MySQL table efficiently by defining a User entity, configuring MyBatis mappers, and comparing three approaches—direct bulk insert, per‑row loop insert, and batch insert with configurable batch sizes—while also providing JDBC equivalents and performance tips.

JDBCMyBatisbatch-insert
0 likes · 15 min read
Efficient Insertion of 300,000 Records Using MyBatis and JDBC
Architect's Guide
Architect's Guide
Aug 29, 2023 · Databases

Why Running MySQL in Docker May Not Be Ideal: Data Safety, Performance, and Resource Isolation Issues

This article examines why containerizing MySQL with Docker can be problematic, highlighting data safety concerns, performance degradation due to I/O bottlenecks, state management limitations, and resource isolation challenges, while also presenting scenarios where containerization may be feasible and offering mitigation strategies.

ContainersData SafetyDocker
0 likes · 5 min read
Why Running MySQL in Docker May Not Be Ideal: Data Safety, Performance, and Resource Isolation Issues
Laravel Tech Community
Laravel Tech Community
Aug 28, 2023 · Databases

Common MySQL Performance Issues and Their Optimization Techniques

This article examines frequent MySQL performance problems such as inefficient LIMIT usage, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, condition push‑down, early range reduction, and intermediate result handling, and provides concrete SQL rewrites and execution‑plan analyses to dramatically improve query speed.

Query Rewriteexecution planindexing
0 likes · 13 min read
Common MySQL Performance Issues and Their Optimization Techniques