MySQL is not configured with innodb_file_per_table = 1

[Richard Kiene]

In Fuel 4.0 MySQL should be configured to use innodb_file_per_table = 1: https://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_file_per_table

In only a few months time our Keystone database has grown to 30+ GB of tokens (which should probably be a separate bug, that a cron job isn't setup to deal with that).

If innodb_file_per_table was enabled I could simply delete expired tokens, backup the keystone database, drop or truncate the token table and I would free up nearly 30GB of wasted space.

Because innodb_file_per_table is disabled I have to delete expired tokens, take everything offline, backup all database in the cluster, delete ibdata1, ib_log, etc. and restore every schema from backup before bringing the server back online, just to free up wasted tokens.

Given that just a few months in a modest sized private install can result in 30GB of expired keystone tokens, file per table should be enabled so that it is easier to clear up unnecessarily used space.

[Vladimir Kuklin (vkuklin)]

Richard, please provide which version of FUEL this bug is related to. We fixed this issue a long time ago.

[Richard Kiene (richard-kiene)]

Vladimir, this is in Fuel 4.0.

[Richard Kiene (richard-kiene)]

Looks like it was fixed and tagged 4.1: https://github.com/stackforge/fuel-library/commit/b7504a2672cc73f4cc1430d9eedfeb4e7f5576d1#diff-4c6d4ccb3a0026527e42a87f5756f5a3R11