BestHub
Sign in
Tagged articles

MySQL

5000 articles · Page 46 of 50
Laravel Tech Community
Laravel Tech Community
Sep 29, 2020 · Databases

Comprehensive MySQL Database Operations: Export, Import, DDL, DML, and User Management

This guide provides step‑by‑step instructions for exporting entire MySQL databases or individual tables, importing data, performing common DDL and DML operations such as creating, altering, renaming, and dropping databases and tables, managing fields, and configuring user permissions, all illustrated with concrete command‑line examples.

DDLDMLDatabase
0 likes · 9 min read
Comprehensive MySQL Database Operations: Export, Import, DDL, DML, and User Management
MaGe Linux Operations
MaGe Linux Operations
Sep 29, 2020 · Databases

Master Python Database Access: From DB‑API to Connection Pools

This article introduces Python's DB‑API for interacting with various databases, explains how to use PyMySQL and SQLAlchemy for MySQL, demonstrates basic CRUD operations, safeguards against SQL injection, and shows how to implement thread‑safe connection pools with DBUtils for scalable backend applications.

DBAPIDBUtilsMySQL
0 likes · 17 min read
Master Python Database Access: From DB‑API to Connection Pools
MaGe Linux Operations
MaGe Linux Operations
Sep 28, 2020 · Backend Development

Build a Scalable Python Web Scraper for 3000+ Companies

This article walks through creating a Python web scraper that extracts financial data for over three thousand listed companies, starting from a simple pandas script and progressively adding error handling, MySQL storage, and multiprocessing to build a robust, production‑ready tool.

MySQLPythonWeb Scraping
0 likes · 7 min read
Build a Scalable Python Web Scraper for 3000+ Companies
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 28, 2020 · Backend Development

DTLE 3.20.09.0 Release Notes – New Monitoring Features, Docker Support, and Bug Fixes

Version 3.20.09.0 of the open‑source DTLE data‑transfer component for MySQL has been released, introducing replication‑delay and memory‑usage monitoring with Prometheus, providing configuration examples and Docker commands, and fixing incremental serialization, CPU usage, and uppercase‑where clause handling.

DTLEData TransferDocker
0 likes · 5 min read
DTLE 3.20.09.0 Release Notes – New Monitoring Features, Docker Support, and Bug Fixes
Laravel Tech Community
Laravel Tech Community
Sep 27, 2020 · Databases

Using MySQL for Persistent Data and Redis for Read‑Only Data: Consistency Strategies and High‑Concurrency Solutions

The article explains how MySQL stores persistent data while Redis serves read‑only data, outlines read/write request handling, discusses consistency issues in low and high concurrency scenarios, and provides practical solutions such as cache invalidation, queue‑based updates, and deployment considerations.

Data ConsistencyDatabaseMySQL
0 likes · 6 min read
Using MySQL for Persistent Data and Redis for Read‑Only Data: Consistency Strategies and High‑Concurrency Solutions
Selected Java Interview Questions
Selected Java Interview Questions
Sep 27, 2020 · Databases

Understanding How MySQL InnoDB Solves Phantom Reads

This article explains the four transaction isolation levels, defines phantom reads, and details how MySQL's InnoDB engine uses MVCC snapshot reads and next‑key locking (including the next‑key principle and lock composition) to prevent phantom reads under the REPEATABLE READ isolation level.

InnoDBIsolation LevelMVCC
0 likes · 2 min read
Understanding How MySQL InnoDB Solves Phantom Reads
Java Backend Technology
Java Backend Technology
Sep 27, 2020 · Databases

How to Speed Up MySQL Pagination: Practical Optimizations and Benchmarks

This article examines why naïve LIMIT‑OFFSET pagination on a multi‑million‑row MySQL table becomes increasingly slow, presents several optimization techniques—including simple LIMIT usage, sub‑query id lookup, ID‑range queries, and temporary‑table tricks—along with concrete benchmark results to guide developers toward faster data paging.

MySQLPerformanceSQL
0 likes · 10 min read
How to Speed Up MySQL Pagination: Practical Optimizations and Benchmarks
Java Captain
Java Captain
Sep 26, 2020 · Databases

MySQL Performance Optimization Techniques: LIMIT, Implicit Conversion, Join Rewrite, Mixed Sorting, EXISTS, Condition Pushdown, and More

This article explains common MySQL performance pitfalls such as large OFFSET in LIMIT clauses, implicit type conversion, sub‑query updates, mixed sorting, EXISTS usage, condition push‑down limitations, and demonstrates how rewriting queries with indexes, JOINs, UNION ALL, and WITH clauses can dramatically reduce execution time.

JOINMySQLSQL optimization
0 likes · 14 min read
MySQL Performance Optimization Techniques: LIMIT, Implicit Conversion, Join Rewrite, Mixed Sorting, EXISTS, Condition Pushdown, and More
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Sep 26, 2020 · Databases

Why Indexes Still Lead to Slow Queries: A MySQL Deep Dive

This article explains why using an index does not guarantee fast MySQL queries, examines how execution time, index selectivity, full index scans, and costly back‑to‑table lookups affect slow‑query logs, and presents practical optimization techniques such as virtual columns and index condition push‑down.

IndexInnoDBMySQL
0 likes · 13 min read
Why Indexes Still Lead to Slow Queries: A MySQL Deep Dive
Top Architect
Top Architect
Sep 25, 2020 · Databases

Introduction to ClickHouse: Installation, MySQL Migration, Performance Testing, and Best Practices

This article introduces ClickHouse, a column‑store OLAP database, explains its advantages over row‑store systems, guides installation on macOS, details migration strategies from MySQL, presents performance benchmarks showing 200‑fold speedups, and discusses synchronization methods, pitfalls, and practical tips.

ClickHouseColumnar DatabaseData Migration
0 likes · 6 min read
Introduction to ClickHouse: Installation, MySQL Migration, Performance Testing, and Best Practices
MaGe Linux Operations
MaGe Linux Operations
Sep 24, 2020 · Databases

Step-by-Step Guide to Compile and Install MySQL 8.0 on CentOS 7

Learn how to compile MySQL 8.0 from source on CentOS 7, including installing dependencies, creating users, configuring build options, setting up systemd services, initializing the database, and securing the root account, with complete command examples and configuration file details.

CentOSCompilationMySQL
0 likes · 7 min read
Step-by-Step Guide to Compile and Install MySQL 8.0 on CentOS 7
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 24, 2020 · Databases

MySQL High Availability vs Oracle High Availability: Can MySQL Replace Oracle in the Financial Industry?

The livestream discusses MySQL's high‑availability architectures compared with Oracle's, analyzes share‑nothing versus share‑everything designs, logical versus physical logging, and concludes that MySQL's share‑nothing and logical binlog replication are better suited for modern financial‑industry workloads, while also covering audience Q&A and upcoming topics.

Database ArchitectureFinancial IndustryGroup Replication
0 likes · 10 min read
MySQL High Availability vs Oracle High Availability: Can MySQL Replace Oracle in the Financial Industry?
Efficient Ops
Efficient Ops
Sep 22, 2020 · Databases

Mastering MySQL Master‑Slave Replication: A Step‑by‑Step Guide

This article explains what MySQL master‑slave replication is, outlines its benefits, details the underlying mechanisms and event types, and provides a comprehensive, command‑line tutorial for configuring both master and slave servers, complete with code snippets and illustrative diagrams.

Binary LogDatabaseMaster‑Slave
0 likes · 9 min read
Mastering MySQL Master‑Slave Replication: A Step‑by‑Step Guide
Top Architect
Top Architect
Sep 22, 2020 · Databases

Understanding MySQL Query Execution and Optimization Techniques

This article explains MySQL’s logical architecture, query processing stages, client‑server protocol, query cache, parsing, optimization, execution engine, and provides practical performance‑tuning advice such as index design, data‑type choices, covering indexes, limit pagination, and handling UNION and JOIN operations.

Database PerformanceMySQLQuery Optimization
0 likes · 35 min read
Understanding MySQL Query Execution and Optimization Techniques
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 22, 2020 · Databases

Using pt-query-digest to Analyze MySQL Slow Query Logs

This article introduces pt-query-digest from Percona Toolkit, explains how to install the toolkit, configure MySQL slow‑query logging, run pt-query-digest on the slow log, interpret its detailed output, and locate specific SQL statements for performance tuning.

MySQLSlow Query Logpercona-toolkit
0 likes · 15 min read
Using pt-query-digest to Analyze MySQL Slow Query Logs
Java Captain
Java Captain
Sep 22, 2020 · Databases

MySQL Basics: DDL/DML/DCL/TCL Commands, Normal Forms, and Table Pivoting

This article provides a comprehensive overview of fundamental MySQL concepts, covering DDL, DML, DCL, and TCL commands, detailed explanations of first to third normal forms, common anomalies, and practical examples of converting between horizontal and vertical table structures using SQL scripts.

DDLDMLMySQL
0 likes · 13 min read
MySQL Basics: DDL/DML/DCL/TCL Commands, Normal Forms, and Table Pivoting
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 21, 2020 · Databases

Comprehensive MySQL Tutorial: Basics, Commands, Data Types, Constraints, Functions, Joins, Stored Procedures, and Transactions

This article provides a detailed, step‑by‑step guide to MySQL covering its purpose, installation, directory layout, common commands, data types, table creation and modification, constraints, functions, subqueries, joins, custom functions, stored procedures, transaction control, and user management, illustrated with extensive code examples and screenshots.

DatabaseMySQLSQL
0 likes · 31 min read
Comprehensive MySQL Tutorial: Basics, Commands, Data Types, Constraints, Functions, Joins, Stored Procedures, and Transactions
Liangxu Linux
Liangxu Linux
Sep 20, 2020 · Databases

Master MySQL: Installation, Configuration, and Advanced Query Techniques

This guide provides a comprehensive overview of MySQL, covering its definition, installation steps for Windows and Linux, connection commands, database and user management, permission handling, table creation and alteration, CRUD operations, and essential data types, all illustrated with practical code examples.

CRUDMySQLQueries
0 likes · 16 min read
Master MySQL: Installation, Configuration, and Advanced Query Techniques
FunTester
FunTester
Sep 20, 2020 · Databases

When VIP Expiration Hits 2038: The MySQL INT Overflow Bug

A hidden bug occurs when a user's VIP subscription is repeatedly extended, causing the stored expiration timestamp to exceed MySQL's signed INT maximum of 2147483647 (January 19, 2038), which prevents the date from being saved correctly.

2038 problemINT overflowMySQL
0 likes · 3 min read
When VIP Expiration Hits 2038: The MySQL INT Overflow Bug
Code Ape Tech Column
Code Ape Tech Column
Sep 20, 2020 · Databases

20 Principles for MySQL Index Optimization

This article presents twenty practical rules for optimizing MySQL indexes—including when to use or avoid indexes, how to write queries that can leverage them, the importance of index selectivity, prefix indexes, covering indexes, and common pitfalls—to help developers write faster, more efficient SQL statements.

Database PerformanceIndex OptimizationMySQL
0 likes · 16 min read
20 Principles for MySQL Index Optimization
Architect
Architect
Sep 19, 2020 · Databases

ClickHouse Overview, MySQL Migration, Performance Testing, and Practical Tips

This article introduces ClickHouse as a high‑performance columnar OLAP database, compares it with row‑based systems, details migration methods from MySQL, presents performance benchmarks showing dramatic speed gains, discusses data synchronization strategies, explains why ClickHouse is fast, and shares common pitfalls and solutions.

ClickHouseColumnar DatabaseData Migration
0 likes · 5 min read
ClickHouse Overview, MySQL Migration, Performance Testing, and Practical Tips
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.

Cloud DatabaseIndexingMySQL
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.

IndexMySQLauto_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.

Cloud DatabaseIndexingMySQL
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 PerformanceIndex
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.

AutomationDevOpsMySQL
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.

DatabaseDeadlockInnoDB
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.

Database MigrationMySQLOnline DDL
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.

Binary LogMySQLRedo Log
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.

DruidJDBCMySQL
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.

MySQLQuery RewriteSQL Performance
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.

EasyExcelExcelJava
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.

IndexingMySQLOptimization
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.

MySQLauto_incrementdatabase-index
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 DataIndexingMySQL
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.

CacheDatabaseMySQL
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.

ElasticsearchMySQLautocomplete
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.

Database ReplicationMySQLRedo Log
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.

Cache ConsistencyDatabase CachingMySQL
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.

Java ValidationMySQLSQL Performance
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.

IndexingMySQLPerformance Tuning
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.

AutomationMySQLdatabase release
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.

Binary LogLVMMySQL
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.

Cloud DatabaseMySQLPerformance
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.

Data IngestionDebeziumHive
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 PerformanceIndexingMySQL
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 fundamentalsMySQLSQL optimization
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 QueryJavaMyBatis
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.

EXPLAINMySQLQuery Optimization
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.

AutomationData synchronizationDatabase 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 ConsistencyHintManagerJava
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.

Cloud DatabaseDBADatabase Architecture
0 likes · 34 min read
How to Become an Outstanding Data Craftsman: Insights from Database Experts
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 TypesInterviewMySQL
0 likes · 20 min read
Master MySQL Basics: Interview Q&A on Relational Databases