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 edit summary |
||
| Line 1: | Line 1: | ||
A partitioned table's contents are stored in different locations.<br> | A partitioned table's contents are stored in different locations (ex. different servers).<br> | ||
A '''partitioning key''' is passed to a function to determine which partition a row or column should belong to.<br> | A '''partitioning key''' is passed to a function to determine which partition a row or column should belong to.<br> | ||
Revision as of 01:28, 8 September 2022
A partitioned table's contents are stored in different locations (ex. different servers).
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
