Opened 4 years ago

Closed 4 years ago

#1427 closed Bug (fixed)

User settings configuration report table is not bounded

Reported by: matt Owned by: matt
Priority: major Milestone: Piwik 0.6.3
Component: Core Keywords:
Cc: Sensitive: no


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.

Change History (1)

comment:1 Changed 4 years ago by matt (mattab)

  • Resolution set to fixed
  • Status changed from new to closed

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

Note: See TracTickets for help on using tickets.