BestHub
Sign in
Tagged articles
5000 articles
Page 44 of 50
Top Architect
Top Architect
Sep 19, 2020 · Databases

MySQL Performance Optimization: Design, Indexing, Partitioning, and Migration Strategies

This article analyzes a severe MySQL performance issue caused by massive user‑access logs, then presents three solution paths—optimizing the existing database, migrating to a compatible high‑performance database, and adopting big‑data technologies—detailing design best practices, indexing, partitioning, sharding, and cloud‑native options to restore query speed and scalability.

Database OptimizationMySQLPartitioning
0 likes · 18 min read
MySQL Performance Optimization: Design, Indexing, Partitioning, and Migration Strategies
Programmer DD
Programmer DD
Sep 19, 2020 · Databases

Boost MySQL Pagination Performance: Proven Techniques and Benchmarks

This article examines various MySQL pagination strategies—including simple LIMIT clauses, sub‑query optimizations, ID‑range queries, and temporary‑table methods—by testing them on a table with millions of rows and presenting detailed timing results that reveal significant speed improvements.

LIMITMySQLpagination
0 likes · 9 min read
Boost MySQL Pagination Performance: Proven Techniques and Benchmarks
Programmer DD
Programmer DD
Sep 19, 2020 · Databases

Why MySQL Auto‑Increment Outperforms UUID: Full Performance Test and Analysis

This article examines MySQL's recommendation to use auto_increment primary keys instead of UUID or Snowflake IDs by creating three tables, running insertion benchmarks with Spring Boot, comparing index structures, and discussing the performance trade‑offs and practical drawbacks of each approach.

Database DesignMySQLauto_increment
0 likes · 9 min read
Why MySQL Auto‑Increment Outperforms UUID: Full Performance Test and Analysis
Architecture Digest
Architecture Digest
Sep 18, 2020 · Databases

Optimizing MySQL RDS for Large‑Scale User Activity Logs: Design, Indexing, Partitioning, and Migration Strategies

This article analyzes the performance problems of a massive MySQL 5.6 RDS table storing billions of user‑activity records and presents three practical solutions—optimizing the existing schema and queries, migrating to a MySQL‑compatible high‑performance database, and adopting a big‑data platform—detailing design, indexing, partitioning, sharding, and cloud‑native options.

MySQLPartitioningcloud database
0 likes · 15 min read
Optimizing MySQL RDS for Large‑Scale User Activity Logs: Design, Indexing, Partitioning, and Migration Strategies
Big Data Technology & Architecture
Big Data Technology & Architecture
Sep 17, 2020 · Databases

Understanding MySQL Join Types and Optimization Techniques

This article explains MySQL's various join algorithms—including Simple Nested Loop, Index Nested Loop, Blocked Nested Loop, and unsupported Hash and Merge joins—detailing their mechanisms, performance trade‑offs, and optimization strategies such as MRR, BKA, join buffers, and driver‑table selection.

BKADatabase PerformanceJOIN optimization
0 likes · 11 min read
Understanding MySQL Join Types and Optimization Techniques
Code Ape Tech Column
Code Ape Tech Column
Sep 17, 2020 · Operations

How to Deploy a One‑Click Linux Dev Environment with MySQL, Nginx, Redis & More

This guide walks you through creating and using a one‑click installation package that sets up essential development services—MySQL, Nginx, JDK, Redis, RabbitMQ, and a SpringBoot jar—on Ubuntu 16.x, detailing directory structure, required prerequisites, individual start/stop scripts, and customization options for small‑scale deployments.

DevOpsLinuxMySQL
0 likes · 6 min read
How to Deploy a One‑Click Linux Dev Environment with MySQL, Nginx, Redis & More
Selected Java Interview Questions
Selected Java Interview Questions
Sep 16, 2020 · Databases

In‑Depth Analysis of MySQL/InnoDB Locking Mechanisms

This article provides a comprehensive examination of MySQL/InnoDB locking, covering MVCC, snapshot vs. current reads, cluster indexes, two‑phase locking, isolation levels, detailed lock‑behaviour for various index and isolation combinations, complex query lock analysis, and deadlock detection techniques.

DatabaseInnoDBIsolation Levels
0 likes · 23 min read
In‑Depth Analysis of MySQL/InnoDB Locking Mechanisms
Big Data Technology & Architecture
Big Data Technology & Architecture
Sep 16, 2020 · Databases

Optimizing a Complex MySQL Slow Query for Article Comments

This article analyzes a 60‑second MySQL query that retrieves article comments with multiple filters, explains why the optimizer chooses a small table as the driver, and presents a step‑by‑step optimization—including avoiding semi‑joins, improving index usage, refining range conditions, and moving GROUP BY into a subquery—that reduces execution time to 1.3 seconds, achieving a 60‑fold speedup.

Big DataDatabaseMySQL
0 likes · 13 min read
Optimizing a Complex MySQL Slow Query for Article Comments
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 16, 2020 · Databases

Online DDL Tool pt-osc: Principles, Usage, and Comparison

This article provides a comprehensive guide to the pt-online-schema-change (pt-osc) tool for MySQL online DDL, covering its underlying mechanism, limitations, installation steps, command‑line syntax, practical examples, and a comparative analysis with native Online DDL and gh‑ost to help users choose the appropriate solution.

MySQLOnline DDLdatabase migration
0 likes · 32 min read
Online DDL Tool pt-osc: Principles, Usage, and Comparison
IT Xianyu
IT Xianyu
Sep 15, 2020 · Databases

Understanding MySQL Log Files: Redo Log, Undo Log, and Binary Log

This article explains MySQL’s six log files, focusing on the redo log, undo log, and binary log, detailing their purposes, contents, generation and release timing, associated physical files, configuration parameters, and their roles in transaction durability and replication.

MySQLbinary loglog
0 likes · 11 min read
Understanding MySQL Log Files: Redo Log, Undo Log, and Binary Log
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 15, 2020 · Databases

Resolving MySQL wait_timeout and JDBC Connection‑Pool Exceptions with Druid Configuration

This article analyses the root cause of generic "exception" errors during article publishing caused by mismatched MySQL wait_timeout and Druid JDBC pool settings, explains the impact of these parameters, and provides step‑by‑step configuration adjustments and alternative solutions to stabilise the backend database connection pool.

Connection PoolDatabase OptimizationDruid
0 likes · 6 min read
Resolving MySQL wait_timeout and JDBC Connection‑Pool Exceptions with Druid Configuration
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 15, 2020 · Databases

Using MySQL 8.0 Statement Digest and Digest Text Functions for SQL Summarization

The article explains MySQL 8.0's new statement_digest() and statement_digest_text() functions, showing how they generate normalized SQL texts and SHA2 hashes to group similar queries, and demonstrates practical applications in performance schema analysis and query‑rewrite plugins with concrete code examples.

Database OptimizationMySQLQuery Rewrite
0 likes · 8 min read
Using MySQL 8.0 Statement Digest and Digest Text Functions for SQL Summarization
Architecture Digest
Architecture Digest
Sep 15, 2020 · Databases

Optimizing Large‑Scale Excel Import in Java: From POI to EasyExcel, Caching, Batch Inserts and Parallel Processing

This article details how to dramatically speed up Excel‑driven fee‑record imports by replacing naïve POI row‑by‑row processing with EasyExcel, caching database look‑ups, using MySQL batch INSERTs, and finally applying parallel streams for multi‑threaded insertion, while also trimming excessive logging.

ExcelMyBatisMySQL
0 likes · 12 min read
Optimizing Large‑Scale Excel Import in Java: From POI to EasyExcel, Caching, Batch Inserts and Parallel Processing
Programmer DD
Programmer DD
Sep 14, 2020 · Databases

Master MySQL Performance: Practical Tips for Scaling and Optimization

This article explores MySQL performance limits, concurrency settings, query‑time best practices, table design choices, index classifications, and a comprehensive set of SQL optimizations—including batch processing, operator rewrites, and pagination tricks—to help developers eliminate slow queries and build scalable database solutions.

MySQLOptimizationPerformance
0 likes · 15 min read
Master MySQL Performance: Practical Tips for Scaling and Optimization
Architecture Digest
Architecture Digest
Sep 13, 2020 · Databases

MySQL 8.0 Version History and New Features

An overview of MySQL 8.0’s release timeline, including major GA versions, and a detailed summary of its new capabilities such as transactional data dictionary, atomic DDL, enhanced security, role support, InnoDB improvements, JSON enhancements, optimizer extensions, backup lock, connection management, and other performance and management features.

8.0InnoDBMySQL
0 likes · 10 min read
MySQL 8.0 Version History and New Features
Architecture Digest
Architecture Digest
Sep 11, 2020 · Databases

Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL

This article investigates why MySQL recommends auto_increment primary keys over UUID or snowflake IDs by creating three tables with different key strategies, running insertion benchmarks using Spring Boot, and analyzing index structures, performance results, and the trade‑offs of each approach.

Database IndexMySQLauto_increment
0 likes · 10 min read
Performance Comparison of Auto‑Increment, UUID, and Random Keys in MySQL
ITPUB
ITPUB
Sep 9, 2020 · Databases

How to Speed Up Massive MySQL User‑Log Tables: Partitioning, Indexing, and Migration Strategies

This article examines performance problems with a 20‑million‑row MySQL user‑log table on Alibaba Cloud RDS, outlines three solution paths—optimizing the existing database, migrating to a MySQL‑compatible high‑performance service, and adopting a big‑data engine—and provides detailed guidance on schema design, indexing, partitioning, and practical SQL tweaks.

Big DataDatabase OptimizationMySQL
0 likes · 17 min read
How to Speed Up Massive MySQL User‑Log Tables: Partitioning, Indexing, and Migration Strategies
Selected Java Interview Questions
Selected Java Interview Questions
Sep 8, 2020 · Databases

Database Cache Consistency Strategies: Using Redis as a MySQL Cache

This article explains the concept of caching, why database caching with Redis is needed for MySQL, the consistency challenges it introduces, and compares four practical solutions—TTL, write‑through, message‑queue, and binlog replication—offering guidance on selecting the appropriate approach for different latency and reliability requirements.

BackendCacheDatabase
0 likes · 8 min read
Database Cache Consistency Strategies: Using Redis as a MySQL Cache
Tencent Cloud Developer
Tencent Cloud Developer
Sep 8, 2020 · Backend Development

Implementing Autocomplete with MySQL, Redis, and Elasticsearch

The article explains autocomplete’s user‑friendly benefits and compares three backend approaches—simple MySQL LIKE queries, Redis sorted‑set range scans, and Elasticsearch’s completion suggester with FST indexing—highlighting their performance, scalability, and feature trade‑offs to help choose the best solution for a given dataset and latency requirement.

ElasticsearchMySQLSearch
0 likes · 8 min read
Implementing Autocomplete with MySQL, Redis, and Elasticsearch
ITPUB
ITPUB
Sep 8, 2020 · Databases

Understanding MySQL Binlog, Redo Log, and Undo Log: Ensuring Data Consistency

This article explains the three core MySQL logs—binlog, redo log, and undo log—their structures, formats, configuration parameters, and how they work together to provide replication, crash recovery, and transactional atomicity while balancing performance and consistency.

MySQLTransaction Logbinlog
0 likes · 11 min read
Understanding MySQL Binlog, Redo Log, and Undo Log: Ensuring Data Consistency
ITPUB
ITPUB
Sep 8, 2020 · Databases

Why a Missing Index Parameter Crashed Our Production MySQL Database

A production MySQL server was overwhelmed by a high‑volume query that ignored a crucial composite index because the leftmost key was missing, leading to full‑table scans, CPU saturation, and a half‑hour outage, and the post explains how the issue was diagnosed and fixed.

Composite IndexDebuggingJava Validation
0 likes · 9 min read
Why a Missing Index Parameter Crashed Our Production MySQL Database
Java Architect Essentials
Java Architect Essentials
Sep 7, 2020 · Databases

Database Cache Consistency: Strategies and Trade‑offs Using Redis as a MySQL Cache

This article explains why database caching is essential, outlines the consistency challenges of using Redis as a MySQL cache, and compares four practical synchronization solutions—ranging from simple TTL expiration to binlog subscription—highlighting their advantages, drawbacks, and appropriate selection criteria.

Backend ArchitectureCache ConsistencyDatabase Caching
0 likes · 8 min read
Database Cache Consistency: Strategies and Trade‑offs Using Redis as a MySQL Cache
ITPUB
ITPUB
Sep 7, 2020 · Databases

Why a Missing Index Parameter Crashed Our Production MySQL and How We Fixed It

A production MySQL server was overwhelmed by a full‑table‑scan query that omitted the leftmost index column, causing CPU saturation and read‑only alerts; the article explains the root cause, temporary mitigation, the leftmost‑match principle, code‑level bug, and key lessons learned.

Bug FixJava ValidationMySQL
0 likes · 9 min read
Why a Missing Index Parameter Crashed Our Production MySQL and How We Fixed It
Programmer DD
Programmer DD
Sep 7, 2020 · Databases

How to Speed Up Massive MySQL Tables: Practical Optimization Strategies

This article examines why a MySQL 5.6 RDS table with tens of millions of rows becomes unbearably slow, then presents three concrete approaches—optimizing the existing database, migrating to a MySQL‑compatible service, and adopting a big‑data engine—detailing design, indexing, partitioning, sharding, and cloud options to restore performance.

Database OptimizationMySQLPartitioning
0 likes · 18 min read
How to Speed Up Massive MySQL Tables: Practical Optimization Strategies
ITPUB
ITPUB
Sep 6, 2020 · Databases

Choosing the Right MySQL‑Redis Cache Consistency Strategy

This article explains why caching is essential for high‑traffic MySQL applications, outlines the consistency challenges of using Redis as a cache, and compares four practical synchronization solutions—TTL‑only, write‑through, message‑queue‑based, and binlog‑driven—highlighting their advantages, drawbacks, and selection guidelines.

Cache ConsistencyDatabase CachingMessage queue
0 likes · 10 min read
Choosing the Right MySQL‑Redis Cache Consistency Strategy
Laravel Tech Community
Laravel Tech Community
Sep 5, 2020 · Databases

MySQL Database Backup and Recovery

The article explains why MySQL databases need regular backup, describes common data‑loss scenarios, classifies backup types (hot, cold, warm) and methods (logical, physical), lists popular tools, and provides detailed command‑line examples for backing up, restoring, migrating, and exporting data.

Data MigrationHot BackupMySQL
0 likes · 27 min read
MySQL Database Backup and Recovery
Ctrip Technology
Ctrip Technology
Sep 3, 2020 · Databases

Evolution of Ctrip's MySQL Database Release System: From 1.0 to 3.0

This article details the design, evolution, and operational practices of Ctrip's MySQL database release system, covering its three major versions, the adoption of gh‑ost, safety mechanisms, real‑world case studies, and performance improvements that enable reliable, low‑impact schema changes at scale.

MySQLSchema Migrationautomation
0 likes · 14 min read
Evolution of Ctrip's MySQL Database Release System: From 1.0 to 3.0
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 3, 2020 · Databases

Is It Time to Upgrade to MySQL 8.0? – Highlights from the First Episode of “MySQL Chōng Chōng Chōng”

The first episode of the “MySQL Chōng Chōng Chōng” livestream discusses why now is an excellent time to upgrade to MySQL 8.0, covering fast add‑column, Atomic DDL, Hash Join, Group Replication, authentication changes, and includes thanks to sponsors and a preview of the next show.

Atomic DDLDatabase UpgradeFast Add Column
0 likes · 9 min read
Is It Time to Upgrade to MySQL 8.0? – Highlights from the First Episode of “MySQL Chōng Chōng Chōng”
Open Source Linux
Open Source Linux
Sep 2, 2020 · Databases

Recover MySQL After Accidental Drop Using LVM Snapshots and Binlog

This guide demonstrates a complete MySQL disaster‑recovery workflow that combines LVM snapshot technology with binary‑log point‑in‑time recovery, allowing you to restore a dropped database by creating a snapshot, extracting it, and replaying binlog events up to the failure moment.

LVMMySQLbinary log
0 likes · 7 min read
Recover MySQL After Accidental Drop Using LVM Snapshots and Binlog
Architects' Tech Alliance
Architects' Tech Alliance
Sep 1, 2020 · Databases

UCloud Kuaijie UDB vs Self‑Built MySQL: Performance & Cost Comparison

This article benchmarks UCloud’s Kuaijie‑based UDB against a self‑built MySQL instance on UHost, detailing environment setup, sysbench testing parameters, QPS, insert/delete and update results, and evaluates performance gains of over 20% alongside a cost analysis showing UDB’s better price‑performance ratio.

BenchmarkMySQLPerformance
0 likes · 8 min read
UCloud Kuaijie UDB vs Self‑Built MySQL: Performance & Cost Comparison
dbaplus Community
dbaplus Community
Sep 1, 2020 · Big Data

Mastering Real‑Time MySQL Binlog Sync with Debezium, Kafka & Hive

This article presents a systematic guide to real‑time MySQL binlog ingestion, outlining three core principles—decoupling from business data, handling schema changes, and ensuring traceability—followed by concrete Debezium‑Kafka‑Hive solutions, scenario‑specific tactics, and practical tips for reliable data pipelines.

DebeziumHiveKafka
0 likes · 15 min read
Mastering Real‑Time MySQL Binlog Sync with Debezium, Kafka & Hive
Code Ape Tech Column
Code Ape Tech Column
Sep 1, 2020 · Databases

Comprehensive Guide to MySQL Database Optimization: SQL Tuning, Index Strategies, and Best Practices

This article presents a thorough overview of MySQL performance tuning, covering step‑by‑step SQL optimization techniques, common pitfalls, index and table‑structure improvements, cache parameter adjustments, and practical guidelines to reduce I/O and CPU bottlenecks while maintaining data integrity.

Database PerformanceMySQLQuery Tuning
0 likes · 28 min read
Comprehensive Guide to MySQL Database Optimization: SQL Tuning, Index Strategies, and Best Practices
Alibaba Cloud Developer
Alibaba Cloud Developer
Aug 31, 2020 · Databases

How to Build a Cloud‑Native High‑Availability MySQL with Kubernetes

This article introduces the SlightShift MySQL high‑availability solution, detailing cloud‑native design principles, architecture, key technologies such as Raft‑based leader election, Local PV storage, ProxySQL routing, automated failover, backup/recovery, and the operator‑driven declarative management that enable scalable, low‑cost, resilient MySQL deployments on Kubernetes.

DatabaseMySQLOperator
0 likes · 19 min read
How to Build a Cloud‑Native High‑Availability MySQL with Kubernetes
ITPUB
ITPUB
Aug 31, 2020 · Databases

Mastering MySQL: Keys, Indexes, Transactions, Storage Engines, and Optimization Explained

This comprehensive guide covers MySQL fundamentals—including primary, foreign, candidate, and super keys—auto‑increment primary keys, triggers, stored procedures, views, cursor usage, index types and design, transaction properties and isolation levels, storage engine differences, query execution order, EXPLAIN analysis, lock mechanisms, replication strategies, high‑concurrency solutions, and crash‑recovery via REDO and UNDO logs, providing practical examples and code snippets for each concept.

Database FundamentalsIndexesMySQL
0 likes · 52 min read
Mastering MySQL: Keys, Indexes, Transactions, Storage Engines, and Optimization Explained
Architecture Digest
Architecture Digest
Aug 31, 2020 · Databases

Understanding MySQL Binlog, Redo Log, and Undo Log

This article explains the purpose, structure, and usage scenarios of MySQL's binlog, redo log, and undo log, detailing how they support replication, crash recovery, and transaction atomicity while balancing performance and data safety.

Database LoggingInnoDBMySQL
0 likes · 13 min read
Understanding MySQL Binlog, Redo Log, and Undo Log
The Dominant Programmer
The Dominant Programmer
Aug 31, 2020 · Backend Development

How to Count Conditional Records with MyBatis and MySQL

This article shows how to use MyBatis XML mappers to write MySQL queries that count employees meeting specific criteria, such as those in the current month or before today, while explaining required aliasing and date‑format handling.

Count QueryMyBatisMySQL
0 likes · 3 min read
How to Count Conditional Records with MyBatis and MySQL
JavaEdge
JavaEdge
Aug 30, 2020 · Databases

Master MySQL EXPLAIN: Decode Every Column and Boost Query Performance

This guide explains each column returned by MySQL's EXPLAIN output, details join types, possible keys, extra information, and shows how to use EXPLAIN EXTENDED, SHOW PROFILE, and optimizer trace to analyze and optimize SQL queries effectively.

EXPLAINMySQLOptimizer_trace
0 likes · 14 min read
Master MySQL EXPLAIN: Decode Every Column and Boost Query Performance
Efficient Ops
Efficient Ops
Aug 29, 2020 · Databases

How Lujinso Migrated 90% of Its Oracle Databases to MySQL at Scale

Facing high licensing costs and poor scalability, Lujinso embarked on an 18‑month, self‑driven project to replace 90% of its Oracle databases—spanning billions of rows across financial services—with MySQL, supplemented by Elasticsearch, Redis, TiDB and HBase, using an automated migration platform.

Financial ServicesMySQLOracle migration
0 likes · 7 min read
How Lujinso Migrated 90% of Its Oracle Databases to MySQL at Scale
Code Ape Tech Column
Code Ape Tech Column
Aug 29, 2020 · Databases

20 Essential MySQL Index Optimization Rules Every Developer Should Know

This article outlines twenty practical principles for optimizing MySQL indexes, covering topics such as LIKE wildcards, UNION/IN/OR usage, negative conditions, composite index prefix rules, range queries, function avoidance, covering indexes, prefix indexes, pagination strategies, and common misconceptions, all illustrated with SQL examples and performance tips.

Database PerformanceIndex OptimizationMySQL
0 likes · 16 min read
20 Essential MySQL Index Optimization Rules Every Developer Should Know
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Aug 28, 2020 · Databases

Understanding Master/Slave Read‑Write Splitting and Data Consistency with Sharding‑JDBC

This article explains the data‑delay problem inherent in asynchronous MySQL master‑slave replication, demonstrates how Sharding‑JDBC provides read‑write splitting and forced‑master routing via HintManager, and offers configuration and code examples as well as alternative async‑query strategies for real‑time consistency.

Data ConsistencyHintManagerMySQL
0 likes · 8 min read
Understanding Master/Slave Read‑Write Splitting and Data Consistency with Sharding‑JDBC
iQIYI Technical Product Team
iQIYI Technical Product Team
Aug 28, 2020 · Databases

iQIYI's Custom MySQL High‑Availability Architecture

iQIYI’s custom MySQL HA solution replaces the single‑point‑failure MHA manager with a Raft‑based trio of HA Masters and HA Agents that continuously monitor instances, automatically perform same‑DC, cross‑DC, or cross‑region failovers, reconcile diff binlogs, ensure data consistency, and integrate with CMDB, tracing and chaos‑engineering platforms.

DatabaseHA ArchitectureMHA
0 likes · 10 min read
iQIYI's Custom MySQL High‑Availability Architecture
Tencent Cloud Developer
Tencent Cloud Developer
Aug 26, 2020 · Databases

How to Become an Outstanding Data Craftsman: Insights from Database Experts

Three leading database experts from Tencent and cloud firms share how deep curiosity, hands‑on experimentation, persistent learning—combined with mastering distributed, cloud, and autonomous databases—forge an outstanding data craftsman, while advising newcomers to master performance, security, one DB per category, and start with open‑source tools.

DBADatabase ArchitectureElasticsearch
0 likes · 34 min read
How to Become an Outstanding Data Craftsman: Insights from Database Experts
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Aug 26, 2020 · Backend Development

Interview Experience and Technical Q&A for a Java Backend Position at Tencent Cloud (Xi'an)

The article shares the author's recent move to Xi'an, discusses the local job market, and provides detailed interview questions and answers on Java backend topics such as Redis replication, Kafka performance, MySQL transactions, and JVM garbage collection to help job seekers prepare effectively.

Backend DevelopmentInterviewJVM
0 likes · 8 min read
Interview Experience and Technical Q&A for a Java Backend Position at Tencent Cloud (Xi'an)
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 26, 2020 · Databases

Deep Dive into MySQL Seconds_Behind_Master Calculation in Dual‑Master Replication

This article investigates why the Seconds_Behind_Master metric fluctuates in a dual‑master MySQL setup, explains the underlying replication logic, reproduces the issue, and analyses the handling of ROTATE_EVENT and other binlog events in both parallel and non‑parallel replication modes using source code excerpts.

BinaryLogDatabasePerformanceMySQL
0 likes · 27 min read
Deep Dive into MySQL Seconds_Behind_Master Calculation in Dual‑Master Replication
Code Ape Tech Column
Code Ape Tech Column
Aug 26, 2020 · Databases

Master MySQL Basics: Interview Q&A on Relational Databases

This article provides a comprehensive interview‑style overview of MySQL fundamentals, covering relational database concepts, data types, storage engines, SQL syntax, version checking, normal forms, views, stored procedures, and performance tips, all essential for backend developers and database professionals.

Data TypesDatabase DesignInterview
0 likes · 20 min read
Master MySQL Basics: Interview Q&A on Relational Databases
JavaEdge
JavaEdge
Aug 25, 2020 · Databases

Mastering MySQL Temporary Tables: Creation, Usage, and Deletion

This guide explains what MySQL temporary tables are, how they exist only for the current connection, provides step‑by‑step SQL examples for creating, inserting, querying, and dropping a temporary table, and discusses practical scenarios such as high‑concurrency writes.

DatabaseMySQLPerformance
0 likes · 3 min read
Mastering MySQL Temporary Tables: Creation, Usage, and Deletion
Top Architect
Top Architect
Aug 25, 2020 · Backend Development

Performance Comparison of Hibernate and MyBatis for Insert and Query Operations

This article presents a systematic performance test of Hibernate and MyBatis covering bulk inserts, single‑table queries, and various association queries on MySQL, analyzes the impact of lazy versus eager loading, caching, and data volume, and provides practical recommendations for choosing the appropriate ORM framework.

HibernateMyBatisMySQL
0 likes · 16 min read
Performance Comparison of Hibernate and MyBatis for Insert and Query Operations
Selected Java Interview Questions
Selected Java Interview Questions
Aug 24, 2020 · Databases

Performance Evaluation of Multi‑Table Joins in MySQL and Oracle with Large Data Sets

This article investigates the practical limits of joining more than three tables in MySQL by designing experiments with up to 1.5 billion rows, comparing indexed and non‑indexed queries, and contrasting the results with Oracle's performance, while providing full SQL scripts for data generation and analysis.

Data GenerationDatabase OptimizationJoin Performance
0 likes · 11 min read
Performance Evaluation of Multi‑Table Joins in MySQL and Oracle with Large Data Sets
Tencent Cloud Developer
Tencent Cloud Developer
Aug 24, 2020 · Databases

Tencent Cloud MySQL 8.0 Enterprise Features and Industry Applications

Tencent Cloud MySQL 8.0 builds on official MySQL improvements with eight enterprise‑grade enhancements—TDE encryption, kernel‑level audit, multi‑queue thread pool, strong consistency, AEP SSD support, lightweight AP mode, hotspot updates, and SQL rate‑limiting—delivering high‑performance, secure, and scalable solutions for e‑commerce, gaming, finance, and new‑retail workloads while paving the way for cloud‑native, AI‑driven database evolution.

MySQLPerformance OptimizationSecurity
0 likes · 30 min read
Tencent Cloud MySQL 8.0 Enterprise Features and Industry Applications
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 21, 2020 · Databases

MySQL 8.0.20 Group Replication Overview and Practical Guide

This article introduces MySQL 8.0.20 Group Replication, covering single‑master and multi‑master modes, monitoring, failover procedures, abnormal recovery, flow control, performance testing, encountered issues, and limitations, and provides a downloadable PDF with detailed documentation hosted on Baidu Cloud.

Baidu CloudDatabaseGroup Replication
0 likes · 1 min read
MySQL 8.0.20 Group Replication Overview and Practical Guide
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 21, 2020 · Databases

Investigation of MySQL Group Replication Message Cache Behavior and Parameter Effects

This article examines how MySQL Group Replication's message cache fills under load, the impact of the group_replication_message_cache_size and group_replication_member_expel_timeout parameters, and provides experimental observations and practical recommendations for balancing reliability, memory usage, and data consistency.

Database PerformanceGroup ReplicationMessage Cache
0 likes · 5 min read
Investigation of MySQL Group Replication Message Cache Behavior and Parameter Effects
dbaplus Community
dbaplus Community
Aug 19, 2020 · Databases

Why MySQL Chose the Wrong Index and How to Fix It

A production MySQL query that should have returned instantly took 44 seconds because the optimizer selected the primary key index instead of a suitable composite index, and the article explains the root cause, the optimizer's decision process, and multiple practical solutions to prevent such slow‑query incidents.

Database OptimizationEXPLAINFORCE INDEX
0 likes · 15 min read
Why MySQL Chose the Wrong Index and How to Fix It
21CTO
21CTO
Aug 19, 2020 · Databases

How to Use MySQL Polygon Types for Precise Location Check‑In

This tutorial explains how to obtain geographic coordinates, store them as MySQL POLYGON types following OGC standards, insert campus area data, and query with spatial functions and SPATIAL indexes to determine whether a user is within a defined check‑in region.

GISMySQLPolygon
0 likes · 7 min read
How to Use MySQL Polygon Types for Precise Location Check‑In
58 Tech
58 Tech
Aug 19, 2020 · Backend Development

Design and Implementation of a Testing Quality System for the 58.com SSP Advertising Platform

The article details the architecture of 58.com’s SSP advertising platform, identifies three key reliability challenges—data consistency, interface regression, and storage synchronization—and presents a three‑layer testing quality system comprising web‑layer validation, service‑layer automated testing, and data‑layer monitoring with concrete tools and future improvement plans.

MySQLRedisSSP
0 likes · 14 min read
Design and Implementation of a Testing Quality System for the 58.com SSP Advertising Platform
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 19, 2020 · Databases

Understanding MySQL Compressed Tables: Concepts, Benefits, Limitations, and Practical Usage

This article explains the concept of MySQL compressed tables, highlights strong compression products, discusses why and when to use them, outlines their advantages and drawbacks, details supported compression algorithms, and provides step‑by‑step examples for both MyISAM and InnoDB engines along with their impact on B‑tree pages and the InnoDB buffer pool.

Compressed TablesDatabase OptimizationInnoDB
0 likes · 13 min read
Understanding MySQL Compressed Tables: Concepts, Benefits, Limitations, and Practical Usage
Top Architect
Top Architect
Aug 18, 2020 · Databases

Comprehensive Guide to MySQL SQL Optimization Techniques

This article explains why SQL optimization is a cost‑effective way to boost system performance, outlines fundamental principles, common pitfalls such as leading wildcards, IN/OR/NULL misuse, and provides practical tips on indexing, execution order, hints, DML batching, pagination, and table design for MySQL databases.

DatabaseMySQLPerformance
0 likes · 21 min read
Comprehensive Guide to MySQL SQL Optimization Techniques
Programmer DD
Programmer DD
Aug 18, 2020 · Databases

Why SELECT Columns After GROUP BY Are Restricted: MySQL Modes Explained

This article explains the SQL standard limits on SELECT columns after GROUP BY, demonstrates how MySQL's ONLY_FULL_GROUP_BY mode enforces those limits, explores various SQL modes, and clarifies why aggregated queries cannot reference non‑grouped columns directly.

GROUP BYMySQLONLY_FULL_GROUP_BY
0 likes · 11 min read
Why SELECT Columns After GROUP BY Are Restricted: MySQL Modes Explained
21CTO
21CTO
Aug 15, 2020 · Databases

Designing Scalable Like/Comment Systems: MySQL vs Redis Strategies

This article examines common requirements for like, comment, and collection features in apps, compares MySQL partition‑and‑cache designs with Redis storage and caching solutions, provides schema examples, query patterns, and discusses trade‑offs, scalability, and data consistency considerations.

CacheMySQL
0 likes · 7 min read
Designing Scalable Like/Comment Systems: MySQL vs Redis Strategies
ITPUB
ITPUB
Aug 14, 2020 · Databases

Designing Scalable Like/Comment Systems: MySQL vs Redis Strategies

This article explores practical database designs for app features like likes, comments, and collections, comparing MySQL partition‑plus‑cache approaches with Redis storage and caching solutions, detailing schema definitions, query examples, Redis commands for various scenarios, and discussing scalability and consistency trade‑offs.

Likes SystemMySQLRedis
0 likes · 8 min read
Designing Scalable Like/Comment Systems: MySQL vs Redis Strategies
Top Architect
Top Architect
Aug 14, 2020 · Big Data

Billion‑Row MySQL to HBase Synchronization: Load Data, Kafka‑Thrift, and Flink Solutions

This article presents a comprehensive guide for transferring massive MySQL datasets to HBase, covering environment setup on Ubuntu, three synchronization methods—MySQL LOAD DATA, a Kafka‑Thrift pipeline using Maxwell, and real‑time Flink processing—along with performance comparisons and practical tips for Hadoop, HBase, Kafka, Zookeeper, Phoenix, and related tools.

DataSyncFlinkHBase
0 likes · 24 min read
Billion‑Row MySQL to HBase Synchronization: Load Data, Kafka‑Thrift, and Flink Solutions
Open Source Linux
Open Source Linux
Aug 14, 2020 · Operations

Speed Up Linux Workflows: Quick Dir Jump, Vim Tweaks, MySQL Prompt & System Info

This guide introduces several handy Linux command-line tricks, including the 'z' shortcut for rapid directory navigation, a feature‑rich Vim configuration, customizing MySQL prompts, reliable methods to display system version details, and concise commands for checking disk usage, helping users streamline their workflow.

LinuxMySQLSystem Administration
0 likes · 4 min read
Speed Up Linux Workflows: Quick Dir Jump, Vim Tweaks, MySQL Prompt & System Info
MaGe Linux Operations
MaGe Linux Operations
Aug 13, 2020 · Backend Development

Cutting a 37‑Second API Call to 1.5 Seconds with Python Flask Profiling

When a business platform’s settings page took 36 seconds to load, we used Chrome’s Network timing, Python profiling, and MySQL query analysis to identify backend bottlenecks, then applied redesign, thread‑pooling, batch queries, and ORM optimizations, reducing response time from 37.6 s to 1.47 s.

Backend DevelopmentFlaskMySQL
0 likes · 9 min read
Cutting a 37‑Second API Call to 1.5 Seconds with Python Flask Profiling
Top Architect
Top Architect
Aug 13, 2020 · Databases

Understanding Index Usage and Slow Queries in MySQL

This article explains why using indexes does not guarantee fast queries in MySQL, analyzes full index scans, index selectivity, the cost of row look‑ups (back‑to‑table), and presents optimization techniques such as index condition pushdown and virtual columns to improve performance.

Database OptimizationMySQLindex
0 likes · 13 min read
Understanding Index Usage and Slow Queries in MySQL