BestHub
search
Sign in
Tag

hash partition

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
May 11, 2022 · Databases

Using Hash Partitioning in MySQL: Scenarios, Queries, and Optimizations

This article explains MySQL hash partition tables, illustrating their suitable use cases such as equality queries on IDs or dates, demonstrating creation, data loading, and query plans, and comparing standard hash partitions with linear hash partitions to highlight performance and data distribution considerations.

Database OptimizationPerformanceSQL
0 likes · 13 min read
Using Hash Partitioning in MySQL: Scenarios, Queries, and Optimizations
macrozheng
macrozheng
May 11, 2022 · Databases

Mastering Database Sharding: When and How to Split Databases and Tables

This article explains the concepts of database and table sharding, why they are needed, various vertical and horizontal splitting strategies, range and hash partitioning methods, their advantages and drawbacks, timing considerations, common challenges such as transactions and distributed IDs, and introduces popular sharding middleware.

database shardingdistributed transactionshash partition
0 likes · 12 min read
Mastering Database Sharding: When and How to Split Databases and Tables