Feb 3, 2021 · Databases

Understanding MySQL Functional (Expression) Indexes

The article explains MySQL functional (expression) indexes, how they are implemented via generated columns, demonstrates their creation and performance benefits for datetime and JSON fields, compares them with prefix indexes, and offers guidance for older MySQL versions.

Functional IndexGenerated ColumnsJSON Index

0 likes · 12 min read

Understanding MySQL Functional (Expression) Indexes

Architecture Digest

Sep 28, 2020 · Databases

Database Bottlenecks and Sharding Strategies: IO, CPU, and Partitioning Solutions

This article analyzes common database performance bottlenecks such as I/O and CPU limits, explains horizontal and vertical sharding techniques, reviews available sharding tools, discusses the challenges of distributed transactions, cross‑node joins, pagination, and global primary‑key generation, and offers practical mitigation strategies.

Partitioningdistributed-systemsperformance

0 likes · 15 min read

Database Bottlenecks and Sharding Strategies: IO, CPU, and Partitioning Solutions