BestHub
Sign in
Tagged articles
26 articles
Page 1 of 1
Java Architect Handbook
Java Architect Handbook
Nov 26, 2025 · Databases

Why UUID Primary Keys Slow Down MySQL and How to Optimize Them

This article explains the performance drawbacks of using UUIDs as primary keys in MySQL—including larger indexes, random inserts, and slower comparisons—details why data updates trigger index refreshes, and offers practical optimization techniques such as ordered UUIDs, binary storage, hybrid auto‑increment keys, and table partitioning.

Binary StorageDatabase PerformanceIndex Optimization
0 likes · 8 min read
Why UUID Primary Keys Slow Down MySQL and How to Optimize Them
Su San Talks Tech
Su San Talks Tech
Mar 7, 2025 · Databases

How to Fix MySQL Deep Pagination Bottlenecks with 6 Proven Techniques

This article dissects the performance problems of MySQL deep pagination, explains why OFFSET‑based queries become increasingly costly, and presents six practical optimization strategies—including cursor pagination, deferred joins, covering indexes, partitioning, precomputed pages, and Elasticsearch integration—to dramatically speed up order‑lookup queries in large e‑commerce databases.

ElasticsearchTable Partitioningcovering index
0 likes · 9 min read
How to Fix MySQL Deep Pagination Bottlenecks with 6 Proven Techniques
Java High-Performance Architecture
Java High-Performance Architecture
May 23, 2024 · Databases

How to Scale Your Database: Sharding Strategies and Middleware Comparison

This article explains the difference between database sharding and table partitioning, illustrates scaling challenges with a fast‑growing startup scenario, and compares popular sharding middleware such as Cobar, TDDL, Atlas, ShardingSphere, and Mycat, offering practical recommendations for different company sizes.

MycatShardingSphereTable Partitioning
0 likes · 12 min read
How to Scale Your Database: Sharding Strategies and Middleware Comparison
macrozheng
macrozheng
Dec 6, 2023 · Databases

When and How to Implement Database Sharding and Partitioning for High‑Scale Systems

This article explains why database sharding and partitioning become necessary, outlines performance bottlenecks, presents software and hardware optimization techniques, details horizontal and vertical splitting strategies, and discusses the added complexity such as cross‑database joins, distributed transactions, and ID generation.

Distributed TransactionsSQL OptimizationTable Partitioning
0 likes · 13 min read
When and How to Implement Database Sharding and Partitioning for High‑Scale Systems
Java High-Performance Architecture
Java High-Performance Architecture
Nov 2, 2023 · Databases

How to Tackle Large MySQL Tables: Partitioning, Sharding, and Archiving Strategies

When MySQL tables grow to millions of rows, insert and query latency increase, schema changes become costly, and irrelevant data bloats storage, so this guide evaluates table size, explains why B+‑tree depth hurts performance, and presents partitioning, sharding, and hot‑cold archiving solutions with practical SQL examples.

B+TreeDatabase OptimizationTable Partitioning
0 likes · 15 min read
How to Tackle Large MySQL Tables: Partitioning, Sharding, and Archiving Strategies
Selected Java Interview Questions
Selected Java Interview Questions
Sep 26, 2023 · Databases

Practical Guide to Monthly Horizontal Partitioning in MySQL Using Stored Procedures and SpringBoot

This article presents a hands‑on walkthrough of implementing in‑database horizontal partitioning by month for a high‑volume billing table, covering the business background, design decisions, stored‑procedure table creation, dynamic table selection in MyBatis, and query strategies such as serial‑number lookup and date‑range retrieval.

SpringBootStored ProcedureTable Partitioning
0 likes · 31 min read
Practical Guide to Monthly Horizontal Partitioning in MySQL Using Stored Procedures and SpringBoot
ITPUB
ITPUB
Sep 18, 2023 · Databases

Why Keep a MySQL Table Under 20 Million Rows? Primary Key & Data Page Insights

This article explains why a single MySQL table should stay below about twenty million rows by examining primary‑key limits, InnoDB data‑page structure, B+‑tree storage calculations, and provides a practical recommendation based on row size and fragmentation.

B+TreeData PageDatabase design
0 likes · 9 min read
Why Keep a MySQL Table Under 20 Million Rows? Primary Key & Data Page Insights
Top Architect
Top Architect
Aug 18, 2023 · Databases

MySQL Table Splitting and Pagination Using the MERGE Engine

This article explains how to split a massive MySQL table into smaller tables, use the MERGE engine to create a unified view, troubleshoot common errors, and implement efficient pagination across the split tables with example SQL and Java code.

MERGE engineSQLTable Partitioning
0 likes · 6 min read
MySQL Table Splitting and Pagination Using the MERGE Engine
Architect's Guide
Architect's Guide
Jun 20, 2023 · Databases

Why and How to Perform Database Sharding and Table Partitioning

Database sharding and table partitioning are essential scaling techniques that separate data across multiple databases and tables to handle growing user volume, data size, and concurrency, with explanations of when to split, methods (horizontal vs vertical), and a comparison of popular middleware solutions.

Table Partitioningdatabase shardinghorizontal scaling
0 likes · 14 min read
Why and How to Perform Database Sharding and Table Partitioning
Selected Java Interview Questions
Selected Java Interview Questions
Oct 12, 2022 · Backend Development

MySQL Table Splitting and Pagination Using the MERGE Engine

This article explains how to handle massive MySQL tables by splitting a single large table into multiple smaller tables, creating a MERGE (union) table to combine them, and using the merged view to implement efficient pagination, including necessary SQL statements and troubleshooting tips.

MERGE engineSQLTable Partitioning
0 likes · 5 min read
MySQL Table Splitting and Pagination Using the MERGE Engine
Top Architect
Top Architect
Jun 30, 2022 · Databases

Database Sharding and Partitioning Strategies with Practical Implementation

This article explains why high‑traffic systems need database sharding, compares table‑level and database‑level partitioning methods, presents concrete MySQL table‑creation scripts and Java service code, and discusses the advantages, drawbacks, and common middleware solutions such as Sharding‑JDBC and Mycat.

MycatSharding-JDBCTable Partitioning
0 likes · 12 min read
Database Sharding and Partitioning Strategies with Practical Implementation
Qunar Tech Salon
Qunar Tech Salon
Sep 1, 2021 · Databases

Implementing Transparent Table Partitioning in PostgreSQL: Strategies, Code Samples, and Performance Gains

This article explains why and when to use table partitioning in PostgreSQL, describes inheritance‑based and declarative partitioning methods (list, range, hash), provides complete SQL and C code examples for creating and maintaining partitions, compares version differences, and shows a real‑world performance improvement case from Qunar.

C extensionsDatabase AdministrationSQL Performance
0 likes · 24 min read
Implementing Transparent Table Partitioning in PostgreSQL: Strategies, Code Samples, and Performance Gains
IT Xianyu
IT Xianyu
Mar 8, 2021 · Databases

Understanding Data Indexes, B+Tree vs Hash Indexes, Table Partitioning, and MySQL Optimization Techniques

This article explains how ordered data indexes improve query efficiency, compares B+Tree and hash indexes, discusses table partitioning versus sharding, outlines MVCC read types, examines row‑level lock pros and cons, and provides practical MySQL optimization tips including key vs index differences and engine choices.

B+TreeHash IndexTable Partitioning
0 likes · 10 min read
Understanding Data Indexes, B+Tree vs Hash Indexes, Table Partitioning, and MySQL Optimization Techniques
NiuNiu MaTe
NiuNiu MaTe
Feb 21, 2021 · Databases

Mastering Database Sharding: When and How to Split Tables Effectively

This article explains why large tables hurt performance, defines database sharding and its vertical and horizontal strategies, compares partitioning by key, size, or time, and outlines practical implementation options and migration steps for robust, scalable backend systems.

Backend DevelopmentTable Partitioningdatabase sharding
0 likes · 12 min read
Mastering Database Sharding: When and How to Split Tables Effectively
21CTO
21CTO
Oct 31, 2017 · Databases

Mastering InnoDB: Table & Index Design Strategies for High‑Performance MySQL

This article explains InnoDB's record storage mechanics, compares auto‑increment and business primary keys, details primary, secondary, and composite index structures, and shares practical table‑design guidelines and real‑world case studies from ZhaiZhai's MySQL usage.

Composite IndexDatabase OptimizationInnoDB
0 likes · 12 min read
Mastering InnoDB: Table & Index Design Strategies for High‑Performance MySQL
ITPUB
ITPUB
Oct 9, 2017 · Databases

What’s New in PostgreSQL 10? Key Features and Improvements Explained

PostgreSQL 10, released after months of beta testing, brings logical replication, declarative table partitioning, higher query concurrency, notable performance gains, stronger SCRAM‑SHA‑256 authentication, and enhanced monitoring and control capabilities, marking a significant evolution for the open‑source database.

Logical ReplicationPostgreSQLTable Partitioning
0 likes · 3 min read
What’s New in PostgreSQL 10? Key Features and Improvements Explained
dbaplus Community
dbaplus Community
Jul 8, 2016 · Databases

Master MySQL Scheduled Events and Table Partitioning: A Step‑by‑Step Guide

This article explains how to enable MySQL scheduled events, shows the full CREATE EVENT syntax with practical timing examples, covers advanced operations like multi‑statement events and disabling, and then dives into table partitioning techniques (RANGE, HASH, KEY, LIST) with detailed commands and troubleshooting for large InnoDB tables.

Database OptimizationInnoDBScheduled Events
0 likes · 8 min read
Master MySQL Scheduled Events and Table Partitioning: A Step‑by‑Step Guide
MaGe Linux Operations
MaGe Linux Operations
May 30, 2016 · Databases

Why and How to Partition MySQL Tables: Sharding, Merge Engine, and Scaling Strategies

Learn why massive MySQL tables need partitioning and how techniques like table splitting, merge storage engine, vertical partitioning, and horizontal sharding—combined with master‑slave replication and proxies such as Amoeba—can reduce load, improve query speed, and enhance scalability.

Table PartitioningVertical Partitioninghorizontal partitioning
0 likes · 6 min read
Why and How to Partition MySQL Tables: Sharding, Merge Engine, and Scaling Strategies
21CTO
21CTO
May 15, 2016 · Databases

Master Table Partitioning in SQL Server: Boost Query Performance

This article presents practical database optimization techniques, including SQL Server table partitioning to handle massive datasets and using the XML data type to replace traditional master‑detail designs, offering clearer schemas and faster queries for large‑scale applications.

Database OptimizationSQL ServerTable Partitioning
0 likes · 9 min read
Master Table Partitioning in SQL Server: Boost Query Performance
MaGe Linux Operations
MaGe Linux Operations
Nov 23, 2015 · Databases

How to Partition Zabbix MySQL Tables for Faster Performance

This guide explains why Zabbix monitoring can become sluggish with large MySQL tables, and provides step‑by‑step instructions—including table modifications, stored procedures for creating, dropping, maintaining, and verifying partitions, plus automation scripts—to shrink the database and improve responsiveness.

Database OptimizationStored ProceduresTable Partitioning
0 likes · 10 min read
How to Partition Zabbix MySQL Tables for Faster Performance