How do I optimize an RTM database with innoDB?

The default database used with RTM is MyISAM. If you have a multicluster or high throughput environment, you may want to use an innoDB database instead, to optimize for bulk insertion.

About this task

RTM provides the tool convert_innodb.php to convert your RTM database to innoDB. You can find the tool under at RTM_TOP/cacti/cli (with a default RTM installation).

This tool does not convert all tables to innoDB. It converts tables with high volumes, which can resolve the performance pressure for the database.

Procedure

To convert the database, run the following command:

php convert_innodb.php

The convert also provide the -d or --debug option for a full output, and the -r or -- rebuild option for rebuilding index.