{"action":"opened","issue":{"url":"https://api.github.com/repos/mautic/mautic/issues/3110","repository_url":"https://api.github.com/repos/mautic/mautic","labels_url":"https://api.github.com/repos/mautic/mautic/issues/3110/labels{/name}","comments_url":"https://api.github.com/repos/mautic/mautic/issues/3110/comments","events_url":"https://api.github.com/repos/mautic/mautic/issues/3110/events","html_url":"https://github.com/mautic/mautic/issues/3110","id":195879408,"number":3110,"title":"Purge old entries","user":{"login":"ldrrp","id":985837,"avatar_url":"https://avatars.githubusercontent.com/u/985837?v=3","gravatar_id":"","url":"https://api.github.com/users/ldrrp","html_url":"https://github.com/ldrrp","followers_url":"https://api.github.com/users/ldrrp/followers","following_url":"https://api.github.com/users/ldrrp/following{/other_user}","gists_url":"https://api.github.com/users/ldrrp/gists{/gist_id}","starred_url":"https://api.github.com/users/ldrrp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ldrrp/subscriptions","organizations_url":"https://api.github.com/users/ldrrp/orgs","repos_url":"https://api.github.com/users/ldrrp/repos","events_url":"https://api.github.com/users/ldrrp/events{/privacy}","received_events_url":"https://api.github.com/users/ldrrp/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-12-15T18:27:30Z","updated_at":"2016-12-15T18:27:30Z","closed_at":null,"body":"| Q  | A\r\n| ---| ---\r\n| Bug report? | N\r\n| Feature request? | Y\r\n| Enhancement? | Y\r\n\r\n## Description:\r\npurge old entries from tables. I have over 5 tables that are over 1GB in size. I run a very large mautic instance for a large corporate company and the mautic interface has started to bog down alot. The following tables are super big\r\n\r\nemail_stats\r\npage_hits\r\naudit_log\r\nleads\r\nip_addresses\r\ncampaign_lead_event_log\r\n\r\n## If a bug:\r\n\r\n| Q   | A\r\n| --- | ---\r\n| Mautic version | 2.4.0\r\n| PHP version | 7.0.0\r\n\r\n## Attempts at fixing\r\nRan many optimizers on the mysql servers config files\r\nCache folder running under a tmpfs partition\r\nPHP Session running under tmpfs\r\nOptimized tables (many times)\r\nupgraded server memory to 64GB\r\nupgraded server cpu to new xeon processor"}}
{"actor":{"display_login":"ldrrp"}}