Move partitions of the same table on different servers.Some MariaDB storage engines allow more interesting uses for partitioning. Partitioning for specific storage engines In case we separate historical data from recent data, we will probably need to take regular backups of one partition, not the whole table.For example, we can have historical data on slower, larger disks (historical data are not supposed to be frequently read) and current data can be on faster disks, or SSD devices.
But if the target table is partitioned, queries that read a small number of partitions can be much faster. There can be several reasons to use this feature:
In MariaDB, a table can be split in smaller subsets.
