User settings configuration report table is not bounded #1427

Closed
mattab opened this Issue Jun 15, 2010 · 1 comment

1 participant

@mattab
Piwik Open Source Analytics member

The report stored with a name 'UserSettings_configuration' in the blob archive tables, is not truncated and can take up significant space in the DB.

It should be truncated after 500 rows.

@mattab
Piwik Open Source Analytics member

Fixed in [2305]

  • User settings reports are now bounded, set to 500 by default (same as Providers report)

I noticed the issue looking at monthly archives: where name='UserSettings_configuration', the blob was up to 31K in size, when the second most larger was the 'Page URLs' report Actions_actions_url at 20K

@mattab mattab added this to the Piwik 0.6.3 milestone Jul 8, 2014
@mattab mattab self-assigned this Jul 8, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment