All versions of MariaDB support version partitioning. However, there are two cases where partitioning is not available for a MariaDB installation:
If MariaDB has been compiled without support to partitioning—while all official distributions have this support, partitioning is not compiled by default. If we compile the server from sources, we should specify the
-DWITH_PARTITION_STORAGE_ENGINE
compile option.If MariaDB has been started with the partitioning disabled—the option to do this is
--skip-partition
. In this case, we will simply need to restart MariaDB without this option. Disabling partitioning is generally not considered a useful optimization.
Checking whether the MariaDB installation supports partitioning is simple. Since partitioning is implemented as a plugin, we will just need to query the PLUGINS
table in the information_schema
database:
MariaDB [(none)]> SELECT * FROM information_schema.PLUGINS WHERE PLUGIN_NAME = 'partition'\G ********************...