Mysql partitioning: Difference between revisions
From wikinotes
(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...") |
(No difference)
|
Revision as of 01:27, 8 September 2022
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