{"action":"created","issue":{"url":"https://api.github.com/repos/sysown/proxysql/issues/384","repository_url":"https://api.github.com/repos/sysown/proxysql","labels_url":"https://api.github.com/repos/sysown/proxysql/issues/384/labels{/name}","comments_url":"https://api.github.com/repos/sysown/proxysql/issues/384/comments","events_url":"https://api.github.com/repos/sysown/proxysql/issues/384/events","html_url":"https://github.com/sysown/proxysql/issues/384","id":106189252,"number":384,"title":"LOAD MYSQL USERS TO RUNTIME resets users' counters","user":{"login":"renecannao","id":3645227,"avatar_url":"https://avatars.githubusercontent.com/u/3645227?v=3","gravatar_id":"","url":"https://api.github.com/users/renecannao","html_url":"https://github.com/renecannao","followers_url":"https://api.github.com/users/renecannao/followers","following_url":"https://api.github.com/users/renecannao/following{/other_user}","gists_url":"https://api.github.com/users/renecannao/gists{/gist_id}","starred_url":"https://api.github.com/users/renecannao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renecannao/subscriptions","organizations_url":"https://api.github.com/users/renecannao/orgs","repos_url":"https://api.github.com/users/renecannao/repos","events_url":"https://api.github.com/users/renecannao/events{/privacy}","received_events_url":"https://api.github.com/users/renecannao/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sysown/proxysql/labels/ADMIN","name":"ADMIN","color":"e11d21"},{"url":"https://api.github.com/repos/sysown/proxysql/labels/AUTHENTICATION","name":"AUTHENTICATION","color":"eb6420"}],"state":"closed","locked":false,"assignee":{"login":"renecannao","id":3645227,"avatar_url":"https://avatars.githubusercontent.com/u/3645227?v=3","gravatar_id":"","url":"https://api.github.com/users/renecannao","html_url":"https://github.com/renecannao","followers_url":"https://api.github.com/users/renecannao/followers","following_url":"https://api.github.com/users/renecannao/following{/other_user}","gists_url":"https://api.github.com/users/renecannao/gists{/gist_id}","starred_url":"https://api.github.com/users/renecannao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renecannao/subscriptions","organizations_url":"https://api.github.com/users/renecannao/orgs","repos_url":"https://api.github.com/users/renecannao/repos","events_url":"https://api.github.com/users/renecannao/events{/privacy}","received_events_url":"https://api.github.com/users/renecannao/received_events","type":"User","site_admin":false},"assignees":[{"login":"renecannao","id":3645227,"avatar_url":"https://avatars.githubusercontent.com/u/3645227?v=3","gravatar_id":"","url":"https://api.github.com/users/renecannao","html_url":"https://github.com/renecannao","followers_url":"https://api.github.com/users/renecannao/followers","following_url":"https://api.github.com/users/renecannao/following{/other_user}","gists_url":"https://api.github.com/users/renecannao/gists{/gist_id}","starred_url":"https://api.github.com/users/renecannao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renecannao/subscriptions","organizations_url":"https://api.github.com/users/renecannao/orgs","repos_url":"https://api.github.com/users/renecannao/repos","events_url":"https://api.github.com/users/renecannao/events{/privacy}","received_events_url":"https://api.github.com/users/renecannao/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/sysown/proxysql/milestones/3","html_url":"https://github.com/sysown/proxysql/milestones/Iovita","labels_url":"https://api.github.com/repos/sysown/proxysql/milestones/3/labels","id":1264112,"number":3,"title":"Iovita","description":"","creator":{"login":"renecannao","id":3645227,"avatar_url":"https://avatars.githubusercontent.com/u/3645227?v=3","gravatar_id":"","url":"https://api.github.com/users/renecannao","html_url":"https://github.com/renecannao","followers_url":"https://api.github.com/users/renecannao/followers","following_url":"https://api.github.com/users/renecannao/following{/other_user}","gists_url":"https://api.github.com/users/renecannao/gists{/gist_id}","starred_url":"https://api.github.com/users/renecannao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renecannao/subscriptions","organizations_url":"https://api.github.com/users/renecannao/orgs","repos_url":"https://api.github.com/users/renecannao/repos","events_url":"https://api.github.com/users/renecannao/events{/privacy}","received_events_url":"https://api.github.com/users/renecannao/received_events","type":"User","site_admin":false},"open_issues":16,"closed_issues":42,"state":"open","created_at":"2015-08-20T09:12:21Z","updated_at":"2016-07-22T16:42:25Z","due_on":"2015-12-31T08:00:00Z","closed_at":null},"comments":1,"created_at":"2015-09-12T22:55:00Z","updated_at":"2016-07-22T16:42:25Z","closed_at":"2016-07-22T16:42:24Z","body":"This is a known bug for now, but needs to be addressed.\r\n\r\n## WHY\r\nWhen LOAD MYSQL USERS TO RUNTIME is executed, num_connections_used is reset to 0.\r\nThat means that the real max number of connections is max_connections + current connections\r\n\r\n## WHAT\r\n* [ ] ProxySQL_Admin::__refresh_users() should be less disruptive, and instead of dropping old users should make a backup to then merge and finally drop\r\n*  [ ] ProxySQL_Admin::__refresh_users() should acquire a global lock on MySQL_Authentication so that LOAD MYSQL USERS TO RUNTIME becomes an atomic operation , as right now it is not. A new connection may be refused while LOAD MYSQL USERS TO RUNTIME is running"},"comment":{"url":"https://api.github.com/repos/sysown/proxysql/issues/comments/234594045","html_url":"https://github.com/sysown/proxysql/issues/384#issuecomment-234594045","issue_url":"https://api.github.com/repos/sysown/proxysql/issues/384","id":234594045,"user":{"login":"renecannao","id":3645227,"avatar_url":"https://avatars.githubusercontent.com/u/3645227?v=3","gravatar_id":"","url":"https://api.github.com/users/renecannao","html_url":"https://github.com/renecannao","followers_url":"https://api.github.com/users/renecannao/followers","following_url":"https://api.github.com/users/renecannao/following{/other_user}","gists_url":"https://api.github.com/users/renecannao/gists{/gist_id}","starred_url":"https://api.github.com/users/renecannao/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/renecannao/subscriptions","organizations_url":"https://api.github.com/users/renecannao/orgs","repos_url":"https://api.github.com/users/renecannao/repos","events_url":"https://api.github.com/users/renecannao/events{/privacy}","received_events_url":"https://api.github.com/users/renecannao/received_events","type":"User","site_admin":false},"created_at":"2016-07-22T16:42:24Z","updated_at":"2016-07-22T16:42:24Z","body":"Done"}}
{"actor":{"display_login":"renecannao"}}