BestHub
Sign in
Tagged articles
5000 articles
Page 47 of 50
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.

BackupBatch DeleteIndex Optimization
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.

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

Sysbenchdatabase scalinghigh concurrency
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.

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

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

SQL Optimizationindexingmysql
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.

NUMATencent Cloud CDBdatabase migration
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 SELECTdatabase migrationindex
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 optimizationIO Waitdatabase
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 designSQL Best Practicesindexing
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 OptimizationTransactionsindexes
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 designInnoDBauto_increment
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.

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

Consistencyflash salemysql
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 designSQL Best Practicesindexing
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.

SQLSecurityStorage Engine
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.

LIMITbuffer poolindex
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 ArchitectureSQL Serverhigh availability
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 PerformanceNULLauto_increment
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.

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

MGRbuginternal temporary tables
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 DevelopmentPHPWeb Development
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 LockInnoDBlocking modes
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 affinityContainersResource Groups
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 designflash sale
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.

coredumpcrash analysismysql
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.

JOINLIMITOrder By
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 SELECTSQLdatabase migration
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.

JDBCReadWrite SplittingShardingSphere
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 designDistributed TransactionsPerformance 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.

InnoDBPerformance Schemalock_wait_timeout
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.

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

CSVFIFA18SQL
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 PerformanceSQL Join
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.

Database ArchitectureRead-Write Separationcaching
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 ArchitectureInnoDBPartitioning
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 MiddlewareSQL
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.

BackendDockerJava
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 ToolsSQLmysql
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 FundamentalsTransactionsindexes
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+TreeInnoDBStorage Engine
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.

ContainersDockerInstallation
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 CacheMemory Managementlinux
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.

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

LIMITbuffer poolindex
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 DeleteOnline DDLSlow query analysis
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 SpillPerformance Schemamysql
0 likes · 5 min read
MySQL Internal Temporary Tables: When They Switch to Disk Storage
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Apr 3, 2020 · Databases

Understanding B+ Tree Indexes in MySQL

This article explains why B+ trees are the dominant data structure for MySQL indexes, compares them with hash tables, linked lists, and skip lists, and details page splits, merges, and how index values map to row records, helping readers master high‑frequency interview questions.

B+TreeData StructuresDatabase Index
0 likes · 14 min read
Understanding B+ Tree Indexes in MySQL
Programmer DD
Programmer DD
Apr 2, 2020 · Databases

How Alibaba Cloud RDS Outperforms Tencent and AWS in MySQL Benchmarks

This article presents a detailed MySQL performance benchmark of Alibaba Cloud RDS, Tencent Cloud RDS, and AWS RDS using sysbench, analyzes configuration differences, shows results across mixed, read‑only, and no‑index update workloads, and offers practical recommendations for cloud database tuning.

Cloud RDSDatabase OptimizationSysbench
0 likes · 12 min read
How Alibaba Cloud RDS Outperforms Tencent and AWS in MySQL Benchmarks
Qunar Tech Salon
Qunar Tech Salon
Apr 2, 2020 · Databases

30 Practical SQL Optimization Tips with Examples

This article presents thirty actionable SQL performance recommendations—including selecting specific columns, using LIMIT, avoiding OR and functions in WHERE clauses, proper indexing, batch inserts, and query planning—each illustrated with clear examples and explanations to help developers write faster, more efficient queries.

SQLdatabaseindexing
0 likes · 19 min read
30 Practical SQL Optimization Tips with Examples
Aikesheng Open Source Community
Aikesheng Open Source Community
Apr 1, 2020 · Databases

MySQL Data Types: An In-Depth Guide

This article provides a comprehensive overview of MySQL data types—including numeric, floating‑point, decimal, string, date/time, binary, bit, enum, and set types—explaining their storage characteristics, appropriate use cases, and performance implications through practical examples and SQL demonstrations.

Data TypesDatabase designSQL
0 likes · 23 min read
MySQL Data Types: An In-Depth Guide
Java Captain
Java Captain
Mar 31, 2020 · Databases

Optimizing Large MySQL Tables: Indexes, Partitioning, Sharding, and System Tuning

When a MySQL table grows to millions of rows, query, insert, update and delete performance degrades sharply, but by applying proper field design, index strategies, SQL best practices, engine selection, system parameters, caching, partitioning, vertical and horizontal sharding, and choosing suitable client‑side or proxy‑side architectures, the database can efficiently handle tens of millions of records.

Database TuningPartitioningmysql
0 likes · 24 min read
Optimizing Large MySQL Tables: Indexes, Partitioning, Sharding, and System Tuning
ITPUB
ITPUB
Mar 30, 2020 · Databases

How to Streamline MySQL Audits with the Open‑Source Yearning Platform

Yearning is an open‑source MySQL audit platform that offers query auditing, SQL review, and workflow automation, providing a web‑based interface for managing tickets, permissions, and notifications, with detailed installation and configuration instructions for quick deployment.

Database ManagementSQL AuditingYearning
0 likes · 7 min read
How to Streamline MySQL Audits with the Open‑Source Yearning Platform
Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 30, 2020 · Databases

Getting Started with dtle: Installation, Configuration, and MySQL Data Migration Guide

This guide introduces dtle, an open‑source MySQL data‑transfer middleware, covering download, installation on three nodes, detailed dtle.conf configuration, startup commands, creating source and target users, preparing job.json, using HTTP API to create and monitor migration jobs, and verifying data migration results.

Data MigrationHTTP APIJob
0 likes · 11 min read
Getting Started with dtle: Installation, Configuration, and MySQL Data Migration Guide
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Mar 29, 2020 · Databases

How to Locate and Analyze Slow SQL Queries in MySQL

This article explains how to identify slow MySQL queries using the slow‑query log and SHOW PROCESSLIST, configure logging parameters, and analyze query performance with EXPLAIN, covering key output fields, common values, and practical code examples for effective SQL optimization.

Database PerformanceSQL Optimizationexplain
0 likes · 14 min read
How to Locate and Analyze Slow SQL Queries in MySQL