{"action":"created","issue":{"url":"https://api.github.com/repos/Wikia/app/issues/9041","labels_url":"https://api.github.com/repos/Wikia/app/issues/9041/labels{/name}","comments_url":"https://api.github.com/repos/Wikia/app/issues/9041/comments","events_url":"https://api.github.com/repos/Wikia/app/issues/9041/events","html_url":"https://github.com/Wikia/app/pull/9041","id":117133461,"number":9041,"title":"Transactions more context for maintenance scripts","user":{"login":"macbre","id":1929317,"avatar_url":"https://avatars.githubusercontent.com/u/1929317?v=3","gravatar_id":"","url":"https://api.github.com/users/macbre","html_url":"https://github.com/macbre","followers_url":"https://api.github.com/users/macbre/followers","following_url":"https://api.github.com/users/macbre/following{/other_user}","gists_url":"https://api.github.com/users/macbre/gists{/gist_id}","starred_url":"https://api.github.com/users/macbre/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/macbre/subscriptions","organizations_url":"https://api.github.com/users/macbre/orgs","repos_url":"https://api.github.com/users/macbre/repos","events_url":"https://api.github.com/users/macbre/events{/privacy}","received_events_url":"https://api.github.com/users/macbre/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-16T14:17:58Z","updated_at":"2015-11-16T14:30:39Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/Wikia/app/pulls/9041","html_url":"https://github.com/Wikia/app/pull/9041","diff_url":"https://github.com/Wikia/app/pull/9041.diff","patch_url":"https://github.com/Wikia/app/pull/9041.patch"},"body":"When working on [PLATFORM-1648](https://wikia-inc.atlassian.net/browse/PLATFORM-1648) I've noticed that there's a huge difference between p50 and p95 of request times for maintenance scripts (they're obviously the slowest ones for 95th percentile):\r\n\r\n```\r\n> The slowest transactions (50 rows)\r\n-----------------------------------------------------------------------------------------------------------------------------\r\n 95th pct req t [ms]    Method                                                                                      Requests\r\n-----------------------------------------------------------------------------------------------------------------------------\r\n           31,181.74    maintenance                                                                                27,293.00\r\n\r\n\r\n> The slowest transactions (50 rows)\r\n-----------------------------------------------------------------------------------------------------------------------------\r\nMedian req time [ms]    Method                                                                                      Requests\r\n-----------------------------------------------------------------------------------------------------------------------------\r\n              ...\r\n              232.30    maintenance                                                                                27,293.00\r\n```\r\n\r\nReport maintenance script as a separate transactions in the form of `maintenance/<maintance script name>`.\r\n\r\n@wladekb / @jcellary "},"comment":{"url":"https://api.github.com/repos/Wikia/app/issues/comments/157048568","html_url":"https://github.com/Wikia/app/pull/9041#issuecomment-157048568","issue_url":"https://api.github.com/repos/Wikia/app/issues/9041","id":157048568,"user":{"login":"wladekb","id":811686,"avatar_url":"https://avatars.githubusercontent.com/u/811686?v=3","gravatar_id":"","url":"https://api.github.com/users/wladekb","html_url":"https://github.com/wladekb","followers_url":"https://api.github.com/users/wladekb/followers","following_url":"https://api.github.com/users/wladekb/following{/other_user}","gists_url":"https://api.github.com/users/wladekb/gists{/gist_id}","starred_url":"https://api.github.com/users/wladekb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wladekb/subscriptions","organizations_url":"https://api.github.com/users/wladekb/orgs","repos_url":"https://api.github.com/users/wladekb/repos","events_url":"https://api.github.com/users/wladekb/events{/privacy}","received_events_url":"https://api.github.com/users/wladekb/received_events","type":"User","site_admin":false},"created_at":"2015-11-16T14:30:39Z","updated_at":"2015-11-16T14:30:39Z","body":"lgtm, if `$maintClass` is always defined at that point"}}