How do I install Matomo using TokuDB table engine in a MySQL or MariaDB database?

By default, Matomo creates tables in your MySQL database using the InnoDB table engine. Previously, some users managing high-traffic Matomo instances opted to use the TokuDB table engine for better performance.

Note: TokuDB has been deprecated by its upstream maintainer and is no longer supported in MariaDB. From MariaDB version 10.5 onwards, TokuDB is disabled, and removed in version 10.6. You can find more details about this on the MariaDB website.

If you are still using an older version of MariaDB that supports TokuDB and wish to proceed, you can follow these steps to configure Matomo with TokuDB:

• Upload the latest Matomo release to your server.
• Before you install Matomo, modify the config/global.ini.php file, and under [database] section change from type = InnoDB to type = TokuDB
• Install Matomo by going through the few steps. Matomo will create your tables with the TokuDB engine.
• After the installation is successful, edit on your server the config/config.ini.php file and below [database] add a new line: type = TokuDB.

Please note that due to TokuDB’s deprecation, this configuration may not be supported in future releases.