BestHub
Sign in
Tagged articles

Partitioning

216 articles · Page 3 of 3
Architecture Digest
Architecture Digest
Jan 9, 2017 · Databases

Comprehensive Guide to MySQL Single-Table Optimization, Partitioning, Sharding, and Scaling Strategies

This article outlines practical techniques for optimizing large MySQL tables—including column and index tuning, query improvements, engine selection, system parameters, hardware upgrades, caching, partitioning, vertical and horizontal sharding, and discusses client‑side and proxy‑based sharding solutions and compatible databases.

MySQLPartitioningSharding
0 likes · 24 min read
Comprehensive Guide to MySQL Single-Table Optimization, Partitioning, Sharding, and Scaling Strategies
dbaplus Community
dbaplus Community
Nov 3, 2016 · Databases

Taming a Million‑Row Log Table: Real‑World SQL Performance Optimization

A detailed case study describes how a rapidly growing edit‑log feature caused query times to soar to 30 seconds, and walks through the step‑by‑step investigation, identification of a custom function bottleneck, data‑volume analysis, and the eventual implementation of partitioning, mandatory time filters, and composite indexing to restore acceptable performance.

DatabaseIndexingPL/SQL
0 likes · 12 min read
Taming a Million‑Row Log Table: Real‑World SQL Performance Optimization
ITPUB
ITPUB
Sep 27, 2016 · Databases

Mastering Oracle Statistics Collection: When, How, and What to Gather

This guide explains how to verify and configure Oracle's automatic optimizer statistics collection, customize collection windows, tailor statistics for large and partitioned tables, detect stale statistics, and decide when to gather histograms, providing practical SQL and PL/SQL examples.

DBMS_STATSHistogramsOracle
0 likes · 10 min read
Mastering Oracle Statistics Collection: When, How, and What to Gather
Qunar Tech Salon
Qunar Tech Salon
Sep 7, 2016 · Databases

Principles and Practices of MySQL Database Sharding

The article explains when MySQL sharding is needed, outlines five practical principles for deciding to split databases or tables, provides real‑world examples, and shares operational tips for implementing horizontal partitioning to improve performance, availability, and manageability.

Database ScalingMySQLOperations
0 likes · 8 min read
Principles and Practices of MySQL Database Sharding
Architect
Architect
Jul 3, 2016 · Databases

Understanding Redis Cluster Partitioning Implementation

This article explains how Redis Cluster automatically distributes data across nodes, how clients locate the correct node using slot hashing and hash tags, and how resharding and slot migration are performed without downtime, providing a detailed overview of the partitioning mechanism.

ClusterKey hashingPartitioning
0 likes · 10 min read
Understanding Redis Cluster Partitioning Implementation
21CTO
21CTO
Jun 14, 2016 · Databases

Why Your SSRS Report Is Slowing Down: Real-World SQL Optimization Lessons

An in‑depth case study of a sluggish SSRS report for Siemens China's MES system reveals how missing indexes, full‑table scans on billion‑row tables, and misguided partitioning cripple performance, and demonstrates practical SQL refactoring, stored‑procedure redesign, and indexing strategies that cut query time from hours to seconds.

PartitioningSQLStored Procedures
0 likes · 10 min read
Why Your SSRS Report Is Slowing Down: Real-World SQL Optimization Lessons
Architect
Architect
Dec 13, 2015 · Databases

Redis Partitioning: How to Store Data Across Multiple Redis Instances

This article explains the concept, benefits, methods, and practical considerations of partitioning data across multiple Redis instances, covering range and hash partitioning, consistent hashing, implementation options, drawbacks, and recommended tools such as Redis Cluster and Twemproxy.

Database ScalingPartitioningRedis
0 likes · 11 min read
Redis Partitioning: How to Store Data Across Multiple Redis Instances
ITPUB
ITPUB
Nov 27, 2015 · Databases

How to Build an Effective Oracle Statistics Collection Strategy for High‑Volume Systems

This article outlines practical strategies for Oracle DBAs to design, automate, and fine‑tune statistics‑gathering processes in large, high‑concurrency environments, covering automatic options, handling skewed data, partitioned tables, bind variables, and ongoing optimization cycles.

DBMS_STATSDatabase AdministrationPartitioning
0 likes · 10 min read
How to Build an Effective Oracle Statistics Collection Strategy for High‑Volume Systems
Qunar Tech Salon
Qunar Tech Salon
Oct 30, 2015 · Databases

MySQL Partitioning Hash Changes, GTID Replication Bugs, Client Crash, and TokuDB Optimize Table Analysis

This article examines how differing key‑hash algorithms in MySQL 5.1 versus 5.5/5.6 cause data loss in partitioned tables, describes compatibility fixes with ALTER TABLE … ALGORITHM=1, analyzes a MySQL client crash caused by mis‑redirected dump output, explores GTID_PURGED replication issues and replicate‑do‑db filtering gaps, and evaluates the behavior of OPTIMIZE TABLE on TokuDB tables.

GTIDMySQLOptimizeTable
0 likes · 18 min read
MySQL Partitioning Hash Changes, GTID Replication Bugs, Client Crash, and TokuDB Optimize Table Analysis
21CTO
21CTO
Oct 20, 2015 · Databases

Deep Dive into MySQL Partitioning, GTID Bugs, and TokuDB Optimize Table Anomalies

This article examines why MySQL 5.5/5.6 fails to retrieve non‑null partitioned rows after a physical upgrade, how the ALTER TABLE … PARTITION BY KEY ALGORITHM=1 fix works, the cause of MySQL client crashes when dump output mixes warnings, GTID_PURGED replication bugs, replicate‑filter side effects, and the behavior of TokuDB’s OPTIMIZE TABLE.

GTIDMySQLOptimization
0 likes · 19 min read
Deep Dive into MySQL Partitioning, GTID Bugs, and TokuDB Optimize Table Anomalies
Qunar Tech Salon
Qunar Tech Salon
Apr 20, 2015 · Databases

Practical MySQL Scaling and Sharding Strategies at 58.com under Big Data Loads

This article presents 58.com’s experience with MySQL under massive data volumes, covering core concepts such as single‑instance, sharding, replication and grouping, common availability and read‑write challenges, detailed sharding implementations for user, post, friend and order tables, and post‑sharding business practices including IN queries, non‑partition key queries, and cross‑database pagination.

Cross‑Shard QueriesDatabase ScalingMySQL
0 likes · 10 min read
Practical MySQL Scaling and Sharding Strategies at 58.com under Big Data Loads