Tagged articles
5000 articles
Page 37 of 50
Top Architect
Top Architect
Jul 19, 2021 · Databases

Why MySQL DELETE Does Not Reduce Table File Size and How to Shrink It

The article explains why deleting rows in MySQL does not shrink the physical table file, describes the underlying InnoDB storage mechanisms, and provides practical methods such as OPTIMIZE TABLE, ALTER TABLE, and Online DDL to reclaim space and reorganize the table.

ALTER TABLEDatabase MaintenanceDelete
0 likes · 7 min read
Why MySQL DELETE Does Not Reduce Table File Size and How to Shrink It
21CTO
21CTO
Jul 18, 2021 · Databases

Why Your MySQL Queries Are Slow and How ElasticSearch & HBase Can Help

This article examines common causes of slow MySQL queries, explains index mechanics and failures, then compares ElasticSearch’s fast tokenized search and HBase’s column‑oriented storage, offering practical guidance on when and how to use each technology.

Big DataDatabase PerformanceHBase
0 likes · 21 min read
Why Your MySQL Queries Are Slow and How ElasticSearch & HBase Can Help
Top Architect
Top Architect
Jul 17, 2021 · Databases

Understanding MySQL Query Optimization and Index Design

This article explains MySQL’s logical architecture, query processing steps, and the principles behind query optimization, covering topics such as client‑server protocol, query cache, parsing, cost‑based optimizer, execution engine, and practical index design strategies to improve performance.

Database PerformanceIndexesMySQL
0 likes · 35 min read
Understanding MySQL Query Optimization and Index Design
Code Ape Tech Column
Code Ape Tech Column
Jul 16, 2021 · Databases

How to Recover Disk Space from MySQL Fragmentation: A Step‑by‑Step Guide

This article walks through diagnosing MySQL disk‑usage spikes caused by data fragmentation, explains why common cleanup commands may fail, and provides a detailed, repeatable procedure—including stopping the service, removing InnoDB files, and restoring the database—to finally free up the occupied space.

Database MaintenanceMySQLOptimization
0 likes · 8 min read
How to Recover Disk Space from MySQL Fragmentation: A Step‑by‑Step Guide
Top Architect
Top Architect
Jul 16, 2021 · Backend Development

Flash-Waimai: A Complete Spring Boot + Vue Food Delivery System Tutorial

This article introduces the Flash-Waimai project—a full‑stack food delivery system built with Spring Boot, Vue.js, MySQL and MongoDB—detailing its architecture, module breakdown, database setup, quick‑start commands, and step‑by‑step instructions for launching the backend, admin portal, and mobile client.

MongoDBMySQLSpring Boot
0 likes · 5 min read
Flash-Waimai: A Complete Spring Boot + Vue Food Delivery System Tutorial
Java Interview Crash Guide
Java Interview Crash Guide
Jul 16, 2021 · Databases

Master‑Slave MySQL Replication: Core Principles, Common Pitfalls, and Advanced Strategies

This article explains MySQL master‑slave replication fundamentals, including basic synchronization, circular replication issues, lag handling, failover strategies, parallel replication techniques, GTID usage, and read‑write splitting, providing practical guidance for reliable high‑availability database deployments.

GTIDMaster‑SlaveMySQL
0 likes · 33 min read
Master‑Slave MySQL Replication: Core Principles, Common Pitfalls, and Advanced Strategies
Selected Java Interview Questions
Selected Java Interview Questions
Jul 15, 2021 · Databases

Fundamentals and Advanced Strategies of MySQL Master‑Slave Replication

This article explains the basic principles of MySQL master‑slave architecture, the role of read‑only replicas, loop‑replication problems, master‑slave delay measurement, various failover strategies, parallel replication mechanisms across MySQL versions and MariaDB, GTID usage, and read‑write splitting techniques, providing practical commands and diagrams for each concept.

Database LagGTIDMaster‑Slave
0 likes · 31 min read
Fundamentals and Advanced Strategies of MySQL Master‑Slave Replication
Top Architect
Top Architect
Jul 11, 2021 · Databases

Handling Duplicate Inserts in MySQL: Strategies and MyBatis Batch Example

The article discusses efficient ways to perform bulk inserts in MySQL while avoiding duplicate records, covering techniques such as INSERT IGNORE, ON DUPLICATE KEY UPDATE, INSERT…SELECT…WHERE NOT EXISTS, REPLACE INTO, and demonstrates a practical MyBatis implementation with a unique mobile_number constraint.

Batch InsertINSERT IGNOREMyBatis
0 likes · 5 min read
Handling Duplicate Inserts in MySQL: Strategies and MyBatis Batch Example
ITPUB
ITPUB
Jul 9, 2021 · Databases

Boost MySQL Performance: Proven SQL, Index, and Hardware Optimization Techniques

This article presents a comprehensive guide to MySQL performance improvement, covering SQL and index tuning, pagination tricks, join and UNION optimizations, slow‑query logging, schema design choices, and hardware considerations, each illustrated with concrete examples and practical code snippets.

MySQL
0 likes · 15 min read
Boost MySQL Performance: Proven SQL, Index, and Hardware Optimization Techniques
Selected Java Interview Questions
Selected Java Interview Questions
Jul 9, 2021 · Backend Development

Various Strategies for Deploying Distributed Scheduled Tasks on a Single Server

The article compares five practical methods—single‑server deployment, IP‑based restriction, database‑driven task selection, Redis expiration with distributed lock, and Quartz clustering—to ensure that a scheduled job runs only once across multiple servers, outlining each approach's advantages, drawbacks, and implementation details.

MySQLQuartzRedis
0 likes · 5 min read
Various Strategies for Deploying Distributed Scheduled Tasks on a Single Server
Laravel Tech Community
Laravel Tech Community
Jul 8, 2021 · Databases

Understanding Optimistic and Pessimistic Locks in MySQL/InnoDB

This article explains the concepts, mechanisms, and practical code examples of optimistic and pessimistic locking in MySQL/InnoDB, including version‑based optimistic locks, shared (read) locks, exclusive (write) locks, and how to apply them with Laravel's query builder.

Database ConcurrencyLaravelMySQL
0 likes · 6 min read
Understanding Optimistic and Pessimistic Locks in MySQL/InnoDB
Sohu Tech Products
Sohu Tech Products
Jul 7, 2021 · Backend Development

Implementing Nearby‑People (LBS) with MySQL and Redis GEO

This article explains how to build a location‑based "nearby people" feature by storing coordinates in MySQL, filtering with rectangular bounds, calculating distances in Java, and then scaling the solution with Redis GEO using GeoHash and Sorted Sets for high‑performance proximity queries.

GeoHashLBSLocation Services
0 likes · 14 min read
Implementing Nearby‑People (LBS) with MySQL and Redis GEO
dbaplus Community
dbaplus Community
Jul 6, 2021 · Databases

Why Do MySQL Transactions Deadlock and How Can You Prevent It?

This article explains the root causes of MySQL deadlocks in InnoDB, walks through transaction and lock fundamentals, analyzes real‑world log cases, and presents practical solutions such as adjusting isolation levels, using SELECT FOR UPDATE, adding unique indexes, or checking existence before deletion to eliminate deadlocks.

DatabaseInnoDBLock
0 likes · 12 min read
Why Do MySQL Transactions Deadlock and How Can You Prevent It?
Top Architect
Top Architect
Jul 5, 2021 · Databases

MySQL Implicit Type Conversion Leads to Unexpected Query Results

This article explains how MySQL implicitly converts mismatched column types—such as comparing a VARCHAR column with a numeric literal—into floating‑point numbers, causing seemingly equal values to match, losing index usage, and potentially producing incorrect query results.

Implicit ConversionIndex UsageMySQL
0 likes · 7 min read
MySQL Implicit Type Conversion Leads to Unexpected Query Results
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 5, 2021 · Databases

Fetching the Latest Record per Name Group in MySQL 5.6/5.7

The article explains why a simple GROUP BY query in MySQL 5.6 returns the earliest rows instead of the most recent ones, demonstrates how to correctly obtain the latest record per name using sub‑queries or window functions, and discusses the impact of the ONLY_FULL_GROUP_BY mode in MySQL 5.7.

DatabaseGROUP BYMySQL
0 likes · 5 min read
Fetching the Latest Record per Name Group in MySQL 5.6/5.7
Liangxu Linux
Liangxu Linux
Jul 4, 2021 · Databases

How to Automate MySQL Backups with Shell Scripts and Cron

This guide explains why database backups are essential, walks through creating a backup directory, writing a mysqldump shell script, compressing the dump, granting execution rights, and scheduling the script with cron to run every minute.

Database AdministrationLinuxMySQL
0 likes · 6 min read
How to Automate MySQL Backups with Shell Scripts and Cron
dbaplus Community
dbaplus Community
Jul 4, 2021 · Big Data

How Didi Scales MySQL‑to‑Hive Sync with Real‑Time Binlog Capture

This article explains Didi's end‑to‑end architecture for ingesting MySQL data into Hive using real‑time Binlog collection, a customized Canal component, message queues, HDFS storage, Dquality monitoring, and strategies for handling data drift and sharding in large‑scale big‑data environments.

Big DataCanalHive
0 likes · 13 min read
How Didi Scales MySQL‑to‑Hive Sync with Real‑Time Binlog Capture
MaGe Linux Operations
MaGe Linux Operations
Jul 4, 2021 · Databases

Why MySQL Queries Slow Down and How ES & HBase Can Help Optimize

This article explores common causes of MySQL slow queries such as index misuse and lock contention, explains indexing strategies like index pushdown and covering indexes, and then compares Elasticsearch and HBase as complementary solutions for large‑scale search and write‑intensive workloads, offering practical tips for performance optimization.

ElasticsearchHBaseMySQL
0 likes · 19 min read
Why MySQL Queries Slow Down and How ES & HBase Can Help Optimize
DeWu Technology
DeWu Technology
Jul 2, 2021 · Databases

MySQL Deep Pagination Optimization

MySQL deep pagination can be dramatically accelerated by ordering on the primary key, indexing the sort column, and using keyset pagination or a sub‑query join instead of scanning millions of rows, while only minor tweaks like increasing sort_buffer_size provide negligible gains.

MySQLdeep paginationindexing
0 likes · 10 min read
MySQL Deep Pagination Optimization
ITPUB
ITPUB
Jul 2, 2021 · Databases

Boost MySQL Bulk Insert and Query Performance with Proven Optimizations

This article presents practical MySQL optimization techniques—including disabling keys for MyISAM, sorting InnoDB input, adjusting UNIQUE_CHECKS and AUTOCOMMIT, using multi‑row INSERT, LOAD DATA INFILE, ORDER BY NULL for GROUP BY, index‑aware ORDER BY, OR condition handling, and SQL hints—to dramatically speed up bulk data loads and common queries.

Bulk InsertMySQLSQL performance
0 likes · 13 min read
Boost MySQL Bulk Insert and Query Performance with Proven Optimizations
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 2, 2021 · Databases

Observing the Effects of MySQL Group Commit through Experiments

Through a series of experiments using MySQL 8.0, this article demonstrates how group commit reduces I/O operations by consolidating multiple transactions into a single commit group, showing that doubling load increases runtime modestly while transaction count and commit groups rise significantly, highlighting performance benefits.

DatabaseGroup CommitIO optimization
0 likes · 4 min read
Observing the Effects of MySQL Group Commit through Experiments
ZhiKe AI
ZhiKe AI
Jul 2, 2021 · Databases

Fast Migration of Millions of MySQL Rows: Step-by-Step Guide

This article outlines a practical method for migrating MySQL tables with millions of rows by exporting data to an outfile, compressing, transferring, and loading it on the target server, while also addressing strict SQL mode errors that can arise during import.

Data MigrationLOAD DATALarge Tables
0 likes · 2 min read
Fast Migration of Millions of MySQL Rows: Step-by-Step Guide
Java Architect Essentials
Java Architect Essentials
Jun 30, 2021 · Operations

Recovering Accidentally Deleted Production Server Data Using ext3grep, extundelete, and MySQL Binlog

After a junior staff member mistakenly ran an unchecked rm‑rf command that erased an entire production server, the author details a step‑by‑step recovery using ext3grep, custom shell scripts, extundelete, and MySQL binlog replay, and concludes with lessons on backup, monitoring, and change management.

Data RecoveryMySQLbackup
0 likes · 8 min read
Recovering Accidentally Deleted Production Server Data Using ext3grep, extundelete, and MySQL Binlog
Top Architect
Top Architect
Jun 30, 2021 · Databases

Analyzing and Optimizing MySQL Pagination Performance with Large Offsets

This article investigates why MySQL queries with large LIMIT offsets become extremely slow, demonstrates the issue with simulated millions‑of‑row datasets, and presents three optimization strategies—including index‑covering subqueries, remembering the last primary‑key position, and applying offset throttling—to achieve consistent, fast pagination performance.

MySQLOptimizationindexing
0 likes · 12 min read
Analyzing and Optimizing MySQL Pagination Performance with Large Offsets
Java Interview Crash Guide
Java Interview Crash Guide
Jun 30, 2021 · Databases

How to Quickly Remove Duplicate Rows in MySQL Without Locking

This article walks through a practical MySQL tutorial that identifies duplicate records, explains why naïve row‑by‑row deletion is slow, and provides efficient DELETE statements—including derived‑table tricks—to clean up large tables while preserving one record per duplicate group.

DeleteMySQLdatabase cleanup
0 likes · 6 min read
How to Quickly Remove Duplicate Rows in MySQL Without Locking
Laravel Tech Community
Laravel Tech Community
Jun 29, 2021 · Databases

MySQL Data Recovery: Backup, Binlog, Point‑in‑Time Recovery and Tools

This article explains how to prevent data loss in MySQL by enabling backups and row‑based binlog, then details full‑volume recovery with mysqldump or xtrabackup, point‑in‑time restoration using binlog, table‑level recovery, skipping erroneous SQL statements, and introduces open‑source tools such as binlog2sql and MyFlash.

MyFlashMySQLRecovery
0 likes · 15 min read
MySQL Data Recovery: Backup, Binlog, Point‑in‑Time Recovery and Tools
Laravel Tech Community
Laravel Tech Community
Jun 28, 2021 · Databases

Understanding and Optimizing MySQL ORDER BY Execution

This article explains how MySQL processes ORDER BY clauses, illustrates the execution steps with a full‑field index, discusses the impact of sort_buffer and max_length_for_sort_data, and shows how adding composite and covering indexes can eliminate filesort and improve query performance.

DatabasesIndex OptimizationMySQL
0 likes · 6 min read
Understanding and Optimizing MySQL ORDER BY Execution
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 28, 2021 · Databases

How to Check and Optimize MySQL Table Space Fragmentation

This article explains how to detect table‑space fragmentation in MySQL, demonstrates the performance impact of deleted rows, and provides step‑by‑step commands—including ALTER TABLE FORCE, OPTIMIZE TABLE, and mysqlcheck—to reclaim space and improve query speed.

Database MaintenanceMySQLOptimization
0 likes · 8 min read
How to Check and Optimize MySQL Table Space Fragmentation
New Oriental Technology
New Oriental Technology
Jun 28, 2021 · Databases

InnoDB Architecture and Key Features: A Comprehensive Overview

This article provides a comprehensive overview of InnoDB architecture, covering its memory structures, background threads, and key features like checkpoint mechanisms, double write, and neighbor page flushing, essential for understanding MySQL's default storage engine.

Background ThreadsCheckpoint MechanismDatabase Architecture
0 likes · 12 min read
InnoDB Architecture and Key Features: A Comprehensive Overview
Architect's Alchemy Furnace
Architect's Alchemy Furnace
Jun 27, 2021 · Databases

Why B+Tree Beats B-Tree: Unlocking MySQL InnoDB Performance

This article explains how B+Tree improves disk I/O efficiency in MySQL InnoDB by detailing disk storage fundamentals, sector/block/page concepts, the differences between B‑Tree and B+Tree, and practical search examples that illustrate reduced I/O operations and faster queries.

B+TreeDatabase IndexInnoDB
0 likes · 15 min read
Why B+Tree Beats B-Tree: Unlocking MySQL InnoDB Performance
The Dominant Programmer
The Dominant Programmer
Jun 27, 2021 · Backend Development

Cache Database Data in Redis with Custom SpringBoot AOP Annotations

This guide demonstrates how to add a custom AOP‑based caching layer to a SpringBoot application, using Redis to store frequently queried MySQL table data, defining @AopCacheEnable and @AopCacheEvict annotations, implementing an aspect, handling key generation, expiration, and cache eviction on CRUD operations.

AOPCacheCustom Annotation
0 likes · 9 min read
Cache Database Data in Redis with Custom SpringBoot AOP Annotations
Ctrip Technology
Ctrip Technology
Jun 24, 2021 · Backend Development

Design and Implementation of Distributed Cache with Eventual and Strong Consistency at Ctrip Finance

This article presents Ctrip Finance's design of a unified high‑availability Redis cache service, covering both eventual‑consistency and strong‑consistency scenarios, the overall architecture, data‑accuracy, completeness and availability mechanisms, lock handling, fault‑tolerant updates, and operational recovery strategies.

ConsistencyDistributed CacheMySQL
0 likes · 26 min read
Design and Implementation of Distributed Cache with Eventual and Strong Consistency at Ctrip Finance
Top Architect
Top Architect
Jun 22, 2021 · Backend Development

Step-by-Step Guide to Building a Spring Boot Project with MyBatis and MySQL

This tutorial walks through creating a Spring Boot project, configuring Maven dependencies, setting up application.yml and properties, defining POJOs, MyBatis mapper XML, service and controller layers, and building simple Thymeleaf login and registration pages, with full code snippets for each step.

JavaMyBatisMySQL
0 likes · 10 min read
Step-by-Step Guide to Building a Spring Boot Project with MyBatis and MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 22, 2021 · Databases

Testing MySQL Behavior Under the Unix 2038 Bug

The article investigates whether MySQL is affected by the Unix 2038 bug by adjusting the system date to 2038, documenting the shutdown behavior, analyzing the timestamp limitations in MySQL source code, and discussing the impact on current versions and possible mitigation strategies.

MySQLUnix 2038 bugtime overflow
0 likes · 6 min read
Testing MySQL Behavior Under the Unix 2038 Bug
Programmer DD
Programmer DD
Jun 22, 2021 · Databases

Mastering Backslash Escapes in MySQL: Insert & SELECT Gotchas

This article explains how MySQL treats backslashes in INSERT and SELECT statements, demonstrates the resulting storage differences with practical examples, and clarifies the double‑escaping rules that developers must handle to avoid unexpected query results.

InsertMySQLbackslash
0 likes · 6 min read
Mastering Backslash Escapes in MySQL: Insert & SELECT Gotchas
Java Architect Essentials
Java Architect Essentials
Jun 21, 2021 · Databases

Understanding MySQL Slow Queries, Index Optimization, and Integration with Elasticsearch and HBase

This article explains why MySQL queries become slow, how index design and common pitfalls affect performance, introduces MDL locks and large‑table strategies, then compares Elasticsearch and HBase as complementary storage and search solutions, providing practical code examples and best‑practice recommendations.

Database OptimizationHBaseMySQL
0 likes · 16 min read
Understanding MySQL Slow Queries, Index Optimization, and Integration with Elasticsearch and HBase
Programmer DD
Programmer DD
Jun 21, 2021 · Frontend Development

How to Build a Xiaomi‑Style E‑Commerce Site with Vue and Koa

This article presents a student‑crafted, high‑fidelity Xiaomi Mall clone built with a Vue‑based front‑end (Vue‑router, Vuex, Element‑ui, Axios) and a Node.js Koa back‑end using MySQL, detailing its architecture, key pages, authentication, shopping cart, order processing, and deployment.

KoaMySQLVue
0 likes · 5 min read
How to Build a Xiaomi‑Style E‑Commerce Site with Vue and Koa
Open Source Linux
Open Source Linux
Jun 20, 2021 · Databases

How to Automate MySQL Database Backups with Shell Scripts and Cron

Learn step-by-step how to create a reliable MySQL database backup solution by writing a shell script, compressing the dump, assigning execution permissions, and scheduling it with cron to run automatically, while covering storage media choices, disk space checks, and verification of the backup process.

LinuxMySQLbackup
0 likes · 6 min read
How to Automate MySQL Database Backups with Shell Scripts and Cron
ITPUB
ITPUB
Jun 20, 2021 · Databases

Unveiling MySQL’s Query Execution: From Architecture to Optimization Strategies

This article explains MySQL’s logical architecture, the client‑server communication protocol, how queries are parsed, optimized and executed, the role of the query cache, and provides concrete performance‑tuning advice on schema design, indexing, B+Tree mechanics, and common pitfalls.

B+TreeMySQLdatabase indexing
0 likes · 35 min read
Unveiling MySQL’s Query Execution: From Architecture to Optimization Strategies
Top Architect
Top Architect
Jun 19, 2021 · Databases

SQL Query Performance Optimization Tips

This article provides a comprehensive collection of practical MySQL and SQL performance optimization techniques, covering index usage, query rewriting, avoiding full table scans, proper data types, efficient joins, backup strategies, and other best practices to improve database speed and reliability.

DatabaseIndexesMySQL
0 likes · 18 min read
SQL Query Performance Optimization Tips
dbaplus Community
dbaplus Community
Jun 19, 2021 · Databases

Why Does MySQL’s KILL Command Sometimes Hang? A Deep Dive into Thread States and Kill Workflow

This article examines why MySQL’s KILL command often leaves a connection in a prolonged “Killed” state, analyzes the 5.7 source‑code flow, explains socket closure, thread flag handling, condition‑variable notifications, and reproduces real‑world cases that illustrate the underlying causes.

Database InternalsDebuggingKill Command
0 likes · 24 min read
Why Does MySQL’s KILL Command Sometimes Hang? A Deep Dive into Thread States and Kill Workflow
Java Architect Essentials
Java Architect Essentials
Jun 18, 2021 · Databases

How to Supercharge MySQL Queries: 8 Proven Optimization Techniques

This article walks through eight common MySQL performance pitfalls—including inefficient LIMIT usage, implicit type conversion, sub‑query updates, mixed sorting, EXISTS clauses, condition push‑down, early range reduction, and intermediate result push‑down—and shows how to rewrite each query to achieve dramatic speed improvements, often reducing execution time from seconds to milliseconds.

Condition PushdownIndexesJoin
0 likes · 14 min read
How to Supercharge MySQL Queries: 8 Proven Optimization Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 18, 2021 · Databases

How to Compile a Debug Version of MySQL Using Docker

This article explains step‑by‑step how to build a MySQL debug binary inside a Docker container, covering environment preparation, dependency installation, configuring the build with CMake, compiling, and locating the resulting mysqld‑debug executable, while also noting performance trade‑offs of debug builds.

CMakeDatabaseDebug Build
0 likes · 3 min read
How to Compile a Debug Version of MySQL Using Docker
Java High-Performance Architecture
Java High-Performance Architecture
Jun 17, 2021 · Databases

How to Recover MySQL Data: Full, Point-in-Time, and Table Restoration Techniques

This guide explains how to protect MySQL data with proper backups and row‑format binlogs, then walk through full restores using mysqldump or xtrabackup, point‑in‑time recovery from binlogs, single‑table restoration, skipping erroneous SQL statements, and flashback tools like binlog2sql and MyFlash.

Backup and RestoreData RecoveryMySQL
0 likes · 15 min read
How to Recover MySQL Data: Full, Point-in-Time, and Table Restoration Techniques
Top Architect
Top Architect
Jun 16, 2021 · Databases

Understanding MySQL Memory Management and When to Shard Tables

The article explains how MySQL uses different memory areas such as Thread Memory, Sharing, and InnoDB Buffer Pool, describes the impact of large user tables on query performance, and shows that when a table size exceeds the InnoDB buffer pool capacity, sharding becomes necessary.

Database PerformanceInnoDBLinux
0 likes · 17 min read
Understanding MySQL Memory Management and When to Shard Tables
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 15, 2021 · Databases

How to Enable Binlog Compression in MySQL

This article explains why MySQL binlog files can become large, demonstrates how to enable the slave_compressed_protocol parameter for binlog compression, presents benchmark results showing reduced network traffic and CPU impact, and outlines compatibility considerations and known bugs.

MySQLbinlogcompression
0 likes · 5 min read
How to Enable Binlog Compression in MySQL
Efficient Ops
Efficient Ops
Jun 14, 2021 · Databases

Why Misplaced Quotes in MySQL UPDATE Can Turn All Values to Zero

This article examines how misplaced quotation marks in MySQL UPDATE statements can unintentionally set fields to zero, explains MySQL’s implicit type conversion that causes the condition to always evaluate true, and offers practical steps for detecting and preventing such bugs.

Data RecoveryImplicit ConversionMySQL
0 likes · 6 min read
Why Misplaced Quotes in MySQL UPDATE Can Turn All Values to Zero
Programmer DD
Programmer DD
Jun 14, 2021 · Databases

Master Real‑Time Change Data Capture with Debezium and Spring Boot

Learn how to capture and stream real‑time database changes using Debezium’s distributed CDC framework, configure MySQL binlog, integrate the embedded engine with Spring Boot, and process change events with sample code and Docker setup for robust data pipelines.

CDCChange Data CaptureDebezium
0 likes · 11 min read
Master Real‑Time Change Data Capture with Debezium and Spring Boot
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 11, 2021 · Databases

MySQL 8.0.23 Invisible Columns Feature Overview

Starting with MySQL 8.0.23, columns can be marked INVISIBLE, causing them to be omitted from SELECT * queries unless explicitly referenced; this article explains the feature, demonstrates creation, inspection, DML considerations, schema modifications, backup behavior, and its impact on database design.

Database DesignInvisible ColumnsMySQL
0 likes · 8 min read
MySQL 8.0.23 Invisible Columns Feature Overview
Open Source Linux
Open Source Linux
Jun 10, 2021 · Databases

MySQL vs MariaDB: Real-World Performance Benchmark and Analysis

This article reviews the history of MySQL and MariaDB, describes a test environment, runs insertion, batch, and query benchmarks (with and without indexes), and concludes that MariaDB generally outperforms MySQL in speed and memory usage while highlighting trade‑offs of indexing.

BenchmarkDatabase PerformanceInnoDB
0 likes · 9 min read
MySQL vs MariaDB: Real-World Performance Benchmark and Analysis
Top Architect
Top Architect
Jun 10, 2021 · Backend Development

Optimizing Large Excel Import Performance in Java Backend Applications

This article details a step‑by‑step optimization of a Java backend Excel import pipeline, covering requirement analysis, performance bottlenecks, caching strategies, batch insertion techniques, parallel processing, and practical code examples to reduce a 10‑minute import to under two minutes.

Batch InsertExcelJava
0 likes · 13 min read
Optimizing Large Excel Import Performance in Java Backend Applications
Efficient Ops
Efficient Ops
Jun 9, 2021 · Databases

Why MySQL Queries Go Slow and How to Fix Them with Indexes, ES, and HBase

This article explains why MySQL queries become slow, explores index-related pitfalls and optimization techniques, and then compares ElasticSearch and HBase as complementary solutions for large‑scale data and search scenarios, offering practical tips and code examples.

Database PerformanceHBaseMySQL
0 likes · 21 min read
Why MySQL Queries Go Slow and How to Fix Them with Indexes, ES, and HBase
ITPUB
ITPUB
Jun 9, 2021 · Databases

Master MySQL Optimization: From Status Variables to Index Tuning

This article walks through practical MySQL performance tuning techniques, covering how to inspect server status variables, enable and read slow query logs, analyze execution plans with EXPLAIN, understand and apply various index types, and use table analysis, checking, and optimization commands to improve query efficiency.

EXPLAINMySQL
0 likes · 19 min read
Master MySQL Optimization: From Status Variables to Index Tuning
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 8, 2021 · Databases

Understanding Table Locks in MySQL When Using INSERT INTO SELECT and the Impact of Isolation Levels

The article explains why an INSERT INTO SELECT statement can lock an entire InnoDB table in MySQL, demonstrates the lock behavior with transaction examples, and offers two solutions—adding an index on the filtered column and adjusting the transaction isolation level—to avoid table‑wide blocking.

INSERT SELECTInnoDBMySQL
0 likes · 13 min read
Understanding Table Locks in MySQL When Using INSERT INTO SELECT and the Impact of Isolation Levels
IT Architects Alliance
IT Architects Alliance
Jun 7, 2021 · Databases

Analyzing and Optimizing MySQL Pagination Performance with Large Offsets

The article examines a production MySQL query that suffers severe slowdown due to large LIMIT offsets, demonstrates how to reproduce the issue with massive test data, analyzes the root cause, and presents three optimization strategies—including index covering, keyset pagination, and offset limiting—to dramatically improve query performance.

MySQLOptimizationindexing
0 likes · 13 min read
Analyzing and Optimizing MySQL Pagination Performance with Large Offsets
Qingyun Technology Community
Qingyun Technology Community
Jun 7, 2021 · Databases

Why Xenon Is the Modern MySQL HA Alternative to MHA

This article compares the legacy MHA solution with the modern open‑source Xenon tool, explaining Xenon's Raft‑based architecture, automatic leader election, GTID integration, and enterprise‑grade features that make it a superior high‑availability option for MySQL deployments.

GTIDMHAMySQL
0 likes · 7 min read
Why Xenon Is the Modern MySQL HA Alternative to MHA
Programmer DD
Programmer DD
Jun 7, 2021 · Databases

Why Misplaced Quotes Turn MySQL UPDATE Results into Zero

This article explains how incorrect placement of quotation marks in MySQL UPDATE statements can cause the SET values to be evaluated as boolean expressions, leading to implicit type conversion that updates fields to zero, and offers practical steps to prevent such errors.

Database ErrorsImplicit ConversionMySQL
0 likes · 5 min read
Why Misplaced Quotes Turn MySQL UPDATE Results into Zero
dbaplus Community
dbaplus Community
Jun 6, 2021 · Big Data

How to Build Near‑Real‑Time Elasticsearch Indexes for PB‑Scale Data

This article explains why traditional databases like MySQL struggle with petabyte‑scale queries, introduces Elasticsearch’s architecture and inverted‑index advantages, and details a practical pipeline using Hive, Canal, Otter, and a custom DTS service to achieve near‑real‑time indexing for massive data volumes.

CanalElasticsearchMySQL
0 likes · 19 min read
How to Build Near‑Real‑Time Elasticsearch Indexes for PB‑Scale Data
Architect
Architect
Jun 6, 2021 · Databases

Optimizing MySQL Pagination for Large Datasets: Analysis and Solutions

An engineer describes a production MySQL pagination issue where large offset queries caused severe slowdown, analyzes the root cause, demonstrates data simulation scripts, and presents three optimization strategies—including index covering with subqueries, redefining start positions, and applying offset limits—to improve query performance on massive tables.

DatabaseMySQLPerformance Optimization
0 likes · 13 min read
Optimizing MySQL Pagination for Large Datasets: Analysis and Solutions
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jun 5, 2021 · Databases

How Many Rows Can a MySQL InnoDB B+Tree Store?

This article explains InnoDB's storage hierarchy (sector, block, page), calculates how many rows fit in a 16KB page, shows how B+‑tree height and pointer counts determine total record capacity, and demonstrates the I/O cost of primary and secondary index lookups using practical MySQL commands.

B+TreeInnoDBMySQL
0 likes · 8 min read
How Many Rows Can a MySQL InnoDB B+Tree Store?