What is a common mistake with database partitioning in System Design?

Choosing a poor partition key can concentrate traffic and make joins or rebalancing expensive. In practice, the value of this concept comes from understanding where it belongs in the architecture, what problem it solves, and what constraints or tradeoffs it introduces.