{"action":"created","issue":{"url":"https://api.github.com/repos/padams/Open-Web-Analytics/issues/215","repository_url":"https://api.github.com/repos/padams/Open-Web-Analytics","labels_url":"https://api.github.com/repos/padams/Open-Web-Analytics/issues/215/labels{/name}","comments_url":"https://api.github.com/repos/padams/Open-Web-Analytics/issues/215/comments","events_url":"https://api.github.com/repos/padams/Open-Web-Analytics/issues/215/events","html_url":"https://github.com/padams/Open-Web-Analytics/issues/215","id":196253254,"number":215,"title":"Another super big table","user":{"login":"josephernest","id":6168083,"avatar_url":"https://avatars.githubusercontent.com/u/6168083?v=3","gravatar_id":"","url":"https://api.github.com/users/josephernest","html_url":"https://github.com/josephernest","followers_url":"https://api.github.com/users/josephernest/followers","following_url":"https://api.github.com/users/josephernest/following{/other_user}","gists_url":"https://api.github.com/users/josephernest/gists{/gist_id}","starred_url":"https://api.github.com/users/josephernest/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/josephernest/subscriptions","organizations_url":"https://api.github.com/users/josephernest/orgs","repos_url":"https://api.github.com/users/josephernest/repos","events_url":"https://api.github.com/users/josephernest/events{/privacy}","received_events_url":"https://api.github.com/users/josephernest/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-12-18T01:53:06Z","updated_at":"2016-12-18T01:56:42Z","closed_at":null,"body":"In my database, I see:\r\n\r\n```\r\n| owaa               | owa_queue_item                               |     747.92                                                                                         |\r\n+--------------------+----------------------------------------------+-----------   \r\n```\r\nWhat is this table that produces 747 MB of data in just a few weeks? This surely isn't normal, how can we disable this?\r\n(as a comparison, other analytics tools that I tried used 1% of this per year). \r\n\r\n*PS: I had a similar problem recently, and that time it was because of log domstream, that I disabled now, following your advice @padams.*"},"comment":{"url":"https://api.github.com/repos/padams/Open-Web-Analytics/issues/comments/267798535","html_url":"https://github.com/padams/Open-Web-Analytics/issues/215#issuecomment-267798535","issue_url":"https://api.github.com/repos/padams/Open-Web-Analytics/issues/215","id":267798535,"user":{"login":"padams","id":249756,"avatar_url":"https://avatars.githubusercontent.com/u/249756?v=3","gravatar_id":"","url":"https://api.github.com/users/padams","html_url":"https://github.com/padams","followers_url":"https://api.github.com/users/padams/followers","following_url":"https://api.github.com/users/padams/following{/other_user}","gists_url":"https://api.github.com/users/padams/gists{/gist_id}","starred_url":"https://api.github.com/users/padams/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/padams/subscriptions","organizations_url":"https://api.github.com/users/padams/orgs","repos_url":"https://api.github.com/users/padams/repos","events_url":"https://api.github.com/users/padams/events{/privacy}","received_events_url":"https://api.github.com/users/padams/received_events","type":"User","site_admin":false},"created_at":"2016-12-18T01:56:42Z","updated_at":"2016-12-18T01:56:42Z","body":"Queue items are added when OWA can't find a valid session to match page views to. The idea is that the queue can be processed later in case the data is coming from another server which is delayed in relaying its logs.\r\n\r\nWhy that is happening to you isn't clear without seeing your logs. Turn on error logging and see what OWA is saying is the reason for logging a queue items. Could be a robot..."}}
{"actor":{"display_login":"padams"}}