BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 35 of 50
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 5, 2022 · Databases

Weekly Community Tech Digest – MySQL Updates, Middleware Progress, and Community News

This weekly digest summarizes the latest MySQL 8.0 enhancements, replication delay case, user connection memory limits, Oracle‑to‑MySQL synchronization, new SQLE release, DBLE middleware developments, bug fixes, community Q&A, recruitment notices, and upcoming plans, providing concise technical insights for the open‑source community.

MySQLWeekly Digestcommunity
0 likes · 4 min read
Weekly Community Tech Digest – MySQL Updates, Middleware Progress, and Community News
DaTaobao Tech
DaTaobao Tech
Mar 3, 2022 · Databases

Comparative Analysis of MySQL and MongoDB: Features, Performance, and Practical Insights

The article compares MySQL’s relational tables with MongoDB’s schema‑free documents, detailing equivalent concepts, CRUD syntax, and benchmark results that show MongoDB achieving higher write and query throughput, easier schema evolution, and built‑in sharding, recommending it for new agile projects while suggesting MySQL remain viable for legacy systems.

MongoDBMySQLNoSQL
0 likes · 14 min read
Comparative Analysis of MySQL and MongoDB: Features, Performance, and Practical Insights
Architect's Tech Stack
Architect's Tech Stack
Mar 3, 2022 · Databases

Understanding MySQL InnoDB Full-Text Search and Inverted Index

This article explains why traditional B‑Tree indexes fail for keyword searches, introduces the concept of inverted indexes, shows how to create and use MySQL InnoDB full‑text indexes with MATCH‑AGAINST in various modes, and covers index maintenance and query‑expansion techniques.

Boolean ModeMySQLQuery Expansion
0 likes · 12 min read
Understanding MySQL InnoDB Full-Text Search and Inverted Index
Xianyu Technology
Xianyu Technology
Mar 2, 2022 · Databases

Optimizing a Slow SQL Query with AnalyticDB and Data Synchronization Strategies

By migrating a latency‑heavy MySQL query to AnalyticDB, employing binlog‑based real‑time sync, refining composite indexes, adding clustering and filter hints, and batching inserts, the team cut execution time from about two seconds to roughly one hundred milliseconds, achieving over 99 % of queries under one second.

AnalyticDBMySQLSQL optimization
0 likes · 12 min read
Optimizing a Slow SQL Query with AnalyticDB and Data Synchronization Strategies
Architect's Guide
Architect's Guide
Mar 2, 2022 · Databases

How to Perform Scheduled MySQL Backups Using mysqldump and Cron

This article explains various methods for scheduled MySQL backups, covering mysqldump command usage, example backup commands for whole or specific databases, a Bash script to retain a fixed number of backups, and configuring cron jobs to automate the backup and restoration processes.

CronMySQLbackup
0 likes · 11 min read
How to Perform Scheduled MySQL Backups Using mysqldump and Cron
dbaplus Community
dbaplus Community
Mar 1, 2022 · Databases

MHA Re-Edition: Modern MySQL HA with GTID Failover and Auto Switch

The MHA Re-Edition tool revives the discontinued MHA manager for MySQL, adding GTID‑based failover, password‑only SSH authentication, lightweight binaries, VIP migration, WeChat alerts, remote‑card reboot, and detailed configuration options, with step‑by‑step deployment instructions and sample app1.cnf parameters for high‑availability clusters.

GTIDMHAMySQL
0 likes · 11 min read
MHA Re-Edition: Modern MySQL HA with GTID Failover and Auto Switch
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 28, 2022 · Databases

Understanding and Using UNION in MySQL 8.0

This article explains the purpose, syntax rules, and practical examples of the UNION operator in MySQL, covering distinct and ALL modes, ORDER BY restrictions, new TABLE and VALUES usages introduced in MySQL 8.0.19, and differences from MySQL 5.7.

CodeExamplesMySQLMySQL8
0 likes · 8 min read
Understanding and Using UNION in MySQL 8.0
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 25, 2022 · Databases

SQLE 1.2202.0 Release Notes

The SQLE 1.2202.0 release introduces new user group and permission management, scoring for audit results, expanded support for MySQL, Oracle, Java application SQL capture, Db2 audit plugins, additional MySQL audit rules, UI optimizations, and several critical bug fixes.

AuditDB2MySQL
0 likes · 4 min read
SQLE 1.2202.0 Release Notes
Architecture Digest
Architecture Digest
Feb 25, 2022 · Backend Development

A Comprehensive Summary of Our Backend Interface Performance Optimization Journey

This article recounts the author's experience of identifying and solving various backend interface performance bottlenecks—including slow MySQL queries, complex business logic, thread‑pool and lock design flaws, and machine issues—by applying targeted optimizations such as pagination redesign, indexing, concurrency, and caching.

MySQLOptimizationPerformance
0 likes · 18 min read
A Comprehensive Summary of Our Backend Interface Performance Optimization Journey
Java Architect Essentials
Java Architect Essentials
Feb 24, 2022 · Databases

Why LIMIT Slows MySQL Queries and How to Speed Them Up

This article analyzes why a MySQL query with a large LIMIT offset can take seconds to run, demonstrates the underlying index and buffer‑pool behavior, and shows how rewriting the query with a sub‑select of primary keys reduces execution time from over 16 seconds to under half a second.

Buffer PoolLIMITMySQL
0 likes · 9 min read
Why LIMIT Slows MySQL Queries and How to Speed Them Up
Top Architect
Top Architect
Feb 24, 2022 · Databases

Using Sequel Pro on macOS to Manage MySQL and MariaDB Databases

This article introduces Sequel Pro, a lightweight macOS client for MySQL and MariaDB, explains how to configure standard connections, describes its main interface modules such as database selection, table structure, query editor, and provides visual guidance for common operations.

Database ManagementGUI ToolMariaDB
0 likes · 4 min read
Using Sequel Pro on macOS to Manage MySQL and MariaDB Databases
IT Services Circle
IT Services Circle
Feb 24, 2022 · Databases

Understanding InnoDB Data Pages, Index Directories, and B+ Tree Indexing

This article explains how InnoDB stores data in 16 KB pages, links pages via a double‑linked list, uses page directories and primary‑key directories for binary search, and builds B+‑tree index pages to accelerate MySQL queries, covering free space, page splits, and the overall search flow.

B+ TreeInnoDBMySQL
0 likes · 8 min read
Understanding InnoDB Data Pages, Index Directories, and B+ Tree Indexing
Tencent Database Technology
Tencent Database Technology
Feb 22, 2022 · Databases

Analysis of Relay Log Recovery and Crash Safety in MySQL GTID‑Based and Binary‑Log‑File‑Position Replication

This article examines how MySQL slaves recover their replication state in GTID‑based and binary‑log‑file‑position scenarios, identifies unsafe factors that can cause crash‑unsafe behavior, and explains how enabling relay_log_recovery=on mitigates these risks while outlining remaining limitations.

Binary LogCrash SafetyGTID
0 likes · 14 min read
Analysis of Relay Log Recovery and Crash Safety in MySQL GTID‑Based and Binary‑Log‑File‑Position Replication
dbaplus Community
dbaplus Community
Feb 21, 2022 · Databases

Why Updating Non‑Indexed Columns Can Lock the Whole Table in MySQL

Through a series of MySQL 5.7.26 experiments the article reveals how record‑level locks are applied to primary‑key indexes when non‑indexed columns are locked, how isolation levels (READ COMMITTED vs REPEATABLE READ) change the locking order, and why both SELECT … FOR UPDATE and UPDATE statements can block other transactions.

InnoDBMySQLRecord Locks
0 likes · 14 min read
Why Updating Non‑Indexed Columns Can Lock the Whole Table in MySQL
Architect's Tech Stack
Architect's Tech Stack
Feb 21, 2022 · Databases

Why MySQL May Not Be Suitable for Containerization

The article examines the drawbacks of running MySQL in Docker containers, highlighting data safety, performance, state management, and resource isolation concerns while also discussing scenarios where containerizing MySQL might be feasible.

Data SafetyDockerMySQL
0 likes · 6 min read
Why MySQL May Not Be Suitable for Containerization
Open Source Linux
Open Source Linux
Feb 21, 2022 · Operations

Mastering LVS: From Basics to MySQL High Availability with Keepalived

This article provides a comprehensive guide to Linux Virtual Server (LVS), covering its history, four operating modes, scheduling algorithms, installation steps, MySQL load‑balancing configuration, ARP suppression techniques, and high‑availability setup using keepalived, all illustrated with diagrams and code snippets.

IPVSKeepalivedLVS
0 likes · 23 min read
Mastering LVS: From Basics to MySQL High Availability with Keepalived
IT Architects Alliance
IT Architects Alliance
Feb 20, 2022 · Backend Development

Cache Consistency Strategies for Database and Redis: Tiered Storage and Synchronization Techniques

The article examines tiered data storage and evaluates four cache‑synchronization strategies—updating the database before the cache, deleting the cache before updating the database, updating the cache before the database, and deleting the cache after a database update—highlighting their trade‑offs and practical solutions such as delayed double deletion, message‑queue retries, and binlog‑driven cache updates.

BackendMySQLRedis
0 likes · 8 min read
Cache Consistency Strategies for Database and Redis: Tiered Storage and Synchronization Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 18, 2022 · Databases

SQLE 1.2202.0-pre1 Release Notes and New Features

The SQLE 1.2202.0-pre1 release introduces a preview version of the open‑source SQL audit platform with new user‑group permissions, task scoring, support for MySQL schema audits, Oracle TopSQL capture, and Java application SQL capture, along with links to the repository, documentation, and plugin development guide.

JavaMySQLOracle
0 likes · 3 min read
SQLE 1.2202.0-pre1 Release Notes and New Features
Youzan Coder
Youzan Coder
Feb 17, 2022 · Databases

Master MySQL Slow Query Optimization: Practical Indexing Techniques

This article shares hands‑on experience with MySQL 5.7 slow‑query problems, explaining common causes, proper index design, pitfalls that invalidate indexes, efficient SQL writing, deep‑pagination avoidance, and how to use EXPLAIN to verify that queries leverage the right indexes.

Explain PlanIndex OptimizationMySQL
0 likes · 16 min read
Master MySQL Slow Query Optimization: Practical Indexing Techniques
Programmer DD
Programmer DD
Feb 16, 2022 · Backend Development

Master Tencent Interview: Deep Dive into HashMap, Redis, MySQL & System Design

This article compiles a comprehensive set of Tencent interview questions and detailed answers covering HashMap internals, thread safety, red‑black trees, Redis performance, MySQL indexing, TCP reliability, IO multiplexing, RPC, and system bottleneck analysis to help candidates prepare effectively.

BackendHashMapMySQL
0 likes · 11 min read
Master Tencent Interview: Deep Dive into HashMap, Redis, MySQL & System Design
Big Data Technology & Architecture
Big Data Technology & Architecture
Feb 16, 2022 · Big Data

Using Flink CDC to Capture MySQL Changes and Sync Them to ClickHouse

This article introduces Change Data Capture (CDC), compares query‑based and log‑based approaches, explains Debezium and ClickHouse, and provides detailed Flink CDC and Flink SQL CDC examples—including Java source code, custom deserialization schema, ClickHouse sink implementation, and required Maven dependencies—to synchronize MySQL data into ClickHouse in real time.

CDCClickHouseData Streaming
0 likes · 17 min read
Using Flink CDC to Capture MySQL Changes and Sync Them to ClickHouse
IT Xianyu
IT Xianyu
Feb 14, 2022 · Databases

MySQL Data Recovery: Backup Strategies, Point‑in‑Time Restoration, Table Recovery, and Flashback Techniques

This article explains how to prevent data loss in MySQL by enabling binlog in ROW format, performing full and incremental restores using mysqldump or XtraBackup, executing point‑in‑time recovery, restoring individual tables, skipping erroneous SQL statements, and using flashback tools such as binlog2sql and MyFlash.

BinlogFlashbackMySQL
0 likes · 15 min read
MySQL Data Recovery: Backup Strategies, Point‑in‑Time Restoration, Table Recovery, and Flashback Techniques
Laravel Tech Community
Laravel Tech Community
Feb 13, 2022 · Databases

Understanding NULL Values and Their Impact on Indexes in MySQL

This article explains how MySQL treats NULL values, the behavior of IS NULL, IS NOT NULL, the spaceship operator, IFNULL, and demonstrates with practical examples how NULL affects indexing, query performance, aggregation functions, and sorting, while offering recommendations for schema design.

MySQLNULLSQL
0 likes · 12 min read
Understanding NULL Values and Their Impact on Indexes in MySQL
dbaplus Community
dbaplus Community
Feb 13, 2022 · Databases

Mastering SQL Execution Order and Optimization: Practical Tips and Best Practices

This guide walks through MySQL's query execution sequence, then presents concrete optimization techniques—from selecting specific columns and avoiding OR conditions to proper indexing, using EXPLAIN, handling VARCHAR vs CHAR, limiting result sets, and improving joins, GROUP BY, and UNION operations—complete with code examples and visual explain plans.

MySQLPerformanceSQL
0 likes · 20 min read
Mastering SQL Execution Order and Optimization: Practical Tips and Best Practices
Efficient Ops
Efficient Ops
Feb 13, 2022 · Operations

Essential Bash Scripts for Linux Ops: From DDoS Blocking to MySQL Backups

This article compiles a collection of practical Bash scripts for Linux system administrators, covering automatic DDoS IP blocking, email alert setup, single‑ and multi‑database MySQL backups, Nginx log rotation and analysis, real‑time network traffic monitoring, server initialization, and bulk disk‑usage checks across many hosts.

MySQLNginxautomation
0 likes · 10 min read
Essential Bash Scripts for Linux Ops: From DDoS Blocking to MySQL Backups
Architect
Architect
Feb 13, 2022 · Databases

Ensuring Data Consistency Between MySQL and Redis in High‑Concurrency Scenarios

This article analyzes why data inconsistencies arise when MySQL and Redis are used together under high load, compares cache‑delete ordering problems, and presents two practical solutions—delayed double‑delete and asynchronous binlog‑driven cache updates—along with implementation tips and trade‑offs.

MySQLRediscache consistency
0 likes · 8 min read
Ensuring Data Consistency Between MySQL and Redis in High‑Concurrency Scenarios
Top Architect
Top Architect
Feb 11, 2022 · Databases

Understanding MySQL INT Display Width and ZEROFILL

This article explains that the numeric value in MySQL INT definitions (e.g., int(1) or int(10)) does not limit the column's range, demonstrates inserting the maximum unsigned value, and shows how ZEROFILL combined with a display width pads numbers with leading zeros.

MySQLSQLZEROFILL
0 likes · 5 min read
Understanding MySQL INT Display Width and ZEROFILL
dbaplus Community
dbaplus Community
Feb 10, 2022 · Databases

Why MySQL Delete Doesn’t Free Space and How InnoDB Reclaims It

This article explains why MySQL’s DELETE only sets a delete‑mark, how InnoDB’s MVCC and purge thread reuse freed pages, the impact of B+‑tree storage on I/O, page merge and split mechanisms, and the proper way to rebuild tables to recover space.

B+ TreeDatabase StorageDelete Mark
0 likes · 14 min read
Why MySQL Delete Doesn’t Free Space and How InnoDB Reclaims It
Architecture & Thinking
Architecture & Thinking
Feb 10, 2022 · Databases

MySQL Custom Functions: How to Create, Use, and Compare with Stored Procedures

This guide explains MySQL custom functions, covering their definition, advantages over stored procedures, step‑by‑step creation syntax, parameter handling, invocation, and management commands such as showing, altering, and dropping functions, with practical examples for both parameterless and parameterized functions and a concise comparison table.

FunctionsMySQLSQL
0 likes · 6 min read
MySQL Custom Functions: How to Create, Use, and Compare with Stored Procedures
Architecture & Thinking
Architecture & Thinking
Feb 10, 2022 · Databases

Mastering MySQL Master‑Slave Replication: Principles, Challenges & Solutions

This article explains MySQL master‑slave replication fundamentals, why it’s used, the replication workflow, causes of lag, and presents multiple practical solutions—including system tuning, partitioning, caching, multi‑threaded relay log replay, and read‑from‑master strategies—to improve performance and reliability.

MySQLRead-Write SplittingReplication
0 likes · 12 min read
Mastering MySQL Master‑Slave Replication: Principles, Challenges & Solutions
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 9, 2022 · Databases

Performance Evaluation of Parallel DDL in MySQL 8.0.27

This article investigates how the innodb_ddl_threads, innodb_ddl_buffer_size, and innodb_parallel_read_threads variables introduced in MySQL 8.0.27 affect parallel DDL execution speed and resource consumption, using a 50‑million‑row test table and presenting detailed benchmark results.

InnoDBMySQLParallel DDL
0 likes · 7 min read
Performance Evaluation of Parallel DDL in MySQL 8.0.27
Programmer DD
Programmer DD
Feb 9, 2022 · Databases

Why Full Table Scans Won’t Exhaust MySQL Server Memory

Even when scanning a 200 GB InnoDB table on a server with only 100 GB RAM, MySQL streams results using a small net buffer and an optimized InnoDB buffer‑pool LRU, so the server’s memory never blows up, though I/O load remains high.

Buffer PoolInnoDBLRU algorithm
0 likes · 11 min read
Why Full Table Scans Won’t Exhaust MySQL Server Memory
Su San Talks Tech
Su San Talks Tech
Feb 7, 2022 · Databases

Essential MySQL Interview Q&A: Locks, Indexes, Replication, and Optimization

A comprehensive collection of MySQL interview questions and answers covering storage engines, lock types, gap locks, deadlock avoidance, isolation levels, index types, covering indexes, the left‑most prefix rule, SQL tuning, master‑slave replication, latency handling, sharding challenges, and global ID generation.

MySQLPerformanceReplication
0 likes · 15 min read
Essential MySQL Interview Q&A: Locks, Indexes, Replication, and Optimization
dbaplus Community
dbaplus Community
Feb 6, 2022 · Databases

10 Common MySQL Index Pitfalls and How to Avoid Them

This article walks through ten typical scenarios where MySQL indexes fail—covering left‑most prefix violations, SELECT *, calculations, functions, type mismatches, LIKE patterns, column comparisons, OR, NOT IN/NOT EXISTS, and ORDER BY—showing why each occurs and how to keep indexes effective.

Covering IndexEXPLAINIndex Optimization
0 likes · 22 min read
10 Common MySQL Index Pitfalls and How to Avoid Them
Top Architect
Top Architect
Feb 6, 2022 · Databases

Understanding MySQL InnoDB Full‑Text Search and Inverted Index

This article explains why InnoDB full‑text search is needed for keyword‑based queries, introduces inverted index structures, shows how to create, use, and delete full‑text indexes in MySQL, and demonstrates natural language, boolean, and query‑expansion search modes with practical SQL examples.

MySQLSQLdatabase
0 likes · 15 min read
Understanding MySQL InnoDB Full‑Text Search and Inverted Index
MaGe Linux Operations
MaGe Linux Operations
Feb 5, 2022 · Operations

Essential Linux Bash Scripts for Server Operations and Automation

This article presents a collection of practical Bash scripts for Linux servers, covering DOS attack IP blocking, alert emailing, MySQL backup (single and multi‑loop), Nginx log rotation and analysis, real‑time network traffic monitoring, system initialization, and disk usage checks across multiple hosts.

LinuxMySQLServer
0 likes · 10 min read
Essential Linux Bash Scripts for Server Operations and Automation
IT Services Circle
IT Services Circle
Feb 2, 2022 · Backend Development

Backend Engineer Interview Experience and Technical Q&A at Huanju (YY)

This article shares a detailed account of a backend engineer's multi‑stage interview process at Huanju (formerly YY), covering personal background, common Java and system design questions, database and caching strategies, distributed lock handling, and reflections on preparation and outcomes.

BackendMySQLPerformance
0 likes · 16 min read
Backend Engineer Interview Experience and Technical Q&A at Huanju (YY)
ITPUB
ITPUB
Jan 29, 2022 · Databases

Master MySQL Permissions: Granting Access, Skip-Grant Tables, and Security Best Practices

This guide explains MySQL’s permission system, shows how to configure remote access for the root user by setting the host field to ‘%’, granting all privileges, flushing privileges, and clarifies the role of the skip‑grant‑tables option, while detailing the underlying tables and privilege levels.

GrantMySQLdatabase administration
0 likes · 7 min read
Master MySQL Permissions: Granting Access, Skip-Grant Tables, and Security Best Practices
ITPUB
ITPUB
Jan 28, 2022 · Databases

6 Common MySQL Index Pitfalls That Kill Query Performance

This article explains MySQL's index storage structures, the difference between clustered and secondary indexes, and demonstrates six typical scenarios—wildcard LIKE, functions on indexed columns, expression calculations, implicit type conversion, left‑most rule violations in composite indexes, and OR conditions—that cause indexes to become ineffective and lead to full‑table scans.

InnoDBMyISAMMySQL
0 likes · 16 min read
6 Common MySQL Index Pitfalls That Kill Query Performance
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 28, 2022 · Databases

SQLE 1.2201.0 Release Notes

The SQLE 1.2201.0 release introduces workflow optimizations, new MySQL and SQL Server audit rules, enhanced pre‑check capabilities, several UI improvements, and numerous bug fixes, while providing links to the source repository, documentation, and plugin development guide.

AuditMySQLReleaseNotes
0 likes · 5 min read
SQLE 1.2201.0 Release Notes
IT Architects Alliance
IT Architects Alliance
Jan 28, 2022 · Fundamentals

Effective Knowledge Accumulation and Learning Strategies for Engineers

The article explores why knowledge retention varies among engineers, proposes concrete learning practices such as systematic note‑taking, focused "nail" learning, hands‑on experimentation with tools like tcpdump and SSH, and distinguishes between knowledge efficiency and engineering efficiency to help readers build lasting, applicable expertise.

LearningMySQLSSH
0 likes · 16 min read
Effective Knowledge Accumulation and Learning Strategies for Engineers
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 27, 2022 · Databases

DTLE 4.22.01.0 Release Notes – New Features and Bug Fixes

DTLE 4.22.01.0, an open‑source MySQL‑focused data transfer component, has been released, introducing Oracle‑MySQL incremental DDL/DML sync, enhanced WHERE clause support, initial Kafka schema‑change handling, and numerous bug fixes including binlog relay issues, character‑set handling, and CREATE TABLE … LIKE renaming problems.

DTLEData TransferKafka
0 likes · 4 min read
DTLE 4.22.01.0 Release Notes – New Features and Bug Fixes
IT Xianyu
IT Xianyu
Jan 27, 2022 · Big Data

Installing Apache Hive on macOS with Hadoop and MySQL Metastore

This tutorial provides step‑by‑step instructions for installing Hadoop 3.1.1, Homebrew, Hive, and configuring MySQL as Hive's metastore on macOS, including environment variable setup, hive‑site.xml configuration, MySQL connector placement, schema initialization, and verification commands.

HadoopHiveInstallation
0 likes · 6 min read
Installing Apache Hive on macOS with Hadoop and MySQL Metastore
JavaEdge
JavaEdge
Jan 26, 2022 · Databases

Inside MySQL: How the Server Handles Queries from Connection to Storage Engine

This article explains MySQL's client‑server architecture, detailing how the server processes connections, parses and optimizes queries, generates execution plans, and interacts with various storage engines, while also covering configuration variables, connection monitoring, and practical command examples.

MySQLOptimizerQuery Processing
0 likes · 21 min read
Inside MySQL: How the Server Handles Queries from Connection to Storage Engine
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 25, 2022 · Databases

Custom MySQL Data Consistency Check Tool: Design, Implementation, and Usage

This article introduces a custom MySQL data consistency verification tool inspired by pt-table-checksum, explains the challenges of handling complex primary keys, details the implementation logic with shell scripts and SQL, and provides installation, configuration, and usage instructions including parallelism, network monitoring, and scheduling.

MySQLautomationchecksum
0 likes · 23 min read
Custom MySQL Data Consistency Check Tool: Design, Implementation, and Usage
Selected Java Interview Questions
Selected Java Interview Questions
Jan 22, 2022 · Databases

Optimizing MyBatis Batch Inserts with ExecutorType.BATCH and Controlled foreach Values

This article analyzes why MyBatis foreach‑based batch inserts become extremely slow with thousands of rows, explains the underlying SQL and PreparedStatement overhead, and demonstrates how switching to ExecutorType.BATCH or limiting foreach values to 20‑50 rows dramatically improves MySQL insertion performance.

Batch InsertExecutorType.BATCHJava
0 likes · 9 min read
Optimizing MyBatis Batch Inserts with ExecutorType.BATCH and Controlled foreach Values
Top Architect
Top Architect
Jan 22, 2022 · Databases

Optimizing MySQL Pagination Queries with Subqueries and Buffer‑Pool Analysis

The article explains why large‑offset LIMIT queries on a MySQL table with millions of rows are slow, demonstrates how rewriting the query to use a subquery that first selects primary‑key IDs dramatically reduces execution time, and validates the improvement by measuring buffer‑pool page usage.

Buffer PoolMySQLQuery Optimization
0 likes · 9 min read
Optimizing MySQL Pagination Queries with Subqueries and Buffer‑Pool Analysis
JavaEdge
JavaEdge
Jan 21, 2022 · Databases

Can MySQL Handle a 100 GB Full Table Scan Without Crashing?

This article explains why a MySQL query that scans a 100‑gigabyte table and returns millions of rows does not exhaust server memory, describing the net_buffer mechanism, socket send buffer behavior, InnoDB buffer‑pool management, and the improved LRU algorithm used to keep large scans from degrading overall performance.

Buffer PoolInnoDBLRU
0 likes · 8 min read
Can MySQL Handle a 100 GB Full Table Scan Without Crashing?
Selected Java Interview Questions
Selected Java Interview Questions
Jan 21, 2022 · Databases

Performance Testing and Optimization of MySQL Pagination on Large Datasets

This article demonstrates how to generate, insert, and query ten‑million‑row MySQL tables, measures pagination query times under different offsets and limits, and presents practical optimization techniques such as sub‑queries, id‑range filtering, and column selection to improve performance on massive data sets.

MySQLOptimizationPerformance
0 likes · 10 min read
Performance Testing and Optimization of MySQL Pagination on Large Datasets
Tencent Database Technology
Tencent Database Technology
Jan 19, 2022 · Databases

Deep Dive into Tencent's Self‑Developed MySQL Kernel TXSQL and Its Architecture

This article provides a comprehensive overview of Tencent's self‑developed MySQL kernel TXSQL, covering its evolution, overall architecture, columnar storage engine, instant DDL capabilities, enterprise‑grade features, high‑availability mechanisms, performance optimizations, and the rigorous development and testing processes behind the product.

Cloud DatabaseMySQLPerformance Optimization
0 likes · 11 min read
Deep Dive into Tencent's Self‑Developed MySQL Kernel TXSQL and Its Architecture
ITPUB
ITPUB
Jan 19, 2022 · Databases

How a Startup Solved Midnight MySQL Timeouts: Slow‑SQL Diagnosis & Caching

During nightly peaks, a social‑e‑commerce startup experienced hour‑long service outages due to MySQL timeouts; by analyzing traffic spikes, CPU usage, and slow‑SQL logs, the team identified un‑cached ranking queries and a 20‑minute cache refresh bottleneck, then implemented targeted caching, monitoring scripts, and fallback static pages to eliminate the issue.

MySQLPerformanceSlow SQL
0 likes · 14 min read
How a Startup Solved Midnight MySQL Timeouts: Slow‑SQL Diagnosis & Caching
Tencent Architect
Tencent Architect
Jan 18, 2022 · Databases

Inside Tencent’s TXSQL: Architecture, Evolution, and Enterprise‑Grade Features

This article reviews Tencent Cloud’s self‑developed MySQL kernel TXSQL, detailing its enterprise‑grade features, evolutionary roadmap, overall and cloud‑native TDSQL‑C architecture, columnar engine for OLAP, instant DDL capabilities, high‑availability mechanisms, performance optimizations, and the rigorous development and release process that underpins its stability.

Cloud NativeColumnar EngineEnterprise Features
0 likes · 12 min read
Inside Tencent’s TXSQL: Architecture, Evolution, and Enterprise‑Grade Features
Java Backend Technology
Java Backend Technology
Jan 18, 2022 · Databases

Master MySQL Full-Text Search: Inverted Indexes, Query Modes, and Optimization

This article explains how InnoDB implements full-text search using inverted indexes, shows how to create and use full-text indexes with various query modes—including natural language, boolean, and query expansion—covers relevance calculation, stopwords, token size limits, and demonstrates how to delete indexes, all illustrated with SQL examples and diagrams.

Boolean ModeMySQLQuery Expansion
0 likes · 13 min read
Master MySQL Full-Text Search: Inverted Indexes, Query Modes, and Optimization
dbaplus Community
dbaplus Community
Jan 16, 2022 · Databases

Essential MySQL Query Optimization Tips to Avoid Full Table Scans

This guide compiles practical MySQL performance techniques—including proper indexing, avoiding costly operators, rewriting OR conditions, using EXISTS, limiting SELECT *, managing temporary tables, configuring threads, choosing storage engines, and optimizing data types—to dramatically reduce full‑table scans and improve query speed.

MySQLQuery OptimizationSQL Performance
0 likes · 21 min read
Essential MySQL Query Optimization Tips to Avoid Full Table Scans
Java Backend Technology
Java Backend Technology
Jan 15, 2022 · Databases

Why Large OFFSETs Slow MySQL Queries and How Subquery Optimization Fixes It

The article explains how using a large OFFSET in MySQL pagination forces the server to read and discard many rows, causing severe performance degradation, and demonstrates that rewriting the query to first fetch primary‑key IDs via a subquery dramatically reduces I/O and execution time, with buffer‑pool experiments confirming the improvement.

Buffer PoolMySQLPerformance
0 likes · 9 min read
Why Large OFFSETs Slow MySQL Queries and How Subquery Optimization Fixes It