{"action":"created","issue":{"url":"https://api.github.com/repos/piwik/piwik/issues/7181","labels_url":"https://api.github.com/repos/piwik/piwik/issues/7181/labels{/name}","comments_url":"https://api.github.com/repos/piwik/piwik/issues/7181/comments","events_url":"https://api.github.com/repos/piwik/piwik/issues/7181/events","html_url":"https://github.com/piwik/piwik/issues/7181","id":57333919,"number":7181,"title":"Report archives have tripled in size since update to 2.10","user":{"login":"skyhawk669","id":2762147,"avatar_url":"https://avatars.githubusercontent.com/u/2762147?v=3","gravatar_id":"","url":"https://api.github.com/users/skyhawk669","html_url":"https://github.com/skyhawk669","followers_url":"https://api.github.com/users/skyhawk669/followers","following_url":"https://api.github.com/users/skyhawk669/following{/other_user}","gists_url":"https://api.github.com/users/skyhawk669/gists{/gist_id}","starred_url":"https://api.github.com/users/skyhawk669/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/skyhawk669/subscriptions","organizations_url":"https://api.github.com/users/skyhawk669/orgs","repos_url":"https://api.github.com/users/skyhawk669/repos","events_url":"https://api.github.com/users/skyhawk669/events{/privacy}","received_events_url":"https://api.github.com/users/skyhawk669/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/piwik/piwik/labels/Bug","name":"Bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"diosmosis","id":125140,"avatar_url":"https://avatars.githubusercontent.com/u/125140?v=3","gravatar_id":"","url":"https://api.github.com/users/diosmosis","html_url":"https://github.com/diosmosis","followers_url":"https://api.github.com/users/diosmosis/followers","following_url":"https://api.github.com/users/diosmosis/following{/other_user}","gists_url":"https://api.github.com/users/diosmosis/gists{/gist_id}","starred_url":"https://api.github.com/users/diosmosis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/diosmosis/subscriptions","organizations_url":"https://api.github.com/users/diosmosis/orgs","repos_url":"https://api.github.com/users/diosmosis/repos","events_url":"https://api.github.com/users/diosmosis/events{/privacy}","received_events_url":"https://api.github.com/users/diosmosis/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/piwik/piwik/milestones/73","html_url":"https://github.com/piwik/piwik/milestones/Piwik%202.12.0","labels_url":"https://api.github.com/repos/piwik/piwik/milestones/73/labels","id":852680,"number":73,"title":"Piwik 2.12.0","description":"This release ideally should not include DB schema upgrades.\r\n","creator":{"login":"mattab","id":466765,"avatar_url":"https://avatars.githubusercontent.com/u/466765?v=3","gravatar_id":"","url":"https://api.github.com/users/mattab","html_url":"https://github.com/mattab","followers_url":"https://api.github.com/users/mattab/followers","following_url":"https://api.github.com/users/mattab/following{/other_user}","gists_url":"https://api.github.com/users/mattab/gists{/gist_id}","starred_url":"https://api.github.com/users/mattab/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mattab/subscriptions","organizations_url":"https://api.github.com/users/mattab/orgs","repos_url":"https://api.github.com/users/mattab/repos","events_url":"https://api.github.com/users/mattab/events{/privacy}","received_events_url":"https://api.github.com/users/mattab/received_events","type":"User","site_admin":false},"open_issues":21,"closed_issues":28,"state":"open","created_at":"2014-11-04T11:19:45Z","updated_at":"2015-03-14T18:35:23Z","due_on":"2015-03-18T11:00:00Z","closed_at":null},"comments":32,"created_at":"2015-02-11T15:52:00Z","updated_at":"2015-03-15T19:04:52Z","closed_at":null,"body":"Since upgrading to 2.10 the archive blobs and archive numbers tables have tripled in size (blob tables usually between 30-40MB, now they are 140-500MB).\r\n\r\nThe archiving process is set  in cron to run every hour and nothing else has changed in the system beyond upgrading from 2.9 to 2.10 (no drastic change in amount of visitors, or to the structure of the site).\r\n\r\nThe tables are reduced in size a bit by running core:run-scheduled-tasks --force, but they're still quite a bit bigger than they used to be.\r\n\r\nMore background info in the following thread: http://forum.piwik.org/read.php?2,123852\r\n\r\nRunning Piwik on:\r\nRed Hat 5\r\napache 2.4\r\nPHP 5.4.35\r\nMySQL 5.0.45"},"comment":{"url":"https://api.github.com/repos/piwik/piwik/issues/comments/81201117","html_url":"https://github.com/piwik/piwik/issues/7181#issuecomment-81201117","issue_url":"https://api.github.com/repos/piwik/piwik/issues/7181","id":81201117,"user":{"login":"GreenReaper","id":383043,"avatar_url":"https://avatars.githubusercontent.com/u/383043?v=3","gravatar_id":"","url":"https://api.github.com/users/GreenReaper","html_url":"https://github.com/GreenReaper","followers_url":"https://api.github.com/users/GreenReaper/followers","following_url":"https://api.github.com/users/GreenReaper/following{/other_user}","gists_url":"https://api.github.com/users/GreenReaper/gists{/gist_id}","starred_url":"https://api.github.com/users/GreenReaper/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GreenReaper/subscriptions","organizations_url":"https://api.github.com/users/GreenReaper/orgs","repos_url":"https://api.github.com/users/GreenReaper/repos","events_url":"https://api.github.com/users/GreenReaper/events{/privacy}","received_events_url":"https://api.github.com/users/GreenReaper/received_events","type":"User","site_admin":false},"created_at":"2015-03-15T19:04:52Z","updated_at":"2015-03-15T19:04:52Z","body":"I'm getting read spikes every two or three hours that weren't there before:\r\n![diskstats_iops-day](https://cloud.githubusercontent.com/assets/383043/6657493/1d588594-cb46-11e4-87da-d9bf5e618804.png)\r\n"}}