BestHub
search
Sign in
Tag

table partitioning

1 views collected around this technical thread.

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.

SQL Optimizationdatabase shardingdistributed transactions
0 likes · 13 min read
When and How to Implement Database Sharding and Partitioning for High‑Scale Systems
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.

DatabaseShardingSpringBoot
0 likes · 31 min read
Practical Guide to Monthly Horizontal Partitioning in MySQL Using Stored Procedures and SpringBoot
Tencent Cloud Developer
Tencent Cloud Developer
Sep 14, 2023 · Databases

Why a Single MySQL Table Should Not Exceed 20 Million Rows: Theory and Estimation

The article explains that, although MySQL’s theoretical limits are far higher, practical B+‑tree page and index calculations suggest keeping a single table under about twenty million one‑kilobyte rows to avoid performance degradation, illustrated with interview examples and estimation formulas.

B-TreeDatabasedata modeling
0 likes · 9 min read
Why a Single MySQL Table Should Not Exceed 20 Million Rows: Theory and Estimation
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 EngineSQLmysql
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.

database shardinghorizontal scalingmiddleware
0 likes · 14 min read
Why and How to Perform Database Sharding and Table Partitioning
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Apr 7, 2023 · Databases

MySQL Optimization Guide: Indexes, Slow Query Tuning, and Table Design

This article provides a comprehensive guide to MySQL performance optimization, covering CPU and I/O bottlenecks, index types and tuning, slow query capture and analysis, and best practices for table design and partitioning to improve query efficiency.

Database OptimizationIndexesSlow Queries
0 likes · 11 min read
MySQL Optimization Guide: Indexes, Slow Query Tuning, and Table Design
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 EngineSQLbackend
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-JDBCdatabase sharding
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 AdministrationPostgreSQL
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 IndexIndexing
0 likes · 10 min read
Understanding Data Indexes, B+Tree vs Hash Indexes, Table Partitioning, and MySQL Optimization Techniques