{"action":"opened","issue":{"url":"https://api.github.com/repos/yandex/ClickHouse/issues/3871","repository_url":"https://api.github.com/repos/yandex/ClickHouse","labels_url":"https://api.github.com/repos/yandex/ClickHouse/issues/3871/labels{/name}","comments_url":"https://api.github.com/repos/yandex/ClickHouse/issues/3871/comments","events_url":"https://api.github.com/repos/yandex/ClickHouse/issues/3871/events","html_url":"https://github.com/yandex/ClickHouse/issues/3871","id":392513384,"node_id":"MDU6SXNzdWUzOTI1MTMzODQ=","number":3871,"title":"Clickhouse lags at each query","user":{"login":"DChistyakov","id":996241,"node_id":"MDQ6VXNlcjk5NjI0MQ==","avatar_url":"https://avatars2.githubusercontent.com/u/996241?v=4","gravatar_id":"","url":"https://api.github.com/users/DChistyakov","html_url":"https://github.com/DChistyakov","followers_url":"https://api.github.com/users/DChistyakov/followers","following_url":"https://api.github.com/users/DChistyakov/following{/other_user}","gists_url":"https://api.github.com/users/DChistyakov/gists{/gist_id}","starred_url":"https://api.github.com/users/DChistyakov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DChistyakov/subscriptions","organizations_url":"https://api.github.com/users/DChistyakov/orgs","repos_url":"https://api.github.com/users/DChistyakov/repos","events_url":"https://api.github.com/users/DChistyakov/events{/privacy}","received_events_url":"https://api.github.com/users/DChistyakov/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-12-19T09:35:03Z","updated_at":"2018-12-19T09:35:03Z","closed_at":null,"author_association":"NONE","body":"Hi everyone!\r\nWell, I have 2 servers located in the same place with about 1-2ms ping between each other: A and B. Clickhouse server with basic configuration is located on the A serever. \r\nI do 2 same queries: \"SHOW databases\". \r\n1. clickhouse-cli @ A server to localhost \r\n2. clickhouse-cli @ B server to A server:9000\r\n\r\nServer A: 0.002 sec. \r\nServer B: 0.19 sec.\r\n\r\nNext \"SELECT * FROM table\": \r\n1. clickouse-cli @ A server to localhost - 8 rows in set. Elapsed: 0.003 sec. \r\n2. clickouse-cli @ B server to A server:9000 - 8 rows in set. Elapsed: 0.15 sec.\r\n\r\nAnd so on.. The same result I have while try to execute query at A server from my PC (about 0.19 sec). So each query executed from remote source has at least 0.1 sec. \r\nIt looks like latency but too much.. anyway I suppose that the latency shoud not affect the executuion time. So the question is: what do I do wrong? \r\nThanks in advance!"}}
{"actor":{"display_login":"DChistyakov"}}