{"action":"created","issue":{"url":"https://api.github.com/repos/unee-t/bugzilla-customisation/issues/28","repository_url":"https://api.github.com/repos/unee-t/bugzilla-customisation","labels_url":"https://api.github.com/repos/unee-t/bugzilla-customisation/issues/28/labels{/name}","comments_url":"https://api.github.com/repos/unee-t/bugzilla-customisation/issues/28/comments","events_url":"https://api.github.com/repos/unee-t/bugzilla-customisation/issues/28/events","html_url":"https://github.com/unee-t/bugzilla-customisation/issues/28","id":280370594,"number":28,"title":"Application timeout issue due to slow DB queries","user":{"login":"kaihendry","id":765871,"avatar_url":"https://avatars3.githubusercontent.com/u/765871?v=4","gravatar_id":"","url":"https://api.github.com/users/kaihendry","html_url":"https://github.com/kaihendry","followers_url":"https://api.github.com/users/kaihendry/followers","following_url":"https://api.github.com/users/kaihendry/following{/other_user}","gists_url":"https://api.github.com/users/kaihendry/gists{/gist_id}","starred_url":"https://api.github.com/users/kaihendry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kaihendry/subscriptions","organizations_url":"https://api.github.com/users/kaihendry/orgs","repos_url":"https://api.github.com/users/kaihendry/repos","events_url":"https://api.github.com/users/kaihendry/events{/privacy}","received_events_url":"https://api.github.com/users/kaihendry/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2017-12-08T04:52:26Z","updated_at":"2017-12-08T05:34:32Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"BG: https://unee-t.slack.com/messages/C871N3LFP/convo/C871N3LFP-1512708819.000007/ & https://s.natalian.org/2017-12-08/504.png\r\n\r\n    mysqldump -h db.dev.unee-t.com -P 3306 -u root --password=$(aws --profile lmb-dev ssm get-parameters --names MYSQL_ROOT_PASSWORD --with-decryption --query Parameters[0].Value --output text) --ignore-table=bugzilla.attach_data bugzilla  > dev.sql\r\n\r\nis ~330M. Full DB with attachments is 17GB: https://github.com/unee-t/bugzilla-customisation/issues/21#issuecomment-350169675\r\n\r\nCurrently RDS configurations between dev and prod are different."},"comment":{"url":"https://api.github.com/repos/unee-t/bugzilla-customisation/issues/comments/350177096","html_url":"https://github.com/unee-t/bugzilla-customisation/issues/28#issuecomment-350177096","issue_url":"https://api.github.com/repos/unee-t/bugzilla-customisation/issues/28","id":350177096,"user":{"login":"kaihendry","id":765871,"avatar_url":"https://avatars3.githubusercontent.com/u/765871?v=4","gravatar_id":"","url":"https://api.github.com/users/kaihendry","html_url":"https://github.com/kaihendry","followers_url":"https://api.github.com/users/kaihendry/followers","following_url":"https://api.github.com/users/kaihendry/following{/other_user}","gists_url":"https://api.github.com/users/kaihendry/gists{/gist_id}","starred_url":"https://api.github.com/users/kaihendry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kaihendry/subscriptions","organizations_url":"https://api.github.com/users/kaihendry/orgs","repos_url":"https://api.github.com/users/kaihendry/repos","events_url":"https://api.github.com/users/kaihendry/events{/privacy}","received_events_url":"https://api.github.com/users/kaihendry/received_events","type":"User","site_admin":false},"created_at":"2017-12-08T05:34:32Z","updated_at":"2017-12-08T05:34:32Z","author_association":"CONTRIBUTOR","body":"https://www.youtube.com/watch?v=BiScul_hGNg&feature=youtu.be video about enabling slow log on a RDS."}}
{"actor":{"display_login":"kaihendry"}}