BestHub
Sign in
Tagged articles
5000 articles
Page 19 of 50
Tencent Cloud Developer
Tencent Cloud Developer
Nov 30, 2023 · Backend Development

Tutorial: Building a Spring Boot CRUD Application with Tencent Hunyuan Large Model API and MySQL

This tutorial demonstrates how to prompt Tencent Hunyuan’s large‑model API to generate a Spring Boot project configured for MySQL, create a user table, and implement full JPA‑based CRUD layers—including entity, repository, service, and REST controller—while addressing common null‑field errors and testing the endpoints.

APICRUDJava
0 likes · 14 min read
Tutorial: Building a Spring Boot CRUD Application with Tencent Hunyuan Large Model API and MySQL
JavaEdge
JavaEdge
Nov 29, 2023 · Databases

How Quora Optimizes MySQL Reads, Writes, and Storage with Caching and MyRocks

This article explains how Quora reduces database load by optimizing read patterns, improving high‑QPS queries with smarter caching, shrinking table size using MyRocks, and boosting write throughput through parallel replication settings, providing concrete steps, code snippets, and real‑world results.

Database OptimizationMyRocksMySQL
0 likes · 12 min read
How Quora Optimizes MySQL Reads, Writes, and Storage with Caching and MyRocks
Architect
Architect
Nov 28, 2023 · Databases

How to Import 1 Billion Records into MySQL Efficiently: Architecture & Performance Guide

This article walks through the full engineering process of importing a billion 1 KB log records into MySQL, covering data size calculations, B‑tree index limits, batch‑insert strategies, storage‑engine trade‑offs, fast file‑reading techniques, task coordination with Redis and Redisson, and distributed‑lock design using Zookeeper.

Batch InsertDistributed TasksMySQL
0 likes · 20 min read
How to Import 1 Billion Records into MySQL Efficiently: Architecture & Performance Guide
Top Architect
Top Architect
Nov 28, 2023 · Databases

Performance Comparison of JOIN vs IN in MySQL Queries

This article experimentally compares the performance of JOIN and IN approaches for retrieving order and user data in MySQL, showing that JOIN is faster on small datasets while IN may become costly with large data volumes, and discusses code implementations and practical conclusions.

DatabaseINJoin
0 likes · 10 min read
Performance Comparison of JOIN vs IN in MySQL Queries
IT Services Circle
IT Services Circle
Nov 28, 2023 · Backend Development

Comprehensive Java Interview Guide: Basics, Collections, Concurrency, Spring Boot, MySQL, and Network Concepts

This article provides a thorough overview of Java interview topics, covering core language fundamentals, collection frameworks, concurrency mechanisms, Spring Boot transaction handling, database indexing strategies, and network protocol comparisons, all presented in clear English with code examples and diagrams.

ConcurrencyInterviewJava
0 likes · 19 min read
Comprehensive Java Interview Guide: Basics, Collections, Concurrency, Spring Boot, MySQL, and Network Concepts
MaGe Linux Operations
MaGe Linux Operations
Nov 27, 2023 · Databases

Why Does MySQL Master‑Slave Replication Lag? Causes and Fixes

This article explains why MySQL master‑slave replication can become delayed, outlines the differences between DDL and DML, shows how to diagnose lag with show slave status, and provides architectural, hardware, and configuration solutions—including semi‑synchronous replication and tuning parameters—to reduce latency.

DatabaseMaster‑SlaveMySQL
0 likes · 9 min read
Why Does MySQL Master‑Slave Replication Lag? Causes and Fixes
Architecture Digest
Architecture Digest
Nov 27, 2023 · Databases

Fast Import of 1 Billion Records into MySQL: Design, Performance, and Reliability Considerations

To import one billion 1 KB log records into MySQL efficiently, the article examines data size constraints, B‑tree index limits, batch insertion strategies, storage engine choices, file‑reading techniques, task coordination with Redis, Redisson semaphores, and distributed lock handling to ensure ordered, reliable, high‑throughput loading.

Batch InsertBig DataDistributed Systems
0 likes · 18 min read
Fast Import of 1 Billion Records into MySQL: Design, Performance, and Reliability Considerations
Su San Talks Tech
Su San Talks Tech
Nov 26, 2023 · Databases

Why Does MySQL LIMIT offset,size Slow Down With Large Offsets?

This article explains why MySQL's LIMIT offset,size becomes slower as the offset grows, compares it with LIMIT size, details the internal execution using primary and secondary indexes, discusses deep pagination issues, and presents practical optimization techniques to improve query performance.

LIMITMySQLdeep pagination
0 likes · 14 min read
Why Does MySQL LIMIT offset,size Slow Down With Large Offsets?
ITPUB
ITPUB
Nov 25, 2023 · Databases

8 Common SQL Pitfalls and How to Optimize Them for Faster Queries

This article examines eight frequent MySQL performance problems—including misuse of LIMIT, implicit type conversion, sub‑query updates, mixed ordering, EXISTS, condition push‑down, early limiting, and intermediate result push‑down—and provides concrete rewrite techniques and example code that dramatically reduce execution time.

IndexesLimitsMySQL
0 likes · 13 min read
8 Common SQL Pitfalls and How to Optimize Them for Faster Queries
Top Architect
Top Architect
Nov 24, 2023 · Databases

Introducing MySQL Innovation and Long‑Term Support (LTS) Versions

The article explains MySQL’s new versioning model, introducing Innovation and Long‑Term Support (LTS) releases, detailing transition timelines, feature deprecation, upgrade and downgrade strategies, and the role of MySQL HeatWave, while also providing links to download and community resources.

Database VersioningHeatWaveInnovation
0 likes · 17 min read
Introducing MySQL Innovation and Long‑Term Support (LTS) Versions
dbaplus Community
dbaplus Community
Nov 23, 2023 · Databases

MySQL vs MongoDB: Which Database Fits Your Needs?

This article compares MySQL and MongoDB, outlining their core concepts, shared features such as open‑source licensing and indexing, and key differences in data model, scalability, performance, flexibility, and security, while summarizing pros and cons and recommending suitable application scenarios for each database.

MongoDBMySQLRelational vs NoSQL
0 likes · 12 min read
MySQL vs MongoDB: Which Database Fits Your Needs?
MaGe Linux Operations
MaGe Linux Operations
Nov 23, 2023 · Databases

Deploy Percona XtraDB Cluster (PXC) on Docker Swarm with Load Balancing

This guide walks through setting up a Percona XtraDB Cluster (PXC) version 5.7.43 on three Docker‑installed machines, configuring hostnames, loading images, creating a Swarm overlay network, deploying the cluster, adjusting MySQL settings, handling common failures, and adding load balancing with Nginx or HAProxy.

Docker SwarmHAProxyMySQL
0 likes · 10 min read
Deploy Percona XtraDB Cluster (PXC) on Docker Swarm with Load Balancing
JD Cloud Developers
JD Cloud Developers
Nov 21, 2023 · Backend Development

Mastering Read‑Write Separation in Spring Boot: A Complete Guide

This guide explains how to implement read‑write separation in Spring Boot applications by configuring master and slave databases, creating dynamic routing data sources, using custom annotations and AOP, integrating HikariCP and MyBatis, and handling thread‑local context for optimal performance.

HikariCPMyBatisMySQL
0 likes · 10 min read
Mastering Read‑Write Separation in Spring Boot: A Complete Guide
MaGe Linux Operations
MaGe Linux Operations
Nov 21, 2023 · Databases

Boost MySQL Performance: 10 Proven Optimization Techniques

This guide presents ten practical MySQL performance optimization methods—including index creation, query rewriting, limiting result sets, avoiding SELECT *, reducing joins, using proper data types, caching with Redis, and server configuration tweaks—each illustrated with concrete SQL code examples to help you speed up your database operations.

Database TuningMySQLPerformance Optimization
0 likes · 11 min read
Boost MySQL Performance: 10 Proven Optimization Techniques
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Nov 21, 2023 · Databases

Demonstrating MySQL Transaction Isolation Levels with Practical Examples

This article explains MySQL's four transaction isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—by creating a simple table, inserting test data, and running step‑by‑step SQL scripts that illustrate the behavior of each level, including phenomena such as dirty reads, non‑repeatable reads, phantom reads, and locking.

InnoDBMySQLREAD UNCOMMITTED
0 likes · 11 min read
Demonstrating MySQL Transaction Isolation Levels with Practical Examples
Qunar Tech Salon
Qunar Tech Salon
Nov 20, 2023 · Databases

Design and Implementation of a High‑Performance Database Backup and Recovery System

This article presents a comprehensive analysis of the shortcomings of an existing database backup solution and details the architecture, high‑performance backup and restore mechanisms, dynamic throttling, storage abstraction, and experimental results of a newly designed, scalable backup‑recovery platform for MySQL databases.

Database BackupDynamic ThrottlingMySQL
0 likes · 33 min read
Design and Implementation of a High‑Performance Database Backup and Recovery System
Architect
Architect
Nov 18, 2023 · Databases

JOIN vs IN: Choosing the Faster MySQL Query Method

Through a series of local experiments on MySQL tables with varying data volumes, this article analyzes the performance trade‑offs between JOIN queries and IN‑list queries, detailing execution plans, PHP benchmarking, and the impact of large IN lists on query speed and reliability.

Database OptimizationINJoin
0 likes · 10 min read
JOIN vs IN: Choosing the Faster MySQL Query Method
IT Architects Alliance
IT Architects Alliance
Nov 17, 2023 · Backend Development

Design and Implementation of a Generic Asynchronous Processing SDK

This article introduces a generic asynchronous processing SDK for Java Spring applications, covering its purpose, advantages, underlying principles, component choices such as Kafka, XXL‑Job, MySQL, design patterns, database schema, configuration via Apollo, usage instructions, safety considerations, and provides code examples and a GitHub repository link.

AOPAsyncKafka
0 likes · 9 min read
Design and Implementation of a Generic Asynchronous Processing SDK
Architecture & Thinking
Architecture & Thinking
Nov 17, 2023 · Databases

Mastering MySQL Transactions: ACID, Isolation Levels, and Common Pitfalls

This article explains MySQL transaction fundamentals, the necessity of ACID properties, details the four isolation levels and their impact on phenomena like dirty reads, non‑repeatable reads, and phantom reads, and provides practical SQL examples and strategies for ensuring data consistency in high‑concurrency environments.

ACIDDatabase ConcurrencyInnoDB
0 likes · 15 min read
Mastering MySQL Transactions: ACID, Isolation Levels, and Common Pitfalls
Test Development Learning Exchange
Test Development Learning Exchange
Nov 17, 2023 · Backend Development

Building a Short URL Service with Flask and Django

This article explains the benefits of using short‑link services for marketing, sharing, and SMS optimization, and provides step‑by‑step Flask and Django tutorials—including installation commands, MySQL integration, URL generation, routing, and database models—to create a functional short URL platform.

Backend DevelopmentDjangoFlask
0 likes · 7 min read
Building a Short URL Service with Flask and Django
Su San Talks Tech
Su San Talks Tech
Nov 15, 2023 · Databases

Understanding MySQL SELECT … FOR UPDATE Locks: Row, Gap, or Table?

This article explains how MySQL's SELECT … FOR UPDATE statement applies different lock types—row, gap, or table—depending on whether the WHERE clause uses primary keys, unique indexes, regular indexes, range queries, or empty results, and demonstrates each case with practical SQL examples and screenshots.

Gap LockMySQLSELECT FOR UPDATE
0 likes · 10 min read
Understanding MySQL SELECT … FOR UPDATE Locks: Row, Gap, or Table?
JD Cloud Developers
JD Cloud Developers
Nov 14, 2023 · Databases

How MySQL Executes a Simple SQL Query: Step‑by‑Step Deep Dive

This article walks through the complete lifecycle of a MySQL query—from the client request, through connection handling, parsing, optimization, execution, and storage engine processing—illustrating each component with diagrams, code snippets, and a detailed analysis of execution order for both simple and join queries.

Database InternalsMySQLSQL Execution
0 likes · 12 min read
How MySQL Executes a Simple SQL Query: Step‑by‑Step Deep Dive
dbaplus Community
dbaplus Community
Nov 13, 2023 · Databases

How a MySQL CPU Spike Exposed Critical Query Mis‑optimizations

An urgent overnight incident revealed a MySQL server’s CPU soaring to 400% due to poorly written queries, prompting a detailed analysis of execution plans, identification of costly operations like filesort and temporary tables, and concrete recommendations for query and team improvements.

BackendDatabaseMySQL
0 likes · 8 min read
How a MySQL CPU Spike Exposed Critical Query Mis‑optimizations
Efficient Ops
Efficient Ops
Nov 13, 2023 · Databases

Understanding MySQL Parallel Replication: From Lag to Group Commit

This article explains why master‑slave lag occurs in MySQL, describes the evolution of parallel replication schemes—including group‑commit, Commit‑Parent‑Based, Lock‑Based, and WRITESET approaches—shows benchmark results, and provides practical configuration steps to enable high‑performance parallel replication.

Group CommitMySQLPerformance Benchmark
0 likes · 19 min read
Understanding MySQL Parallel Replication: From Lag to Group Commit
Architect
Architect
Nov 13, 2023 · Backend Development

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

This article explains why asynchronous processing is needed in evolving systems, outlines the goals of guaranteeing execution without blocking the main flow, and walks through a complete SDK design that uses Spring transaction events, Kafka, XXL‑Job, MySQL, and a Vue UI, including configuration, code snippets, and deployment details.

AsynchronousBackendKafka
0 likes · 10 min read
Designing a Robust Asynchronous Processing SDK with Spring, Kafka, and MySQL
JD Tech
JD Tech
Nov 13, 2023 · Databases

Analysis of MySQL Lock Mechanisms and Deadlock Scenarios

This article examines MySQL's various lock types—including shared, exclusive, gap, next‑key, and insert‑intention locks—illustrates how they interact during concurrent transactions, analyzes a real‑world deadlock incident, and provides recommendations for preventing similar concurrency issues in high‑traffic systems.

ConcurrencyLocksMySQL
0 likes · 19 min read
Analysis of MySQL Lock Mechanisms and Deadlock Scenarios
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 13, 2023 · Databases

MySQL Backup and Recovery Best Practices

This article explains why MySQL backups are essential, defines RTO and RPO, compares physical and logical backup methods, describes snapshot, binary‑log, incremental and differential strategies, and provides best‑practice recommendations and example commands for reliable backup and recovery.

DatabaseMySQLPercona XtraBackup
0 likes · 13 min read
MySQL Backup and Recovery Best Practices
IT Services Circle
IT Services Circle
Nov 12, 2023 · Databases

Why Many Large Internet Companies Avoid Using MySQL Foreign Keys

The article explains that while MySQL foreign keys ensure data consistency and integrity, they introduce performance overhead, lock contention, and scalability issues—especially in high‑concurrency and sharded environments—leading many large internet firms to forego them in favor of application‑level solutions.

Database PerformanceForeign KeyMySQL
0 likes · 5 min read
Why Many Large Internet Companies Avoid Using MySQL Foreign Keys
ITPUB
ITPUB
Nov 10, 2023 · Databases

Why Does MySQL Replication Lag? Causes and Practical Fixes

This article explains what MySQL master‑slave replication lag is, walks through the replication workflow, identifies the main technical reasons for delay such as single‑threaded replay and lock contention, and provides concrete configuration and architectural solutions to reduce or eliminate the lag.

DatabasesLagMySQL
0 likes · 8 min read
Why Does MySQL Replication Lag? Causes and Practical Fixes
JD Tech
JD Tech
Nov 9, 2023 · Databases

Optimizing Pagination Queries for Billion‑Row MySQL Tables

This article analyzes the performance problems of LIMIT‑based pagination on massive MySQL tables and presents three progressively more efficient solutions—including a simple LIMIT approach, a tag‑record method using the last primary key, and a range‑limit method with cached min‑ID—along with best‑practice indexing recommendations to keep query latency in the tens of milliseconds even for tables containing billions of rows.

Index OptimizationLarge DataMySQL
0 likes · 12 min read
Optimizing Pagination Queries for Billion‑Row MySQL Tables
ITPUB
ITPUB
Nov 9, 2023 · Databases

Understanding MySQL Locks: When to Use Them, How They Work, and When to Avoid Them

This article explains the fundamentals of MySQL locking—including explicit and implicit locks, transaction isolation levels, next‑key and gap locks, and practical session‑based examples—so developers can decide when to apply pessimistic locks and when to prefer safer alternatives.

Database PerformanceInnoDBLocks
0 likes · 17 min read
Understanding MySQL Locks: When to Use Them, How They Work, and When to Avoid Them
Efficient Ops
Efficient Ops
Nov 8, 2023 · Databases

Which Database Reigns Supreme? MySQL vs PostgreSQL Deep Dive

This article analyzes the popularity, success metrics, distributed versus centralized architectures, TPC‑C benchmark relevance, and a detailed feature comparison between MySQL and PostgreSQL, concluding which system currently leads in real‑world OLTP deployments.

DB-EnginesMySQLPostgreSQL
0 likes · 16 min read
Which Database Reigns Supreme? MySQL vs PostgreSQL Deep Dive
Senior Tony
Senior Tony
Nov 8, 2023 · Databases

Beyond Row and Table Locks: Uncovering MySQL’s Hidden Lock Types

This article examines MySQL's comprehensive lock taxonomy, starting from common row and table locks, then delving into lesser‑known mechanisms such as global locks, intention locks, auto‑increment locks, and Latch, while explaining their commands, use‑cases, and performance implications for developers and DBAs.

DatabaseInnoDBLocks
0 likes · 10 min read
Beyond Row and Table Locks: Uncovering MySQL’s Hidden Lock Types
政采云技术
政采云技术
Nov 8, 2023 · Databases

Understanding MySQL ORDER BY and LIMIT: Execution Principles, Sorting Algorithms, and Pagination Optimization

This article provides a comprehensive technical analysis of how MySQL processes ORDER BY and LIMIT clauses during pagination queries, detailing index utilization, filesort mechanisms, memory-based sorting algorithms, and practical optimization strategies for resolving deep pagination performance bottlenecks.

Database OptimizationFilesort AlgorithmMySQL
0 likes · 11 min read
Understanding MySQL ORDER BY and LIMIT: Execution Principles, Sorting Algorithms, and Pagination Optimization
Architect
Architect
Nov 7, 2023 · Databases

MySQL Architecture, Indexes, and SQL Optimization Guide

This article explains MySQL's basic architecture, demonstrates how to view and set storage engines, and provides comprehensive guidance on SQL optimization methods, index types, creation, usage, and performance analysis using EXPLAIN, helping readers improve query efficiency and avoid common pitfalls.

Database PerformanceEXPLAINIndexes
0 likes · 35 min read
MySQL Architecture, Indexes, and SQL Optimization Guide
Architecture & Thinking
Architecture & Thinking
Nov 7, 2023 · Databases

How MySQL InnoDB Achieves High Concurrency with MVCC and Locks

This article explains MySQL InnoDB's concurrency control mechanisms—including read‑write locks, transaction isolation levels, MVCC, redo/undo logs, and rollback segments—and shows how they work together to ensure data consistency while maximizing read/write performance in high‑traffic environments.

Concurrency ControlInnoDBLocks
0 likes · 12 min read
How MySQL InnoDB Achieves High Concurrency with MVCC and Locks
Laravel Tech Community
Laravel Tech Community
Nov 6, 2023 · Databases

MySQL InnoDB Configuration Parameters and Optimization Guide

This article explains how to tune MySQL's InnoDB settings—including buffer pool size, log file configuration, I/O threads, flush behavior, and timeout values—by providing detailed explanations and exact configuration snippets to improve performance and resource usage.

Database TuningInnoDBMySQL
0 likes · 7 min read
MySQL InnoDB Configuration Parameters and Optimization Guide
ITPUB
ITPUB
Nov 6, 2023 · Databases

Why MySQL Dominates China While PostgreSQL Lags Behind

Despite PostgreSQL’s rapid global growth, MySQL remains the leading database in China, a gap explained by early Windows support, the entrenched LAMP stack, lower entry barriers, extensive tooling, and strong backing from major tech firms, as illustrated by trend data and ecosystem analysis.

ChinaDatabase PopularityEcosystem
0 likes · 9 min read
Why MySQL Dominates China While PostgreSQL Lags Behind
Tencent Cloud Developer
Tencent Cloud Developer
Nov 6, 2023 · Databases

MySQL Lock Mechanisms: When, How, and When Not to Use

The article explains MySQL’s explicit and implicit lock mechanisms—including SELECT … FOR UPDATE, metadata, row, gap, and next‑key locks—how isolation levels affect them, and offers practical guidelines such as using optimistic locking, indexing locked columns, and avoiding long transactions to prevent phantom reads, deadlocks, and performance issues.

Database PerformanceInnoDBMySQL
0 likes · 15 min read
MySQL Lock Mechanisms: When, How, and When Not to Use
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 6, 2023 · Databases

MySQL 8.2 Release Highlights and Community Contributions

MySQL 8.2, released on October 25, 2023, is the second Innovation version that brings numerous community contributions, new client options, InnoDB fixes, optimizer improvements, Clone plugin updates, and documentation changes, while inviting developers to contribute via GitHub or MySQL Bugs.

8.2MySQLcontributions
0 likes · 5 min read
MySQL 8.2 Release Highlights and Community Contributions
dbaplus Community
dbaplus Community
Nov 5, 2023 · Backend Development

Three Hidden Pagination Pitfalls That Can Break Your Production System

The article recounts three real‑world pagination bugs—batch‑processing loops, misuse of MyBatis PageHelper, and nondeterministic results from identical ORDER BY values—explaining why they occur, how they manifest in production, and concrete fixes to avoid data loss or endless loops.

MyBatisMySQLpagehelper
0 likes · 15 min read
Three Hidden Pagination Pitfalls That Can Break Your Production System
Top Architecture Tech Stack
Top Architecture Tech Stack
Nov 5, 2023 · Databases

Understanding MySQL Communication Protocols, Parsing, Optimizer, Storage Engines, and Execution Engine

This article explains how MySQL establishes connections, the supported communication protocols and message formats, the lexical and syntactic parsing process, query optimization and execution plan generation, the role of different storage engines, and how the execution engine uses the plan to operate on the storage layer.

Communication ProtocolExecution EngineMySQL
0 likes · 15 min read
Understanding MySQL Communication Protocols, Parsing, Optimizer, Storage Engines, and Execution Engine
php Courses
php Courses
Nov 4, 2023 · Databases

Common Causes of MySQL Database Crashes and Their Solutions

This article outlines the typical reasons MySQL databases crash—such as hardware failures, software issues, external attacks, and poor design—and provides practical remedies including regular backups, using myisamchk for repair, leveraging binary logs, optimizing schemas, and upgrading to newer MySQL versions.

Database CrashMySQLOptimization
0 likes · 4 min read
Common Causes of MySQL Database Crashes and Their Solutions
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Nov 4, 2023 · Databases

Understanding MySQL Lock Types: Shared, Exclusive, Intention, Gap, Next‑Key, and Insert‑Intention Locks with Deadlock Analysis

This article explains MySQL's various lock mechanisms—including shared (S) and exclusive (X) locks, intention locks, record, gap, next‑key, and insert‑intention locks—illustrates their behavior with SQL examples, analyzes a concurrent insert deadlock scenario, and offers practical mitigation strategies.

DatabaseInnoDBLocks
0 likes · 11 min read
Understanding MySQL Lock Types: Shared, Exclusive, Intention, Gap, Next‑Key, and Insert‑Intention Locks with Deadlock Analysis
Java Interview Crash Guide
Java Interview Crash Guide
Nov 3, 2023 · Databases

5 Critical Reasons Docker Isn't Ideal for MySQL

While Docker simplifies many development tasks, this article examines five key drawbacks of running MySQL in containers—including data loss risks, performance bottlenecks, statefulness issues, limited resource isolation, and unsuitable use cases—offering guidance on when to avoid or adapt containerization for databases.

ContainersDockerMySQL
0 likes · 7 min read
5 Critical Reasons Docker Isn't Ideal for MySQL
php Courses
php Courses
Nov 3, 2023 · Backend Development

Comparison of Popular Open-Source CMS Platforms for Personal Websites

This article reviews ten open‑source content management systems—including Joomla!, Drupal, Mambo, DEDECMS, phpCMS, EmpireCMS, php168, HBcms, SupSite, and WordPress—highlighting their features, platform compatibility, strengths, and limitations to help individuals choose the most suitable CMS for building a personal website.

CMSMySQLPHP
0 likes · 5 min read
Comparison of Popular Open-Source CMS Platforms for Personal Websites
Architect's Guide
Architect's Guide
Nov 3, 2023 · Databases

Performance Evaluation of Inserting Hundreds of Millions of Records into MySQL Using Java, MyBatis, and JDBC

This article experimentally compares three Java‑based insertion strategies—MyBatis without transaction, plain JDBC with and without transaction, and JDBC batch processing—with and without transactions, measuring how they affect the time required to insert tens of millions of rows into MySQL.

Batch processingDatabase OptimizationJDBC
0 likes · 13 min read
Performance Evaluation of Inserting Hundreds of Millions of Records into MySQL Using Java, MyBatis, and JDBC
Laravel Tech Community
Laravel Tech Community
Nov 2, 2023 · Databases

MyISAM Related Options and Configuration Guidelines

This article explains the purpose, recommended settings, and tuning tips for MyISAM‑related MySQL variables such as key_buffer_size, read_buffer_size, read_rnd_buffer_size, bulk_insert_buffer_size, myisam_sort_buffer_size, myisam_max_sort_file_size, myisam_repair_threads, and myisam_recover, helping DBAs optimize indexing and query performance.

BuffersMyISAMMySQL
0 likes · 4 min read
MyISAM Related Options and Configuration Guidelines
dbaplus Community
dbaplus Community
Nov 2, 2023 · Databases

Scaling a Ride‑Hailing Order System: From Single SQLServer to Sharded MySQL

This article recounts the step‑by‑step evolution of a ride‑hailing order service’s data layer—from a single SQLServer database through SQL optimization, read‑write splitting, business‑domain sharding, caching and MQ integration, to a custom sharding component and smooth migration to MySQL—highlighting challenges, solutions, and lessons learned.

CachingData MigrationMessage queue
0 likes · 15 min read
Scaling a Ride‑Hailing Order System: From Single SQLServer to Sharded MySQL
Top Architecture Tech Stack
Top Architecture Tech Stack
Nov 2, 2023 · Databases

Strategies for Efficiently Importing One Billion Records into MySQL

This article analyzes the constraints of loading one billion 1 KB log records from distributed storage into MySQL, evaluates single‑table limits, proposes batch‑insert, sharding, storage‑engine, file‑reading, and distributed‑task coordination techniques to achieve high‑speed, ordered, and reliable data ingestion.

Batch InsertJavaMySQL
0 likes · 18 min read
Strategies for Efficiently Importing One Billion Records into MySQL
ITPUB
ITPUB
Nov 2, 2023 · Databases

How to Diagnose and Fix Slow SQL Queries: Practical Steps and Real Examples

This article explains why slow SQL queries become a major risk for service stability, outlines a step‑by‑step investigation process using EXPLAIN, and presents multiple real‑world case studies with code snippets and optimization principles to quickly locate and resolve performance bottlenecks.

EXPLAINMySQLsql
0 likes · 14 min read
How to Diagnose and Fix Slow SQL Queries: Practical Steps and Real Examples
Java High-Performance Architecture
Java High-Performance Architecture
Nov 2, 2023 · Databases

How to Tackle Large MySQL Tables: Partitioning, Sharding, and Archiving Strategies

When MySQL tables grow to millions of rows, insert and query latency increase, schema changes become costly, and irrelevant data bloats storage, so this guide evaluates table size, explains why B+‑tree depth hurts performance, and presents partitioning, sharding, and hot‑cold archiving solutions with practical SQL examples.

B+TreeDatabase OptimizationMySQL
0 likes · 15 min read
How to Tackle Large MySQL Tables: Partitioning, Sharding, and Archiving Strategies
Laravel Tech Community
Laravel Tech Community
Nov 1, 2023 · Databases

MySQL my.cnf Configuration Parameters Reference

This article presents a detailed reference of MySQL server configuration options (my.cnf), explaining each setting such as storage engine, networking, replication, logging, cache sizes, and performance‑related parameters to help administrators fine‑tune their databases.

Database ConfigurationMySQLPerformance tuning
0 likes · 12 min read
MySQL my.cnf Configuration Parameters Reference
dbaplus Community
dbaplus Community
Nov 1, 2023 · Databases

What’s New in MySQL 8.2.0? Features, Deprecations, and Firewall Updates

MySQL 8.2.0, released on October 25, 2023, introduces audit‑log cleanup scripts, FIDO‑based authentication, named‑parameter support, numerous deprecations, firewall reload scheduling, expanded SQL syntax options, and new client and server features while dropping outdated functions and variables.

Database FeaturesMySQLRelease Notes
0 likes · 9 min read
What’s New in MySQL 8.2.0? Features, Deprecations, and Firewall Updates
Efficient Ops
Efficient Ops
Nov 1, 2023 · Databases

Why MySQL Single Tables Should Stay Below 20 Million Rows: Theory & Practice

This article explains the technical reasons why a MySQL single table should not exceed about 20 million rows, covering limits from auto‑increment primary keys, data‑page structures, B+‑tree storage calculations, and practical partitioning recommendations for large‑scale applications.

B+TreeMySQLTable Size Limits
0 likes · 9 min read
Why MySQL Single Tables Should Stay Below 20 Million Rows: Theory & Practice
ITPUB
ITPUB
Oct 31, 2023 · Databases

Demystifying MySQL InnoDB Buffers: Pool, Change, Log & Doublewrite

This article explains MySQL InnoDB’s key buffering mechanisms—buffer pool, change buffer, log buffer, and doublewrite buffer—detailing their roles, internal structures, eviction policies, and how they improve performance and data durability while handling page reads, writes, and crash recovery.

Change BufferDatabase PerformanceDoublewrite
0 likes · 14 min read
Demystifying MySQL InnoDB Buffers: Pool, Change, Log & Doublewrite
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 31, 2023 · Databases

MySQL Disaster Recovery: Multi‑Region Three‑Center Replication and RTO/RPO Optimization

This article explains the principles of disaster recovery for MySQL, covering RTO/RPO metrics, national backup level standards, common master‑slave topologies, a comparative analysis of high‑availability solutions, and a detailed three‑center multi‑region replication design with code patches to avoid replication loops.

DatabaseMySQLRPO
0 likes · 17 min read
MySQL Disaster Recovery: Multi‑Region Three‑Center Replication and RTO/RPO Optimization
ITPUB
ITPUB
Oct 30, 2023 · Databases

Why MySQL Queries Slow Down and How to Speed Them Up

This article explores common reasons MySQL queries become sluggish—beyond missing indexes—including connection limits, insufficient InnoDB buffer pool size, and query cache issues, and provides practical steps such as profiling, using FORCE INDEX, adjusting max_connections, enlarging the buffer pool, and tuning connection pools to improve performance.

Connection PoolMySQLProfiling
0 likes · 16 min read
Why MySQL Queries Slow Down and How to Speed Them Up
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 30, 2023 · Databases

MySQL 8.2 Transparent Read/Write Splitting with MySQL Router

MySQL 8.2 introduces transparent read/write splitting via MySQL Router, allowing automatic routing of read traffic to replica instances and write traffic to the primary source without any changes to the application, demonstrated with a simple InnoDB ReplicaSet deployment and configuration examples.

DatabasePerformanceInnoDBReplicaSetMySQL
0 likes · 6 min read
MySQL 8.2 Transparent Read/Write Splitting with MySQL Router
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 30, 2023 · Databases

ActionTech Open Source Community Weekly Newsletter – SQLE Updates, Technical Articles, and Events

The newsletter announces the SQLE 3.0 release with new UI and demo environments, highlights the SQLE 2.2310.0‑pre3 update, reviews technical articles on MySQL cloning, OceanBase indexing, data replication, charset issues, and connection‑pool design, recaps recent conferences, and previews upcoming OB Cloud open class events.

DataReplicationDatabaseMySQL
0 likes · 8 min read
ActionTech Open Source Community Weekly Newsletter – SQLE Updates, Technical Articles, and Events
dbaplus Community
dbaplus Community
Oct 29, 2023 · Databases

Why MySQL 8.0 MTS Hangs After 2³¹ Transactions and How to Reproduce the Bug

MySQL 8.0.28 and earlier can deadlock in multi‑threaded slave replication when the internal commit sequence counter overflows after 2³¹ transactions, causing workers to stop waking and the replica to hang; the article explains the underlying slave_preserve_commit_order mechanism, the overflow bug, and a step‑by‑step reproduction method.

MTSMySQLbug reproduction
0 likes · 11 min read
Why MySQL 8.0 MTS Hangs After 2³¹ Transactions and How to Reproduce the Bug
Architecture & Thinking
Architecture & Thinking
Oct 27, 2023 · Databases

How to Choose the Optimal Prefix Length for MySQL Indexes

This article explains why indexing long character columns can bloat MySQL indexes, introduces the concept of index selectivity, shows how to calculate the best prefix length with real‑world queries, and demonstrates performance differences between short and optimal index prefixes.

MySQLPrefix IndexSelectivity
0 likes · 8 min read
How to Choose the Optimal Prefix Length for MySQL Indexes
ITPUB
ITPUB
Oct 26, 2023 · Databases

Mastering Case Sensitivity Across Snowflake, Databend, MySQL, and PostgreSQL

This guide explains why case‑sensitivity issues arise in databases, how naming conventions can prevent them, and compares the behavior of Snowflake, Databend, MySQL, and PostgreSQL for database, table, column names and string literals, complete with practical examples and a concise checklist.

DatabasesDatabendMySQL
0 likes · 6 min read
Mastering Case Sensitivity Across Snowflake, Databend, MySQL, and PostgreSQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 26, 2023 · Databases

SQL Learning Course Outline and Book Giveaway Announcement

This announcement details a book giveaway sponsored by Tsinghua University Press and presents a comprehensive SQL learning curriculum covering SQLite, MySQL, query fundamentals, subqueries, joins, and advanced database features, complete with micro‑lecture videos and hands‑on exercises.

Book GiveawayDatabaseDatabase tutorial
0 likes · 9 min read
SQL Learning Course Outline and Book Giveaway Announcement
Practical DevOps Architecture
Practical DevOps Architecture
Oct 26, 2023 · Operations

Step-by-Step Guide to Deploy MySQL Using Ansible Roles

This tutorial walks through creating an Ansible role that structures directories, defines configuration templates, sets variables, writes task files, and runs a playbook to install MySQL 8.0.32 on a Linux host, illustrating a complete automation workflow for database deployment.

AnsibleDevOpsMySQL
0 likes · 4 min read
Step-by-Step Guide to Deploy MySQL Using Ansible Roles
ITPUB
ITPUB
Oct 25, 2023 · Databases

SELECT FOR UPDATE: When MySQL Locks Rows vs. Tables – 20 Tested Scenarios

This article systematically investigates how MySQL's SELECT FOR UPDATE behaves under different versions (5.7 and 8.0) and isolation levels (RR and RC), covering twenty scenarios that vary by index type and query range, and summarizes whether the statement acquires row‑level, gap, or table‑level locks.

MySQLSELECT FOR UPDATElocking
0 likes · 21 min read
SELECT FOR UPDATE: When MySQL Locks Rows vs. Tables – 20 Tested Scenarios
MaGe Linux Operations
MaGe Linux Operations
Oct 25, 2023 · Cloud Native

Deploy a Typecho Blog on Kubernetes: Step‑by‑Step Guide with MySQL

This tutorial walks you through preparing a Kubernetes cluster, deploying MySQL and Typecho containers with detailed YAML configurations, creating the necessary services and ingress, testing the setup, and highlighting Kubernetes' high‑availability and auto‑scaling benefits for a reliable blog platform.

MySQLTypechoYAML
0 likes · 8 min read
Deploy a Typecho Blog on Kubernetes: Step‑by‑Step Guide with MySQL