BestHub
Sign in
Tagged articles
5000 articles
Page 47 of 50
Java Architect Essentials
Java Architect Essentials
May 25, 2020 · Databases

MySQL Sharding and Partitioning: Strategies, Tools, and Best Practices

This article explains MySQL performance bottlenecks, compares IO and CPU limits, introduces horizontal and vertical sharding and partitioning concepts, presents practical scenarios, outlines common tools such as Sharding‑Sphere, TDDL and Mycat, and provides step‑by‑step guidance for implementation, troubleshooting and scaling.

MySQLShardingVertical Partitioning
0 likes · 8 min read
MySQL Sharding and Partitioning: Strategies, Tools, and Best Practices
Ops Development Stories
Ops Development Stories
May 24, 2020 · Cloud Native

How to Deploy Rancher on K3s with Nginx, Keepalived, and MySQL

This guide walks through preparing the environment, installing required tools, configuring firewalls, setting up host files, deploying Nginx with Keepalived for high‑availability, installing Docker, MySQL, and finally installing K3s and Rancher using Helm, including certificate creation and troubleshooting steps.

DockerK3sKubernetes
0 likes · 16 min read
How to Deploy Rancher on K3s with Nginx, Keepalived, and MySQL
iQIYI Technical Product Team
iQIYI Technical Product Team
May 22, 2020 · Databases

Understanding MySQL Binlog, Redo Log, and Two‑Phase Commit for Event‑Driven Order Processing

The article explains how iQIYI’s order system leverages MySQL binlog and redo log with a two‑phase commit to drive event‑driven processing, reveals hidden consistency gaps where binlog events can precede database state, and proposes retry or direct binlog consumption strategies to ensure reliable order fulfillment.

DatabaseEventDrivenMySQL
0 likes · 15 min read
Understanding MySQL Binlog, Redo Log, and Two‑Phase Commit for Event‑Driven Order Processing
Laravel Tech Community
Laravel Tech Community
May 21, 2020 · Databases

When to Use Optimistic vs. Pessimistic Locks in MySQL (and Redis)

This article explains the concepts, advantages, and drawbacks of MySQL pessimistic and optimistic locks, shows how to implement each with SQL and PHP code, compares their suitability for different traffic patterns, and demonstrates a Redis‑based optimistic lock for high‑concurrency flash‑sale scenarios.

ConcurrencyMySQLOptimistic Lock
0 likes · 10 min read
When to Use Optimistic vs. Pessimistic Locks in MySQL (and Redis)
vivo Internet Technology
vivo Internet Technology
May 20, 2020 · Databases

Understanding MySQL Crash‑Safe Mechanism: WAL, Redo/Undo/Binlog, Two‑Phase and Group Commit, and Recovery Process

MySQL achieves crash‑safe durability by employing a write‑ahead log architecture that records changes in redo, undo, and binary logs, coordinates them through two‑phase and group commit to maintain order, and uses a structured recovery process to replay or roll back transactions after any failure.

Crash SafetyGroup CommitMySQL
0 likes · 17 min read
Understanding MySQL Crash‑Safe Mechanism: WAL, Redo/Undo/Binlog, Two‑Phase and Group Commit, and Recovery Process
Aikesheng Open Source Community
Aikesheng Open Source Community
May 18, 2020 · Databases

Understanding MySQL Group Replication Consistency Levels (group_replication_consistency)

This article explains the MySQL group_replication_consistency parameter, describes its five possible values, demonstrates the three most common consistency modes (EVENTUAL, BEFORE, AFTER) with practical multi‑node examples, and discusses their advantages, drawbacks, and impact on query latency and data integrity.

ConsistencyDatabaseGroup Replication
0 likes · 13 min read
Understanding MySQL Group Replication Consistency Levels (group_replication_consistency)
Laravel Tech Community
Laravel Tech Community
May 18, 2020 · Databases

How to Diagnose and Eliminate MySQL Master‑Slave Replication Lag

This article explains why MySQL master‑slave replication can suffer from latency, examines the root causes on both master and slave sides, and provides practical architectural, hardware, and configuration solutions—including semi‑sync and parallel replication—to improve data consistency and performance.

DatabaseLatencyMaster‑Slave
0 likes · 11 min read
How to Diagnose and Eliminate MySQL Master‑Slave Replication Lag
Laravel Tech Community
Laravel Tech Community
May 18, 2020 · Databases

MySQL Large‑Table Index Optimization and Delete Performance Improvement

This article analyzes a MySQL master‑slave instance with a massive arrival_record table, identifies slow‑query causes using pt‑query‑digest and tcpdump, proposes index redesign, demonstrates backup/restore with mydumper, compares online DDL and pt‑osc, and presents batch‑delete strategies that dramatically reduce SLA‑triggering latency.

Batch DeleteIndex OptimizationLarge Table
0 likes · 14 min read
MySQL Large‑Table Index Optimization and Delete Performance Improvement
JavaEdge
JavaEdge
May 17, 2020 · Databases

Mastering MySQL High Availability: Backup, Binlog, and Replication Strategies

This guide explains how to achieve MySQL high availability and scalability through full and incremental backups, binlog-based point‑in‑time recovery, and both asynchronous and synchronous replication, while highlighting trade‑offs, best practices, and practical command examples.

DatabaseMySQLbackup
0 likes · 11 min read
Mastering MySQL High Availability: Backup, Binlog, and Replication Strategies
Laravel Tech Community
Laravel Tech Community
May 17, 2020 · Databases

Can MySQL Handle 100,000 Concurrent Connections? A Real‑World Test

This article details a comprehensive experiment that evaluates MySQL's ability to sustain up to 100,000 simultaneous connections using Percona Server's thread‑pool plugin, sysbench clients, adjusted OS/network limits, and multiple IP addresses, presenting hardware specs, configuration steps, observed errors, performance metrics, and practical recommendations.

MySQLSysbenchdatabase scaling
0 likes · 8 min read
Can MySQL Handle 100,000 Concurrent Connections? A Real‑World Test
Aikesheng Open Source Community
Aikesheng Open Source Community
May 16, 2020 · Databases

Weekly Community Newsletter: MySQL Leads DB‑Engines May Ranking, DBLE & TXLE Updates, and MySQL Tips

This week’s community newsletter highlights the DB‑Engines May 2024 ranking where MySQL shows the highest growth, shares links to MySQL troubleshooting and performance articles, reports DBLE and TXLE development progress, bug fixes, community Q&A, and outlines upcoming plans for the open‑source middleware projects.

Community UpdatesDBLEDatabase Ranking
0 likes · 5 min read
Weekly Community Newsletter: MySQL Leads DB‑Engines May Ranking, DBLE & TXLE Updates, and MySQL Tips
Aikesheng Open Source Community
Aikesheng Open Source Community
May 14, 2020 · Databases

MySQL 5.7 Upgrade Failure Caused by Default SSL Enablement and JDBC useSSL Parameter Misconfiguration

The article analyzes a MySQL 5.7 upgrade that broke an application due to SSL being enabled by default in version 5.7.28, explains how the JDBC useSSL=true setting triggered handshake errors, and provides several practical solutions such as disabling SSL, adjusting auto‑generation settings, and updating the connection string.

DatabaseJDBCMySQL
0 likes · 12 min read
MySQL 5.7 Upgrade Failure Caused by Default SSL Enablement and JDBC useSSL Parameter Misconfiguration
MaGe Linux Operations
MaGe Linux Operations
May 10, 2020 · Databases

How to Build a Complete MySQL Monitoring Dashboard with Prometheus and Grafana

This guide walks through deploying mysqld_exporter, configuring Prometheus and Grafana, and monitoring essential MySQL metrics such as replication health, query throughput, slow‑query counts, connection usage, and InnoDB buffer‑pool statistics, while also showing how to set up alert rules for proactive database operations.

ExportersGrafanaMySQL
0 likes · 15 min read
How to Build a Complete MySQL Monitoring Dashboard with Prometheus and Grafana
Java Captain
Java Captain
May 10, 2020 · Databases

MySQL Performance Optimization and Best Practices

This article shares practical MySQL performance optimization techniques, covering table size limits, connection settings, data type choices, index design, query rewriting, pagination, and batch processing, with code examples and actionable guidelines to improve query speed and scalability.

MySQLSQL optimizationindexing
0 likes · 13 min read
MySQL Performance Optimization and Best Practices
ITPUB
ITPUB
May 10, 2020 · Databases

How We Migrated MySQL to Tencent Cloud CDB and Boosted Performance Up to 10×

This case study details the migration of Weimeng's MySQL databases to Tencent Cloud CDB, describing the testing methodology, performance bottlenecks discovered (NUMA, network parameters, low‑concurrency issues, and version bugs), the step‑by‑step optimizations applied, and the resulting QPS improvements across various workloads.

MySQLNUMAPerformance tuning
0 likes · 20 min read
How We Migrated MySQL to Tencent Cloud CDB and Boosted Performance Up to 10×
macrozheng
macrozheng
May 9, 2020 · Databases

Why Insert‑Into‑Select Can Lock Your MySQL Tables and How to Fix It

An engineer’s mishap with a massive ‘INSERT INTO … SELECT’ migration exposed how full‑table scans lock MySQL tables, causing payment failures, and shows that adding an index on the filter column prevents the lock and ensures safe, efficient data transfer.

INSERT INTO SELECTMySQLdatabase migration
0 likes · 7 min read
Why Insert‑Into‑Select Can Lock Your MySQL Tables and How to Fix It
Programmer DD
Programmer DD
May 9, 2020 · Databases

How to Identify and Reduce CPU Bottlenecks in MySQL

This article explains which components consume CPU on a MySQL server, analyzes the impact of user‑space processing and IO wait, and provides practical strategies—such as optimizing indexes, reducing unnecessary calculations, and improving IO handling—to lower CPU usage and improve overall database performance.

CPU optimizationDatabaseIO Wait
0 likes · 6 min read
How to Identify and Reduce CPU Bottlenecks in MySQL
macrozheng
macrozheng
May 8, 2020 · Backend Development

Build an Efficient ‘Nearby Users’ Feature Using MySQL, Redis, MongoDB & GeoHash

This article explores multiple backend strategies for implementing a location‑based “nearby users” service, covering pure MySQL queries, MySQL combined with GeoHash, Redis Geo commands, and MongoDB geospatial indexes, explaining design principles, pros and cons, and providing complete code examples for each approach.

GeoHashLBSMongoDB
0 likes · 20 min read
Build an Efficient ‘Nearby Users’ Feature Using MySQL, Redis, MongoDB & GeoHash
Laravel Tech Community
Laravel Tech Community
May 7, 2020 · Databases

MySQL Database Naming, Design, Field, Index, and Operation Standards

This guide presents comprehensive MySQL best‑practice standards covering object naming, basic schema design, field definitions, index design, common index column recommendations, covering indexes, SET usage, SQL development rules, and safe operational behaviors to improve performance, maintainability, and security.

Database DesignMySQLSQL Best Practices
0 likes · 19 min read
MySQL Database Naming, Design, Field, Index, and Operation Standards
Selected Java Interview Questions
Selected Java Interview Questions
May 7, 2020 · Databases

MySQL Fundamentals and Optimization: Concepts, Schema Design, Indexes, and Query Tuning

This article explains MySQL's core architecture, lock and transaction mechanisms, storage engines, and provides practical creation‑time and query‑time optimization techniques such as proper data types, index selection, query rewriting, and performance analysis using EXPLAIN, supplemented with concrete SQL examples.

Database OptimizationIndexesMySQL
0 likes · 10 min read
MySQL Fundamentals and Optimization: Concepts, Schema Design, Indexes, and Query Tuning
Sohu Tech Products
Sohu Tech Products
May 6, 2020 · Databases

Why MySQL AUTO_INCREMENT Primary Keys Are Not Monotonic or Continuous

The article explains why MySQL's AUTO_INCREMENT primary keys can become non‑monotonic and non‑continuous due to early‑version in‑memory counters, restart behavior, concurrency lock modes, and how MySQL 8.0 persists the counter to mitigate these issues while discussing design trade‑offs and best practices.

Database DesignInnoDBMySQL
0 likes · 11 min read
Why MySQL AUTO_INCREMENT Primary Keys Are Not Monotonic or Continuous
Laravel Tech Community
Laravel Tech Community
May 2, 2020 · Operations

Comprehensive MySQL and Linux Operations Interview Guide

This guide compiles essential MySQL security steps, master‑slave replication principles, backup scripts, Linux boot overview, common port services, virus mitigation, monitoring tools, nginx optimization, InnoDB lock troubleshooting, replication lag reduction, high‑availability components, data migration utilities, and automation configuration management techniques for operations engineers.

DatabaseLinuxMySQL
0 likes · 13 min read
Comprehensive MySQL and Linux Operations Interview Guide
Architecture Digest
Architecture Digest
May 2, 2020 · Databases

Designing High‑Performance Flash‑Sale (秒杀) Systems with MySQL: Balancing Consistency and Performance

This article explains how to build a MySQL‑based flash‑sale system that guarantees high performance and strong consistency, discusses common pitfalls such as overselling and duplicate purchases, and presents progressive solutions from simple unique indexes to transaction‑based locking and performance‑oriented designs that may sacrifice consistency when necessary.

ConsistencyMySQLflash sale
0 likes · 11 min read
Designing High‑Performance Flash‑Sale (秒杀) Systems with MySQL: Balancing Consistency and Performance
Laravel Tech Community
Laravel Tech Community
May 2, 2020 · Databases

MySQL Database Naming, Design, Indexing, and Development Standards

This comprehensive guide outlines MySQL database naming conventions, basic design rules, field specifications, index design principles, common index recommendations, and best practices for SQL development and operational behavior to ensure performance, maintainability, and security.

Database DesignMySQLSQL Best Practices
0 likes · 18 min read
MySQL Database Naming, Design, Indexing, and Development Standards
Laravel Tech Community
Laravel Tech Community
Apr 30, 2020 · Databases

Essential MySQL FAQ: Core Concepts, Features, and Best Practices

This comprehensive MySQL FAQ covers its definition, implementation language, key features, differences from SQL, storage engines, data types, triggers, security tips, performance considerations, and practical queries such as retrieving the N‑th highest salary, providing a solid reference for developers and DBAs.

DatabaseMySQLSQL
0 likes · 14 min read
Essential MySQL FAQ: Core Concepts, Features, and Best Practices
Top Architect
Top Architect
Apr 30, 2020 · Databases

Why LIMIT with Large Offsets Slows MySQL Queries and How to Optimize It

The article explains why using LIMIT with a large offset in MySQL causes severe performance degradation, demonstrates the problem with real data, and shows how rewriting the query with a sub‑query that selects only primary keys dramatically reduces execution time by avoiding massive random I/O and buffer‑pool pollution.

LIMITMySQLbuffer pool
0 likes · 8 min read
Why LIMIT with Large Offsets Slows MySQL Queries and How to Optimize It
Architecture Digest
Architecture Digest
Apr 30, 2020 · Databases

Understanding MySQL Query Optimization and Performance Tuning

This article explains MySQL's logical architecture, query processing steps, and the underlying principles of query optimization, covering topics such as client‑server protocol, query cache, parsing, optimizer cost model, index structures, and practical performance‑tuning strategies for efficient database operations.

IndexesMySQLquery optimization
0 likes · 33 min read
Understanding MySQL Query Optimization and Performance Tuning
DataFunTalk
DataFunTalk
Apr 29, 2020 · Databases

High Availability Architecture for SQL Server, MySQL, and Redis at Ctrip

This article explains Ctrip's high‑availability designs for SQL Server, MySQL, and Redis, describing multi‑replica strategies, evolution from legacy mirroring to AlwaysOn, multi‑node MHA management, and Redis sentinel‑based failover, while emphasizing fault‑tolerance across data centers.

Database ArchitectureMySQLRedis
0 likes · 12 min read
High Availability Architecture for SQL Server, MySQL, and Redis at Ctrip
Youzan Coder
Youzan Coder
Apr 29, 2020 · Databases

MySQL Slow Query Analysis: Root Causes and Optimization Strategies

The article examines why MySQL queries become slow, detailing system‑level issues such as network latency, I/O bottlenecks, and CPU settings, alongside database‑level problems like missing indexes, type conversion, poor execution plans, lock contention, skewed data, and inefficient SQL patterns, and offers optimization strategies.

Database PerformanceIndex OptimizationInnoDB
0 likes · 15 min read
MySQL Slow Query Analysis: Root Causes and Optimization Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 29, 2020 · Databases

Understanding MySQL Field Attributes: NULL, NOT NULL, and AUTO_INCREMENT Performance Considerations

This article examines MySQL column attributes—especially NULL vs NOT NULL handling, the impact of NULL on concatenation, COUNT and indexing, as well as AUTO_INCREMENT behaviors, lock modes, step/offset settings, and overflow scenarios—to help developers write more efficient and reliable SQL.

Database PerformanceIndexesMySQL
0 likes · 10 min read
Understanding MySQL Field Attributes: NULL, NOT NULL, and AUTO_INCREMENT Performance Considerations
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 28, 2020 · Databases

New Features in MySQL 8.0.20 Release

MySQL 8.0.20 introduces a range of enhancements including new SHOW_ROUTINE privilege, hash join improvements, index‑level optimizer hints, performance schema refinements, SQL syntax changes, InnoDB doublewrite buffer relocation, binary log transaction compression, X Plugin and protocol upgrades, and additional replication options.

BinaryLogDatabaseInnoDB
0 likes · 5 min read
New Features in MySQL 8.0.20 Release
ITPUB
ITPUB
Apr 27, 2020 · Databases

Why MySQL 8.0.15 Leaks Internal Temp Files and How Upgrading to 8.0.16 Fixes It

A production MySQL 8.0.15 MGR cluster suffered from massive internal temporary‑table file leaks due to a known bug, which was diagnosed through log analysis and Oracle documentation and resolved by upgrading to MySQL 8.0.16, confirming the issue is version‑specific and not MGR‑related.

MGRMySQLUpgrade
0 likes · 11 min read
Why MySQL 8.0.15 Leaks Internal Temp Files and How Upgrading to 8.0.16 Fixes It
Laravel Tech Community
Laravel Tech Community
Apr 26, 2020 · Backend Development

Top PHP Interview Questions and Answers for Developers

This article compiles a comprehensive set of PHP interview questions covering fundamentals, session and cookie handling, database transactions, MySQL optimization, version control tools, string manipulation, HTTP status codes, MVC concepts, and practical coding tasks with detailed answers and code examples.

Backend DevelopmentInterview QuestionsMySQL
0 likes · 28 min read
Top PHP Interview Questions and Answers for Developers
Programmer DD
Programmer DD
Apr 26, 2020 · Databases

Understanding MySQL Table and Row Locks: Mechanisms, Modes, and Types

This article explains the differences between MySQL table locks and row locks, how they are implemented by the server and storage engines, the lock modes and types (including intention, auto‑increment, gap, next‑key, and insert‑intention locks), and provides practical SQL examples with diagrams.

Gap LockInnoDBMySQL
0 likes · 13 min read
Understanding MySQL Table and Row Locks: Mechanisms, Modes, and Types
NetEase Game Operations Platform
NetEase Game Operations Platform
Apr 25, 2020 · Databases

MySQL 8.0 Resource Groups: Configuration, Usage, and Limitations

This article explains how MySQL 8.0 Resource Groups enable fine‑grained CPU binding and thread‑priority control, provides sample SQL procedures and commands, details Linux environment setup, discusses implementation internals, outlines known limitations especially in containerized environments, and suggests practical usage scenarios.

CPU affinityContainersMySQL
0 likes · 16 min read
MySQL 8.0 Resource Groups: Configuration, Usage, and Limitations
ITPUB
ITPUB
Apr 24, 2020 · Databases

Designing a High‑Performance, Consistent Flash‑Sale System with MySQL

This article explains how to design a high‑performance, strongly consistent flash‑sale (秒杀) system using MySQL InnoDB, covering table schema, unique indexes, transaction handling, row‑level locking, and trade‑offs between consistency and performance, with concrete SQL examples and flow diagrams.

ConsistencyDatabase DesignMySQL
0 likes · 11 min read
Designing a High‑Performance, Consistent Flash‑Sale System with MySQL
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 24, 2020 · Databases

Enabling Core Dumps for MySQL Crash Diagnosis

This guide demonstrates how to reproduce a MySQL crash, enable system‑level core dumps, adjust user limits, configure MySQL to generate core files, and use gdb to extract useful debugging information for complex failure analysis.

MySQLcoredumpcrash analysis
0 likes · 4 min read
Enabling Core Dumps for MySQL Crash Diagnosis
Architecture Digest
Architecture Digest
Apr 24, 2020 · Databases

Detailed Explanation of MySQL InnoDB Lock Mechanisms

This article provides a comprehensive overview of MySQL InnoDB locking, covering shared/exclusive locks, intention locks, record locks, gap locks, next‑key locks, insert‑intention locks, and auto‑increment locks, with examples, compatibility tables, and practical SQL snippets to illustrate each mechanism.

Database ConcurrencyInnoDBLocks
0 likes · 12 min read
Detailed Explanation of MySQL InnoDB Lock Mechanisms
Java Backend Technology
Java Backend Technology
Apr 23, 2020 · Databases

Why MySQL LIMIT Can Reverse ORDER BY in LEFT JOIN Queries

The author discovers a puzzling MySQL bug where moving the LIMIT clause outside a nested SELECT causes the final result set to be ordered incorrectly, explains how ORDER BY inside subqueries is ignored during LEFT JOIN processing, and recommends placing ORDER BY and LIMIT at the outermost query level.

JoinLIMITMySQL
0 likes · 5 min read
Why MySQL LIMIT Can Reverse ORDER BY in LEFT JOIN Queries
Programmer DD
Programmer DD
Apr 23, 2020 · Databases

How INSERT INTO SELECT Nearly Crashed a MySQL DB – Lessons & Fix

An engineer’s attempt to migrate millions of orders using INSERT INTO SELECT caused massive table locking, payment failures, and system alerts, but by analyzing the locking behavior and adding an index on the timestamp column, the migration succeeded efficiently, illustrating the importance of proper indexing for large‑scale data moves.

INSERT INTO SELECTMySQLSQL
0 likes · 7 min read
How INSERT INTO SELECT Nearly Crashed a MySQL DB – Lessons & Fix
Architecture Digest
Architecture Digest
Apr 22, 2020 · Databases

Implementing Database Sharding with ShardingSphere‑JDBC in Spring Boot

This article explains how to use ShardingSphere‑JDBC to achieve horizontal database sharding and read/write splitting in a Spring Boot application, covering ShardingSphere concepts, configuration, entity and DAO code, custom sharding algorithm, and practical testing with multiple MySQL instances.

JDBCMySQLReadWrite Splitting
0 likes · 23 min read
Implementing Database Sharding with ShardingSphere‑JDBC in Spring Boot
Java Backend Technology
Java Backend Technology
Apr 22, 2020 · Databases

Master MySQL Partitioning and Sharding: Theory, Practice, and Performance

This article explains the programming mindset of splitting and merging, details MySQL partition implementation and internal file types, demonstrates how partitioning improves query performance, and explores sharding strategies, middleware choices, and common issues like distributed transactions and cross‑shard joins.

Database DesignMySQLPerformance Optimization
0 likes · 11 min read
Master MySQL Partitioning and Sharding: Theory, Practice, and Performance
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 21, 2020 · Databases

Diagnosing and Resolving MySQL InnoDB Row Lock Wait Timeout Errors

This article explains the causes of MySQL InnoDB row lock wait timeout errors, distinguishes row and metadata lock waits, and provides practical methods—including manual replication, monitoring scripts, general_log analysis, and Performance Schema queries—to locate, diagnose, and resolve such locking issues.

InnoDBMySQLPerformance Schema
0 likes · 18 min read
Diagnosing and Resolving MySQL InnoDB Row Lock Wait Timeout Errors
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 20, 2020 · Databases

Understanding and Managing Undo Tablespaces in MySQL 8.0

This article explains the concept of MySQL Undo Log, traces its evolution from version 5.5 to 8.0, and provides step‑by‑step instructions with examples for creating, viewing, configuring, deleting, and moving undo tablespaces, highlighting the new parameters and defaults introduced in MySQL 8.0.

InnoDBMySQLSQL
0 likes · 9 min read
Understanding and Managing Undo Tablespaces in MySQL 8.0
Java Backend Technology
Java Backend Technology
Apr 20, 2020 · Databases

Why Indexes Can Still Cause Slow Queries and How to Optimize Them

This article explains why using indexes does not guarantee fast queries, explores the relationship between index usage and slow‑query logs, and presents practical MySQL optimization techniques such as improving index selectivity, reducing table‑lookup costs, and leveraging virtual columns.

Index OptimizationMySQLslow-query
0 likes · 14 min read
Why Indexes Can Still Cause Slow Queries and How to Optimize Them
21CTO
21CTO
Apr 18, 2020 · Databases

How to Import FIFA18 Player Data from CSV into MySQL with Python

This step‑by‑step guide shows how to download the FIFA 18 player dataset from GitHub, create a MySQL database and table, read the CSV with Python’s csv.DictReader, generate INSERT statements, batch‑load the data efficiently, and query Argentine players, illustrating a complete end‑to‑end data‑import workflow.

CSVFIFA18MySQL
0 likes · 12 min read
How to Import FIFA18 Player Data from CSV into MySQL with Python
Java Captain
Java Captain
Apr 18, 2020 · Databases

Understanding Linux Memory Usage, Buffer Cache, and SQL Join Optimization

This article explains how to inspect and clear Linux memory buffers, interprets the fields shown by the free command, and then dives into SQL join types, performance‑impacting factors such as join_buffer_size, and practical optimization techniques like indexing and denormalization.

Buffer CacheDatabase PerformanceLinux
0 likes · 7 min read
Understanding Linux Memory Usage, Buffer Cache, and SQL Join Optimization
Architects' Tech Alliance
Architects' Tech Alliance
Apr 16, 2020 · Databases

Database Application Architecture Principles and Common Schemes

This article outlines core database architecture principles—high availability, high performance, consistency, and scalability—examines four common deployment schemes (primary‑standby, dual‑primary, primary‑replica with read/write separation, and a combined dual‑primary/replica model), and presents multiple consistency and cache‑integration solutions.

CachingDatabase ArchitectureMySQL
0 likes · 12 min read
Database Application Architecture Principles and Common Schemes
Meituan Technology Team
Meituan Technology Team
Apr 16, 2020 · Databases

Analyzing and Optimizing MySQL Performance on Intel Skylake CPUs

Meituan’s DBA team discovered that Intel Skylake CPUs dramatically increased PAUSE‑instruction latency, causing MySQL’s ut_delay spin‑wait loops to consume most CPU cycles and reduce write throughput, and they restored performance by back‑porting MySQL 8.0’s spin_wait_pause_multiplier patch to 5.7, upgrading to CentOS 7, and moving to Cascadelake hardware.

CPUDatabaseLinux
0 likes · 18 min read
Analyzing and Optimizing MySQL Performance on Intel Skylake CPUs
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 15, 2020 · Databases

Understanding MySQL Large Object Types: TEXT/BLOB and JSON

This article explains MySQL's large object data types—TEXT, BLOB, and JSON—covering their storage formats, performance implications, indexing rules, partition restrictions, relevant server parameters, and practical examples of creating tables, inserting data, and querying JSON values.

BlobDatabase DesignJSON
0 likes · 10 min read
Understanding MySQL Large Object Types: TEXT/BLOB and JSON
Programmer DD
Programmer DD
Apr 14, 2020 · Databases

Understanding InnoDB Storage Architecture and MySQL Partitioning Strategies

This article explains InnoDB's logical storage hierarchy of tablespaces, segments, extents, and pages, then details MySQL's partitioning concepts, types, creation syntax, and performance considerations, providing practical examples and guidance for effective database design.

Database ArchitectureInnoDBMySQL
0 likes · 8 min read
Understanding InnoDB Storage Architecture and MySQL Partitioning Strategies
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 13, 2020 · Databases

How DBLE Implements MySQL View Functionality

This article explains how DBLE, a PaaS middleware, implements MySQL view capabilities by first describing MySQL view concepts and the MERGE and TEMPTABLE algorithms, then detailing DBLE's push‑down and non‑push‑down approaches, the criteria for each, and providing illustrative diagrams.

DBLEDatabase MiddlewareMySQL
0 likes · 5 min read
How DBLE Implements MySQL View Functionality
Wukong Talks Architecture
Wukong Talks Architecture
Apr 13, 2020 · Backend Development

Quick Guide to Setting Up the Renren‑Fast Management Backend for the PassJava Project

This tutorial walks through downloading the Renren‑Fast open‑source admin framework, integrating it into the PassJava project, configuring MySQL and Docker, adjusting application settings, launching the backend service, building the Vue front‑end, and performing end‑to‑end login verification, providing a complete step‑by‑step guide for developers.

DockerJavaMySQL
0 likes · 4 min read
Quick Guide to Setting Up the Renren‑Fast Management Backend for the PassJava Project
Liangxu Linux
Liangxu Linux
Apr 12, 2020 · Databases

Essential MySQL Performance Tuning Tools and How to Use Them

This guide introduces four open‑source MySQL tuning utilities—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download and run each tool, and shows how to interpret their AWR‑style reports for concrete performance and security improvements.

Database ToolsMySQLOptimization
0 likes · 9 min read
Essential MySQL Performance Tuning Tools and How to Use Them
Big Data Technology & Architecture
Big Data Technology & Architecture
Apr 12, 2020 · Databases

Comprehensive MySQL Fundamentals and Advanced Topics Overview

This extensive guide covers MySQL fundamentals and advanced concepts, including storage engines, data types, indexes, transactions, isolation levels, locking mechanisms, views, stored procedures, triggers, SQL optimization techniques, replication, backup strategies, and sharding approaches for high‑availability and scalability.

Database FundamentalsIndexesMySQL
0 likes · 73 min read
Comprehensive MySQL Fundamentals and Advanced Topics Overview
Programmer DD
Programmer DD
Apr 9, 2020 · Databases

How Many Rows Can a Single InnoDB B+ Tree Store? A Deep Dive

This article explains how InnoDB organizes data with B+ trees, calculates the maximum number of rows a single tree can hold (around 20 million), and shows how page size, pointer count, and tree height affect MySQL index performance.

B+TreeInnoDBMySQL
0 likes · 11 min read
How Many Rows Can a Single InnoDB B+ Tree Store? A Deep Dive
Wukong Talks Architecture
Wukong Talks Architecture
Apr 8, 2020 · Databases

Step-by-Step Guide to Installing MySQL Using Docker

This tutorial explains how to download the MySQL Docker image, create and run a MySQL container with volume mappings and environment variables, verify the container, connect to the database via Workbench, and access the container’s shell and host files.

ContainersDatabaseDocker
0 likes · 3 min read
Step-by-Step Guide to Installing MySQL Using Docker
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 8, 2020 · Databases

DBLE Heartbeat Detection Module: Purpose and Source Code Analysis

This article explains the purpose of DBLE's heartbeat detection, including high‑availability switching, read load balancing, and idle connection management, and provides a detailed walkthrough of the module's source code—from the Scheduler initialization to the MySQLHeartbeat implementation—illustrating how the system monitors MySQL instance status.

DBLEHeartbeatMySQL
0 likes · 8 min read
DBLE Heartbeat Detection Module: Purpose and Source Code Analysis
MaGe Linux Operations
MaGe Linux Operations
Apr 7, 2020 · Databases

Understanding MySQL Locks: Types, Engines, and Deadlock Prevention

This article explains why MySQL requires locking, compares table and row lock types, details MyISAM and InnoDB lock mechanisms—including optimistic vs. pessimistic locks, lock algorithms, and deadlock handling—while providing practical SQL examples and prevention strategies.

Database LocksInnoDBMyISAM
0 likes · 16 min read
Understanding MySQL Locks: Types, Engines, and Deadlock Prevention
Java Backend Technology
Java Backend Technology
Apr 7, 2020 · Databases

How to Inspect and Clear Linux Buff/Cache and Optimize MySQL Joins

This article explains how to use Linux commands like free and sync to view and clear buffer/cache memory, describes the information shown by free, and then dives into SQL join types, their performance impact, and optimization techniques such as indexing, join_buffer tuning, and join algorithms.

Buffer CacheLinuxMySQL
0 likes · 9 min read
How to Inspect and Clear Linux Buff/Cache and Optimize MySQL Joins
Efficient Ops
Efficient Ops
Apr 6, 2020 · Databases

How to Build a MySQL Monitoring Platform with Prometheus and Grafana

This article walks through setting up a production‑grade MySQL monitoring solution using Prometheus and Grafana, covering exporter installation, MySQL user configuration, systemd service setup, Prometheus job definition, key MySQL performance metrics, and basic alerting rules.

GrafanaMetricsMySQL
0 likes · 15 min read
How to Build a MySQL Monitoring Platform with Prometheus and Grafana
Java Captain
Java Captain
Apr 5, 2020 · Databases

Optimizing MySQL LIMIT Queries by Reducing Row Lookups

This article explains why large OFFSET values in MySQL LIMIT queries cause severe performance degradation and demonstrates how rewriting the query to fetch primary keys first and then joining reduces execution time from seconds to milliseconds, supported by buffer‑pool analysis and practical test results.

LIMITMySQLbuffer pool
0 likes · 8 min read
Optimizing MySQL LIMIT Queries by Reducing Row Lookups
Java Backend Technology
Java Backend Technology
Apr 5, 2020 · Databases

How to Optimize Massive MySQL Tables: Index Tuning, Online DDL, and Batch Deletion

This article walks through diagnosing severe SLA alerts caused by slow queries on a huge MySQL table, using pt‑query‑digest and tcpdump to uncover index misuse, then proposes new composite and single‑column indexes, demonstrates online DDL versus pt‑osc, and shows how batch deletions and efficient backup/restore dramatically reduce execution time and replication lag.

Batch DeleteMySQLOnline DDL
0 likes · 16 min read
How to Optimize Massive MySQL Tables: Index Tuning, Online DDL, and Batch Deletion
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 3, 2020 · Databases

MySQL Internal Temporary Tables: When They Switch to Disk Storage

Through a hands‑on experiment, this article demonstrates how MySQL’s internal temporary tables, governed by tmp_table_size and max_heap_table_size, transition from in‑memory heap storage to on‑disk storage, showing the resulting I/O behavior, disk usage statistics, and the impact of engine configuration.

Disk SpillMySQLPerformance Schema
0 likes · 5 min read
MySQL Internal Temporary Tables: When They Switch to Disk Storage