{"action":"created","issue":{"url":"https://api.github.com/repos/rundeck/rundeck/issues/1351","labels_url":"https://api.github.com/repos/rundeck/rundeck/issues/1351/labels{/name}","comments_url":"https://api.github.com/repos/rundeck/rundeck/issues/1351/comments","events_url":"https://api.github.com/repos/rundeck/rundeck/issues/1351/events","html_url":"https://github.com/rundeck/rundeck/issues/1351","id":96211181,"number":1351,"title":"Slow main page load","user":{"login":"rgazaryants","id":7463136,"avatar_url":"https://avatars.githubusercontent.com/u/7463136?v=3","gravatar_id":"","url":"https://api.github.com/users/rgazaryants","html_url":"https://github.com/rgazaryants","followers_url":"https://api.github.com/users/rgazaryants/followers","following_url":"https://api.github.com/users/rgazaryants/following{/other_user}","gists_url":"https://api.github.com/users/rgazaryants/gists{/gist_id}","starred_url":"https://api.github.com/users/rgazaryants/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rgazaryants/subscriptions","organizations_url":"https://api.github.com/users/rgazaryants/orgs","repos_url":"https://api.github.com/users/rgazaryants/repos","events_url":"https://api.github.com/users/rgazaryants/events{/privacy}","received_events_url":"https://api.github.com/users/rgazaryants/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-07-21T02:32:15Z","updated_at":"2015-07-21T05:30:45Z","closed_at":null,"body":"We have 500~ jobs\r\n18 projects\r\n9000~ daily executions\r\nMySQL back-end (no slow queries in log)\r\n\r\n/menu/home takes about 30-45 seconds to load. It has progressively gotten worse as we add jobs.\r\n"},"comment":{"url":"https://api.github.com/repos/rundeck/rundeck/issues/comments/123166738","html_url":"https://github.com/rundeck/rundeck/issues/1351#issuecomment-123166738","issue_url":"https://api.github.com/repos/rundeck/rundeck/issues/1351","id":123166738,"user":{"login":"mathieuchateau","id":4478521,"avatar_url":"https://avatars.githubusercontent.com/u/4478521?v=3","gravatar_id":"","url":"https://api.github.com/users/mathieuchateau","html_url":"https://github.com/mathieuchateau","followers_url":"https://api.github.com/users/mathieuchateau/followers","following_url":"https://api.github.com/users/mathieuchateau/following{/other_user}","gists_url":"https://api.github.com/users/mathieuchateau/gists{/gist_id}","starred_url":"https://api.github.com/users/mathieuchateau/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mathieuchateau/subscriptions","organizations_url":"https://api.github.com/users/mathieuchateau/orgs","repos_url":"https://api.github.com/users/mathieuchateau/repos","events_url":"https://api.github.com/users/mathieuchateau/events{/privacy}","received_events_url":"https://api.github.com/users/mathieuchateau/received_events","type":"User","site_admin":false},"created_at":"2015-07-21T05:30:45Z","updated_at":"2015-07-21T05:30:45Z","body":"Hello,\n\nIf no big/slow query, it may be there numbers (if sequential).\nCan you do a tcpdump on rundeck node (filtering to MySQL IP) ?\n\nSo we may see how long time it is doing SQL query out of the 30-45 total\nseconds.\n\nCordialement,\nMathieu CHATEAU\nhttp://www.lotp.fr\n\n2015-07-21 4:43 GMT+02:00 rgazaryants <notifications@github.com>:\n\n> That was my first guess too, but the longest query in the slow log is 2~\n> seconds.\n>\n> —\n> Reply to this email directly or view it on GitHub\n> <https://github.com/rundeck/rundeck/issues/1351#issuecomment-123132938>.\n>\n"}}