{"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":null,"milestone":{"url":"https://api.github.com/repos/piwik/piwik/milestones/76","html_url":"https://github.com/piwik/piwik/milestones/Piwik%202.13.0","labels_url":"https://api.github.com/repos/piwik/piwik/milestones/76/labels","id":969583,"number":76,"title":"Piwik 2.13.0","description":"Pool of tickets we pick issues to work on. This release may 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":34,"closed_issues":28,"state":"open","created_at":"2015-02-07T01:34:22Z","updated_at":"2015-03-31T05:56:57Z","due_on":"2015-04-14T12:00:00Z","closed_at":null},"comments":63,"created_at":"2015-02-11T15:52:00Z","updated_at":"2015-03-31T13:32:19Z","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/88086213","html_url":"https://github.com/piwik/piwik/issues/7181#issuecomment-88086213","issue_url":"https://api.github.com/repos/piwik/piwik/issues/7181","id":88086213,"user":{"login":"ThaDafinser","id":533017,"avatar_url":"https://avatars.githubusercontent.com/u/533017?v=3","gravatar_id":"","url":"https://api.github.com/users/ThaDafinser","html_url":"https://github.com/ThaDafinser","followers_url":"https://api.github.com/users/ThaDafinser/followers","following_url":"https://api.github.com/users/ThaDafinser/following{/other_user}","gists_url":"https://api.github.com/users/ThaDafinser/gists{/gist_id}","starred_url":"https://api.github.com/users/ThaDafinser/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ThaDafinser/subscriptions","organizations_url":"https://api.github.com/users/ThaDafinser/orgs","repos_url":"https://api.github.com/users/ThaDafinser/repos","events_url":"https://api.github.com/users/ThaDafinser/events{/privacy}","received_events_url":"https://api.github.com/users/ThaDafinser/received_events","type":"User","site_admin":false},"created_at":"2015-03-31T13:32:19Z","updated_at":"2015-03-31T13:32:19Z","body":"@diosmosis what are \"high\" numbers for 2/3/4?\r\n\r\ne.g on my piwik for `piwik_archive_numeric_2015_03` i see this:\r\n- 1.558.413 total rows\r\n- 125.900 with value = 4\r\n- 150.735 with value 3\r\n- 1 with value 2"}}