{"action":"created","issue":{"url":"https://api.github.com/repos/sysown/proxysql/issues/754","repository_url":"https://api.github.com/repos/sysown/proxysql","labels_url":"https://api.github.com/repos/sysown/proxysql/issues/754/labels{/name}","comments_url":"https://api.github.com/repos/sysown/proxysql/issues/754/comments","events_url":"https://api.github.com/repos/sysown/proxysql/issues/754/events","html_url":"https://github.com/sysown/proxysql/issues/754","id":184845966,"number":754,"title":"It seems that performance of v1.3.0-0 is a little lower than v1.2.4","user":{"login":"jkklee","id":11570771,"avatar_url":"https://avatars.githubusercontent.com/u/11570771?v=3","gravatar_id":"","url":"https://api.github.com/users/jkklee","html_url":"https://github.com/jkklee","followers_url":"https://api.github.com/users/jkklee/followers","following_url":"https://api.github.com/users/jkklee/following{/other_user}","gists_url":"https://api.github.com/users/jkklee/gists{/gist_id}","starred_url":"https://api.github.com/users/jkklee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jkklee/subscriptions","organizations_url":"https://api.github.com/users/jkklee/orgs","repos_url":"https://api.github.com/users/jkklee/repos","events_url":"https://api.github.com/users/jkklee/events{/privacy}","received_events_url":"https://api.github.com/users/jkklee/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sysown/proxysql/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","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/10","html_url":"https://github.com/sysown/proxysql/milestones/v1.3.1","labels_url":"https://api.github.com/repos/sysown/proxysql/milestones/10/labels","id":2081671,"number":10,"title":"v1.3.1","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":3,"closed_issues":3,"state":"open","created_at":"2016-10-20T06:45:08Z","updated_at":"2016-10-24T14:00:01Z","due_on":null,"closed_at":null},"comments":5,"created_at":"2016-10-24T13:49:41Z","updated_at":"2016-10-24T15:51:30Z","closed_at":null,"body":"I did some test between `mysql`(single server), `proxysql v1.2.4`(1write 2 read), `proxysql v1.3.0`(1write 2read).\r\n**test scenario:**\r\n```\r\nsysbench-0.5;\r\noltp  read-only;\r\n16 test tables with 5 hundred thousand rows in every table;\r\nevery test there is 280000 request in total;\r\n\r\na very simple mysql_query_rule that route read request to read HG;\r\nother setting as default;\r\n\r\nevery thread test more than 6 times and calculate the average;\r\n```\r\n**the test result graph see below**\r\n![95_pct_time](https://cloud.githubusercontent.com/assets/11570771/19648050/65acd22e-9a33-11e6-9fd7-7d020aabe5a8.png)\r\n![request_per_second](https://cloud.githubusercontent.com/assets/11570771/19648052/65b1282e-9a33-11e6-895f-c8552adf2212.png)\r\n![total_time](https://cloud.githubusercontent.com/assets/11570771/19648051/65ae575c-9a33-11e6-8a7b-a888ff3ecad8.png)\r\n"},"comment":{"url":"https://api.github.com/repos/sysown/proxysql/issues/comments/255781048","html_url":"https://github.com/sysown/proxysql/issues/754#issuecomment-255781048","issue_url":"https://api.github.com/repos/sysown/proxysql/issues/754","id":255781048,"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-10-24T15:51:30Z","updated_at":"2016-10-24T15:51:30Z","body":"@jkklee : a quick note while I start reproducing this test case: it seems that with the default oltp options , 35k requests per second saturates 1Gbps.\r\nI will also evaluate reducing the number of range scans and increase the point selects."}}
{"actor":{"display_login":"renecannao"}}