BestHub
Sign in
Tagged articles
499 articles
Page 4 of 5
Java Captain
Java Captain
Oct 29, 2020 · Databases

MySQL Single‑Table Optimization, Partitioning, Sharding and Scaling Strategies

When a MySQL table grows large, CRUD performance degrades, so this article presents comprehensive optimization techniques—including field design, indexing, query rewriting, engine selection, system parameters, hardware upgrades, read‑write separation, caching, partitioning, vertical and horizontal splitting, sharding architectures, and recommendations for compatible scalable databases—to help maintain high performance and scalability.

Database OptimizationPartitioningmysql
0 likes · 26 min read
MySQL Single‑Table Optimization, Partitioning, Sharding and Scaling Strategies
Programmer DD
Programmer DD
Oct 28, 2020 · Databases

Master MySQL Performance: Essential Database Optimization Techniques

This guide explains how to identify bottlenecks and boost MySQL performance through both soft (query, index, schema) and hard (hardware, configuration, sharding, caching) optimizations, offering practical commands, best‑practice tips, and visual illustrations for each step.

Database OptimizationSQLindexes
0 likes · 9 min read
Master MySQL Performance: Essential Database Optimization Techniques
dbaplus Community
dbaplus Community
Oct 18, 2020 · Databases

Why MongoDB mongos Proxies Crash Under Load and How to Fix It

A high‑traffic Java service using MongoDB experienced intermittent latency spikes and a full‑scale outage caused by excessive connection churn, kernel‑level random‑number generation bottlenecks, and mis‑configured client timeouts, which were diagnosed through log analysis, packet captures, and performance testing, leading to concrete mitigation steps.

Database OptimizationLinux kernelMongoDB
0 likes · 25 min read
Why MongoDB mongos Proxies Crash Under Load and How to Fix It
Architecture Digest
Architecture Digest
Oct 15, 2020 · Databases

Understanding MySQL Indexes: B‑Tree, B+Tree, and Index Design Principles

This article explains how MySQL indexes work, compares binary trees, B‑Tree and B+Tree structures, describes their implementation in MyISAM and InnoDB storage engines, and provides practical guidelines for creating efficient single‑column, composite, and covering indexes to improve query performance.

B+TreeDatabase OptimizationSQL
0 likes · 17 min read
Understanding MySQL Indexes: B‑Tree, B+Tree, and Index Design Principles
Selected Java Interview Questions
Selected Java Interview Questions
Oct 3, 2020 · Databases

SQL Query Optimization Tips and Common Pitfalls

This article presents a comprehensive collection of SQL query optimization techniques, covering index usage, avoiding full table scans, proper handling of NULLs, functions, LIKE patterns, temporary tables, cursors, and other best practices to improve database performance and maintainability.

Database OptimizationSQLindexes
0 likes · 11 min read
SQL Query Optimization Tips and Common Pitfalls
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.

Database OptimizationSQLmysql
0 likes · 10 min read
How to Speed Up MySQL Pagination: Practical Optimizations and Benchmarks
Top Architect
Top Architect
Sep 19, 2020 · Databases

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

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

Database OptimizationPartitioningcloud database
0 likes · 18 min read
MySQL Performance Optimization: Design, Indexing, Partitioning, and Migration Strategies
Java Architect Essentials
Java Architect Essentials
Sep 17, 2020 · Databases

Optimizing Large-Scale SQL Queries with Stored Procedures and Indexing

The article details how a half‑hour SSRS report query on a massive MES database was transformed into a sub‑second operation by analyzing the original SQL, eliminating full table scans, adding proper indexes, using temporary tables and a well‑designed stored procedure, while also discussing common pitfalls and best‑practice tips for high‑performance database querying.

Database OptimizationSQLStored Procedure
0 likes · 20 min read
Optimizing Large-Scale SQL Queries with Stored Procedures and Indexing
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Sep 15, 2020 · Databases

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

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

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

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

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

Database OptimizationQuery RewriteSQL Performance
0 likes · 8 min read
Using MySQL 8.0 Statement Digest and Digest Text Functions for SQL Summarization
ITPUB
ITPUB
Sep 9, 2020 · Databases

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

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

Big DataDatabase OptimizationPartitioning
0 likes · 17 min read
How to Speed Up Massive MySQL User‑Log Tables: Partitioning, Indexing, and Migration Strategies
Programmer DD
Programmer DD
Sep 7, 2020 · Databases

How to Speed Up Massive MySQL Tables: Practical Optimization Strategies

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

Database OptimizationPartitioningindexing
0 likes · 18 min read
How to Speed Up Massive MySQL Tables: Practical Optimization Strategies
IT Architects Alliance
IT Architects Alliance
Aug 29, 2020 · Databases

Why OFFSET/LIMIT Pagination Breaks at Scale and How to Use High‑Performance Keyset Pagination

The article explains why traditional OFFSET and LIMIT pagination becomes inefficient for large tables due to full‑table scans, demonstrates the performance gap with real‑world examples, and presents keyset (cursor‑based) pagination as a fast, index‑driven alternative with practical query patterns.

Database OptimizationKeyset PaginationOFFSET LIMIT
0 likes · 6 min read
Why OFFSET/LIMIT Pagination Breaks at Scale and How to Use High‑Performance Keyset Pagination
DataFunTalk
DataFunTalk
Aug 25, 2020 · Databases

Real‑time Data Ingestion and Optimization with ClickHouse at ByteDance

This article details ByteDance's engineering practices for using ClickHouse to ingest, store, and query massive real‑time recommendation and advertising data, covering early external‑transaction mechanisms, the risks of direct INSERTs, the design and evaluation of Kafka Engine versus Flink pipelines, and a series of performance and reliability improvements implemented to support high‑frequency workloads.

ClickHouseDatabase OptimizationKafka
0 likes · 20 min read
Real‑time Data Ingestion and Optimization with ClickHouse at ByteDance
Selected Java Interview Questions
Selected Java Interview Questions
Aug 24, 2020 · Databases

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

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

Data GenerationDatabase OptimizationJoin Performance
0 likes · 11 min read
Performance Evaluation of Multi‑Table Joins in MySQL and Oracle with Large Data Sets
dbaplus Community
dbaplus Community
Aug 19, 2020 · Databases

Why MySQL Chose the Wrong Index and How to Fix It

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

Database OptimizationFORCE INDEXIndex Selection
0 likes · 15 min read
Why MySQL Chose the Wrong Index and How to Fix It
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 19, 2020 · Databases

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

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

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

Understanding Index Usage and Slow Queries in MySQL

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

Database Optimizationindexmysql
0 likes · 13 min read
Understanding Index Usage and Slow Queries in MySQL
DataFunTalk
DataFunTalk
Aug 11, 2020 · Databases

Applying ClickHouse for Real‑Time Advertising Audience Estimation at ByteDance

This article details how ByteDance leverages ClickHouse to power large‑scale advertising audience estimation, profiling, and statistical analysis, describing the challenges of massive data, strict latency requirements, and the evolution from a simple tag‑uid table to a bitmap‑based architecture with extensive parallel and cache optimizations.

Audience EstimationBitmap IndexClickHouse
0 likes · 21 min read
Applying ClickHouse for Real‑Time Advertising Audience Estimation at ByteDance
Selected Java Interview Questions
Selected Java Interview Questions
Aug 8, 2020 · Databases

MySQL Single‑Table Optimization, Sharding, and Scaling Strategies

This article explains why MySQL tables with massive row counts suffer performance degradation and provides practical guidance on single‑table optimization, field and index design, query tuning, engine selection, system parameters, hardware upgrades, read‑write splitting, caching layers, partitioning, vertical and horizontal sharding, as well as client‑side and proxy‑side sharding solutions.

Database Optimizationindexingmysql
0 likes · 26 min read
MySQL Single‑Table Optimization, Sharding, and Scaling Strategies
Laravel Tech Community
Laravel Tech Community
Aug 6, 2020 · Databases

MySQL Index Types, Creation Methods, and Optimization Strategies

This article explains MySQL's B‑Tree index structure, describes various index types such as primary, unique, normal, full‑text, and composite indexes, and provides practical techniques for creating efficient indexes, choosing column order, using prefix and covering indexes, and optimizing query sorting.

B+TreeDatabase OptimizationSQL
0 likes · 12 min read
MySQL Index Types, Creation Methods, and Optimization Strategies
Tencent Cloud Developer
Tencent Cloud Developer
Aug 6, 2020 · Big Data

ClickHouse Real‑Time Analytics at QQ Music: Challenges, Solutions, and Tencent Cloud Best Practices

QQ Music replaced its slow Hive warehouse with a massive ClickHouse cluster, achieving sub‑second to ten‑second query latency on petabyte‑scale data, enabling real‑time analytics for non‑technical users, and following five operational best practices—ZooKeeper planning, idempotent writes, sensible partitions, read‑write separation, and localized joins—while leveraging Tencent Cloud’s managed ClickHouse service.

ClickHouseDatabase OptimizationOLAP
0 likes · 24 min read
ClickHouse Real‑Time Analytics at QQ Music: Challenges, Solutions, and Tencent Cloud Best Practices
Tencent Database Technology
Tencent Database Technology
Aug 4, 2020 · Databases

Root Cause Analysis of MySQL OOM in Tencent Cloud CDB Instances

This article details a comprehensive investigation of MySQL out‑of‑memory (OOM) alerts on a Tencent Cloud CDB instance during a high‑traffic marketing event, covering background, observed symptoms, step‑by‑step debugging, analysis of server and engine memory usage, relevant MySQL bugs, fetch_cache behavior, and the final configuration recommendations to prevent OOM.

Database OptimizationOOMPerformance Schema
0 likes · 14 min read
Root Cause Analysis of MySQL OOM in Tencent Cloud CDB Instances
JavaEdge
JavaEdge
Jul 26, 2020 · Databases

How to Choose and Use Prefix Indexes for String Columns in MySQL

This article explains why and how to create prefix indexes for string fields in MySQL, compares full‑column and prefix indexes with concrete examples, shows how to pick an optimal prefix length using cardinality statistics, and discusses alternative solutions such as reverse storage and hash fields.

Database OptimizationPrefix IndexSQL
0 likes · 12 min read
How to Choose and Use Prefix Indexes for String Columns in MySQL
Laravel Tech Community
Laravel Tech Community
Jul 25, 2020 · Databases

Comprehensive Guide to MySQL Optimization: Philosophy, Tools, and Practical Steps

This article presents a thorough overview of MySQL optimization, covering the query execution process, philosophical principles, risk assessment, required participants, optimization dimensions, commonly used diagnostic tools, emergency and regular tuning procedures, hardware and system level adjustments, as well as detailed configuration parameters for both the server and the database engine.

Database OptimizationSQLmysql
0 likes · 14 min read
Comprehensive Guide to MySQL Optimization: Philosophy, Tools, and Practical Steps
21CTO
21CTO
Jul 23, 2020 · Databases

How to Achieve 570,000 Writes/sec in MySQL with TokuDB

This article explains how a friend loaded over 2 billion rows into MySQL using XeLabs TokuDB, detailing configuration, bulk‑load commands, benchmark results of roughly 574 k rows per second, and comparisons with InnoDB performance on a cloud server.

Database OptimizationTokuDBbulk load
0 likes · 6 min read
How to Achieve 570,000 Writes/sec in MySQL with TokuDB
ITPUB
ITPUB
Jul 23, 2020 · Databases

How to Achieve 570,000 MySQL Writes per Second with TokuDB

This article details a real‑world test that loads 200 million rows into a MySQL TokuDB table in under six minutes, achieving roughly 570 k writes per second, and compares the results with InnoDB while providing configuration tips and bulk‑loader considerations.

Database OptimizationHigh ThroughputTokuDB
0 likes · 6 min read
How to Achieve 570,000 MySQL Writes per Second with TokuDB
ITPUB
ITPUB
Jul 22, 2020 · Databases

How to Achieve 570,000 Writes per Second in MySQL with TokuDB

This article explains how to load over 20 billion rows into MySQL using the XeLabs‑compiled TokuDB engine, detailing configuration tweaks, table schema, bulk‑loader commands, benchmark results that reach 574 k rows per second, and practical tips for handling auto‑increment keys.

Database OptimizationTokuDBbulk load
0 likes · 7 min read
How to Achieve 570,000 Writes per Second in MySQL with TokuDB
Architect's Tech Stack
Architect's Tech Stack
Jul 19, 2020 · Databases

MySQL Pagination Query Optimization Techniques and Performance Testing

This article explains various MySQL pagination methods—including simple LIMIT queries, sub‑query optimizations, ID‑range filtering, and temporary‑table approaches—provides detailed performance measurements on a large order_history table, and concludes with practical recommendations while also promoting a comprehensive interview‑question PDF collection.

Database OptimizationSQLmysql
0 likes · 10 min read
MySQL Pagination Query Optimization Techniques and Performance Testing
Full-Stack Internet Architecture
Full-Stack Internet Architecture
Jul 16, 2020 · Databases

Comprehensive Guide to MySQL Optimization: Table Design, Indexes, Partitioning, and Read/Write Splitting

This article provides a thorough overview of MySQL performance tuning, covering proper table design according to the three normal forms, various index types and their creation, partitioning strategies, read/write separation, storage engine selection, and practical SQL tips for improving query efficiency.

Database OptimizationPartitioningSQL
0 likes · 14 min read
Comprehensive Guide to MySQL Optimization: Table Design, Indexes, Partitioning, and Read/Write Splitting
ITPUB
ITPUB
Jul 15, 2020 · Databases

Master MySQL Performance: Indexes, EXPLAIN, and Slow‑Query Optimization

This guide compiles essential MySQL optimization techniques—including index cardinality, function indexes, EXPLAIN usage, covering indexes, ICP, slow‑query log analysis, online schema changes, and common SQL pitfalls—to help developers efficiently tune database performance.

Database OptimizationSQLexplain
0 likes · 19 min read
Master MySQL Performance: Indexes, EXPLAIN, and Slow‑Query Optimization
Java Captain
Java Captain
Jun 14, 2020 · Databases

MySQL Single‑Table Optimization, Indexing, Partitioning, and Sharding Strategies

This article presents comprehensive techniques for improving MySQL performance on large single tables, covering column choices, index design, query writing, engine selection, system parameters, hardware upgrades, read‑write splitting, caching, table partitioning, vertical and horizontal sharding, and guidance on selecting mature sharding solutions.

Database OptimizationPartitioningmysql
0 likes · 27 min read
MySQL Single‑Table Optimization, Indexing, Partitioning, and Sharding Strategies
ITPUB
ITPUB
Jun 13, 2020 · Databases

Why Does Alibaba Recommend No More Than Three Table Joins? MySQL vs Oracle Performance Test

The article investigates the Alibaba Java development manual's rule that joins involving more than three tables are prohibited, by designing massive MySQL and Oracle experiments, generating billions of rows, measuring query times, analyzing indexing effects, and concluding that the rule is MySQL‑specific and driven by large‑scale performance limits.

Database OptimizationJoin PerformanceOracle
0 likes · 11 min read
Why Does Alibaba Recommend No More Than Three Table Joins? MySQL vs Oracle Performance Test
Architecture Digest
Architecture Digest
Jun 10, 2020 · Databases

Comprehensive MySQL Single‑Table Optimization and Scaling Strategies

This article presents a thorough guide to improving MySQL performance for large single tables, covering field choices, indexing best practices, query tuning, engine selection, system parameters, hardware upgrades, read/write separation, caching layers, partitioning, vertical and horizontal sharding, and compatible scalable database alternatives.

Database OptimizationPartitioningindexing
0 likes · 21 min read
Comprehensive MySQL Single‑Table Optimization and Scaling Strategies
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
HomeTech
HomeTech
Apr 29, 2020 · Databases

Optimizing Write Hotspots in TiDB: Architecture Overview, Problem Analysis, and Solution

This article details a real‑world case of write‑hotspot performance degradation in a TiDB 3.0.9 cluster, explains TiDB’s architecture, analyzes monitoring data and hot‑region tables, and presents a redesign using varchar primary keys and SHARD_ROW_ID_BITS to disperse writes and dramatically improve latency.

Database OptimizationTiDBWrite Hotspot
0 likes · 16 min read
Optimizing Write Hotspots in TiDB: Architecture Overview, Problem Analysis, and Solution
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
ITPUB
ITPUB
Mar 23, 2020 · Databases

Essential MySQL Performance Tuning Tools: MySQLTuner, Tuning‑Primer, and Percona Toolkit

This guide introduces four open‑source MySQL diagnostic utilities—MySQLTuner, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explaining how to download, run them against a live server, interpret the generated AWR‑style reports, and apply the recommended configuration changes for better stability and speed.

Database OptimizationMySQLTunermysql
0 likes · 8 min read
Essential MySQL Performance Tuning Tools: MySQLTuner, Tuning‑Primer, and Percona Toolkit
Programmer DD
Programmer DD
Mar 21, 2020 · Databases

Essential MySQL Performance Tuning Tools and How to Use Them

This guide introduces four key MySQL optimization utilities—mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest—explains how to download, install, and run each tool, and shows how to interpret their health‑check reports to identify performance bottlenecks, configuration issues, and security risks.

Database Optimizationmysqlpercona-toolkit
0 likes · 8 min read
Essential MySQL Performance Tuning Tools and How to Use Them
UCloud Tech
UCloud Tech
Mar 17, 2020 · Backend Development

How We Scaled an Online Education Platform 20× During COVID: A Technical Playbook

During the COVID‑19 school closures, the education platform rapidly expanded its backend and database architecture, achieving a 20‑fold traffic increase through vertical upgrades, read/write separation, high‑availability redesign, and meticulous performance tuning, all within a few days of planning and execution.

COVID-19 educationDatabase OptimizationUDB
0 likes · 11 min read
How We Scaled an Online Education Platform 20× During COVID: A Technical Playbook
ITPUB
ITPUB
Feb 22, 2020 · Databases

12 Practical SQL Optimization Tips to Speed Up Your Queries

This article presents a concise collection of twelve actionable SQL tuning techniques—including using proper comparison operators, LIMIT 1, appropriate data types, breaking large statements, UNION ALL, consistent query formatting, avoiding SELECT *, indexing WHERE/JOIN/ORDER BY columns, pagination with LIMIT, and leveraging EXPLAIN—to help developers improve database performance.

Database OptimizationQuery PlanningSQL
0 likes · 5 min read
12 Practical SQL Optimization Tips to Speed Up Your Queries
Alibaba Cloud Developer
Alibaba Cloud Developer
Feb 17, 2020 · Operations

How Hema Achieved Zero‑Failure Smart Scheduling: Lessons in System Stability

This article details Hema's approach to guaranteeing system stability for its offline and delivery operations, covering the complete smart‑dispatch architecture, exhaustive dependency analysis, database and middleware safeguards, monitoring strategies, gray‑release practices, testing methods, and emergency response procedures that together enabled a year of zero failures.

Backend ArchitectureDatabase OptimizationMicroservices
0 likes · 24 min read
How Hema Achieved Zero‑Failure Smart Scheduling: Lessons in System Stability
Architecture Digest
Architecture Digest
Dec 28, 2019 · Databases

Comprehensive Guide to MySQL Optimization: Philosophy, Tools, and Practical Steps

This article provides a thorough overview of MySQL optimization, covering the underlying philosophy, risk considerations, participants, optimization scope across hardware, system, application, and database layers, practical tools, command‑line techniques, and detailed tuning recommendations for both system and database parameters.

Database OptimizationHardwareSQL
0 likes · 9 min read
Comprehensive Guide to MySQL Optimization: Philosophy, Tools, and Practical Steps
21CTO
21CTO
Dec 12, 2019 · Databases

Why Does Alibaba’s Java Handbook Ban Joins Over Three Tables? A Deep MySQL & Oracle Performance Test

This article investigates the claim from Alibaba's Java Development Manual that joining more than three tables should be avoided, by setting up a MySQL 5.7 environment, generating massive synthetic data, executing multi‑table join queries, analyzing execution times, and comparing the results with Oracle, ultimately revealing the practical limits of MySQL joins on large data sets.

Data GenerationDatabase OptimizationJoin Performance
0 likes · 12 min read
Why Does Alibaba’s Java Handbook Ban Joins Over Three Tables? A Deep MySQL & Oracle Performance Test
Architecture Digest
Architecture Digest
Dec 6, 2019 · Databases

Understanding InnoDB Index Structures: B+ Trees, Covering Indexes, and Best Practices

This article explains how MySQL InnoDB implements indexes with B+ trees, describes primary and secondary (clustered and non‑clustered) indexes, the concepts of row lookup, covering indexes, composite indexes, the left‑most prefix rule, index push‑down, and provides practical guidelines for creating and maintaining efficient indexes.

B+TreeDatabase OptimizationInnoDB
0 likes · 10 min read
Understanding InnoDB Index Structures: B+ Trees, Covering Indexes, and Best Practices
DevOps Cloud Academy
DevOps Cloud Academy
Nov 20, 2019 · Databases

Introducing Soar: Features, Usage Scenarios, and Practical Examples for SQL Optimization

This article introduces the open‑source SQL optimization tool Soar, explains its core features, configuration methods, heuristic rules, multiple report formats, syntax checking, SQL rewrite capabilities, EXPLAIN analysis, markdown‑to‑HTML conversion, and how to clean up test artifacts, providing concrete command‑line examples throughout.

Command-lineDatabase OptimizationHeuristic Rules
0 likes · 8 min read
Introducing Soar: Features, Usage Scenarios, and Practical Examples for SQL Optimization
Tech Musings
Tech Musings
Oct 31, 2019 · Databases

Master MySQL Tricks: Upserts, Ignoring Errors, Joins, Pagination & More

This guide explores advanced MySQL techniques—including ON DUPLICATE KEY UPDATE for upserts, INSERT IGNORE to bypass errors, replacing subqueries with JOINs, handling LEFT JOIN pitfalls, efficient pagination strategies, multi‑table UPDATE/DELETE via JOIN, and the nuances of COUNT(*) versus COUNT(1).

Database OptimizationJOINSQL
0 likes · 12 min read
Master MySQL Tricks: Upserts, Ignoring Errors, Joins, Pagination & More
Java Captain
Java Captain
Oct 11, 2019 · Databases

MySQL Optimization: Concepts, Schema Design, Indexing, and Query Tuning

This article introduces MySQL fundamentals, covering logical architecture, locking, transactions, storage engines, schema and data type design, as well as index types and their constraints, plus practical creation‑time and query‑time optimization techniques with code examples and best‑practice recommendations.

Database OptimizationQuery TuningTransactions
0 likes · 11 min read
MySQL Optimization: Concepts, Schema Design, Indexing, and Query Tuning
21CTO
21CTO
Sep 8, 2019 · Databases

Master MySQL Optimization: Proven Strategies for High Performance and Stability

This comprehensive guide walks you through MySQL optimization philosophy, risk management, stakeholder involvement, practical tools, hardware and system tuning, kernel parameter adjustments, and detailed MySQL configuration tweaks to achieve both performance gains and reliable stability in production environments.

Database OptimizationSystem Administrationlinux
0 likes · 18 min read
Master MySQL Optimization: Proven Strategies for High Performance and Stability
Efficient Ops
Efficient Ops
Sep 2, 2019 · Databases

Master MySQL Optimization: Strategies, Tools, and Best Practices

This comprehensive guide explains MySQL optimization philosophy, required participants, key dimensions, essential tools, step‑by‑step tuning procedures, hardware and system tuning, and detailed MySQL and InnoDB parameter settings to improve performance and reliability.

Database OptimizationSQLmysql
0 likes · 18 min read
Master MySQL Optimization: Strategies, Tools, and Best Practices
MaGe Linux Operations
MaGe Linux Operations
Aug 19, 2019 · Databases

Master MySQL Optimization: Practical Strategies for High Performance

This guide walks through MySQL's query process, optimization philosophy, required participants, dimensions, tools, and detailed hardware, system, and configuration tuning steps, providing actionable commands and code snippets to improve database stability, security, and performance.

Database Optimizationmysqlperformance tuning
0 likes · 16 min read
Master MySQL Optimization: Practical Strategies for High Performance
dbaplus Community
dbaplus Community
Aug 6, 2019 · Databases

How ClickHouse Powers Real‑Time Hotel Data Analytics at Ctrip

This article details Ctrip's hotel data platform challenges with billions of daily updates and near‑million queries, evaluates various storage options, explains why ClickHouse was chosen, and describes the full‑load and incremental pipelines, monitoring, server clustering, and practical tips that enable sub‑second query performance at massive scale.

Big DataCtripData Warehouse
0 likes · 13 min read
How ClickHouse Powers Real‑Time Hotel Data Analytics at Ctrip
Programmer DD
Programmer DD
Aug 5, 2019 · Databases

Master MySQL Optimization: Practical Strategies to Boost Performance and Stability

This guide walks you through MySQL's query process, the philosophy and risks of optimization, the key participants, core dimensions such as hardware, system, schema and SQL, essential diagnostic tools, emergency and regular tuning steps, system‑level monitoring, kernel and user limits, as well as detailed MySQL and InnoDB configuration parameters for achieving high performance and reliability.

Database OptimizationSQLSystem Administration
0 likes · 15 min read
Master MySQL Optimization: Practical Strategies to Boost Performance and Stability
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 2, 2019 · Databases

How to Retrieve Table Row Count in MySQL 8.0 – Methods, Deprecation of sql_calc_found_rows and Performance Comparison

The article explains five ways to obtain a table's row count in MySQL, discusses the deprecation of the sql_calc_found_rows feature in MySQL 8.0, compares the performance of the old and new approaches using EXPLAIN JSON, and recommends using the standard COUNT(*) query for accurate results.

COUNT(*)Database OptimizationSQL_CALC_FOUND_ROWS
0 likes · 6 min read
How to Retrieve Table Row Count in MySQL 8.0 – Methods, Deprecation of sql_calc_found_rows and Performance Comparison
JD Retail Technology
JD Retail Technology
Jul 19, 2019 · Databases

Optimizing Distributed Transactions in CB‑SQL: From Two‑Phase Commit to Parallel and Pipeline Commit

This article explains how CB‑SQL improves distributed transaction performance by introducing a transaction record table, parallel prepare requests, one‑phase commit for single‑shard writes, latch‑based consistent reads, transaction pipelines, and a staged parallel‑commit mode, dramatically reducing latency and I/O overhead.

CB-SQLDatabase OptimizationDistributed Transactions
0 likes · 13 min read
Optimizing Distributed Transactions in CB‑SQL: From Two‑Phase Commit to Parallel and Pipeline Commit
21CTO
21CTO
Jul 9, 2019 · Databases

How to Load 2 Billion Rows into MySQL Fast with TokuDB – Real‑World Test

This article details a real‑world performance test of loading over two billion rows from a big‑data platform into MySQL using XeLabs TokuDB, covering requirements, TokuDB features, table schema, bulk‑load commands, results, and practical recommendations for high‑throughput data ingestion.

Database OptimizationLarge DataTokuDB
0 likes · 6 min read
How to Load 2 Billion Rows into MySQL Fast with TokuDB – Real‑World Test
Architect's Tech Stack
Architect's Tech Stack
Jun 29, 2019 · Databases

Practical MySQL Optimization Guide: Philosophy, Tools, and Tuning Techniques

This article provides a comprehensive, step‑by‑step guide to MySQL performance tuning, covering the underlying query process, optimization philosophy, practical tools, system‑level diagnostics, hardware and OS recommendations, as well as detailed configuration parameters for both the server and storage engine.

Database OptimizationSQLSystem Tuning
0 likes · 16 min read
Practical MySQL Optimization Guide: Philosophy, Tools, and Tuning Techniques
Architect's Tech Stack
Architect's Tech Stack
Jun 15, 2019 · Backend Development

Making Java Applications Run Faster: Performance Tuning Tools and Practices

This article presents a comprehensive guide to Java application performance optimization, covering OS‑level and JVM‑level diagnostics, profiling tools, GC analysis, JVM tuning, application‑code refactoring, and database‑layer adjustments, illustrated with real‑world case studies and code examples.

Database OptimizationGarbage CollectionJVM
0 likes · 20 min read
Making Java Applications Run Faster: Performance Tuning Tools and Practices
Programmer DD
Programmer DD
Jun 12, 2019 · Databases

Why CentOS 7 Boosts MySQL Performance: Real‑World Sysbench Test Results

An in‑depth performance benchmark compares MySQL on CentOS 6 and CentOS 7 using sysbench with 10 tables of 5 million rows, revealing up to 40% higher QPS on CentOS 7, detailing test setup, results, and key configuration tweaks that dramatically improve throughput.

CentOSDatabase OptimizationPerformance Testing
0 likes · 7 min read
Why CentOS 7 Boosts MySQL Performance: Real‑World Sysbench Test Results
Architecture Digest
Architecture Digest
Jun 11, 2019 · Databases

Database Optimization for Billion‑Scale Data: Partitioning, Sharding, and Vertical Splitting in MySQL

This article explains how a high‑traffic messaging platform with tens of millions of users and billions of daily records can be optimized using MySQL partitioning, sharding (both client‑side and proxy‑side), vertical database splitting, and practical migration scripts to maintain performance and availability.

Big DataDatabase Optimizationmysql
0 likes · 15 min read
Database Optimization for Billion‑Scale Data: Partitioning, Sharding, and Vertical Splitting in MySQL
21CTO
21CTO
Jun 5, 2019 · Databases

12 Proven SQL Tricks to Supercharge Your Database Performance

This article presents twelve practical SQL optimization techniques—from using proper comparison operators and LIMIT clauses to indexing strategies and query consistency—to dramatically improve database query speed and overall application performance.

Database OptimizationQuery PlanningSQL
0 likes · 5 min read
12 Proven SQL Tricks to Supercharge Your Database Performance
Aikesheng Open Source Community
Aikesheng Open Source Community
May 28, 2019 · Databases

Unlocking MySQL 8.0 Invisible Indexes for Safer Query Optimization

This article explains MySQL 8.0's invisible index feature, outlines practical scenarios for its use, provides step‑by‑step SQL examples to create, hide, and test indexes, and shows how to enable the optimizer to consider invisible indexes for better performance and safer schema changes.

Database OptimizationIndex ManagementInvisible Index
0 likes · 18 min read
Unlocking MySQL 8.0 Invisible Indexes for Safer Query Optimization
Tencent Cloud Developer
Tencent Cloud Developer
May 9, 2019 · Backend Development

Evolution of Large-Scale Website Architecture: From Single Server to Distributed Systems

The article traces website architecture evolution from a single‑server LAMP setup to distributed clusters, highlighting stages such as service separation, caching, load‑balanced application servers, read‑write database splitting, CDN/reverse proxy use, distributed storage, NoSQL/search integration, and finally SOA‑based business and service segmentation.

CDNDatabase OptimizationMicroservices
0 likes · 8 min read
Evolution of Large-Scale Website Architecture: From Single Server to Distributed Systems
Efficient Ops
Efficient Ops
May 7, 2019 · Databases

Master MySQL: Essential Tips for Data Types, Indexes, and Query Optimization

This guide compiles essential MySQL 5.5 techniques for teams without a DBA, covering storage engine characteristics, data type selection, index design—including composite, prefix, and covering indexes—and practical query optimizations such as reducing scanned rows, avoiding redundant indexes, and improving execution plans.

Data TypesDatabase OptimizationSQL Performance
0 likes · 22 min read
Master MySQL: Essential Tips for Data Types, Indexes, and Query Optimization
dbaplus Community
dbaplus Community
May 5, 2019 · Databases

Essential MySQL Tips: Data Types, Indexes, and Query Optimization

This article compiles practical MySQL tips for teams without a DBA, covering MySQL's storage‑engine characteristics, data‑type choices, index design strategies, and query‑performance improvements with concrete examples, code snippets, and best‑practice recommendations.

Data TypesDatabase Optimizationmysql
0 likes · 18 min read
Essential MySQL Tips: Data Types, Indexes, and Query Optimization
Java High-Performance Architecture
Java High-Performance Architecture
Mar 28, 2019 · Databases

Mastering MySQL Indexes: From Hash Tables to B+ Trees and Beyond

This article explains the main index structures used in MySQL—including hash tables, ordered arrays, search trees, and B+ trees—covers why InnoDB prefers B+ trees, the benefits of auto‑increment primary keys, and key concepts such as covering indexes, the left‑most prefix rule, and index‑pushdown for query optimization.

B+TreeDatabase OptimizationSQL
0 likes · 7 min read
Mastering MySQL Indexes: From Hash Tables to B+ Trees and Beyond
21CTO
21CTO
Feb 14, 2019 · Databases

Loading 2 Billion Rows into MySQL Fast with XeLabs TokuDB

This article details a real‑world test of loading over 2 billion rows into MySQL using XeLabs TokuDB, compares InnoDB and TokuDB performance, shows configuration, table schema, bulk‑loader commands, and provides practical conclusions for high‑throughput data ingestion.

Database OptimizationLarge DataTokuDB
0 likes · 7 min read
Loading 2 Billion Rows into MySQL Fast with XeLabs TokuDB
Youzan Coder
Youzan Coder
Jan 25, 2019 · Databases

MySQL/InnoDB Deadlock Analysis: Detection, Handling, and Prevention

The guide explains MySQL/InnoDB deadlocks—how circular lock waits arise, the wait‑for‑graph detection that rolls back the transaction with fewer undo logs, the various lock modes and their behavior in UPDATE/INSERT/DELETE, and practical strategies such as proper indexing, consistent access order, and configuration tweaks to detect, handle, and prevent deadlocks.

Concurrency ControlDatabase LocksDatabase Optimization
0 likes · 13 min read
MySQL/InnoDB Deadlock Analysis: Detection, Handling, and Prevention
Efficient Ops
Efficient Ops
Jan 22, 2019 · Databases

Master MySQL Optimization: Proven Strategies, Tools, and System Tuning

An in‑depth guide to MySQL optimization covering the query execution process, risk‑aware philosophy, hardware and system tuning, essential diagnostic tools, practical SQL and index adjustments, and comprehensive configuration settings to boost performance while maintaining stability and security.

Database OptimizationSQLmysql
0 likes · 17 min read
Master MySQL Optimization: Proven Strategies, Tools, and System Tuning
vivo Internet Technology
vivo Internet Technology
Dec 18, 2018 · Databases

2018 3306π 深圳站年会 - Database Technologies and Practices

The 2018 3306π Shenzhen annual conference, co‑hosted by the 3306π community, Zhishu Hall and vivo, attracted over 150 attendees and featured expert talks on MySQL 8.0, open‑source data‑transfer middleware, TDSQL for finance, RadonDB, InnoDB enhancements, large‑scale Redis clusters, and Youzan database operations, with presentation materials available online.

Database ArchitectureDatabase OptimizationMongoDB
0 likes · 3 min read
2018 3306π 深圳站年会 - Database Technologies and Practices
Tencent Cloud Developer
Tencent Cloud Developer
Oct 22, 2018 · Databases

TXSQL Internals@2018: Tencent MySQL Architecture and Optimization

The article details Tencent’s TXSQL (Tencent MySQL) architecture and optimizations—including asynchronous table deletion, DDL NO_WAIT/WAIT, MDL visibility, lock splitting, parallel replication, query push‑down, read‑view enhancements, low‑overhead auditing and KMS‑integrated encryption—highlighting its role as the core engine powering CDB for diverse industries such as gaming, finance, e‑commerce and internal services like WeChat and QQ.

CDBDatabase OptimizationInnoDB
0 likes · 10 min read
TXSQL Internals@2018: Tencent MySQL Architecture and Optimization
Architecture Talk
Architecture Talk
Oct 10, 2018 · Databases

Master MySQL Optimization: Proven Strategies for Performance and Stability

This article provides a comprehensive guide to MySQL optimization, covering the underlying query process, risk-aware philosophy, practical troubleshooting steps, hardware and system tuning, essential monitoring tools, and detailed configuration adjustments to improve performance and stability in production environments.

Database Optimizationlinuxmysql
0 likes · 13 min read
Master MySQL Optimization: Proven Strategies for Performance and Stability
Java Backend Technology
Java Backend Technology
Sep 26, 2018 · Databases

Master MySQL Optimization: Practical Strategies for High Performance

This article provides a comprehensive guide to MySQL optimization, covering the underlying query process, philosophical considerations, practical troubleshooting steps, hardware and system tuning, essential tools, and detailed configuration adjustments to achieve stable and high‑performance database operations.

Database Optimizationlinuxmysql
0 likes · 15 min read
Master MySQL Optimization: Practical Strategies for High Performance