BestHub
search
Sign in
Tag

stringhash

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 15, 2020 · Databases

Diagnosing Slow SQL Execution in DBLE Due to Incorrect Stringhash Partition Configuration

An investigation of a DBLE performance issue revealed that identical sharding keys with the same stringhash rule failed to improve query speed because differing hashSlice configurations prevented proper partitioning, and after correcting the rule.xml function settings, the SQL executed efficiently with sub‑second response times.

DBLEDatabase ConfigurationMySQL
0 likes · 4 min read
Diagnosing Slow SQL Execution in DBLE Due to Incorrect Stringhash Partition Configuration
Aikesheng Open Source Community
Aikesheng Open Source Community
Jun 5, 2019 · Databases

DBLE String‑Hash Sharding Algorithm and Configuration Guide

This article explains DBLE's string‑hash sharding algorithm, detailing how to configure partitionLength, partitionCount, and hashSlice in rule.xml, the conversion of string indexes to integers, comparison with MyCat, development and operational considerations, and provides example XML configurations and best‑practice tips.

ConfigurationDBLEDatabase
0 likes · 12 min read
DBLE String‑Hash Sharding Algorithm and Configuration Guide