Mysql partitioning

From wikinotes
Revision as of 01:27, 8 September 2022 by Will (talk | contribs) (Created page with "A partitioned table's contents are stored in different locations.<br> A '''partitioning key''' is passed to a function to determine which partition a row or column should belong to.<br> Partitions must share the same storage-engine = Partition Methods = <blockquote> <syntaxhighlight lang="yaml"> horizontal: rows are partitioned vertical: cols are partitioned </syntaxhighlight> </blockquote><!-- Partition Styles --> = Partitioning Strategies = <blockquote> </block...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

A partitioned table's contents are stored in different locations.
A partitioning key is passed to a function to determine which partition a row or column should belong to.

Partitions must share the same storage-engine

Partition Methods

horizontal:  rows are partitioned
vertical:    cols are partitioned

Partitioning Strategies

Retrieved from "http://willpittman.net:8080/index.php?title=Mysql_partitioning&oldid=31780"