By default Piwik creates tables in your Mysql database with InnoDB table engine. Sometimes if you manage a high traffic Piwik instance you may want to use Piwik with TokuDB table engine instead of InnoDB. Currently Piwik does not let the user select TokuDB during the installation process. However you can follow these simple steps to install Piwik with TokuDB:

  • Upload the latest Piwik release to your server
  • Before you install Piwik, modify the config/global.ini.php file, and under [database] section change from type = InnoDB to type = TokuDB
  • Install Piwik by going through the few steps. Piwik 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.
  • Enjoy your high performance Piwik Analytics service!

Any questions?

Many answers and more information about Piwik You can find here:

We are social

Follow us: