Guides 11791 Published by

Vitux published a tutorial about enabling large Indexes in MariaDB 10 on Debian 10.



How to enable Large Indexes in MariaDB 10 on Debian 10

This tutorial shows you how to enable large indexes in MariaDB 10 on Debian 10. This refers to the innodb_large_prefix option which exists in MariaDB and MySQL. I will show you how to enable the large index option permanently by editing the MariaDB configuration file and I will also show you how to enable it temporarily in the current database session by using SQL commands. InnoDB large prefix allows it to have index key prefixes up to 3072 bytes (for 16k pages, smaller otherwise).



How to enable Large Indexes in MariaDB 10 on Debian 10