{"action":"created","issue":{"url":"https://api.github.com/repos/prometheus/mysqld_exporter/issues/133","repository_url":"https://api.github.com/repos/prometheus/mysqld_exporter","labels_url":"https://api.github.com/repos/prometheus/mysqld_exporter/issues/133/labels{/name}","comments_url":"https://api.github.com/repos/prometheus/mysqld_exporter/issues/133/comments","events_url":"https://api.github.com/repos/prometheus/mysqld_exporter/issues/133/events","html_url":"https://github.com/prometheus/mysqld_exporter/issues/133","id":158998394,"number":133,"title":"Protect MySQL Server from Overload - Limit number of Scrapes which can happen at the same time","user":{"login":"PeterZaitsev","id":3651746,"avatar_url":"https://avatars.githubusercontent.com/u/3651746?v=3","gravatar_id":"","url":"https://api.github.com/users/PeterZaitsev","html_url":"https://github.com/PeterZaitsev","followers_url":"https://api.github.com/users/PeterZaitsev/followers","following_url":"https://api.github.com/users/PeterZaitsev/following{/other_user}","gists_url":"https://api.github.com/users/PeterZaitsev/gists{/gist_id}","starred_url":"https://api.github.com/users/PeterZaitsev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PeterZaitsev/subscriptions","organizations_url":"https://api.github.com/users/PeterZaitsev/orgs","repos_url":"https://api.github.com/users/PeterZaitsev/repos","events_url":"https://api.github.com/users/PeterZaitsev/events{/privacy}","received_events_url":"https://api.github.com/users/PeterZaitsev/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2016-06-07T18:57:48Z","updated_at":"2016-06-08T13:40:30Z","closed_at":null,"body":"We have some cases when users have tens of thousands of tables, which means  the information_schema related scrapes  may take a long time,  causing folks to have 100+  information schema queries triggered by Prometheus to happen at the same time possibly driving server out of connections. \r\n\r\nSometimes it happens only when server is under duress  rather than all the time which makes it a bad idea to simply disable this data collection. \r\n\r\nIt would be great if I could configure what   exporter allows no more than N concurrent requests to handle in parallel,   so for example if there is more than 3 scrape requests are underway error is returned and data is unavailable rather than server being overloaded. "},"comment":{"url":"https://api.github.com/repos/prometheus/mysqld_exporter/issues/comments/224591804","html_url":"https://github.com/prometheus/mysqld_exporter/issues/133#issuecomment-224591804","issue_url":"https://api.github.com/repos/prometheus/mysqld_exporter/issues/133","id":224591804,"user":{"login":"SuperQ","id":1320667,"avatar_url":"https://avatars.githubusercontent.com/u/1320667?v=3","gravatar_id":"","url":"https://api.github.com/users/SuperQ","html_url":"https://github.com/SuperQ","followers_url":"https://api.github.com/users/SuperQ/followers","following_url":"https://api.github.com/users/SuperQ/following{/other_user}","gists_url":"https://api.github.com/users/SuperQ/gists{/gist_id}","starred_url":"https://api.github.com/users/SuperQ/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SuperQ/subscriptions","organizations_url":"https://api.github.com/users/SuperQ/orgs","repos_url":"https://api.github.com/users/SuperQ/repos","events_url":"https://api.github.com/users/SuperQ/events{/privacy}","received_events_url":"https://api.github.com/users/SuperQ/received_events","type":"User","site_admin":false},"created_at":"2016-06-08T13:40:30Z","updated_at":"2016-06-08T13:40:30Z","body":"@brian-brazil That's probably a better way.  I could add that as a recommended setting to the `GRANT` in the README.\r\n\r\nhttp://dev.mysql.com/doc/refman/5.6/en/user-resources.html"}}
{"actor":{"display_login":"SuperQ"}}