Comments - Does MariaDB Support Partitioning?
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
partitioning is suitable for certain use cases, such as deletes. Selects instead are not optimal especially with random key strategy or when several partitions are accessed.
Would it be possible to have selects scan partitions in parallel? Comparing this to current sequential approach I believe this could increase the overall performance when working with large data sets and latest MySQL versions.
Does this make any sense?
Regards, Juha Poutiainen