{"action":"created","issue":{"url":"https://api.github.com/repos/inverse-inc/packetfence/issues/283","labels_url":"https://api.github.com/repos/inverse-inc/packetfence/issues/283/labels{/name}","comments_url":"https://api.github.com/repos/inverse-inc/packetfence/issues/283/comments","events_url":"https://api.github.com/repos/inverse-inc/packetfence/issues/283/events","html_url":"https://github.com/inverse-inc/packetfence/pull/283","id":49014363,"number":283,"title":"Batch iplog and locationlog deletion","user":{"login":"jrouzierinverse","id":2727473,"avatar_url":"https://avatars.githubusercontent.com/u/2727473?v=3","gravatar_id":"","url":"https://api.github.com/users/jrouzierinverse","html_url":"https://github.com/jrouzierinverse","followers_url":"https://api.github.com/users/jrouzierinverse/followers","following_url":"https://api.github.com/users/jrouzierinverse/following{/other_user}","gists_url":"https://api.github.com/users/jrouzierinverse/gists{/gist_id}","starred_url":"https://api.github.com/users/jrouzierinverse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jrouzierinverse/subscriptions","organizations_url":"https://api.github.com/users/jrouzierinverse/orgs","repos_url":"https://api.github.com/users/jrouzierinverse/repos","events_url":"https://api.github.com/users/jrouzierinverse/events{/privacy}","received_events_url":"https://api.github.com/users/jrouzierinverse/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/inverse-inc/packetfence/labels/for+review","name":"for review","color":"fbca04"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2014-11-16T20:25:06Z","updated_at":"2015-01-12T15:55:53Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/inverse-inc/packetfence/pulls/283","html_url":"https://github.com/inverse-inc/packetfence/pull/283","diff_url":"https://github.com/inverse-inc/packetfence/pull/283.diff","patch_url":"https://github.com/inverse-inc/packetfence/pull/283.patch"},"body":"Description\r\n-----------\r\nBatch the amount of rows that get are deleted from the iplog and location log to reduce the table locks.\r\n\r\nImpacts\r\n-------\r\nThis reduces the time spent deleting records in pfmon.\r\nHowever this could lead to have more stale records.\r\n\r\nAn additional cronjob at night could also be used to cleanup tables.\r\nThere are two new scripts\r\n\r\naddons/iplog-cleanup.pl\r\naddons/locationlog-cleanup.pl\r\n\r\nThe options are the same for both\r\n\r\n    iplog-cleanup.pl [--expire SECONDS] [--batch BATCH] [--timeout SECONDS]\r\n\r\n     Options:\r\n      --expire   The expire time of the iplog in seconds     - default expire.iplog\r\n      --batch    The number of iplog entries to batch delete - default maintenance.iplog_cleanup_batch\r\n      --timeout  How long this job is allowed to run         - default maintenance.iplog_cleanup_timeout\r\n      --help     Shows this help\r\n\r\nThis will run the job for an hour instead 10 seconds\r\naddons/iplog-cleanup.pl --timeout 3600\r\n\r\nDelete branch after merge\r\n-------------------------\r\nNO"},"comment":{"url":"https://api.github.com/repos/inverse-inc/packetfence/issues/comments/69591419","html_url":"https://github.com/inverse-inc/packetfence/pull/283#issuecomment-69591419","issue_url":"https://api.github.com/repos/inverse-inc/packetfence/issues/283","id":69591419,"user":{"login":"fdurand","id":1553962,"avatar_url":"https://avatars.githubusercontent.com/u/1553962?v=3","gravatar_id":"","url":"https://api.github.com/users/fdurand","html_url":"https://github.com/fdurand","followers_url":"https://api.github.com/users/fdurand/followers","following_url":"https://api.github.com/users/fdurand/following{/other_user}","gists_url":"https://api.github.com/users/fdurand/gists{/gist_id}","starred_url":"https://api.github.com/users/fdurand/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fdurand/subscriptions","organizations_url":"https://api.github.com/users/fdurand/orgs","repos_url":"https://api.github.com/users/fdurand/repos","events_url":"https://api.github.com/users/fdurand/events{/privacy}","received_events_url":"https://api.github.com/users/fdurand/received_events","type":"User","site_admin":false},"created_at":"2015-01-12T15:55:53Z","updated_at":"2015-01-12T15:55:53Z","body":"It miss maintenance.iplog_cleanup_timeout ... in po file (for the admin gui).\r\nIt miss sql in pf-schema-4.6.0.sql file."}}