{"action":"created","issue":{"url":"https://api.github.com/repos/prometheus/mysqld_exporter/issues/27","labels_url":"https://api.github.com/repos/prometheus/mysqld_exporter/issues/27/labels{/name}","comments_url":"https://api.github.com/repos/prometheus/mysqld_exporter/issues/27/comments","events_url":"https://api.github.com/repos/prometheus/mysqld_exporter/issues/27/events","html_url":"https://github.com/prometheus/mysqld_exporter/issues/27","id":105191107,"number":27,"title":"Support TRUNCATE TABLE for performance_schema tables","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},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":9,"created_at":"2015-09-07T10:27:00Z","updated_at":"2015-09-08T12:03:58Z","closed_at":"2015-09-08T12:03:58Z","body":"For `performance_schema.events_statements_summary_by_digest`, we limit the number of metrics we extract by using `ORDER BY SUM_TIMER_WAIT DESC LIMIT ?`.  This can cause some queries that were active at one time in the past to stay at the top of the list.\r\n\r\nWe should provide a feature to `TRUNCATE TABLE` on a periodic basis to keep the list up to date with current use patterns."},"comment":{"url":"https://api.github.com/repos/prometheus/mysqld_exporter/issues/comments/138532907","html_url":"https://github.com/prometheus/mysqld_exporter/issues/27#issuecomment-138532907","issue_url":"https://api.github.com/repos/prometheus/mysqld_exporter/issues/27","id":138532907,"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":"2015-09-08T12:03:58Z","updated_at":"2015-09-08T12:03:58Z","body":"Merged #28, Should be good enough."}}